Changeset 7fb11ef in github

Timestamp:

Feb 12, 2011 9:14:11 AM (2 years ago)

Author:

thomascube <thomas@…>

Branches:

master, HEAD, courier-fix, dev-browser-capabilities, pdo, release-0.6, release-0.7, release-0.8

Children:

a1bbc2c

Parents:

f1e98a4

Message:

Move BINARY modifier to make MYSQL use index again

File:

• program/include/rcube_user.php (modified) (1 diff)

program/include/rcube_user.php

@@ -360 +360 @@
 
         // use BINARY (case-sensitive) comparison on MySQL, other engines are case-sensitive
-        $prefix = preg_match('/^mysql/', $dbh->db_provider) ? 'BINARY ' : '';
+        $mod = preg_match('/^mysql/', $dbh->db_provider) ? 'BINARY' : '';
 
         // query for matching user name
-        $query = "SELECT * FROM ".get_table_name('users')." WHERE mail_host = ? AND %s = ?";
-
-        $sql_result = $dbh->query(sprintf($query, $prefix.'username'), $host, $user);
+        $query = "SELECT * FROM ".get_table_name('users')." WHERE mail_host = ? AND username = $mod ?";
+        $sql_result = $dbh->query($query, $host, $user);
 
         // query for matching alias