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

Question Jawards

More
14 years 10 months ago #98595 by xillibit
Replied by xillibit on topic Re: Jawards
To ordering items by ASC or DESC, you need to do the following :
Code:
ORBER BY b.name ASC

instead of
Code:
ORDER BY RAND()

I don't provide support by PM, because this can be useful for someone else.

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

More
14 years 10 months ago - 14 years 10 months ago #98607 by kj2010
Replied by kj2010 on topic Re: Jawards

xillibit wrote: To ordering items by ASC or DESC, you need to do the following :

Code:
ORBER BY b.name ASC

instead of
Code:
ORDER BY RAND()


Thanks a lot for the fast reply but this does not work.
When i replace this line then the awards are gone. :S


*edit:
It works! :)
There was a typo in your reply.
You wrote "ORBER"
Now it works. You're my hero! ;) Thanks a lot! Problem solved!
Last edit: 14 years 10 months ago by kj2010.

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

  • C0n
  • C0n's Avatar
  • Offline
  • Premium Member
  • Premium Member
  • Only the strongest will survive
More
14 years 10 months ago #98626 by C0n
Replied by C0n on topic Re: Jawards
So is jawards compatible with kunena 1.6 ?

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

More
14 years 10 months ago #98648 by xillibit
Replied by xillibit on topic Re: Jawards

C0n wrote: So is jawards compatible with kunena 1.6 ?

With the hack, i think yes because i haven't tried it else kunena doesn't support jaward integration

I don't provide support by PM, because this can be useful for someone else.

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

More
14 years 10 months ago - 14 years 10 months ago #98651 by Lodder
Replied by Lodder on topic Re: Jawards

xillibit wrote:

C0n wrote: So is jawards compatible with kunena 1.6 ?

With the hack, i think yes because i haven't tried it else kunena doesn't support jaward integration


Yes, Jawards IS compatible with Kunena 1.6.4 and previous versions.
I have tested it on my site. If you want a preview then check my website.
www.blackpanthergaming.com
Code:
<?php // Hack for jAwards integration, displays some medals of the user for Kunena 1.6 $number_medals = 10; // number of medals to show $query = "SELECT b.image, b.name" . "\n FROM #__jawards_awards AS a" . "\n LEFT JOIN #__jawards_medals AS b ON b.id = a.award" . "\n WHERE a.userid=". $this->profile->userid . "\n ORDER BY RAND() LIMIT ".$number_medals; $database = &JFactory::getDbo(); $database->setQuery( $query ); $medals = $database->loadObjectList(); // URL links to the jAwards-Tab for Community Builder which displays all // medals of the user - change to another URL of needed $awards_url=JRoute::_('index.php?option=com_comprofiler&task=userProfile&user='.$this->profile->userid."&tab=getawardstab"); // CSS-class "ja_medals" allows individual styling of medal images and // container. "nobr" keeps the medals from breaking apart, display them // in one row. $msg_jawards = "<div class=\"ja_medals\">"; foreach ($medals as $med){ $msg_jawards.= "<a href=\"$awards_url\" title=\"$med->name\">" . "<img style='border:0px;padding:0px;' src=\"".KUNENA_JLIVEURL."/images/medals/".$med->image ."\" alt=\"".$med->name."\" />" . "</a>"; } $msg_jawards.="</div>"; unset($medals); echo $msg_jawards; ?>

Copy and paste this code in /components/com_kunena/template/default/view/profile.vertical.php on line 81 after:
<?php echo $this->profile->profileIcon('email'); ?>
</li>
Last edit: 14 years 10 months ago by Lodder.

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

  • C0n
  • C0n's Avatar
  • Offline
  • Premium Member
  • Premium Member
  • Only the strongest will survive
More
14 years 10 months ago - 14 years 10 months ago #98888 by C0n
Replied by C0n on topic Re: Jawards
Its not a automated awards system though you have to manualy select a user to award :O ?

I need a automated system :( manualy going through users and awarding them one by one is allot of effort :'( :blush:
Last edit: 14 years 10 months ago by C0n.

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

Time to create page: 0.269 seconds