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 currently just shows group info, and allows certain privaledged members to add/remove members.
Chris@76: 
Chris@76: 	void Groups()
Chris@76: 		- allows moderators and users to access the group showing functions.
Chris@76: 		- handles permission checks, and puts the moderation bar on as required.
Chris@76: 
Chris@76: 	void MembergroupMembers()
Chris@76: 		- can be called from ManageMembergroups if it needs templating within the admin environment.
Chris@76: 		- show a list of members that are part of a given membergroup.
Chris@76: 		- called by ?action=moderate;area=viewgroups;sa=members;group=x
Chris@76: 		- requires the manage_membergroups permission.
Chris@76: 		- uses the group_members sub template of ManageMembergroups.
Chris@76: 		- allows to add and remove members from the selected membergroup.
Chris@76: 		- allows sorting on several columns.
Chris@76: 		- redirects to itself.
Chris@76: 
Chris@76: 	int list_getGroupRequestCount(string where)
Chris@76: 		- callback function for createList()
Chris@76: 		- returns the count of group requests
Chris@76: 
Chris@76: 	array list_getGroupRequests(int start, int items_per_page, string sort, string where)
Chris@76: 		- callback function for createList()
Chris@76: 		- returns an array of group requests
Chris@76: 		- each group request has:
Chris@76: 			'id'
Chris@76: 			'member_link'
Chris@76: 			'group_link'
Chris@76: 			'reason'
Chris@76: 			'time_submitted'
Chris@76: 
Chris@76: */
Chris@76: 
Chris@76: // Entry point, permission checks, admin bars, etc.
Chris@76: function Groups()
Chris@76: {
Chris@76: 	global $context, $txt, $scripturl, $sourcedir, $user_info;
Chris@76: 
Chris@76: 	// The sub-actions that we can do. Format "Function Name, Mod Bar Index if appropriate".
Chris@76: 	$subActions = array(
Chris@76: 		'index' => array('GroupList', 'view_groups'),
Chris@76: 		'members' => array('MembergroupMembers', 'view_groups'),
Chris@76: 		'requests' => array('GroupRequests', 'group_requests'),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Default to sub action 'index' or 'settings' depending on permissions.
Chris@76: 	$_REQUEST['sa'] = isset($_REQUEST['sa']) && isset($subActions[$_REQUEST['sa']]) ? $_REQUEST['sa'] : 'index';
Chris@76: 
Chris@76: 	// Get the template stuff up and running.
Chris@76: 	loadLanguage('ManageMembers');
Chris@76: 	loadLanguage('ModerationCenter');
Chris@76: 	loadTemplate('ManageMembergroups');
Chris@76: 
Chris@76: 	// If we can see the moderation center, and this has a mod bar entry, add the mod center bar.
Chris@76: 	if (allowedTo('access_mod_center') || $user_info['mod_cache']['bq'] != '0=1' || $user_info['mod_cache']['gq'] != '0=1' || allowedTo('manage_membergroups'))
Chris@76: 	{
Chris@76: 		require_once($sourcedir . '/ModerationCenter.php');
Chris@76: 		$_GET['area'] = $_REQUEST['sa'] == 'requests' ? 'groups' : 'viewgroups';
Chris@76: 		ModerationMain(true);
Chris@76: 	}
Chris@76: 	// Otherwise add something to the link tree, for normal people.
Chris@76: 	else
Chris@76: 	{
Chris@76: 		isAllowedTo('view_mlist');
Chris@76: 
Chris@76: 		$context['linktree'][] = array(
Chris@76: 			'url' => $scripturl . '?action=groups',
Chris@76: 			'name' => $txt['groups'],
Chris@76: 		);
Chris@76: 	}
Chris@76: 
Chris@76: 	// Call the actual function.
Chris@76: 	$subActions[$_REQUEST['sa']][0]();
Chris@76: }
Chris@76: 
Chris@76: // This very simply lists the groups, nothing snazy.
Chris@76: function GroupList()
Chris@76: {
Chris@76: 	global $txt, $scripturl, $user_profile, $user_info, $context, $settings, $modSettings, $smcFunc, $sourcedir;
Chris@76: 
Chris@76: 	// Yep, find the groups...
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT mg.id_group, mg.group_name, mg.description, mg.group_type, mg.online_color, mg.hidden,
Chris@76: 			mg.stars, IFNULL(gm.id_member, 0) AS can_moderate
Chris@76: 		FROM {db_prefix}membergroups AS mg
Chris@76: 			LEFT JOIN {db_prefix}group_moderators AS gm ON (gm.id_group = mg.id_group AND gm.id_member = {int:current_member})
Chris@76: 		WHERE mg.min_posts = {int:min_posts}
Chris@76: 			AND mg.id_group != {int:mod_group}' . (allowedTo('admin_forum') ? '' : '
Chris@76: 			AND mg.group_type != {int:is_protected}') . '
Chris@76: 		ORDER BY group_name',
Chris@76: 		array(
Chris@76: 			'current_member' => $user_info['id'],
Chris@76: 			'min_posts' => -1,
Chris@76: 			'mod_group' => 3,
Chris@76: 			'is_protected' => 1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	// This is where we store our groups.
Chris@76: 	$context['groups'] = array();
Chris@76: 	$group_ids = array();
Chris@76: 	$context['can_moderate'] = allowedTo('manage_membergroups');
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// We only list the groups they can see.
Chris@76: 		if ($row['hidden'] && !$row['can_moderate'] && !allowedTo('manage_membergroups'))
Chris@76: 			continue;
Chris@76: 
Chris@76: 		$row['stars'] = explode('#', $row['stars']);
Chris@76: 
Chris@76: 		$context['groups'][$row['id_group']] = array(
Chris@76: 			'id' => $row['id_group'],
Chris@76: 			'name' => $row['group_name'],
Chris@76: 			'desc' => $row['description'],
Chris@76: 			'color' => $row['online_color'],
Chris@76: 			'type' => $row['group_type'],
Chris@76: 			'num_members' => 0,
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: 		$context['can_moderate'] |= $row['can_moderate'];
Chris@76: 		$group_ids[] = $row['id_group'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Count up the members separately...
Chris@76: 	if (!empty($group_ids))
Chris@76: 	{
Chris@76: 		$query = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_group, COUNT(*) AS num_members
Chris@76: 			FROM {db_prefix}members
Chris@76: 			WHERE id_group IN ({array_int:group_list})
Chris@76: 			GROUP BY id_group',
Chris@76: 			array(
Chris@76: 				'group_list' => $group_ids,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($query))
Chris@76: 			$context['groups'][$row['id_group']]['num_members'] += $row['num_members'];
Chris@76: 		$smcFunc['db_free_result']($query);
Chris@76: 
Chris@76: 		// Only do additional groups if we can moderate...
Chris@76: 		if ($context['can_moderate'])
Chris@76: 		{
Chris@76: 			$query = $smcFunc['db_query']('', '
Chris@76: 				SELECT mg.id_group, COUNT(*) AS num_members
Chris@76: 				FROM {db_prefix}membergroups AS mg
Chris@76: 					INNER JOIN {db_prefix}members AS mem ON (mem.additional_groups != {string:blank_screen}
Chris@76: 						AND mem.id_group != mg.id_group
Chris@76: 						AND FIND_IN_SET(mg.id_group, mem.additional_groups) != 0)
Chris@76: 				WHERE mg.id_group IN ({array_int:group_list})
Chris@76: 				GROUP BY mg.id_group',
Chris@76: 				array(
Chris@76: 					'group_list' => $group_ids,
Chris@76: 					'blank_screen' => '',
Chris@76: 				)
Chris@76: 			);
Chris@76: 			while ($row = $smcFunc['db_fetch_assoc']($query))
Chris@76: 				$context['groups'][$row['id_group']]['num_members'] += $row['num_members'];
Chris@76: 			$smcFunc['db_free_result']($query);
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	$context['sub_template'] = 'group_index';
Chris@76: 	$context['page_title'] = $txt['viewing_groups'];
Chris@76: 
Chris@76: 	// Making a list is not hard with this beauty.
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 
Chris@76: 	// Use the standard templates for showing this.
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'group_lists',
Chris@76: 		'title' => $context['page_title'],
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getGroups',
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'group' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['name'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$group', '
Chris@76: 						global $scripturl, $context;
Chris@76: 
Chris@76: 						$output = \'<a href="\' . $scripturl . \'?action=\' . $context[\'current_action\'] . (isset($context[\'admin_area\']) ? \';area=\' . $context[\'admin_area\'] : \'\') . \';sa=members;group=\' . $group[\'id\'] . \'" \' . ($group[\'color\'] ? \'style="color: \' . $group[\'color\'] . \';"\' : \'\') . \'>\' . $group[\'name\'] . \'</a>\';
Chris@76: 
Chris@76: 						if ($group[\'desc\'])
Chris@76: 							$output .= \'<div class="smalltext">\' . $group[\'desc\'] . \'</div>\';
Chris@76: 
Chris@76: 						return $output;
Chris@76: 					'),
Chris@76: 					'style' => 'width: 50%;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'stars' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['membergroups_stars'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'stars',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'moderators' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['moderators'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'function' => create_function('$group', '
Chris@76: 						global $txt;
Chris@76: 
Chris@76: 						return empty($group[\'moderators\']) ? \'<em>\' . $txt[\'membergroups_new_copy_none\'] . \'</em>\' : implode(\', \', $group[\'moderators\']);
Chris@76: 					'),
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'members' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['membergroups_members_top'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'comma_format' => true,
Chris@76: 					'db' => 'num_members',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Create the request list.
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	$context['sub_template'] = 'show_list';
Chris@76: 	$context['default_list'] = 'group_lists';
Chris@76: }
Chris@76: 
Chris@76: // Get the group information for the list.
Chris@76: function list_getGroups($start, $items_per_page, $sort)
Chris@76: {
Chris@76: 	global $smcFunc, $txt, $scripturl, $user_info, $settings;
Chris@76: 
Chris@76: 	// Yep, find the groups...
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT mg.id_group, mg.group_name, mg.description, mg.group_type, mg.online_color, mg.hidden,
Chris@76: 			mg.stars, IFNULL(gm.id_member, 0) AS can_moderate
Chris@76: 		FROM {db_prefix}membergroups AS mg
Chris@76: 			LEFT JOIN {db_prefix}group_moderators AS gm ON (gm.id_group = mg.id_group AND gm.id_member = {int:current_member})
Chris@76: 		WHERE mg.min_posts = {int:min_posts}
Chris@76: 			AND mg.id_group != {int:mod_group}' . (allowedTo('admin_forum') ? '' : '
Chris@76: 			AND mg.group_type != {int:is_protected}') . '
Chris@76: 		ORDER BY group_name',
Chris@76: 		array(
Chris@76: 			'current_member' => $user_info['id'],
Chris@76: 			'min_posts' => -1,
Chris@76: 			'mod_group' => 3,
Chris@76: 			'is_protected' => 1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	// Start collecting the data.
Chris@76: 	$groups = array();
Chris@76: 	$group_ids = array();
Chris@76: 	$context['can_moderate'] = allowedTo('manage_membergroups');
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		// We only list the groups they can see.
Chris@76: 		if ($row['hidden'] && !$row['can_moderate'] && !allowedTo('manage_membergroups'))
Chris@76: 			continue;
Chris@76: 
Chris@76: 		$row['stars'] = explode('#', $row['stars']);
Chris@76: 
Chris@76: 		$groups[$row['id_group']] = array(
Chris@76: 			'id' => $row['id_group'],
Chris@76: 			'name' => $row['group_name'],
Chris@76: 			'desc' => $row['description'],
Chris@76: 			'color' => $row['online_color'],
Chris@76: 			'type' => $row['group_type'],
Chris@76: 			'num_members' => 0,
Chris@76: 			'moderators' => array(),
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: 		$context['can_moderate'] |= $row['can_moderate'];
Chris@76: 		$group_ids[] = $row['id_group'];
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Count up the members separately...
Chris@76: 	if (!empty($group_ids))
Chris@76: 	{
Chris@76: 		$query = $smcFunc['db_query']('', '
Chris@76: 			SELECT id_group, COUNT(*) AS num_members
Chris@76: 			FROM {db_prefix}members
Chris@76: 			WHERE id_group IN ({array_int:group_list})
Chris@76: 			GROUP BY id_group',
Chris@76: 			array(
Chris@76: 				'group_list' => $group_ids,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($query))
Chris@76: 			$groups[$row['id_group']]['num_members'] += $row['num_members'];
Chris@76: 		$smcFunc['db_free_result']($query);
Chris@76: 
Chris@76: 		// Only do additional groups if we can moderate...
Chris@76: 		if ($context['can_moderate'])
Chris@76: 		{
Chris@76: 			$query = $smcFunc['db_query']('', '
Chris@76: 				SELECT mg.id_group, COUNT(*) AS num_members
Chris@76: 				FROM {db_prefix}membergroups AS mg
Chris@76: 					INNER JOIN {db_prefix}members AS mem ON (mem.additional_groups != {string:blank_screen}
Chris@76: 						AND mem.id_group != mg.id_group
Chris@76: 						AND FIND_IN_SET(mg.id_group, mem.additional_groups) != 0)
Chris@76: 				WHERE mg.id_group IN ({array_int:group_list})
Chris@76: 				GROUP BY mg.id_group',
Chris@76: 				array(
Chris@76: 					'group_list' => $group_ids,
Chris@76: 					'blank_screen' => '',
Chris@76: 				)
Chris@76: 			);
Chris@76: 			while ($row = $smcFunc['db_fetch_assoc']($query))
Chris@76: 				$groups[$row['id_group']]['num_members'] += $row['num_members'];
Chris@76: 			$smcFunc['db_free_result']($query);
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Get any group moderators.
Chris@76: 	// Count up the members separately...
Chris@76: 	if (!empty($group_ids))
Chris@76: 	{
Chris@76: 		$query = $smcFunc['db_query']('', '
Chris@76: 			SELECT mods.id_group, mods.id_member, mem.member_name, mem.real_name
Chris@76: 			FROM {db_prefix}group_moderators AS mods
Chris@76: 				INNER JOIN {db_prefix}members AS mem ON (mem.id_member = mods.id_member)
Chris@76: 			WHERE mods.id_group IN ({array_int:group_list})',
Chris@76: 			array(
Chris@76: 				'group_list' => $group_ids,
Chris@76: 			)
Chris@76: 		);
Chris@76: 		while ($row = $smcFunc['db_fetch_assoc']($query))
Chris@76: 			$groups[$row['id_group']]['moderators'][] = '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>';
Chris@76: 		$smcFunc['db_free_result']($query);
Chris@76: 	}
Chris@76: 
Chris@76: 	return $groups;
Chris@76: }
Chris@76: 
Chris@76: // How many groups are there that are visible?
Chris@76: function list_getGroupCount()
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(id_group) AS group_count
Chris@76: 		FROM {db_prefix}membergroups
Chris@76: 		WHERE mg.min_posts = {int:min_posts}
Chris@76: 			AND mg.id_group != {int:mod_group}' . (allowedTo('admin_forum') ? '' : '
Chris@76: 			AND mg.group_type != {int:is_protected}'),
Chris@76: 		array(
Chris@76: 			'min_posts' => -1,
Chris@76: 			'mod_group' => 3,
Chris@76: 			'is_protected' => 1,
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($group_count) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $group_count;
Chris@76: }
Chris@76: 
Chris@76: // Display members of a group, and allow adding of members to a group. Silly function name though ;)
Chris@76: function MembergroupMembers()
Chris@76: {
Chris@76: 	global $txt, $scripturl, $context, $modSettings, $sourcedir, $user_info, $settings, $smcFunc;
Chris@76: 
Chris@76: 	$_REQUEST['group'] = isset($_REQUEST['group']) ? (int) $_REQUEST['group'] : 0;
Chris@76: 
Chris@76: 	// No browsing of guests, membergroup 0 or moderators.
Chris@76: 	if (in_array($_REQUEST['group'], array(-1, 0, 3)))
Chris@76: 		fatal_lang_error('membergroup_does_not_exist', false);
Chris@76: 
Chris@76: 	// Load up the group details.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_group AS id, group_name AS name, CASE WHEN min_posts = {int:min_posts} THEN 1 ELSE 0 END AS assignable, hidden, online_color,
Chris@76: 			stars, description, CASE WHEN min_posts != {int:min_posts} THEN 1 ELSE 0 END AS is_post_group, group_type
Chris@76: 		FROM {db_prefix}membergroups
Chris@76: 		WHERE id_group = {int:id_group}
Chris@76: 		LIMIT 1',
Chris@76: 		array(
Chris@76: 			'min_posts' => -1,
Chris@76: 			'id_group' => $_REQUEST['group'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	// Doesn't exist?
Chris@76: 	if ($smcFunc['db_num_rows']($request) == 0)
Chris@76: 		fatal_lang_error('membergroup_does_not_exist', false);
Chris@76: 	$context['group'] = $smcFunc['db_fetch_assoc']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Fix the stars.
Chris@76: 	$context['group']['stars'] = explode('#', $context['group']['stars']);
Chris@76: 	$context['group']['stars'] = !empty($context['group']['stars'][0]) && !empty($context['group']['stars'][1]) ? str_repeat('<img src="' . $settings['images_url'] . '/' . $context['group']['stars'][1] . '" alt="*" />', $context['group']['stars'][0]) : '';
Chris@76: 	$context['group']['can_moderate'] = allowedTo('manage_membergroups') && (allowedTo('admin_forum') || $context['group']['group_type'] != 1);
Chris@76: 
Chris@76: 	$context['linktree'][] = array(
Chris@76: 		'url' => $scripturl . '?action=groups;sa=members;group=' . $context['group']['id'],
Chris@76: 		'name' => $context['group']['name'],
Chris@76: 	);
Chris@76: 
Chris@76: 	// Load all the group moderators, for fun.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT mem.id_member, mem.real_name
Chris@76: 		FROM {db_prefix}group_moderators AS mods
Chris@76: 			INNER JOIN {db_prefix}members AS mem ON (mem.id_member = mods.id_member)
Chris@76: 		WHERE mods.id_group = {int:id_group}',
Chris@76: 		array(
Chris@76: 			'id_group' => $_REQUEST['group'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['group']['moderators'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$context['group']['moderators'][] = array(
Chris@76: 			'id' => $row['id_member'],
Chris@76: 			'name' => $row['real_name']
Chris@76: 		);
Chris@76: 
Chris@76: 		if ($user_info['id'] == $row['id_member'] && $context['group']['group_type'] != 1)
Chris@76: 			$context['group']['can_moderate'] = true;
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// If this group is hidden then it can only "exists" if the user can moderate it!
Chris@76: 	if ($context['group']['hidden'] && !$context['group']['can_moderate'])
Chris@76: 		fatal_lang_error('membergroup_does_not_exist', false);
Chris@76: 
Chris@76: 	// You can only assign membership if you are the moderator and/or can manage groups!
Chris@76: 	if (!$context['group']['can_moderate'])
Chris@76: 		$context['group']['assignable'] = 0;
Chris@76: 	// Non-admins cannot assign admins.
Chris@76: 	elseif ($context['group']['id'] == 1 && !allowedTo('admin_forum'))
Chris@76: 		$context['group']['assignable'] = 0;
Chris@76: 
Chris@76: 	// Removing member from group?
Chris@76: 	if (isset($_POST['remove']) && !empty($_REQUEST['rem']) && is_array($_REQUEST['rem']) && $context['group']['assignable'])
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		// Make sure we're dealing with integers only.
Chris@76: 		foreach ($_REQUEST['rem'] as $key => $group)
Chris@76: 			$_REQUEST['rem'][$key] = (int) $group;
Chris@76: 
Chris@76: 		require_once($sourcedir . '/Subs-Membergroups.php');
Chris@76: 		removeMembersFromGroups($_REQUEST['rem'], $_REQUEST['group'], true);
Chris@76: 	}
Chris@76: 	// Must be adding new members to the group...
Chris@76: 	elseif (isset($_REQUEST['add']) && (!empty($_REQUEST['toAdd']) || !empty($_REQUEST['member_add'])) && $context['group']['assignable'])
Chris@76: 	{
Chris@76: 		checkSession();
Chris@76: 
Chris@76: 		$member_query = array();
Chris@76: 		$member_parameters = array();
Chris@76: 
Chris@76: 		// Get all the members to be added... taking into account names can be quoted ;)
Chris@76: 		$_REQUEST['toAdd'] = strtr($smcFunc['htmlspecialchars']($_REQUEST['toAdd'], ENT_QUOTES), array('&quot;' => '"'));
Chris@76: 		preg_match_all('~"([^"]+)"~', $_REQUEST['toAdd'], $matches);
Chris@76: 		$member_names = array_unique(array_merge($matches[1], explode(',', preg_replace('~"[^"]+"~', '', $_REQUEST['toAdd']))));
Chris@76: 
Chris@76: 		foreach ($member_names as $index => $member_name)
Chris@76: 		{
Chris@76: 			$member_names[$index] = trim($smcFunc['strtolower']($member_names[$index]));
Chris@76: 
Chris@76: 			if (strlen($member_names[$index]) == 0)
Chris@76: 				unset($member_names[$index]);
Chris@76: 		}
Chris@76: 
Chris@76: 		// Any passed by ID?
Chris@76: 		$member_ids = array();
Chris@76: 		if (!empty($_REQUEST['member_add']))
Chris@76: 			foreach ($_REQUEST['member_add'] as $id)
Chris@76: 				if ($id > 0)
Chris@76: 					$member_ids[] = (int) $id;
Chris@76: 
Chris@76: 		// Construct the query pelements.
Chris@76: 		if (!empty($member_ids))
Chris@76: 		{
Chris@76: 			$member_query[] = 'id_member IN ({array_int:member_ids})';
Chris@76: 			$member_parameters['member_ids'] = $member_ids;
Chris@76: 		}
Chris@76: 		if (!empty($member_names))
Chris@76: 		{
Chris@76: 			$member_query[] = 'LOWER(member_name) IN ({array_string:member_names})';
Chris@76: 			$member_query[] = 'LOWER(real_name) IN ({array_string:member_names})';
Chris@76: 			$member_parameters['member_names'] = $member_names;
Chris@76: 		}
Chris@76: 
Chris@76: 		$members = array();
Chris@76: 		if (!empty($member_query))
Chris@76: 		{
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT id_member
Chris@76: 				FROM {db_prefix}members
Chris@76: 				WHERE (' . implode(' OR ', $member_query) . ')
Chris@76: 					AND id_group != {int:id_group}
Chris@76: 					AND FIND_IN_SET({int:id_group}, additional_groups) = 0',
Chris@76: 				array_merge($member_parameters, array(
Chris@76: 					'id_group' => $_REQUEST['group'],
Chris@76: 				))
Chris@76: 			);
Chris@76: 			while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 				$members[] = $row['id_member'];
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 		}
Chris@76: 
Chris@76: 		// !!! Add $_POST['additional'] to templates!
Chris@76: 
Chris@76: 		// Do the updates...
Chris@76: 		if (!empty($members))
Chris@76: 		{
Chris@76: 			require_once($sourcedir . '/Subs-Membergroups.php');
Chris@76: 			addMembersToGroup($members, $_REQUEST['group'], isset($_POST['additional']) || $context['group']['hidden'] ? 'only_additional' : 'auto', true);
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// Sort out the sorting!
Chris@76: 	$sort_methods = array(
Chris@76: 		'name' => 'real_name',
Chris@76: 		'email' => allowedTo('moderate_forum') ? 'email_address' : 'hide_email ' . (isset($_REQUEST['desc']) ? 'DESC' : 'ASC') . ', email_address',
Chris@76: 		'active' => 'last_login',
Chris@76: 		'registered' => 'date_registered',
Chris@76: 		'posts' => 'posts',
Chris@76: 	);
Chris@76: 
Chris@76: 	// They didn't pick one, default to by name..
Chris@76: 	if (!isset($_REQUEST['sort']) || !isset($sort_methods[$_REQUEST['sort']]))
Chris@76: 	{
Chris@76: 		$context['sort_by'] = 'name';
Chris@76: 		$querySort = 'real_name';
Chris@76: 	}
Chris@76: 	// Otherwise default to ascending.
Chris@76: 	else
Chris@76: 	{
Chris@76: 		$context['sort_by'] = $_REQUEST['sort'];
Chris@76: 		$querySort = $sort_methods[$_REQUEST['sort']];
Chris@76: 	}
Chris@76: 
Chris@76: 	$context['sort_direction'] = isset($_REQUEST['desc']) ? 'down' : 'up';
Chris@76: 
Chris@76: 	// The where on the query is interesting. Non-moderators should only see people who are in this group as primary.
Chris@76: 	if ($context['group']['can_moderate'])
Chris@76: 		$where = $context['group']['is_post_group'] ? 'id_post_group = {int:group}' : 'id_group = {int:group} OR FIND_IN_SET({int:group}, additional_groups) != 0';
Chris@76: 	else
Chris@76: 		$where = $context['group']['is_post_group'] ? 'id_post_group = {int:group}' : 'id_group = {int:group}';
Chris@76: 
Chris@76: 	// Count members of the group.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}members
Chris@76: 		WHERE ' . $where,
Chris@76: 		array(
Chris@76: 			'group' => $_REQUEST['group'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	list ($context['total_members']) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 	$context['total_members'] = comma_format($context['total_members']);
Chris@76: 
Chris@76: 	// Create the page index.
Chris@76: 	$context['page_index'] = constructPageIndex($scripturl . '?action=' . ($context['group']['can_moderate'] ? 'moderate;area=viewgroups' : 'groups') . ';sa=members;group=' . $_REQUEST['group'] . ';sort=' . $context['sort_by'] . (isset($_REQUEST['desc']) ? ';desc' : ''), $_REQUEST['start'], $context['total_members'], $modSettings['defaultMaxMembers']);
Chris@76: 	$context['start'] = $_REQUEST['start'];
Chris@76: 	$context['can_moderate_forum'] = allowedTo('moderate_forum');
Chris@76: 
Chris@76: 	// Load up all members of this group.
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT id_member, member_name, real_name, email_address, member_ip, date_registered, last_login,
Chris@76: 			hide_email, posts, is_activated, real_name
Chris@76: 		FROM {db_prefix}members
Chris@76: 		WHERE ' . $where . '
Chris@76: 		ORDER BY ' . $querySort . ' ' . ($context['sort_direction'] == 'down' ? 'DESC' : 'ASC') . '
Chris@76: 		LIMIT ' . $context['start'] . ', ' . $modSettings['defaultMaxMembers'],
Chris@76: 		array(
Chris@76: 			'group' => $_REQUEST['group'],
Chris@76: 		)
Chris@76: 	);
Chris@76: 	$context['members'] = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$last_online = empty($row['last_login']) ? $txt['never'] : timeformat($row['last_login']);
Chris@76: 
Chris@76: 		// Italicize the online note if they aren't activated.
Chris@76: 		if ($row['is_activated'] % 10 != 1)
Chris@76: 			$last_online = '<em title="' . $txt['not_activated'] . '">' . $last_online . '</em>';
Chris@76: 
Chris@76: 		$context['members'][] = array(
Chris@76: 			'id' => $row['id_member'],
Chris@76: 			'name' => '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>',
Chris@76: 			'email' => $row['email_address'],
Chris@76: 			'show_email' => showEmailAddress(!empty($row['hide_email']), $row['id_member']),
Chris@76: 			'ip' => '<a href="' . $scripturl . '?action=trackip;searchip=' . $row['member_ip'] . '">' . $row['member_ip'] . '</a>',
Chris@76: 			'registered' => timeformat($row['date_registered']),
Chris@76: 			'last_online' => $last_online,
Chris@76: 			'posts' => comma_format($row['posts']),
Chris@76: 			'is_activated' => $row['is_activated'] % 10 == 1,
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	// Select the template.
Chris@76: 	$context['sub_template'] = 'group_members';
Chris@76: 	$context['page_title'] = $txt['membergroups_members_title'] . ': ' . $context['group']['name'];
Chris@76: }
Chris@76: 
Chris@76: // Show and manage all group requests.
Chris@76: function GroupRequests()
Chris@76: {
Chris@76: 	global $txt, $context, $scripturl, $user_info, $sourcedir, $smcFunc, $modSettings, $language;
Chris@76: 
Chris@76: 	// Set up the template stuff...
Chris@76: 	$context['page_title'] = $txt['mc_group_requests'];
Chris@76: 	$context['sub_template'] = 'show_list';
Chris@76: 
Chris@76: 	// Verify we can be here.
Chris@76: 	if ($user_info['mod_cache']['gq'] == '0=1')
Chris@76: 		isAllowedTo('manage_membergroups');
Chris@76: 
Chris@76: 	// Normally, we act normally...
Chris@76: 	$where = $user_info['mod_cache']['gq'] == '1=1' || $user_info['mod_cache']['gq'] == '0=1' ? $user_info['mod_cache']['gq'] : 'lgr.' . $user_info['mod_cache']['gq'];
Chris@76: 	$where_parameters = array();
Chris@76: 
Chris@76: 	// We've submitted?
Chris@76: 	if (isset($_POST[$context['session_var']]) && !empty($_POST['groupr']) && !empty($_POST['req_action']))
Chris@76: 	{
Chris@76: 		checkSession('post');
Chris@76: 
Chris@76: 		// Clean the values.
Chris@76: 		foreach ($_POST['groupr'] as $k => $request)
Chris@76: 			$_POST['groupr'][$k] = (int) $request;
Chris@76: 
Chris@76: 		// If we are giving a reason (And why shouldn't we?), then we don't actually do much.
Chris@76: 		if ($_POST['req_action'] == 'reason')
Chris@76: 		{
Chris@76: 			// Different sub template...
Chris@76: 			$context['sub_template'] = 'group_request_reason';
Chris@76: 			// And a limitation. We don't care that the page number bit makes no sense, as we don't need it!
Chris@76: 			$where .= ' AND lgr.id_request IN ({array_int:request_ids})';
Chris@76: 			$where_parameters['request_ids'] = $_POST['groupr'];
Chris@76: 
Chris@76: 			$context['group_requests'] = list_getGroupRequests(0, $modSettings['defaultMaxMessages'], 'lgr.id_request', $where, $where_parameters);
Chris@76: 
Chris@76: 			// Let obExit etc sort things out.
Chris@76: 			obExit();
Chris@76: 		}
Chris@76: 		// Otherwise we do something!
Chris@76: 		else
Chris@76: 		{
Chris@76: 			// Get the details of all the members concerned...
Chris@76: 			$request = $smcFunc['db_query']('', '
Chris@76: 				SELECT lgr.id_request, lgr.id_member, lgr.id_group, mem.email_address, mem.id_group AS primary_group,
Chris@76: 					mem.additional_groups AS additional_groups, mem.lngfile, mem.member_name, mem.notify_types,
Chris@76: 					mg.hidden, mg.group_name
Chris@76: 				FROM {db_prefix}log_group_requests AS lgr
Chris@76: 					INNER JOIN {db_prefix}members AS mem ON (mem.id_member = lgr.id_member)
Chris@76: 					INNER JOIN {db_prefix}membergroups AS mg ON (mg.id_group = lgr.id_group)
Chris@76: 				WHERE ' . $where . '
Chris@76: 					AND lgr.id_request IN ({array_int:request_list})
Chris@76: 				ORDER BY mem.lngfile',
Chris@76: 				array(
Chris@76: 					'request_list' => $_POST['groupr'],
Chris@76: 				)
Chris@76: 			);
Chris@76: 			$email_details = array();
Chris@76: 			$group_changes = array();
Chris@76: 			while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 			{
Chris@76: 				$row['lngfile'] = empty($row['lngfile']) || empty($modSettings['userLanguage']) ? $language : $row['lngfile'];
Chris@76: 
Chris@76: 				// If we are approving work out what their new group is.
Chris@76: 				if ($_POST['req_action'] == 'approve')
Chris@76: 				{
Chris@76: 					// For people with more than one request at once.
Chris@76: 					if (isset($group_changes[$row['id_member']]))
Chris@76: 					{
Chris@76: 						$row['additional_groups'] = $group_changes[$row['id_member']]['add'];
Chris@76: 						$row['primary_group'] = $group_changes[$row['id_member']]['primary'];
Chris@76: 					}
Chris@76: 					else
Chris@76: 						$row['additional_groups'] = explode(',', $row['additional_groups']);
Chris@76: 
Chris@76: 					// Don't have it already?
Chris@76: 					if ($row['primary_group'] == $row['id_group'] || in_array($row['id_group'], $row['additional_groups']))
Chris@76: 						continue;
Chris@76: 
Chris@76: 					// Should it become their primary?
Chris@76: 					if ($row['primary_group'] == 0 && $row['hidden'] == 0)
Chris@76: 						$row['primary_group'] = $row['id_group'];
Chris@76: 					else
Chris@76: 						$row['additional_groups'][] = $row['id_group'];
Chris@76: 
Chris@76: 					// Add them to the group master list.
Chris@76: 					$group_changes[$row['id_member']] = array(
Chris@76: 						'primary' => $row['primary_group'],
Chris@76: 						'add' => $row['additional_groups'],
Chris@76: 					);
Chris@76: 				}
Chris@76: 
Chris@76: 				// Add required information to email them.
Chris@76: 				if ($row['notify_types'] != 4)
Chris@76: 					$email_details[] = array(
Chris@76: 						'rid' => $row['id_request'],
Chris@76: 						'member_id' => $row['id_member'],
Chris@76: 						'member_name' => $row['member_name'],
Chris@76: 						'group_id' => $row['id_group'],
Chris@76: 						'group_name' => $row['group_name'],
Chris@76: 						'email' => $row['email_address'],
Chris@76: 						'language' => $row['lngfile'],
Chris@76: 					);
Chris@76: 			}
Chris@76: 			$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 			// Remove the evidence...
Chris@76: 			$smcFunc['db_query']('', '
Chris@76: 				DELETE FROM {db_prefix}log_group_requests
Chris@76: 				WHERE id_request IN ({array_int:request_list})',
Chris@76: 				array(
Chris@76: 					'request_list' => $_POST['groupr'],
Chris@76: 				)
Chris@76: 			);
Chris@76: 
Chris@76: 			// Ensure everyone who is online gets their changes right away.
Chris@76: 			updateSettings(array('settings_updated' => time()));
Chris@76: 
Chris@76: 			if (!empty($email_details))
Chris@76: 			{
Chris@76: 				require_once($sourcedir . '/Subs-Post.php');
Chris@76: 
Chris@76: 				// They are being approved?
Chris@76: 				if ($_POST['req_action'] == 'approve')
Chris@76: 				{
Chris@76: 					// Make the group changes.
Chris@76: 					foreach ($group_changes as $id => $groups)
Chris@76: 					{
Chris@76: 						// Sanity check!
Chris@76: 						foreach ($groups['add'] as $key => $value)
Chris@76: 							if ($value == 0 || trim($value) == '')
Chris@76: 								unset($groups['add'][$key]);
Chris@76: 
Chris@76: 						$smcFunc['db_query']('', '
Chris@76: 							UPDATE {db_prefix}members
Chris@76: 							SET id_group = {int:primary_group}, additional_groups = {string:additional_groups}
Chris@76: 							WHERE id_member = {int:selected_member}',
Chris@76: 							array(
Chris@76: 								'primary_group' => $groups['primary'],
Chris@76: 								'selected_member' => $id,
Chris@76: 								'additional_groups' => implode(',', $groups['add']),
Chris@76: 							)
Chris@76: 						);
Chris@76: 					}
Chris@76: 
Chris@76: 					$lastLng = $user_info['language'];
Chris@76: 					foreach ($email_details as $email)
Chris@76: 					{
Chris@76: 						$replacements = array(
Chris@76: 							'USERNAME' => $email['member_name'],
Chris@76: 							'GROUPNAME' => $email['group_name'],
Chris@76: 						);
Chris@76: 
Chris@76: 						$emaildata = loadEmailTemplate('mc_group_approve', $replacements, $email['language']);
Chris@76: 
Chris@76: 						sendmail($email['email'], $emaildata['subject'], $emaildata['body'], null, null, false, 2);
Chris@76: 					}
Chris@76: 				}
Chris@76: 				// Otherwise, they are getting rejected (With or without a reason).
Chris@76: 				else
Chris@76: 				{
Chris@76: 					// Same as for approving, kind of.
Chris@76: 					$lastLng = $user_info['language'];
Chris@76: 					foreach ($email_details as $email)
Chris@76: 					{
Chris@76: 						$custom_reason = isset($_POST['groupreason']) && isset($_POST['groupreason'][$email['rid']]) ? $_POST['groupreason'][$email['rid']] : '';
Chris@76: 
Chris@76: 						$replacements = array(
Chris@76: 							'USERNAME' => $email['member_name'],
Chris@76: 							'GROUPNAME' => $email['group_name'],
Chris@76: 						);
Chris@76: 
Chris@76: 						if (!empty($custom_reason))
Chris@76: 							$replacements['REASON'] = $custom_reason;
Chris@76: 
Chris@76: 						$emaildata = loadEmailTemplate(empty($custom_reason) ? 'mc_group_reject' : 'mc_group_reject_reason', $replacements, $email['language']);
Chris@76: 
Chris@76: 						sendmail($email['email'], $emaildata['subject'], $emaildata['body'], null, null, false, 2);
Chris@76: 					}
Chris@76: 				}
Chris@76: 			}
Chris@76: 
Chris@76: 			// Restore the current language.
Chris@76: 			loadLanguage('ModerationCenter');
Chris@76: 		}
Chris@76: 	}
Chris@76: 
Chris@76: 	// We're going to want this for making our list.
Chris@76: 	require_once($sourcedir . '/Subs-List.php');
Chris@76: 
Chris@76: 	// This is all the information required for a group listing.
Chris@76: 	$listOptions = array(
Chris@76: 		'id' => 'group_request_list',
Chris@76: 		'title' => $txt['mc_group_requests'],
Chris@76: 		'width' => '100%',
Chris@76: 		'items_per_page' => $modSettings['defaultMaxMessages'],
Chris@76: 		'no_items_label' => $txt['mc_groupr_none_found'],
Chris@76: 		'base_href' => $scripturl . '?action=groups;sa=requests',
Chris@76: 		'default_sort_col' => 'member',
Chris@76: 		'get_items' => array(
Chris@76: 			'function' => 'list_getGroupRequests',
Chris@76: 			'params' => array(
Chris@76: 				$where,
Chris@76: 				$where_parameters,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'get_count' => array(
Chris@76: 			'function' => 'list_getGroupRequestCount',
Chris@76: 			'params' => array(
Chris@76: 				$where,
Chris@76: 				$where_parameters,
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'columns' => array(
Chris@76: 			'member' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['mc_groupr_member'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'member_link',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'mem.member_name',
Chris@76: 					'reverse' => 'mem.member_name DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'group' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['mc_groupr_group'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'group_link',
Chris@76: 				),
Chris@76: 				'sort' => array(
Chris@76: 					'default' => 'mg.group_name',
Chris@76: 					'reverse' => 'mg.group_name DESC',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'reason' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => $txt['mc_groupr_reason'],
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'db' => 'reason',
Chris@76: 				),
Chris@76: 			),
Chris@76: 			'action' => array(
Chris@76: 				'header' => array(
Chris@76: 					'value' => '<input type="checkbox" class="input_check" onclick="invertAll(this, this.form);" />',
Chris@76: 					'style' => 'width: 4%;',
Chris@76: 				),
Chris@76: 				'data' => array(
Chris@76: 					'sprintf' => array(
Chris@76: 						'format' => '<input type="checkbox" name="groupr[]" value="%1$d" class="input_check" />',
Chris@76: 						'params' => array(
Chris@76: 							'id' => false,
Chris@76: 						),
Chris@76: 					),
Chris@76: 					'style' => 'text-align: center;',
Chris@76: 				),
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'form' => array(
Chris@76: 			'href' => $scripturl . '?action=groups;sa=requests',
Chris@76: 			'include_sort' => true,
Chris@76: 			'include_start' => true,
Chris@76: 			'hidden_fields' => array(
Chris@76: 				$context['session_var'] => $context['session_id'],
Chris@76: 			),
Chris@76: 		),
Chris@76: 		'additional_rows' => array(
Chris@76: 			array(
Chris@76: 				'position' => 'bottom_of_list',
Chris@76: 				'value' => '
Chris@76: 					<select name="req_action" onchange="if (this.value != 0 &amp;&amp; (this.value == \'reason\' || confirm(\'' . $txt['mc_groupr_warning'] . '\'))) this.form.submit();">
Chris@76: 						<option value="0">' . $txt['with_selected'] . ':</option>
Chris@76: 						<option value="0">---------------------</option>
Chris@76: 						<option value="approve">' . $txt['mc_groupr_approve'] . '</option>
Chris@76: 						<option value="reject">' . $txt['mc_groupr_reject'] . '</option>
Chris@76: 						<option value="reason">' . $txt['mc_groupr_reject_w_reason'] . '</option>
Chris@76: 					</select>
Chris@76: 					<input type="submit" name="go" value="' . $txt['go'] . '" onclick="var sel = document.getElementById(\'req_action\'); if (sel.value != 0 &amp;&amp; sel.value != \'reason\' &amp;&amp; !confirm(\'' . $txt['mc_groupr_warning'] . '\')) return false;" class="button_submit" />',
Chris@76: 				'align' => 'right',
Chris@76: 			),
Chris@76: 		),
Chris@76: 	);
Chris@76: 
Chris@76: 	// Create the request list.
Chris@76: 	createList($listOptions);
Chris@76: 
Chris@76: 	$context['default_list'] = 'group_request_list';
Chris@76: }
Chris@76: 
Chris@76: function list_getGroupRequestCount($where, $where_parameters)
Chris@76: {
Chris@76: 	global $smcFunc;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT COUNT(*)
Chris@76: 		FROM {db_prefix}log_group_requests AS lgr
Chris@76: 		WHERE ' . $where,
Chris@76: 		array_merge($where_parameters, array(
Chris@76: 		))
Chris@76: 	);
Chris@76: 	list ($totalRequests) = $smcFunc['db_fetch_row']($request);
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $totalRequests;
Chris@76: }
Chris@76: 
Chris@76: function list_getGroupRequests($start, $items_per_page, $sort, $where, $where_parameters)
Chris@76: {
Chris@76: 	global $smcFunc, $txt, $scripturl;
Chris@76: 
Chris@76: 	$request = $smcFunc['db_query']('', '
Chris@76: 		SELECT lgr.id_request, lgr.id_member, lgr.id_group, lgr.time_applied, lgr.reason,
Chris@76: 			mem.member_name, mg.group_name, mg.online_color, mem.real_name
Chris@76: 		FROM {db_prefix}log_group_requests AS lgr
Chris@76: 			INNER JOIN {db_prefix}members AS mem ON (mem.id_member = lgr.id_member)
Chris@76: 			INNER JOIN {db_prefix}membergroups AS mg ON (mg.id_group = lgr.id_group)
Chris@76: 		WHERE ' . $where . '
Chris@76: 		ORDER BY {raw:sort}
Chris@76: 		LIMIT ' . $start . ', ' . $items_per_page,
Chris@76: 		array_merge($where_parameters, array(
Chris@76: 			'sort' => $sort,
Chris@76: 		))
Chris@76: 	);
Chris@76: 	$group_requests = array();
Chris@76: 	while ($row = $smcFunc['db_fetch_assoc']($request))
Chris@76: 	{
Chris@76: 		$group_requests[] = array(
Chris@76: 			'id' => $row['id_request'],
Chris@76: 			'member_link' => '<a href="' . $scripturl . '?action=profile;u=' . $row['id_member'] . '">' . $row['real_name'] . '</a>',
Chris@76: 			'group_link' => '<span style="color: ' . $row['online_color'] . '">' . $row['group_name'] . '</span>',
Chris@76: 			'reason' => censorText($row['reason']),
Chris@76: 			'time_submitted' => timeformat($row['time_applied']),
Chris@76: 		);
Chris@76: 	}
Chris@76: 	$smcFunc['db_free_result']($request);
Chris@76: 
Chris@76: 	return $group_requests;
Chris@76: }
Chris@76: 
Chris@76: ?>