I tested the latest dev, and played around with the vocab integration. I have two specific needs, that is:

1. count the total number of badges for each given user, (e.g. Badges: 12)
2. count the number of badges belonging to each category that the user earns, (e.g. Badges on Contribution: 5, etc.)

Any help would be very much appreciated. Thanks

Comments

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Active » Postponed (maintainer needs more info)

Where should this be displayed? Badges are already listed on the user page.

gausarts’s picture

gausarts commented

I wanted to display it via node.tpl if any snippet I can use there.

Thanks

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented
Status: Postponed (maintainer needs more info) » Postponed

For sites that have a lot of badges, that could be pretty database intensive unless we saved that information in a table and updated it on the fly. I think Likeless will have to decide on this one.

gausarts’s picture

gausarts commented

Okay. Thanks for the info.
On my current implementation, some user info, which hopefully can include these badges as well, are loaded via cTools ajax when user hover over pictures. This info can be loaded on node.tpl, comment.tpl, views listing or anywhere the trigger (picture) resides.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented 
    $count = db_result(db_query("SELECT COUNT(*) FROM {user_badges_user} WHERE uid=%d", $uid));

You can probably also figure out how to join it on taxonomy.

gausarts’s picture

gausarts commented

Thanks. I really appreciate it.
This will be the last missing piece I need to integrate into the user box.

sophievn107’s picture

sophievn107 commented

subscribing, I also want to do the same thing. can you please more specific on the changes made?

gausarts’s picture

gausarts commented

Sorry, not a chance yet. I am in the process of upgrading to drupal 7, so this one must also wait for the port.

nancydru’s picture

nancydru
she/her/hers
Primary language English
Location Boston
commented

When my massive changes for D7 get committed, the user object will contain $user->badges_all and $user->badges (limit applied), so you won't have to query the user_badges_user table.

[EDIT]
It will also have $user->badge_count.

shabana.navas’s picture

shabana.navas commented
Status: Postponed » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.