Zeile 44 | Zeile 44 |
---|
$query = $db->simple_select("users", "COUNT(uid) AS users", "lastactive > '{$threshold}' AND invisible = '1'"); $invis_count = $db->fetch_field($query, "users");
|
$query = $db->simple_select("users", "COUNT(uid) AS users", "lastactive > '{$threshold}' AND invisible = '1'"); $invis_count = $db->fetch_field($query, "users");
|
if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1) { $mybb->settings['threadsperpage'] = 20; }
| if(!$mybb->settings['wolusersperpage'] || (int)$mybb->settings['wolusersperpage'] < 1) { $mybb->settings['wolusersperpage'] = 20; }
|
// Add pagination
|
// Add pagination
|
$perpage = $mybb->settings['threadsperpage'];
| $perpage = $mybb->settings['wolusersperpage'];
|
if($mybb->get_input('page', MyBB::INPUT_INT) > 0) { $page = $mybb->get_input('page', MyBB::INPUT_INT); $start = ($page-1) * $perpage; $pages = ceil($todaycount / $perpage);
|
if($mybb->get_input('page', MyBB::INPUT_INT) > 0) { $page = $mybb->get_input('page', MyBB::INPUT_INT); $start = ($page-1) * $perpage; $pages = ceil($todaycount / $perpage);
|
if($page > $pages) { $start = 0; $page = 1; } }
| if($page > $pages) { $start = 0; $page = 1; } }
|
else { $start = 0;
| else { $start = 0;
|
Zeile 75 | Zeile 75 |
---|
while($online = $db->fetch_array($query)) { $invisiblemark = '';
|
while($online = $db->fetch_array($query)) { $invisiblemark = '';
|
if($online['invisible'] == 1) { $invisiblemark = "*"; }
| if($online['invisible'] == 1) { $invisiblemark = "*"; }
|
if($online['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $online['uid'] == $mybb->user['uid']) { $username = format_name(htmlspecialchars_uni($online['username']), $online['usergroup'], $online['displaygroup']); $online['profilelink'] = build_profile_link($username, $online['uid']);
|
if($online['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $online['uid'] == $mybb->user['uid']) { $username = format_name(htmlspecialchars_uni($online['username']), $online['usergroup'], $online['displaygroup']); $online['profilelink'] = build_profile_link($username, $online['uid']);
|
$onlinetime = my_date($mybb->settings['timeformat'], $online['lastactive']);
| $onlinetime = my_date('normal', $online['lastactive']);
|
eval("\$todayrows .= \"".$templates->get("online_today_row")."\";"); } }
|
eval("\$todayrows .= \"".$templates->get("online_today_row")."\";"); } }
|
| $multipage = multipage($todaycount, $perpage, $page, "online.php?action=today");
|
$todaycount = my_number_format($todaycount); $invis_count = my_number_format($invis_count);
if($todaycount == 1) { $onlinetoday = $lang->member_online_today;
|
$todaycount = my_number_format($todaycount); $invis_count = my_number_format($invis_count);
if($todaycount == 1) { $onlinetoday = $lang->member_online_today;
|
} else {
| } else {
|
$onlinetoday = $lang->sprintf($lang->members_were_online_today, $todaycount);
|
$onlinetoday = $lang->sprintf($lang->members_were_online_today, $todaycount);
|
}
| }
|
if($invis_count) { $string = $lang->members_online_hidden;
|
if($invis_count) { $string = $lang->members_online_hidden;
|
|
|
if($invis_count == 1) { $string = $lang->member_online_hidden;
|
if($invis_count == 1) { $string = $lang->member_online_hidden;
|
}
$onlinetoday .= $lang->sprintf($string, $invis_count); }
$multipage = multipage($todaycount, $perpage, $page, "online.php?action=today");
| }
$onlinetoday .= $lang->sprintf($string, $invis_count); }
|
$plugins->run_hooks("online_today_end");
eval("\$today = \"".$templates->get("online_today")."\";");
| $plugins->run_hooks("online_today_end");
eval("\$today = \"".$templates->get("online_today")."\";");
|
Zeile 143 | Zeile 143 |
---|
{ case "sqlite": case "pgsql":
|
{ case "sqlite": case "pgsql":
|
$sql = "s.time DESC";
| $sql = "CASE WHEN s.uid > 0 THEN 1 ELSE 0 END DESC, s.time DESC";
|
break; default: $sql = "IF( s.uid >0, 1, 0 ) DESC, s.time DESC"; break; } $refresh_string = '';
|
break; default: $sql = "IF( s.uid >0, 1, 0 ) DESC, s.time DESC"; break; } $refresh_string = '';
|
}
| }
|
$timesearch = TIME_NOW - $mybb->settings['wolcutoffmins']*60;
|
$timesearch = TIME_NOW - $mybb->settings['wolcutoffmins']*60;
|
// Exactly how many users are currently online? switch($db->type) { case "sqlite": $sessions = array(); $query = $db->simple_select("sessions", "sid", "time > {$timesearch}"); while($sid = $db->fetch_field($query, "sid")) { $sessions[$sid] = 1; } $online_count = count($sessions); unset($sessions); break; case "pgsql": default: $query = $db->simple_select("sessions", "COUNT(sid) as online", "time > {$timesearch}"); $online_count = $db->fetch_field($query, "online"); break; }
| $query = $db->query(" SELECT COUNT(*) AS online FROM ( SELECT 1 FROM " . TABLE_PREFIX . "sessions WHERE time > $timesearch GROUP BY uid, ip ) s ");
$online_count = $db->fetch_field($query, "online");
|
if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1) { $mybb->settings['threadsperpage'] = 20;
| if(!$mybb->settings['threadsperpage'] || (int)$mybb->settings['threadsperpage'] < 1) { $mybb->settings['threadsperpage'] = 20;
|
Zeile 203 | Zeile 194 |
---|
$multipage = multipage($online_count, $perpage, $page, "online.php".$refresh_string);
// Query for active sessions
|
$multipage = multipage($online_count, $perpage, $page, "online.php".$refresh_string);
// Query for active sessions
|
$query = $db->query(" SELECT DISTINCT s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."sessions s LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid=u.uid) WHERE s.time>'$timesearch' ORDER BY $sql LIMIT {$start}, {$perpage} ");
| $dbversion = $db->get_version(); if( ( $db->type == 'mysqli' && ( version_compare($dbversion, '10.2.0', '>=') || ( // MariaDB version_compare($dbversion, '10', '<') && version_compare($dbversion, '8.0.2', '>=') ) ) ) || ($db->type == 'pgsql' && version_compare($dbversion, '8.4.0', '>=')) || ($db->type == 'sqlite' && version_compare($dbversion, '3.25.0', '>=')) ) { $sql = str_replace('u.username', 's.username', $sql);
$query = $db->query(" SELECT * FROM ( SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup, row_number() OVER (PARTITION BY s.uid, s.ip ORDER BY time DESC) AS row_num FROM ".TABLE_PREFIX."sessions s LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid = u.uid) WHERE s.time > $timesearch ) s WHERE row_num = 1 ORDER BY $sql LIMIT {$start}, {$perpage} "); } else { $query = $db->query(" SELECT s.sid, s.ip, s.uid, s.time, s.location, u.username, s.nopermission, u.invisible, u.usergroup, u.displaygroup FROM ".TABLE_PREFIX."sessions s INNER JOIN ( SELECT MIN(s2.sid) AS sid FROM ".TABLE_PREFIX."sessions s2 LEFT JOIN ".TABLE_PREFIX."sessions s3 ON (s2.sid = s3.sid AND s2.time < s3.time) WHERE s2.time > $timesearch AND s3.sid IS NULL GROUP BY s2.uid, s2.ip ) s2 ON (s.sid = s2.sid) LEFT JOIN ".TABLE_PREFIX."users u ON (s.uid = u.uid) ORDER BY $sql LIMIT {$start}, {$perpage} "); }
|
// Fetch spiders $spiders = $cache->read("spiders");
| // Fetch spiders $spiders = $cache->read("spiders");
|