=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 


[TheComputerGuy]

TECK, thanks for offering what you did, but it doesn't work properly, I tried to uninstall the hack and my forum jump does not work

[TECK]

Ok, I enabled the forumJump just for you. I will take it off tomorrow...
Use tester/test to login onto my board and see that it's working.

View this forum, for example:
http://www.teckwizards.com/forum/for....php?forumid=5

[Velocd]

@sparky2: yeah, that is certainly possible, but that would cancel out the purpose of this hack being named as "vB3 Similar Threads," as it is suppose to visually look and function like the vB3 feature over at vBulletin.com. Despite the fact that I use a mySQL function MATCH..AGAINST which is probably not as efficient compared to the method Freddie used, which he explained here, but oh well.... this version works well enough for me.

Feel free to make that request yourself, as it surely isn't difficult to do.

[TECK]

Well, in VB2 the word table is not indexed... and I think that Freddie used there several LEFT JOIN's which also affect the performance...

[TheComputerGuy]

TECK, you da man as usual, I will retry on a clean showthread file. Your recommendation for where to place it...Do i place chunk.txt right above the last line? I believe that is the part I got confused on

Thank you so much for helping me.

[TECK]

Originally posted by TheComputerGuy
Your recommendation for where to place it...Do i place chunk.txt right above the last line? I believe that is the part I got confused on

Thank you so much for helping me.

Notice the [high]// Velocd's code here...[/high] part? Replace that line with the chunkcode (that makes me think of biscuits, heh)...

[sparky2]

Originally posted by TECK
Well, in VB2 the word table is not indexed...

Huh???

run this query:
show create table word

and you'll see that both (of the 2) columns are indexed

[Velocd]

Actually it might vary from version sparky2, as both of my columns in the word table are not indexed (running on 2.2.6)

It's not that significant anyway

[VirtueTech]

It appears "freddie" was right that this was not the most optimized way to go about "similar threads".

Query: SELECT

thread.threadid,thread.lastposter,thread.title,thread.postusername,thread.replycount,thread.

lastpost,thread.postuserid,
			thread.dateline,forum.title AS

ftitle,forum.forumid,forum.parentlist
			FROM thread
			LEFT JOIN forum ON (thread.forumid=forum.forumid)
			WHERE thread.threadid<>256184 AND thread.forumid IN( 192,62,186,65,64,60,187,271,59,61,138,228,127,214,265,67,68,69,70,71,72,73,74,123,142,232,137,227,66,212,145,234,166,125,216,124,215,141,231,139,229,144,233,126,213,131,219,247,129,130,218,146,235,128,217,269,270,140,230,147,236,143,221,135,225,136,226,165,168,167,164,132,220,133,222,134,223,177,178,183,267,13,190,18,162,2,1,12,15,9,4,169,25,188,29,10,19,24,23,33,31,30,53,39,55,56,172,41,42,17,7,27,37,26,16,28,20,32,38,47,179,44,173,303,22,46,45,11,5,51,170,49,50,52,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,149,150,151,152,148,153,154,155,156,157,158,159,160,161,224,174,175,171,180,3,185,264,34,204,21,195,57,304,194,197,198,199,196,200,208,205,201,202,203,268,207,210,211,266,305,273,277,289,278,274,276,275,288,293,292,291,279,286,287,285,298,282,284,290,299,302,301,300,295,297,296 )
			AND MATCH(thread.title) AGAINST ('old stock from closed store-cocker stuff, lots of redz and more')
			AND thread.open<>10
			AND thread.visible=1
			ORDER BY dateline DESC
			LIMIT 4
Time before: 0.39137995243073
Time after:  3.3633810281754

Check out the delay!

Nice try though. I was excited that you had made this hack...too bad I can't use it. Thanks anyway.

[Velocd]

Ah yes, but I could defiantly understand why with your forums VirtueTechy--they're massive

Then again, this version of the hack is more improved from the last, in the major effect that it will compare threads to the current thread viewing until it has gathered whatever you set as "LIMIT", in your case 4. (in contrast to the old version where it would retrieve ALL threads, then compare). Not to mention, your forum must have dozens of threads with similar titles, so this hack shouldn't have a problem finding 4 similar threads and quickly. Then again, each similar thread could be seperated by 300 non-similar threads, thus having to read more.

This hack still proves very useful for the smaller forums, such as mine with 1,938 threads and not the slightest decrease in performance.