phpbb: Make the username case-insensitve on login again.

The username field in the phpbb3 database is case sensitive (i.e., it
has utf_bin collation), whereas in phpbb2 it was case insensitive. This
commit changes the SQL query to make logins case insensitive again,
since a lot of people used a capital letter for registering their
username, but forgot that later on...

diff --git a/auth.py b/auth.py
index 9d8566f9a4aa3889ee066cb939f7b429ae5fc7b2..23b48bba25b8e984d92cf413e68cdc68bd11fa17 100644 (file)
--- a/auth.py
+++ b/auth.py
@@ -62,7 +62,7 @@ class PhpBBBackend:
 
         # Get some data
         cursor = conn.cursor ()
-        cursor.execute ("SELECT user_password,user_email FROM %susers WHERE username=%%s" % prefix, username)
+        cursor.execute ("SELECT user_password,user_email FROM %susers WHERE LOWER(username)=LOWER(%%s)" % prefix, username)
 
         # No data? No login.
         if (cursor.rowcount == 0):