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)

Mark sorry to highjack this thread ...but how about to show only 1 usergroup even if they belong to a secondary usergroup?

Quote:

Originally Posted by CAG CheechDogg (Post 2561442)

Mark sorry to highjack this thread ...but how about to show only 1 usergroup even if they belong to a secondary usergroup?

it doesn't display usergroups. Are you wanting to show all member of only 1 specific group? If so, change the query to this:

Code:

$users_visited = $vbulletin->db->query_read(" 

    SELECT user.* 

    FROM " . TABLE_PREFIX . "user AS user 

    WHERE lastvisit >= " . TIMENOW . " - " . 7 * 86400 . " 

    AND usergroupid = _YOURUSERGROUP_

    ORDER BY lastvisit DESC 

");

change _YOURUSERGROUP_ to the group ID you want to show

Quote:

Originally Posted by Dragonsys (Post 2561448)

it doesn't display usergroups. Are you wanting to show all member of only 1 specific group? If so, change the query to this:

Code:

$users_visited = $vbulletin->db->query_read(" 

    SELECT user.* 

    FROM " . TABLE_PREFIX . "user AS user 

    WHERE lastvisit >= " . TIMENOW . " - " . 7 * 86400 . " 

    AND usergroupid = _YOURUSERGROUP_

    ORDER BY lastvisit DESC 

");

change _YOURUSERGROUP_ to the group ID you want to show

What I was really looking for is to show members of a specific usergroup who are online now. I have members who belong to usergroup "Officers" and would like to show them online now if they are online now kind of like they are staff who are online so that members can contact them if they have questions... know what I mean?

Quote:

Originally Posted by CAG CheechDogg (Post 2561449)

When I am in for the night, I will post the code to display members of a certain usergroup who are online at the moment. :)

Quote:

Originally Posted by MarkFL (Post 2561451)

When I am in for the night, I will post the code to display members of a certain usergroup who are online at the moment. :)

Good stuff Mark thank you so much !!!!!!

:up::up::up:

I wasn't paying attention and just put in the change you made to weed out banned members. It gave me a server error. Had one of those DOH moments. When I replaced the old with the new in its entirety, it worked as advertised. Now all that shows is me and the supermod and the folks that just signed up for S&G.

Thanks again. If I could program like you my Arduino wouldn't be sitting on my desk gathering dust.

Quote:

Originally Posted by MarkFL (Post 2561451)

When I am in for the night, I will post the code to display members of a certain usergroup who are online at the moment. :)

Any progress on this Senor Mark?

Quote:

Originally Posted by CAG CheechDogg (Post 2561467)

Any progress on this Senor Mark?

Quote:

Originally Posted by CAG CheechDogg (Post 2561467)

Any progress on this Senor Mark?

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

Quote:

Originally Posted by MarkFL (Post 2561469)

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

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

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:

https://vborg.vbsupport.ru/external/2016/01/24.jpg

I did not realize there were new posts in this thread because of doublepost merges. Sorry about that. To allow multiple usergroups and to prevent repetition, try this (of course edit the $groupid/$groupname definitions):

PHP Code:


		
			
global $vbulletin, $db;
$groupid = '6,13';
$groupname = 'Math Helpers/Administrators';
$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.*, session.loggedin
    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
    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 (2)bbcode_code_printable (5)bbcode_php_printable (8)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 (10)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.01313 seconds Memory Usage 1,851KB 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 (2)bbcode_code_printable (5)bbcode_php_printable (8)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 (10)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: