small request plz

[SilverBoy]

I wanna add numer of users of all titles to my index page, so can some one help me to do that thx.
ex:
1 adminstrator
8 moderators
165 joniour member
78 member
15 senior member

and I wish I can add it too other php page too.
thx for help.

Good suggestion, SilverBoy!

Would certainly make a useful small hack for lots of vBulletin users out there.

Could someone please create this hack? Thank you!

[SilverBoy]

I want it plz make it to me.

I'll give it a try.

[SilverBoy]

u are gentel man.

Good luck with the hack, PeF!

[SilverBoy]

Iam still waiting ??????

[Kier]

Add this code to the page you want to show the user totals on:

PHP Code:

    $users = $DB_site->query("SELECT usergroup.title, COUNT(userid) AS users
    FROM usergroup
    LEFT JOIN user USING(usergroupid)
    GROUP BY usergroup.usergroupid");
    while ($user = $DB_site->fetch_array($users)) {
        $usertotals .= "$user[title] ($user[users])<br>";
    } 


...and then add $usertotals to an appropriate template.

Easy peasy

I'm late. As usual.

[SilverBoy]

I will try it and replay later, thx