sidebar block

[Wisc]

I would like to have sidebar block "Visiting Members" That shows the visiting members for X amount of days

What is the code I would put in the content box to accomplish this.

As always Thank you in advance!

[MarkFL]

Here is how I set it up on my local dev site:



And this is the PHP code I wrote:

PHP Code:

global $vbulletin, $db;
$output = '<div class="restore"><ul>';

$users_visited = $vbulletin->db->query_read("
    SELECT user.*
    FROM " . TABLE_PREFIX . "user AS user
    WHERE lastvisit >= " . TIMENOW . " - " . 7 * 86400 . "
    ORDER BY lastvisit DESC
");

$vcount = 0;
while ($visitor = $db->fetch_array($users_visited))
{
    $output .= '<li>' . visitor_link($visitor, $visitor['lastvisit']) . '</li>';
    $vcount++;
}

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

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

return $output;

function visitor_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 Visited: ' . 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>';
} 


This is the result:



Each username is shown with their usergroup HTML markup in a bulleted list, and each username links to their profile, with a tooltip showing their last visit time.

Please give this a try, and let me know of any changes you would like.

[Wisc]

gave me : 406 Not Acceptable
when i tried to save it...

[MarkFL]

Originally Posted by Wisc

gave me : 406 Not Acceptable
when i tried to save it...

406 happens when the server cannot respond with the accept-header specified in the request.

Unfortunately, I cannot duplicate the error, it works fine on both my local and online dev sites.

[Wisc]

so id server issue or I should try to
refresh the blocks
clear the cache

and do again?

Thank you for your hard work...
I think will be helpful for a lot of people

[MarkFL]

Originally Posted by Wisc

so id server issue or I should try to
refresh the blocks
clear the cache

and do again?

Thank you for your hard work...
I think will be helpful for a lot of people

It sounds like a server issue to me, from the brief amount I read about it online. As such, it is outside my relatively diminutive areas of expertise, so I don't know what to tell you to try to resolve the issue. Hopefully someone else here can offer some suggestions.

What I suggest doing is creating a new thread, where the title indicates you are getting a 406 error when trying to save a forum block, and this will be more likely to get you some help rather than to trust that someone who knows how to fix it will stumble across this thread.

[Wisc]

Thank you again MarK...the code is a huge help and others will use too i am sure
Happy Holidays

[webmastersun]

Cool tips Mark!

Your codes can be edited a bit to make a block on right sidebar that show users online last 24 hours...instead of showing at the bottom of homepage.

[setishock]

Mark, is there a way to make it so it doesn't show banned members? All but a few of the listed visitors are spammers that got banned. I'd prefer not to show those.

[MarkFL]

Originally Posted by setishock

Mark, is there a way to make it so it doesn't show banned members? All but a few of the listed visitors are spammers that got banned. I'd prefer not to show those.

Yes, change the query near the top of the PHP content to read:

PHP Code:

$users_visited = $vbulletin->db->query_read("
    SELECT user.*
    FROM " . TABLE_PREFIX . "user AS user
    WHERE lastvisit >= " . TIMENOW . " - " . 7 * 86400 . "
    AND usergroupid != 8
    ORDER BY lastvisit DESC
");