Go Back   vBulletin Setup > vBulletinSetup Information > vBulletin Questions


Please Register to get full access to the forums.
Post New Thread  Reply



#1   08-02-2007, 02:19 PM
Send a message via AIM to Brandon Send a message via MSN to Brandon Send a message via Yahoo to Brandon Brandon is a glorious beacon of lightBrandon is a glorious beacon of lightBrandon is a glorious beacon of lightBrandon is a glorious beacon of light Join Date: Jul 2006 Posts: 10,496 Location: Topeka, KS
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 / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.


Add our Facebook Blog, Group and LinkedIn group.. Thanks
Stay up to date by installing our Tool Bar
Quote   |  



#2   08-02-2007, 08:53 PM
Michael Biddle is just really niceMichael Biddle is just really nice Join Date: Aug 2006 Posts: 1,601 Location: Anaheim, CA
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.
--------------------
Do NOT PM me for Support!
Michael Biddle / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.
Quote   |  



#3   08-02-2007, 09:01 PM
Send a message via AIM to Brandon Send a message via MSN to Brandon Send a message via Yahoo to Brandon Brandon is a glorious beacon of lightBrandon is a glorious beacon of lightBrandon is a glorious beacon of lightBrandon is a glorious beacon of light Join Date: Jul 2006 Posts: 10,496 Location: Topeka, KS
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 / vBulletin Setup Staff
Check out our Newsletter for the latest vB and SEO news.
Are you looking for vBulletin work to be done on your forums ?
Would you like to Help Support vBulletin Setup.


Add our Facebook Blog, Group and LinkedIn group.. Thanks
Stay up to date by installing our Tool Bar

Last edited by Brandon; 08-02-2007 at 09:25 PM. Reason: Automerged Doublepost
Quote   |  
Post New Thread  Reply
vBulletin Setup > vBulletinSetup Information > vBulletin Questions


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
Users Statistics / Forum Activity? aragorn vBulletin Questions 2 11-19-2007 01:36 PM
Removing threads display from a forum to create a hybrid "sub-forum container" Ville vBulletin Questions 0 07-25-2007 01:55 PM
Post Your vBulletin Forum Stats Brent vBulletin Questions 16 07-12-2007 12:20 AM
"users online in the past 24 hrs" is missing from my forum aj8690 vBulletin Questions 2 12-22-2006 08:44 PM


All times are GMT -6. The time now is 10:51 AM.

vBulletin Setup, vBulletin Setup Forums, vBulletin Services, vBulletin Blogs, vBulletin SEO, vBulletin Questions, vBulletin Skins, Styles, Templates
vBulletin Hacks / Modifications, vBulletin Monetization, Blogs, vBulletin Link Directory,Quality Link Directory