Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Mysql 4 Search hack Details »
Mysql 4 Search hack
Mod Version: 1.00, by traekwon (Member) traekwon is offline
Developer Last Online: Apr 2006 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (1 vote - 5.00 average) Installs: 18
Released: 17 Apr 2003 Last Update: Never Downloads: 11
Not Supported Is in Beta Stage  

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:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


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!

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
  #106  
Old 14 Aug 2003, 00:02
ImportPassion ImportPassion is offline
 
Join Date: Mar 2002
I think you don't have the hack installed right cause I can't search for anything on your site.
Reply With Quote
  #107  
Old 14 Aug 2003, 01:03
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
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

Last edited by msimplay; 14 Aug 2003 at 01:12.
Reply With Quote
  #108  
Old 12 Sep 2003, 17:16
WCW Fan WCW Fan is offline
 
Join Date: Jun 2003
So is this Hack safe to install, it sounds like and awesome hack I just want to be on the safe side though
Reply With Quote
  #109  
Old 13 Dec 2003, 06:09
dwh's Avatar
dwh dwh is offline
 
Join Date: Feb 2002
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?
Reply With Quote
  #110  
Old 13 Dec 2003, 16:04
gmarik's Avatar
gmarik gmarik is offline
 
Join Date: May 2002
Real name: Marco
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.
Reply With Quote
  #111  
Old 16 Dec 2003, 04:50
forumdude's Avatar
forumdude forumdude is offline
 
Join Date: Nov 2001
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.
Reply With Quote
  #112  
Old 21 Dec 2003, 09:34
MilleniumClock MilleniumClock is offline
 
Join Date: Mar 2003
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

Last edited by MilleniumClock; 15 Jan 2004 at 06:21.
Reply With Quote
  #113  
Old 04 Jan 2004, 19:04
KevinM KevinM is offline
 
Join Date: Dec 2002
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?
Reply With Quote
  #114  
Old 05 Jan 2004, 05:17
forumdude's Avatar
forumdude forumdude is offline
 
Join Date: Nov 2001
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.
Reply With Quote
  #115  
Old 31 Jan 2004, 15:31
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
i wish this hack for vb3 would come out
Reply With Quote
  #116  
Old 31 Jan 2004, 17:37
ImportPassion ImportPassion is offline
 
Join Date: Mar 2002
vb 3.1 will have it built in from what i hear
Reply With Quote
  #117  
Old 31 Jan 2004, 17:38
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
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
Reply With Quote
  #118  
Old 31 Jan 2004, 17:41
ImportPassion ImportPassion is offline
 
Join Date: Mar 2002
not really the point, iwas just stating that cause I doubt someone will do it if it is planned for 3.1
Reply With Quote
  #119  
Old 31 Jan 2004, 17:48
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
yeh i know what u mean but still vb 3.1 is a long way off
Reply With Quote
  #120  
Old 31 Jan 2004, 17:56
Brad Brad is offline
 
Join Date: Nov 2001
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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 01:30.

Layout Options | Width: Wide Color: