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

xillibit
Offline
Administrator

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.

kj2010
Offline
Junior Member

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
Offline
Premium Member
Only the strongest will survive

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.

xillibit
Offline
Administrator

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.

Lodder
Offline
New Member
Co-Founder of JoomJunk

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>

www.joomjunk.co.uk

Last edit: 14 years 10 months ago by Lodder.

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

C0n
Offline
Premium Member
Only the strongest will survive

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

?

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