I am trying to display both the karma rank and karma total in the comments. So far, I've been able to display the user karma rank by inserting print user_karma_user_rank(array('uid' => $comment->uid)); into my comment.tpl.php, but I can't figure out how to do the karma total.

Thanks

Comments

mercmobily’s picture

mercmobily commented

Hi,

The function is user_karma_user_karma! :-D
Please confirm that this answers your question!

Merc.

jorgepg23’s picture

jorgepg23 commented

I tried that function earlier and it didn't work for me. It outputs the same number for all users (the highest overall karma value on the site). In other words, it displays 87 for everybody.

I noticed that when using the devel module to see the query info for each user's profile page that it seems to be getting the karma total from the votingapi_get_vote function. The query output for this function is SELECT * FROM votingapi_vote v WHERE content_type='user' AND content_id=3 AND value_type='karma_points' AND tag='karma' AND uid=1.

mercmobily’s picture

mercmobily commented

Hi,

I don't get it. The query above is actually correct: it's returning the vote given from user "1" (the karma system) to the user 3 (the user receiving the karma). It really oughtn't return 87 for everybody.

I ran this very query for Free Software Magazine and am getting normal values...

What do you get if you run:

SELECT * FROM votingapi_vote v WHERE content_type='user' AND value_type='karma_points' AND tag='karma' AND uid=1 limit 100;

...?

It's the same query, but without having the content_id constraint...

Bye,

Merc.

mercmobily’s picture

mercmobily commented

Hi,

Well...?

Merc.

mercmobily’s picture

mercmobily commented
Status: Active » Fixed

Hi,

I can only assume this is fixed.

Merc.

mercmobily’s picture

mercmobily commented
Status: Fixed » Closed (fixed)
NoRandom’s picture

NoRandom commented

I don't know much about php, actually a little more than copy-paste, but this is working for me:

print user_karma_user_karma($comment->uid);
mercmobily’s picture

mercmobily commented

Hi,

I am an idiot, and you are completely right.
I can be stupidly unhelpful at times.

Merc.