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.

[Swoosh]

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! :D

[SilverBoy]

I want it plz make it to me.

[PeF]

I'll give it a try. :)

[SilverBoy]

u are gentel man. ;)

[Swoosh]

Good luck with the hack, PeF! :)

[SilverBoy]

Iam still waiting ?????? :D

[Kier]

Add this code to the page you want to show the user totals on: $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 :)

[PeF]

I'm late. As usual. :D

[SilverBoy]

I will try it and replay later, thx ;)

[SilverBoy]

thx Kier but I tried it on vb115 and work fine, but it is not what i want, I wanna to display usertitles not usergroups, sorry for bothering u but can u to modify it.;)

[polgas]

Replace Kier's SQL query with this:

SELECT user.usertitle, COUNT(userid) AS users
FROM user
GROUP BY user.usertitle

Hope this helps.

[jojo85]

Lol Pef,don't forget that Kier is the better php coder's of the World (for vbulletin ;) )

[SilverBoy]

I have 4 users in my test board, and when I test it, it gived me a list without titles only numbers, and they was 3 numbers only, but I have 4 titles to those users, any help???:confused:

[polgas]

try the sql query if you have this.

[SilverBoy]

I didnt get ur meaning, sorry

[polgas]

Do you know if you have phpmyAdmin access to your site? If you have, run the SELECT statement I posted and see if you get the result you wanted.

[SilverBoy]

I checked in phpmyadmin and it was very nie, I think there are some modification in the rest of kier code to display every thing correctly in the index page, any help.

[SilverBoy]

can u do it with new select statment?

[trilizio]

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


I think this might work

not 100% sure.

[SilverBoy]

it works fine now, thx for ur help all.