set_filenames(array("body" => "admin/admin_index_body.tpl")); // // Get forum statistics // $total_posts = get_db_stat('postcount'); $total_users = get_db_stat('usercount'); $total_topics = get_db_stat('topiccount'); $start_date = create_date($board_config['default_dateformat'], $board_config['board_startdate'], $board_config['default_timezone']); $boarddays = (time() - $board_config['board_startdate']) / (24*60*60); $posts_per_day = sprintf("%.2f", $total_posts / $boarddays); $topics_per_day = sprintf("%.2f", $total_topics / $boarddays); $users_per_day = sprintf("%.2f", $total_users / $boarddays); $avatar_dir_size = 0; if ($avatar_dir = opendir($phpbb_root_path . $board_config['avatar_path'])) { while($file = readdir($avatar_dir)) { if($file != "." && $file != "..") { $avatar_dir_size += filesize($phpbb_root_path . $board_config['avatar_path'] . "/" . $file); } } closedir($avatar_dir); } // // This bit of code translates the avatar directory size into human readable format // Borrowed the code from the PHP.net annoted manual, origanally written by: // Jesse (jesse@jess.on.ca) // if($avatar_dir_size >= 1048576) { $avatar_dir_size = round($avatar_dir_size / 1048576 * 100) / 100 . "MB"; } else if($avatar_dir_size >= 1024) { $avatar_dir_size = round($avatar_dir_size / 1024 * 100) / 100 . "KB"; } else { $avatar_dir_size = $avatar_dir_size . "Bytes"; } if($posts_per_day > $total_posts) { $posts_per_day = $total_posts; } if($topics_per_day > $total_topics) { $topics_per_day = $total_topics; } if($users_per_day > $total_users) { $users_per_day = $total_users; } $template->assign_vars(array("NUMBER_OF_POSTS" => $total_posts, "NUMBER_OF_TOPICS" => $total_topics, "NUMBER_OF_USERS" => $total_users, "STARTDATE" => $start_date, "POSTS_PER_DAY" => $posts_per_day, "TOPICS_PER_DAY" => $topics_per_day, "USERS_PER_DAY" => $users_per_day, "AVATAR_DIR_SIZE" => $avatar_dir_size)); // // End forum statistics // // // Get users online information. // $sql = "SELECT u.username, u.user_id, u.user_allow_viewonline, s.session_page, s.session_logged_in, s.session_time, s.session_ip FROM " . USERS_TABLE . " u, " . SESSIONS_TABLE . " s WHERE u.user_id = s.session_user_id AND s.session_time >= " . (time()-300) . " ORDER BY s.session_time DESC"; if(!$result = $db->sql_query($sql)) { message_die(GENERAL_ERROR, "Couldn't obtain user/online information.", "", __LINE__, __FILE__, $sql); } $onlinerow = $db->sql_fetchrowset($result); $sql = "SELECT forum_name, forum_id FROM " . FORUMS_TABLE; if($forums_result = $db->sql_query($sql)) { while($forumsrow = $db->sql_fetchrow($forums_result)) { $forum_data[$forumsrow['forum_id']] = $forumsrow['forum_name']; } } else { message_die(GENERAL_ERROR, "Couldn't obtain user/online forums information.", "", __LINE__, __FILE__, $sql); } $online_count = $db->sql_numrows($result); if($online_count) { $count = 0; for($i = 0; $i < $online_count; $i++) { if($onlinerow[$i]['user_id'] != ANONYMOUS) { if($onlinerow[$i]['session_logged_in']) { $username = $onlinerow[$i]['username']; } else { $username = $onlinerow[$i]['username']; } } else { $username = $lang['Anonymous']; } if($onlinerow[$i]['session_page'] < 1) { switch($onlinerow[$i]['session_page']) { case PAGE_INDEX: $location = $lang['Forum_index']; $location_url = "index.$phpEx"; break; case PAGE_POSTING: $location = $lang['Posting_message']; $location_url = "index.$phpEx"; break; case PAGE_LOGIN: $location = $lang['Logging_on']; $location_url = "index.$phpEx"; break; case PAGE_SEARCH: $location = $lang['Searching_forums']; $location_url = "search.$phpEx"; break; case PAGE_PROFILE: $location = $lang['Viewing_profile']; $location_url = "index.$phpEx"; break; case PAGE_VIEWONLINE: $location = $lang['Viewing_online']; $location_url = "viewonline.$phpEx"; break; case PAGE_VIEWMEMBERS: $location = $lang['Viewing_member_list']; $location_url = "memberlist.$phpEx"; break; case PAGE_PRIVMSGS: $location = $lang['Viewing_priv_msgs']; $location_url = "privmsg.$phpEx"; break; case PAGE_FAQ: $location = $lang['Viewing_FAQ']; $location_url = "faq.$phpEx"; break; default: $location = $lang['Forum_index']; $location_url = "index.$phpEx"; } } else { $location_url = append_sid("viewforum.$phpEx?" . POST_FORUM_URL . "=" . $onlinerow[$i]['session_page']); $location = $forum_data[$onlinerow[$i]['session_page']]; } if(!($count % 2)) { $row_color = "#" . $theme['td_color1']; } else { $row_color = "#" . $theme['td_color2']; } $count++; $ip_address = decode_ip($onlinerow[$i]['session_ip']); // // This resolves the users IP to a host name, but it REALLY slows the page down // // $host_name = gethostbyaddr($ip_address); // $ip_address = $ip_address . " ($host_name)"; if(empty($username)) { $username = $lang['Guest']; } $template->assign_block_vars("userrow", array( "ROW_COLOR" => $row_color, "USERNAME" => $username, "LOGGED_ON" => $logged_on, "LASTUPDATE" => create_date($board_config['default_dateformat'], $onlinerow[$i]['session_time'], $board_config['default_timezone']), "LOCATION" => $location, "IPADDRESS" => $ip_address, "U_USER_PROFILE" => append_sid("profile.$phpEx?mode=viewprofile&" . POST_USERS_URL . "=" . $onlinerow[$i]['user_id']), "U_FORUM_LOCATION" => append_sid($location_url)) ); } } $template->assign_vars(array("L_USERNAME" => $lang['Username'], "L_LOCATION" => $lang['Location'], "L_LAST_UPDATE" => $lang['Last_updated'], "L_IPADDRESS" => $lang['IP_Address'])); $template->pparse("body"); if($from_index != 1) { include('page_footer_admin.'.$phpEx); } ?>