function ShowAdminHelp() { global $txt, $helptxt, $context, $scripturl; if (!isset($_GET['help']) || !is_string($_GET['help'])) { fatal_lang_error('no_access', false); } if (!isset($helptxt)) { $helptxt = array(); } // Load the admin help language file and template. loadLanguage('Help'); // Permission specific help? if (isset($_GET['help']) && substr($_GET['help'], 0, 14) == 'permissionhelp') { loadLanguage('ManagePermissions'); } Eos_Smarty::loadTemplate('xml_blocks'); $context['template_functions'] = array('help_popup'); // Set the page title to something relevant. $context['page_title'] = $context['forum_name'] . ' - ' . $txt['help']; // Don't show any template layers, just the popup sub template. $context['template_layers'] = array(); $context['sub_template'] = 'popup'; // What help string should be used? if (isset($helptxt[$_GET['help']])) { $context['help_text'] = $helptxt[$_GET['help']]; } elseif (isset($txt[$_GET['help']])) { $context['help_text'] = $txt[$_GET['help']]; } else { $context['help_text'] = $_GET['help']; } // Does this text contain a link that we should fill in? if (preg_match('~%([0-9]+\\$)?s\\?~', $context['help_text'], $match)) { $context['help_text'] = sprintf($context['help_text'], $scripturl, $context['session_id'], $context['session_var']); } }
/** * @param $memID int member id * * show activities, notifications and settings on the profile page. The latter two * are only handled when viewing your own profile. * * This is here because Profile-View.php is already big enough :) */ function showActivitiesProfile($memID) { global $context, $user_info, $sourcedir, $user_profile, $txt, $modSettings, $options; $context['user']['is_owner'] = $memID == $user_info['id']; require_once $sourcedir . '/lib/Subs-Activities.php'; Eos_Smarty::loadTemplate('profile/profile_base'); loadLanguage('Activities'); $sa = isset($_GET['sa']) ? $_GET['sa'] : 'activities'; $start = isset($_GET['start']) ? (int) $_GET['start'] : 0; if ($sa == 'settings') { return showActivitiesProfileSettings($memID); } Eos_Smarty::getConfigInstance()->registerHookTemplate('profile_content_area', 'profile/activities_display'); $context['page_title'] = $txt['showActivities'] . ' - ' . $user_profile[$memID]['real_name']; $context['pageindex_multiplier'] = commonAPI::getMessagesPerPage(); $context['act_results'] = 0; $context['rich_output'] = true; $context[$context['profile_menu_name']]['tab_data'] = array('title' => $txt['showActivities'], 'description' => $txt['showActivitiesMenu'], 'tabs' => array()); // these areas cannot be visited if it's not our own profile unless you are the mighty one if (($sa == 'notifications' || $sa == 'settings') && !$context['user']['is_owner'] && !$user_info['is_admin']) { fatal_lang_error('no_access'); } $result = smf_db_query(' SELECT a.*, t.*, b.name AS board_name FROM {db_prefix}log_activities AS a LEFT JOIN {db_prefix}activity_types AS t ON (t.id_type = a.id_type) LEFT JOIN {db_prefix}boards AS b ON(b.id_board = a.id_board) WHERE ({query_see_board} OR a.id_board = 0) AND (a.id_member = {int:id_user} OR a.id_owner = {int:id_user}) ORDER BY a.id_act DESC LIMIT {int:start}, 20', array('start' => $start, 'id_user' => $memID)); $context['act_global'] = true; aStreamOutput($result); $context['titletext'] = $context['page_title']; }
function BoardNotify() { global $scripturl, $txt, $board, $user_info, $context, $smcFunc; // Permissions are an important part of anything ;). is_not_guest(); isAllowedTo('mark_notify'); // You have to specify a board to turn notifications on! if (empty($board)) { fatal_lang_error('no_board', false); } // No subaction: find out what to do. if (empty($_GET['sa'])) { // We're gonna need the notify template... Eos_Smarty::loadTemplate('generic_skeleton'); EoS_Smarty::getConfigInstance()->registerHookTemplate('generic_content_area', 'notify/notify_board'); // Find out if they have notification set for this topic already. $request = smf_db_query(' SELECT id_member FROM {db_prefix}log_notify WHERE id_member = {int:current_member} AND id_board = {int:current_board} LIMIT 1', array('current_board' => $board, 'current_member' => $user_info['id'])); $context['notification_set'] = mysql_num_rows($request) != 0; mysql_free_result($request); // Set the template variables... $context['board_href'] = $scripturl . '?board=' . $board . '.' . $_REQUEST['start']; $context['start'] = $_REQUEST['start']; $context['page_title'] = $txt['notification']; return; } elseif ($_GET['sa'] == 'on') { checkSession('get'); // Turn notification on. (note this just blows smoke if it's already on.) smf_db_insert('ignore', '{db_prefix}log_notify', array('id_member' => 'int', 'id_board' => 'int'), array($user_info['id'], $board), array('id_member', 'id_board')); } else { checkSession('get'); // Turn notification off for this board. smf_db_query(' DELETE FROM {db_prefix}log_notify WHERE id_member = {int:current_member} AND id_board = {int:current_board}', array('current_board' => $board, 'current_member' => $user_info['id'])); } // Back to the board! redirectexit('board=' . $board . '.' . $_REQUEST['start']); }
function ViewFile() { global $context, $txt, $boarddir, $sourcedir; // Check for the administrative permission to do this. isAllowedTo('admin_forum'); $context['need_synhlt'] = true; // decode the file and get the line $file = base64_decode($_REQUEST['file']); $line = isset($_REQUEST['line']) ? (int) $_REQUEST['line'] : 0; // Make sure the file we are looking for is one they are allowed to look at if (!is_readable($file) || strpos($file, '../') !== false && (strpos($file, $boarddir) === false || strpos($file, $sourcedir) === false)) { fatal_lang_error('error_bad_file', true, array(htmlspecialchars($file))); } // get the min and max lines $min = $line - 20 <= 0 ? 1 : $line - 20; $max = $line + 21; // One additional line to make everything work out correctly if ($max <= 0 || $min >= $max) { fatal_lang_error('error_bad_line'); } $file_data = explode('<br />', highlight_php_code(htmlspecialchars(implode('', file($file))))); // We don't want to slice off too many so lets make sure we stop at the last one $max = min($max, max(array_keys($file_data))); $file_data = array_slice($file_data, $min - 1, $max - $min); $context['file_data'] = array('contents' => $file_data, 'min' => $min, 'target' => $line, 'file' => strtr($file, array('"' => '\\"'))); Eos_Smarty::loadTemplate('admin/errors_show_file'); //loadAdminTemplate('Errors'); }
function Memberlist() { global $scripturl, $txt, $modSettings, $context, $settings, $modSettings; // Make sure they can view the memberlist. isAllowedTo('view_mlist'); $context['listing_by'] = !empty($_GET['sa']) ? $_GET['sa'] : 'all'; $context['show_sidebar'] = true; $context['sidebar_template'] = 'sidebars/sidebar_memberlist.tpl'; MLSearch(); // $subActions array format: // 'subaction' => array('label', 'function', 'is_selected') $subActions = array('all' => array($txt['view_all_members'], 'MLAll', $context['listing_by'] == 'all'), 'search' => array($txt['mlist_search'], 'MLSearch', $context['listing_by'] == 'search')); // Set up the sort links. $context['sort_links'] = array(); foreach ($subActions as $act => $text) { $context['sort_links'][] = array('label' => $text[0], 'action' => $act, 'selected' => $text[2]); } $context['num_members'] = $modSettings['totalMembers']; // Set up the columns... $context['columns'] = array('is_online' => array('label' => $txt['status'], 'width' => '60', 'class' => 'first_th'), 'real_name' => array('label' => $txt['username']), 'id_group' => array('label' => $txt['position']), 'registered' => array('label' => $txt['date_registered']), 'posts' => array('label' => $txt['posts'], 'width' => '115', 'colspan' => '2', 'default_sort_rev' => true)); $context['colspan'] = 0; $context['disabled_fields'] = isset($modSettings['disabled_profile_fields']) ? array_flip(explode(',', $modSettings['disabled_profile_fields'])) : array(); foreach ($context['columns'] as $key => $column) { if (isset($context['disabled_fields'][$key]) || isset($column['link_with']) && isset($context['disabled_fields'][$column['link_with']])) { unset($context['columns'][$key]); continue; } $context['colspan'] += isset($column['colspan']) ? $column['colspan'] : 1; } // Aesthetic stuff. end($context['columns']); $context['columns'][key($context['columns'])]['class'] = 'last_th'; $context['linktree'][] = array('url' => $scripturl . '?action=mlist', 'name' => $txt['members_list']); $context['can_send_pm'] = allowedTo('pm_send'); // Jump to the sub action. if (isset($subActions[$context['listing_by']])) { $subActions[$context['listing_by']][1](); } else { $subActions['all'][1](); } Eos_Smarty::loadTemplate('memberlist'); }
function ReportsMain() { global $txt, $modSettings, $context, $scripturl; // Only admins, only EVER admins! isAllowedTo('admin_forum'); // Let's get our things running... //loadTemplate('Reports'); Eos_Smarty::setActive(); loadLanguage('Reports'); $context['page_title'] = $txt['generate_reports']; // These are the types of reports which exist - and the functions to generate them. $context['report_types'] = array('boards' => 'BoardReport', 'board_perms' => 'BoardPermissionsReport', 'member_groups' => 'MemberGroupsReport', 'group_perms' => 'GroupPermissionsReport', 'staff' => 'StaffReport'); $is_first = 0; foreach ($context['report_types'] as $k => $temp) { $context['report_types'][$k] = array('id' => $k, 'title' => isset($txt['gr_type_' . $k]) ? $txt['gr_type_' . $k] : $type['id'], 'description' => isset($txt['gr_type_desc_' . $k]) ? $txt['gr_type_desc_' . $k] : null, 'function' => $temp, 'is_first' => $is_first++ == 0); } // If they haven't choosen a report type which is valid, send them off to the report type chooser! if (empty($_REQUEST['rt']) || !isset($context['report_types'][$_REQUEST['rt']])) { $context['sub_template'] = 'report_type'; Eos_Smarty::loadTemplate('reports/base'); Eos_Smarty::getConfigInstance()->registerHookTemplate('reports_content_area', 'reports/choose_type'); return; } $context['report_type'] = $_REQUEST['rt']; $context['report_buttons'] = array('generate_reports' => array('text' => 'generate_reports', 'image' => 'print.gif', 'lang' => true, 'url' => $scripturl . '?action=admin;area=reports', 'active' => true), 'print' => array('text' => 'print', 'image' => 'print.gif', 'lang' => true, 'url' => $scripturl . '?action=admin;area=reports;rt=' . $context['report_type'] . ';st=print', 'custom' => 'target="_blank"')); // What are valid templates for showing reports? $reportTemplates = array('main' => array('layers' => null), 'print' => array('layers' => array('print'))); // Specific template? Use that instead of main! if (isset($_REQUEST['st']) && isset($reportTemplates[$_REQUEST['st']])) { // Are we disabling the other layers - print friendly for example? if ($reportTemplates[$_REQUEST['st']]['layers'] !== null) { Eos_Smarty::loadTemplate('reports/print'); $context['template_layers'] = $reportTemplates[$_REQUEST['st']]['layers']; } } else { Eos_Smarty::loadTemplate('reports/base'); Eos_Smarty::getConfigInstance()->registerHookTemplate('reports_content_area', 'reports/main'); } // Make the page title more descriptive. $context['page_title'] .= ' - ' . (isset($txt['gr_type_' . $context['report_type']]) ? $txt['gr_type_' . $context['report_type']] : $context['report_type']); // Now generate the data. $context['report_types'][$context['report_type']]['function'](); // Finish the tables before exiting - this is to help the templates a little more. finishTables(); }
function DisplayStats() { global $txt, $scripturl, $modSettings, $user_info, $context, $smcFunc; isAllowedTo('view_stats'); if (!empty($_REQUEST['expand'])) { $context['robot_no_index'] = true; $month = (int) substr($_REQUEST['expand'], 4); $year = (int) substr($_REQUEST['expand'], 0, 4); if ($year > 1900 && $year < 2200 && $month >= 1 && $month <= 12) { $_SESSION['expanded_stats'][$year][] = $month; } } elseif (!empty($_REQUEST['collapse'])) { $context['robot_no_index'] = true; $month = (int) substr($_REQUEST['collapse'], 4); $year = (int) substr($_REQUEST['collapse'], 0, 4); if (!empty($_SESSION['expanded_stats'][$year])) { $_SESSION['expanded_stats'][$year] = array_diff($_SESSION['expanded_stats'][$year], array($month)); } } // Handle the XMLHttpRequest. if (isset($_REQUEST['xml'])) { // Collapsing stats only needs adjustments of the session variables. if (!empty($_REQUEST['collapse'])) { obExit(false); } $context['sub_template'] = 'stats'; getDailyStats('YEAR(date) = {int:year} AND MONTH(date) = {int:month}', array('year' => $year, 'month' => $month)); $context['yearly'][$year]['months'][$month]['date'] = array('month' => sprintf('%02d', $month), 'year' => $year); return; } loadLanguage('Stats'); Eos_Smarty::loadTemplate('forumstats'); // Build the link tree...... $context['linktree'][] = array('url' => $scripturl . '?action=stats', 'name' => $txt['stats_center']); $context['page_title'] = $context['forum_name'] . ' - ' . $txt['stats_center']; $context['show_member_list'] = allowedTo('view_mlist'); // Get averages... $result = smf_db_query(' SELECT SUM(posts) AS posts, SUM(topics) AS topics, SUM(registers) AS registers, SUM(most_on) AS most_on, MIN(date) AS date, SUM(hits) AS hits FROM {db_prefix}log_activity', array()); $row = mysql_fetch_assoc($result); mysql_free_result($result); // This would be the amount of time the forum has been up... in days... $total_days_up = ceil((time() - strtotime($row['date'])) / (60 * 60 * 24)); $context['average_posts'] = comma_format(round($row['posts'] / $total_days_up, 2)); $context['average_topics'] = comma_format(round($row['topics'] / $total_days_up, 2)); $context['average_members'] = comma_format(round($row['registers'] / $total_days_up, 2)); $context['average_online'] = comma_format(round($row['most_on'] / $total_days_up, 2)); $context['average_hits'] = comma_format(round($row['hits'] / $total_days_up, 2)); $context['num_hits'] = comma_format($row['hits'], 0); // How many users are online now. $result = smf_db_query(' SELECT COUNT(*) FROM {db_prefix}log_online', array()); list($context['users_online']) = mysql_fetch_row($result); mysql_free_result($result); // Statistics such as number of boards, categories, etc. $result = smf_db_query(' SELECT COUNT(*) FROM {db_prefix}boards AS b WHERE b.redirect = {string:blank_redirect}', array('blank_redirect' => '')); list($context['num_boards']) = mysql_fetch_row($result); mysql_free_result($result); $result = smf_db_query(' SELECT COUNT(*) FROM {db_prefix}categories AS c', array()); list($context['num_categories']) = mysql_fetch_row($result); mysql_free_result($result); // Format the numbers nicely. $context['users_online'] = comma_format($context['users_online']); $context['num_boards'] = comma_format($context['num_boards']); $context['num_categories'] = comma_format($context['num_categories']); $context['num_members'] = comma_format($modSettings['totalMembers']); $context['num_posts'] = comma_format($modSettings['totalMessages']); $context['num_topics'] = comma_format($modSettings['totalTopics']); $context['most_members_online'] = array('number' => comma_format($modSettings['mostOnline']), 'date' => timeformat($modSettings['mostDate'])); $context['latest_member'] =& $context['common_stats']['latest_member']; // Male vs. female ratio - let's calculate this only every four minutes. if (($context['gender'] = CacheAPI::getCache('stats_gender', 240)) == null) { $result = smf_db_query(' SELECT COUNT(*) AS total_members, gender FROM {db_prefix}members GROUP BY gender', array()); $context['gender'] = array(); while ($row = mysql_fetch_assoc($result)) { // Assuming we're telling... male or female? if (!empty($row['gender'])) { $context['gender'][$row['gender'] == 2 ? 'females' : 'males'] = $row['total_members']; } } mysql_free_result($result); // Set these two zero if the didn't get set at all. if (empty($context['gender']['males'])) { $context['gender']['males'] = 0; } if (empty($context['gender']['females'])) { $context['gender']['females'] = 0; } // Try and come up with some "sensible" default states in case of a non-mixed board. if ($context['gender']['males'] == $context['gender']['females']) { $context['gender']['ratio'] = '1:1'; } elseif ($context['gender']['males'] == 0) { $context['gender']['ratio'] = '0:1'; } elseif ($context['gender']['females'] == 0) { $context['gender']['ratio'] = '1:0'; } elseif ($context['gender']['males'] > $context['gender']['females']) { $context['gender']['ratio'] = round($context['gender']['males'] / $context['gender']['females'], 1) . ':1'; } elseif ($context['gender']['females'] > $context['gender']['males']) { $context['gender']['ratio'] = '1:' . round($context['gender']['females'] / $context['gender']['males'], 1); } CacheAPI::putCache('stats_gender', $context['gender'], 240); } $date = strftime('%Y-%m-%d', forum_time(false)); // Members online so far today. $result = smf_db_query(' SELECT most_on FROM {db_prefix}log_activity WHERE date = {date:today_date} LIMIT 1', array('today_date' => $date)); list($context['online_today']) = mysql_fetch_row($result); mysql_free_result($result); $context['online_today'] = comma_format((int) $context['online_today']); // Poster top 10. $members_result = smf_db_query(' SELECT id_member, real_name, posts FROM {db_prefix}members WHERE posts > {int:no_posts} ORDER BY posts DESC LIMIT 10', array('no_posts' => 0)); $context['top_posters'] = array(); $max_num_posts = 1; while ($row_members = mysql_fetch_assoc($members_result)) { $context['top_posters'][] = array('name' => $row_members['real_name'], 'id' => $row_members['id_member'], 'num_posts' => $row_members['posts'], 'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'], 'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'); if ($max_num_posts < $row_members['posts']) { $max_num_posts = $row_members['posts']; } } mysql_free_result($members_result); foreach ($context['top_posters'] as $i => $poster) { $context['top_posters'][$i]['post_percent'] = round($poster['num_posts'] * 100 / $max_num_posts); $context['top_posters'][$i]['num_posts'] = comma_format($context['top_posters'][$i]['num_posts']); } // Board top 10. $boards_result = smf_db_query(' SELECT id_board, name, num_posts FROM {db_prefix}boards AS b WHERE {query_see_board}' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? ' AND b.id_board != {int:recycle_board}' : '') . ' AND b.redirect = {string:blank_redirect} ORDER BY num_posts DESC LIMIT 10', array('recycle_board' => $modSettings['recycle_board'], 'blank_redirect' => '')); $context['top_boards'] = array(); $max_num_posts = 1; while ($row_board = mysql_fetch_assoc($boards_result)) { $context['top_boards'][] = array('id' => $row_board['id_board'], 'name' => $row_board['name'], 'num_posts' => $row_board['num_posts'], 'href' => $scripturl . '?board=' . $row_board['id_board'] . '.0', 'link' => '<a href="' . $scripturl . '?board=' . $row_board['id_board'] . '.0">' . $row_board['name'] . '</a>'); if ($max_num_posts < $row_board['num_posts']) { $max_num_posts = $row_board['num_posts']; } } mysql_free_result($boards_result); foreach ($context['top_boards'] as $i => $board) { $context['top_boards'][$i]['post_percent'] = round($board['num_posts'] * 100 / $max_num_posts); $context['top_boards'][$i]['num_posts'] = comma_format($context['top_boards'][$i]['num_posts']); } // Are you on a larger forum? If so, let's try to limit the number of topics we search through. if ($modSettings['totalMessages'] > 100000) { $request = smf_db_query(' SELECT id_topic FROM {db_prefix}topics WHERE num_replies != {int:no_replies}' . ($modSettings['postmod_active'] ? ' AND approved = {int:is_approved}' : '') . ' ORDER BY num_replies DESC LIMIT 100', array('no_replies' => 0, 'is_approved' => 1)); $topic_ids = array(); while ($row = mysql_fetch_assoc($request)) { $topic_ids[] = $row['id_topic']; } mysql_free_result($request); } else { $topic_ids = array(); } // Topic replies top 10. $topic_reply_result = smf_db_query(' SELECT m.subject, t.num_replies, t.id_board, t.id_topic, b.name FROM {db_prefix}topics AS t INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg) INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? ' AND b.id_board != {int:recycle_board}' : '') . ') WHERE {query_see_board}' . (!empty($topic_ids) ? ' AND t.id_topic IN ({array_int:topic_list})' : ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '')) . ' ORDER BY t.num_replies DESC LIMIT 10', array('topic_list' => $topic_ids, 'recycle_board' => $modSettings['recycle_board'], 'is_approved' => 1)); $context['top_topics_replies'] = array(); $max_num_replies = 1; while ($row_topic_reply = mysql_fetch_assoc($topic_reply_result)) { censorText($row_topic_reply['subject']); $context['top_topics_replies'][] = array('id' => $row_topic_reply['id_topic'], 'board' => array('id' => $row_topic_reply['id_board'], 'name' => $row_topic_reply['name'], 'href' => $scripturl . '?board=' . $row_topic_reply['id_board'] . '.0', 'link' => '<a href="' . $scripturl . '?board=' . $row_topic_reply['id_board'] . '.0">' . $row_topic_reply['name'] . '</a>'), 'subject' => $row_topic_reply['subject'], 'num_replies' => $row_topic_reply['num_replies'], 'href' => $scripturl . '?topic=' . $row_topic_reply['id_topic'] . '.0', 'link' => '<a href="' . $scripturl . '?topic=' . $row_topic_reply['id_topic'] . '.0">' . $row_topic_reply['subject'] . '</a>'); if ($max_num_replies < $row_topic_reply['num_replies']) { $max_num_replies = $row_topic_reply['num_replies']; } } mysql_free_result($topic_reply_result); foreach ($context['top_topics_replies'] as $i => $topic) { $context['top_topics_replies'][$i]['post_percent'] = round($topic['num_replies'] * 100 / $max_num_replies); $context['top_topics_replies'][$i]['num_replies'] = comma_format($context['top_topics_replies'][$i]['num_replies']); } // Large forums may need a bit more prodding... if ($modSettings['totalMessages'] > 100000) { $request = smf_db_query(' SELECT id_topic FROM {db_prefix}topics WHERE num_views != {int:no_views} ORDER BY num_views DESC LIMIT 100', array('no_views' => 0)); $topic_ids = array(); while ($row = mysql_fetch_assoc($request)) { $topic_ids[] = $row['id_topic']; } mysql_free_result($request); } else { $topic_ids = array(); } // Topic views top 10. $topic_view_result = smf_db_query(' SELECT m.subject, t.num_views, t.id_board, t.id_topic, b.name FROM {db_prefix}topics AS t INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg) INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? ' AND b.id_board != {int:recycle_board}' : '') . ') WHERE {query_see_board}' . (!empty($topic_ids) ? ' AND t.id_topic IN ({array_int:topic_list})' : ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '')) . ' ORDER BY t.num_views DESC LIMIT 10', array('topic_list' => $topic_ids, 'recycle_board' => $modSettings['recycle_board'], 'is_approved' => 1)); $context['top_topics_views'] = array(); $max_num_views = 1; while ($row_topic_views = mysql_fetch_assoc($topic_view_result)) { censorText($row_topic_views['subject']); $context['top_topics_views'][] = array('id' => $row_topic_views['id_topic'], 'board' => array('id' => $row_topic_views['id_board'], 'name' => $row_topic_views['name'], 'href' => $scripturl . '?board=' . $row_topic_views['id_board'] . '.0', 'link' => '<a href="' . $scripturl . '?board=' . $row_topic_views['id_board'] . '.0">' . $row_topic_views['name'] . '</a>'), 'subject' => $row_topic_views['subject'], 'num_views' => $row_topic_views['num_views'], 'href' => $scripturl . '?topic=' . $row_topic_views['id_topic'] . '.0', 'link' => '<a href="' . $scripturl . '?topic=' . $row_topic_views['id_topic'] . '.0">' . $row_topic_views['subject'] . '</a>'); if ($max_num_views < $row_topic_views['num_views']) { $max_num_views = $row_topic_views['num_views']; } } mysql_free_result($topic_view_result); foreach ($context['top_topics_views'] as $i => $topic) { $context['top_topics_views'][$i]['post_percent'] = round($topic['num_views'] * 100 / $max_num_views); $context['top_topics_views'][$i]['num_views'] = comma_format($context['top_topics_views'][$i]['num_views']); } // Try to cache this when possible, because it's a little unavoidably slow. if (($members = CacheAPI::getCache('stats_top_starters', 360)) == null) { $request = smf_db_query(' SELECT id_member_started, COUNT(*) AS hits FROM {db_prefix}topics' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? ' WHERE id_board != {int:recycle_board}' : '') . ' GROUP BY id_member_started ORDER BY hits DESC LIMIT 20', array('recycle_board' => $modSettings['recycle_board'])); $members = array(); while ($row = mysql_fetch_assoc($request)) { $members[$row['id_member_started']] = $row['hits']; } mysql_free_result($request); CacheAPI::putCache('stats_top_starters', $members, 360); } if (empty($members)) { $members = array(0 => 0); } // Topic poster top 10. $members_result = smf_db_query(' SELECT id_member, real_name FROM {db_prefix}members WHERE id_member IN ({array_int:member_list}) ORDER BY FIND_IN_SET(id_member, {string:top_topic_posters}) LIMIT 10', array('member_list' => array_keys($members), 'top_topic_posters' => implode(',', array_keys($members)))); $context['top_starters'] = array(); $max_num_topics = 1; while ($row_members = mysql_fetch_assoc($members_result)) { $context['top_starters'][] = array('name' => $row_members['real_name'], 'id' => $row_members['id_member'], 'num_topics' => $members[$row_members['id_member']], 'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'], 'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'); if ($max_num_topics < $members[$row_members['id_member']]) { $max_num_topics = $members[$row_members['id_member']]; } } mysql_free_result($members_result); foreach ($context['top_starters'] as $i => $topic) { $context['top_starters'][$i]['post_percent'] = round($topic['num_topics'] * 100 / $max_num_topics); $context['top_starters'][$i]['num_topics'] = comma_format($context['top_starters'][$i]['num_topics']); } // Time online top 10. $temp = CacheAPI::getCache('stats_total_time_members', 600); $members_result = smf_db_query(' SELECT id_member, real_name, total_time_logged_in FROM {db_prefix}members' . (!empty($temp) ? ' WHERE id_member IN ({array_int:member_list_cached})' : '') . ' ORDER BY total_time_logged_in DESC LIMIT 20', array('member_list_cached' => $temp)); $context['top_time_online'] = array(); $temp2 = array(); $max_time_online = 1; while ($row_members = mysql_fetch_assoc($members_result)) { $temp2[] = (int) $row_members['id_member']; if (count($context['top_time_online']) >= 10) { continue; } // Figure out the days, hours and minutes. $timeDays = floor($row_members['total_time_logged_in'] / 86400); $timeHours = floor($row_members['total_time_logged_in'] % 86400 / 3600); // Figure out which things to show... (days, hours, minutes, etc.) $timelogged = ''; if ($timeDays > 0) { $timelogged .= $timeDays . $txt['totalTimeLogged5']; } if ($timeHours > 0) { $timelogged .= $timeHours . $txt['totalTimeLogged6']; } $timelogged .= floor($row_members['total_time_logged_in'] % 3600 / 60) . $txt['totalTimeLogged7']; $context['top_time_online'][] = array('id' => $row_members['id_member'], 'name' => $row_members['real_name'], 'time_online' => $timelogged, 'seconds_online' => $row_members['total_time_logged_in'], 'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'], 'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'); if ($max_time_online < $row_members['total_time_logged_in']) { $max_time_online = $row_members['total_time_logged_in']; } } mysql_free_result($members_result); foreach ($context['top_time_online'] as $i => $member) { $context['top_time_online'][$i]['time_percent'] = round($member['seconds_online'] * 100 / $max_time_online); } // Cache the ones we found for a bit, just so we don't have to look again. if ($temp !== $temp2) { CacheAPI::putCache('stats_total_time_members', $temp2, 480); } // Activity by month. $months_result = smf_db_query(' SELECT YEAR(date) AS stats_year, MONTH(date) AS stats_month, SUM(hits) AS hits, SUM(registers) AS registers, SUM(topics) AS topics, SUM(posts) AS posts, MAX(most_on) AS most_on, COUNT(*) AS num_days FROM {db_prefix}log_activity GROUP BY stats_year, stats_month', array()); $context['yearly'] = array(); while ($row_months = mysql_fetch_assoc($months_result)) { $ID_MONTH = $row_months['stats_year'] . sprintf('%02d', $row_months['stats_month']); $expanded = !empty($_SESSION['expanded_stats'][$row_months['stats_year']]) && in_array($row_months['stats_month'], $_SESSION['expanded_stats'][$row_months['stats_year']]); if (!isset($context['yearly'][$row_months['stats_year']])) { $context['yearly'][$row_months['stats_year']] = array('year' => $row_months['stats_year'], 'new_topics' => 0, 'new_posts' => 0, 'new_members' => 0, 'most_members_online' => 0, 'hits' => 0, 'num_months' => 0, 'months' => array(), 'expanded' => false, 'current_year' => $row_months['stats_year'] == date('Y')); } $context['yearly'][$row_months['stats_year']]['months'][(int) $row_months['stats_month']] = array('id' => $ID_MONTH, 'date' => array('month' => sprintf('%02d', $row_months['stats_month']), 'year' => $row_months['stats_year']), 'href' => $scripturl . '?action=stats;' . ($expanded ? 'collapse' : 'expand') . '=' . $ID_MONTH . '#m' . $ID_MONTH, 'link' => '<a href="' . $scripturl . '?action=stats;' . ($expanded ? 'collapse' : 'expand') . '=' . $ID_MONTH . '#m' . $ID_MONTH . '">' . $txt['months'][(int) $row_months['stats_month']] . ' ' . $row_months['stats_year'] . '</a>', 'month' => $txt['months'][(int) $row_months['stats_month']], 'year' => $row_months['stats_year'], 'new_topics' => comma_format($row_months['topics']), 'new_posts' => comma_format($row_months['posts']), 'new_members' => comma_format($row_months['registers']), 'most_members_online' => comma_format($row_months['most_on']), 'hits' => comma_format($row_months['hits']), 'num_days' => $row_months['num_days'], 'days' => array(), 'expanded' => $expanded); $context['yearly'][$row_months['stats_year']]['new_topics'] += $row_months['topics']; $context['yearly'][$row_months['stats_year']]['new_posts'] += $row_months['posts']; $context['yearly'][$row_months['stats_year']]['new_members'] += $row_months['registers']; $context['yearly'][$row_months['stats_year']]['hits'] += $row_months['hits']; $context['yearly'][$row_months['stats_year']]['num_months']++; $context['yearly'][$row_months['stats_year']]['expanded'] |= $expanded; $context['yearly'][$row_months['stats_year']]['most_members_online'] = max($context['yearly'][$row_months['stats_year']]['most_members_online'], $row_months['most_on']); } krsort($context['yearly']); $context['collapsed_years'] = array(); foreach ($context['yearly'] as $year => $data) { // This gets rid of the filesort on the query ;). krsort($context['yearly'][$year]['months']); $context['yearly'][$year]['new_topics'] = comma_format($data['new_topics']); $context['yearly'][$year]['new_posts'] = comma_format($data['new_posts']); $context['yearly'][$year]['new_members'] = comma_format($data['new_members']); $context['yearly'][$year]['most_members_online'] = comma_format($data['most_members_online']); $context['yearly'][$year]['hits'] = comma_format($data['hits']); // Keep a list of collapsed years. if (!$data['expanded'] && !$data['current_year']) { $context['collapsed_years'][] = $year; } } if (empty($_SESSION['expanded_stats'])) { return; } $condition_text = array(); $condition_params = array(); foreach ($_SESSION['expanded_stats'] as $year => $months) { if (!empty($months)) { $condition_text[] = 'YEAR(date) = {int:year_' . $year . '} AND MONTH(date) IN ({array_int:months_' . $year . '})'; $condition_params['year_' . $year] = $year; $condition_params['months_' . $year] = $months; } } // No daily stats to even look at? if (empty($condition_text)) { return; } getDailyStats(implode(' OR ', $condition_text), $condition_params); }