=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]

Alright, the .zip has been updated with version 2.1.

Updated:
+ Added permission check, with thanks going to Teck for supplying the code.
+ Enhanced "last poster" information, requested by Boofo
+ Updated screenshot

To upgrade from V2:

Just update the template1.txt and the codechunk.txt over the previous code.

[Velocd]

Originally posted by xware
phpmyadmin said:
The used table type doesn't support FULLTEXT indexes
Why?

What version of MySQL & vBulletin are you running?

[TECK]

[high]* TECK clicked Install
[/high]
Btw, the perms will add 2 queries, for a total of 3. But is better then editing every time the showthread.php, once you change the perm settings.

[xware]

Originally posted by Velocd


What version of MySQL & vBulletin are you running?

PHP v4.2.2
mysql v3.23.54

[Velocd]

What about your vBulletin version? This hack has been tested on 2.2.6 and 2.2.9, thus suggesting it should work for 2.2.7 and 2.2.8 as well. If there are issues with older versions, I'll need to modify the vB database info of this hack.

[TECK]

Originally posted by xware

PHP v4.2.2
mysql v3.23.54

Make a file with the content:

<?php
error_reporting( E_ALL & ~E_NOTICE );
include_once( './global.php' );

cpheader( '<title>Run Query</title>' );

$runquery = "ALTER TABLE thread ADD FULLTEXT( title )";
$DB_site->reporterror = 1;
$DB_site->query( $runquery );

print_r( 'Query successful:<br>' );
print_r( '<font face="Courier New"> ' . $runquery . '</font><br><br>' );
print_r( 'Do not forget to delete this file.' );

cpfooter();
?>

Save it as [high]doquery.php[/high] and upload it onto your /admin folder.
Once uploaded, load it through your browser and let me know if you get any errors. If you do, post them here...

[TECK]

Velocd, is working on 2.2.8 for sure.

[xware]

Originally posted by Velocd
What about your vBulletin version? This hack has been tested on 2.2.6 and 2.2.9, thus suggesting it should work for 2.2.7 and 2.2.8 as well. If there are issues with older versions, I'll need to modify the vB database info of this hack.

my vb is 2.2.9 and phpmyadmin is 2.2.5

[TECK]

Forget about phpmyadmin, do what I asked you... please.

[xware]

Originally posted by TECK

Make a file with the content:

<?php
error_reporting( E_ALL & ~E_NOTICE );
include_once( './global.php' );

cpheader( '<title>Run Query</title>' );

$runquery = "ALTER TABLE thread ADD FULLTEXT( title )";
$DB_site->reporterror = 1;
$DB_site->query( $runquery );

print_r( 'Query successful:<br>' );
print_r( '<font face="Courier New"> ' . $runquery . '</font><br><br>' );
print_r( 'Do not forget to delete this file.' );

cpfooter();
?>

Save it as [high]doquery.php[/high] and upload it onto your /admin folder.
Once uploaded, load it through your browser and let me know if you get any errors. If you do, post them here...

The used table type doesn't support FULLTEXT indexes
Same error...
Maybe I must check my thread table.