How to make search profile fields mod do this...

[fahraeus]

Your phpBB Version: Vanilla phpBB 2.0.19
MODs: No
Your knowledge: Basic Knowledge
Boardlink: [url]http://[/url]

PHP Version:
MySQL Version:


What have you done before the problem was there?
not applicable


What have you already tryed to solve the problem?
not applicable



Description and Message

First of all thank you for all your great mods! I enjoy many of them.

Now search profile fields mod works like this:

When I search for:

"TEST"

I get results for fields with words like anythinghereTESTanythinghere

How can I make it get results only for TESTanythinghere but not anythinghereTEST?

ie how to make the search work like test* but not *test* when searching (where * are wildcards)

[oxpus]

The script still search for

%TEST%

per default.
It's a harder job to change this, because my MOD will not search with SQL statements directly in the user profile fields (as the "normal" search will do!), but in a joined string from them...

[fahraeus]

Yes, I've been staring at the code for a while now, and I understand. If you come up with a solution, please let me now?

Would it be possible for instance to chance the code so it searched for whole words?