From b7c608d594c4356facbf4fa2f898ad28b7d358ba Mon Sep 17 00:00:00 2001
From: naderman <naderman@89ea8834-ac86-4346-8a33-228a782c2dd0>
Date: Sun, 29 Oct 2006 14:59:19 +0000
Subject: [PATCH] - Handle upper/lower case in memberlist properly [Bug #5012]

git-svn-id: http://code.phpbb.com/svn/phpbb/trunk@6537 89ea8834-ac86-4346-8a33-228a782c2dd0
---
 phpBB/memberlist.php | 10 +++++-----
 1 file changed, 5 insertions(+), 5 deletions(-)

diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php
index 6e0a3bf17..f50e79ed2 100644
--- a/phpBB/memberlist.php
+++ b/phpBB/memberlist.php
@@ -935,14 +935,14 @@ switch ($mode)
 
 		if ($first_char == 'other')
 		{
-			for ($i = 65; $i < 91; $i++)
+			for ($i = 97; $i < 123; $i++)
 			{
-				$sql_where .= " AND u.username NOT LIKE '" . chr($i) . "%'";
+				$sql_where .= " AND u.username_clean NOT LIKE '" . chr($i) . "%'";
 			}
 		}
 		else if ($first_char)
 		{
-			$sql_where .= " AND u.username LIKE '" . $db->sql_escape(substr($first_char, 0, 1)) . "%'";
+			$sql_where .= " AND u.username_clean LIKE '" . $db->sql_escape(substr($first_char, 0, 1)) . "%'";
 		}
 
 		// Are we looking at a usergroup? If so, fetch additional info
@@ -1068,9 +1068,9 @@ switch ($mode)
 		}
 
 		$s_char_options = '<option value=""' . ((!$first_char) ? ' selected="selected"' : '') . '>&nbsp; &nbsp;</option>';
-		for ($i = 65; $i < 91; $i++)
+		for ($i = 97; $i < 123; $i++)
 		{
-			$s_char_options .= '<option value="' . chr($i) . '"' . (($first_char == chr($i)) ? ' selected="selected"' : '') . '>' . chr($i) . '</option>';
+			$s_char_options .= '<option value="' . chr($i) . '"' . (($first_char == chr($i)) ? ' selected="selected"' : '') . '>' . chr($i-32) . '</option>';
 		}
 		$s_char_options .= '<option value="other"' . (($first_char == 'other') ? ' selected="selected"' : '') . '>' . $user->lang['OTHER'] . '</option>';
 
-- 
2.11.4.GIT