COUNT'ing usergroups...

[Tryfwar]

Is there a way that i can have the total number of members belonging to a usergroup displayed in the header of each usergorup table listed in showgroups.php ?

I don't want to create a seperate SQL query for every instance of a usergroup, but would rather somehow have a variable placed in the WHERE clause which is then later defined.

Thanks

[assassingod]

This is easy but since your forums is vB3, you'll have to wait til vB3 hacking is allowed

[Tryfwar]

aarrrrrrrrrrrrgggg! lol

Could you e-mail me?

nick@mortalis.com I would greatly appreciate any help

Its really only MySQL syntax that i need, not template or anything vB specific.

Heres what i have atm for a custom script (based on showgroups.php) which produces this : http://www.mortalis.com/?mainDiv=/forums/rollcall.php

As you can see i have a created 3 queries to produce the totals for active, inactive & all, but have not been able to think up a count query for each of the classes.

[NickPR]

bump ! been a while and vB3 is out now. Anyone able to help me still?

[Xenon]

if you open showgroups.php

you'll find that line:

PHP Code:

        eval('$usergroups .= "' . fetch_template('showgroups_usergroup') . '";'); 


before that add:

PHP Code:

$num_users = count($users); 


now you just have to add $num_users into the showgroups_usergroup template, where you want to ahve it

[NickPR]

it just returns 1. I have to admit that im using a very customised version of the showgroups.php and your probably not supposed to support me Its based on an older vb too now. So ill modify it so that it resembles the v3 more and try again.

Thanks for your reply

[the Sandman]

This works great... except the count is incorrect for the "Moderators" category that includes everyone who is assigned to Moderate Forums regardless of usergroup. Any way to get that number correct?

[Xenon]

for the moderators sections you have to use

PHP Code:

$num_users = count($modcache); 


it should work i'd say

[the Sandman]

Originally Posted by Xenon

for the moderators sections you have to use

PHP Code:

$num_users = count($modcache); 


it should work i'd say

Where?

[Xenon]

before that:

PHP Code:

        exec_switch_bg();
        eval('$moderatorbits .= "' . fetch_template('showgroups_usergroupbit') . '";');