load("online"); if($mybb->usergroup['canviewonline'] == 0) { error_no_permission(); } // Make navigation add_breadcrumb($lang->nav_online, "online.php"); if($mybb->input['action'] == "today") { add_breadcrumb($lang->nav_onlinetoday); $plugins->run_hooks("online_today_start"); $threshold = TIME_NOW-(60*60*24); $query = $db->simple_select("users", "COUNT(uid) AS users", "lastactive > '{$threshold}'"); $todaycount = $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"); // Add pagination $perpage = $mybb->settings['threadsperpage']; if(intval($mybb->input['page']) > 0) { $page = intval($mybb->input['page']); $start = ($page-1) * $perpage; $pages = ceil($todaycount / $perpage); if($page > $pages) { $start = 0; $page = 1; } } else { $start = 0; $page = 1; } $query = $db->simple_select("users", "*", "lastactive > '{$threshold}'", array("order_by" => "lastactive", "order_dir" => "desc", "limit" => $perpage, "limit_start" => $start)); $todayrows = ''; while($online = $db->fetch_array($query)) { $invisiblemark = ''; if($online['invisible'] == 1) { $invisiblemark = "*"; } if($online['invisible'] != 1 || $mybb->usergroup['canviewwolinvis'] == 1 || $online['uid'] == $mybb->user['uid']) { $username = $online['username']; $username = format_name($username, $online['usergroup'], $online['displaygroup']); $online['profilelink'] = build_profile_link($username, $online['uid']); $onlinetime = my_date($mybb->settings['timeformat'], $online['lastactive']); eval("\$todayrows .= \"".$templates->get("online_today_row")."\";"); } } if($todaycount == 1) { $onlinetoday = $lang->member_online_today; } else { $onlinetoday = $lang->sprintf($lang->members_were_online_today, $todaycount); } if($invis_count) { $string = $lang->members_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"); $plugins->run_hooks("online_today_end"); eval("\$today = \"".$templates->get("online_today")."\";"); output_page($today); } else { $plugins->run_hooks("online_start"); // Custom sorting options if($mybb->input['sortby'] == "username") { $sql = "u.username ASC, s.time DESC"; $refresh_string = "?sortby=username"; } elseif($mybb->input['sortby'] == "location") { $sql = "s.location, s.time DESC"; $refresh_string = "?sortby=location"; } // Otherwise sort by last refresh else { switch($db->type) { case "sqlite": case "pgsql": $sql = "s.time DESC"; break; default: $sql = "IF( s.uid >0, 1, 0 ) DESC, s.time DESC"; break; } $refresh_string = ''; } $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; } // How many pages are there? $perpage = $mybb->settings['threadsperpage']; if(intval($mybb->input['page']) > 0) { $page = intval($mybb->input['page']); $start = ($page-1) * $perpage; $pages = ceil($online_count / $perpage); if($page > $pages) { $start = 0; $page = 1; } } else { $start = 0; $page = 1; } // Assemble page URL $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} "); // Fetch spiders $spiders = $cache->read("spiders"); while($user = $db->fetch_array($query)) { $plugins->run_hooks("online_user"); // Fetch the WOL activity $user['activity'] = fetch_wol_activity($user['location'], $user['nopermission']); $botkey = my_strtolower(str_replace("bot=", '', $user['sid'])); // Have a registered user if($user['uid'] > 0) { if($users[$user['uid']]['time'] < $user['time'] || !$users[$user['uid']]) { $users[$user['uid']] = $user; } } // Otherwise this session is a bot else if(my_strpos($user['sid'], "bot=") !== false && $spiders[$botkey]) { $user['bot'] = $spiders[$botkey]['name']; $user['usergroup'] = $spiders[$botkey]['usergroup']; $guests[] = $user; } // Or a guest else { $guests[] = $user; } } // Now we build the actual online rows - we do this separately because we need to query all of the specific activity and location information $online_rows = ''; if(is_array($users)) { reset($users); foreach($users as $user) { $online_rows .= build_wol_row($user); } } if(is_array($guests)) { reset($guests); foreach($guests as $user) { $online_rows .= build_wol_row($user); } } // Fetch the most online information $most_online = $cache->read("mostonline"); $record_count = $most_online['numusers']; $record_date = my_date($mybb->settings['dateformat'], $most_online['time']); $record_time = my_date($mybb->settings['timeformat'], $most_online['time']); // Set automatic refreshing if enabled if($mybb->settings['refreshwol'] > 0) { $refresh_time = $mybb->settings['refreshwol'] * 60; $refresh = ""; } $plugins->run_hooks("online_end"); eval("\$online = \"".$templates->get("online")."\";"); output_page($online); } ?>