Quick Search Order by Score

[DIARY.JOMYUT.NET]

My Serendipity version is 0.8.2 at http://diary.jomyut.net

I think if search and ranking it by score , it be better than ranking by timestamp like now. [ My English so bad]
See here ....
file : function_entries.inc.php
function : function serendipity_searchEntries

line 446 : $find_part = "MATCH(title,body,extended) AGAINST('$term' IN BOOLEAN MODE)";
ex. if I type "hello*" in quicksearch it will return entries that have word "hello" , "helloworld" , "helloaaa"
I mean user can specific advance option to search (by use + - * ( ) " ~ )

line 479 : e.exflag,
line 480 : $find_part AS score
line 483 : ORDER BY score DESC

this will ranking word by score.

if you not understand me,you can see http://dev.mysql.com/doc/mysql/en/fulltext-boolean.html


It is very bad when I search word in Thai.Cause Thai language will write by not space (like Iamaboy NOT I am a boy)
You can try by type
องศา
on Quicksearch in http://diary.jomyut.net , I will not found. try again with
*องศา*
You will found many document. but some document not contain "องศา" but it have only "อง".

I want to tell that Can you use PHP to search again? to find that it have องศา not อง in document.

[garvinhicking]

Hi!

Thanks for your suggestion about the ordernig! I will commit a patch for this to make the admin decide how he wants his results ordered...

The other problem - is there a way to solve your search in MySQL? Because using PHP would be very inefficient...

Regards,
Garvin

[wesley]

While we're on the topic of quick search... I've encountered an obvious, uh... hole in the method involved. It's not really the fault of the quick search, per se, but nevertheless somewhat icky.

Multilingual entries don't get searched.

I think it's because they are stored in a different table altogether. Perhaps there needs to be a way to search this 'other' table, too. All my Korean visitors would tell me the search feature is broken...

[Guest]

Hi!
The other problem - is there a way to solve your search in MySQL? Because using PHP would be very inefficient...

Thanks for your answer,
I haven't found solition to search my language in MySQL.
I know that using PHP to search is very inefficient but I dont have a way be better than this cause MySQL doesn't support my language.

Can s9y have option that search in MySQL and search in PHP again?

I will try to find solution to search again on b2evolution source code , I have use it on past and it's work.

[garvinhicking]

If you care to get your fingers into code, the one responsible for searching in serendipity can be found here:

include/functions_entries.in.php
function serendipity_searchEntries()

You can/could add plugin hooks there to make another PHP search on the results by changing this:

Code: Select all

    $search = serendipity_db_query($querystring);

into:

Code: Select all

    $search = serendipity_db_query($querystring);
    serendipity_plugin_api::hook_event('frontend_searchentries_result', $search, $term)

Then you can use any plugin to iterate through the results and strip out invalid results...

Regards,
Garvin

[Warun]

Thanks for suggestion and answer.
I will do it.

Warun