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

[JohnWoo]

true... Uploading fixed txt

[JonP]

Originally Posted by rikman

Did you shut down your board while altering the tables? If there are queries waiting for access to the post table while it is locked, your machine load will grow high and higher. This has an affect on ALL tasks running on your machine, incl. creating the index columns at your post table.

rikman

Yep, I completely shut down the forum, and the forum is the only thing on the dedicated server.

[Erwin]

Ooh... this is so tempting...

[sabret00the]

what does it do exactly and what's the advantage of having this installed?

[msimplay]

Originally Posted by Erwin

Ooh... this is so tempting...

well it seems to be working perfect now
i have it installed with similar threads and unanswered posts
u can check at my website

Originally Posted by sabret00the

what does it do exactly and what's the advantage of having this installed?

it removes the need for a search index hence making your database smaller and faster
extremely good for large sites
it will be standard in vb3.1 but don't know how long that will take
and large sites need it now

check this link for a better description of its capabilities
https://vborg.vbsupport.ru/showthrea...ighlight=mysql

[Boofo]

Originally Posted by Erwin

Ooh... this is so tempting...

If you install this, Erwin, please let me know what you think of it. If you're brave enough, I may have a go at it.

[sabret00the]

Originally Posted by msimplay

well it seems to be working perfect now
i have it installed with similar threads and unanswered posts
u can check at my website
it removes the need for a search index hence making your database smaller and faster
extremely good for large sites
it will be standard in vb3.1 but don't know how long that will take
and large sites need it now

check this link for a better description of its capabilities
https://vborg.vbsupport.ru/showthrea...ighlight=mysql

thanks for explaining that, it's fairly exciting after reading that thread

[Natch]

I am running it - small board, but definite performance improvement ...

Plus I just like the fulltext searching bonus!

[size]and I'm a sucker for a hack not many have installed ...[/size]

[msimplay]

ok one problem theres an option when u make a new forum where it says do not index posts
traditionally this stops people from searching those forums
but with this hack to be able to do that
u have to be able to exclude forums from fulltext searching with the same setting

reason is because i have the unanswered post hack installed and also the news syndication hack installed

which means that all posts in the news area will always be unanswered
so i do not want them to be searchable

[Dontom]

Originally Posted by msimplay

hey sorry for bugging you
i have found a new bug
when you search this thread it returns results from other threads

Same here, too.
Tom