=V.2= vB3 Similar Threads

vB3 Similar Threads =Version 2=
by Velocd

This hack, as well all my other vB2 hacks, I no longer provide support for (being I run vB3 and it's too much hassel to debug vB2). When vB3 Release Candidate comes out, by request I might convert some of my hacks.


Update - Version 2.1
View this post for complete information.


Description:

I recoded the old vB3 Similar Threads hack earlier today, realizing a much better and enhanced method of making it work.
Also, I made a new thread for this hack mainly so it would be better known, since the old one had many unsolved issues.

Improvements:

• It no longer compares threads via a similarity or priority level, but rather using a MySQL string-comparison function.
  I experienced no slow downs on any pages, and many of my pages seem to be generating .20 faster (from the old version).
• The comparison between threads is even more accurate and efficient, and best of all requires no toggling of a priority setting like the previous version. The threads are now searched via the one and only query, making things faster.
• The hack has been tested on 2.2.6 and 2.2.9, and also does not require the use of PHP function trim(), so older versions of PHP should deal no trouble.
• The overall appearance of the hack has been enhanced to look more vB3 as well

The MySQL function MATCH..AGAINST requires MySQL version 3.23.23 or later, else the hack will not operate.

Screenshots:

Refer to the .zip, they are located inside.


Upgrading?

If you are upgrading from the old version, just replace the codechunk.txt file in the location of the old chunk, as well replacing the templates.

---------------

Remember, if you use this hack on your forum, please click the install button! ^__^

side note: once installed, the similar-thread box will not show until you start replying to threads or create new ones. I predict this has something to do with the altering of the field title to FULLTEXT

side note 2: if for some reason you are getting an error about FULLTEXT not being functionable on your thread table, you are running a non-MyISAM table type, and thus must be converted. Run this query to do so:

PHP Code:

ALTER TABLE `thread` TYPE = MYISAM 


[Vindicator]

This is wierd. I had it working. Made no further changes. Come to check the site 2 hours later and it's not showing again!!!

I'm the only person editing the site. All files are unchanged.

I've checked everything again, but no joy. This is being a right pain in the rear!

Edit:

Oh look, it fixed itself! Some wierd stuff going on with this hack

[Ninth Dimension]

nice hack, i've just installed it, but like many other people i've seen in this thread i can't get it to show any info. I believe that might be partly due to the forum having very few posts on it (i.e. it's a production site) but i'm making threads with similar titles and content in a bid to get it to show up and t's not doing anything.

can someone point me in the right direction? thanx.

[Ninth Dimension]

It's OK fella, i've got it working now, I was only using half the code needed, thank you very much, this add's an extra dimension to the forum

[drumsy]

How do I undo this query?

ALTER TABLE `thread` ADD FULLTEXT(`title`);

[Chris-FH]

Hello Folks...

I love this hack, it´s great...

But there is an interesting problem with the permissions. For my registered members, it´s all okay, but UNregistered people can see all threads including the internal ones...

The unregisterd have more rights than registered, I think to much... ;-)

Can someone help me?

vB: 2.30

C.

[PsyBlast]

i've followed the directions perfectly, but when I view a thread nothing . . . no similar threads . . .
http://www.gameinsider.net/forums/sh...s=&threadid=32 to see help please . .

[chrisvonc]

Can anyone use the search/results features of this hack to replace the search/results feature in the Similar Topic hack?
https://vborg.vbsupport.ru/showthrea...threadid=54308

I find boths hack amazingly helpful on my forum but the Topic hack has stopped working 90% of the time. Since this one seems real solid and works everytime can this somehow be appiled to the Similar Topic hack?

[tpearl5]

Is there an easy way to exclude certain forums?

[tpearl5]

Nevermind, I figured it out.

[Chris-FH]

Please tell us tpeal5...

C.