Question [hack] Related posts for 1.6

<!-- B: RELATIVE POSTS HACK BY GOLGE --><?php //similar posts hack by guerilla $percent=4; //similarity percentage, increase for sensitive matching. for example 10 is 10% match, 50 is 50% match, 100 is one o one $limit = 5; //set number of relative messages $query= "SELECT id, subject, name, time as zaman, catid, userid, MATCH(t1.subject) AGAINST ('$this->kunena_topic_title') AS oran FROM #__kunena_messages as t1 "; $query.= "WHERE MATCH(t1.subject) AGAINST('$this->kunena_topic_title') >= $percent AND id<> $this->thread "; $query.= "ORDER BY oran DESC LIMIT $limit;"; $sim_message = $this->db->setQuery($query); $sim_message = $this->db->loadObjectList(); echo mysql_error(); if (count($sim_message)> 0) { echo '<div class="kblock"><div class="kheader"><h2><span>Relative Posts</span></h2></div></div><div class= "klist-bottom"><table width="100%"><thead>'; echo '<tr><td><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) { echo '<tr><td><a href="index.php?option=com_kunena&Itemid='.$sonuc->id.'&func=view&catid=' . $sonuc->catid . '&id=' . $sonuc->id. '">' . $sonuc->subject . '</a></td>'; echo '<td>' . $sonuc->name . '</td>'; echo '<td align="right">' . CKunenaTimeformat::showDate($sonuc->zaman, 'config_post_dateformat') . '</td>'; echo '<td align="right">%' . (int)$sonuc->oran . '</td></tr>'; } echo "</table></div>"; } //similar posts hack by gerilla ?><!-- F: RELATIVE POSTS HACK BY GOLGE -->

ALTER TABLE jos_kunena_messages ADD FULLTEXT(subject) ALTER TABLE jos_kunena_messages_text ADD FULLTEXT(message)