Changeset 20988


Ignore:
Timestamp:
Feb 23, 2013, 10:58:00 PM (7 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)

Location:
extensions/user_tags
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • extensions/user_tags/CHANGELOG

    r20985 r20988  
     1User Tags 0.7.5 - 2013-02-23
     2================================
     3* Fix issue : search for tags was case sensistive.
     4
    15User Tags 0.7.4 - 2013-02-23
    26================================
  • extensions/user_tags/include/t4u_ws.class.php

    r20762 r20988  
    4343    $query = 'SELECT id AS tag_id, name AS tag_name FROM '.TAGS_TABLE;
    4444    if (!empty($params['q'])) {
    45       $query .= sprintf(' WHERE name like \'%%%s%%\'', pwg_db_real_escape_string($params['q']));
     45      $query .= sprintf(' WHERE LOWER(name) like \'%%%s%%\'', strtolower(pwg_db_real_escape_string($params['q'])));
    4646    }
    4747   
  • extensions/user_tags/main.inc.php

    r20985 r20988  
    2222/*
    2323Plugin Name: User Tags
    24 Version: 0.7.4
     24Version: 0.7.5
    2525Description: Allow visitors to add tag to images
    2626Plugin URI: http://piwigo.org/ext/extension_view.php?eid=441
Note: See TracChangeset for help on using the changeset viewer.