Sphinx Search

[jwksite]

This sounds promising.

The one problem I can see now is searching with "Exact Name" unchecked? It sounds like this is only going to rely on ONE userid. I guess while this new feature of Sphinx is being worked on that we could FORCE "Exact Name" to avoid any issues.

Anyway, I've read through this entire thread by now and this seems like the first real hint of promise since before orban left!

You said a few posts ago that you were willing to help fill in the blanks, so would you be so kind? Some kind of outline of changes between the old implementation and what you've done for the new 0.9.8 would be really great. I guess the biggest blank is how you've changed sphinx.php. I imagine that the rest of the old method is mostly unchanged? (Except for a new sphinxapi.php?)

Haha, sorry.. I don't mean for that to sound demanding, obviously. I'm just ready at any point over the next few days to install 0.9.8 and I really want to help get any issues worked out!

Let me know your thoughts on the "non-Exact Name" search, too. I think even in the meantime that it could just reroute to the old vBulletin search?

Edit: Actually, I just guess the exact name thing would rely on how the query to return the username is formed? I'm sure Sphinx will support searching over multiple userids, right?

[Xorlev]

It currently supports non-exact checking. The nice thing about sphinx filters is you can pass it an array.

I'm actually working on it right now. Mostly I just ripped out vBulletin's search completely rather than the conditional "is the query blank or not?" and handling with vB's or Sphinx. Right now I'm working on adding the features sphinx.php lacks from the advanced search as well as all the sorting modes. If it's on the advanced search page, I'll add it.

After that it's most likely sanity checking to make sure it's all working.

Coventry: All we want to do is exclude posts/threads from userids in the list, right?

[andrewkhunn]

Originally Posted by Xorlev

Coventry: All we want to do is exclude posts/threads from userids in the list, right?

I believe so, yes.

Also, if it's not too much trouble... If you could see about getting the "Similar Thread" search functionality pawned off to Sphinx too, that would be great. It's not that big of a deal for me because it only fires on new threads (might be for some I suppose), but being able to drop the standard FULLTEXT tables from the DB would be nice.

[TECK]

Originally Posted by Xorlev

Right now I'm working on adding the features sphinx.php lacks from the advanced search as well as all the sorting modes. If it's on the advanced search page, I'll add it.

You can have all the vBulletin search features working with 0.9.7 if you know how to code.
The only feature I like in 0.9.8 is the usage of wildcards, that's the only option is currently missing in 0.9.7 to make it fully compatible.

I do not use Orban's hack, neither I use his coding approach. It is very bulky.

[amcd]

What do we have to do to convince you to share your work?

[ferreo]

This is a silly question but after going through this thread i couldn't find a definite answer.

Is the fulltext search index still used or can I drop it? Reason I ask is that it got corrupted somehow today and I am debating to drop it and not have it repaired. Thanks!

[Xorlev]

If you use similar threads, then yes. If not, you can delete them. I'm working on replacing similar threads as well.

[ferreo]

Originally Posted by Xorlev

If you use similar threads, then yes. If not, you can delete them. I'm working on replacing similar threads as well.

Excellent, thank you very much! I will give it a shot.

[Xorlev]

Er, by that I mean "yes you need them." similar threads will fail to work otherwise, if you don't use them you can delete them. I don't believe anything else other than search and similar threads use them though.

[amcd]

I don't use similar threads and I dropped the fulltext indexes ages ago. No problems whatsoever.