Search module only displays 100%

[marvanni]

When I insert a searchword like animal, the module only displays results with pages that contain animal.

But I also want words linke animalfarm is in the search results.

I think it is in this query:

Code: Select all

$query = "SELECT DISTINCT i.module_name, i.content_id, i.extra_attr, COUNT(*) AS nb, SUM(idx.count) AS total_weight FROM ".cms_db_prefix()."module_search_items i INNER JOIN ".cms_db_prefix()."module_search_index idx ON idx.item_id = i.id WHERE (".$searchphrase.") AND  (".$db->IfNull('i.expires',$db->DBTimeStamp(100 * 100 * 100 * 100 * 25))." > ".$db->DBTimeStamp(time()).") ";

I replaced WHERE into LIKE, but that doen's work.

How can I make the module searches less rigourous and also returns words that contain the searchstring?

[RonnyK]

You might want to try pisearch instead,

http://dev.cmsmadesimple.org/projects/modpisearch/

Ronny

[marvanni]

Hm, thanks,

but none of them seem to install with version 1.0.5...