diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-12 16:37:52 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-12 16:37:52 +0000 |
| commit | 59b27564488edc899ec8b73c8af9f47b94ede46b (patch) | |
| tree | 85b070055d25b03dbc9058d96c71155bc51ff025 /phpBB/includes | |
| parent | c08decbf1a3ca5ac6584706d261b384c6a8826b4 (diff) | |
| download | forums-59b27564488edc899ec8b73c8af9f47b94ede46b.tar forums-59b27564488edc899ec8b73c8af9f47b94ede46b.tar.gz forums-59b27564488edc899ec8b73c8af9f47b94ede46b.tar.bz2 forums-59b27564488edc899ec8b73c8af9f47b94ede46b.tar.xz forums-59b27564488edc899ec8b73c8af9f47b94ede46b.zip | |
Switched validate_username check to groups table
git-svn-id: file:///svn/phpbb/trunk@481 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/includes')
| -rw-r--r-- | phpBB/includes/functions.php | 16 |
1 files changed, 8 insertions, 8 deletions
diff --git a/phpBB/includes/functions.php b/phpBB/includes/functions.php index bfff4b7461..72d48c1bf0 100644 --- a/phpBB/includes/functions.php +++ b/phpBB/includes/functions.php @@ -427,11 +427,11 @@ function validate_username($username) // a UNION clause which would be very nice here :( // So we have to use two queries case 'mysql': - $sql_users = "SELECT username - FROM ".USERS_TABLE." - WHERE LOWER(username) = '".strtolower($username)."'"; + $sql_users = "SELECT group_name AS username + FROM " . GROUPS_TABLE . " + WHERE LOWER(group_name) = '" . strtolower($username) . "'"; $sql_disallow = "SELECT disallow_username - FROM ".DISALLOW_TABLE." + FROM " . DISALLOW_TABLE . " WHERE disallow_username = '$username'"; if($result = $db->sql_query($sql_users)) @@ -452,12 +452,12 @@ function validate_username($username) default: $sql = "SELECT disallow_username - FROM ".DISALLOW_TABLE." + FROM " . DISALLOW_TABLE . " WHERE disallow_username = '$username' UNION - SELECT username - FROM ".USERS_TABLE." - WHERE LOWER(username) = '".strtolower($username)."'"; + SELECT group_name AS username + FROM " . GROUPS_TABLE . " + WHERE LOWER(group_name) = '" . strtolower($username) . "'"; if($result = $db->sql_query($sql)) { |