appdb/include util.php
WineHQ
wineowner at wine.codeweavers.com
Mon Jul 23 16:00:37 CDT 2007
ChangeSet ID: 31266
CVSROOT: /opt/cvs-commit
Module name: appdb
Changes by: wineowner at winehq.org 2007/07/23 16:00:37
Modified files:
include : util.php
Log message:
Edwin Smulders <edwin.smulders at gmail.com>
Make searches use words as keywords
Patch: http://cvs.winehq.org/patch.py?id=31266
Old revision New revision Changes Path
1.98 1.99 +5 -3 appdb/include/util.php
Index: appdb/include/util.php
diff -u -p appdb/include/util.php:1.98 appdb/include/util.php:1.99
--- appdb/include/util.php:1.98 23 Jul 2007 21: 0:37 -0000
+++ appdb/include/util.php 23 Jul 2007 21: 0:37 -0000
@@ -466,15 +466,17 @@ function searchForApplication($search_wo
}
}
+ $search_words = str_replace(' ', '%', mysql_real_escape_string($search_words));
+
/* base query */
$sQuery = "SELECT *
FROM appFamily, vendor
WHERE appName != 'NONAME'
AND appFamily.vendorId = vendor.vendorId
AND appFamily.queued = 'false'
- AND (appName LIKE '%".mysql_real_escape_string($search_words)."%'
- OR keywords LIKE '%".mysql_real_escape_string($search_words)."%'";
-
+ AND (appName LIKE '%" . $search_words . "%'
+ OR keywords LIKE '%" . $search_words . "%'";
+
/* append to the query any vendors that we matched with */
foreach($vendorIdArray as $key=>$value)
{
More information about the wine-cvs
mailing list