diff options
| author | Meik Sievertsen <acydburn@phpbb.com> | 2005-12-30 16:52:29 +0000 |
|---|---|---|
| committer | Meik Sievertsen <acydburn@phpbb.com> | 2005-12-30 16:52:29 +0000 |
| commit | 3bf7635b3c1879d8322daaca1f3837bcc62ebfb7 (patch) | |
| tree | dcdd82230aea25c21800792e303213bfcb92252b /phpBB/memberlist.php | |
| parent | 0ef491f3b982046bcce43a3d40845005456198f2 (diff) | |
| download | forums-3bf7635b3c1879d8322daaca1f3837bcc62ebfb7.tar forums-3bf7635b3c1879d8322daaca1f3837bcc62ebfb7.tar.gz forums-3bf7635b3c1879d8322daaca1f3837bcc62ebfb7.tar.bz2 forums-3bf7635b3c1879d8322daaca1f3837bcc62ebfb7.tar.xz forums-3bf7635b3c1879d8322daaca1f3837bcc62ebfb7.zip | |
- fix query for obtaining usernames beginning with a character and additionally searching for other criterias (produced a join not very healthy to the database - not the correct where statement is used)
git-svn-id: file:///svn/phpbb/trunk@5407 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/memberlist.php')
| -rw-r--r-- | phpBB/memberlist.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index ffd53937e0..24d3c8fc49 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -830,7 +830,6 @@ switch ($mode) if ($first_char == 'other') { - $sql_where = ''; for ($i = 65; $i < 91; $i++) { $sql_where .= " AND u.username NOT LIKE '" . chr($i) . "%'"; @@ -838,9 +837,9 @@ switch ($mode) } else if ($first_char) { - $sql_where = " AND u.username LIKE '" . $db->sql_escape(substr($first_char, 0, 1)) . "%'"; + $sql_where .= " AND u.username LIKE '" . $db->sql_escape(substr($first_char, 0, 1)) . "%'"; } - + // Are we looking at a usergroup? If so, fetch additional info // and further restrict the user info query if ($mode == 'group') |