Fulltext boolean search v.2.2 for vB

Hello all!

Moving here from beta forum
https://vborg.vbsupport.ru/showthread.php?t=62218

This hack makes nearly same for vB3 as
[vB 2.2.x] - Mysql 4 Search hack
https://vborg.vbsupport.ru/showthread.php?t=51716
for vB2

You will need MySQL server v4.0.1 or better (but sometimes it may work on 3.23.xx). After installing you will be able to search with empty native vB index (word and postindex tables) and using modifiers.
Allowed modifiers + are ,-, * and "
All modifiers except * should be used only once for one word (in the beginning and without space).
* it should be used at the end of a word.
For example:
windows unix -> will find messages containing at least one these words.
+windows +unix -> will find messages with both this words.
windows* -> will find "windows", "windowss", "windowssauce" or "windowst".
*indows will NOT find "windows"
"some words" -> will find "some words of wisdom", but will not find "some extra words".
Search phrase length limitations replaced with results number limitation.
Value of old "Search Index Maximum Word Length" used to limit number of posts in the result returned by fulltext search (control panel/Message Searching Options)
Supposed that it must run faster then native vB search

History:
v.2.2 [5 Apr 2004]
- search words relevance (when sort by relevance) added at last
but little different then native vB (it may not work when searching with * modifiers)
- attempt to fix incompatibility with other hacks
=to upgrade replace code block #5 in search.php with latest one

v.2.1 [4 Apr 2004]
- Excluding from search forums with "Index New Posts in Search Engine" option set to "No"

v.2.0 [30 Mar 2004]
-"Similar Threads" now must start working (to move from 1.x to 2 just change one more script - functions_search.php)

v.1.9 [29 Mar 2004]
-checking if $query string is not empty before running fill text sql

v.1.8 [20 Mar 2004]
- line numbers and higlight code changed for VB3 Gold
- more tests and error explanations

v.1.7 [9 Mar 2004]
- MySQL error for administrators bug fixed
checking is $not_forumid string exixts before adding it to query

v.1.6 [9 Mar 2004]
- national letters bug fixed
preg_replace("~[^\w\"\-+\* ]~i", "", $query);
was replaced by
preg_replace("~[^\w\xC0-\xFF\"\-+\* ]~i", "", $query);

v.1.5 [8 Mar 2004]
- TABLE_PREFIX bug fixed
- slightly optimised SQL requests

v.1.4 [8 Mar 2004]
- delete_post_index function turned off
- more tests and error explanations

v.1.3 [7 Mar 2004]
- less code because of using native vB $postQueryLogic and $threadQueryLogic conditions
- more tests and error explanations

v.1.2 [7 Mar 2004]
- boolean mode can be turned off in AdminCP ("Allow Search Wild Cards" setting)
- "titles only" search fixed
- limiting number of matches retunned by fulltext search AFTER applying search conditions

v.1.1 [7 Mar 2004]
- HighLight support added

the "actual" version of fulltext inside vB is not working at all... 75% of the results are falsed and bug on most Mysql systems because not fixed... that'S why vB 3.5 will ahve a complete new fulltext integration, mostly based on this one... logically... 0

[David Bott]

Ah. Why thank you very much. Thus the issue we had when we made the move to VB3 with the high mysql loads and frequent site outages.

I am guessing then I do not need their...

ALTER TABLE thread ADD FULLTEXT INDEX (title);

...querty and I can dump that index.

this actual hack was built before the full index modification was applied in vB 3.0.1, therefore you can delete that index... because vB added the fulltext in vB 3.0.2 ...

[David Bott]

Well in the VB version of the code, Full Text seems to work well other than the high loads. Meaning....if someone looks for "the quick brown fox" it finds that. However...I just received this...

Is there any way to search for an exact phrase? On the Search FAQ page there are a couple of matching options, including "Match Complete Phrase", but on the Search Forums page there is only a keyword search. For example, if I search the forums for "whole house audio" it returns some 300 threads, all of which contain the three words somewhere, but not necessarily the whole phrase.

I've tried some things like using quotes and Boolean operators (AND, OR, NOT) -- with no luck. Am I missing something, or is this simply not an option?

I tested this and found he is correct. It does not hit like a full text search should.

Anyone have any thoughts on this?

Thank you.


*** Disreguard...NOTE...You need to have "Allow Search Wild Cards" set to YES in the Message Searching Options area of the Vb Options page.

[David Bott]

Hello again...

I searched for the word RAID and the user name of BasementBob on my site in advanced mode. It retured no results even though their are threads by him with the word RAID in it. So the question is...Can you not use both the word box and the user name box at the same time with this hack running?

Can someome please test and advise.

Thanks

[David Bott]

Ok, have some more issues and I have no clue why.

In this thread you can see a user reported an issue with not finding posts with the serach that clearly has the words in it.

http://www.tivocommunity.com/tivo-vb...d.php?t=246239

After testing I had found this to be true and droped the indexes and regreated them based on the information provided in the install text file.

even tried to find that thread above by seraching for "channels" and even "DirectTV" and could not even find that thread that reported the same issue.

Any thoughts on this?

MySQL version = MySQL 4.1.10a

[David Bott]

Hello...Anyone? Is this hack no longer supported?

Thank you.

[Steve St.Lauren]

Do you still have the hack installed? If so then you must have missed some part of the hack install. I just did a search on "+tivo +will +no +longer +change" in titles only in that forum to try to find the thread in question and it returned two threads that didn't include all of those terms in the search results - it shouldn't have returned those. My guess is that you missed some part of the hack install - check it over carefully again.

[David Bott]

I have done so now more than once. Not new to this at all as you may see. I just do not get it. Something justis not right and it happen both on TiVo Community Forum and AVS Forum.

Thank you kindly for the reply.

[Edited to removed requested found item.]

[klamm]

Guys, you saved me!

I'm running a >2 Million Posts Board with 500 Users on ... heaviest load during searches using the standard algorithm. Now I tried this hack (vb 3.0.8, including Erwins improved Addon) and load is going down to nearly zero!
Thank God for this hack!

Btw: The built-in-hidden-debug-beta-fulltext-VB-search - don't even think of trying it @ big boards. It will only crash your machines ...