how do I get the statistics to 'not count' members in a specific usergroup

[kurtbarker]

Hey guyz...

In the statistics at the bottom of the page it has members and active members..

For specific usergroups can I exclude them from the total member count?

Thanks guyz

[rnmcd]

Bump.

I'm looking for the same thing. Maybe the mod already exists but I might be using the wrong search terms.

Any suggestions?

[glennno]

I've been looking for this too, no help on vbulletin.com.

We imported a Yahoo Group and archived all the old messages, and now all the old usernames are inflating our member count on the home page. It's confusing everyone. Not everyone from that group joined the vB forum, and all the new usernames of those who did are different. We cannot change any of those usernames, for reasons specific to the forum.

This is a pain. It seems so simple, there's got to be a way.

[rnmcd]

<bump>

[Paul M]

You would need to rewrite the queries in the build_user_statistics() function. There are no hooks in that function.

[rnmcd]

That's not something that is in the template is it?

[Paul M]

Nope, it's php code.

[fxs158]

anyone able to help with this?

[jamoss]

For the home page active users, edit index.php

SEARCH FOR (around line 401):
WHERE session.lastactivity > $datecut

AFTER THAT, ADD:
AND user.usergroupid in (x,x,x)

... where x,x,x are the usergroups you want it to show.

For the Member List feature, you can create a plugin:

Hook Location: memberlist_query_userscount
PHP CODE:
$ids='x,x,x';

where x,x,x are the usergroups you want it to show.

[silurius]

Bump!

For my 3.8.3 site, I edited index.php exactly as jamoss described, but it did not appear to have any effect. I cleared my browser cache, ran the "Daily Statistics Log" scheduled task, ran the "Rebuild Statistics" counter update. Anything else I'm missing? I assume vBulletin has changed enough since 2007 to indicate something new, but I have no idea where to look.

Thanks in advance!

Edit: Here is my code:

    $forumusers = $db->query_read_slave("
        SELECT
            user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,
            session.userid, session.inforum, session.lastactivity, session.badlocation,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
            $hook_query_fields
        FROM " . TABLE_PREFIX . "session AS session
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
        $hook_query_joins
        WHERE session.lastactivity > $datecut AND user.usergroupid in (5,6,7,10)
            $hook_query_where
        " . iif($vbulletin->options['displayloggedin'] == 1 OR $vbulletin->options['displayloggedin'] == 3, "ORDER BY username ASC") . "
    ");