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.2
Chris@76:  */
Chris@76: 
Chris@76: if (!defined('SMF'))
Chris@76: 	die('Hacking attempt...');
Chris@76: 
Chris@76: /*	This file is mainly concerned, or that is to say only concerned, with the
Chris@76: 	Who's Online list.  It contains only the following functions:
Chris@76: 
Chris@76: 	void Who()
Chris@76: 		- prepares the who's online data for the Who template.
Chris@76: 		- uses the Who template (main sub template.) and language file.
Chris@76: 		- requires the who_view permission.
Chris@76: 		- is enabled with the who_enabled setting.
Chris@76: 		- is accessed via ?action=who.
Chris@76: 
Chris@76: 	array determineActions(array urls, string preferred_prefix = false)
Chris@76: 		- determine the actions of the members passed in urls.
Chris@76: 		- urls should be a single url (string) or an array of arrays, each
Chris@76: 		  inner array being (serialized request data, id_member).
Chris@76: 		- returns an array of descriptions if you passed an array, otherwise
Chris@76: 		  the string describing their current location.
Chris@76: 
Chris@76: 	void Credits(bool in_admin)
Chris@76: 		- prepares credit and copyright information for the credits page or the admin page
Chris@76: 		- if parameter is true the it will not load the sub template nor the template file
Chris@76: 
Chris@76: 	Adding actions to the Who's Online list:
Chris@76: 	---------------------------------------------------------------------------
Chris@76: 		Adding actions to this list is actually relatively easy....
Chris@76: 		- for actions anyone should be able to see, just add a string named
Chris@76: 		   whoall_ACTION.  (where ACTION is the action used in index.php.)
Chris@76: 		- for actions that have a subaction which should be represented
Chris@76: 		   differently, use whoall_ACTION_SUBACTION.
Chris@76: 		- for actions that include a topic, and should be restricted, use
Chris@76: 		   whotopic_ACTION.
Chris@76: 		- for actions that use a message, by msg or quote, use whopost_ACTION.
Chris@76: 		- for administrator-only actions, use whoadmin_ACTION.
Chris@76: 		- for actions that should be viewable only with certain permissions,
Chris@76: 		   use whoallow_ACTION and add a list of possible permissions to the
Chris@76: 		   $allowedActions array, using ACTION as the key.
Chris@76: */
Chris@76: 
Chris@76: // Who's online, and what are they doing?
Chris@76: function Who()
Chris@76: {
Chris@76: 	global $context, $scripturl, $user_info, $txt, $modSettings, $memberContext, $smcFunc;
Chris@76: 
Chris@76: 	// Permissions, permissions, permissions.
Chris@76: 	isAllowedTo('who_view');
Chris@76: 
Chris@76: 	// You can't do anything if this is off.
Chris@76: 	if (empty($modSettings['who_enabled']))
Chris@76: 		fatal_lang_error('who_off', false);
Chris@76: 
Chris@76: 	// Load the 'Who' template.
Chris@76: 	loadTemplate('Who');
Chris@76: 	loadLanguage('Who');
Chris@76: 
Chris@76: 	// Sort out... the column sorting.
Chris@76: 	$sort_methods = array(
Chris@76: 		'user' => 'mem.real_name',
Chris@76: 		'time' => 'lo.log_time'
Chris@76: 	);
Chris@76: 
Chris@76: 	$show_methods = array(
Chris@76: 		'members' => '(lo.id_member != 0)',
Chris@76: 		'guests' => '(lo.id_member = 0)',
Chris@76: 		'all' => '1=1',
Chris@76: 	);
Chris@76: 
Chris@76: 	// Store the sort methods and the show types for use in the template.
Chris@76: 	$context['sort_methods'] = array(
Chris@76: 		'user' => $txt['who_user'],
Chris@76: 		'time' => $txt['who_time'],
Chris@76: 	);
Chris@76: 	$context['show_methods'] = array(
Chris@76: 		'all' => $txt['who_show_all'],
Chris@76: 		'members' => $txt['who_show_members_only'],
Chris@76: 		'guests' => $txt['who_show_guests_only'],
Chris@76: 	);
Chris@76: 
Chris@76: 	// Can they see spiders too?
Chris@76: 	if (!empty($modSettings['show_spider_online']) && ($modSettings['show_spider_online'] == 2 || allowedTo('admin_forum')) && !empty($modSettings['spider_name_cache']))
Chris@76: 	{
Chris@76: 		$show_methods['spiders'] = '(lo.id_member = 0 AND lo.id_spider > 0)';
Chris@76: 		$show_methods['guests'] = '(lo.id_member = 0 AND lo.id_spider = 0)';
Chris@76: 		$context['show_methods']['spiders'] = $txt['who_show_spiders_only'];
Chris@76: 	}
Chris@76: 	elseif (empty($modSettings['show_spider_online']) && isset($_SESSION['who_online_filter']) && $_SESSION['who_online_filter'] == 'spiders')
Chris@76: 		unset($_SESSION['who_online_filter']);
Chris@76: 
Chris@76: 	// Does the user prefer a different sort direction?
Chris@76: 	if (isset($_REQUEST['sort']) && isset($sort_methods[$_REQUEST['sort']]))
Chris@76: 	{
Chris@76: 		$context['sort_by'] = $_SESSION['who_online_sort_by'] = $_REQUEST['sort'];
Chris@76: 		$sort_method = $sort_methods[$_REQUEST['sort']];
Chris@76: 	}
Chris@76: 	// Did we set a preferred sort order earlier in the session?
Chris@76: 	elseif (isset($_SESSION['who_online_sort_by']))
Chris@76: 	{
Chris@76: 		$context['sort_by'] = $_SESSION['who_online_sort_by'];
Chris@76: 		$sort_method = $sort_methods[$_SESSION['who_online_sort_by']];
Chris@76: 	}
Chris@76: 	// Default to last time online.
Chris@76: 	else
Chris@76: 	{
Chris@76: 		$context['sort_by'] = $_SESSION['who_online_sort_by'] = 'time';
Chris@76: 		$sort_method = 'lo.log_time';
Chris@76: 	}
Chris@76: 
Chris@76: 	$context['sort_direction'] = isset($_REQUEST['asc']) || (isset($_REQUEST['sort_dir']) && $_REQUEST['sort_dir'] == 'asc') ? 'up' : 'down';
Chris@76: 
Chris@76: 	$conditions = array();
Chris@76: 	if (!allowedTo('moderate_forum'))
Chris@76: 		$conditions[] = '(IFNULL(mem.show_online, 1) = 1)';
Chris@76: 
Chris@76: 	// Fallback to top filter?
Chris@76: 	if (isset($_REQUEST['submit_top']) && isset($_REQUEST['show_top']))
Chris@76: 		$_REQUEST['show'] = $_REQUEST['show_top'];
Chris@76: 	// Does the user wish to apply a filter?
Chris@76: 	if (isset($_REQUEST['show']) && isset($show_methods[$_REQUEST['show']]))
Chris@76: 	{
Chris@76: 		$context['show_by'] = $_SESSION['who_online_filter'] = $_REQUEST['show'];
Chris@76: 		$conditions[] = $show_methods[$_REQUEST['show']];
Chris@76: 	}
Chris@76: 	// Perhaps we saved a filter earlier in the session?
Chris@76: 	elseif (isset($_SESSION['who_online_filter']))
Chris@76: 	{
Chris@76: 		$context['show_by'] = $_SESSION['who_online_filter'];
Chris@76: 		$conditions[] = $show_methods[$_SESSION['who_online_filter']];
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$context['show_by'] = $_SESSION['who_online_filter'] = 'all';
Chris@76: 
Chris@76: 	// Get the total amount of members online.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}log_online AS lo
Chris@76: 			LEFT JOIN {db_prefix}members AS mem ON (lo.id_member = mem.id_member)' . (!empty($conditions) ? '
Chris@76: 		WHERE ' . implode(' AND ', $conditions) : ''),
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($totalMembers) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Prepare some page index variables.
Chris@76: 	$context['page_index'] = constructPageIndex($scripturl . '?action=who;sort=' . $context['sort_by'] . ($context['sort_direction'] == 'up' ? ';asc' : '') . ';show=' . $context['show_by'], $_REQUEST['start'], $totalMembers, $modSettings['defaultMaxMembers']);
Chris@76: 	$context['start'] = $_REQUEST['start'];
Chris@76: 
Chris@76: 	// Look for people online, provided they don't mind if you see they are.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT
Chris@76: 			lo.log_time, lo.id_member, lo.url, INET_NTOA(lo.ip) AS ip, mem.real_name,
Chris@76: 			lo.session, mg.online_color, IFNULL(mem.show_online, 1) AS show_online,
Chris@76: 			lo.id_spider
Chris@76: 		FROM {db_prefix}log_online AS lo
Chris@76: 			LEFT JOIN {db_prefix}members AS mem ON (lo.id_member = mem.id_member)
Chris@76: 			LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = CASE WHEN mem.id_group = {int:regular_member} THEN mem.id_post_group ELSE mem.id_group END)' . (!empty($conditions) ? '
Chris@76: 		WHERE ' . implode(' AND ', $conditions) : '') . '
Chris@76: 		ORDER BY {raw:sort_method} {raw:sort_direction}
Chris@76: 		LIMIT {int:offset}, {int:limit}',
Chris@76: 		array(
Chris@76: 			'regular_member' => 0,
Chris@76: 			'sort_method' => $sort_method,
Chris@76: 			'sort_direction' => $context['sort_direction'] == 'up' ? 'ASC' : 'DESC',
Chris@76: 			'offset' => $context['start'],
Chris@76: 			'limit' => $modSettings['defaultMaxMembers'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['members'] = array();
Chris@76: 	$member_ids = array();
Chris@76: 	$url_data = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$actions = @unserialize($row['url']);
Chris@76: 		if ($actions === false)
Chris@76: 			continue;
Chris@76: 
Chris@76: 		// Send the information to the template.
Chris@76: 		$context['members'][$row['session']] = array(
Chris@76: 			'id' => $row['id_member'],
Chris@76: 			'ip' => allowedTo('moderate_forum') ? $row['ip'] : '',
Chris@76: 			// It is *going* to be today or yesterday, so why keep that information in there?
Chris@76: 			'time' => strtr(timeformat($row['log_time']), array($txt['today'] => '', $txt['yesterday'] => '')),
Chris@76: 			'timestamp' => forum_time(true, $row['log_time']),
Chris@76: 			'query' => $actions,
Chris@76: 			'is_hidden' => $row['show_online'] == 0,
Chris@76: 			'id_spider' => $row['id_spider'],
Chris@76: 			'color' => empty($row['online_color']) ? '' : $row['online_color']
Chris@76: 		);
Chris@76: 
Chris@76: 		$url_data[$row['session']] = array($row['url'], $row['id_member']);
Chris@76: 		$member_ids[] = $row['id_member'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Load the user data for these members.
Chris@76: 	loadMemberData($member_ids);
Chris@76: 
Chris@76: 	// Load up the guest user.
Chris@76: 	$memberContext[0] = array(
Chris@76: 		'id' => 0,
Chris@76: 		'name' => $txt['guest_title'],
Chris@76: 		'group' => $txt['guest_title'],
Chris@76: 		'href' => '',
Chris@76: 		'link' => $txt['guest_title'],
Chris@76: 		'email' => $txt['guest_title'],
Chris@76: 		'is_guest' => true
Chris@76: 	);
Chris@76: 
Chris@76: 	// Are we showing spiders?
Chris@76: 	$spiderContext = array();
Chris@76: 	if (!empty($modSettings['show_spider_online']) && ($modSettings['show_spider_online'] == 2 || allowedTo('admin_forum')) && !empty($modSettings['spider_name_cache']))
Chris@76: 	{
Chris@76: 		foreach (unserialize($modSettings['spider_name_cache']) as $id => $name)
Chris@76: 			$spiderContext[$id] = array(
Chris@76: 				'id' => 0,
Chris@76: 				'name' => $name,
Chris@76: 				'group' => $txt['spiders'],
Chris@76: 				'href' => '',
Chris@76: 				'link' => $name,
Chris@76: 				'email' => $name,
Chris@76: 				'is_guest' => true
Chris@76: 			);
Chris@76: 	}
Chris@76: 
Chris@76: 	$url_data = determineActions($url_data);
Chris@76: 
Chris@76: 	// Setup the linktree and page title (do it down here because the language files are now loaded..)
Chris@76: 	$context['page_title'] = $txt['who_title'];
Chris@76: 	$context['linktree'][] = array(
Chris@76: 		'url' => $scripturl . '?action=who',
Chris@76: 		'name' => $txt['who_title']
Chris@76: 	);
Chris@76: 
Chris@76: 	// Put it in the context variables.
Chris@76: 	foreach ($context['members'] as $i => $member)
Chris@76: 	{
Chris@76: 		if ($member['id'] != 0)
Chris@76: 			$member['id'] = loadMemberContext($member['id']) ? $member['id'] : 0;
Chris@76: 
Chris@76: 		// Keep the IP that came from the database.
Chris@76: 		$memberContext[$member['id']]['ip'] = $member['ip'];
Chris@76: 		$context['members'][$i]['action'] = isset($url_data[$i]) ? $url_data[$i] : $txt['who_hidden'];
Chris@76: 		if ($member['id'] == 0 && isset($spiderContext[$member['id_spider']]))
Chris@76: 			$context['members'][$i] += $spiderContext[$member['id_spider']];
Chris@76: 		else
Chris@76: 			$context['members'][$i] += $memberContext[$member['id']];
Chris@76: 	}
Chris@76: 
Chris@76: 	// Some people can't send personal messages...
Chris@76: 	$context['can_send_pm'] = allowedTo('pm_send');
Chris@76: 
Chris@76: 	// any profile fields disabled?
Chris@76: 	$context['disabled_fields'] = isset($modSettings['disabled_profile_fields']) ? array_flip(explode(',', $modSettings['disabled_profile_fields'])) : array();
Chris@76: 
Chris@76: }
Chris@76: 
Chris@76: function determineActions($urls, $preferred_prefix = false)
Chris@76: {
Chris@76: 	global $txt, $user_info, $modSettings, $smcFunc, $context;
Chris@76: 
Chris@76: 	if (!allowedTo('who_view'))
Chris@76: 		return array();
Chris@76: 	loadLanguage('Who');
Chris@76: 
Chris@76: 	// Actions that require a specific permission level.
Chris@76: 	$allowedActions = array(
Chris@76: 		'admin' => array('moderate_forum', 'manage_membergroups', 'manage_bans', 'admin_forum', 'manage_permissions', 'send_mail', 'manage_attachments', 'manage_smileys', 'manage_boards', 'edit_news'),
Chris@76: 		'ban' => array('manage_bans'),
Chris@76: 		'boardrecount' => array('admin_forum'),
Chris@76: 		'calendar' => array('calendar_view'),
Chris@76: 		'editnews' => array('edit_news'),
Chris@76: 		'mailing' => array('send_mail'),
Chris@76: 		'maintain' => array('admin_forum'),
Chris@76: 		'manageattachments' => array('manage_attachments'),
Chris@76: 		'manageboards' => array('manage_boards'),
Chris@76: 		'mlist' => array('view_mlist'),
Chris@76: 		'moderate' => array('access_mod_center', 'moderate_forum', 'manage_membergroups'),
Chris@76: 		'optimizetables' => array('admin_forum'),
Chris@76: 		'repairboards' => array('admin_forum'),
Chris@76: 		'search' => array('search_posts'),
Chris@76: 		'search2' => array('search_posts'),
Chris@76: 		'setcensor' => array('moderate_forum'),
Chris@76: 		'setreserve' => array('moderate_forum'),
Chris@76: 		'stats' => array('view_stats'),
Chris@76: 		'viewErrorLog' => array('admin_forum'),
Chris@76: 		'viewmembers' => array('moderate_forum'),
Chris@76: 	);
Chris@76: 
Chris@76: 	if (!is_array($urls))
Chris@76: 		$url_list = array(array($urls, $user_info['id']));
Chris@76: 	else
Chris@76: 		$url_list = $urls;
Chris@76: 
Chris@76: 	// These are done to later query these in large chunks. (instead of one by one.)
Chris@76: 	$topic_ids = array();
Chris@76: 	$profile_ids = array();
Chris@76: 	$board_ids = array();
Chris@76: 
Chris@76: 	$data = array();
Chris@76: 	foreach ($url_list as $k => $url)
Chris@76: 	{
Chris@76: 		// Get the request parameters..
Chris@76: 		$actions = @unserialize($url[0]);
Chris@76: 		if ($actions === false)
Chris@76: 			continue;
Chris@76: 
Chris@76: 		// If it's the admin or moderation center, and there is an area set, use that instead.
Chris@76: 		if (isset($actions['action']) && ($actions['action'] == 'admin' || $actions['action'] == 'moderate') && isset($actions['area']))
Chris@76: 			$actions['action'] = $actions['area'];
Chris@76: 
Chris@76: 		// Check if there was no action or the action is display.
Chris@76: 		if (!isset($actions['action']) || $actions['action'] == 'display')
Chris@76: 		{
Chris@76: 			// It's a topic!  Must be!
Chris@76: 			if (isset($actions['topic']))
Chris@76: 			{
Chris@76: 				// Assume they can't view it, and queue it up for later.
Chris@76: 				$data[$k] = $txt['who_hidden'];
Chris@76: 				$topic_ids[(int) $actions['topic']][$k] = $txt['who_topic'];
Chris@76: 			}
Chris@76: 			// It's a board!
Chris@76: 			elseif (isset($actions['board']))
Chris@76: 			{
Chris@76: 				// Hide first, show later.
Chris@76: 				$data[$k] = $txt['who_hidden'];
Chris@76: 				$board_ids[$actions['board']][$k] = $txt['who_board'];
Chris@76: 			}
Chris@76: 			// It's the board index!!  It must be!
Chris@76: 			else
Chris@76: 				$data[$k] = $txt['who_index'];
Chris@76: 		}
Chris@76: 		// Probably an error or some goon?
Chris@76: 		elseif ($actions['action'] == '')
Chris@76: 			$data[$k] = $txt['who_index'];
Chris@76: 		// Some other normal action...?
Chris@76: 		else
Chris@76: 		{
Chris@76: 			// Viewing/editing a profile.
Chris@76: 			if ($actions['action'] == 'profile')
Chris@76: 			{
Chris@76: 				// Whose?  Their own?
Chris@76: 				if (empty($actions['u']))
Chris@76: 					$actions['u'] = $url[1];
Chris@76: 
Chris@76: 				$data[$k] = $txt['who_hidden'];
Chris@76: 				$profile_ids[(int) $actions['u']][$k] = $actions['action'] == 'profile' ? $txt['who_viewprofile'] : $txt['who_profile'];
Chris@76: 			}
Chris@76: 			elseif (($actions['action'] == 'post' || $actions['action'] == 'post2') && empty($actions['topic']) && isset($actions['board']))
Chris@76: 			{
Chris@76: 				$data[$k] = $txt['who_hidden'];
Chris@76: 				$board_ids[(int) $actions['board']][$k] = isset($actions['poll']) ? $txt['who_poll'] : $txt['who_post'];
Chris@76: 			}
Chris@76: 			// A subaction anyone can view... if the language string is there, show it.
Chris@76: 			elseif (isset($actions['sa']) && isset($txt['whoall_' . $actions['action'] . '_' . $actions['sa']]))
Chris@76: 				$data[$k] = $preferred_prefix && isset($txt[$preferred_prefix . $actions['action'] . '_' . $actions['sa']]) ? $txt[$preferred_prefix . $actions['action'] . '_' . $actions['sa']] : $txt['whoall_' . $actions['action'] . '_' . $actions['sa']];
Chris@76: 			// An action any old fellow can look at. (if ['whoall_' . $action] exists, we know everyone can see it.)
Chris@76: 			elseif (isset($txt['whoall_' . $actions['action']]))
Chris@76: 				$data[$k] = $preferred_prefix && isset($txt[$preferred_prefix . $actions['action']]) ? $txt[$preferred_prefix . $actions['action']] : $txt['whoall_' . $actions['action']];
Chris@76: 			// Viewable if and only if they can see the board...
Chris@76: 			elseif (isset($txt['whotopic_' . $actions['action']]))
Chris@76: 			{
Chris@76: 				// Find out what topic they are accessing.
Chris@76: 				$topic = (int) (isset($actions['topic']) ? $actions['topic'] : (isset($actions['from']) ? $actions['from'] : 0));
Chris@76: 
Chris@76: 				$data[$k] = $txt['who_hidden'];
Chris@76: 				$topic_ids[$topic][$k] = $txt['whotopic_' . $actions['action']];
Chris@76: 			}
Chris@76: 			elseif (isset($txt['whopost_' . $actions['action']]))
Chris@76: 			{
Chris@76: 				// Find out what message they are accessing.
Chris@76: 				$msgid = (int) (isset($actions['msg']) ? $actions['msg'] : (isset($actions['quote']) ? $actions['quote'] : 0));
Chris@76: 
Chris@76: 				$result = $smcFunc['db_query']('', '
Chris@76: 					SELECT m.id_topic, m.subject
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: 						INNER JOIN {db_prefix}topics AS t ON (t.id_topic = m.id_topic' . ($modSettings['postmod_active'] ? ' AND t.approved = {int:is_approved}' : '') . ')
Chris@76: 					WHERE m.id_msg = {int:id_msg}
Chris@76: 						AND {query_see_board}' . ($modSettings['postmod_active'] ? '
Chris@76: 						AND m.approved = {int:is_approved}' : '') . '
Chris@76: 					LIMIT 1',
Chris@76: 					array(
Chris@76: 						'is_approved' => 1,
Chris@76: 						'id_msg' => $msgid,
Chris@76: 					)
Chris@76: 				);
Chris@76: 				list ($id_topic, $subject) = $smcFunc['db_fetch_row']($result);
Chris@76: 				$data[$k] = sprintf($txt['whopost_' . $actions['action']], $id_topic, $subject);
Chris@76: 				$smcFunc['db_free_result']($result);
Chris@76: 
Chris@76: 				if (empty($id_topic))
Chris@76: 					$data[$k] = $txt['who_hidden'];
Chris@76: 			}
Chris@76: 			// Viewable only by administrators.. (if it starts with whoadmin, it's admin only!)
Chris@76: 			elseif (allowedTo('moderate_forum') && isset($txt['whoadmin_' . $actions['action']]))
Chris@76: 				$data[$k] = $txt['whoadmin_' . $actions['action']];
Chris@76: 			// Viewable by permission level.
Chris@76: 			elseif (isset($allowedActions[$actions['action']]))
Chris@76: 			{
Chris@76: 				if (allowedTo($allowedActions[$actions['action']]))
Chris@76: 					$data[$k] = $txt['whoallow_' . $actions['action']];
Chris@76: 				else
Chris@76: 					$data[$k] = $txt['who_hidden'];
Chris@76: 			}
Chris@76: 			// Unlisted or unknown action.
Chris@76: 			else
Chris@76: 				$data[$k] = $txt['who_unknown'];
Chris@76: 		}
Chris@76: 
Chris@76: 		// Maybe the action is integrated into another system?
Chris@76: 		if (count($integrate_actions = call_integration_hook('integrate_whos_online', array($actions))) > 0)
Chris@76: 		{
Chris@76: 			foreach ($integrate_actions as $integrate_action)
Chris@76: 			{
Chris@76: 				if (!empty($integrate_action))
Chris@76: 				{
Chris@76: 					$data[$k] = $integrate_action;
Chris@76: 					break;
Chris@76: 				}
Chris@76: 			}
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Load topic names.
Chris@76: 	if (!empty($topic_ids))
Chris@76: 	{
Chris@76: 		$result = $smcFunc['db_query']('', '
Chris@76: 			SELECT t.id_topic, m.subject
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: 				INNER JOIN {db_prefix}messages AS m ON (m.id_msg = t.id_first_msg)
Chris@76: 			WHERE {query_see_board}
Chris@76: 				AND t.id_topic IN ({array_int:topic_list})' . ($modSettings['postmod_active'] ? '
Chris@76: 				AND t.approved = {int:is_approved}' : '') . '
Chris@76: 			LIMIT {int:limit}',
Chris@76: 			array(
Chris@76: 				'topic_list' => array_keys($topic_ids),
Chris@76: 				'is_approved' => 1,
Chris@76: 				'limit' => count($topic_ids),
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 		{
Chris@76: 			// Show the topic's subject for each of the actions.
Chris@76: 			foreach ($topic_ids[$row['id_topic']] as $k => $session_text)
Chris@76: 				$data[$k] = sprintf($session_text, $row['id_topic'], censorText($row['subject']));
Chris@76: 		}
Chris@76: 		$smcFunc['db_free_result']($result);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Load board names.
Chris@76: 	if (!empty($board_ids))
Chris@76: 	{
Chris@76: 		$result = $smcFunc['db_query']('', '
Chris@76: 			SELECT b.id_board, b.name
Chris@76: 			FROM {db_prefix}boards AS b
Chris@76: 			WHERE {query_see_board}
Chris@76: 				AND b.id_board IN ({array_int:board_list})
Chris@76: 			LIMIT ' . count($board_ids),
Chris@76: 			array(
Chris@76: 				'board_list' => array_keys($board_ids),
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 		{
Chris@76: 			// Put the board name into the string for each member...
Chris@76: 			foreach ($board_ids[$row['id_board']] as $k => $session_text)
Chris@76: 				$data[$k] = sprintf($session_text, $row['id_board'], $row['name']);
Chris@76: 		}
Chris@76: 		$smcFunc['db_free_result']($result);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Load member names for the profile.
Chris@76: 	if (!empty($profile_ids) && (allowedTo('profile_view_any') || allowedTo('profile_view_own')))
Chris@76: 	{
Chris@76: 		$result = $smcFunc['db_query']('', '
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: 			LIMIT ' . count($profile_ids),
Chris@76: 			array(
Chris@76: 				'member_list' => array_keys($profile_ids),
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($result))
Chris@76: 		{
Chris@76: 			// If they aren't allowed to view this person's profile, skip it.
Chris@76: 			if (!allowedTo('profile_view_any') && $user_info['id'] != $row['id_member'])
Chris@76: 				continue;
Chris@76: 
Chris@76: 			// Set their action on each - session/text to sprintf.
Chris@76: 			foreach ($profile_ids[$row['id_member']] as $k => $session_text)
Chris@76: 				$data[$k] = sprintf($session_text, $row['id_member'], $row['real_name']);
Chris@76: 		}
Chris@76: 		$smcFunc['db_free_result']($result);
Chris@76: 	}
Chris@76: 
Chris@76: 	if (!is_array($urls))
Chris@76: 		return isset($data[0]) ? $data[0] : false;
Chris@76: 	else
Chris@76: 		return $data;
Chris@76: }
Chris@76: 
Chris@76: function Credits($in_admin = false)
Chris@76: {
Chris@76: 	global $context, $modSettings, $forum_copyright, $forum_version, $boardurl, $txt, $user_info;
Chris@76: 
Chris@76: 	// Don't blink. Don't even blink. Blink and you're dead.
Chris@76: 	loadLanguage('Who');
Chris@76: 
Chris@76: 	$context['credits'] = array(
Chris@76: 		array(
Chris@76: 			'pretext' => $txt['credits_intro'],
Chris@76: 			'title' => $txt['credits_team'],
Chris@76: 			'groups' => array(
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_ps'],
Chris@76: 					'members' => array(
Chris@76: 						'Michael &quot;Oldiesmann&quot; Eshom',
Chris@76: 						'Amacythe',
Chris@76: 						'Jeremy &quot;SleePy&quot; Darwood',
Chris@76: 						'Justin &quot;metallica48423&quot; O\'Leary',
Chris@76: 					),
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_dev'],
Chris@76: 					'members' => array(
Chris@76: 						'Norv',
Chris@76: 						'Aaron van Geffen',
Chris@76: 						'Antechinus',
Chris@76: 						'Bjoern &quot;Bloc&quot; Kristiansen',
Chris@76: 						'Hendrik Jan &quot;Compuart&quot; Visser',
Chris@76: 						'Juan &quot;JayBachatero&quot; Hernandez',
Chris@76: 						'Karl &quot;RegularExpression&quot; Benson',
Chris@76: 						$user_info['is_admin'] ? 'Matt &quot;Grudge&quot; Wolf': 'Grudge',
Chris@76: 						'Michael &quot;Thantos&quot; Miller',
Chris@76: 						'Selman &quot;[SiNaN]&quot; Eser',
Chris@76: 						'Theodore &quot;Orstio&quot; Hildebrandt',
Chris@76: 						'Thorsten &quot;TE&quot; Eurich',
Chris@76: 						'winrules',
Chris@76: 					),
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_support'],
Chris@76: 					'members' => array(
Chris@76: 						'JimM',
Chris@76: 						'Adish &quot;(F.L.A.M.E.R)&quot; Patel',
Chris@76: 						'Aleksi &quot;Lex&quot; Kilpinen',
Chris@76: 						'Ben Scott',
Chris@76: 						'Bigguy',
Chris@76: 						'CapadY',
Chris@76: 						'Chas Large',
Chris@76: 						'Duncan85',
Chris@76: 						'Eliana Tamerin',
Chris@76: 						'Fiery',
Chris@76: 						'gbsothere',
Chris@76: 						'Harro',
Chris@76: 						'Huw',
Chris@76: 						'Jan-Olof &quot;Owdy&quot; Eriksson',
Chris@76: 						'Jeremy &quot;jerm&quot; Strike',
Chris@76: 						'Jessica &quot;Miss All Sunday&quot; Gonzales',
Chris@76: 						'K@',
Chris@76: 						'Kevin &quot;greyknight17&quot; Hou',
Chris@76: 						'KGIII',
Chris@76: 						'Kill Em All',
Chris@76: 						'Mattitude',
Chris@76: 						'Mashby',
Chris@76: 						'Mick G.',
Chris@76: 						'Michele &quot;Illori&quot; Davis',
Chris@76: 						'MrPhil',
Chris@76: 						'Nick &quot;Fizzy&quot; Dyer',
Chris@76: 						'Nick &quot;Ha&sup2;&quot;',
Chris@76: 						'Paul_Pauline',
Chris@76: 						'Piro &quot;Sarge&quot; Dhima',
Chris@76: 						'Rumbaar',
Chris@76: 						'Pitti',
Chris@76: 						'RedOne',
Chris@76: 						'S-Ace',
Chris@76: 						'Wade &quot;s&eta;&sigma;&omega;&quot; Poulsen',
Chris@76: 						'xenovanis',
Chris@76: 					),
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_customize'],
Chris@76: 					'members' => array(
Chris@76: 						'Brad &quot;IchBin&trade;&quot; Grow',
Chris@76: 						'&#12487;&#12451;&#12531;1031',
Chris@76: 						'Brannon &quot;B&quot; Hall',
Chris@76: 						'Bryan &quot;Runic&quot; Deakin',
Chris@76: 						'Bulakbol',
Chris@76: 						'Colin &quot;Shadow82x&quot; Blaber',
Chris@76: 						'Daniel15',
Chris@76: 						'Eren Yasarkurt',
Chris@76: 						'Gary M. Gadsdon',
Chris@76: 						'Jason &quot;JBlaze&quot; Clemons',
Chris@76: 						'Jerry',
Chris@76: 						'Jonathan &quot;vbgamer45&quot; Valentin',
Chris@76: 						'Kays',
Chris@76: 						'Killer Possum',
Chris@76: 						'Kirby',
Chris@76: 						'Matt &quot;SlammedDime&quot; Zuba',
Chris@76: 						'Matthew &quot;Labradoodle-360&quot; Kerle',
Chris@76: 						'Nibogo',
Chris@76: 						'Niko',
Chris@76: 						'Peter &quot;Arantor&quot; Spicer',
Chris@76: 						'snork13',
Chris@76: 						'Spuds',
Chris@76: 						'Steven &quot;Fustrate&quot; Hoffman',
Chris@76: 						'Joey &quot;Tyrsson&quot; Smith',
Chris@76: 					),
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_docs'],
Chris@76: 					'members' => array(
Chris@76: 						'Joshua &quot;groundup&quot; Dickerson',
Chris@76: 						'AngellinaBelle',
Chris@76: 						'Daniel Diehl',
Chris@76: 						'Dannii Willis',
Chris@76: 						'emanuele',
Chris@76: 						'Graeme Spence',
Chris@76: 						'Jack &quot;akabugeyes&quot; Thorsen',
Chris@76: 						'Jade Elizabeth Trainor',
Chris@76: 						'Peter Duggan',
Chris@76: 					),
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_marketing'],
Chris@76: 					'members' => array(
Chris@76: 						'Kindred',
Chris@76: 						'Marcus &quot;c&sigma;&sigma;&#1082;&iota;&#1108; &#1084;&sigma;&eta;&#1109;&#1090;&#1108;&#1103;&quot; Forsberg',
Chris@76: 						'Ralph &quot;[n3rve]&quot; Otowo',
Chris@76: 						'rickC',
Chris@76: 						'Tony Reid',
Chris@76: 					),
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_internationalizers'],
Chris@76: 					'members' => array(
Chris@76: 						'Relyana',
Chris@76: 						'Akyhne',
Chris@76: 						'GravuTrad',
Chris@76: 					),
Chris@76: 				),
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_servers'],
Chris@76: 					'members' => array(
Chris@76: 						'Derek Schwab',
Chris@76: 						'Liroy &quot;CoreISP&quot; van Hoewijk',
Chris@76: 					),
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Give the translators some credit for their hard work.
Chris@76: 	if (!empty($txt['translation_credits']))
Chris@76: 		$context['credits'][] = array(
Chris@76: 			'title' => $txt['credits_groups_translation'],
Chris@76: 			'groups' => array(
Chris@76: 				array(
Chris@76: 					'title' => $txt['credits_groups_translation'],
Chris@76: 					'members' => $txt['translation_credits'],
Chris@76: 				),
Chris@76: 			),
Chris@76: 		);
Chris@76: 
Chris@76: 	$context['credits'][] = array(
Chris@76: 		'title' => $txt['credits_special'],
Chris@76: 		'posttext' => $txt['credits_anyone'],
Chris@76: 		'groups' => array(
Chris@76: 			array(
Chris@76: 				'title' => $txt['credits_groups_consultants'],
Chris@76: 				'members' => array(
Chris@76: 					'Brett Flannigan',
Chris@76: 					'Mark Rose',
Chris@76: 					'Ren&eacute;-Gilles &quot;Nao &#23578;&quot; Deberdt',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			array(
Chris@76: 				'title' => $txt['credits_groups_beta'],
Chris@76: 				'members' => array(
Chris@76: 					$txt['credits_beta_message'],
Chris@76: 				),
Chris@76: 			),
Chris@76: 			array(
Chris@76: 				'title' => $txt['credits_groups_translators'],
Chris@76: 				'members' => array(
Chris@76: 					$txt['credits_translators_message'],
Chris@76: 				),
Chris@76: 			),
Chris@76: 			array(
Chris@76: 				'title' => $txt['credits_groups_founder'],
Chris@76: 				'members' => array(
Chris@76: 					'Unknown W. &quot;[Unknown]&quot; Brackets',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			array(
Chris@76: 				'title' => $txt['credits_groups_orignal_pm'],
Chris@76: 				'members' => array(
Chris@76: 					'Jeff Lewis',
Chris@76: 					'Joseph Fung',
Chris@76: 					'David Recordon',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	$context['copyrights'] = array(
Chris@76: 		'smf' => sprintf($forum_copyright, $forum_version),
Chris@76: 
Chris@76: 		/* Modification Authors:  You may add a copyright statement to this array for your mods.
Chris@76: 			Copyright statements should be in the form of a value only without a array key.  I.E.:
Chris@76: 				'Some Mod by Thantos &copy; 2010',
Chris@76: 				$txt['some_mod_copyright'],
Chris@76: 		*/
Chris@76: 		'mods' => array(
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	if (!$in_admin)
Chris@76: 	{
Chris@76: 		loadTemplate('Who');
Chris@76: 		$context['sub_template'] = 'credits';
Chris@76: 		$context['robot_no_index'] = true;
Chris@76: 		$context['page_title'] = $txt['credits'];
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: ?>