It lives!

It's a tad ugly but I have a standard solution to that I'll be bringing over when I get onto more of the panels.

Use guide, enter your text plain and it searches for all of the given words in all given fields. If you want to search a specific phrase put quotes around it "like this". If you want to do some wild card searching put * at the end of the word or phrase and it should work. Anything more complex won't work, but it is entirely possible I could do more additions later.

Now, what's left to do for quote search is actually rather complicated. To search the comments and display matched comments along with their quotes I need to search a second table for matches and correctly display at least one of those matching comments along with the related quote. if I hard coded the search it'd be rather easy, only as I've mentioned before I can't hard code the method I'm using. So instead I'm working out something I've been idling on at work for a while now, searching multiple tables and handling the output gracefully. I'm pretty sure I have the search part down, and the display may be a rather simple matter if I don't over complicate it with functionality, but once I have something working I'll go more into specifics on what I can and can't do easily.

Also, if you're regularly annoyed with the current search and want me to update the data on the test site kvetch in the comments and I'll dedicate some time but I should mention it's a couple hour process which is why I don't do it regularly. The glory of cheap webhosting.

Oh, and this version is a little old since I have it torn apart on my dev machine, if you put in a double quote without a match it will error. Should be fixed next update.