sidebar block

[CAG CheechDogg]

Ok good this works, just one small bug .... it still shows one member active from 5 hours ago who is a test account ....

--------------- Added [DATE]1451768165[/DATE] at [TIME]1451768165[/TIME] ---------------

Any update on this Mark as to why it will still show someone logged in from 5,10 and 20 hours ago?

I did notice though that in order for this to consider someone active they have to actually execute something like post a comment, like a comment not just be logged on ....

What other options are there for this, can this display members who are just logged on period? And does it also detect logged in users from Tapatalk? I see that there are members who are online logged in but through tapatalk but are not being displayed on this sidebar block ....

Thank you ahead of time Mark !!!

[MarkFL]

Originally Posted by CAG CheechDogg

Ok good this works, just one small bug .... it still shows one member active from 5 hours ago who is a test account ....

--------------- Added [DATE]1451768165[/DATE] at [TIME]1451768165[/TIME] ---------------

Any update on this Mark as to why it will still show someone logged in from 5,10 and 20 hours ago?

I did notice though that in order for this to consider someone active they have to actually execute something like post a comment, like a comment not just be logged on ....

What other options are there for this, can this display members who are just logged on period? And does it also detect logged in users from Tapatalk? I see that there are members who are online logged in but through tapatalk but are not being displayed on this sidebar block ....

Thank you ahead of time Mark !!!

I will have to take a look at a better way to determine which users are actually online.

[CAG CheechDogg]

Ok good stuff my Man .... thank again !!!!

[MarkFL]

Okay, add the following line before the query:

PHP Code:

$timecutoff = TIMENOW - $vbulletin->options['cookietimeout']; 


And then change the db query to the following:

PHP Code:

$users_online = $vbulletin->db->query_read("
    SELECT user.*
    FROM " . TABLE_PREFIX . "user AS user
    INNER JOIN " . TABLE_PREFIX . "session AS session
    ON session.userid = user.userid
    WHERE user.usergroupid IN (" . $groupid . ")
    " . $qwhere . "
    AND session.loggedin > 0
    AND session.lastactivity >= " . $timecutoff . "
    GROUP BY user.userid
    ORDER BY user.lastactivity DESC
"); 


[CAG CheechDogg]

Where exactly do I add

PHP Code:

 $timecutoff = TIMENOW - $vbulletin->options['cookietimeout']; 


[MarkFL]

Originally Posted by CAG CheechDogg

Where exactly do I add

PHP Code:

 $timecutoff = TIMENOW - $vbulletin->options['cookietimeout']; 


Anywhere before the db query will be fine.

This is what I now have:

PHP Code:

global $vbulletin, $db;
$groupid = '6,13';
$groupname = 'Math Helpers/Administrators';
$timecutoff = TIMENOW - $vbulletin->options['cookietimeout'];
$output = '<div class="restore"><ul>';

$groupid_arr = explode(',', $groupid);
$qwhere = '';

foreach ($groupid_arr AS $id)
{
    $qwhere .= 'OR ' . $id . ' IN (user.membergroupids) ';
}

$users_online = $vbulletin->db->query_read("
    SELECT user.*
    FROM " . TABLE_PREFIX . "user AS user
    INNER JOIN " . TABLE_PREFIX . "session AS session
    ON session.userid = user.userid
    WHERE user.usergroupid IN (" . $groupid . ")
    " . $qwhere . "
    AND session.loggedin > 0
    AND session.lastactivity >= " . $timecutoff . "
    GROUP BY user.userid
    ORDER BY user.lastactivity DESC
");

$count = 0;
while ($member = $db->fetch_array($users_online))
{
    $output .= '<li>' . helper_link($member, $member['lastactivity']) . '</li>';
    $count++;
}

$output .= '</ul></div>';

$output = '<div style="text-align: center; font-weight: bold; margin-bottom: 1em">' . $count . ' ' . $groupname . ' Online</div>' . $output;

return $output;

function helper_link($user_name, $dateline)
{
    global $vbulletin;
    $link = 'member.php?do=getinfo&username=' . $user_name['username'];

    if ($user_name['displaygroupid'])
    {
        $groupid = $user_name['displaygroupid'];
    }
    else
    {
        $groupid = $user_name['usergroupid'];
    }

    $open_tag = $vbulletin->usergroupcache[$groupid]['opentag'];
    $close_tag = $vbulletin->usergroupcache[$groupid]['closetag'];
    $title = 'Last Activity: ' . vbdate($vbulletin->options['dateformat'], $dateline, 1) . ' at ' . vbdate($vbulletin->options['timeformat'], $dateline);
    return '<a title="' . $title . '" href="' . $link . '">' . $open_tag . $user_name['username'] . $close_tag . '</a>';
}