diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-03 20:09:18 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-06-03 20:09:18 +0000 |
| commit | 7858865add8a825050d3eec0e18d078787ddea50 (patch) | |
| tree | ab666b19be7ca2fbde3133f8ac7c2d7559f5d85a /phpBB/profile.php | |
| parent | dfa753d56205c79c8c4ad9c82e24680a08ec1ca1 (diff) | |
| download | forums-7858865add8a825050d3eec0e18d078787ddea50.tar forums-7858865add8a825050d3eec0e18d078787ddea50.tar.gz forums-7858865add8a825050d3eec0e18d078787ddea50.tar.bz2 forums-7858865add8a825050d3eec0e18d078787ddea50.tar.xz forums-7858865add8a825050d3eec0e18d078787ddea50.zip | |
Fixed validate_username failure and matched groups field names
git-svn-id: file:///svn/phpbb/trunk@419 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/profile.php')
| -rw-r--r-- | phpBB/profile.php | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/phpBB/profile.php b/phpBB/profile.php index e39277aeed..48f9ca95d3 100644 --- a/phpBB/profile.php +++ b/phpBB/profile.php @@ -48,10 +48,10 @@ 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 + echo $sql_users = "SELECT username FROM ".USERS_TABLE." - WHERE LOWER(u.username) = '".strtolower($username)."'"; - $sql_disallow = "SELECT disallow_username + WHERE LOWER(username) = '".strtolower($username)."'"; + echo $sql_disallow = "SELECT disallow_username FROM ".DISALLOW_TABLE." WHERE disallow_username = '$username'"; @@ -888,7 +888,7 @@ if(isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode'])) if($result = $db->sql_query($sql)) { $sql = "INSERT INTO ".GROUPS_TABLE." - (group_name, group_note, single_user) + (group_name, group_description, group_single_user) VALUES ('$username', 'Personal User', 1)"; if($result = $db->sql_query($sql)) |