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

[ImportPassion]

i only have one problem, but it works fine in 3.0.3 for me.

if ppl search for 17" rims, it will blow up cause of the ". I should be able to fix it tho.

the " is easy to deal with, it's a tag... point actually is the install instructions... 3.0.0 is really different from 3.0.3, because of the new fulltext search propriety... is someone updating the install so we can drive it cool ?!

[M1th]

Yep, that'd be cool. It's quite confusing to follow the instructions for 3.0.3.

[ImportPassion]

ok, this thing is now killing my site for some reason, especially when some one searches for say 17" rims.
The vb3 one also kills it, but even worse.

I don't know what to do anymore.

[WotC_Tech]

I've installed this hack and are having good luck with it on vB 3.0.3 with 3 million posts. I did have a performance problem when searching for posts in forums rather than searching against all posts. It appears that Erwin's Add-On helped us a great deal when searching against all posts, but queries against specific forums would often take 30 or more seconds to complete.

We resolved this issue by modifying Erwin's Add-On a bit:

PHP Code:

// Erwin's Add-On

$searchlimit = " WHERE";
$searchforumadd = "";

if ($searchthread) {
$searchlimit = " WHERE post.threadid=$searchthreadid AND";
}

if ($forumchoice) {
$searchforumadd = ", forumid";
// Modified by WotC_Tech
//$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid WHERE forumid IN($forumchoice) AND";
$searchlimit = " LEFT JOIN thread AS thread ON post.threadid=thread.threadid AND thread.forumid IN($forumchoice) WHERE";
}

$fulltext_sql = "SELECT postid$searchforumadd FROM post$searchlimit MATCH (".$what_field.") AGAINST ('$query".$isboolean.") LIMIT 0, ".$vboptions['maxresults'];

// Erwin's Add-On 


It appears that the MySQL optimizer isn't doing its job and running the query as fast as it could.

diguidi bump! -- want news for this !!!

[alexi]

I'm with nexialys, any chance of getting an updated version of this for 3.03? I'm missing something trying to tie all of these threads together with the changes

[Steve St.Lauren]

With this hack when you search on entire posts it won't search the titles as well. I was searching for a thread on my board and if I did the search on titles only it would come up but if I did the same search on entire posts it won't. Any ideas?

as msimplay released his new hack for this tool (https://vborg.vbsupport.ru/showthread.php?t=76678), can someone update the install script for 3.0.6 ???

there is a completely different file structure after 3.0.1+, so this would be more than efficient to update the script install process...

someone ?!

[msimplay]

Originally Posted by nexialys

as msimplay released his new hack for this tool (https://vborg.vbsupport.ru/showthread.php?t=76678), can someone update the install script for 3.0.6 ???

there is a completely different file structure after 3.0.1+, sothiswould be more than efficient to update the script install process...

someone ?!

Someone has already used the same hack with vb3.06 its installed