Go Back   vBulletin Setup > vBulletinSetup Information > Troubleshooting vBulletin Problems

Reply 
 
LinkBack Thread Tools Display Modes
Old 08-02-2007, 12:19 PM   #1
Community Manager
Supporters
vBulletin Owner
vBSetup Mods
 
Brandon Sheley's Avatar
 
Join Date: Jul 2006
Location: Topeka, KS
Posts: 14,112
Blog Entries: 35
Brandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to behold
Send a message via AIM to Brandon Sheley Send a message via MSN to Brandon Sheley Send a message via Yahoo to Brandon Sheley
Display the # of users in a group in the forum stats box

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
__________________
Brandon Sheley / vBulletinSetup Staff
Check the Newsletter & Marketplace for the latest deals.
Looking for a place to Support vBulletinSetup?
Submit your Forum and other Quality Websites.


Brandon Sheley is offline   Reply With Quote

Advertisement [Remove Advertisement]

Old 08-02-2007, 06:53 PM   #2
Supporters
vBulletin Owner
 
Michael Biddle's Avatar
 
Join Date: Aug 2006
Location: Anaheim, CA
Posts: 1,657
Michael Biddle is just really niceMichael Biddle is just really niceMichael Biddle is just really nice
Re: Display the # of users in a group in the forum stats box

Quote:
Originally Posted by Brandon View Post
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.
__________________
I hate that someone changed my signature.
Michael Biddle is offline   Reply With Quote
Old 08-02-2007, 07:01 PM   #3
Community Manager
Supporters
vBulletin Owner
vBSetup Mods
 
Brandon Sheley's Avatar
 
Join Date: Jul 2006
Location: Topeka, KS
Posts: 14,112
Blog Entries: 35
Brandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to beholdBrandon Sheley is a splendid one to behold
Send a message via AIM to Brandon Sheley Send a message via MSN to Brandon Sheley Send a message via Yahoo to Brandon Sheley
Re: Display the # of users in a group in the forum stats box

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
__________________
Brandon Sheley / vBulletinSetup Staff
Check the Newsletter & Marketplace for the latest deals.
Looking for a place to Support vBulletinSetup?
Submit your Forum and other Quality Websites.



Last edited by Brandon Sheley; 08-02-2007 at 07:25 PM. Reason: Automerged Doublepost
Brandon Sheley is offline   Reply With Quote
Reply 
vBulletin Setup > vBulletinSetup Information > Troubleshooting vBulletin Problems

Tags
box, display, forum, group, stats, users

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Removing Members name| forum home and forum display Template for a specific forum Ekka Troubleshooting vBulletin Problems 6 07-21-2009 06:48 AM
Forum Stats and Variable Help tbathgate Troubleshooting vBulletin Problems 0 11-11-2008 03:03 AM
Join the unofficial vbsetup forum launch group Noodles General Discussion 4 08-07-2008 01:27 PM
Removing threads display from a forum to create a hybrid "sub-forum container" Ville Troubleshooting vBulletin Problems 0 07-25-2007 11:55 AM
Post Your vBulletin Forum Stats Brent Troubleshooting vBulletin Problems 16 07-11-2007 10:20 PM


All times are GMT -8. The time now is 05:56 PM.