vb.org Archive - sidebar block

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)

- - sidebar block (https://vborg.vbsupport.ru/showthread.php?t=320977)

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 !!!

Quote:

Originally Posted by CAG CheechDogg (Post 2561690)

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

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

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

");

Where exactly do I add

PHP Code:


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

Quote:

Originally Posted by CAG CheechDogg (Post 2561781)

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>';

}

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01175 seconds Memory Usage 1,765KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (5)bbcode_php_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: