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: /*
Chris@76: 
Chris@76: 	void summary(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void showPosts(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void showAttachments(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void statPanel(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void tracking(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void trackUser(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	int list_getUserErrorCount(string where)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	array list_getUserErrors(int start, int items_per_page, string sort, string where, array where_vars)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	int list_getIPMessageCount(string where)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	array list_getIPMessages(int start, int items_per_page, string sort, string where, array where_vars)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void TrackIP(int id_member = none)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void trackEdits(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	int list_getProfileEditCount(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	array list_getProfileEdits(int start, int items_per_page, string sort, int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void showPermissions(int id_member)
Chris@76: 		// !!!
Chris@76: 
Chris@76: 	void viewWarning(int id_member)
Chris@76: 		// !!!
Chris@76: */
Chris@76: 
Chris@76: // View a summary.
Chris@76: function summary($memID)
Chris@76: {
Chris@76: 	global $context, $memberContext, $txt, $modSettings, $user_info, $user_profile, $sourcedir, $scripturl, $smcFunc;
Chris@76: 
Chris@76: 	// Attempt to load the member's profile data.
Chris@76: 	if (!loadMemberContext($memID) || !isset($memberContext[$memID]))
Chris@76: 		fatal_lang_error('not_a_user', false);
Chris@76: 
Chris@76: 	// Set up the stuff and load the user.
Chris@76: 	$context += array(
Chris@76: 		'page_title' => sprintf($txt['profile_of_username'], $memberContext[$memID]['name']),
Chris@76: 		'can_send_pm' => allowedTo('pm_send'),
Chris@76: 		'can_have_buddy' => allowedTo('profile_identity_own') && !empty($modSettings['enable_buddylist']),
Chris@76: 		'can_issue_warning' => in_array('w', $context['admin_features']) && allowedTo('issue_warning') && $modSettings['warning_settings'][0] == 1,
Chris@76: 	);
Chris@76: 	$context['member'] = &$memberContext[$memID];
Chris@76: 	$context['can_view_warning'] = in_array('w', $context['admin_features']) && (allowedTo('issue_warning') && !$context['user']['is_owner']) || (!empty($modSettings['warning_show']) && ($modSettings['warning_show'] > 1 || $context['user']['is_owner']));
Chris@76: 
Chris@76: 	// Set a canonical URL for this page.
Chris@76: 	$context['canonical_url'] = $scripturl . '?action=profile;u=' . $memID;
Chris@76: 
Chris@76: 	// Are there things we don't show?
Chris@76: 	$context['disabled_fields'] = isset($modSettings['disabled_profile_fields']) ? array_flip(explode(',', $modSettings['disabled_profile_fields'])) : array();
Chris@76: 
Chris@76: 	// See if they have broken any warning levels...
Chris@76: 	list ($modSettings['warning_enable'], $modSettings['user_limit']) = explode(',', $modSettings['warning_settings']);
Chris@76: 	if (!empty($modSettings['warning_mute']) && $modSettings['warning_mute'] <= $context['member']['warning'])
Chris@76: 		$context['warning_status'] = $txt['profile_warning_is_muted'];
Chris@76: 	elseif (!empty($modSettings['warning_moderate']) && $modSettings['warning_moderate'] <= $context['member']['warning'])
Chris@76: 		$context['warning_status'] = $txt['profile_warning_is_moderation'];
Chris@76: 	elseif (!empty($modSettings['warning_watch']) && $modSettings['warning_watch'] <= $context['member']['warning'])
Chris@76: 		$context['warning_status'] = $txt['profile_warning_is_watch'];
Chris@76: 
Chris@76: 	// They haven't even been registered for a full day!?
Chris@76: 	$days_registered = (int) ((time() - $user_profile[$memID]['date_registered']) / (3600 * 24));
Chris@76: 	if (empty($user_profile[$memID]['date_registered']) || $days_registered < 1)
Chris@76: 		$context['member']['posts_per_day'] = $txt['not_applicable'];
Chris@76: 	else
Chris@76: 		$context['member']['posts_per_day'] = comma_format($context['member']['real_posts'] / $days_registered, 3);
Chris@76: 
Chris@76: 	// Set the age...
Chris@76: 	if (empty($context['member']['birth_date']))
Chris@76: 	{
Chris@76: 		$context['member'] += array(
Chris@76: 			'age' => $txt['not_applicable'],
Chris@76: 			'today_is_birthday' => false
Chris@76: 		);
Chris@76: 	}
Chris@76: 	else
Chris@76: 	{
Chris@76: 		list ($birth_year, $birth_month, $birth_day) = sscanf($context['member']['birth_date'], '%d-%d-%d');
Chris@76: 		$datearray = getdate(forum_time());
Chris@76: 		$context['member'] += array(
Chris@76: 			'age' => $birth_year <= 4 ? $txt['not_applicable'] : $datearray['year'] - $birth_year - (($datearray['mon'] > $birth_month || ($datearray['mon'] == $birth_month && $datearray['mday'] >= $birth_day)) ? 0 : 1),
Chris@76: 			'today_is_birthday' => $datearray['mon'] == $birth_month && $datearray['mday'] == $birth_day
Chris@76: 		);
Chris@76: 	}
Chris@76: 
Chris@76: 	if (allowedTo('moderate_forum'))
Chris@76: 	{
Chris@76: 		// Make sure it's a valid ip address; otherwise, don't bother...
Chris@76: 		if (preg_match('/^\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}$/', $memberContext[$memID]['ip']) == 1 && empty($modSettings['disableHostnameLookup']))
Chris@76: 			$context['member']['hostname'] = host_from_ip($memberContext[$memID]['ip']);
Chris@76: 		else
Chris@76: 			$context['member']['hostname'] = '';
Chris@76: 
Chris@76: 		$context['can_see_ip'] = true;
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$context['can_see_ip'] = false;
Chris@76: 
Chris@76: 	if (!empty($modSettings['who_enabled']))
Chris@76: 	{
Chris@76: 		include_once($sourcedir . '/Who.php');
Chris@76: 		$action = determineActions($user_profile[$memID]['url']);
Chris@76: 
Chris@76: 		if ($action !== false)
Chris@76: 			$context['member']['action'] = $action;
Chris@76: 	}
Chris@76: 
Chris@76: 	// If the user is awaiting activation, and the viewer has permission - setup some activation context messages.
Chris@76: 	if ($context['member']['is_activated'] % 10 != 1 && allowedTo('moderate_forum'))
Chris@76: 	{
Chris@76: 		$context['activate_type'] = $context['member']['is_activated'];
Chris@76: 		// What should the link text be?
Chris@76: 		$context['activate_link_text'] = in_array($context['member']['is_activated'], array(3, 4, 5, 13, 14, 15)) ? $txt['account_approve'] : $txt['account_activate'];
Chris@76: 
Chris@76: 		// Should we show a custom message?
Chris@76: 		$context['activate_message'] = isset($txt['account_activate_method_' . $context['member']['is_activated'] % 10]) ? $txt['account_activate_method_' . $context['member']['is_activated'] % 10] : $txt['account_not_activated'];
Chris@76: 	}
Chris@76: 
Chris@76: 	// Is the signature even enabled on this forum?
Chris@76: 	$context['signature_enabled'] = substr($modSettings['signature_settings'], 0, 1) == 1;
Chris@76: 
Chris@76: 	// How about, are they banned?
Chris@76: 	$context['member']['bans'] = array();
Chris@76: 	if (allowedTo('moderate_forum'))
Chris@76: 	{
Chris@76: 		// Can they edit the ban?
Chris@76: 		$context['can_edit_ban'] = allowedTo('manage_bans');
Chris@76: 
Chris@76: 		$ban_query = array();
Chris@76: 		$ban_query_vars = array(
Chris@76: 			'time' => time(),
Chris@76: 		);
Chris@76: 		$ban_query[] = 'id_member = ' . $context['member']['id'];
Chris@76: 
Chris@76: 		// Valid IP?
Chris@76: 		if (preg_match('/^(\d{1,3})\.(\d{1,3})\.(\d{1,3})\.(\d{1,3})$/', $memberContext[$memID]['ip'], $ip_parts) == 1)
Chris@76: 		{
Chris@76: 			$ban_query[] = '((' . $ip_parts[1] . ' BETWEEN bi.ip_low1 AND bi.ip_high1)
Chris@76: 						AND (' . $ip_parts[2] . ' BETWEEN bi.ip_low2 AND bi.ip_high2)
Chris@76: 						AND (' . $ip_parts[3] . ' BETWEEN bi.ip_low3 AND bi.ip_high3)
Chris@76: 						AND (' . $ip_parts[4] . ' BETWEEN bi.ip_low4 AND bi.ip_high4))';
Chris@76: 
Chris@76: 			// Do we have a hostname already?
Chris@76: 			if (!empty($context['member']['hostname']))
Chris@76: 			{
Chris@76: 				$ban_query[] = '({string:hostname} LIKE hostname)';
Chris@76: 				$ban_query_vars['hostname'] = $context['member']['hostname'];
Chris@76: 			}
Chris@76: 		}
Chris@76: 		// Use '255.255.255.255' for 'unknown' - it's not valid anyway.
Chris@76: 		elseif ($memberContext[$memID]['ip'] == 'unknown')
Chris@76: 			$ban_query[] = '(bi.ip_low1 = 255 AND bi.ip_high1 = 255
Chris@76: 						AND bi.ip_low2 = 255 AND bi.ip_high2 = 255
Chris@76: 						AND bi.ip_low3 = 255 AND bi.ip_high3 = 255
Chris@76: 						AND bi.ip_low4 = 255 AND bi.ip_high4 = 255)';
Chris@76: 
Chris@76: 		// Check their email as well...
Chris@76: 		if (strlen($context['member']['email']) != 0)
Chris@76: 		{
Chris@76: 			$ban_query[] = '({string:email} LIKE bi.email_address)';
Chris@76: 			$ban_query_vars['email'] = $context['member']['email'];
Chris@76: 		}
Chris@76: 
Chris@76: 		// So... are they banned?  Dying to know!
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT bg.id_ban_group, bg.name, bg.cannot_access, bg.cannot_post, bg.cannot_register,
Chris@76: 				bg.cannot_login, bg.reason
Chris@76: 			FROM {db_prefix}ban_items AS bi
Chris@76: 				INNER JOIN {db_prefix}ban_groups AS bg ON (bg.id_ban_group = bi.id_ban_group AND (bg.expire_time IS NULL OR bg.expire_time > {int:time}))
Chris@76: 			WHERE (' . implode(' OR ', $ban_query) . ')',
Chris@76: 			$ban_query_vars
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		{
Chris@76: 			// Work out what restrictions we actually have.
Chris@76: 			$ban_restrictions = array();
Chris@76: 			foreach (array('access', 'register', 'login', 'post') as $type)
Chris@76: 				if ($row['cannot_' . $type])
Chris@76: 					$ban_restrictions[] = $txt['ban_type_' . $type];
Chris@76: 
Chris@76: 			// No actual ban in place?
Chris@76: 			if (empty($ban_restrictions))
Chris@76: 				continue;
Chris@76: 
Chris@76: 			// Prepare the link for context.
Chris@76: 			$ban_explanation = sprintf($txt['user_cannot_due_to'], implode(', ', $ban_restrictions), '<a href="' . $scripturl . '?action=admin;area=ban;sa=edit;bg=' . $row['id_ban_group'] . '">' . $row['name'] . '</a>');
Chris@76: 
Chris@76: 			$context['member']['bans'][$row['id_ban_group']] = array(
Chris@76: 				'reason' => empty($row['reason']) ? '' : '<br /><br /><strong>' . $txt['ban_reason'] . ':</strong> ' . $row['reason'],
Chris@76: 				'cannot' => array(
Chris@76: 					'access' => !empty($row['cannot_access']),
Chris@76: 					'register' => !empty($row['cannot_register']),
Chris@76: 					'post' => !empty($row['cannot_post']),
Chris@76: 					'login' => !empty($row['cannot_login']),
Chris@76: 				),
Chris@76: 				'explanation' => $ban_explanation,
Chris@76: 			);
Chris@76: 		}
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 	}
Chris@76: 
Chris@76: 	loadCustomFields($memID);
Chris@76: }
Chris@76: 
Chris@76: // !!! This function needs to be split up properly.
Chris@76: // Show all posts by the current user
Chris@76: function showPosts($memID)
Chris@76: {
Chris@76: 	global $txt, $user_info, $scripturl, $modSettings;
Chris@76: 	global $context, $user_profile, $sourcedir, $smcFunc, $board;
Chris@76: 
Chris@76: 	// Some initial context.
Chris@76: 	$context['start'] = (int) $_REQUEST['start'];
Chris@76: 	$context['current_member'] = $memID;
Chris@76: 
Chris@76: 	// Create the tabs for the template.
Chris@76: 	$context[$context['profile_menu_name']]['tab_data'] = array(
Chris@76: 		'title' => $txt['showPosts'],
Chris@76: 		'description' => $txt['showPosts_help'],
Chris@76: 		'icon' => 'profile_sm.gif',
Chris@76: 		'tabs' => array(
Chris@76: 			'messages' => array(
Chris@76: 			),
Chris@76: 			'topics' => array(
Chris@76: 			),
Chris@76: 			'attach' => array(
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Set the page title
Chris@76: 	$context['page_title'] = $txt['showPosts'] . ' - ' . $user_profile[$memID]['real_name'];
Chris@76: 
Chris@76: 	// Is the load average too high to allow searching just now?
Chris@76: 	if (!empty($context['load_average']) && !empty($modSettings['loadavg_show_posts']) && $context['load_average'] >= $modSettings['loadavg_show_posts'])
Chris@76: 		fatal_lang_error('loadavg_show_posts_disabled', false);
Chris@76: 
Chris@76: 	// If we're specifically dealing with attachments use that function!
Chris@76: 	if (isset($_GET['sa']) && $_GET['sa'] == 'attach')
Chris@76: 		return showAttachments($memID);
Chris@76: 
Chris@76: 	// Are we just viewing topics?
Chris@76: 	$context['is_topics'] = isset($_GET['sa']) && $_GET['sa'] == 'topics' ? true : false;
Chris@76: 
Chris@76: 	// If just deleting a message, do it and then redirect back.
Chris@76: 	if (isset($_GET['delete']) && !$context['is_topics'])
Chris@76: 	{
Chris@76: 		checkSession('get');
Chris@76: 
Chris@76: 		// We need msg info for logging.
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT subject, id_member, id_topic, id_board
Chris@76: 			FROM {db_prefix}messages
Chris@76: 			WHERE id_msg = {int:id_msg}',
Chris@76: 			array(
Chris@76: 				'id_msg' => (int) $_GET['delete'],
Chris@76: 			)
Chris@76: 		);
Chris@76: 		$info = $smcFunc['db_fetch_row']($request);
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 		// Trying to remove a message that doesn't exist.
Chris@76: 		if (empty($info))
Chris@76: 			redirectexit('action=profile;u=' . $memID . ';area=showposts;start=' . $_GET['start']);
Chris@76: 
Chris@76: 		// We can be lazy, since removeMessage() will check the permissions for us.
Chris@76: 		require_once($sourcedir . '/RemoveTopic.php');
Chris@76: 		removeMessage((int) $_GET['delete']);
Chris@76: 
Chris@76: 		// Add it to the mod log.
Chris@76: 		if (allowedTo('delete_any') && (!allowedTo('delete_own') || $info[1] != $user_info['id']))
Chris@76: 			logAction('delete', array('topic' => $info[2], 'subject' => $info[0], 'member' => $info[1], 'board' => $info[3]));
Chris@76: 
Chris@76: 		// Back to... where we are now ;).
Chris@76: 		redirectexit('action=profile;u=' . $memID . ';area=showposts;start=' . $_GET['start']);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Default to 10.
Chris@76: 	if (empty($_REQUEST['viewscount']) || !is_numeric($_REQUEST['viewscount']))
Chris@76: 		$_REQUEST['viewscount'] = '10';
Chris@76: 
Chris@76: 	if ($context['is_topics'])
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT COUNT(*)
Chris@76: 			FROM {db_prefix}topics AS t' . ($user_info['query_see_board'] == '1=1' ? '' : '
Chris@76: 				INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board AND {query_see_board})') . '
Chris@76: 			WHERE t.id_member_started = {int:current_member}' . (!empty($board) ? '
Chris@76: 				AND t.id_board = {int:board}' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
Chris@76: 				AND t.approved = {int:is_approved}'),
Chris@76: 			array(
Chris@76: 				'current_member' => $memID,
Chris@76: 				'is_approved' => 1,
Chris@76: 				'board' => $board,
Chris@76: 			)
Chris@76: 		);
Chris@76: 	else
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT COUNT(*)
Chris@76: 			FROM {db_prefix}messages AS m' . ($user_info['query_see_board'] == '1=1' ? '' : '
Chris@76: 				INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})') . '
Chris@76: 			WHERE m.id_member = {int:current_member}' . (!empty($board) ? '
Chris@76: 				AND m.id_board = {int:board}' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
Chris@76: 				AND m.approved = {int:is_approved}'),
Chris@76: 			array(
Chris@76: 				'current_member' => $memID,
Chris@76: 				'is_approved' => 1,
Chris@76: 				'board' => $board,
Chris@76: 			)
Chris@76: 		);
Chris@76: 	list ($msgCount) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT MIN(id_msg), MAX(id_msg)
Chris@76: 		FROM {db_prefix}messages AS m
Chris@76: 		WHERE m.id_member = {int:current_member}' . (!empty($board) ? '
Chris@76: 			AND m.id_board = {int:board}' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
Chris@76: 			AND m.approved = {int:is_approved}'),
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 			'is_approved' => 1,
Chris@76: 			'board' => $board,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($min_msg_member, $max_msg_member) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	$reverse = false;
Chris@76: 	$range_limit = '';
Chris@76: 	$maxIndex = (int) $modSettings['defaultMaxMessages'];
Chris@76: 
Chris@76: 	// Make sure the starting place makes sense and construct our friend the page index.
Chris@76: 	$context['page_index'] = constructPageIndex($scripturl . '?action=profile;u=' . $memID . ';area=showposts' . ($context['is_topics'] ? ';sa=topics' : '') . (!empty($board) ? ';board=' . $board : ''), $context['start'], $msgCount, $maxIndex);
Chris@76: 	$context['current_page'] = $context['start'] / $maxIndex;
Chris@76: 
Chris@76: 	// Reverse the query if we're past 50% of the pages for better performance.
Chris@76: 	$start = $context['start'];
Chris@76: 	$reverse = $_REQUEST['start'] > $msgCount / 2;
Chris@76: 	if ($reverse)
Chris@76: 	{
Chris@76: 		$maxIndex = $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] + 1 && $msgCount > $context['start'] ? $msgCount - $context['start'] : (int) $modSettings['defaultMaxMessages'];
Chris@76: 		$start = $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] + 1 || $msgCount < $context['start'] + $modSettings['defaultMaxMessages'] ? 0 : $msgCount - $context['start'] - $modSettings['defaultMaxMessages'];
Chris@76: 	}
Chris@76: 
Chris@76: 	// Guess the range of messages to be shown.
Chris@76: 	if ($msgCount > 1000)
Chris@76: 	{
Chris@76: 		$margin = floor(($max_msg_member - $min_msg_member) * (($start + $modSettings['defaultMaxMessages']) / $msgCount) + .1 * ($max_msg_member - $min_msg_member));
Chris@76: 		// Make a bigger margin for topics only.
Chris@76: 		if ($context['is_topics'])
Chris@76: 		{
Chris@76: 			$margin *= 5;
Chris@76: 			$range_limit = $reverse ? 't.id_first_msg < ' . ($min_msg_member + $margin) : 't.id_first_msg > ' . ($max_msg_member - $margin);
Chris@76: 		}
Chris@76: 		else
Chris@76: 			$range_limit = $reverse ? 'm.id_msg < ' . ($min_msg_member + $margin) : 'm.id_msg > ' . ($max_msg_member - $margin);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Find this user's posts.  The left join on categories somehow makes this faster, weird as it looks.
Chris@76: 	$looped = false;
Chris@76: 	while (true)
Chris@76: 	{
Chris@76: 		if ($context['is_topics'])
Chris@76: 		{
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT
Chris@76: 					b.id_board, b.name AS bname, c.id_cat, c.name AS cname, t.id_member_started, t.id_first_msg, t.id_last_msg,
Chris@76: 					t.approved, m.body, m.smileys_enabled, m.subject, m.poster_time, m.id_topic, m.id_msg
Chris@76: 				FROM {db_prefix}topics AS t
Chris@76: 					INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
Chris@76: 					LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
Chris@76: 					INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
Chris@76: 				WHERE t.id_member_started = {int:current_member}' . (!empty($board) ? '
Chris@76: 					AND t.id_board = {int:board}' : '') . (empty($range_limit) ? '' : '
Chris@76: 					AND ' . $range_limit) . '
Chris@76: 					AND {query_see_board}' . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
Chris@76: 					AND t.approved = {int:is_approved} AND m.approved = {int:is_approved}') . '
Chris@76: 				ORDER BY t.id_first_msg ' . ($reverse ? 'ASC' : 'DESC') . '
Chris@76: 				LIMIT ' . $start . ', ' . $maxIndex,
Chris@76: 				array(
Chris@76: 					'current_member' => $memID,
Chris@76: 					'is_approved' => 1,
Chris@76: 					'board' => $board,
Chris@76: 				)
Chris@76: 			);
Chris@76: 		}
Chris@76: 		else
Chris@76: 		{
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT
Chris@76: 					b.id_board, b.name AS bname, c.id_cat, c.name AS cname, m.id_topic, m.id_msg,
Chris@76: 					t.id_member_started, t.id_first_msg, t.id_last_msg, m.body, m.smileys_enabled,
Chris@76: 					m.subject, m.poster_time, m.approved
Chris@76: 				FROM {db_prefix}messages AS m
Chris@76: 					INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic)
Chris@76: 					INNER JOIN {db_prefix}boards AS b ON (b.id_board = t.id_board)
Chris@76: 					LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
Chris@76: 				WHERE m.id_member = {int:current_member}' . (!empty($board) ? '
Chris@76: 					AND b.id_board = {int:board}' : '') . (empty($range_limit) ? '' : '
Chris@76: 					AND ' . $range_limit) . '
Chris@76: 					AND {query_see_board}' . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
Chris@76: 					AND t.approved = {int:is_approved} AND m.approved = {int:is_approved}') . '
Chris@76: 				ORDER BY m.id_msg ' . ($reverse ? 'ASC' : 'DESC') . '
Chris@76: 				LIMIT ' . $start . ', ' . $maxIndex,
Chris@76: 				array(
Chris@76: 					'current_member' => $memID,
Chris@76: 					'is_approved' => 1,
Chris@76: 					'board' => $board,
Chris@76: 				)
Chris@76: 			);
Chris@76: 		}
Chris@76: 
Chris@76: 		// Make sure we quit this loop.
Chris@76: 		if ($smcFunc['db_num_rows']($request) === $maxIndex || $looped)
Chris@76: 			break;
Chris@76: 		$looped = true;
Chris@76: 		$range_limit = '';
Chris@76: 	}
Chris@76: 
Chris@76: 	// Start counting at the number of the first message displayed.
Chris@76: 	$counter = $reverse ? $context['start'] + $maxIndex + 1 : $context['start'];
Chris@76: 	$context['posts'] = array();
Chris@76: 	$board_ids = array('own' => array(), 'any' => array());
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// Censor....
Chris@76: 		censorText($row['body']);
Chris@76: 		censorText($row['subject']);
Chris@76: 
Chris@76: 		// Do the code.
Chris@76: 		$row['body'] = parse_bbc($row['body'], $row['smileys_enabled'], $row['id_msg']);
Chris@76: 
Chris@76: 		// And the array...
Chris@76: 		$context['posts'][$counter += $reverse ? -1 : 1] = array(
Chris@76: 			'body' => $row['body'],
Chris@76: 			'counter' => $counter,
Chris@76: 			'alternate' => $counter % 2,
Chris@76: 			'category' => array(
Chris@76: 				'name' => $row['cname'],
Chris@76: 				'id' => $row['id_cat']
Chris@76: 			),
Chris@76: 			'board' => array(
Chris@76: 				'name' => $row['bname'],
Chris@76: 				'id' => $row['id_board']
Chris@76: 			),
Chris@76: 			'topic' => $row['id_topic'],
Chris@76: 			'subject' => $row['subject'],
Chris@76: 			'start' => 'msg' . $row['id_msg'],
Chris@76: 			'time' => timeformat($row['poster_time']),
Chris@76: 			'timestamp' => forum_time(true, $row['poster_time']),
Chris@76: 			'id' => $row['id_msg'],
Chris@76: 			'can_reply' => false,
Chris@76: 			'can_mark_notify' => false,
Chris@76: 			'can_delete' => false,
Chris@76: 			'delete_possible' => ($row['id_first_msg'] != $row['id_msg'] || $row['id_last_msg'] == $row['id_msg']) && (empty($modSettings['edit_disable_time']) || $row['poster_time'] + $modSettings['edit_disable_time'] * 60 >= time()),
Chris@76: 			'approved' => $row['approved'],
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($user_info['id'] == $row['id_member_started'])
Chris@76: 			$board_ids['own'][$row['id_board']][] = $counter;
Chris@76: 		$board_ids['any'][$row['id_board']][] = $counter;
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// All posts were retrieved in reverse order, get them right again.
Chris@76: 	if ($reverse)
Chris@76: 		$context['posts'] = array_reverse($context['posts'], true);
Chris@76: 
Chris@76: 	// These are all the permissions that are different from board to board..
Chris@76: 	if ($context['is_topics'])
Chris@76: 		$permissions = array(
Chris@76: 			'own' => array(
Chris@76: 				'post_reply_own' => 'can_reply',
Chris@76: 			),
Chris@76: 			'any' => array(
Chris@76: 				'post_reply_any' => 'can_reply',
Chris@76: 				'mark_any_notify' => 'can_mark_notify',
Chris@76: 			)
Chris@76: 		);
Chris@76: 	else
Chris@76: 		$permissions = array(
Chris@76: 			'own' => array(
Chris@76: 				'post_reply_own' => 'can_reply',
Chris@76: 				'delete_own' => 'can_delete',
Chris@76: 			),
Chris@76: 			'any' => array(
Chris@76: 				'post_reply_any' => 'can_reply',
Chris@76: 				'mark_any_notify' => 'can_mark_notify',
Chris@76: 				'delete_any' => 'can_delete',
Chris@76: 			)
Chris@76: 		);
Chris@76: 
Chris@76: 	// For every permission in the own/any lists...
Chris@76: 	foreach ($permissions as $type => $list)
Chris@76: 	{
Chris@76: 		foreach ($list as $permission => $allowed)
Chris@76: 		{
Chris@76: 			// Get the boards they can do this on...
Chris@76: 			$boards = boardsAllowedTo($permission);
Chris@76: 
Chris@76: 			// Hmm, they can do it on all boards, can they?
Chris@76: 			if (!empty($boards) && $boards[0] == 0)
Chris@76: 				$boards = array_keys($board_ids[$type]);
Chris@76: 
Chris@76: 			// Now go through each board they can do the permission on.
Chris@76: 			foreach ($boards as $board_id)
Chris@76: 			{
Chris@76: 				// There aren't any posts displayed from this board.
Chris@76: 				if (!isset($board_ids[$type][$board_id]))
Chris@76: 					continue;
Chris@76: 
Chris@76: 				// Set the permission to true ;).
Chris@76: 				foreach ($board_ids[$type][$board_id] as $counter)
Chris@76: 					$context['posts'][$counter][$allowed] = true;
Chris@76: 			}
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Clean up after posts that cannot be deleted and quoted.
Chris@76: 	$quote_enabled = empty($modSettings['disabledBBC']) || !in_array('quote', explode(',', $modSettings['disabledBBC']));
Chris@76: 	foreach ($context['posts'] as $counter => $dummy)
Chris@76: 	{
Chris@76: 		$context['posts'][$counter]['can_delete'] &= $context['posts'][$counter]['delete_possible'];
Chris@76: 		$context['posts'][$counter]['can_quote'] = $context['posts'][$counter]['can_reply'] && $quote_enabled;
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: // Show all the attachments of a user.
Chris@76: function showAttachments($memID)
Chris@76: {
Chris@76: 	global $txt, $user_info, $scripturl, $modSettings, $board;
Chris@76: 	global $context, $user_profile, $sourcedir, $smcFunc;
Chris@76: 
Chris@76: 	// OBEY permissions!
Chris@76: 	$boardsAllowed = boardsAllowedTo('view_attachments');
Chris@76: 	// Make sure we can't actually see anything...
Chris@76: 	if (empty($boardsAllowed))
Chris@76: 		$boardsAllowed = array(-1);
Chris@76: 
Chris@76: 	// Get the total number of attachments they have posted.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}attachments AS a
Chris@76: 			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})
Chris@76: 		WHERE a.attachment_type = {int:attachment_type}
Chris@76: 			AND a.id_msg != {int:no_message}
Chris@76: 			AND m.id_member = {int:current_member}' . (!empty($board) ? '
Chris@76: 			AND b.id_board = {int:board}' : '') . (!in_array(0, $boardsAllowed) ? '
Chris@76: 			AND b.id_board IN ({array_int:boards_list})' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
Chris@76: 			AND m.approved = {int:is_approved}'),
Chris@76: 		array(
Chris@76: 			'boards_list' => $boardsAllowed,
Chris@76: 			'attachment_type' => 0,
Chris@76: 			'no_message' => 0,
Chris@76: 			'current_member' => $memID,
Chris@76: 			'is_approved' => 1,
Chris@76: 			'board' => $board,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($attachCount) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	$maxIndex = (int) $modSettings['defaultMaxMessages'];
Chris@76: 
Chris@76: 	// What about ordering?
Chris@76: 	$sortTypes = array(
Chris@76: 		'filename' => 'a.filename',
Chris@76: 		'downloads' => 'a.downloads',
Chris@76: 		'subject' => 'm.subject',
Chris@76: 		'posted' => 'm.poster_time',
Chris@76: 	);
Chris@76: 	$context['sort_order'] = isset($_GET['sort']) && isset($sortTypes[$_GET['sort']]) ? $_GET['sort'] : 'posted';
Chris@76: 	$context['sort_direction'] = isset($_GET['asc']) ? 'up' : 'down';
Chris@76: 
Chris@76: 	$sort = $sortTypes[$context['sort_order']];
Chris@76: 
Chris@76: 	// Let's get ourselves a lovely page index.
Chris@76: 	$context['page_index'] = constructPageIndex($scripturl . '?action=profile;u=' . $memID . ';area=showposts;sa=attach;sort=' . $context['sort_order'] . ($context['sort_direction'] == 'up' ? ';asc' : ''), $context['start'], $attachCount, $maxIndex);
Chris@76: 
Chris@76: 	// Retrieve some attachments.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT a.id_attach, a.id_msg, a.filename, a.downloads, a.approved, m.id_msg, m.id_topic,
Chris@76: 			m.id_board, m.poster_time, m.subject, b.name
Chris@76: 		FROM {db_prefix}attachments AS a
Chris@76: 			INNER JOIN {db_prefix}messages AS m ON (m.id_msg = a.id_msg)
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board AND {query_see_board})
Chris@76: 		WHERE a.attachment_type = {int:attachment_type}
Chris@76: 			AND a.id_msg != {int:no_message}
Chris@76: 			AND m.id_member = {int:current_member}' . (!empty($board) ? '
Chris@76: 			AND b.id_board = {int:board}' : '') . (!in_array(0, $boardsAllowed) ? '
Chris@76: 			AND b.id_board IN ({array_int:boards_list})' : '') . (!$modSettings['postmod_active'] || $context['user']['is_owner'] ? '' : '
Chris@76: 			AND m.approved = {int:is_approved}') . '
Chris@76: 		ORDER BY {raw:sort}
Chris@76: 		LIMIT {int:offset}, {int:limit}',
Chris@76: 		array(
Chris@76: 			'boards_list' => $boardsAllowed,
Chris@76: 			'attachment_type' => 0,
Chris@76: 			'no_message' => 0,
Chris@76: 			'current_member' => $memID,
Chris@76: 			'is_approved' => 1,
Chris@76: 			'board' => $board,
Chris@76: 			'sort' => $sort . ' ' . ($context['sort_direction'] == 'down' ? 'DESC' : 'ASC'),
Chris@76: 			'offset' => $context['start'],
Chris@76: 			'limit' => $maxIndex,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['attachments'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$row['subject'] = censorText($row['subject']);
Chris@76: 
Chris@76: 		$context['attachments'][] = array(
Chris@76: 			'id' => $row['id_attach'],
Chris@76: 			'filename' => $row['filename'],
Chris@76: 			'downloads' => $row['downloads'],
Chris@76: 			'subject' => $row['subject'],
Chris@76: 			'posted' => timeformat($row['poster_time']),
Chris@76: 			'msg' => $row['id_msg'],
Chris@76: 			'topic' => $row['id_topic'],
Chris@76: 			'board' => $row['id_board'],
Chris@76: 			'board_name' => $row['name'],
Chris@76: 			'approved' => $row['approved'],
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: }
Chris@76: 
Chris@76: function statPanel($memID)
Chris@76: {
Chris@76: 	global $txt, $scripturl, $context, $user_profile, $user_info, $modSettings, $smcFunc;
Chris@76: 
Chris@76: 	$context['page_title'] = $txt['statPanel_showStats'] . ' ' . $user_profile[$memID]['real_name'];
Chris@76: 
Chris@76: 	// General user statistics.
Chris@76: 	$timeDays = floor($user_profile[$memID]['total_time_logged_in'] / 86400);
Chris@76: 	$timeHours = floor(($user_profile[$memID]['total_time_logged_in'] % 86400) / 3600);
Chris@76: 	$context['time_logged_in'] = ($timeDays > 0 ? $timeDays . $txt['totalTimeLogged2'] : '') . ($timeHours > 0 ? $timeHours . $txt['totalTimeLogged3'] : '') . floor(($user_profile[$memID]['total_time_logged_in'] % 3600) / 60) . $txt['totalTimeLogged4'];
Chris@76: 	$context['num_posts'] = comma_format($user_profile[$memID]['posts']);
Chris@76: 
Chris@76: 	// Number of topics started.
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}topics
Chris@76: 		WHERE id_member_started = {int:current_member}' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
Chris@76: 			AND id_board != {int:recycle_board}' : ''),
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 			'recycle_board' => $modSettings['recycle_board'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['num_topics']) = $smcFunc['db_fetch_row']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// Number polls started.
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}topics
Chris@76: 		WHERE id_member_started = {int:current_member}' . (!empty($modSettings['recycle_enable']) && $modSettings['recycle_board'] > 0 ? '
Chris@76: 			AND id_board != {int:recycle_board}' : '') . '
Chris@76: 			AND id_poll != {int:no_poll}',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 			'recycle_board' => $modSettings['recycle_board'],
Chris@76: 			'no_poll' => 0,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['num_polls']) = $smcFunc['db_fetch_row']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// Number polls voted in.
Chris@76: 	$result = $smcFunc['db_query']('distinct_poll_votes', '
Chris@76: 		SELECT COUNT(DISTINCT id_poll)
Chris@76: 		FROM {db_prefix}log_polls
Chris@76: 		WHERE id_member = {int:current_member}',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['num_votes']) = $smcFunc['db_fetch_row']($result);
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// Format the numbers...
Chris@76: 	$context['num_topics'] = comma_format($context['num_topics']);
Chris@76: 	$context['num_polls'] = comma_format($context['num_polls']);
Chris@76: 	$context['num_votes'] = comma_format($context['num_votes']);
Chris@76: 
Chris@76: 	// Grab the board this member posted in most often.
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			b.id_board, MAX(b.name) AS name, MAX(b.num_posts) AS num_posts, COUNT(*) AS message_count
Chris@76: 		FROM {db_prefix}messages AS m
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
Chris@76: 		WHERE m.id_member = {int:current_member}
Chris@76: 			AND b.count_posts = {int:count_enabled}
Chris@76: 			AND {query_see_board}
Chris@76: 		GROUP BY b.id_board
Chris@76: 		ORDER BY message_count DESC
Chris@76: 		LIMIT 10',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 			'count_enabled' => 0,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['popular_boards'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 	{
Chris@76: 		$context['popular_boards'][$row['id_board']] = array(
Chris@76: 			'id' => $row['id_board'],
Chris@76: 			'posts' => $row['message_count'],
Chris@76: 			'href' => $scripturl . '?board=' . $row['id_board'] . '.0',
Chris@76: 			'link' => '<a href="' . $scripturl . '?board=' . $row['id_board'] . '.0">' . $row['name'] . '</a>',
Chris@76: 			'posts_percent' => $user_profile[$memID]['posts'] == 0 ? 0 : ($row['message_count'] * 100) / $user_profile[$memID]['posts'],
Chris@76: 			'total_posts' => $row['num_posts'],
Chris@76: 			'total_posts_member' => $user_profile[$memID]['posts'],
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// Now get the 10 boards this user has most often participated in.
Chris@76: 	$result = $smcFunc['db_query']('profile_board_stats', '
Chris@76: 		SELECT
Chris@76: 			b.id_board, MAX(b.name) AS name, b.num_posts, COUNT(*) AS message_count,
Chris@76: 			CASE WHEN COUNT(*) > MAX(b.num_posts) THEN 1 ELSE COUNT(*) / MAX(b.num_posts) END * 100 AS percentage
Chris@76: 		FROM {db_prefix}messages AS m
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
Chris@76: 		WHERE m.id_member = {int:current_member}
Chris@76: 			AND {query_see_board}
Chris@76: 		GROUP BY b.id_board, b.num_posts
Chris@76: 		ORDER BY percentage DESC
Chris@76: 		LIMIT 10',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['board_activity'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 	{
Chris@76: 		$context['board_activity'][$row['id_board']] = array(
Chris@76: 			'id' => $row['id_board'],
Chris@76: 			'posts' => $row['message_count'],
Chris@76: 			'href' => $scripturl . '?board=' . $row['id_board'] . '.0',
Chris@76: 			'link' => '<a href="' . $scripturl . '?board=' . $row['id_board'] . '.0">' . $row['name'] . '</a>',
Chris@76: 			'percent' => comma_format((float) $row['percentage'], 2),
Chris@76: 			'posts_percent' => (float) $row['percentage'],
Chris@76: 			'total_posts' => $row['num_posts'],
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	// Posting activity by time.
Chris@76: 	$result = $smcFunc['db_query']('user_activity_by_time', '
Chris@76: 		SELECT
Chris@76: 			HOUR(FROM_UNIXTIME(poster_time + {int:time_offset})) AS hour,
Chris@76: 			COUNT(*) AS post_count
Chris@76: 		FROM {db_prefix}messages
Chris@76: 		WHERE id_member = {int:current_member}' . ($modSettings['totalMessages'] > 100000 ? '
Chris@76: 			AND id_topic > {int:top_ten_thousand_topics}' : '') . '
Chris@76: 		GROUP BY hour',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 			'top_ten_thousand_topics' => $modSettings['totalTopics'] - 10000,
Chris@76: 			'time_offset' => (($user_info['time_offset'] + $modSettings['time_offset']) * 3600),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$maxPosts = $realPosts = 0;
Chris@76: 	$context['posts_by_time'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 	{
Chris@76: 		// Cast as an integer to remove the leading 0.
Chris@76: 		$row['hour'] = (int) $row['hour'];
Chris@76: 
Chris@76: 		$maxPosts = max($row['post_count'], $maxPosts);
Chris@76: 		$realPosts += $row['post_count'];
Chris@76: 
Chris@76: 		$context['posts_by_time'][$row['hour']] = array(
Chris@76: 			'hour' => $row['hour'],
Chris@76: 			'hour_format' => stripos($user_info['time_format'], '%p') === false ? $row['hour'] : date('g a', mktime($row['hour'])),
Chris@76: 			'posts' => $row['post_count'],
Chris@76: 			'posts_percent' => 0,
Chris@76: 			'is_last' => $row['hour'] == 23,
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	if ($maxPosts > 0)
Chris@76: 		for ($hour = 0; $hour < 24; $hour++)
Chris@76: 		{
Chris@76: 			if (!isset($context['posts_by_time'][$hour]))
Chris@76: 				$context['posts_by_time'][$hour] = array(
Chris@76: 					'hour' => $hour,
Chris@76: 					'hour_format' => stripos($user_info['time_format'], '%p') === false ? $hour : date('g a', mktime($hour)),
Chris@76: 					'posts' => 0,
Chris@76: 					'posts_percent' => 0,
Chris@76: 					'relative_percent' => 0,
Chris@76: 					'is_last' => $hour == 23,
Chris@76: 				);
Chris@76: 			else
Chris@76: 			{
Chris@76: 				$context['posts_by_time'][$hour]['posts_percent'] = round(($context['posts_by_time'][$hour]['posts'] * 100) / $realPosts);
Chris@76: 				$context['posts_by_time'][$hour]['relative_percent'] = round(($context['posts_by_time'][$hour]['posts'] * 100) / $maxPosts);
Chris@76: 			}
Chris@76: 		}
Chris@76: 
Chris@76: 	// Put it in the right order.
Chris@76: 	ksort($context['posts_by_time']);
Chris@76: }
Chris@76: 
Chris@76: function tracking($memID)
Chris@76: {
Chris@76: 	global $sourcedir, $context, $txt, $scripturl, $modSettings, $user_profile;
Chris@76: 
Chris@76: 	$subActions = array(
Chris@76: 		'activity' => array('trackActivity', $txt['trackActivity']),
Chris@76: 		'ip' => array('TrackIP', $txt['trackIP']),
Chris@76: 		'edits' => array('trackEdits', $txt['trackEdits']),
Chris@76: 	);
Chris@76: 
Chris@76: 	$context['tracking_area'] = isset($_GET['sa']) && isset($subActions[$_GET['sa']]) ? $_GET['sa'] : 'activity';
Chris@76: 
Chris@76: 	if (isset($types[$context['tracking_area']][1]))
Chris@76: 		require_once($sourcedir . '/' . $types[$context['tracking_area']][1]);
Chris@76: 
Chris@76: 	// Create the tabs for the template.
Chris@76: 	$context[$context['profile_menu_name']]['tab_data'] = array(
Chris@76: 		'title' => $txt['tracking'],
Chris@76: 		'description' => $txt['tracking_description'],
Chris@76: 		'icon' => 'profile_sm.gif',
Chris@76: 		'tabs' => array(
Chris@76: 			'activity' => array(),
Chris@76: 			'ip' => array(),
Chris@76: 			'edits' => array(),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Moderation must be on to track edits.
Chris@76: 	if (empty($modSettings['modlog_enabled']))
Chris@76: 		unset($context[$context['profile_menu_name']]['tab_data']['edits']);
Chris@76: 
Chris@76: 	// Set a page title.
Chris@76: 	$context['page_title'] = $txt['trackUser'] . ' - ' . $subActions[$context['tracking_area']][1] . ' - ' . $user_profile[$memID]['real_name'];
Chris@76: 
Chris@76: 	// Pass on to the actual function.
Chris@76: 	$context['sub_template'] = $subActions[$context['tracking_area']][0];
Chris@76: 	$subActions[$context['tracking_area']][0]($memID);
Chris@76: }
Chris@76: 
Chris@76: function trackActivity($memID)
Chris@76: {
Chris@76: 	global $scripturl, $txt, $modSettings, $sourcedir;
Chris@76: 	global $user_profile, $context, $smcFunc;
Chris@76: 
Chris@76: 	// Verify if the user has sufficient permissions.
Chris@76: 	isAllowedTo('moderate_forum');
Chris@76: 
Chris@76: 	$context['last_ip'] = $user_profile[$memID]['member_ip'];
Chris@76: 	if ($context['last_ip'] != $user_profile[$memID]['member_ip2'])
Chris@76: 		$context['last_ip2'] = $user_profile[$memID]['member_ip2'];
Chris@76: 	$context['member']['name'] = $user_profile[$memID]['real_name'];
Chris@76: 
Chris@76: 	// Set the options for the list component.
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'track_user_list',
Chris@76: 		'title' => $txt['errors_by'] . ' ' . $context['member']['name'],
Chris@76: 		'items_per_page' => $modSettings['defaultMaxMessages'],
Chris@76: 		'no_items_label' => $txt['no_errors_from_user'],
Chris@76: 		'base_href' => $scripturl . '?action=profile;area=tracking;sa=user;u=' . $memID,
Chris@76: 		'default_sort_col' => 'date',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getUserErrors',
Chris@76: 			'params' => array(
Chris@76: 				'le.id_member = {int:current_member}',
Chris@76: 				array('current_member' => $memID),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getUserErrorCount',
Chris@76: 			'params' => array(
Chris@76: 				'id_member = {int:current_member}',
Chris@76: 				array('current_member' => $memID),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'ip_address' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['ip_address'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '<a href="' . $scripturl . '?action=profile;area=tracking;sa=ip;searchip=%1$s;u=' . $memID. '">%1$s</a>',
Chris@76: 						'params' => array(
Chris@76: 							'ip' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'le.ip',
Chris@76: 					'reverse' => 'le.ip DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'message' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['message'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '%1$s<br /><a href="%2$s">%2$s</a>',
Chris@76: 						'params' => array(
Chris@76: 							'message' => false,
Chris@76: 							'url' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'date' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['date'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'time',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'le.id_error DESC',
Chris@76: 					'reverse' => 'le.id_error',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'additional_rows' => array(
Chris@76: 			array(
Chris@76: 				'position' => 'after_title',
Chris@76: 				'value' => $txt['errors_desc'],
Chris@76: 				'class' => 'smalltext',
Chris@76: 				'style' => 'padding: 2ex;',
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Create the list for viewing.
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	// If this is a big forum, or a large posting user, let's limit the search.
Chris@76: 	if ($modSettings['totalMessages'] > 50000 && $user_profile[$memID]['posts'] > 500)
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT MAX(id_msg)
Chris@76: 			FROM {db_prefix}messages AS m
Chris@76: 			WHERE m.id_member = {int:current_member}',
Chris@76: 			array(
Chris@76: 				'current_member' => $memID,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		list ($max_msg_member) = $smcFunc['db_fetch_row']($request);
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 		// There's no point worrying ourselves with messages made yonks ago, just get recent ones!
Chris@76: 		$min_msg_member = max(0, $max_msg_member - $user_profile[$memID]['posts'] * 3);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Default to at least the ones we know about.
Chris@76: 	$ips = array(
Chris@76: 		$user_profile[$memID]['member_ip'],
Chris@76: 		$user_profile[$memID]['member_ip2'],
Chris@76: 	);
Chris@76: 
Chris@76: 	// Get all IP addresses this user has used for his messages.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT poster_ip
Chris@76: 		FROM {db_prefix}messages
Chris@76: 		WHERE id_member = {int:current_member}
Chris@76: 		' . (isset($min_msg_member) ? '
Chris@76: 			AND id_msg >= {int:min_msg_member} AND id_msg <= {int:max_msg_member}' : '') . '
Chris@76: 		GROUP BY poster_ip',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 			'min_msg_member' => !empty($min_msg_member) ? $min_msg_member : 0,
Chris@76: 			'max_msg_member' => !empty($max_msg_member) ? $max_msg_member : 0,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['ips'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$context['ips'][] = '<a href="' . $scripturl . '?action=profile;area=tracking;sa=ip;searchip=' . $row['poster_ip'] . ';u=' . $memID . '">' . $row['poster_ip'] . '</a>';
Chris@76: 		$ips[] = $row['poster_ip'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Now also get the IP addresses from the error messages.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*) AS error_count, ip
Chris@76: 		FROM {db_prefix}log_errors
Chris@76: 		WHERE id_member = {int:current_member}
Chris@76: 		GROUP BY ip',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['error_ips'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$context['error_ips'][] = '<a href="' . $scripturl . '?action=profile;area=tracking;sa=ip;searchip=' . $row['ip'] . ';u=' . $memID . '">' . $row['ip'] . '</a>';
Chris@76: 		$ips[] = $row['ip'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Find other users that might use the same IP.
Chris@76: 	$ips = array_unique($ips);
Chris@76: 	$context['members_in_range'] = array();
Chris@76: 	if (!empty($ips))
Chris@76: 	{
Chris@76: 		// Get member ID's which are in messages...
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT mem.id_member
Chris@76: 			FROM {db_prefix}messages AS m
Chris@76: 				INNER JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
Chris@76: 			WHERE m.poster_ip IN ({array_string:ip_list})
Chris@76: 			GROUP BY mem.id_member
Chris@76: 			HAVING mem.id_member != {int:current_member}',
Chris@76: 			array(
Chris@76: 				'current_member' => $memID,
Chris@76: 				'ip_list' => $ips,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		$message_members = array();
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 			$message_members[] = $row['id_member'];
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 		// Fetch their names, cause of the GROUP BY doesn't like giving us that normally.
Chris@76: 		if (!empty($message_members))
Chris@76: 		{
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT id_member, real_name
Chris@76: 				FROM {db_prefix}members
Chris@76: 				WHERE id_member IN ({array_int:message_members})',
Chris@76: 				array(
Chris@76: 					'message_members' => $message_members,
Chris@76: 					'ip_list' => $ips,
Chris@76: 				)
Chris@76: 			);
Chris@76: 			while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 				$context['members_in_range'][$row['id_member']] = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 		}
Chris@76: 
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_member, real_name
Chris@76: 			FROM {db_prefix}members
Chris@76: 			WHERE id_member != {int:current_member}
Chris@76: 				AND member_ip IN ({array_string:ip_list})',
Chris@76: 			array(
Chris@76: 				'current_member' => $memID,
Chris@76: 				'ip_list' => $ips,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 			$context['members_in_range'][$row['id_member']] = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: function list_getUserErrorCount($where, $where_vars = array())
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*) AS error_count
Chris@76: 		FROM {db_prefix}log_errors
Chris@76: 		WHERE ' . $where,
Chris@76: 		$where_vars
Chris@76: 	);
Chris@76: 	list ($count) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $count;
Chris@76: }
Chris@76: 
Chris@76: function list_getUserErrors($start, $items_per_page, $sort, $where, $where_vars = array())
Chris@76: {
Chris@76: 	global $smcFunc, $txt, $scripturl;
Chris@76: 
Chris@76: 	// Get a list of error messages from this ip (range).
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			le.log_time, le.ip, le.url, le.message, IFNULL(mem.id_member, 0) AS id_member,
Chris@76: 			IFNULL(mem.real_name, {string:guest_title}) AS display_name, mem.member_name
Chris@76: 		FROM {db_prefix}log_errors AS le
Chris@76: 			LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = le.id_member)
Chris@76: 		WHERE ' . $where . '
Chris@76: 		ORDER BY ' . $sort . '
Chris@76: 		LIMIT ' . $start . ', ' . $items_per_page,
Chris@76: 		array_merge($where_vars, array(
Chris@76: 			'guest_title' => $txt['guest_title'],
Chris@76: 		))
Chris@76: 	);
Chris@76: 	$error_messages = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$error_messages[] = array(
Chris@76: 			'ip' => $row['ip'],
Chris@76: 			'member_link' => $row['id_member'] > 0 ? '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['display_name'] . '</a>' : $row['display_name'],
Chris@76: 			'message' => strtr($row['message'], array('&lt;span class=&quot;remove&quot;&gt;' => '', '&lt;/span&gt;' => '')),
Chris@76: 			'url' => $row['url'],
Chris@76: 			'time' => timeformat($row['log_time']),
Chris@76: 			'timestamp' => forum_time(true, $row['log_time']),
Chris@76: 		);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $error_messages;
Chris@76: }
Chris@76: 
Chris@76: function list_getIPMessageCount($where, $where_vars = array())
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*) AS message_count
Chris@76: 		FROM {db_prefix}messages AS m
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
Chris@76: 		WHERE {query_see_board} AND ' . $where,
Chris@76: 		$where_vars
Chris@76: 	);
Chris@76: 	list ($count) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $count;
Chris@76: }
Chris@76: 
Chris@76: function list_getIPMessages($start, $items_per_page, $sort, $where, $where_vars = array())
Chris@76: {
Chris@76: 	global $smcFunc, $txt, $scripturl;
Chris@76: 
Chris@76: 	// Get all the messages fitting this where clause.
Chris@76: 	// !!!SLOW This query is using a filesort.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			m.id_msg, m.poster_ip, IFNULL(mem.real_name, m.poster_name) AS display_name, mem.id_member,
Chris@76: 			m.subject, m.poster_time, m.id_topic, m.id_board
Chris@76: 		FROM {db_prefix}messages AS m
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = m.id_board)
Chris@76: 			LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = m.id_member)
Chris@76: 		WHERE {query_see_board} AND ' . $where . '
Chris@76: 		ORDER BY ' . $sort . '
Chris@76: 		LIMIT ' . $start . ', ' . $items_per_page,
Chris@76: 		array_merge($where_vars, array(
Chris@76: 		))
Chris@76: 	);
Chris@76: 	$messages = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$messages[] = array(
Chris@76: 			'ip' => $row['poster_ip'],
Chris@76: 			'member_link' => empty($row['id_member']) ? $row['display_name'] : '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['display_name'] . '</a>',
Chris@76: 			'board' => array(
Chris@76: 				'id' => $row['id_board'],
Chris@76: 				'href' => $scripturl . '?board=' . $row['id_board']
Chris@76: 			),
Chris@76: 			'topic' => $row['id_topic'],
Chris@76: 			'id' => $row['id_msg'],
Chris@76: 			'subject' => $row['subject'],
Chris@76: 			'time' => timeformat($row['poster_time']),
Chris@76: 			'timestamp' => forum_time(true, $row['poster_time'])
Chris@76: 		);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $messages;
Chris@76: }
Chris@76: 
Chris@76: function TrackIP($memID = 0)
Chris@76: {
Chris@76: 	global $user_profile, $scripturl, $txt, $user_info, $modSettings, $sourcedir;
Chris@76: 	global $context, $smcFunc;
Chris@76: 
Chris@76: 	// Can the user do this?
Chris@76: 	isAllowedTo('moderate_forum');
Chris@76: 
Chris@76: 	if ($memID == 0)
Chris@76: 	{
Chris@76: 		$context['ip'] = $user_info['ip'];
Chris@76: 		loadTemplate('Profile');
Chris@76: 		loadLanguage('Profile');
Chris@76: 		$context['sub_template'] = 'trackIP';
Chris@76: 		$context['page_title'] = $txt['profile'];
Chris@76: 		$context['base_url'] = $scripturl . '?action=trackip';
Chris@76: 	}
Chris@76: 	else
Chris@76: 	{
Chris@76: 		$context['ip'] = $user_profile[$memID]['member_ip'];
Chris@76: 		$context['base_url'] = $scripturl . '?action=profile;area=tracking;sa=ip;u=' . $memID;
Chris@76: 	}
Chris@76: 
Chris@76: 	// Searching?
Chris@76: 	if (isset($_REQUEST['searchip']))
Chris@76: 		$context['ip'] = trim($_REQUEST['searchip']);
Chris@76: 
Chris@76: 	if (preg_match('/^\d{1,3}\.(\d{1,3}|\*)\.(\d{1,3}|\*)\.(\d{1,3}|\*)$/', $context['ip']) == 0)
Chris@76: 		fatal_lang_error('invalid_tracking_ip', false);
Chris@76: 
Chris@76: 	$ip_var = str_replace('*', '%', $context['ip']);
Chris@76: 	$ip_string = strpos($ip_var, '%') === false ? '= {string:ip_address}' : 'LIKE {string:ip_address}';
Chris@76: 
Chris@76: 	if (empty($context['tracking_area']))
Chris@76: 		$context['page_title'] = $txt['trackIP'] . ' - ' . $context['ip'];
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_member, real_name AS display_name, member_ip
Chris@76: 		FROM {db_prefix}members
Chris@76: 		WHERE member_ip ' . $ip_string,
Chris@76: 		array(
Chris@76: 			'ip_address' => $ip_var,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['ips'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$context['ips'][$row['member_ip']][] = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['display_name'] . '</a>';
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	ksort($context['ips']);
Chris@76: 
Chris@76: 	// Gonna want this for the list.
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 
Chris@76: 	// Start with the user messages.
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'track_message_list',
Chris@76: 		'title' => $txt['messages_from_ip'] . ' ' . $context['ip'],
Chris@76: 		'start_var_name' => 'messageStart',
Chris@76: 		'items_per_page' => $modSettings['defaultMaxMessages'],
Chris@76: 		'no_items_label' => $txt['no_messages_from_ip'],
Chris@76: 		'base_href' => $context['base_url'] . ';searchip=' . $context['ip'],
Chris@76: 		'default_sort_col' => 'date',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getIPMessages',
Chris@76: 			'params' => array(
Chris@76: 				'm.poster_ip ' . $ip_string,
Chris@76: 				array('ip_address' => $ip_var),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getIPMessageCount',
Chris@76: 			'params' => array(
Chris@76: 				'm.poster_ip ' . $ip_string,
Chris@76: 				array('ip_address' => $ip_var),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'ip_address' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['ip_address'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '<a href="' . $context['base_url'] . ';searchip=%1$s">%1$s</a>',
Chris@76: 						'params' => array(
Chris@76: 							'ip' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'INET_ATON(m.poster_ip)',
Chris@76: 					'reverse' => 'INET_ATON(m.poster_ip) DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'poster' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['poster'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'member_link',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'subject' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['subject'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '<a href="' . $scripturl . '?topic=%1$s.msg%2$s#msg%2$s" rel="nofollow">%3$s</a>',
Chris@76: 						'params' => array(
Chris@76: 							'topic' => false,
Chris@76: 							'id' => false,
Chris@76: 							'subject' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'date' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['date'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'time',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'm.id_msg DESC',
Chris@76: 					'reverse' => 'm.id_msg',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'additional_rows' => array(
Chris@76: 			array(
Chris@76: 				'position' => 'after_title',
Chris@76: 				'value' => $txt['messages_from_ip_desc'],
Chris@76: 				'class' => 'smalltext',
Chris@76: 				'style' => 'padding: 2ex;',
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Create the messages list.
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	// Set the options for the error lists.
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'track_user_list',
Chris@76: 		'title' => $txt['errors_from_ip'] . ' ' . $context['ip'],
Chris@76: 		'start_var_name' => 'errorStart',
Chris@76: 		'items_per_page' => $modSettings['defaultMaxMessages'],
Chris@76: 		'no_items_label' => $txt['no_errors_from_ip'],
Chris@76: 		'base_href' => $context['base_url'] . ';searchip=' . $context['ip'],
Chris@76: 		'default_sort_col' => 'date2',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getUserErrors',
Chris@76: 			'params' => array(
Chris@76: 				'le.ip ' . $ip_string,
Chris@76: 				array('ip_address' => $ip_var),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getUserErrorCount',
Chris@76: 			'params' => array(
Chris@76: 				'ip ' . $ip_string,
Chris@76: 				array('ip_address' => $ip_var),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'ip_address2' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['ip_address'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '<a href="' . $context['base_url'] . ';searchip=%1$s">%1$s</a>',
Chris@76: 						'params' => array(
Chris@76: 							'ip' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'INET_ATON(le.ip)',
Chris@76: 					'reverse' => 'INET_ATON(le.ip) DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'display_name' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['display_name'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'member_link',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'message' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['message'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '%1$s<br /><a href="%2$s">%2$s</a>',
Chris@76: 						'params' => array(
Chris@76: 							'message' => false,
Chris@76: 							'url' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'date2' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['date'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'time',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'le.id_error DESC',
Chris@76: 					'reverse' => 'le.id_error',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'additional_rows' => array(
Chris@76: 			array(
Chris@76: 				'position' => 'after_title',
Chris@76: 				'value' => $txt['errors_from_ip_desc'],
Chris@76: 				'class' => 'smalltext',
Chris@76: 				'style' => 'padding: 2ex;',
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Create the error list.
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	$context['single_ip'] = strpos($context['ip'], '*') === false;
Chris@76: 	if ($context['single_ip'])
Chris@76: 	{
Chris@76: 		$context['whois_servers'] = array(
Chris@76: 			'afrinic' => array(
Chris@76: 				'name' => $txt['whois_afrinic'],
Chris@76: 				'url' => 'http://www.afrinic.net/cgi-bin/whois?searchtext=' . $context['ip'],
Chris@76: 				'range' => array(41, 154, 196),
Chris@76: 			),
Chris@76: 			'apnic' => array(
Chris@76: 				'name' => $txt['whois_apnic'],
Chris@76: 				'url' => 'http://wq.apnic.net/apnic-bin/whois.pl?searchtext=' . $context['ip'],
Chris@76: 				'range' => array(58, 59, 60, 61, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124,
Chris@76: 					125, 126, 133, 150, 153, 163, 171, 202, 203, 210, 211, 218, 219, 220, 221, 222),
Chris@76: 			),
Chris@76: 			'arin' => array(
Chris@76: 				'name' => $txt['whois_arin'],
Chris@76: 				'url' => 'http://whois.arin.net/rest/ip/' . $context['ip'],
Chris@76: 				'range' => array(7, 24, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 96, 97, 98, 99,
Chris@76: 					128, 129, 130, 131, 132, 134, 135, 136, 137, 138, 139, 140, 142, 143, 144, 146, 147, 148, 149,
Chris@76: 					152, 155, 156, 157, 158, 159, 160, 161, 162, 164, 165, 166, 167, 168, 169, 170, 172, 173, 174,
Chris@76: 					192, 198, 199, 204, 205, 206, 207, 208, 209, 216),
Chris@76: 			),
Chris@76: 			'lacnic' => array(
Chris@76: 				'name' => $txt['whois_lacnic'],
Chris@76: 				'url' => 'http://lacnic.net/cgi-bin/lacnic/whois?query=' . $context['ip'],
Chris@76: 				'range' => array(186, 187, 189, 190, 191, 200, 201),
Chris@76: 			),
Chris@76: 			'ripe' => array(
Chris@76: 				'name' => $txt['whois_ripe'],
Chris@76: 				'url' => 'http://www.db.ripe.net/whois?searchtext=' . $context['ip'],
Chris@76: 				'range' => array(62, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95,
Chris@76: 					141, 145, 151, 188, 193, 194, 195, 212, 213, 217),
Chris@76: 			),
Chris@76: 		);
Chris@76: 
Chris@76: 		foreach ($context['whois_servers'] as $whois)
Chris@76: 		{
Chris@76: 			// Strip off the "decimal point" and anything following...
Chris@76: 			if (in_array((int) $context['ip'], $whois['range']))
Chris@76: 				$context['auto_whois_server'] = $whois;
Chris@76: 		}
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: function trackEdits($memID)
Chris@76: {
Chris@76: 	global $scripturl, $txt, $modSettings, $sourcedir, $context, $smcFunc;
Chris@76: 
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 
Chris@76: 	// Get the names of any custom fields.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT col_name, field_name, bbc
Chris@76: 		FROM {db_prefix}custom_fields',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['custom_field_titles'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$context['custom_field_titles']['customfield_' . $row['col_name']] = array(
Chris@76: 			'title' => $row['field_name'],
Chris@76: 			'parse_bbc' => $row['bbc'],
Chris@76: 		);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Set the options for the error lists.
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'edit_list',
Chris@76: 		'title' => $txt['trackEdits'],
Chris@76: 		'items_per_page' => $modSettings['defaultMaxMessages'],
Chris@76: 		'no_items_label' => $txt['trackEdit_no_edits'],
Chris@76: 		'base_href' => $scripturl . '?action=profile;area=tracking;sa=edits;u=' . $memID,
Chris@76: 		'default_sort_col' => 'time',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getProfileEdits',
Chris@76: 			'params' => array(
Chris@76: 				$memID,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getProfileEditCount',
Chris@76: 			'params' => array(
Chris@76: 				$memID,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'action' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['trackEdit_action'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'action_text',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'before' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['trackEdit_before'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'before',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'after' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['trackEdit_after'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'after',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'time' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['date'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'time',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'id_action DESC',
Chris@76: 					'reverse' => 'id_action',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'applicator' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['trackEdit_applicator'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'member_link',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Create the error list.
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	$context['sub_template'] = 'show_list';
Chris@76: 	$context['default_list'] = 'edit_list';
Chris@76: }
Chris@76: 
Chris@76: // How many edits?
Chris@76: function list_getProfileEditCount($memID)
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*) AS edit_count
Chris@76: 		FROM {db_prefix}log_actions
Chris@76: 		WHERE id_log = {int:log_type}
Chris@76: 			AND id_member = {int:owner}',
Chris@76: 		array(
Chris@76: 			'log_type' => 2,
Chris@76: 			'owner' => $memID,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($edit_count) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $edit_count;
Chris@76: }
Chris@76: 
Chris@76: function list_getProfileEdits($start, $items_per_page, $sort, $memID)
Chris@76: {
Chris@76: 	global $smcFunc, $txt, $scripturl, $context;
Chris@76: 
Chris@76: 	// Get a list of error messages from this ip (range).
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			id_action, id_member, ip, log_time, action, extra
Chris@76: 		FROM {db_prefix}log_actions
Chris@76: 		WHERE id_log = {int:log_type}
Chris@76: 			AND id_member = {int:owner}
Chris@76: 		ORDER BY ' . $sort . '
Chris@76: 		LIMIT ' . $start . ', ' . $items_per_page,
Chris@76: 		array(
Chris@76: 			'log_type' => 2,
Chris@76: 			'owner' => $memID,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$edits = array();
Chris@76: 	$members = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$extra = @unserialize($row['extra']);
Chris@76: 		if (!empty($extra['applicator']))
Chris@76: 			$members[] = $extra['applicator'];
Chris@76: 
Chris@76: 		// Work out what the name of the action is.
Chris@76: 		if (isset($txt['trackEdit_action_' . $row['action']]))
Chris@76: 			$action_text = $txt['trackEdit_action_' . $row['action']];
Chris@76: 		elseif (isset($txt[$row['action']]))
Chris@76: 			$action_text = $txt[$row['action']];
Chris@76: 		// Custom field?
Chris@76: 		elseif (isset($context['custom_field_titles'][$row['action']]))
Chris@76: 			$action_text = $context['custom_field_titles'][$row['action']]['title'];
Chris@76: 		else
Chris@76: 			$action_text = $row['action'];
Chris@76: 
Chris@76: 		// Parse BBC?
Chris@76: 		$parse_bbc = isset($context['custom_field_titles'][$row['action']]) && $context['custom_field_titles'][$row['action']]['parse_bbc'] ? true : false;
Chris@76: 
Chris@76: 		$edits[] = array(
Chris@76: 			'id' => $row['id_action'],
Chris@76: 			'ip' => $row['ip'],
Chris@76: 			'id_member' => !empty($extra['applicator']) ? $extra['applicator'] : 0,
Chris@76: 			'member_link' => $txt['trackEdit_deleted_member'],
Chris@76: 			'action' => $row['action'],
Chris@76: 			'action_text' => $action_text,
Chris@76: 			'before' => !empty($extra['previous']) ? ($parse_bbc ? parse_bbc($extra['previous']) : $extra['previous']) : '',
Chris@76: 			'after' => !empty($extra['new']) ? ($parse_bbc ? parse_bbc($extra['new']) : $extra['new']) : '',
Chris@76: 			'time' => timeformat($row['log_time']),
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Get any member names.
Chris@76: 	if (!empty($members))
Chris@76: 	{
Chris@76: 		$request = $smcFunc['db_query']('', '
Chris@76: 			SELECT
Chris@76: 				id_member, real_name
Chris@76: 			FROM {db_prefix}members
Chris@76: 			WHERE id_member IN ({array_int:members})',
Chris@76: 			array(
Chris@76: 				'members' => $members,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		$members = array();
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 			$members[$row['id_member']] = $row['real_name'];
Chris@76: 		$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 		foreach ($edits as $key => $value)
Chris@76: 			if (isset($members[$value['id_member']]))
Chris@76: 				$edits[$key]['member_link'] = '<a href="' . $scripturl . '?action=profile;u=' . $value['id_member'] . '">' . $members[$value['id_member']] . '</a>';
Chris@76: 	}
Chris@76: 
Chris@76: 	return $edits;
Chris@76: }
Chris@76: 
Chris@76: function showPermissions($memID)
Chris@76: {
Chris@76: 	global $scripturl, $txt, $board, $modSettings;
Chris@76: 	global $user_profile, $context, $user_info, $sourcedir, $smcFunc;
Chris@76: 
Chris@76: 	// Verify if the user has sufficient permissions.
Chris@76: 	isAllowedTo('manage_permissions');
Chris@76: 
Chris@76: 	loadLanguage('ManagePermissions');
Chris@76: 	loadLanguage('Admin');
Chris@76: 	loadTemplate('ManageMembers');
Chris@76: 
Chris@76: 	// Load all the permission profiles.
Chris@76: 	require_once($sourcedir . '/ManagePermissions.php');
Chris@76: 	loadPermissionProfiles();
Chris@76: 
Chris@76: 	$context['member']['id'] = $memID;
Chris@76: 	$context['member']['name'] = $user_profile[$memID]['real_name'];
Chris@76: 
Chris@76: 	$context['page_title'] = $txt['showPermissions'];
Chris@76: 	$board = empty($board) ? 0 : (int) $board;
Chris@76: 	$context['board'] = $board;
Chris@76: 
Chris@76: 	// Determine which groups this user is in.
Chris@76: 	if (empty($user_profile[$memID]['additional_groups']))
Chris@76: 		$curGroups = array();
Chris@76: 	else
Chris@76: 		$curGroups = explode(',', $user_profile[$memID]['additional_groups']);
Chris@76: 	$curGroups[] = $user_profile[$memID]['id_group'];
Chris@76: 	$curGroups[] = $user_profile[$memID]['id_post_group'];
Chris@76: 
Chris@76: 	// Load a list of boards for the jump box - except the defaults.
Chris@76: 	$request = $smcFunc['db_query']('order_by_board_order', '
Chris@76: 		SELECT b.id_board, b.name, b.id_profile, b.member_groups, IFNULL(mods.id_member, 0) AS is_mod
Chris@76: 		FROM {db_prefix}boards AS b
Chris@76: 			LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board AND mods.id_member = {int:current_member})
Chris@76: 		WHERE {query_see_board}',
Chris@76: 		array(
Chris@76: 			'current_member' => $memID,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['boards'] = array();
Chris@76: 	$context['no_access_boards'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		if (count(array_intersect($curGroups, explode(',', $row['member_groups']))) === 0 && !$row['is_mod'])
Chris@76: 			$context['no_access_boards'][] = array(
Chris@76: 				'id' => $row['id_board'],
Chris@76: 				'name' => $row['name'],
Chris@76: 				'is_last' => false,
Chris@76: 			);
Chris@76: 		elseif ($row['id_profile'] != 1 || $row['is_mod'])
Chris@76: 			$context['boards'][$row['id_board']] = array(
Chris@76: 				'id' => $row['id_board'],
Chris@76: 				'name' => $row['name'],
Chris@76: 				'selected' => $board == $row['id_board'],
Chris@76: 				'profile' => $row['id_profile'],
Chris@76: 				'profile_name' => $context['profiles'][$row['id_profile']]['name'],
Chris@76: 			);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	if (!empty($context['no_access_boards']))
Chris@76: 		$context['no_access_boards'][count($context['no_access_boards']) - 1]['is_last'] = true;
Chris@76: 
Chris@76: 	$context['member']['permissions'] = array(
Chris@76: 		'general' => array(),
Chris@76: 		'board' => array()
Chris@76: 	);
Chris@76: 
Chris@76: 	// If you're an admin we know you can do everything, we might as well leave.
Chris@76: 	$context['member']['has_all_permissions'] = in_array(1, $curGroups);
Chris@76: 	if ($context['member']['has_all_permissions'])
Chris@76: 		return;
Chris@76: 
Chris@76: 	$denied = array();
Chris@76: 
Chris@76: 	// Get all general permissions.
Chris@76: 	$result = $smcFunc['db_query']('', '
Chris@76: 		SELECT p.permission, p.add_deny, mg.group_name, p.id_group
Chris@76: 		FROM {db_prefix}permissions AS p
Chris@76: 			LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = p.id_group)
Chris@76: 		WHERE p.id_group IN ({array_int:group_list})
Chris@76: 		ORDER BY p.add_deny DESC, p.permission, mg.min_posts, CASE WHEN mg.id_group < {int:newbie_group} THEN mg.id_group ELSE 4 END, mg.group_name',
Chris@76: 		array(
Chris@76: 			'group_list' => $curGroups,
Chris@76: 			'newbie_group' => 4,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 	{
Chris@76: 		// We don't know about this permission, it doesn't exist :P.
Chris@76: 		if (!isset($txt['permissionname_' . $row['permission']]))
Chris@76: 			continue;
Chris@76: 
Chris@76: 		if (empty($row['add_deny']))
Chris@76: 			$denied[] = $row['permission'];
Chris@76: 
Chris@76: 		// Permissions that end with _own or _any consist of two parts.
Chris@76: 		if (in_array(substr($row['permission'], -4), array('_own', '_any')) && isset($txt['permissionname_' . substr($row['permission'], 0, -4)]))
Chris@76: 			$name = $txt['permissionname_' . substr($row['permission'], 0, -4)] . ' - ' . $txt['permissionname_' . $row['permission']];
Chris@76: 		else
Chris@76: 			$name = $txt['permissionname_' . $row['permission']];
Chris@76: 
Chris@76: 		// Add this permission if it doesn't exist yet.
Chris@76: 		if (!isset($context['member']['permissions']['general'][$row['permission']]))
Chris@76: 			$context['member']['permissions']['general'][$row['permission']] = array(
Chris@76: 				'id' => $row['permission'],
Chris@76: 				'groups' => array(
Chris@76: 					'allowed' => array(),
Chris@76: 					'denied' => array()
Chris@76: 				),
Chris@76: 				'name' => $name,
Chris@76: 				'is_denied' => false,
Chris@76: 				'is_global' => true,
Chris@76: 			);
Chris@76: 
Chris@76: 		// Add the membergroup to either the denied or the allowed groups.
Chris@76: 		$context['member']['permissions']['general'][$row['permission']]['groups'][empty($row['add_deny']) ? 'denied' : 'allowed'][] = $row['id_group'] == 0 ? $txt['membergroups_members'] : $row['group_name'];
Chris@76: 
Chris@76: 		// Once denied is always denied.
Chris@76: 		$context['member']['permissions']['general'][$row['permission']]['is_denied'] |= empty($row['add_deny']);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			bp.add_deny, bp.permission, bp.id_group, mg.group_name' . (empty($board) ? '' : ',
Chris@76: 			b.id_profile, CASE WHEN mods.id_member IS NULL THEN 0 ELSE 1 END AS is_moderator') . '
Chris@76: 		FROM {db_prefix}board_permissions AS bp' . (empty($board) ? '' : '
Chris@76: 			INNER JOIN {db_prefix}boards AS b ON (b.id_board = {int:current_board})
Chris@76: 			LEFT JOIN {db_prefix}moderators AS mods ON (mods.id_board = b.id_board AND mods.id_member = {int:current_member})') . '
Chris@76: 			LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = bp.id_group)
Chris@76: 		WHERE bp.id_profile = {raw:current_profile}
Chris@76: 			AND bp.id_group IN ({array_int:group_list}' . (empty($board) ? ')' : ', {int:moderator_group})
Chris@76: 			AND (mods.id_member IS NOT NULL OR bp.id_group != {int:moderator_group})'),
Chris@76: 		array(
Chris@76: 			'current_board' => $board,
Chris@76: 			'group_list' => $curGroups,
Chris@76: 			'current_member' => $memID,
Chris@76: 			'current_profile' => empty($board) ? '1' : 'b.id_profile',
Chris@76: 			'moderator_group' => 3,
Chris@76: 		)
Chris@76: 	);
Chris@76: 
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// We don't know about this permission, it doesn't exist :P.
Chris@76: 		if (!isset($txt['permissionname_' . $row['permission']]))
Chris@76: 			continue;
Chris@76: 
Chris@76: 		// The name of the permission using the format 'permission name' - 'own/any topic/event/etc.'.
Chris@76: 		if (in_array(substr($row['permission'], -4), array('_own', '_any')) && isset($txt['permissionname_' . substr($row['permission'], 0, -4)]))
Chris@76: 			$name = $txt['permissionname_' . substr($row['permission'], 0, -4)] . ' - ' . $txt['permissionname_' . $row['permission']];
Chris@76: 		else
Chris@76: 			$name = $txt['permissionname_' . $row['permission']];
Chris@76: 
Chris@76: 		// Create the structure for this permission.
Chris@76: 		if (!isset($context['member']['permissions']['board'][$row['permission']]))
Chris@76: 			$context['member']['permissions']['board'][$row['permission']] = array(
Chris@76: 				'id' => $row['permission'],
Chris@76: 				'groups' => array(
Chris@76: 					'allowed' => array(),
Chris@76: 					'denied' => array()
Chris@76: 				),
Chris@76: 				'name' => $name,
Chris@76: 				'is_denied' => false,
Chris@76: 				'is_global' => empty($board),
Chris@76: 			);
Chris@76: 
Chris@76: 		$context['member']['permissions']['board'][$row['permission']]['groups'][empty($row['add_deny']) ? 'denied' : 'allowed'][$row['id_group']] = $row['id_group'] == 0 ? $txt['membergroups_members'] : $row['group_name'];
Chris@76: 
Chris@76: 		$context['member']['permissions']['board'][$row['permission']]['is_denied'] |= empty($row['add_deny']);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: }
Chris@76: 
Chris@76: // View a members warnings?
Chris@76: function viewWarning($memID)
Chris@76: {
Chris@76: 	global $modSettings, $context, $sourcedir, $txt, $scripturl;
Chris@76: 
Chris@76: 	// Firstly, can we actually even be here?
Chris@76: 	if (!allowedTo('issue_warning') && (empty($modSettings['warning_show']) || ($modSettings['warning_show'] == 1 && !$context['user']['is_owner'])))
Chris@76: 		fatal_lang_error('no_access', false);
Chris@76: 
Chris@76: 	// Make sure things which are disabled stay disabled.
Chris@76: 	$modSettings['warning_watch'] = !empty($modSettings['warning_watch']) ? $modSettings['warning_watch'] : 110;
Chris@76: 	$modSettings['warning_moderate'] = !empty($modSettings['warning_moderate']) && !empty($modSettings['postmod_active']) ? $modSettings['warning_moderate'] : 110;
Chris@76: 	$modSettings['warning_mute'] = !empty($modSettings['warning_mute']) ? $modSettings['warning_mute'] : 110;
Chris@76: 
Chris@76: 	// Let's use a generic list to get all the current warnings, and use the issue warnings grab-a-granny thing.
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 	require_once($sourcedir . '/Profile-Actions.php');
Chris@76: 
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'view_warnings',
Chris@76: 		'title' => $txt['profile_viewwarning_previous_warnings'],
Chris@76: 		'items_per_page' => $modSettings['defaultMaxMessages'],
Chris@76: 		'no_items_label' => $txt['profile_viewwarning_no_warnings'],
Chris@76: 		'base_href' => $scripturl . '?action=profile;area=viewwarning;sa=user;u=' . $memID,
Chris@76: 		'default_sort_col' => 'log_time',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getUserWarnings',
Chris@76: 			'params' => array(
Chris@76: 				$memID,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getUserWarningCount',
Chris@76: 			'params' => array(
Chris@76: 				$memID,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'log_time' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['profile_warning_previous_time'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'time',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'lc.log_time DESC',
Chris@76: 					'reverse' => 'lc.log_time',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'reason' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['profile_warning_previous_reason'],
Chris@76: 					'style' => 'width: 50%',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'reason',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'level' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['profile_warning_previous_level'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'counter',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'lc.counter DESC',
Chris@76: 					'reverse' => 'lc.counter',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'additional_rows' => array(
Chris@76: 			array(
Chris@76: 				'position' => 'after_title',
Chris@76: 				'value' => $txt['profile_viewwarning_desc'],
Chris@76: 				'class' => 'smalltext',
Chris@76: 				'style' => 'padding: 2ex;',
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Create the list for viewing.
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	// Create some common text bits for the template.
Chris@76: 	$context['level_effects'] = array(
Chris@76: 		0 => '',
Chris@76: 		$modSettings['warning_watch'] => $txt['profile_warning_effect_own_watched'],
Chris@76: 		$modSettings['warning_moderate'] => $txt['profile_warning_effect_own_moderated'],
Chris@76: 		$modSettings['warning_mute'] => $txt['profile_warning_effect_own_muted'],
Chris@76: 	);
Chris@76: 	$context['current_level'] = 0;
Chris@76: 	foreach ($context['level_effects'] as $limit => $dummy)
Chris@76: 		if ($context['member']['warning'] >= $limit)
Chris@76: 			$context['current_level'] = $limit;
Chris@76: }
Chris@76: 
Chris@76: ?>