Display the # of users in a group in the forum stats box

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#1 08-02-2007, 02:19 PM

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.

Post your URL and a link to your vb.com username here to get full access.

Add our Facebook Blog, Group and LinkedIn group.. Thanks

Stay up to date by installing our Tool Bar

Quote |

Michael Biddle

vBSetup Team
Tech Admin
vBulletin Owner

#2 08-02-2007, 08:53 PM

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

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 |

Brandon

vBSetup Team
vBulletin Owner
vBSetup Owner

#3 08-02-2007, 09:01 PM

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

--------------------

Post your URL and a link to your vb.com username here to get full access.

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 |