Revision: 1831
          http://mrbs.svn.sourceforge.net/mrbs/?rev=1831&view=rev
Author:   cimorrison
Date:     2011-05-26 11:36:17 +0000 (Thu, 26 May 2011)

Log Message:
-----------
Fixed bug which meant that a user logging in with an upper case version of his 
name (eg "John" instead of "john" was denied access to some pages in MySQL when 
the collation of the username field is set to binary and PostgreSQL always)

Modified Paths:
--------------
    mrbs/trunk/web/auth_db.inc

Modified: mrbs/trunk/web/auth_db.inc
===================================================================
--- mrbs/trunk/web/auth_db.inc  2011-05-26 09:05:58 UTC (rev 1830)
+++ mrbs/trunk/web/auth_db.inc  2011-05-26 11:36:17 UTC (rev 1831)
@@ -69,7 +69,7 @@
     return 0;
   }
   
-  $result = sql_query1("SELECT level FROM $tbl_users WHERE name='" . 
addslashes($user) . "' LIMIT 1");
+  $result = sql_query1("SELECT level FROM $tbl_users WHERE name='" . 
strtolower(addslashes($user)) . "' LIMIT 1");
   if ($result == -1)
   {
     trigger_error(sql_error(), E_USER_WARNING);


This was sent by the SourceForge.net collaborative development platform, the 
world's largest Open Source development site.

------------------------------------------------------------------------------
vRanger cuts backup time in half-while increasing security.
With the market-leading solution for virtual backup and recovery, 
you get blazing-fast, flexible, and affordable data protection.
Download your free trial now. 
http://p.sf.net/sfu/quest-d2dcopy1
_______________________________________________
Mrbs-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/mrbs-commits

Reply via email to