Troubleshooting vBulletin Problems Discuss Display the # of users in a group in the forum stats box in the vBulletinSetup Information forums; I have a client that has a paid forum, right now you see this in the stats box down in the whats going on box Member 600, Active members 150 ...

[Brandon Sheley]

I have a client that has a paid forum, right now you see this in the stats box down in the whats going on box


Member 600, Active members 150

He wants to change it to this


Total Member 600, Paid Members 250, Active members 150


I need to pull the "250" from more then one usergroups

Thanks for the help

-Brandon

[Michael Biddle]

Originally Posted by Brandon

I have a client that has a paid forum, right now you see this in the stats box down in the whats going on box


Member 600, Active members 150

He wants to change it to this


Total Member 600, Paid Members 250, Active members 150


I need to pull the "250" from more then one usergroups

Thanks for the help

-Brandon

It would be a hook into the forumhome_start. Run a query something like:

PHP Code:

$result = $vbulletin->db->query_read("
    SELECT username
    FROM " . TABLE_PREFIX . "user
    WHERE usergroupid = X
");

$paidmembers = $vbulletin->db->num_rows($result); 


Then in the forumhome template add the $paidmembers variable where you want it. BUT remember to change the X in the top query to the usergroupid.

Also, not sure if this works as I am writing it from my cell. Some syntax might be off. Will double check tommorow morning.

[Brandon Sheley]

do I make the plugin title paidmembers ?

and I need to pull from 3 usergroups 37,36,40

do I just add the numbers and commas

just to update, the plugin worked great :smiley_:
Thanks Mike

and to add more then one user group I had to add

OR usergroupid = x OR usergroupid = x

so thanks again mike guess I owe you a :beat:

lol