Search custom fields & Display results modules

[dinatius]

I searched over stuff and didn't find anything in the results... I'm looking for a way to search custom profile fields that users fill in and display the results. I'm new at vB/advanced, so I don't know how tough this is to do...

To be a little more specific, I'm running a guild site. Users can type in up to 5 character names, classes, races, and levels. I'd like people to be able to search by any of those fields and post back the info. For example, search by character name and list any that contain what they searched (search 'jim' and list 'jim, jimbo, jimbob, ajimo') from any of the characters. I've gotten as far as a sql query that gets all of the info for all of the characters. Either a single module or two side-by-side would work (one for search, one for display, or just search boxes at the top of the display mod).

It's not something I can display in a regular memberlist search, partly just due to how the memberlist is formatted, but mainly because it only allows searching by specific field, not one search field to look in 5 sql columns.

I've got some ideas on design to make it more generic and usable by other sites, willing to discuss it if anyone's interested in picking this up. I'm just not experienced enough to code it myself