Display the number of members of a group

[tokads3]

Hi all,

Here I would like to show in the stats footer of the forum, the number of members of a specific group that we created (total core members + additional members)

A bit like this example

Threads: 1234, Posts: 123,456 Members: 12345
Welcome to our newest member, XXXX
Today Posts: 123
New Users Today: 12
Association members: 1234



How? Thank you in advance, sorry for my english

[tokads3]

Nobody can help me??

[tokads3]

?????

[LifesGreatestGift]

New plugin

Count primary / secondary users of group

hook location: forumhome_complete

PHP Code:

$groupid = 6; // Count admin users

$group_primary = $vbulletin->db->query_first("
SELECT COUNT(user.userid) AS count
        FROM " . TABLE_PREFIX . "user AS user
        WHERE user.usergroupid = " . $groupid . "
");
$group_secondary = $vbulletin->db->query_first("
SELECT COUNT(user.userid) AS count
        FROM " . TABLE_PREFIX . "user AS user
        WHERE user.membergroupids = " . $groupid . "
");

$primary = $group_primary['count'];
$secondary = $group_secondary['count'];
$total = vb_number_format($primary + $secondary);

vB_Template::preRegister('FORUMHOME',array('g_count' => $total)); 


then in FORUMHOME template you can do

Association members: {vb:raw g_count}

Be sure to change the '6' in $groupid to the group id you are trying to count.

[tokads3]

Thank you very much, it's good.

[LifesGreatestGift]

[TRBozo]

Originally Posted by LifesGreatestGift

New plugin

Count primary / secondary users of group

hook location: forumhome_complete

PHP Code:

$groupid = 6; // Count admin users

$group_primary = $vbulletin->db->query_first("
SELECT COUNT(user.userid) AS count
        FROM " . TABLE_PREFIX . "user AS user
        WHERE user.usergroupid = " . $groupid . "
");
$group_secondary = $vbulletin->db->query_first("
SELECT COUNT(user.userid) AS count
        FROM " . TABLE_PREFIX . "user AS user
        WHERE user.membergroupids = " . $groupid . "
");

$primary = $group_primary['count'];
$secondary = $group_secondary['count'];
$total = vb_number_format($primary + $secondary);

vB_Template::preRegister('FORUMHOME',array('g_count' => $total)); 


then in FORUMHOME template you can do

Association members: {vb:raw g_count}

Be sure to change the '6' in $groupid to the group id you are trying to count.

thank you, I'm looking for it for days..