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

Question Jawards

squale
Offline
Junior Member

13 years 7 months ago #21 by squale

Replied by squale on topic Re:Jawards

thanks it works

little request : is it possible ton show award under user's signature ? i was able to do that with K 1.5

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

Lodder
Offline
New Member
Co-Founder of JoomJunk

13 years 2 months ago #22 by Lodder

Replied by Lodder on topic Re:Jawards

Hi,

Thank for sharing the code to integrate jAwards with Kunena 1.6. The is however one question I would like to ask and that is, what do I have to add to the code so that there are for example 5 award image per line?

www.joomjunk.co.uk

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

kj2010
Offline
Junior Member

12 years 10 months ago #23 by kj2010

Replied by kj2010 on topic Re:Jawards

Hello,
many thanks to squale for the code! It works fine in my forum!

But i have a question. I searched and tried several options/functions but it seems that i'm too dumb to get it working. :blush:

My problem: I won't the awards sorted by RANDOM.
I would like to sort them by "name" ASC or maybe by their SQL id ASC.

It is about this code:

Code:

"\n ORDER BY RAND() LIMIT ".$number_medals;

Anyone here who can give me a quick hint?
I would appreciate it a lot. Thanks in advance!

greets!

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

kj2010
Offline
Junior Member

12 years 10 months ago #24 by kj2010

Replied by kj2010 on topic Re:Jawards

Hello, it's me again and i'm sorry to bump this thread here. Maybe noone noticed my question.
Hopefully there is anyone here in this forum who can help with my issue.
I would be really happy

Thanks in advance!

kj2010 wrote: Hello,
many thanks to squale for the code! It works fine in my forum!

But i have a question. I searched and tried several options/functions but it seems that i'm too dumb to get it working. :blush:

My problem: I won't the awards sorted by RANDOM.
I would like to sort them by "name" ASC or maybe by their SQL id ASC.

It is about this code:

Code:

"\n ORDER BY RAND() LIMIT ".$number_medals;

Anyone here who can give me a quick hint?
I would appreciate it a lot. Thanks in advance!

greets!

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

xillibit
Offline
Administrator

12 years 10 months ago #25 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

12 years 10 months ago - 12 years 10 months ago #26 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: 12 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

12 years 10 months ago #27 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

12 years 10 months ago #28 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

12 years 10 months ago - 12 years 10 months ago #29 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: 12 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

12 years 10 months ago - 12 years 10 months ago #30 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: 12 years 10 months ago by C0n.

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

Time to create page: 0.744 seconds