Changeset 20988 for extensions/user_tags/include/t4u_ws.class.php

Timestamp:

Feb 23, 2013, 10:58:00 PM (11 years ago)

Author:

nikrou

Message:

Fix issue. Search for tag with capitalize letter didn't work.

(Thanks one more time to Tim Mohr for reporting issue)

File:

• extensions/user_tags/include/t4u_ws.class.php (modified) (1 diff)

extensions/user_tags/include/t4u_ws.class.php

@@ -43 +43 @@
     $query = 'SELECT id AS tag_id, name AS tag_name FROM '.TAGS_TABLE;
     if (!empty($params['q'])) {
-      $query .= sprintf(' WHERE name like \'%%%s%%\'', pwg_db_real_escape_string($params['q']));
+      $query .= sprintf(' WHERE LOWER(name) like \'%%%s%%\'', strtolower(pwg_db_real_escape_string($params['q'])));
     }