From b654fdac5699b0ad3722444a69c027f5c9f01a1b Mon Sep 17 00:00:00 2001 From: rvelices Date: Wed, 14 Mar 2007 23:50:21 +0000 Subject: minimal changes (lang, small tpl change and quick search on tag url names in addition to name - handy with accentuated letters) git-svn-id: http://piwigo.org/svn/trunk@1906 68402e56-0260-453c-a942-63ccdbb3a9ee --- include/functions_search.inc.php | 5 ++++- 1 file changed, 4 insertions(+), 1 deletion(-) (limited to 'include/functions_search.inc.php') diff --git a/include/functions_search.inc.php b/include/functions_search.inc.php index 1f7469021..e2d518e0d 100644 --- a/include/functions_search.inc.php +++ b/include/functions_search.inc.php @@ -385,10 +385,13 @@ SELECT id $q_like_clause = get_qsearch_like_clause($q, 'CONVERT(name, CHAR)' ); if (!empty($q_like_clause)) { + // search also by url name (without accents) + $q_like_clause_url = get_qsearch_like_clause($q, 'url_name' ); $query = ' SELECT id FROM '.TAGS_TABLE.' - WHERE '.$q_like_clause; + WHERE '.$q_like_clause.' + OR '.$q_like_clause_url; $tag_ids = array_from_query( $query, 'id'); if (!empty($tag_ids)) { // we got some tags -- cgit v1.2.3