Gallery Is Not Keyword Searchable Via Forum Search

[marcbkk]

The gallery can't be keyword searched.

[SMFHacks]

The forum search is not integrated with the gallery keywords/picture results.

[marcbkk]

Understand. How can I search the Gallery though by only whole keywords? For example, a search for the word "King" also yields results which contain the word "Making". Not very effective.

[SMFHacks]

Open Sources/Gallery.php
Find

Code: [Select]

$searchquery .= "p.keywords LIKE '%$searchfor%'";
Replace with

Code: [Select]

$searchquery .= "p.keywords = '$searchfor' OR p.keywords LIKE '%$searchfor,%' OR p.keywords LIKE '%,$searchfor,%' OR p.keywords LIKE '%,$searchfor%' ";


[marcbkk]

Thanks. Did that and did a new search for the word "King". Still got results like Sticking, Making, Linking, Looking, etc.

So no change as far as I can see.

I think what needs to be added is a box which says "Search Whole Words Only".

[marcbkk]

So how can I do a keyword search on the Gallery for whole words only?

[SMFHacks]

I have to make a major change to search function to fix it to do the tag could might do it for next update.

[SMFHacks]

Took little more time more complicated that I thought looks like I would need to add a fulltext search in order to get it to work probably will be for SMF Gallery 4.0.