New Posting Features - [Ajax] Check for similar thread before posting a new one

You love the 'similar threads' function and you are sick of duplicate threads just because your users don't use the search function?

Why not just combine them?

This Add-on will grab the thread title the user typed in and it will load a small box (using Ajax magic ) with 5 similar threads just like the 'similar threads' function that you can normally find under an already posted thread.

The box also tells the user to search through the similar threads first BEFORE starting a new one.


Features:
- no edits whatsoever needed, just import the product file, enable the Add-on and it works (well, it should )
- you can turn it off for certain forums or
- you can turn it off completely without leaving any code that messes your templates/files
- it can be translated
- don't like it anymore? Remove the product and you'll never see that Add-on again


Known issues:
- none


Things to consider:
It uses jQuery to get the information from ajax.php. jQuery is great and you can do many great things with it and unlike the vBulletin method it's quite easy to understand.
The jQuery file is compressed and only 20kb large.
To download the file, visit the homepage at http://jquery.com/
The link to download the file is on the right hand side.

Here's the version I use: http://code.google.com/p/jqueryjs/do....1.3.1.pack.js

Just download it and put it into the 'clientscript' folder without renaming the file.


Installation:
Download jQuery as described above.
Import the attached file using the Product Manager. Go to your vBulletin settings and search for 'Check for similar threads?'. Enable it.


Important:
It adds 2 new templates, it changes 1 template and it edits 2 files. I highly doubt that it will break you vBulletin but do a back-up and be on the safe side.



Version history:
1. initial release
2. current release
*** fixed some browser issues. The attached file is up to date.





How to fix the Opera problems in the first release:
The first release of this Add-on didn't work on Opera. To fix the problems, please follow these steps:
Open the template 'mrnasesimilarthreadcheck_header' and REPLACE the content with this code:

    <script type="text/javascript" src="clientscript/jquery-1.1.3.1.pack.js"></script>
    <script type="text/javascript">
        $(function(){
            $("#inputthreadtitle").bind("blur", function(){
                var value =$(this).val(); 
                $('td#similarthreadcheckcontent').html('<img src="$stylevar[imgdir_misc]/13x13progress.gif" />');
                $.ajax({
                    type: "GET",
                    url: "ajax.php",
                    data: "do=getsimilarthreads&title="+value,
                    success: function(msg){
                        $('td#similarthreadcheckcontent').html(msg);
                         }
                });
            });
        });
    </script>

The attached file is up to date.


Support will only given to those who have clicked 'install'.

[paulnp88]

Originally Posted by MadK

I just keep getting this on every topic:

No similar topics found. Start your thread and let the users answer your questions.


Yet, the name is exactly the same.

I have the same problem, any solutions?

[MadK]

Argh! Anybody.

[HaCaoChien]

Do not works with Vietnamese characters Y__Y

[toddos]

pls update it, it doesnt work, just the start-text, but it isnt really searching !

Dominik, MrNase, bitte bereinig das irgendwie, es steht nur der Standarttext da, aber er sucht nichts über Ajax ?!

[zeus_r6]

Works

[heeroyun]

Installed , I followed the instrution step by step but still , the it won't work . The check for similar thread setting just didn't appear

[codershark]

dont works on vb 3.7 beta 6

[ivanstanchev]

I impoted the product,but how to enable it ?In my vbulletin options i cant find it ?

[yakusasc]

Hi,

When we put a ' in the topic tite, we get a database error :

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT * FROM ruleshack 
			WHERE (fileurl LIKE 'http://forums.website.com/ajax.php?do=getsimilarthreads&title=alpha%20'test' AND exactmatch = 1 ) 
			OR (fileurl LIKE 'http://forums.website.com/ajax.php%' AND exactmatch = 0 ) AND active = 1 ORDER BY ruleid;

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'test' AND exactmatch = 1 ) 
			OR (fileurl LIKE 'http://forums.website.' at line 2
Error Number : 1064
Date         : Monday, March 17th 2008 @ 09:02:00 AM
Script       : /ajax.php?do=getsimilarthreads&title=alpha%20'test

Classname    : vB_Database

[F0xy]

Originally Posted by ivanstanchev

I impoted the product,but how to enable it ?In my vbulletin options i cant find it ?

to enable the product you need to go to admincp>vbulletin options>Message Posting and Editing Options>Check for similar threads? and enable it