<!-- F: List Actions Bottom -->

<?php
//similar posts hack by guerilla
 
$percent=5; //similarity percentage, increase for sensitive matching. for example 10 is 10% match, 50 is 50% match, 100 is one o one
$topics_only=0; //set 1 if you wanna show only topics, set 0 to show relative messages directly
$limit = 5; //set number of relative messages 
 
if ($topics_only = 1)
{
$parent =" AND parent=0 ";
}
 
$query=("SELECT id, subject, name, time as zaman, catid, userid, MATCH(t1.message) AGAINST('$this_message->subject') as oran1, MATCH(t2.subject) AGAINST('$this_message->subject') as oran2 FROM 
#__fb_messages_text as t1 INNER JOIN #__fb_messages as t2 ON t2.id = t1.mesid 
WHERE (MATCH(t1.message) AGAINST('$this_message->subject') > $percent OR MATCH(t2.subject) AGAINST('$this_message->subject') > $percent) AND t2.id <>" . $this_message->id . $parent . " ORDER BY oran2 DESC, oran1 DESC LIMIT $limit;");
 
 
$sim_message=$kunena_db->setQuery($query);
$sim_message = $kunena_db->loadObjectList();
echo mysql_error();
if (count($sim_message)> 0)
{
echo '<table class = "fb_blocktable' . $objCatInfo->class_sfx . '" id="fb_views" border = "0" cellspacing = "0" cellpadding = "5" width="100%"><thead><tr><th colspan="4"><div class = "fb_title_cover  fbm">';
echo '<span class = "fb_title fbl"><b>Relative Posts</b></span></div></th></tr></thead>';
echo '<tr class = "fb_sth"><td class = "view-th ' . $boardclass . 'sectiontableheader"><b>Subject</b></td><td><b>Author</b></td><td align="right"><b>Date</b></td><td align="right"><b>Similarity</b></td></tr>';
 
foreach ($sim_message as $sonuc) {
if ($sonuc->oran1 > $sonuc->oran2)
{
$oran = $sonuc->oran1;
}
else {
$oran=$sonuc->oran2;
}
            echo "<tr><td><a href=\"index.php?option=com_kunena&Itemid=" . KUNENA_COMPONENT_ITEMID . "&func=view&catid=" . $sonuc->catid . "&id=" . $sonuc->id. "\">" . $sonuc->subject . "</a></td>";
            echo "<td>" . CKunenaLink::GetProfileLink($fbConfig, $sonuc->userid, $sonuc->name) . "</td>";
            echo "<td align=\"right\">" . date(_DATETIME, $sonuc->zaman) . "</td>";
			echo "<td align=\"right\">%" . (int)$oran . "</td></tr>";
        }
echo "</table>";
}
//similar posts hack by gerilla
?>

 
ALTER TABLE jos_fb_messages ADD FULLTEXT(subject)
 
ALTER TABLE jos_fb_messages_text ADD FULLTEXT(message)