appdb/include util.php

[WineHQ]

ChangeSet ID:	31266
CVSROOT:	/opt/cvs-commit
Module name:	appdb
Changes by:	[e-mail]	2007/07/23 16:00:37

Modified files:
    include        : util.php

Log message:
    Edwin Smulders 
    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)
     {