Chris@76: <?php
Chris@76: 
Chris@76: /**
Chris@76:  * Simple Machines Forum (SMF)
Chris@76:  *
Chris@76:  * @package SMF
Chris@76:  * @author Simple Machines http://www.simplemachines.org
Chris@76:  * @copyright 2011 Simple Machines
Chris@76:  * @license http://www.simplemachines.org/about/smf/license.php BSD
Chris@76:  *
Chris@76:  * @version 2.0
Chris@76:  */
Chris@76: 
Chris@76: if (!defined('SMF'))
Chris@76: 	die('Hacking attempt...');
Chris@76: 
Chris@76: /*	This file is exclusively for generating reports to help assist forum
Chris@76: 	administrators keep track of their forum configuration and state. The
Chris@76: 	core report generation is done in two areas. Firstly, a report "generator"
Chris@76: 	will fill context with relevant data. Secondly, the choice of sub-template
Chris@76: 	will determine how this data is shown to the user. It has the following
Chris@76: 	functions:
Chris@76: 
Chris@76: 	void ReportsMain()
Chris@76: 		- requires the admin_forum permission.
Chris@76: 		- loads the Reports template and language files.
Chris@76: 		- decides which type of report to generate, if this isn't passed
Chris@76: 		  through the querystring it will set the report_type sub-template to
Chris@76: 		  force the user to choose which type.
Chris@76: 		- when generating a report chooses which sub_template to use.
Chris@76: 		- depends on the cal_enabled setting, and many of the other cal_
Chris@76: 		  settings.
Chris@76: 		- will call the relevant report generation function.
Chris@76: 		- if generating report will call finishTables before returning.
Chris@76: 		- accessed through ?action=admin;area=reports.
Chris@76: 
Chris@76: 	void xxxxxxReport()
Chris@76: 		- functions ending with "Report" are responsible for generating data
Chris@76: 		  for reporting.
Chris@76: 		- they are all called from ReportsMain.
Chris@76: 		- never access the context directly, but use the data handling
Chris@76: 		  functions to do so.
Chris@76: 
Chris@76: 	void newTable(string title = '', string default_value = '',
Chris@76: 			string shading = 'all', string width_normal = 'auto',
Chris@76: 			string align_normal = 'center', string width_shaded = 'auto',
Chris@76: 			string align_shaded = 'auto')
Chris@76: 		- the core of this file, it creates a new, but empty, table of data in
Chris@76: 		  context, ready for filling using addData().
Chris@76: 		- takes a lot of possible attributes, these have the following effect:
Chris@76: 			+ title = Title to be displayed with this data table.
Chris@76: 			+ default_value = Value to be displayed if a key is missing from a
Chris@76: 			  row.
Chris@76: 			+ shading = Should the left, top or both (all) parts of the table
Chris@76: 			  beshaded?
Chris@76: 			+ width_normal = width of an unshaded column (auto means not
Chris@76: 			  defined).
Chris@76: 			+ align_normal = alignment of data in an unshaded column.
Chris@76: 			+ width_shaded = width of a shaded column (auto means not
Chris@76: 			  defined).
Chris@76: 			+ align_shaded = alignment of data in a shaded column.
Chris@76: 		- fills the context variable current_table with the ID of the table
Chris@76: 		  created.
Chris@76: 		- keeps track of the current table count using context variable
Chris@76: 		  table_count.
Chris@76: 
Chris@76: 	void addData(array inc_data, int custom_table = null)
Chris@76: 		- adds an array of data into an existing table.
Chris@76: 		- if there are no existing tables, will create one with default
Chris@76: 		  attributes.
Chris@76: 		- if custom_table isn't specified, it will use the last table created,
Chris@76: 		  if it is specified and doesn't exist the function will return false.
Chris@76: 		- if a set of keys have been specified, the function will check each
Chris@76: 		  required key is present in the incoming data. If this data is missing
Chris@76: 		  the current tables default value will be used.
Chris@76: 		- if any key in the incoming data begins with '#sep#', the function
Chris@76: 		  will add a separator accross the table at this point.
Chris@76: 		- once the incoming data has been sanitized, it is added to the table.
Chris@76: 
Chris@76: 	void addSeparator(string title = '', int custom_table = null)
Chris@76: 		- adds a separator with title given by attribute "title" after the
Chris@76: 		  current row in the table.
Chris@76: 		- if there are no existing tables, will create one with default
Chris@76: 		  attributes.
Chris@76: 		- if custom_table isn't specified, it will use the last table created,
Chris@76: 		  if it is specified and doesn't exist the function will return false.
Chris@76: 		- if the table is currently having data added by column this may have
Chris@76: 		  unpredictable visual results.
Chris@76: 
Chris@76: 	void finishTables()
Chris@76: 		- is (unfortunately) required to create some useful variables for
Chris@76: 		  templates.
Chris@76: 		- foreach data table created, it will count the number of rows and
Chris@76: 		  columns in the table.
Chris@76: 		- will also create a max_width variable for the table, to give an
Chris@76: 		  estimate width for the whole table - if it can.
Chris@76: 
Chris@76: 	void setKeys(string method = 'rows', array keys = array(),
Chris@76: 			bool reverse = false)
Chris@76: 		- sets the current set of "keys" expected in each data array passed to
Chris@76: 		  addData. It also sets the way we are adding data to the data table.
Chris@76: 		- method specifies whether the data passed to addData represents a new
Chris@76: 		  column, or a new row.
Chris@76: 		- keys is an array whose keys are the keys for data being passed to
Chris@76: 		  addData().
Chris@76: 		- if reverse is set to true, then the values of the variable "keys"
Chris@76: 		  are used as oppossed to the keys(!)
Chris@76: */
Chris@76: 
Chris@76: // Handling function for generating reports.
Chris@76: function ReportsMain()
Chris@76: {
Chris@76: 	global $txt, $modSettings, $context, $scripturl;
Chris@76: 
Chris@76: 	// Only admins, only EVER admins!
Chris@76: 	isAllowedTo('admin_forum');
Chris@76: 
Chris@76: 	// Let's get our things running...
Chris@76: 	loadTemplate('Reports');
Chris@76: 	loadLanguage('Reports');
Chris@76: 
Chris@76: 	$context['page_title'] = $txt['generate_reports'];
Chris@76: 
Chris@76: 	// These are the types of reports which exist - and the functions to generate them.
Chris@76: 	$context['report_types'] = array(
Chris@76: 		'boards' => 'BoardReport',
Chris@76: 		'board_perms' => 'BoardPermissionsReport',
Chris@76: 		'member_groups' => 'MemberGroupsReport',
Chris@76: 		'group_perms' => 'GroupPermissionsReport',
Chris@76: 		'staff' => 'StaffReport',
Chris@76: 	);
Chris@76: 
Chris@76: 	$is_first = 0;
Chris@76: 	foreach ($context['report_types'] as $k => $temp)
Chris@76: 		$context['report_types'][$k] = array(
Chris@76: 			'id' => $k,
Chris@76: 			'title' => isset($txt['gr_type_' . $k]) ? $txt['gr_type_' . $k] : $type['id'],
Chris@76: 			'description' => isset($txt['gr_type_desc_' . $k]) ? $txt['gr_type_desc_' . $k] : null,
Chris@76: 			'function' => $temp,
Chris@76: 			'is_first' => $is_first++ == 0,
Chris@76: 		);
Chris@76: 
Chris@76: 	// If they haven't choosen a report type which is valid, send them off to the report type chooser!
Chris@76: 	if (empty($_REQUEST['rt']) || !isset($context['report_types'][$_REQUEST['rt']]))
Chris@76: 	{
Chris@76: 		$context['sub_template'] = 'report_type';
Chris@76: 		return;
Chris@76: 	}
Chris@76: 	$context['report_type'] = $_REQUEST['rt'];
Chris@76: 
Chris@76: 	// What are valid templates for showing reports?
Chris@76: 	$reportTemplates = array(
Chris@76: 		'main' => array(
Chris@76: 			'layers' => null,
Chris@76: 		),
Chris@76: 		'print' => array(
Chris@76: 			'layers' => array('print'),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Specific template? Use that instead of main!
Chris@76: 	if (isset($_REQUEST['st']) && isset($reportTemplates[$_REQUEST['st']]))
Chris@76: 	{
Chris@76: 		$context['sub_template'] = $_REQUEST['st'];
Chris@76: 
Chris@76: 		// Are we disabling the other layers - print friendly for example?
Chris@76: 		if ($reportTemplates[$_REQUEST['st']]['layers'] !== null)
Chris@76: 			$context['template_layers'] = $reportTemplates[$_REQUEST['st']]['layers'];
Chris@76: 	}
Chris@76: 
Chris@76: 	// Make the page title more descriptive.
Chris@76: 	$context['page_title'] .= ' - ' . (isset($txt['gr_type_' . $context['report_type']]) ? $txt['gr_type_' . $context['report_type']] : $context['report_type']);
Chris@76: 	// Now generate the data.
Chris@76: 	$context['report_types'][$context['report_type']]['function']();
Chris@76: 
Chris@76: 	// Finish the tables before exiting - this is to help the templates a little more.
Chris@76: 	finishTables();
Chris@76: }
Chris@76: 
Chris@76: // Standard report about what settings the boards have.
Chris@76: function BoardReport()
Chris@76: {
Chris@76: 	global $context, $txt, $sourcedir, $smcFunc;
Chris@76: 
Chris@76: 	// Load the permission profiles.
Chris@76: 	require_once($sourcedir . '/ManagePermissions.php');
Chris@76: 	loadLanguage('ManagePermissions');
Chris@76: 	loadPermissionProfiles();
Chris@76: 
Chris@76: 	// Get every moderator.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT mods.id_board, mods.id_member, mem.real_name
Chris@76: 		FROM {db_prefix}moderators AS mods
Chris@76: 			INNER JOIN {db_prefix}members AS mem ON (mem.id_member = mods.id_member)',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$moderators = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$moderators[$row['id_board']][] = $row['real_name'];
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Get all the possible membergroups!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_group, group_name, online_color
Chris@76: 		FROM {db_prefix}membergroups',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$groups = array(-1 => $txt['guest_title'], 0 => $txt['full_member']);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$groups[$row['id_group']] = empty($row['online_color']) ? $row['group_name'] : '<span style="color: ' . $row['online_color'] . '">' . $row['group_name'] . '</span>';
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// All the fields we'll show.
Chris@76: 	$boardSettings = array(
Chris@76: 		'category' => $txt['board_category'],
Chris@76: 		'parent' => $txt['board_parent'],
Chris@76: 		'num_topics' => $txt['board_num_topics'],
Chris@76: 		'num_posts' => $txt['board_num_posts'],
Chris@76: 		'count_posts' => $txt['board_count_posts'],
Chris@76: 		'theme' => $txt['board_theme'],
Chris@76: 		'override_theme' => $txt['board_override_theme'],
Chris@76: 		'profile' => $txt['board_profile'],
Chris@76: 		'moderators' => $txt['board_moderators'],
Chris@76: 		'groups' => $txt['board_groups'],
Chris@76: 	);
Chris@76: 
Chris@76: 	// Do it in columns, it's just easier.
Chris@76: 	setKeys('cols');
Chris@76: 
Chris@76: 	// Go through each board!
Chris@76: 	$request = $smcFunc['db_query']('order_by_board_order', '
Chris@76: 		SELECT b.id_board, b.name, b.num_posts, b.num_topics, b.count_posts, b.member_groups, b.override_theme, b.id_profile,
Chris@76: 			c.name AS cat_name, IFNULL(par.name, {string:text_none}) AS parent_name, IFNULL(th.value, {string:text_none}) AS theme_name
Chris@76: 		FROM {db_prefix}boards AS b
Chris@76: 			LEFT JOIN {db_prefix}categories AS c ON (c.id_cat = b.id_cat)
Chris@76: 			LEFT JOIN {db_prefix}boards AS par ON (par.id_board = b.id_parent)
Chris@76: 			LEFT JOIN {db_prefix}themes AS th ON (th.id_theme = b.id_theme AND th.variable = {string:name})',
Chris@76: 		array(
Chris@76: 			'name' => 'name',
Chris@76: 			'text_none' => $txt['none'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$boards = array(0 => array('name' => $txt['global_boards']));
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// Each board has it's own table.
Chris@76: 		newTable($row['name'], '', 'left', 'auto', 'left', 200, 'left');
Chris@76: 
Chris@76: 		// First off, add in the side key.
Chris@76: 		addData($boardSettings);
Chris@76: 
Chris@76: 		// Format the profile name.
Chris@76: 		$profile_name = $context['profiles'][$row['id_profile']]['name'];
Chris@76: 
Chris@76: 		// Create the main data array.
Chris@76: 		$boardData = array(
Chris@76: 			'category' => $row['cat_name'],
Chris@76: 			'parent' => $row['parent_name'],
Chris@76: 			'num_posts' => $row['num_posts'],
Chris@76: 			'num_topics' => $row['num_topics'],
Chris@76: 			'count_posts' => empty($row['count_posts']) ? $txt['yes'] : $txt['no'],
Chris@76: 			'theme' => $row['theme_name'],
Chris@76: 			'profile' => $profile_name,
Chris@76: 			'override_theme' => $row['override_theme'] ? $txt['yes'] : $txt['no'],
Chris@76: 			'moderators' => empty($moderators[$row['id_board']]) ? $txt['none'] : implode(', ', $moderators[$row['id_board']]),
Chris@76: 		);
Chris@76: 
Chris@76: 		// Work out the membergroups who can access it.
Chris@76: 		$allowedGroups = explode(',', $row['member_groups']);
Chris@76: 		foreach ($allowedGroups as $key => $group)
Chris@76: 		{
Chris@76: 			if (isset($groups[$group]))
Chris@76: 				$allowedGroups[$key] = $groups[$group];
Chris@76: 			else
Chris@76: 				unset($allowedGroups[$key]);
Chris@76: 		}
Chris@76: 		$boardData['groups'] = implode(', ', $allowedGroups);
Chris@76: 
Chris@76: 		// Next add the main data.
Chris@76: 		addData($boardData);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: }
Chris@76: 
Chris@76: // Generate a report on the current permissions by board and membergroup.
Chris@76: function BoardPermissionsReport()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $smcFunc;
Chris@76: 
Chris@76: 	// Get as much memory as possible as this can be big.
Chris@76: 	@ini_set('memory_limit', '256M');
Chris@76: 
Chris@76: 	if (isset($_REQUEST['boards']))
Chris@76: 	{
Chris@76: 		if (!is_array($_REQUEST['boards']))
Chris@76: 			$_REQUEST['boards'] = explode(',', $_REQUEST['boards']);
Chris@76: 		foreach ($_REQUEST['boards'] as $k => $dummy)
Chris@76: 			$_REQUEST['boards'][$k] = (int) $dummy;
Chris@76: 
Chris@76: 		$board_clause = 'id_board IN ({array_int:boards})';
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$board_clause = '1=1';
Chris@76: 
Chris@76: 	if (isset($_REQUEST['groups']))
Chris@76: 	{
Chris@76: 		if (!is_array($_REQUEST['groups']))
Chris@76: 			$_REQUEST['groups'] = explode(',', $_REQUEST['groups']);
Chris@76: 		foreach ($_REQUEST['groups'] as $k => $dummy)
Chris@76: 			$_REQUEST['groups'][$k] = (int) $dummy;
Chris@76: 
Chris@76: 		$group_clause = 'id_group IN ({array_int:groups})';
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$group_clause = '1=1';
Chris@76: 
Chris@76: 	// Fetch all the board names.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_board, name, id_profile
Chris@76: 		FROM {db_prefix}boards
Chris@76: 		WHERE ' . $board_clause . '
Chris@76: 		ORDER BY id_board',
Chris@76: 		array(
Chris@76: 			'boards' => isset($_REQUEST['boards']) ? $_REQUEST['boards'] : array(),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$profiles = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$boards[$row['id_board']] = array(
Chris@76: 			'name' => $row['name'],
Chris@76: 			'profile' => $row['id_profile'],
Chris@76: 		);
Chris@76: 		$profiles[] = $row['id_profile'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Get all the possible membergroups, except admin!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_group, group_name
Chris@76: 		FROM {db_prefix}membergroups
Chris@76: 		WHERE ' . $group_clause . '
Chris@76: 			AND id_group != {int:admin_group}' . (empty($modSettings['permission_enable_postgroups']) ? '
Chris@76: 			AND min_posts = {int:min_posts}' : '') . '
Chris@76: 		ORDER BY min_posts, CASE WHEN id_group < {int:newbie_group} THEN id_group ELSE 4 END, group_name',
Chris@76: 		array(
Chris@76: 			'admin_group' => 1,
Chris@76: 			'min_posts' => -1,
Chris@76: 			'newbie_group' => 4,
Chris@76: 			'groups' => isset($_REQUEST['groups']) ? $_REQUEST['groups'] : array(),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	if (!isset($_REQUEST['groups']) || in_array(-1, $_REQUEST['groups']) || in_array(0, $_REQUEST['groups']))
Chris@76: 		$member_groups = array('col' => '', -1 => $txt['membergroups_guests'], 0 => $txt['membergroups_members']);
Chris@76: 	else
Chris@76: 		$member_groups = array('col' => '');
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$member_groups[$row['id_group']] = $row['group_name'];
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Make sure that every group is represented - plus in rows!
Chris@76: 	setKeys('rows', $member_groups);
Chris@76: 
Chris@76: 	// Cache every permission setting, to make sure we don't miss any allows.
Chris@76: 	$permissions = array();
Chris@76: 	$board_permissions = array();
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_profile, id_group, add_deny, permission
Chris@76: 		FROM {db_prefix}board_permissions
Chris@76: 		WHERE id_profile IN ({array_int:profile_list})
Chris@76: 			AND ' . $group_clause . (empty($modSettings['permission_enable_deny']) ? '
Chris@76: 			AND add_deny = {int:not_deny}' : '') . '
Chris@76: 		ORDER BY id_profile, permission',
Chris@76: 		array(
Chris@76: 			'profile_list' => $profiles,
Chris@76: 			'not_deny' => 1,
Chris@76: 			'groups' => isset($_REQUEST['groups']) ? $_REQUEST['groups'] : array(),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		foreach ($boards as $id => $board)
Chris@76: 			if ($board['profile'] == $row['id_profile'])
Chris@76: 				$board_permissions[$id][$row['id_group']][$row['permission']] = $row['add_deny'];
Chris@76: 
Chris@76: 		// Make sure we get every permission.
Chris@76: 		if (!isset($permissions[$row['permission']]))
Chris@76: 		{
Chris@76: 			// This will be reused on other boards.
Chris@76: 			$permissions[$row['permission']] = array(
Chris@76: 				'title' => isset($txt['board_perms_name_' . $row['permission']]) ? $txt['board_perms_name_' . $row['permission']] : $row['permission'],
Chris@76: 			);
Chris@76: 		}
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Now cycle through the board permissions array... lots to do ;)
Chris@76: 	foreach ($board_permissions as $board => $groups)
Chris@76: 	{
Chris@76: 		// Create the table for this board first.
Chris@76: 		newTable($boards[$board]['name'], 'x', 'all', 100, 'center', 200, 'left');
Chris@76: 
Chris@76: 		// Add the header row - shows all the membergroups.
Chris@76: 		addData($member_groups);
Chris@76: 
Chris@76: 		// Add the separator.
Chris@76: 		addSeparator($txt['board_perms_permission']);
Chris@76: 
Chris@76: 		// Here cycle through all the detected permissions.
Chris@76: 		foreach ($permissions as $ID_PERM => $perm_info)
Chris@76: 		{
Chris@76: 			// Is this identical to the global?
Chris@76: 			$identicalGlobal = $board == 0 ? false : true;
Chris@76: 
Chris@76: 			// Default data for this row.
Chris@76: 			$curData = array('col' => $perm_info['title']);
Chris@76: 
Chris@76: 			// Now cycle each membergroup in this set of permissions.
Chris@76: 			foreach ($member_groups as $id_group => $name)
Chris@76: 			{
Chris@76: 				// Don't overwrite the key column!
Chris@76: 				if ($id_group === 'col')
Chris@76: 					continue;
Chris@76: 
Chris@76: 				$group_permissions = isset($groups[$id_group]) ? $groups[$id_group] : array();
Chris@76: 
Chris@76: 				// Do we have any data for this group?
Chris@76: 				if (isset($group_permissions[$ID_PERM]))
Chris@76: 				{
Chris@76: 					// Set the data for this group to be the local permission.
Chris@76: 					$curData[$id_group] = $group_permissions[$ID_PERM];
Chris@76: 				}
Chris@76: 				// Otherwise means it's set to disallow..
Chris@76: 				else
Chris@76: 				{
Chris@76: 					$curData[$id_group] = 'x';
Chris@76: 				}
Chris@76: 
Chris@76: 				// Now actually make the data for the group look right.
Chris@76: 				if (empty($curData[$id_group]))
Chris@76: 					$curData[$id_group] = '<span style="color: red;">' . $txt['board_perms_deny'] . '</span>';
Chris@76: 				elseif ($curData[$id_group] == 1)
Chris@76: 					$curData[$id_group] = '<span style="color: darkgreen;">' . $txt['board_perms_allow'] . '</span>';
Chris@76: 				else
Chris@76: 					$curData[$id_group] = 'x';
Chris@76: 
Chris@76: 				// Embolden those permissions different from global (makes it a lot easier!)
Chris@76: 				if (@$board_permissions[0][$id_group][$ID_PERM] != @$group_permissions[$ID_PERM])
Chris@76: 					$curData[$id_group] = '<strong>' . $curData[$id_group] . '</strong>';
Chris@76: 			}
Chris@76: 
Chris@76: 			// Now add the data for this permission.
Chris@76: 			addData($curData);
Chris@76: 		}
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: // Show what the membergroups are made of.
Chris@76: function MemberGroupsReport()
Chris@76: {
Chris@76: 	global $context, $txt, $settings, $modSettings, $smcFunc;
Chris@76: 
Chris@76: 	// Fetch all the board names.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_board, name, member_groups, id_profile
Chris@76: 		FROM {db_prefix}boards',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		if (trim($row['member_groups']) == '')
Chris@76: 			$groups = array(1);
Chris@76: 		else
Chris@76: 			$groups = array_merge(array(1), explode(',', $row['member_groups']));
Chris@76: 
Chris@76: 		$boards[$row['id_board']] = array(
Chris@76: 			'id' => $row['id_board'],
Chris@76: 			'name' => $row['name'],
Chris@76: 			'profile' => $row['id_profile'],
Chris@76: 			'groups' => $groups,
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Standard settings.
Chris@76: 	$mgSettings = array(
Chris@76: 		'name' => '',
Chris@76: 		'#sep#1' => $txt['member_group_settings'],
Chris@76: 		'color' => $txt['member_group_color'],
Chris@76: 		'min_posts' => $txt['member_group_min_posts'],
Chris@76: 		'max_messages' => $txt['member_group_max_messages'],
Chris@76: 		'stars' => $txt['member_group_stars'],
Chris@76: 		'#sep#2' => $txt['member_group_access'],
Chris@76: 	);
Chris@76: 
Chris@76: 	// Add on the boards!
Chris@76: 	foreach ($boards as $board)
Chris@76: 		$mgSettings['board_' . $board['id']] = $board['name'];
Chris@76: 
Chris@76: 	// Add all the membergroup settings, plus we'll be adding in columns!
Chris@76: 	setKeys('cols', $mgSettings);
Chris@76: 
Chris@76: 	// Only one table this time!
Chris@76: 	newTable($txt['gr_type_member_groups'], '-', 'all', 100, 'center', 200, 'left');
Chris@76: 
Chris@76: 	// Get the shaded column in.
Chris@76: 	addData($mgSettings);
Chris@76: 
Chris@76: 	// Now start cycling the membergroups!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT mg.id_group, mg.group_name, mg.online_color, mg.min_posts, mg.max_messages, mg.stars,
Chris@76: 			CASE WHEN bp.permission IS NOT NULL OR mg.id_group = {int:admin_group} THEN 1 ELSE 0 END AS can_moderate
Chris@76: 		FROM {db_prefix}membergroups AS mg
Chris@76: 			LEFT JOIN {db_prefix}board_permissions AS bp ON (bp.id_group = mg.id_group AND bp.id_profile = {int:default_profile} AND bp.permission = {string:moderate_board})
Chris@76: 		ORDER BY 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: 			'admin_group' => 1,
Chris@76: 			'default_profile' => 1,
Chris@76: 			'newbie_group' => 4,
Chris@76: 			'moderate_board' => 'moderate_board',
Chris@76: 		)
Chris@76: 	);
Chris@76: 
Chris@76: 	// Cache them so we get regular members too.
Chris@76: 	$rows = array(
Chris@76: 		array(
Chris@76: 			'id_group' => -1,
Chris@76: 			'group_name' => $txt['membergroups_guests'],
Chris@76: 			'online_color' => '',
Chris@76: 			'min_posts' => -1,
Chris@76: 			'max_messages' => null,
Chris@76: 			'stars' => ''
Chris@76: 		),
Chris@76: 		array(
Chris@76: 			'id_group' => 0,
Chris@76: 			'group_name' => $txt['membergroups_members'],
Chris@76: 			'online_color' => '',
Chris@76: 			'min_posts' => -1,
Chris@76: 			'max_messages' => null,
Chris@76: 			'stars' => ''
Chris@76: 		),
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$rows[] = $row;
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	foreach ($rows as $row)
Chris@76: 	{
Chris@76: 		$row['stars'] = explode('#', $row['stars']);
Chris@76: 
Chris@76: 		$group = array(
Chris@76: 			'name' => $row['group_name'],
Chris@76: 			'color' => empty($row['online_color']) ? '-' : '<span style="color: ' . $row['online_color'] . ';">' . $row['online_color'] . '</span>',
Chris@76: 			'min_posts' => $row['min_posts'] == -1 ? 'N/A' : $row['min_posts'],
Chris@76: 			'max_messages' => $row['max_messages'],
Chris@76: 			'stars' => !empty($row['stars'][0]) && !empty($row['stars'][1]) ? str_repeat('<img src="' . $settings['images_url'] . '/' . $row['stars'][1] . '" alt="*" />', $row['stars'][0]) : '',
Chris@76: 		);
Chris@76: 
Chris@76: 		// Board permissions.
Chris@76: 		foreach ($boards as $board)
Chris@76: 			$group['board_' . $board['id']] = in_array($row['id_group'], $board['groups']) ? '<span style="color: darkgreen;">' . $txt['board_perms_allow'] . '</span>' : 'x';
Chris@76: 
Chris@76: 		addData($group);
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: // Show the large variety of group permissions assigned to each membergroup.
Chris@76: function GroupPermissionsReport()
Chris@76: {
Chris@76: 	global $context, $txt, $modSettings, $smcFunc;
Chris@76: 
Chris@76: 	if (isset($_REQUEST['groups']))
Chris@76: 	{
Chris@76: 		if (!is_array($_REQUEST['groups']))
Chris@76: 			$_REQUEST['groups'] = explode(',', $_REQUEST['groups']);
Chris@76: 		foreach ($_REQUEST['groups'] as $k => $dummy)
Chris@76: 			$_REQUEST['groups'][$k] = (int) $dummy;
Chris@76: 		$_REQUEST['groups'] = array_diff($_REQUEST['groups'], array(3));
Chris@76: 
Chris@76: 		$clause = 'id_group IN ({array_int:groups})';
Chris@76: 	}
Chris@76: 	else
Chris@76: 		$clause = 'id_group != {int:moderator_group}';
Chris@76: 
Chris@76: 	// Get all the possible membergroups, except admin!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_group, group_name
Chris@76: 		FROM {db_prefix}membergroups
Chris@76: 		WHERE ' . $clause . '
Chris@76: 			AND id_group != {int:admin_group}' . (empty($modSettings['permission_enable_postgroups']) ? '
Chris@76: 			AND min_posts = {int:min_posts}' : '') . '
Chris@76: 		ORDER BY min_posts, CASE WHEN id_group < {int:newbie_group} THEN id_group ELSE 4 END, group_name',
Chris@76: 		array(
Chris@76: 			'admin_group' => 1,
Chris@76: 			'min_posts' => -1,
Chris@76: 			'newbie_group' => 4,
Chris@76: 			'moderator_group' => 3,
Chris@76: 			'groups' => isset($_REQUEST['groups']) ? $_REQUEST['groups'] : array(),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	if (!isset($_REQUEST['groups']) || in_array(-1, $_REQUEST['groups']) || in_array(0, $_REQUEST['groups']))
Chris@76: 		$groups = array('col' => '', -1 => $txt['membergroups_guests'], 0 => $txt['membergroups_members']);
Chris@76: 	else
Chris@76: 		$groups = array('col' => '');
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$groups[$row['id_group']] = $row['group_name'];
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Make sure that every group is represented!
Chris@76: 	setKeys('rows', $groups);
Chris@76: 
Chris@76: 	// Create the table first.
Chris@76: 	newTable($txt['gr_type_group_perms'], '-', 'all', 100, 'center', 200, 'left');
Chris@76: 
Chris@76: 	// Show all the groups
Chris@76: 	addData($groups);
Chris@76: 
Chris@76: 	// Add a separator
Chris@76: 	addSeparator($txt['board_perms_permission']);
Chris@76: 
Chris@76: 	// Now the big permission fetch!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_group, add_deny, permission
Chris@76: 		FROM {db_prefix}permissions
Chris@76: 		WHERE ' . $clause . (empty($modSettings['permission_enable_deny']) ? '
Chris@76: 			AND add_deny = {int:not_denied}' : '') . '
Chris@76: 		ORDER BY permission',
Chris@76: 		array(
Chris@76: 			'not_denied' => 1,
Chris@76: 			'moderator_group' => 3,
Chris@76: 			'groups' => isset($_REQUEST['groups']) ? $_REQUEST['groups'] : array(),
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$lastPermission = null;
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// If this is a new permission flush the last row.
Chris@76: 		if ($row['permission'] != $lastPermission)
Chris@76: 		{
Chris@76: 			// Send the data!
Chris@76: 			if ($lastPermission !== null)
Chris@76: 				addData($curData);
Chris@76: 
Chris@76: 			// Add the permission name in the left column.
Chris@76: 			$curData = array('col' => isset($txt['group_perms_name_' . $row['permission']]) ? $txt['group_perms_name_' . $row['permission']] : $row['permission']);
Chris@76: 
Chris@76: 			$lastPermission = $row['permission'];
Chris@76: 		}
Chris@76: 
Chris@76: 		// Good stuff - add the permission to the list!
Chris@76: 		if ($row['add_deny'])
Chris@76: 			$curData[$row['id_group']] = '<span style="color: darkgreen;">' . $txt['board_perms_allow'] . '</span>';
Chris@76: 		else
Chris@76: 			$curData[$row['id_group']] = '<span style="color: red;">' . $txt['board_perms_deny'] . '</span>';
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Flush the last data!
Chris@76: 	addData($curData);
Chris@76: }
Chris@76: 
Chris@76: // Report for showing all the forum staff members - quite a feat!
Chris@76: function StaffReport()
Chris@76: {
Chris@76: 	global $sourcedir, $context, $txt, $smcFunc;
Chris@76: 
Chris@76: 	require_once($sourcedir . '/Subs-Members.php');
Chris@76: 
Chris@76: 	// Fetch all the board names.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_board, name
Chris@76: 		FROM {db_prefix}boards',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$boards = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$boards[$row['id_board']] = $row['name'];
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Get every moderator.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT mods.id_board, mods.id_member
Chris@76: 		FROM {db_prefix}moderators AS mods',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$moderators = array();
Chris@76: 	$local_mods = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$moderators[$row['id_member']][] = $row['id_board'];
Chris@76: 		$local_mods[$row['id_member']] = $row['id_member'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Get a list of global moderators (i.e. members with moderation powers).
Chris@76: 	$global_mods = array_intersect(membersAllowedTo('moderate_board', 0), membersAllowedTo('approve_posts', 0), membersAllowedTo('remove_any', 0), membersAllowedTo('modify_any', 0));
Chris@76: 
Chris@76: 	// How about anyone else who is special?
Chris@76: 	$allStaff = array_merge(membersAllowedTo('admin_forum'), membersAllowedTo('manage_membergroups'), membersAllowedTo('manage_permissions'), $local_mods, $global_mods);
Chris@76: 
Chris@76: 	// Make sure everyone is there once - no admin less important than any other!
Chris@76: 	$allStaff = array_unique($allStaff);
Chris@76: 
Chris@76: 	// This is a bit of a cop out - but we're protecting their forum, really!
Chris@76: 	if (count($allStaff) > 300)
Chris@76: 		fatal_lang_error('report_error_too_many_staff');
Chris@76: 
Chris@76: 	// Get all the possible membergroups!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_group, group_name, online_color
Chris@76: 		FROM {db_prefix}membergroups',
Chris@76: 		array(
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$groups = array(0 => $txt['full_member']);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 		$groups[$row['id_group']] = empty($row['online_color']) ? $row['group_name'] : '<span style="color: ' . $row['online_color'] . '">' . $row['group_name'] . '</span>';
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// All the fields we'll show.
Chris@76: 	$staffSettings = array(
Chris@76: 		'position' => $txt['report_staff_position'],
Chris@76: 		'moderates' => $txt['report_staff_moderates'],
Chris@76: 		'posts' => $txt['report_staff_posts'],
Chris@76: 		'last_login' => $txt['report_staff_last_login'],
Chris@76: 	);
Chris@76: 
Chris@76: 	// Do it in columns, it's just easier.
Chris@76: 	setKeys('cols');
Chris@76: 
Chris@76: 	// Get each member!
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_member, real_name, id_group, posts, last_login
Chris@76: 		FROM {db_prefix}members
Chris@76: 		WHERE id_member IN ({array_int:staff_list})
Chris@76: 		ORDER BY real_name',
Chris@76: 		array(
Chris@76: 			'staff_list' => $allStaff,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// Each member gets their own table!.
Chris@76: 		newTable($row['real_name'], '', 'left', 'auto', 'left', 200, 'center');
Chris@76: 
Chris@76: 		// First off, add in the side key.
Chris@76: 		addData($staffSettings);
Chris@76: 
Chris@76: 		// Create the main data array.
Chris@76: 		$staffData = array(
Chris@76: 			'position' => isset($groups[$row['id_group']]) ? $groups[$row['id_group']] : $groups[0],
Chris@76: 			'posts' => $row['posts'],
Chris@76: 			'last_login' => timeformat($row['last_login']),
Chris@76: 			'moderates' => array(),
Chris@76: 		);
Chris@76: 
Chris@76: 		// What do they moderate?
Chris@76: 		if (in_array($row['id_member'], $global_mods))
Chris@76: 			$staffData['moderates'] = '<em>' . $txt['report_staff_all_boards'] . '</em>';
Chris@76: 		elseif (isset($moderators[$row['id_member']]))
Chris@76: 		{
Chris@76: 			// Get the names
Chris@76: 			foreach ($moderators[$row['id_member']] as $board)
Chris@76: 				if (isset($boards[$board]))
Chris@76: 					$staffData['moderates'][] = $boards[$board];
Chris@76: 
Chris@76: 			$staffData['moderates'] = implode(', ', $staffData['moderates']);
Chris@76: 		}
Chris@76: 		else
Chris@76: 			$staffData['moderates'] = '<em>' . $txt['report_staff_no_boards'] . '</em>';
Chris@76: 
Chris@76: 		// Next add the main data.
Chris@76: 		addData($staffData);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: }
Chris@76: 
Chris@76: // This function creates a new table of data, most functions will only use it once.
Chris@76: function newTable($title = '', $default_value = '', $shading = 'all', $width_normal = 'auto', $align_normal = 'center', $width_shaded = 'auto', $align_shaded = 'auto')
Chris@76: {
Chris@76: 	global $context;
Chris@76: 
Chris@76: 	// Set the table count if needed.
Chris@76: 	if (empty($context['table_count']))
Chris@76: 		$context['table_count'] = 0;
Chris@76: 
Chris@76: 	// Create the table!
Chris@76: 	$context['tables'][$context['table_count']] = array(
Chris@76: 		'title' => $title,
Chris@76: 		'default_value' => $default_value,
Chris@76: 		'shading' => array(
Chris@76: 			'left' => $shading == 'all' || $shading == 'left',
Chris@76: 			'top' => $shading == 'all' || $shading == 'top',
Chris@76: 		),
Chris@76: 		'width' => array(
Chris@76: 			'normal' => $width_normal,
Chris@76: 			'shaded' => $width_shaded,
Chris@76: 		),
Chris@76: 		'align' => array(
Chris@76: 			'normal' => $align_normal,
Chris@76: 			'shaded' => $align_shaded,
Chris@76: 		),
Chris@76: 		'data' => array(),
Chris@76: 	);
Chris@76: 
Chris@76: 	$context['current_table'] = $context['table_count'];
Chris@76: 
Chris@76: 	// Increment the count...
Chris@76: 	$context['table_count']++;
Chris@76: }
Chris@76: 
Chris@76: // Add an extra slice of data to the table
Chris@76: function addData($inc_data, $custom_table = null)
Chris@76: {
Chris@76: 	global $context;
Chris@76: 
Chris@76: 	// No tables? Create one even though we are probably already in a bad state!
Chris@76: 	if (empty($context['table_count']))
Chris@76: 		newTable();
Chris@76: 
Chris@76: 	// Specific table?
Chris@76: 	if ($custom_table !== null && !isset($context['tables'][$custom_table]))
Chris@76: 		return false;
Chris@76: 	elseif ($custom_table !== null)
Chris@76: 		$table = $custom_table;
Chris@76: 	else
Chris@76: 		$table = $context['current_table'];
Chris@76: 
Chris@76: 	// If we have keys, sanitise the data...
Chris@76: 	if (!empty($context['keys']))
Chris@76: 	{
Chris@76: 		// Basically, check every key exists!
Chris@76: 		foreach ($context['keys'] as $key => $dummy)
Chris@76: 		{
Chris@76: 			$data[$key] = array(
Chris@76: 				'v' => empty($inc_data[$key]) ? $context['tables'][$table]['default_value'] : $inc_data[$key],
Chris@76: 			);
Chris@76: 			// Special "hack" the adding separators when doing data by column.
Chris@76: 			if (substr($key, 0, 5) == '#sep#')
Chris@76: 				$data[$key]['separator'] = true;
Chris@76: 		}
Chris@76: 	}
Chris@76: 	else
Chris@76: 	{
Chris@76: 		$data = $inc_data;
Chris@76: 		foreach ($data as $key => $value)
Chris@76: 		{
Chris@76: 			$data[$key] = array(
Chris@76: 				'v' => $value,
Chris@76: 			);
Chris@76: 			if (substr($key, 0, 5) == '#sep#')
Chris@76: 				$data[$key]['separator'] = true;
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Is it by row?
Chris@76: 	if (empty($context['key_method']) || $context['key_method'] == 'rows')
Chris@76: 	{
Chris@76: 		// Add the data!
Chris@76: 		$context['tables'][$table]['data'][] = $data;
Chris@76: 	}
Chris@76: 	// Otherwise, tricky!
Chris@76: 	else
Chris@76: 	{
Chris@76: 		foreach ($data as $key => $item)
Chris@76: 			$context['tables'][$table]['data'][$key][] = $item;
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: // Add a separator row, only really used when adding data by rows.
Chris@76: function addSeparator($title = '', $custom_table = null)
Chris@76: {
Chris@76: 	global $context;
Chris@76: 
Chris@76: 	// No tables - return?
Chris@76: 	if (empty($context['table_count']))
Chris@76: 		return;
Chris@76: 
Chris@76: 	// Specific table?
Chris@76: 	if ($custom_table !== null && !isset($context['tables'][$table]))
Chris@76: 		return false;
Chris@76: 	elseif ($custom_table !== null)
Chris@76: 		$table = $custom_table;
Chris@76: 	else
Chris@76: 		$table = $context['current_table'];
Chris@76: 
Chris@76: 	// Plumb in the separator
Chris@76: 	$context['tables'][$table]['data'][] = array(0 => array(
Chris@76: 		'separator' => true,
Chris@76: 		'v' => $title
Chris@76: 	));
Chris@76: }
Chris@76: 
Chris@76: // This does the necessary count of table data before displaying them.
Chris@76: function finishTables()
Chris@76: {
Chris@76: 	global $context;
Chris@76: 
Chris@76: 	if (empty($context['tables']))
Chris@76: 		return;
Chris@76: 
Chris@76: 	// Loop through each table counting up some basic values, to help with the templating.
Chris@76: 	foreach ($context['tables'] as $id => $table)
Chris@76: 	{
Chris@76: 		$context['tables'][$id]['id'] = $id;
Chris@76: 		$context['tables'][$id]['row_count'] = count($table['data']);
Chris@76: 		$curElement = current($table['data']);
Chris@76: 		$context['tables'][$id]['column_count'] = count($curElement);
Chris@76: 
Chris@76: 		// Work out the rough width - for templates like the print template. Without this we might get funny tables.
Chris@76: 		if ($table['shading']['left'] && $table['width']['shaded'] != 'auto' && $table['width']['normal'] != 'auto')
Chris@76: 			$context['tables'][$id]['max_width'] = $table['width']['shaded'] + ($context['tables'][$id]['column_count'] - 1) * $table['width']['normal'];
Chris@76: 		elseif ($table['width']['normal'] != 'auto')
Chris@76: 			$context['tables'][$id]['max_width'] = $context['tables'][$id]['column_count'] * $table['width']['normal'];
Chris@76: 		else
Chris@76: 			$context['tables'][$id]['max_width'] = 'auto';
Chris@76: 	}
Chris@76: }
Chris@76: 
Chris@76: // Set the keys in use by the tables - these ensure entries MUST exist if the data isn't sent.
Chris@76: function setKeys($method = 'rows', $keys = array(), $reverse = false)
Chris@76: {
Chris@76: 	global $context;
Chris@76: 
Chris@76: 	// Do we want to use the keys of the keys as the keys? :P
Chris@76: 	if ($reverse)
Chris@76: 		$context['keys'] = array_flip($keys);
Chris@76: 	else
Chris@76: 		$context['keys'] = $keys;
Chris@76: 
Chris@76: 	// Rows or columns?
Chris@76: 	$context['key_method'] = $method == 'rows' ? 'rows' : 'cols';
Chris@76: }
Chris@76: 
Chris@76: ?>