Brent H
03-12-2006, 06:58 PM
I need to modify my Who's Online page to restrict the viewing of online members to those in the same group as the user.
If a user is in Group A, I only want them to see people online who are also in Group A.
How can this be done, please?
Darwinist
03-15-2006, 02:22 AM
Open 'online.php' and find:
$allusers = $db->query_read("
SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "session AS session
". iif($vbulletin->options['WOLguests'], " LEFT JOIN " . TABLE_PREFIX . "user AS user USING (userid) ", ", " . TABLE_PREFIX . "user AS user") ."
WHERE session.lastactivity > $datecut
". iif(!$vbulletin->options['WOLguests'], " AND session.userid = user.userid", "") ."
ORDER BY $sqlsort $sortorder
");
Change part of the WHERE statement from...
WHERE session.lastactivity > $datecut
to...
WHERE session.lastactivity > $datecut AND user.usergroupid=" . $vbulletin->userinfo['usergroupid'] . "
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.