From ff076caeee3ca29b1e4fb8c741e7525f30d921bf Mon Sep 17 00:00:00 2001 From: Michael Gapczynski Date: Tue, 28 Aug 2012 11:28:38 -0400 Subject: [PATCH] Check usernames in the database as case insensitive, they are still stored case sensitive. Bug fix for oc-422 and oc-1514 --- lib/user/database.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/user/database.php b/lib/user/database.php index a4cffe5d0c1..dc11614cc57 100644 --- a/lib/user/database.php +++ b/lib/user/database.php @@ -121,7 +121,7 @@ class OC_User_Database extends OC_User_Backend { * returns the user id or false */ public function checkPassword( $uid, $password ){ - $query = OC_DB::prepare( 'SELECT `uid`, `password` FROM `*PREFIX*users` WHERE `uid` = ?' ); + $query = OC_DB::prepare( 'SELECT `uid`, `password` FROM `*PREFIX*users` WHERE LOWER(`uid`) = LOWER(?)' ); $result = $query->execute( array( $uid)); $row=$result->fetchRow(); @@ -170,7 +170,7 @@ class OC_User_Database extends OC_User_Backend { * @return boolean */ public function userExists($uid){ - $query = OC_DB::prepare( 'SELECT * FROM `*PREFIX*users` WHERE `uid` = ?' ); + $query = OC_DB::prepare( 'SELECT * FROM `*PREFIX*users` WHERE LOWER(`uid`) = LOWER(?)' ); $result = $query->execute( array( $uid )); return $result->numRows() > 0; -- 2.39.5