=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 


[Schorsch]

thanks!! very nice modification

[TECK]

Originally posted by Rolodex
Another question ... why are you pointing the category background in your showthread_simularthreads template to:

<tr align="center" bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" background="https://vborg.vbsupport.ru/images/catagory_backing.gif">

Is there a reason for this, or are you "unknowingly" duplicating the same mistake in every update of this hack?

Because he wanted to see if you are checking everything and not install it no matter how.

Velocd, I will recommend your hack as HOTM.
Is one of the very few hacks I installed from many out there...

A small recomandation, try to use into the templates the direct variables pulled from the fetched array. No need to redefine them again inside. Look at my code example (permissions)...

Also, for NTLDR, the perms code listed few posts above are set based on my forum settings. I don't use access masks to save a query on all pages (everyone should do the same!!!) So yes, the perms will not be inherited.
Disable the masks, set your perms individually, or even better, write your own set of perms if you want an extra query on showthread.php file (for a total of 4, instead of 3, as it has now the hack).

[Velocd]

Thanks for the comments and suggestion, Teck

I've updated the .zip once again, fixing some minor stuff

[DrkFusion]

Great Hack, I installed the first one, I will install this one.

/me clicks install

[Bison]

Originally posted by Velocd
It's only one small mistake Rolodex, nobody is perfect, eh? I'm quite lazy as it is, so I'll update it next time I figure it need be. If it's gonna kill you, then well.. I bid you the best farewell j/k

It's not a point of it killing me dude, it just looked like you should have noticed this after the second update ... that's all.

And TECK, you have a way of budding in on sh*t that makes you look even more like the jerk you really are ... sometimes it best to shut the f*ck up when the attention is NOT pointed @ you!

[TECK]

Rolodex, is the way you posted acting like the smart ass. Instead of being normal and posting the error, like:
"Velocd, I noticed this error, I think it should be this way, not this way..."
you decided to show your "superiority".
My example, listed 2 lines above, is a constructive way to correct an issue, not your way, but you cannot realize this.
This guy Velocd made a great addition to vBulletin and instead of being nice and modest you act like the HTML wizo, when is such a small mistake.

Hey, I make those kind of HTML mistakes every day, I'm not as perfect as you are and "I don't notice everything" because, as Velocd said, I'm human. Making a good piece of code (like Velocd's) is alot more important in my eyes then a small template editing typo. I was looking for a solution like this and he made it easy for me because I didn't know I could run a query like the one he wrote... so I also helped him with the perms to make this hack a really good one.
You are right about one thing, I shouldn't waste my time posting to those kind of people like you.

[TheComputerGuy]

I use the Forum Jump, and tried to do what you said to do on page 2...yet..my forumjump still does not show properly...any ideas...

[TECK]

Place the code just about the eval(); and unset the perm and forum cache:

unset( $iforumcache );
unset( $ipermcache );

// Velocd's code here...

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

It should take care of the problem.

[DrkFusion]

Thanks teck, I was having the same error.

Regards

[NTLDR]

Originally posted by Velocd
@NTLDR: When you say inherited permissions, do you mean specific permissions geared to user groups? Also, can you give an example of how it is not working? I have user group and forum permissions set, and this hack is working correctly--unless I am overlooking something.

Example Structure:

-Catagory
--Forum 1

If I set the canview permission for Catagory to no for a usergroup, when using the forum that usergroup cannot see Forum 1, however threads in Forum 1 will still show up as similar threads even if though they can't access the thread.