Changeset 1637 in subversion for trunk/roundcubemail/program/include/rcube_contacts.php

Timestamp:

Aug 9, 2008 4:20:59 PM (5 years ago)

Author:

alec

Message:

• Case insensitive contacts searching using PostgreSQL (#1485259)

File:

• trunk/roundcubemail/program/include/rcube_contacts.php (modified) (1 diff)

trunk/roundcubemail/program/include/rcube_contacts.php

@@ -197 +197 @@
       {
         $ids = !is_array($value) ? split(',', $value) : $value;
-        $add_where[] = $this->primary_key." IN (".join(',', $ids).")";
+        $add_where[] = $this->primary_key.' IN ('.join(',', $ids).')';
       }
       else if ($strict)
-        $add_where[] = $this->db->quoteIdentifier($col)."=".$this->db->quote($value);
+        $add_where[] = $this->db->quoteIdentifier($col).'='.$this->db->quote($value);
       else
-        $add_where[] = $this->db->quoteIdentifier($col)." LIKE ".$this->db->quote(strlen($value)>2 ? "%$value%" : "$value%");
+        $add_where[] = $this->db->ilike($col, '%'.$value.'%');
     }