Alexander Nicolaysen Sørnes : Don' t include vendor names in searches
Chris Morgan
cmorgan at winehq.org
Sun Nov 11 14:16:25 CST 2007
Module: appdb
Branch: master
Commit: da4b3f638db157c5fc3de077c4e4ed5d60d43819
URL: http://source.winehq.org/git/appdb.git/?a=commit;h=da4b3f638db157c5fc3de077c4e4ed5d60d43819
Author: Alexander Nicolaysen Sørnes <alex at thehandofagony.com>
Date: Sat Nov 10 17:20:53 2007 +0100
Don't include vendor names in searches
---
include/util.php | 24 +-----------------------
1 files changed, 1 insertions(+), 23 deletions(-)
diff --git a/include/util.php b/include/util.php
index 4f6f546..5853a10 100644
--- a/include/util.php
+++ b/include/util.php
@@ -416,37 +416,15 @@ function searchForApplication($search_words)
array_push($split_words, $value);
}
- $vendorIdArray = array();
-
- /* find all of the vendors whos names or urls match words in our */
- /* search parameters */
- foreach ($split_words as $key=>$value)
- {
- $sQuery = "SELECT vendorId from vendor where vendorName LIKE '%?%'
- OR vendorURL LIKE '%?%'";
- $hResult = query_parameters($sQuery, $value, $value);
- while($oRow = query_fetch_object($hResult))
- {
- array_push($vendorIdArray, $oRow->vendorId);
- }
- }
-
$search_words = str_replace(' ', '%', query_escape_string($search_words));
/* base query */
$sQuery = "SELECT *
- FROM appFamily, vendor
+ FROM appFamily
WHERE appName != 'NONAME'
- AND appFamily.vendorId = vendor.vendorId
AND appFamily.queued = 'false'
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)
- {
- $sQuery.=" OR appFamily.vendorId=".query_escape_string($value);
- }
$sQuery.=" ) ORDER BY appName";
More information about the wine-cvs
mailing list