Kunena 6.3.0 released

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

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

14 years 4 months ago - 14 years 4 months ago #21 by guerilla

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

jeanpier biasiolo mérchan wrote:

I have not copied directly echo what you say. cite and your message to take the code, but I say it is best to upload a file and edited view.php? For those who do not know

i didnt integrate code to view.php, cos this is a version and template independent hack.

here you can download view.php for 1.5.7:
www.badongo.com/file/19107414

but you must run theese sql queries at your phphmyadmin:

Code:

ALTER TABLE jos_fb_messages ADD FULLTEXT(subject)

ALTER TABLE jos_fb_messages_text ADD FULLTEXT(message)

what is PARDUS?
pardus 2008 review

Last edit: 14 years 4 months ago by guerilla.

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

14 years 4 months ago #22 by jeanpier biasiolo mérchan

Replied by jeanpier biasiolo mérchan on topic Re:relative posts hack 0.1 beta

Gracias por el aporte

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

nttranbao
Offline
New Member

13 years 10 months ago #23 by nttranbao

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

Thank you. It works great on my Kunena 1.5.9. With small modifications on both language and view.php, I can have this function in different languages.

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

gonzaunit
Offline
Senior Member

13 years 9 months ago #24 by gonzaunit

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

you can update this hack for Kunena 1.6?

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

guerilla
Topic Author
Offline
Senior Member

13 years 9 months ago #25 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

13 years 9 months ago #26 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

13 years 9 months ago #27 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

13 years 9 months ago - 13 years 8 months ago #28 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: 13 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.553 seconds