Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 31 Jan 2004, 23:50
forumdude's Avatar
forumdude forumdude is offline
 
Join Date: Nov 2001
Lightbulb MySQL Fulltext Searching

Welp. Here it is, my official request for this hack. I know that vbulletin has said fulltext searching will be supported in a later version of vbulletin (http://www.vbulletin.com/forum/showthread.php?t=93105) but quite frankly I want to reap the benefits of vb3 when it comes out instead of waiting for what seems like eternity for vb3 just to have to wait for a later version. :tired:

Our board's stats: Members: 67,265, Threads: 358,424, Posts: 3,388,146

We can't possibly use vbulletin without the fulltext searching ability and I know there are other boards out there that are in the same boat.

I'm willing to start a fund for someone who can write a good fulltext searching hack for vb3 and I'm more than willing to throw $50 bucks into the pot. If we can find someone who is a reputable hacker this could turn out well for not only those who need the functionality but the person writing the hack as well.

Last edited by forumdude; 31 Jan 2004 at 23:54.
Reply With Quote
  #2  
Old 01 Feb 2004, 00:36
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
I'd be highly interested too, would also put some € into the pot
Reply With Quote
  #3  
Old 01 Feb 2004, 01:50
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
yes me too i am willing to put some money for this hack
Reply With Quote
  #4  
Old 01 Feb 2004, 02:37
ImportPassion ImportPassion is offline
 
Join Date: Mar 2002
me too.
Reply With Quote
  #5  
Old 01 Feb 2004, 03:25
alexi alexi is offline
 
Join Date: Feb 2002
disboards.com will kick in $100.00 if it works as well as the last one!
Reply With Quote
  #6  
Old 01 Feb 2004, 10:43
Lumina's Avatar
Lumina Lumina is offline
 
Join Date: Sep 2002
Thumbs up

I second this request.
(but sorry, no money)
__________________
Lumina, aventurière des mondes fantastiques
Traductrice pour la version française de vB3
Jeux Online - vBulletin Francophone - Coeur Lumière
Reply With Quote
  #7  
Old 01 Feb 2004, 12:40
Nitesh Nitesh is offline
 
Join Date: Jun 2002
yeap i would be willing to pay aswell. I requested as soon as vb went to RC. Very important for us with the larger boards
Reply With Quote
  #8  
Old 01 Feb 2004, 12:53
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
Talking

Even invision powerboard 1.2 has this as standard
Attached Images
File Type: jpg untitled1.JPG (143.8 KB, 92 views)
Reply With Quote
  #9  
Old 01 Feb 2004, 12:58
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
What a shame that vB does not have it out of the box yet
Reply With Quote
  #10  
Old 01 Feb 2004, 15:39
YogiTW YogiTW is offline
 
Join Date: Jan 2004
I completed this hack earlier this week because our very large forums could not use the usual search engine. Since the license doesn't allow me to just send out my search.php and I don't have the time to package it up nicely it is now in someone else's hands to do that for me. Hopefully you'll see it soon.

It took me less than a day to put it together. It consisted mostly of commenting out a few hundred line of vB's phrase logic (which is replace by mysql's boolean search capabilities) and then changing a couple of lines of the SQL code. From the user's stand point it looks EXACTLY the same as the old search engine
Reply With Quote
  #11  
Old 01 Feb 2004, 15:54
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Real name: Andreas
Hmm, what about just runnig a diff on your modified search.php and the original?
Takes only secs to do and AFAIK would not break the license.

Maybe HTL could also be used?

Come on, this would definitly make MANY guys happy
Reply With Quote
  #12  
Old 01 Feb 2004, 15:58
mute mute is offline
 
Join Date: Dec 2002
Fear not. I'm working on it. I have a diff done, and I'm just waiting for my partner in crime to test it out, and to finish up the instructions.

If he would wake up, I could get this done with and we could all be happy

It took some work to get the diff done, because the version Yogi gave me was against gamma, and the change in code is huge (the new search.php is ~600 lines smaller), so I had to do a little manual patching. Maintaining it going forward might be a bit of a pain, we'll just have to see though.

I'll post more when I'm ready to post it.
Reply With Quote
  #13  
Old 01 Feb 2004, 17:38
msimplay's Avatar
msimplay msimplay is offline
 
Join Date: Aug 2002
i'd like to donate to the hack creator let us know when your ready
Reply With Quote
  #14  
Old 03 Feb 2004, 07:05
forumdude's Avatar
forumdude forumdude is offline
 
Join Date: Nov 2001
Originally Posted by mute
Fear not. I'm working on it. I have a diff done, and I'm just waiting for my partner in crime to test it out, and to finish up the instructions.

If he would wake up, I could get this done with and we could all be happy

It took some work to get the diff done, because the version Yogi gave me was against gamma, and the change in code is huge (the new search.php is ~600 lines smaller), so I had to do a little manual patching. Maintaining it going forward might be a bit of a pain, we'll just have to see though.

I'll post more when I'm ready to post it.
We (myself and mute) have a working version of the fulltext search for vb3 gamma. Unfortunately we don't have one for rc3 yet as the code changes to search.php in rc3 have proven to be an obstacle.

Our site is moving hosts this week so this hack will probably be put on a backburner until more time is taken for it. Do not fret, it will come.

I'm considering setting up a private forum in our community for those who have experience with hacking or would like to help troubleshoot, test and get this thing out into an available release asap. Anyone interested, please pm me.
Reply With Quote
  #15  
Old 04 Feb 2004, 20:07
jb605 jb605 is offline
 
Join Date: Feb 2004
Does this handle multibyte character language correctly? I am very interested in this as well, because the standard VB3 search does not work at all for multibyte language.

Thanks.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fulltext boolean search for vB v.1.5 JohnWoo vBulletin 3.0 Beta Releases 13 07 Mar 2004 07:14



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

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 11:02.

Layout Options | Width: Wide Color: