Usergroups

[lasto]

Say i have 20 users in one usergroup - how can i call the amount of users in one specific usergroup so i can use that info on my index.php page.

I just want to grab the amount of users in one specific usergroup and display the info on main page so it looks something like this :

Admins : 7 (if that is the correct number)

Is this possible ......

--------------- Added [DATE]1206807835[/DATE] at [TIME]1206807835[/TIME] ---------------

anyone know a way to pull this off - i know its not a big request

[lasto]

/me bumps this again

[Opserty]

Check the Usergroup.php page in the AdminCP to see how vBulletin does it.

I'm not sure if the count is stored in the usergroup cache, (run a var_dump() of $vbulletin->usergroupcache to see if it is present).

If it doesn't then you best bet is to run a query to count the users in each usergroup and run this on the usergroup.php page or as a scheduled task to update a cache in the datastore. (You don't want to be querying the database on every page load when the data is going to be fairly static).

I'll see if I can give you some more information later, when I boot up my dev vBulletin, but this should give you an idea of what to do/look for.

[lasto]

cheers m8 as all i want the code for is to call on index.php to show how many users are in one particular usergroup.

[Opserty]

Hmm by the looks of it, it isn't stored in the usergroup cache. Here is the query I pulled from the usergroup admin page:

PHP Code:

    // count primary users
    $groupcounts = $db->query_read("
        SELECT user.usergroupid, COUNT(user.userid) AS total
        FROM " . TABLE_PREFIX . "user AS user
        LEFT JOIN " . TABLE_PREFIX . "usergroup AS usergroup USING (usergroupid)
        WHERE usergroup.usergroupid IS NOT NULL
        GROUP BY usergroupid
    "); 


You could change the WHERE clause to select just what you want.

Have a read of this as you'll probably just want to cache the results to save on queries and processing time. Cache System Explanation (datastore)

[lasto]

bit to much for me m8 how can i use the above info to show the stat i want without it sounding to over complicated

and thanks as well

[Dismounted]

The simple way, without using the cache (bad for load-heavy sites, and bad in general coding practise!):

PHP Code:

// count users in usergroup 7 (primary usergroups only)
$groupcount = $vbulletin->db->query_read("
    SELECT COUNT(userid)
    FROM " . TABLE_PREFIX . "user
    WHERE usergroupid = 7
");
$groupcount = $groupcount['userid']; 


[lasto]

i would add that code to my index.php is that correct : now what code would i need to call it into the board

[Opserty]

Put that code in a FORUMHOME hook. Like forumhome_complete or something like that.

Then you just need to add $groupcount in your FORUMHOME template. Like:

Adminstrator: $groupcount

[lasto]

thanks m8 will try this tonight when get back from work.