MySQL Fulltext Searching

[Andreas]

Hmm, what about just runnig a diff on your modified search.php and the original?
Takes only secs to do and AFAIK would not break the license.

Maybe HTL could also be used?

Come on, this would definitly make MANY guys happy

[mute]

Fear not. I'm working on it. I have a diff done, and I'm just waiting for my partner in crime to test it out, and to finish up the instructions.

If he would wake up, I could get this done with and we could all be happy

It took some work to get the diff done, because the version Yogi gave me was against gamma, and the change in code is huge (the new search.php is ~600 lines smaller), so I had to do a little manual patching. Maintaining it going forward might be a bit of a pain, we'll just have to see though.

I'll post more when I'm ready to post it.

[msimplay]

i'd like to donate to the hack creator let us know when your ready

[forumdude]

Originally Posted by mute

Fear not. I'm working on it. I have a diff done, and I'm just waiting for my partner in crime to test it out, and to finish up the instructions.

If he would wake up, I could get this done with and we could all be happy

It took some work to get the diff done, because the version Yogi gave me was against gamma, and the change in code is huge (the new search.php is ~600 lines smaller), so I had to do a little manual patching. Maintaining it going forward might be a bit of a pain, we'll just have to see though.

I'll post more when I'm ready to post it.

We (myself and mute) have a working version of the fulltext search for vb3 gamma. Unfortunately we don't have one for rc3 yet as the code changes to search.php in rc3 have proven to be an obstacle.

Our site is moving hosts this week so this hack will probably be put on a backburner until more time is taken for it. Do not fret, it will come.

I'm considering setting up a private forum in our community for those who have experience with hacking or would like to help troubleshoot, test and get this thing out into an available release asap. Anyone interested, please pm me.

[jb605]

Does this handle multibyte character language correctly? I am very interested in this as well, because the standard VB3 search does not work at all for multibyte language.

Thanks.

[gmarik]

This should be as the default vb3 gold ...

[ImportPassion]

3.1 will

[Erwin]

Originally Posted by YogiTW

I completed this hack earlier this week because our very large forums could not use the usual search engine. Since the license doesn't allow me to just send out my search.php and I don't have the time to package it up nicely it is now in someone else's hands to do that for me. Hopefully you'll see it soon.

It took me less than a day to put it together. It consisted mostly of commenting out a few hundred line of vB's phrase logic (which is replace by mysql's boolean search capabilities) and then changing a couple of lines of the SQL code. From the user's stand point it looks EXACTLY the same as the old search engine

Very cool. Well done.

Apparently vB 3.1 will have this, but not vB 3.0 Gold.

[Nitesh]

3.1 will have it but thats too many months away....

Anyone had any luck with this yet?

[LuVi]

Ok for your proposal.

LuVi