V4.1.x Allow Extra fields to be searched!

[marketingsolutions +]

Hi all

After hacking the Listings.php I have managed to get the extra fields included in searches, and it respects fSearch values

WORKING WITH: includes/classes/kernel/Listings.php

Save a backup of Listings.php as Listings.php.old or whatever ( we should ALWAYS backup!)
Open Listings.php in your favourite editor
scroll to line 439 ( it should be a commented out echo )
replace line 439 with the following code

PHP Code:

################################################## ######
# Allow Extra Fields to be searchable
# BKD - 11/02/2009
################################################## ######
if(!defined('IN_ADMIN') && !isset($_GET['cat'])){
    $efsql = "SELECT p.pID FROM ".PREFIX."products_fields AS p RIGHT JOIN ".PREFIX."fields AS f ON p.fID = f.fID WHERE f.fSearch = 'Y' AND (";
    
    $efq = trim(mysql_real_escape_string($_REQUEST['searchtext']));
    $efq_array = explode(" ",$efq);
    foreach($efq_array as $idx => $searchvalue){
        $efsql .= " p.sValue LIKE '%$searchvalue%' OR";
    }
    $efsql = rtrim($efsql,' OR');
    $efsql .= ')';
    $efqresults = $db->query($efsql);
    $efnumrows = $efqresults->size();
    if($efnumrows != 0){
        $efqrows = array();
        $ef_addon_sql = '';
        while($row = $efqresults->fetch()){
            $efqrows[] = $row;
        }
        foreach($efqrows as $idx => $extrafieldid){
            $pid = $extrafieldid['pID'];
            $ef_addon_sql .= "SELECT p.id, p.owner, p.title, p.featured, p.section, p.shortDescription, p.description, p.price, p.dateadded, p.expiration, p.display, p.pHighlighted, p.pBold, p.hitcount, p.url, u.username, u.state, u.city, u.country, u.extra, u.extra2, u.extra3 ". $select ." FROM ".PREFIX."listings AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.id = '$pid' UNION ";
        }
    }
    if($ef_addon_sql > ''){
        $listingSQL = $ef_addon_sql.$listingSQL;
    }
}
################################################### ###### 


Now save Listings.php and upload to your server.

Et Voila! Your extra fields ( if they set as searchable in the admin ) should now be included in subsequent searches.

If you have any problems with this solution, please email me with details of your problem and i will try to help you out My email is [email protected].

Ben Duffin

[Eric Barnes]

This is very cool. Thanks for sharing!

[marketingsolutions +]

Edited away

[Eric Barnes]

I like this so much I am converting it to a module. But it needs a new hook in place. So it will be ready with the next release. Would you like me to send you the files?

[Freddy +]

Oooo I just came into the forums to find an answer to my problem and this might be it!

I purchased the search module here:

ClassifiedMods Search Module

Works a treat but I need an additional field (well a radio select option). Are there any other avenues around for adding another search option?

Will I have to have the developers 68 code for including this script (I have designers)?

Big thanks to marketingsolutions for posting this up!

Cheers,
Fred

[Eric Barnes]

With this code it would require the Developer edition. I have taken this and added it a module but it needed a new hook added. So it would not be in a module form until the next release.

[Freddy +]

Ah bugger. Will have to upgrade then just for this extra field to appear in search box :/

SO just to confirm, this kind script from the OP will allow me to add another search field to my search box?

Many thanks,
Fred

[hel68c +]

Can we used it on version 4.08?