=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 


[Velocd]

xware, back up your database just incase of any freak errors occur, and then run this query to convert to MyISAM:

PHP Code:

ALTER TABLE `thread` TYPE = MYISAM 


[xware]

Originally posted by Velocd
xware, back up your database just incase of any freak errors occur, and then run this query to convert to MyISAM:

PHP Code:

ALTER TABLE `thread` TYPE = MYISAM 


Works well now.
Thank you!

[NTLDR]

Originally posted by Velocd
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

This isn't true for me, it works fine after updating from your old version without any new posts being made

I've changed:

PHP Code:

ORDER BY dateline 


to:

PHP Code:

ORDER BY dateline DESC 


This way I get the most recent matches as oposed to the oldest matches (IMO seems more sensible that way).

[high]* NTLDR clicks install [/high]

[Boofo]

The line you changed was already in the version I downloaded last night. Is there another version out?

When I put the code in the old spot (from the first version) it also worked without having to update anything. I could never get it to work under the "Show Posts" area, only under the "Show Threads" area. Could that have something to do with it?

[Velocd]

It's not suppose to go under the "Show Posts" area, this hack is meant to show when viewing a thread, therefore it goes in the "show threads" area. Check the new version and its more clear in the instructions now.

In the original version I did have your suggestion NTLDR, but for some reason took it out upgrading. It has been re-added.

[Boofo]

I couldn't find the line in the "Show Threads" section (it was only in the "Show Posts" section for me) to add the codechunk to so I added it ABOVE this piece of code (like you had in your release of the first version):

if ($noshutdownfunc) {
  $DB_site->query("UPDATE thread SET views=views+1 WHERE threadid='$threadid'");
} else {
  $shutdownqueries[]="UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='$threadid'";
}

if ($bbuserinfo[cookieuser]) {
  set_bbarraycookie('threadview', $threadid, time());
}

That might make it easier for everyone to find.

Also, I do not have a "$discluded" variable to set at all in the codechunk file.

[Boofo]

Ok, another problem. I lost the forums listing in the forumjump now. When you view a thread, they are no longer there. They are there when viewing a forum, though. Any idea on how to fix this?

[Bison]

For some reason, this version doesn't work as good as the last one ... I get all sorts of thread title matches that don't have any simularities!

What thread titles is this version trying to read? Cause it aint reading them right!

[revert to original in a hurry!]

[Boofo]

Rolodex, try putting the chunkcode above this line and see if that helps. It fixed my forumjump problem and the threads are only showing similar threads if they really ARE similar. Let me know if it works for you.

eval("dooutput(\"".gettemplate("showthread")."\");");

[Velocd]

It's much more accurate for me, not to mention the pages load way faster ^________^

Boofo, refer to the 2nd page about your problem with the forum jump, that issue was already brought up.