Chris@76: <?php
Chris@76: 
Chris@76: /**
Chris@76:  * Simple Machines Forum (SMF)
Chris@76:  *
Chris@76:  * @package SMF
Chris@76:  * @author Simple Machines http://www.simplemachines.org
Chris@76:  * @copyright 2011 Simple Machines
Chris@76:  * @license http://www.simplemachines.org/about/smf/license.php BSD
Chris@76:  *
Chris@76:  * @version 2.0
Chris@76:  */
Chris@76: 
Chris@76: if (!defined('SMF'))
Chris@76: 	die('Hacking attempt...');
Chris@76: 
Chris@76: /*	This function has only one job: providing a display for forum statistics.
Chris@76: 	As such, it has only one function:
Chris@76: 
Chris@76: 	void DisplayStats()
Chris@76: 		- gets all the statistics in order and puts them in.
Chris@76: 		- uses the Stats template and language file. (and main sub template.)
Chris@76: 		- requires the view_stats permission.
Chris@76: 		- accessed from ?action=stats.
Chris@76: 
Chris@76: 	void getDailyStats(string $condition)
Chris@76: 		- called by DisplayStats().
Chris@76: 		- loads the statistics on a daily basis in $context.
Chris@76: 
Chris@76: 	void SMStats()
Chris@76: 		- called by simplemachines.org.
Chris@76: 		- only returns anything if stats was enabled during installation.
Chris@76: 		- can also be accessed by the admin, to show what stats sm.org collects.
Chris@76: 		- does not return any data directly to sm.org, instead starts a new request for security.
Chris@76: 
Chris@76: */
Chris@76: 
Chris@76: // Display some useful/interesting board statistics.
Chris@76: function DisplayStats()
Chris@76: {
Chris@76: 	global $txt, $scripturl, $modSettings, $user_info, $context, $smcFunc;
Chris@76: 
Chris@76: 	isAllowedTo('view_stats');
Chris@76: 
Chris@76: 	if (!empty($_REQUEST['expand']))
Chris@76: 	{
Chris@76: 		$context['robot_no_index'] = true;
Chris@76: 
Chris@76: 		$month = (int) substr($_REQUEST['expand'], 4);
Chris@76: 		$year = (int) substr($_REQUEST['expand'], 0, 4);
Chris@76: 		if ($year > 1900 && $year < 2200 && $month >= 1 && $month <= 12)
Chris@76: 			$_SESSION['expanded_stats'][$year][] = $month;
Chris@76: 	}
Chris@76: 	elseif (!empty($_REQUEST['collapse']))
Chris@76: 	{
Chris@76: 		$context['robot_no_index'] = true;
Chris@76: 
Chris@76: 		$month = (int) substr($_REQUEST['collapse'], 4);
Chris@76: 		$year = (int) substr($_REQUEST['collapse'], 0, 4);
Chris@76: 		if (!empty($_SESSION['expanded_stats'][$year]))
Chris@76: 			$_SESSION['expanded_stats'][$year] = array_diff($_SESSION['expanded_stats'][$year], array($month));
Chris@76: 	}
Chris@76: 
Chris@76: 	// Handle the XMLHttpRequest.
Chris@76: 	if (isset($_REQUEST['xml']))
Chris@76: 	{
Chris@76: 		// Collapsing stats only needs adjustments of the session variables.
Chris@76: 		if (!empty($_REQUEST['collapse']))
Chris@76: 			obExit(false);
Chris@76: 
Chris@76: 		$context['sub_template'] = 'stats';
Chris@76: 		getDailyStats('YEAR(date) = {int:year} AND MONTH(date) = {int:month}', array('year' => $year, 'month' => $month));
Chris@76: 		$context['yearly'][$year]['months'][$month]['date'] = array(
Chris@76: 			'month' => sprintf('%02d', $month),
Chris@76: 			'year' => $year,
Chris@76: 		);
Chris@76: 		return;
Chris@76: 	}
Chris@76: 
Chris@76: 	loadLanguage('Stats');
Chris@76: 	loadTemplate('Stats');
Chris@76: 
Chris@76: 	// Build the link tree......
Chris@76: 	$context['linktree'][] = array(
Chris@76: 		'url' => $scripturl . '?action=stats',
Chris@76: 		'name' => $txt['stats_center']
Chris@76: 	);
Chris@76: 	$context['page_title'] = $context['forum_name'] . ' - ' . $txt['stats_center'];
Chris@76: 
Chris@76: 	$context['show_member_list'] = allowedTo('view_mlist');
Chris@76: 
Chris@76: 	// Get averages...
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			SUM(posts) AS posts, SUM(topics) AS topics, SUM(registers) AS registers,
Chris@76: 			SUM(most_on) AS most_on, MIN(date) AS date, SUM(hits) AS hits
Chris@76: 		FROM {db_prefix}log_activity',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$row = $smcFunc['db_fetch_assoc']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// This would be the amount of time the forum has been up... in days...
Chris@76: 	$total_days_up = ceil((time() - strtotime($row['date'])) / (60 * 60 * 24));
Chris@76: 
Chris@76: 	$context['average_posts'] = comma_format(round($row['posts'] / $total_days_up, 2));
Chris@76: 	$context['average_topics'] = comma_format(round($row['topics'] / $total_days_up, 2));
Chris@76: 	$context['average_members'] = comma_format(round($row['registers'] / $total_days_up, 2));
Chris@76: 	$context['average_online'] = comma_format(round($row['most_on'] / $total_days_up, 2));
Chris@76: 	$context['average_hits'] = comma_format(round($row['hits'] / $total_days_up, 2));
Chris@76: 
Chris@76: 	$context['num_hits'] = comma_format($row['hits'], 0);
Chris@76: 
Chris@76: 	// How many users are online now.
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}log_online',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['users_online']) = $smcFunc['db_fetch_row']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// Statistics such as number of boards, categories, etc.
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}boards AS b
Chris@76: 		WHERE b.redirect = {string:blank_redirect}',
Chris@76: 		array(
Chris@76: 			'blank_redirect' => '',
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['num_boards']) = $smcFunc['db_fetch_row']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}categories AS c',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['num_categories']) = $smcFunc['db_fetch_row']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// Format the numbers nicely.
Chris@76: 	$context['users_online'] = comma_format($context['users_online']);
Chris@76: 	$context['num_boards'] = comma_format($context['num_boards']);
Chris@76: 	$context['num_categories'] = comma_format($context['num_categories']);
Chris@76: 
Chris@76: 	$context['num_members'] = comma_format($modSettings['totalMembers']);
Chris@76: 	$context['num_posts'] = comma_format($modSettings['totalMessages']);
Chris@76: 	$context['num_topics'] = comma_format($modSettings['totalTopics']);
Chris@76: 	$context['most_members_online'] = array(
Chris@76: 		'number' => comma_format($modSettings['mostOnline']),
Chris@76: 		'date' => timeformat($modSettings['mostDate'])
Chris@76: 	);
Chris@76: 	$context['latest_member'] = &$context['common_stats']['latest_member'];
Chris@76: 
Chris@76: 	// Male vs. female ratio - let's calculate this only every four minutes.
Chris@76: 	if (($context['gender'] = cache_get_data('stats_gender', 240)) == null)
Chris@76: 	{
Chris@76: 		$result = $smcFunc['db_query']('', '
Chris@76: 			SELECT COUNT(*) AS total_members, gender
Chris@76: 			FROM {db_prefix}members
Chris@76: 			GROUP BY gender',
Chris@76: 			array(
Chris@76: 			)
Chris@76: 		);
Chris@76: 		$context['gender'] = array();
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 		{
Chris@76: 			// Assuming we're telling... male or female?
Chris@76: 			if (!empty($row['gender']))
Chris@76: 				$context['gender'][$row['gender'] == 2 ? 'females' : 'males'] = $row['total_members'];
Chris@76: 		}
Chris@76: 		$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 		// Set these two zero if the didn't get set at all.
Chris@76: 		if (empty($context['gender']['males']))
Chris@76: 			$context['gender']['males'] = 0;
Chris@76: 		if (empty($context['gender']['females']))
Chris@76: 			$context['gender']['females'] = 0;
Chris@76: 
Chris@76: 		// Try and come up with some "sensible" default states in case of a non-mixed board.
Chris@76: 		if ($context['gender']['males'] == $context['gender']['females'])
Chris@76: 			$context['gender']['ratio'] = '1:1';
Chris@76: 		elseif ($context['gender']['males'] == 0)
Chris@76: 			$context['gender']['ratio'] = '0:1';
Chris@76: 		elseif ($context['gender']['females'] == 0)
Chris@76: 			$context['gender']['ratio'] = '1:0';
Chris@76: 		elseif ($context['gender']['males'] > $context['gender']['females'])
Chris@76: 			$context['gender']['ratio'] = round($context['gender']['males'] / $context['gender']['females'], 1) . ':1';
Chris@76: 		elseif ($context['gender']['females'] > $context['gender']['males'])
Chris@76: 			$context['gender']['ratio'] = '1:' . round($context['gender']['females'] / $context['gender']['males'], 1);
Chris@76: 
Chris@76: 		cache_put_data('stats_gender', $context['gender'], 240);
Chris@76: 	}
Chris@76: 
Chris@76: 	$date = strftime('%Y-%m-%d', forum_time(false));
Chris@76: 
Chris@76: 	// Members online so far today.
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT most_on
Chris@76: 		FROM {db_prefix}log_activity
Chris@76: 		WHERE date = {date:today_date}
Chris@76: 		LIMIT 1',
Chris@76: 		array(
Chris@76: 			'today_date' => $date,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['online_today']) = $smcFunc['db_fetch_row']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	$context['online_today'] = comma_format((int) $context['online_today']);
Chris@76: 
Chris@76: 	// Poster top 10.
Chris@76: 	$members_result = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_member, real_name, posts
Chris@76: 		FROM {db_prefix}members
Chris@76: 		WHERE posts > {int:no_posts}
Chris@76: 		ORDER BY posts DESC
Chris@76: 		LIMIT 10',
Chris@76: 		array(
Chris@76: 			'no_posts' => 0,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['top_posters'] = array();
Chris@76: 	$max_num_posts = 1;
Chris@76: 	while ($row_members = $smcFunc['db_fetch_assoc']($members_result))
Chris@76: 	{
Chris@76: 		$context['top_posters'][] = array(
Chris@76: 			'name' => $row_members['real_name'],
Chris@76: 			'id' => $row_members['id_member'],
Chris@76: 			'num_posts' => $row_members['posts'],
Chris@76: 			'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
Chris@76: 			'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($max_num_posts < $row_members['posts'])
Chris@76: 			$max_num_posts = $row_members['posts'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($members_result);
Chris@76: 
Chris@76: 	foreach ($context['top_posters'] as $i => $poster)
Chris@76: 	{
Chris@76: 		$context['top_posters'][$i]['post_percent'] = round(($poster['num_posts'] * 100) / $max_num_posts);
Chris@76: 		$context['top_posters'][$i]['num_posts'] = comma_format($context['top_posters'][$i]['num_posts']);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Board top 10.
Chris@76: 	$boards_result = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_board, name, num_posts
Chris@76: 		FROM {db_prefix}boards AS b
Chris@76: 		WHERE {query_see_board}' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
Chris@76: 			AND b.id_board != {int:recycle_board}' : '') . '
Chris@76: 			AND b.redirect = {string:blank_redirect}
Chris@76: 		ORDER BY num_posts DESC
Chris@76: 		LIMIT 10',
Chris@76: 		array(
Chris@76: 			'recycle_board' => $modSettings['recycle_board'],
Chris@76: 			'blank_redirect' => '',
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['top_boards'] = array();
Chris@76: 	$max_num_posts = 1;
Chris@76: 	while ($row_board = $smcFunc['db_fetch_assoc']($boards_result))
Chris@76: 	{
Chris@76: 		$context['top_boards'][] = array(
Chris@76: 			'id' => $row_board['id_board'],
Chris@76: 			'name' => $row_board['name'],
Chris@76: 			'num_posts' => $row_board['num_posts'],
Chris@76: 			'href' => $scripturl . '?board=' . $row_board['id_board'] . '.0',
Chris@76: 			'link' => '<a href="' . $scripturl . '?board=' . $row_board['id_board'] . '.0">' . $row_board['name'] . '</a>'
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($max_num_posts < $row_board['num_posts'])
Chris@76: 			$max_num_posts = $row_board['num_posts'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($boards_result);
Chris@76: 
Chris@76: 	foreach ($context['top_boards'] as $i => $board)
Chris@76: 	{
Chris@76: 		$context['top_boards'][$i]['post_percent'] = round(($board['num_posts'] * 100) / $max_num_posts);
Chris@76: 		$context['top_boards'][$i]['num_posts'] = comma_format($context['top_boards'][$i]['num_posts']);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Are you on a larger forum?  If so, let's try to limit the number of topics we search through.
Chris@76: 	if ($modSettings['totalMessages'] > 100000)
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_topic
Chris@76: 			FROM {db_prefix}topics
Chris@76: 			WHERE num_replies != {int:no_replies}' . ($modSettings['postmod_active'] ? '
Chris@76: 				AND approved = {int:is_approved}' : '') . '
Chris@76: 			ORDER BY num_replies DESC
Chris@76: 			LIMIT 100',
Chris@76: 			array(
Chris@76: 				'no_replies' => 0,
Chris@76: 				'is_approved' => 1,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		$topic_ids = array();
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 			$topic_ids[] = $row['id_topic'];
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$topic_ids = array();
Chris@76: 
Chris@76: 	// Topic replies top 10.
Chris@76: 	$topic_reply_result = $smcFunc['db_query']('', '
Chris@76: 		SELECT m.subject, t.num_replies, t.id_board, t.id_topic, b.name
Chris@76: 		FROM {db_prefix}topics AS t
Chris@76: 			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
Chris@76: 			AND b.id_board != {int:recycle_board}' : '') . ')
Chris@76: 		WHERE {query_see_board}' . (!empty($topic_ids) ? '
Chris@76: 			AND t.id_topic IN ({array_int:topic_list})' : ($modSettings['postmod_active'] ? '
Chris@76: 			AND t.approved = {int:is_approved}' : '')) . '
Chris@76: 		ORDER BY t.num_replies DESC
Chris@76: 		LIMIT 10',
Chris@76: 		array(
Chris@76: 			'topic_list' => $topic_ids,
Chris@76: 			'recycle_board' => $modSettings['recycle_board'],
Chris@76: 			'is_approved' => 1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['top_topics_replies'] = array();
Chris@76: 	$max_num_replies = 1;
Chris@76: 	while ($row_topic_reply = $smcFunc['db_fetch_assoc']($topic_reply_result))
Chris@76: 	{
Chris@76: 		censorText($row_topic_reply['subject']);
Chris@76: 
Chris@76: 		$context['top_topics_replies'][] = array(
Chris@76: 			'id' => $row_topic_reply['id_topic'],
Chris@76: 			'board' => array(
Chris@76: 				'id' => $row_topic_reply['id_board'],
Chris@76: 				'name' => $row_topic_reply['name'],
Chris@76: 				'href' => $scripturl . '?board=' . $row_topic_reply['id_board'] . '.0',
Chris@76: 				'link' => '<a href="' . $scripturl . '?board=' . $row_topic_reply['id_board'] . '.0">' . $row_topic_reply['name'] . '</a>'
Chris@76: 			),
Chris@76: 			'subject' => $row_topic_reply['subject'],
Chris@76: 			'num_replies' => $row_topic_reply['num_replies'],
Chris@76: 			'href' => $scripturl . '?topic=' . $row_topic_reply['id_topic'] . '.0',
Chris@76: 			'link' => '<a href="' . $scripturl . '?topic=' . $row_topic_reply['id_topic'] . '.0">' . $row_topic_reply['subject'] . '</a>'
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($max_num_replies < $row_topic_reply['num_replies'])
Chris@76: 			$max_num_replies = $row_topic_reply['num_replies'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($topic_reply_result);
Chris@76: 
Chris@76: 	foreach ($context['top_topics_replies'] as $i => $topic)
Chris@76: 	{
Chris@76: 		$context['top_topics_replies'][$i]['post_percent'] = round(($topic['num_replies'] * 100) / $max_num_replies);
Chris@76: 		$context['top_topics_replies'][$i]['num_replies'] = comma_format($context['top_topics_replies'][$i]['num_replies']);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Large forums may need a bit more prodding...
Chris@76: 	if ($modSettings['totalMessages'] > 100000)
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_topic
Chris@76: 			FROM {db_prefix}topics
Chris@76: 			WHERE num_views != {int:no_views}
Chris@76: 			ORDER BY num_views DESC
Chris@76: 			LIMIT 100',
Chris@76: 			array(
Chris@76: 				'no_views' => 0,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		$topic_ids = array();
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 			$topic_ids[] = $row['id_topic'];
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$topic_ids = array();
Chris@76: 
Chris@76: 	// Topic views top 10.
Chris@76: 	$topic_view_result = $smcFunc['db_query']('', '
Chris@76: 		SELECT m.subject, t.num_views, t.id_board, t.id_topic, b.name
Chris@76: 		FROM {db_prefix}topics AS t
Chris@76: 			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
Chris@76: 			AND b.id_board != {int:recycle_board}' : '') . ')
Chris@76: 		WHERE {query_see_board}' . (!empty($topic_ids) ? '
Chris@76: 			AND t.id_topic IN ({array_int:topic_list})' : ($modSettings['postmod_active'] ? '
Chris@76: 			AND t.approved = {int:is_approved}' : '')) . '
Chris@76: 		ORDER BY t.num_views DESC
Chris@76: 		LIMIT 10',
Chris@76: 		array(
Chris@76: 			'topic_list' => $topic_ids,
Chris@76: 			'recycle_board' => $modSettings['recycle_board'],
Chris@76: 			'is_approved' => 1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['top_topics_views'] = array();
Chris@76: 	$max_num_views = 1;
Chris@76: 	while ($row_topic_views = $smcFunc['db_fetch_assoc']($topic_view_result))
Chris@76: 	{
Chris@76: 		censorText($row_topic_views['subject']);
Chris@76: 
Chris@76: 		$context['top_topics_views'][] = array(
Chris@76: 			'id' => $row_topic_views['id_topic'],
Chris@76: 			'board' => array(
Chris@76: 				'id' => $row_topic_views['id_board'],
Chris@76: 				'name' => $row_topic_views['name'],
Chris@76: 				'href' => $scripturl . '?board=' . $row_topic_views['id_board'] . '.0',
Chris@76: 				'link' => '<a href="' . $scripturl . '?board=' . $row_topic_views['id_board'] . '.0">' . $row_topic_views['name'] . '</a>'
Chris@76: 			),
Chris@76: 			'subject' => $row_topic_views['subject'],
Chris@76: 			'num_views' => $row_topic_views['num_views'],
Chris@76: 			'href' => $scripturl . '?topic=' . $row_topic_views['id_topic'] . '.0',
Chris@76: 			'link' => '<a href="' . $scripturl . '?topic=' . $row_topic_views['id_topic'] . '.0">' . $row_topic_views['subject'] . '</a>'
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($max_num_views < $row_topic_views['num_views'])
Chris@76: 			$max_num_views = $row_topic_views['num_views'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($topic_view_result);
Chris@76: 
Chris@76: 	foreach ($context['top_topics_views'] as $i => $topic)
Chris@76: 	{
Chris@76: 		$context['top_topics_views'][$i]['post_percent'] = round(($topic['num_views'] * 100) / $max_num_views);
Chris@76: 		$context['top_topics_views'][$i]['num_views'] = comma_format($context['top_topics_views'][$i]['num_views']);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Try to cache this when possible, because it's a little unavoidably slow.
Chris@76: 	if (($members = cache_get_data('stats_top_starters', 360)) == null)
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_member_started, COUNT(*) AS hits
Chris@76: 			FROM {db_prefix}topics' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
Chris@76: 			WHERE id_board != {int:recycle_board}' : '') . '
Chris@76: 			GROUP BY id_member_started
Chris@76: 			ORDER BY hits DESC
Chris@76: 			LIMIT 20',
Chris@76: 			array(
Chris@76: 				'recycle_board' => $modSettings['recycle_board'],
Chris@76: 			)
Chris@76: 		);
Chris@76: 		$members = array();
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 			$members[$row['id_member_started']] = $row['hits'];
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 		cache_put_data('stats_top_starters', $members, 360);
Chris@76: 	}
Chris@76: 
Chris@76: 	if (empty($members))
Chris@76: 		$members = array(0 => 0);
Chris@76: 
Chris@76: 	// Topic poster top 10.
Chris@76: 	$members_result = $smcFunc['db_query']('top_topic_starters', '
Chris@76: 		SELECT id_member, real_name
Chris@76: 		FROM {db_prefix}members
Chris@76: 		WHERE id_member IN ({array_int:member_list})
Chris@76: 		ORDER BY FIND_IN_SET(id_member, {string:top_topic_posters})
Chris@76: 		LIMIT 10',
Chris@76: 		array(
Chris@76: 			'member_list' => array_keys($members),
Chris@76: 			'top_topic_posters' => implode(',', array_keys($members)),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['top_starters'] = array();
Chris@76: 	$max_num_topics = 1;
Chris@76: 	while ($row_members = $smcFunc['db_fetch_assoc']($members_result))
Chris@76: 	{
Chris@76: 		$context['top_starters'][] = array(
Chris@76: 			'name' => $row_members['real_name'],
Chris@76: 			'id' => $row_members['id_member'],
Chris@76: 			'num_topics' => $members[$row_members['id_member']],
Chris@76: 			'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
Chris@76: 			'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($max_num_topics < $members[$row_members['id_member']])
Chris@76: 			$max_num_topics = $members[$row_members['id_member']];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($members_result);
Chris@76: 
Chris@76: 	foreach ($context['top_starters'] as $i => $topic)
Chris@76: 	{
Chris@76: 		$context['top_starters'][$i]['post_percent'] = round(($topic['num_topics'] * 100) / $max_num_topics);
Chris@76: 		$context['top_starters'][$i]['num_topics'] = comma_format($context['top_starters'][$i]['num_topics']);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Time online top 10.
Chris@76: 	$temp = cache_get_data('stats_total_time_members', 600);
Chris@76: 	$members_result = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_member, real_name, total_time_logged_in
Chris@76: 		FROM {db_prefix}members' . (!empty($temp) ? '
Chris@76: 		WHERE id_member IN ({array_int:member_list_cached})' : '') . '
Chris@76: 		ORDER BY total_time_logged_in DESC
Chris@76: 		LIMIT 20',
Chris@76: 		array(
Chris@76: 			'member_list_cached' => $temp,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['top_time_online'] = array();
Chris@76: 	$temp2 = array();
Chris@76: 	$max_time_online = 1;
Chris@76: 	while ($row_members = $smcFunc['db_fetch_assoc']($members_result))
Chris@76: 	{
Chris@76: 		$temp2[] = (int) $row_members['id_member'];
Chris@76: 		if (count($context['top_time_online']) >= 10)
Chris@76: 			continue;
Chris@76: 
Chris@76: 		// Figure out the days, hours and minutes.
Chris@76: 		$timeDays = floor($row_members['total_time_logged_in'] / 86400);
Chris@76: 		$timeHours = floor(($row_members['total_time_logged_in'] % 86400) / 3600);
Chris@76: 
Chris@76: 		// Figure out which things to show... (days, hours, minutes, etc.)
Chris@76: 		$timelogged = '';
Chris@76: 		if ($timeDays > 0)
Chris@76: 			$timelogged .= $timeDays . $txt['totalTimeLogged5'];
Chris@76: 		if ($timeHours > 0)
Chris@76: 			$timelogged .= $timeHours . $txt['totalTimeLogged6'];
Chris@76: 		$timelogged .= floor(($row_members['total_time_logged_in'] % 3600) / 60) . $txt['totalTimeLogged7'];
Chris@76: 
Chris@76: 		$context['top_time_online'][] = array(
Chris@76: 			'id' => $row_members['id_member'],
Chris@76: 			'name' => $row_members['real_name'],
Chris@76: 			'time_online' => $timelogged,
Chris@76: 			'seconds_online' => $row_members['total_time_logged_in'],
Chris@76: 			'href' => $scripturl . '?action=profile;u=' . $row_members['id_member'],
Chris@76: 			'link' => '<a href="' . $scripturl . '?action=profile;u=' . $row_members['id_member'] . '">' . $row_members['real_name'] . '</a>'
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($max_time_online < $row_members['total_time_logged_in'])
Chris@76: 			$max_time_online = $row_members['total_time_logged_in'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($members_result);
Chris@76: 
Chris@76: 	foreach ($context['top_time_online'] as $i => $member)
Chris@76: 		$context['top_time_online'][$i]['time_percent'] = round(($member['seconds_online'] * 100) / $max_time_online);
Chris@76: 
Chris@76: 	// Cache the ones we found for a bit, just so we don't have to look again.
Chris@76: 	if ($temp !== $temp2)
Chris@76: 		cache_put_data('stats_total_time_members', $temp2, 480);
Chris@76: 
Chris@76: 	// Activity by month.
Chris@76: 	$months_result = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			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
Chris@76: 		FROM {db_prefix}log_activity
Chris@76: 		GROUP BY stats_year, stats_month',
Chris@76: 		array()
Chris@76: 	);
Chris@76: 
Chris@76: 	$context['yearly'] = array();
Chris@76: 	while ($row_months = $smcFunc['db_fetch_assoc']($months_result))
Chris@76: 	{
Chris@76: 		$ID_MONTH = $row_months['stats_year'] . sprintf('%02d', $row_months['stats_month']);
Chris@76: 		$expanded = !empty($_SESSION['expanded_stats'][$row_months['stats_year']]) && in_array($row_months['stats_month'], $_SESSION['expanded_stats'][$row_months['stats_year']]);
Chris@76: 
Chris@76: 		if (!isset($context['yearly'][$row_months['stats_year']]))
Chris@76: 			$context['yearly'][$row_months['stats_year']] = array(
Chris@76: 				'year' => $row_months['stats_year'],
Chris@76: 				'new_topics' => 0,
Chris@76: 				'new_posts' => 0,
Chris@76: 				'new_members' => 0,
Chris@76: 				'most_members_online' => 0,
Chris@76: 				'hits' => 0,
Chris@76: 				'num_months' => 0,
Chris@76: 				'months' => array(),
Chris@76: 				'expanded' => false,
Chris@76: 				'current_year' => $row_months['stats_year'] == date('Y'),
Chris@76: 			);
Chris@76: 
Chris@76: 		$context['yearly'][$row_months['stats_year']]['months'][(int) $row_months['stats_month']] = array(
Chris@76: 			'id' => $ID_MONTH,
Chris@76: 			'date' => array(
Chris@76: 				'month' => sprintf('%02d', $row_months['stats_month']),
Chris@76: 				'year' => $row_months['stats_year']
Chris@76: 			),
Chris@76: 			'href' => $scripturl . '?action=stats;' . ($expanded ? 'collapse' : 'expand') . '=' . $ID_MONTH . '#m' . $ID_MONTH,
Chris@76: 			'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>',
Chris@76: 			'month' => $txt['months'][(int) $row_months['stats_month']],
Chris@76: 			'year' => $row_months['stats_year'],
Chris@76: 			'new_topics' => comma_format($row_months['topics']),
Chris@76: 			'new_posts' => comma_format($row_months['posts']),
Chris@76: 			'new_members' => comma_format($row_months['registers']),
Chris@76: 			'most_members_online' => comma_format($row_months['most_on']),
Chris@76: 			'hits' => comma_format($row_months['hits']),
Chris@76: 			'num_days' => $row_months['num_days'],
Chris@76: 			'days' => array(),
Chris@76: 			'expanded' => $expanded
Chris@76: 		);
Chris@76: 
Chris@76: 		$context['yearly'][$row_months['stats_year']]['new_topics'] += $row_months['topics'];
Chris@76: 		$context['yearly'][$row_months['stats_year']]['new_posts'] += $row_months['posts'];
Chris@76: 		$context['yearly'][$row_months['stats_year']]['new_members'] += $row_months['registers'];
Chris@76: 		$context['yearly'][$row_months['stats_year']]['hits'] += $row_months['hits'];
Chris@76: 		$context['yearly'][$row_months['stats_year']]['num_months']++;
Chris@76: 		$context['yearly'][$row_months['stats_year']]['expanded'] |= $expanded;
Chris@76: 		$context['yearly'][$row_months['stats_year']]['most_members_online'] = max($context['yearly'][$row_months['stats_year']]['most_members_online'], $row_months['most_on']);
Chris@76: 	}
Chris@76: 
Chris@76: 	krsort($context['yearly']);
Chris@76: 
Chris@76: 	$context['collapsed_years'] = array();
Chris@76: 	foreach ($context['yearly'] as $year => $data)
Chris@76: 	{
Chris@76: 		// This gets rid of the filesort on the query ;).
Chris@76: 		krsort($context['yearly'][$year]['months']);
Chris@76: 
Chris@76: 		$context['yearly'][$year]['new_topics'] = comma_format($data['new_topics']);
Chris@76: 		$context['yearly'][$year]['new_posts'] = comma_format($data['new_posts']);
Chris@76: 		$context['yearly'][$year]['new_members'] = comma_format($data['new_members']);
Chris@76: 		$context['yearly'][$year]['most_members_online'] = comma_format($data['most_members_online']);
Chris@76: 		$context['yearly'][$year]['hits'] = comma_format($data['hits']);
Chris@76: 
Chris@76: 		// Keep a list of collapsed years.
Chris@76: 		if (!$data['expanded'] && !$data['current_year'])
Chris@76: 			$context['collapsed_years'][] = $year;
Chris@76: 	}
Chris@76: 
Chris@76: 	if (empty($_SESSION['expanded_stats']))
Chris@76: 		return;
Chris@76: 
Chris@76: 	$condition_text = array();
Chris@76: 	$condition_params = array();
Chris@76: 	foreach ($_SESSION['expanded_stats'] as $year => $months)
Chris@76: 		if (!empty($months))
Chris@76: 		{
Chris@76: 			$condition_text[] = 'YEAR(date) = {int:year_' . $year . '} AND MONTH(date) IN ({array_int:months_' . $year . '})';
Chris@76: 			$condition_params['year_' . $year] = $year;
Chris@76: 			$condition_params['months_' . $year] = $months;
Chris@76: 		}
Chris@76: 
Chris@76: 	// No daily stats to even look at?
Chris@76: 	if (empty($condition_text))
Chris@76: 		return;
Chris@76: 
Chris@76: 	getDailyStats(implode(' OR ', $condition_text), $condition_params);
Chris@76: }
Chris@76: 
Chris@76: function getDailyStats($condition_string, $condition_parameters = array())
Chris@76: {
Chris@76: 	global $context, $smcFunc;
Chris@76: 
Chris@76: 	// Activity by day.
Chris@76: 	$days_result = $smcFunc['db_query']('', '
Chris@76: 		SELECT YEAR(date) AS stats_year, MONTH(date) AS stats_month, DAYOFMONTH(date) AS stats_day, topics, posts, registers, most_on, hits
Chris@76: 		FROM {db_prefix}log_activity
Chris@76: 		WHERE ' . $condition_string . '
Chris@76: 		ORDER BY stats_day ASC',
Chris@76: 		$condition_parameters
Chris@76: 	);
Chris@76: 	while ($row_days = $smcFunc['db_fetch_assoc']($days_result))
Chris@76: 		$context['yearly'][$row_days['stats_year']]['months'][(int) $row_days['stats_month']]['days'][] = array(
Chris@76: 			'day' => sprintf('%02d', $row_days['stats_day']),
Chris@76: 			'month' => sprintf('%02d', $row_days['stats_month']),
Chris@76: 			'year' => $row_days['stats_year'],
Chris@76: 			'new_topics' => comma_format($row_days['topics']),
Chris@76: 			'new_posts' => comma_format($row_days['posts']),
Chris@76: 			'new_members' => comma_format($row_days['registers']),
Chris@76: 			'most_members_online' => comma_format($row_days['most_on']),
Chris@76: 			'hits' => comma_format($row_days['hits'])
Chris@76: 		);
Chris@76: 	$smcFunc['db_free_result']($days_result);
Chris@76: }
Chris@76: 
Chris@76: // This is the function which returns stats to simplemachines.org IF enabled!
Chris@76: // See http://www.simplemachines.org/about/stats.php for more info.
Chris@76: function SMStats()
Chris@76: {
Chris@76: 	global $modSettings, $user_info, $forum_version, $sourcedir;
Chris@76: 
Chris@76: 	// First, is it disabled?
Chris@76: 	if (empty($modSettings['allow_sm_stats']))
Chris@76: 		die();
Chris@76: 
Chris@76: 	// Are we saying who we are, and are we right? (OR an admin)
Chris@76: 	if (!$user_info['is_admin'] && (!isset($_GET['sid']) || $_GET['sid'] != $modSettings['allow_sm_stats']))
Chris@76: 		die();
Chris@76: 
Chris@76: 	// Verify the referer...
Chris@76: 	if (!$user_info['is_admin'] && (!isset($_SERVER['HTTP_REFERER']) || md5($_SERVER['HTTP_REFERER']) != '746cb59a1a0d5cf4bd240e5a67c73085'))
Chris@76: 		die();
Chris@76: 
Chris@76: 	// Get some server versions.
Chris@76: 	require_once($sourcedir . '/Subs-Admin.php');
Chris@76: 	$checkFor = array(
Chris@76: 		'php',
Chris@76: 		'db_server',
Chris@76: 	);
Chris@76: 	$serverVersions = getServerVersions($checkFor);
Chris@76: 
Chris@76: 	// Get the actual stats.
Chris@76: 	$stats_to_send = array(
Chris@76: 		'UID' => $modSettings['allow_sm_stats'],
Chris@76: 		'time_added' => time(),
Chris@76: 		'members' => $modSettings['totalMembers'],
Chris@76: 		'messages' => $modSettings['totalMessages'],
Chris@76: 		'topics' => $modSettings['totalTopics'],
Chris@76: 		'boards' => 0,
Chris@76: 		'php_version' => $serverVersions['php']['version'],
Chris@76: 		'database_type' => strtolower($serverVersions['db_server']['title']),
Chris@76: 		'database_version' => $serverVersions['db_server']['version'],
Chris@76: 		'smf_version' => $forum_version,
Chris@76: 		'smfd_version' => $modSettings['smfVersion'],
Chris@76: 	);
Chris@76: 
Chris@76: 	// Encode all the data, for security.
Chris@76: 	foreach ($stats_to_send as $k => $v)
Chris@76: 		$stats_to_send[$k] = urlencode($k) . '=' . urlencode($v);
Chris@76: 
Chris@76: 	// Turn this into the query string!
Chris@76: 	$stats_to_send = implode('&', $stats_to_send);
Chris@76: 
Chris@76: 	// If we're an admin, just plonk them out.
Chris@76: 	if ($user_info['is_admin'])
Chris@76: 		echo $stats_to_send;
Chris@76: 	else
Chris@76: 	{
Chris@76: 		// Connect to the collection script.
Chris@76: 		$fp = @fsockopen('www.simplemachines.org', 80, $errno, $errstr);
Chris@76: 		if ($fp)
Chris@76: 		{
Chris@76: 			$length = strlen($stats_to_send);
Chris@76: 
Chris@76: 			$out = 'POST /smf/stats/collect_stats.php HTTP/1.1' . "\r\n";
Chris@76: 			$out .= 'Host: www.simplemachines.org' . "\r\n";
Chris@76: 			$out .= 'Content-Type: application/x-www-form-urlencoded' . "\r\n";
Chris@76: 			$out .= 'Content-Length: ' . $length . "\r\n\r\n";
Chris@76: 			$out .= $stats_to_send . "\r\n";
Chris@76: 			$out .= 'Connection: Close' . "\r\n\r\n";
Chris@76: 			fwrite($fp, $out);
Chris@76: 			fclose($fp);
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Die.
Chris@76: 	die('OK');
Chris@76: }
Chris@76: 
Chris@76: ?>