Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

This category contains miscellaneous, uncategorised user contributions, (templates, modules, plugins and hacks) relating to older versions of Kunena that are no longer supported.

This category may also contain a few topics relating to K 1.6 that may have been moved here possibly by mistake.

The topics in this category are for historical interest only. Owing to the structural differences between K 1.6 and K 1.7, these ideas in these topics will not work with later versions and, for that reason, the topics are locked.

Question relative posts hack 0.1 beta

guerilla
Topic Author
Offline
Senior Member

15 years 9 months ago #52717 by guerilla

Replied by guerilla on topic Re:relative posts hack 0.1 beta

gonzaunit wrote: you can update this hack for Kunena 1.6?

stable version released?

what is PARDUS?
pardus 2008 review

Please Log in or Create an account to join the conversation.

gonzaunit
Offline
Senior Member

15 years 9 months ago #52725 by gonzaunit

Replied by gonzaunit on topic Re:relative posts hack 0.1 beta

there is no stable version but you can try Kunena alpha version 2 as published

Please Log in or Create an account to join the conversation.

mike2m
Offline
Junior Member

15 years 9 months ago #52766 by mike2m

Replied by mike2m on topic Re:relative posts hack 0.1 beta

Hi,

Did you write:

ALTER TABLE jos_fb_messages ADD FULLTEXT (subject)

ALTER TABLE jos_fb_messages_text ADD FULLTEXT (message)

that's a reply he received:

This is the optional Forum header for the Suggestion Box.

Please Log in or Create an account to join the conversation.

gonzaunit
Offline
Senior Member

15 years 9 months ago - 15 years 8 months ago #53558 by gonzaunit

Replied by gonzaunit on topic Re:relative posts hack 0.1 beta

Tested Kunena 1.6 Beta 1
Look in components \ com_kunena \ template \ default \ view \ "view.php"

Code:

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

and paste below

Code:

<?php
		$id 			= $this->thread;
		$catid 			= $this->catid;
 
		$this->db->setQuery("SELECT a.*, b.* FROM #__kunena_messages AS a LEFT JOIN #__kunena_messages_text AS b ON a.id=b.mesid WHERE a.id='{$id}' AND a.hold='0'");
		$this_message = $this->db->loadObject();
 
		$this->db->setQuery("SELECT * FROM #__kunena_categories WHERE id='{$catid}'");
        $objCatInfo = $this->db->loadObject();
 
		$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=1; //set 1 if you wanna show only topics, set 0 to show relative messages directly
		$limit = 5; //set number of relative messages 
 
		$parent = ($topics_only == 1) ? " AND parent=0 " : "";
 
		$query=("SELECT id, subject, name, time as zaman, catid, userid, MATCH(t1.message) AGAINST('".addslashes($this_message->subject)."') as oran1, MATCH(t2.subject)  AGAINST('".addslashes($this_message->subject)."') as oran2 FROM 
		#__kunena_messages_text as t1 INNER JOIN #__kunena_messages as t2 ON t2.id = t1.mesid 
		WHERE (MATCH(t1.message) AGAINST('".addslashes($this_message->subject)."') > $percent OR MATCH(t2.subject) AGAINST('".addslashes($this_message->subject)."') > $percent)  AND t2.thread <>" . $this_message->thread . $parent . " ORDER BY oran2 DESC, oran1 DESC LIMIT $limit;");
 
 
		$sim_message = $this->db->setQuery($query);
		$sim_message = $this->db->loadObjectList();;
 
		if (count($sim_message)> 0)
		{
		echo '<div class= "kblock"><div class= "kheader"><h2><span>Relacionados</span></h2></div><div class= "klist-bottom"';?>
 
		<?php foreach ($sim_message as $sonuc) {
		if ($sonuc->oran1 > $sonuc->oran2)
		{
		$oran = $sonuc->oran1;
		}
		else {
		$oran=$sonuc->oran2;
		}
					echo "<span><b><a  rel=\"follow\" title=\"".$sonuc->subject."\" href=\"".CKunenaLink::GetThreadPageURL('view', $sonuc->catid, $sonuc->id, $page, $this->limit)."\">".$sonuc->subject."</a></b></span><br>";
				}
echo "</div></div>";
		}
?>

in Mysql

Code:

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

Last edit: 15 years 8 months ago by gonzaunit.

The following user(s) said Thank You: tsetsoo

Please Log in or Create an account to join the conversation.

Time to create page: 0.244 seconds