=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 


[Gutspiller]

Originally posted by Faranth
.

Quit spamming Faranth. Sh|t. You fill my email box up and waste my time for me to come to the thread to see what people have said and it's just a F'ing period. :tired:

[Mike11212]

anyone know how to hide specific forums?

[FleaBag]

Finally got this working in 2.3.0... I think the Attachments As Files hack was messing it up.

[Shepski]

marvelous hack, installed on my v2.2.6 with no problems at all

well done m8

[PurpleCow]

Does this work with the current stable release of vB 2.3.0 ??

I have downloaded this and would like to install !

Thank much

[AlexanderT]

it works in 2.3.0.

[Mireade]

Very great hack !

What about putting this kind of possibility on a non vb page ?
Would it be difficult ?

And another suggestion to make it more "server friendly" :

Would it be possible to have just a link on which the user could click to get the related threads (so the query would not be systematic but just on demand) ?

Thank you

[ChurchMedia]

I'm really looking forward to getting this to work. I'm getting this error, however:

Fatal error: [] operator not supported for strings in /path/to/showthread.php on line 499

I'm running MySQL 3.23.41. I can send my showthread.php if it would help.

Thanks!!

[hypedave]

I have this hack running fine on one of my boards, I did the same install on another board, and my similar threads are not showing up, here is a link to check it out

http://boards.bluegoop.net/showthrea...threadid=10607

at the bottom you will see that it shows the Similar threads part

[Vindicator]

I have followed the instructions over and over, but I simply don't get an output. Seems to make no difference what so ever




Edit:
I have the obligitory $similarthreads in the showthread template, but this generates nothing.

Edit:
Sorted, started with a clean showthread.php file.

Thanks.

Vindi