IMPORTANT - How to Have a really funcional Search

[Pigeon]

.

[Pigeon]

?

[Pigeon]

?

[_CONEJO]

.

?

?

Please stop this kind of messages

[Pigeon]

.

?

?

Please stop this kind of messages

Why don't you help me? this should be easy for you 

[_CONEJO]

Because the original question is answered already, you asked a different one and I don't have time to answer every single question posted in the forums.

You need to modify the osc_highlight function to your needs. Please, create a new topic for each different question and show what modifications did you already made.

[Pigeon]

Because the original question is answered already, you asked a different one and I don't have time to answer every single question posted in the forums.

You need to modify the osc_highlight function to your needs. Please, create a new topic for each different question and show what modifications did you already made.

thank you very much, yes now  made one 

[BabyDunk]

Hello and thank you for the previous help i have received

i am now wondering is it possible to add listing id to this search function?? that would be excellent if possible.

thanks

[ezybusy]

BabyDunk,  if you are trying to search item by Id there is a plugin for that.
I can't remember the name or where I saw it, but I came across it some days ago.

[BabyDunk]

thanks ezybusy.

i will have a look shortly.

[BabyDunk]

@ezybusy
thanks for the info but i cant find the plugin you are talking about. i have searched on and off for a few days.

does anyone else know of this plugin??

or

is it possible to add the function search by item Id to this already brilliant code? 

thanks

[BabyDunk]

can anyone tell me if im going in the right direction??

Code: [Select]

<?php
//Add Username search function to the search engine
function cust_search_keyword_wildcard_with_user_username($params) {

    if ($params['sPattern']) {
        $mSearch =  Search::newInstance();
        $query_elements = (array) json_decode($mSearch->toJson());
        $pattern = $query_elements['sPattern'];
  
        $query_elements['sPattern'] = str_replace(' ', '* ', $pattern) . '*';

        $mSearch->setJsonAlert($query_elements);

        // Search by user.Username too
        $mSearch->addJoinTable(count($query_elements['tables_join']), DB_TABLE_PREFIX."t_user u", "fk_i_user_id = u.pk_i_id", 'INNER');
        
        $aPattern = explode(' ', $pattern);
        $userNameCond = '';
        $userItemCond = '';

        foreach ($aPattern as $word) {
            if ($word) $userNameCond .= sprintf(" || u.s_username = '%s'", $word);
        }
        
        foreach ($aPattern as $item) {
            if ($item) $userItemCond .= sprintf(" || t_item_description.fk_i_item_id = '%s'", $item);
        }

        $mSearch->addConditions("1 = 1 " . $userNameCond);
        $mSearch->addConditions("1 = 1 " . $userItemCond);
        $mSearch->addGroupBy(DB_TABLE_PREFIX.'t_item.pk_i_id');
        
     }
}

osc_add_hook('search_conditions', 'cust_search_keyword_wildcard_with_user_username', 1);
?>

thanks