[Beta 1.5.2] Search Enhance

[A.M.A.]

What is it:
This mod will enhance the search capability for displaying accurate results. Now you can search for strings in Subject only or in Message only or in both of them.

Download:
H E R E

Manual:
open Search.php and search for:

Code Select Expand

     if ($userkind == 1 && $userspec == '')
        $where = "($boardsWhere m.ID_MSG=t.ID_FIRST_MSG && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 1 && $userspec != '')
        $where = "($boardsWhere m.ID_MSG=t.ID_FIRST_MSG && m.posterName='$userspec' && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 2 && $userspec == '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 2 && $userspec != '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.posterName='$userspec' && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 3 && $userspec == '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER != -1 && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 3 && $userspec != '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER != -1 && m.posterName='$userspec' && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 4 && $userspec == '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER=-1 && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 4 && $userspec != '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER=-1 && m.posterName='$userspec' && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && (INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query')) && m.posterTime <= $mintime && m.posterTime > $maxtime)";

replace it with:

Code Select Expand

 if ($searchsubject == 'on' && $searchmessage == 'on')
    $searchcrit = "(INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query'))";
 else if ($searchsubject == 'on')
    $searchcrit = "(INSTR(LOWER(m.subject),'$query'))";
 else if ($searchmessage == 'on')
    $searchcrit = "(INSTR(LOWER(m.body),'$query'))";
 else
    $searchcrit = "(INSTR(LOWER(m.subject),'$query') || INSTR(LOWER(m.body),'$query'))";

     if ($userkind == 1 && $userspec == '')
        $where = "($boardsWhere m.ID_MSG=t.ID_FIRST_MSG && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 1 && $userspec != '')
        $where = "($boardsWhere m.ID_MSG=t.ID_FIRST_MSG && m.posterName='$userspec' && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 2 && $userspec == '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 2 && $userspec != '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.posterName='$userspec' && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 3 && $userspec == '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER != -1 && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 3 && $userspec != '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER != -1 && m.posterName='$userspec' && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 4 && $userspec == '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER=-1 && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else if ($userkind == 4 && $userspec != '')
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && m.ID_MEMBER=-1 && m.posterName='$userspec' && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
     else
        $where = "($boardsWhere m.ID_TOPIC=t.ID_TOPIC && $searchcrit && m.posterTime <= $mintime && m.posterTime > $maxtime)";
not much   .. but it took me a while to figure out the best method.

cheer

[Shadow's Pawn]

Any chance of making this able to search by user?  Right now you can search by user but you must provide a search string..  I want to be able to search, for instance, for all threads started by a user.  Any idea how to do that?

Thanks for the mod by the way.  Great work.

[Zulu]

Any chance of making this able to search by user?  Right now you can search by user but you must provide a search string..  I want to be able to search, for instance, for all threads started by a user.  Any idea how to do that?

Thanks for the mod by the way.  Great work.

go to their profile, and select if you want to see 10.25,50 or all of their posts.

[Shadow's Pawn]

I know that, but I want to search for only those threads *started* by that user.. not all posts by the user.  Essentially what I want is to create a "user archive" using the search option.  If I get enough spare time to learn php, I might tackle this myself.

[shy hamster]

What is it:
This mod will enhance the search capability for displaying accurate results. Now you can search for strings in Subject only or in Message only or in both of them.

Hello A.M.A.

I have been having trouble getting YaBBSE search function to retrieve relevant results - e.g. if I search for "ion", I will get "ignition", "lion" etc. In short, the search function does not "match whole words only".

Does your mod solve this problem?

Thanks.

Shy Hamster

[A.M.A.]

The search will return both words "ion" and "ignition".

[Spaceman-Spiff]

i thought i gave u the code already, shy hamster
search match whole word

i want to make a better version of it when i have the time
probably using pattern matching like: '^ion %' and '% ion(.|!|?|,| )%' (note the spaces)
so it can also check if ion is in the beginning of a sentence, or at the end