diff options
| author | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-14 15:10:05 +0000 |
|---|---|---|
| committer | Paul S. Owen <psotfx@users.sourceforge.net> | 2001-05-14 15:10:05 +0000 |
| commit | ffb911d1e1160986a34fc46065299a4b832b9eb8 (patch) | |
| tree | 1b1cd0bab33bdf63f6e588399bccef6a48d13d69 /phpBB/profile.php | |
| parent | 60c507756c4c11584128753e53d656ec4f2945fc (diff) | |
| download | forums-ffb911d1e1160986a34fc46065299a4b832b9eb8.tar forums-ffb911d1e1160986a34fc46065299a4b832b9eb8.tar.gz forums-ffb911d1e1160986a34fc46065299a4b832b9eb8.tar.bz2 forums-ffb911d1e1160986a34fc46065299a4b832b9eb8.tar.xz forums-ffb911d1e1160986a34fc46065299a4b832b9eb8.zip | |
Altered SQL slightly for Postgres
git-svn-id: file:///svn/phpbb/trunk@293 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 a226605078..ca1941b6af 100644 --- a/phpBB/profile.php +++ b/phpBB/profile.php @@ -42,9 +42,9 @@ function validate_username($username) global $db; - $sql = "SELECT LOWER(u.username), d.disallow_username + $sql = "SELECT u.username, d.disallow_username FROM ".USERS_TABLE." u, ".DISALLOW_TABLE." d - WHERE u.username = '".strtolower($username)."' + WHERE LOWER(u.username) = '".strtolower($username)."' OR d.disallow_username = '$username'"; if($result = $db->sql_query($sql)) { @@ -91,7 +91,7 @@ function template_select($default) { if($file == $default) { - $selected = " SELECTED"; + $selected = " selected"; } $template_select .= "<option value=\"$file\"$selected>$file</option>\n"; } @@ -527,7 +527,7 @@ switch($mode) $user_theme = ($HTTP_POST_VARS['theme']) ? $HTTP_POST_VARS['theme'] : $board_config['default_theme']; $user_lang = ($HTTP_POST_VARS['language']) ? $HTTP_POST_VARS['language'] : $board_config['default_lang']; - $user_timezone = (isset($HTTP_POST_VARS['timezone'])) ? $HTTP_POST_VARS['timezone'] : $board_config['default_timezone']; + $user_timezone = str_replace("+", "", (isset($HTTP_POST_VARS['timezone'])) ? $HTTP_POST_VARS['timezone'] : $board_config['default_timezone']); $user_template = ($HTTP_POST_VARS['template']) ? $HTTP_POST_VARS['template'] : $board_config['default_template']; $user_dateformat = ($HTTP_POST_VARS['dateformat']) ? trim($HTTP_POST_VARS['dateformat']) : $board_config['default_dateformat']; |