$activeusers's declaration

[ArashB]

Hi there

I need to find out where $activeusers is populated, I need to avoid showing banned users from being displayed in the online users in homepage

I recommend you add "exclude user groups" in "online users module" in the next vbulletin but now I need to change it myself.


I'm looking for the declaration of the variable so that I can change the sql command, I'm not looking for where this variable is defined

[Colin F]

This is done in the build_user_statistics() function in the /includes/functions_databuild.php file.

[ArashB]

This is done in the build_user_statistics() function in the /includes/functions_databuild.php file.

Thank you,

I changed it to:

function build_user_statistics()
{
    global $vbulletin;

    if ($vbulletin->options['activememberdays'] > 0)
    {
        $sumsql = "SUM(IF(lastvisit >= " . (TIMENOW - $vbulletin->options['activememberdays'] * 86400) . ", 1, 0)) AS active,";
    }
    else
    {
        $sumsql = '';
    }

    // get total members
    $members = $vbulletin->db->query_first("
        SELECT
        $sumsql
        COUNT(*) AS users,
        MAX(userid) AS maxid
        FROM " . TABLE_PREFIX . "user where usergroupid <> 6
     ");

    // get newest member
    $newuser = $vbulletin->db->query_first("SELECT userid, username FROM " . TABLE_PREFIX . "user WHERE userid = $members[maxid]");

    // make a little array with the data
    $values = array(
        'numbermembers' => $members['users'],
        'activemembers' => $members['active'],
        'newusername'   => $newuser['username'],
        'newuserid'     => $newuser['userid']
    );

    // update the special template
    build_datastore('userstats', serialize($values), 1);

    return $values;
} 

Yet users in usergroup 6 are still being shown on "who's online" section, any idea how I can solve that?

[Colin F]

It's possible that you'll need to rebuild it. Add a user and delete him again and see if it updates correctly.

For further support with code modifications please ask on www.vbulletin.org.

[ArashB]

did that, doesn't work

do usergroups have "show on who is online" option?

[Zachery]

No, though further discussions on modifications should be carried out at vBulletin.org.