[ros-diffs] [dgoette] 417: fix more problems with case sensitive names

Author: dgoette
Date: Mon May 18 17:12:53 2009
New Revision: 417

URL: http://svn.reactos.org/svn/reactos?rev=417&view=rev
Log:
fix more problems with case sensitive names

Modified:
   
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntry…
   
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewUserT…

Modified:
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntry…
URL:
http://svn.reactos.org/svn/reactos/branches/danny-web/www/www.reactos.org/r…
==============================================================================
---
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntry…
[iso-8859-1] (original)
+++
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewEntry…
[iso-8859-1] Mon May 18 17:12:53 2009
@@ -568,7 +568,7 @@
           // user
           case 'u': 
             // get user_id
-            $stmt=&DBConnection::getInstance()->prepare("SELECT id FROM
".ROSCMST_USERS." WHERE name = :user_name LIMIT 1");
+            $stmt=&DBConnection::getInstance()->prepare("SELECT id FROM
".ROSCMST_USERS." WHERE LOWER(name) = LOWER(:user_name) LIMIT 1");
             $stmt->bindParam('user_name',$type_c,PDO::PARAM_STR);
             $stmt->execute();
             $user_id = $stmt->fetchColumn();

Modified:
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewUserT…
URL:
http://svn.reactos.org/svn/reactos/branches/danny-web/www/www.reactos.org/r…
==============================================================================
---
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewUserT…
[iso-8859-1] (original)
+++
branches/danny-web/www/www.reactos.org/roscms/lib/backend/Backend_ViewUserT…
[iso-8859-1] Mon May 18 17:12:53 2009
@@ -287,7 +287,7 @@
             // set order field
             switch ($type_c) {
               case 'name': // accóunt name
-                $this->sql_order .= " u.name ";
+                $this->sql_order .= " LOWER(u.name) ";
                 break;
               case 'real-name': // real name
                 $this->sql_order .= " u.fullname ";
@@ -406,7 +406,8 @@
         break;
       case 'name': // account name
       default:
-        $this->sql_where .= " u.name";
+        $this->sql_where .= " LOWER(u.name)";
+        $searchtext = strtolower($searchtext);
         break;
     } // end switch
     $this->sql_where .= " LIKE
".DBConnection::getInstance()->quote('%'.$searchtext.'%',PDO::PARAM_STR)."
";