sidebar block

[CAG CheechDogg]

Originally Posted by MarkFL

I had some buddies show up unexpectedly tonight, and many beers were quaffed, and I decided to put off anything serious until tomorrow.

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



You will likely want to set "Cache Time (in minutes)" to 0 so that this information is always current. This is the PHP content I used on my dev site to show all Math Helpers currently online:

PHP Code:

global $vbulletin, $db;
$groupid = 13;
$groupname = 'Math Helpers';
$output = '<div class="restore"><ul>';

$users_online = $vbulletin->db->query_read("
    SELECT user.*, session.loggedin
    FROM " . TABLE_PREFIX . "user AS user
    INNER JOIN " . TABLE_PREFIX . "session AS session
    ON session.userid = user.userid
    WHERE (user.usergroupid = " . $groupid . "
    OR " . $groupid . " IN (user.membergroupids))
    AND session.loggedin > 0
    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>';
} 


You will want to edit these two lines near the top:

PHP Code:

$groupid = 13;
$groupname = 'Math Helpers'; 


to use the groupid and groupname of your choice.

This will list all users currently online who are a member of the selected usergroupid, and list them in descending order by the time of their last activity.

I should also add, that if you wish to use multiple groupids (and have user avatars displayed), I recommend checking out Joe's (BirdOPrey5) product here:

Current Staff Online Forum Sideblock and CMS Widget by BOP5

TY Mark ... I tried using BOP5's CSOFS mod on my site but for some reason it doesn't work ....

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

Mark ..is it possible to edit this so that when there is only one member of said group it says "1 Officer Online" when there is only one member (Officer) instead of "1 Officers Online"

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

Ooops ...nevermind Mark ...this doesn't work with for additional usergroups .... it will only display members of the primary usergroup .... can this be modified to show members if they also have the groupid as the additional usergroup?

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

Or allow to do an array of group ids?

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

Bummer !!! This works but for some reason it works for some of the members and not others ... at one point it listed one member 10 times ...

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

This is what is happening: