Mysql 4 Search hack

MySQL 4 Search hack for Vbulletin 2.x.x - version 1.2 beta
Author: PineappleClock (pineappleclock@clockcrew.cc) aim: Janitor61
-------------------------------------

Overview
The MySQL 4 search hack modifies the search functionality in Vbulletin to take advantage of the new SQL functions available in MySQL 4.

Synopsis
This hack allows MySQL to index the posts and threads in your BBS instead of requiring vbulletin to do it.
This hack, when installed, will change the BBS in the following ways:

• Vbulletin will not require the 'word' or 'searchindex' tables anymore - saving lots of space - instead it will use the 'post' table as an index.
• Vbulletin will not catalog, reference and index every word of every post upon insertion into the database - saving tons of processing.
• No need to regenerate the search index ever.
• The 'post' table will increase in size by about 35%
• Searches will be considerably faster, and posting will be somewhat faster.
• Search strings will be able to contain phrases, like "lets share a soda", which can include small words that would of been blocked in vbulletin 2.x searches.
• Advanced searches, containing included words, optional words, excluded words and exact phrases.

File Listing
install.txt -- the installation howto
simplesearch.txt -- a block of code that replaces a block of code in search.php
searchtemplate.txt -- a vbulletin template used for drawing the search form.

Requirements
MySQL 4.0.1 or newer - required
vbulletin 2.x.x - required (i've only tested it on 2.3.0 though)

How to check your MySQL version:
execute the following query:

SELECT @@global.version

Notes
The installation instructions assumes that you have access to database management software, like phpMyAdmin. If you can't edit your database directly, I can make a php script that will modify your database if there's enough demand.

The Vbulletin team aren't going to put in support for MySQL 4 until version 3.1 - so this hack should be obsolete by then.
If you'd like to see the modified search engine, go here:

http://www.clockcrew.cc/bbs/search.php

I was originally going to distribute the whole modified search.php file, but after reading the rules, im only distributing the modified part. Please let me know if you spot any bugs, etc. I've tested this, but there still are probably bugs i need to work out.

update [Apr 17]: added instructions on uninstalling

good luck!

[ImportPassion]

I think you don't have the hack installed right cause I can't search for anything on your site.

[msimplay]

oops sorry i just realised guest searchin was turned off i'll turn it back on :P

problem fixed i searched for the answer within the thread sorry for wasting time

[WCW Fan]

So is this Hack safe to install, it sounds like and awesome hack I just want to be on the safe side though

[dwh]

I tried searching on the first few sites that have this installed. Search results were really slow. Do the people who have installed this still feel that good about it? Especially for large forums?

[gmarik]

Originally Posted by dwh

I tried searching on the first few sites that have this installed. Search results were really slow. Do the people who have installed this still feel that good about it? Especially for large forums?

Another good idea would be to make it work for vB3, it's comming closer and closer, year 2004 is the one to rule it.

[forumdude]

Originally Posted by gmarik

Another good idea would be to make it work for vB3, it's comming closer and closer, year 2004 is the one to rule it.

Just wondering if anyone knows of work being done on this hack for vb3 compatibility. I'm not sure that I can even upgrade to vb3 until this hack is available for vb3.

[MilleniumClock]

Originally Posted by forumdude

Just wondering if anyone knows of work being done on this hack for vb3 compatibility. I'm not sure that I can even upgrade to vb3 until this hack is available for vb3.

lol, i doubt it, this original hack was made for clockcrew.cc, a site which i was part of, hence my name MilleniumClock, Traekwon was the owner and the guy who posted this for piney, and pineappleclock did most, then the site went down, Traekwon dissapeared and hasn't been seen since, and pineappleclock hasn't been around for a while. SOOO.... i seriously doubt it if traekwon and pineapple re-release this for vb3

but things can happen, so you can always keep your fingers crossed :-p

[KevinM]

I've got this hack installed and working fine, however i do have one problem.

I use a gateway script (Gilbys newsgroup hack) to import newsgroup posts, and since installing this hack these new posts are not showing up in the search results.

There is only one line in the newsgroup script which refers to searching of posts, which is:

indexpost($postid,1);

Does anyone know what I need to change this too?

[forumdude]

Originally Posted by MilleniumClock

lol, i doubt it, this original hack was made for clockcrew.cc, a site which i was part of, hence my name MilleniumClock, Traekwon was the owner and part coder, and pineappleclock did most, then the site went down, Traekwon dissapeared and hasn't been seen since, and pineappleclock pretty much left the clockcrew. SOOO.... i seriously doubt it if traekwon and pineapple re-release this for vb3

but things can happen, so you can always keep your fingers crossed :-p

Nice, the worst case scenario played out.


I suppose on a positive note its good that vbulletin plans to add this feature into the stock software in 3.1(i think?). The downside is that those of us who require such a feature are forced to be patient and wait for it (been waiting for vb3 for what seems like a lifetime anyways right?), meh.

[msimplay]

i wish this hack for vb3 would come out

[ImportPassion]

vb 3.1 will have it built in from what i hear

[msimplay]

well to be honest i dont care what vb 3.1 has coz judging on the length of time for vb3 to come out 3.1 is more then a year away

[ImportPassion]

not really the point, iwas just stating that cause I doubt someone will do it if it is planned for 3.1

[msimplay]

yeh i know what u mean but still vb 3.1 is a long way off

[Brad]

I plan on making this for my forum but it is on a long to do list so whenever I get around to it ill do it.