Similar Threads

[grindcore]

Quick question: Do the similar threads only work on 1 forum category?

For instance, I have a news forum and a general forum... Will it pull similar threads from both forums or just from the news OR general? I would love for it to pull relevant threads from both forums, so related news threads would pull if someone mentioned a topic in the general forums. Please let me know if this is already available and I just need to adjust my similar thread sensitivity or this is a new idea entirely.

Thanks and take care,
Jody

[dvb]

I've never used the 'similar threads' feature nor the plugin but some time ago I wanted to see how it's works so I checked the source and if I'm not mistaken it's based on an SQL query that checks ALL threads inside the database.

[grindcore]

Oh really? I don't think it's a plugin anymore and came stock on the mybb install. If it does pull threads from throughout the database, I will simply have to increase the sensitivity. I hope that's the case. Thanks for your help.

[grindcore]

I have just done some testing setting the sensitivity to '1' and it is still not pulling a similar thread with the same topic in a different category forum. Is there a way for 'similar threads' to display similar threads throughout the board? Thanks in advance!

[Dennis Tsang]

In showthread.php, find:

PHP Code:

        $query = $db->query("
            SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance
            FROM ".TABLE_PREFIX."threads t
            LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
            WHERE t.fid='{$thread['fid']}' AND t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}'
            ORDER BY t.lastpost DESC
            LIMIT 0, {$mybb->settings['similarlimit']}
        "); 


Replace with:

PHP Code:

        $query = $db->query("
            SELECT t.*, t.username AS threadusername, u.username, MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') AS relevance
            FROM ".TABLE_PREFIX."threads t
            LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid = t.uid)
            WHERE t.tid!='{$thread['tid']}' AND t.visible='1' AND t.closed NOT LIKE 'moved|%' AND MATCH (t.subject) AGAINST ('".$db->escape_string($thread['subject'])."') >= '{$mybb->settings['similarityrating']}'
            ORDER BY t.lastpost DESC
            LIMIT 0, {$mybb->settings['similarlimit']}
        "); 


[grindcore]

Thank you so much for this hack! It works perfectly.

Cheers,
Jody

[remshad]

Can i use this snippet to my MYBB 1.44

[MattRogowski]

Probably not.

[remshad]

do i get another method