I am hoping to do something really simple. I want to show the # of Flags per user in the forums, and on the profile page on my site. This way on the forums, you could see "Joe" has a collection of "32" items. Seems really simple, but I am not exactly sure how to do it (views?). Also, would there be anyway to cache this simple number so there wouldn't be lots of calculations to load a page like the forums?

Thanks

Comments

quicksketch’s picture

quicksketch
he/him
commented
Category: feature » support

This is essentially a theming request. If you want to get the number of flags you can use code like the following:

$flag = flag_get_flag('name_of_your_flag');
print $flag->get_user_count($user->uid);

This is not cached. Unfortunately this particular request there isn't actually a column or field that stores this exact number anywhere, it's done through a COUNT() query, so you can't build it in Views without using something like Views Calc or Views Group By. Either way I don't think Views would be appropriate for showing this count (though it is great if you want to list out the items that a user has flagged).

sammyman’s picture

sammyman commented

For some reason that didn't work. I used $account_id (User ID number for the author), so it would pull just info for the author of that post, but it still doesn't work. Any idea how to tweak this to pull the flag #'s?

<?php
$flag = flag_get_flag('friend');
print $flag->get_user_count($account_id);
?>

Edit: Strange, it is working for other flags, but not "friend"... Any idea why "friend" would be different.

quicksketch’s picture

quicksketch
he/him
commented

You're sure this is the count you want? This function will get you the number of items that the user with ID $account_id has flagged. So if "Joe" hasn't yet flagged any friends, this will be 0. It's not the number of times Joe himself has been flagged (that's $flag->get_count($account_id)).

sammyman’s picture

sammyman commented

Thanks for your help quicksketch. I tried the get_count like you suggested and it returned 0 as well. I guess I don't understand how the friend flag works, who is flagged, who is flagging.

I do want to give a count of the total #'s a user has been flagged as a friend I guess (how popular they are). Weird thing is that I am pretty sure the code was working and stopped for some reason....

sammyman’s picture

sammyman commented

It appears that this code counts the number of users that they have invited to be friends, NOT users that have accepted that friendship. Once the invitations have been accepted, the number goes to 0. So I guess I will keep trying to figure it out. Thanks for all the help.

quicksketch’s picture

quicksketch
he/him
commented

My guess is that there is a second flag added by flag_friend that is actually used to store "accepted" friends. But I'm not sure how flag_friend works.

sammyman’s picture

sammyman commented

It looks like it is stored in flag_content. It is a "user" content type, rather than "node" content type like the rest of my site. I see the fid # is 5 too, but I have no idea how to access the data.

quicksketch’s picture

quicksketch
he/him
commented

Look up what fid 5 is in the flags table, then get the name of the flag from there.

quicksketch’s picture

quicksketch
he/him
commented
Status: Active » Closed (fixed)

Closing after lack of activity.