diff options
| author | Suhaib Khan <suhebjerk@gmail.com> | 2014-02-23 00:22:52 +0530 |
|---|---|---|
| committer | Cesar G <prototech91@gmail.com> | 2014-04-23 09:11:39 -0700 |
| commit | aa23cf64cae6710f556c8d43528d28cff6d6a775 (patch) | |
| tree | fe494d3588ff8f6945e410e8b0f81fd65040ea61 /phpBB/memberlist.php | |
| parent | e644c67dcf4a505759533c42e0c511fab93028ae (diff) | |
| download | forums-aa23cf64cae6710f556c8d43528d28cff6d6a775.tar forums-aa23cf64cae6710f556c8d43528d28cff6d6a775.tar.gz forums-aa23cf64cae6710f556c8d43528d28cff6d6a775.tar.bz2 forums-aa23cf64cae6710f556c8d43528d28cff6d6a775.tar.xz forums-aa23cf64cae6710f556c8d43528d28cff6d6a775.zip | |
[ticket/10737] Avoid hard-coding table row and use case-insensitive search.
PHPBB3-10737
Diffstat (limited to 'phpBB/memberlist.php')
| -rw-r--r-- | phpBB/memberlist.php | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php index 67e168e7bb..7cea4a59d7 100644 --- a/phpBB/memberlist.php +++ b/phpBB/memberlist.php @@ -983,11 +983,12 @@ switch ($mode) case 'livesearch': $username_chars = $request->variable('q', '', true); + $username_chars = strtolower($username_chars); $sql = 'SELECT username, user_id FROM ' . USERS_TABLE . ' WHERE ' . $db->sql_in_set('user_type', array(USER_NORMAL, USER_FOUNDER)) . ' - AND username ' . $db->sql_like_expression($username_chars . $db->any_char); + AND LOWER(username) ' . $db->sql_like_expression($username_chars . $db->any_char); $result = $db->sql_query_limit($sql, 10); $user_list = array(); |