12
Actually I got it...after an hour or so...
I edited the search file under the module directory .... xyp4all/includes/search.inc.php
Changed line 35:
$sql = "SELECT l.lid,l.cid,l.title,l.submitter,l.zip,l.date,c.title AS cattitle,t.description FROM ".$xoopsDB->prefix("xyp_links")." l LEFT JOIN ".$xoopsDB->prefix("xyp_cat")." c ON c.cid=l.cid LEFT JOIN ".$xoopsDB->prefix("xyp_text")." t ON t.lid=l.lid WHERE status>0";
Changed line 42-45:
$sql .= " AND ((l.title LIKE '%$queryarray[0]%' OR c.title LIKE '%$queryarray[0]%' OR l.zip LIKE '%$queryarray[0]%' OR t.description LIKE '%$queryarray[0]%')";
for($i=1;$i<$count;$i++){
$sql .= " $andor ";
$sql .= "(l.title LIKE '%$queryarray[$i]%' OR c.title LIKE '%$queryarray[$i]%' OR l.zip LIKE '%$queryarray[$i]%' OR t.description LIKE '%$queryarray[$i]%')";
note the added "l.zip" queries.
Please note:
I do not think of myself as a php or MySql Guru so I just fluked it (or better still just used logic from the above mentioned patch). I just needed a postcode/zipcode search, and if anyone else needs help I am sure I can for a small fee
Hmmm... Why do I have so many screws left over?
