phpBB

Code Changes

File: memberlist.php

  Unmodified   Added   Modified   Removed
Line 89Line 89
$default_key = 'c';
$sort_key = request_var('sk', $default_key);
$sort_dir = request_var('sd', 'a');

$default_key = 'c';
$sort_key = request_var('sk', $default_key);
$sort_dir = request_var('sd', 'a');

 

$user_types = array(USER_NORMAL, USER_FOUNDER);
if ($auth->acl_get('a_user'))
{
$user_types[] = USER_INACTIVE;
}


// What do you want to do today? ... oops, I think that line is taken ...
switch ($mode)
{
case 'team':
// Display a listing of board admins, moderators


// What do you want to do today? ... oops, I think that line is taken ...
switch ($mode)
{
case 'team':
// Display a listing of board admins, moderators

 
		if (!function_exists('user_get_id_name'))
{

		include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

		include($phpbb_root_path . 'includes/functions_user.' . $phpEx);

 
		}


$page_title = $user->lang['THE_TEAM'];
$template_html = 'memberlist_team.html';


$page_title = $user->lang['THE_TEAM'];
$template_html = 'memberlist_team.html';

Line 834Line 843

$sql = 'SELECT username, user_id, user_colour
FROM ' . USERS_TABLE . '


$sql = 'SELECT username, user_id, user_colour
FROM ' . USERS_TABLE . '

			WHERE ' . $db->sql_in_set('user_type', array(USER_NORMAL, USER_FOUNDER)) . '

			WHERE ' . $db->sql_in_set('user_type', $user_types) . '

				AND username_clean ' . $db->sql_like_expression(utf8_clean_string($username_chars) . $db->get_any_char());
$result = $db->sql_query_limit($sql, 10);
$user_list = array();

				AND username_clean ' . $db->sql_like_expression(utf8_clean_string($username_chars) . $db->get_any_char());
$result = $db->sql_query_limit($sql, 10);
$user_list = array();

Line 1230Line 1239
		extract($phpbb_dispatcher->trigger_event('core.memberlist_modify_sql_query_data', compact($vars)));

// Count the users ...

		extract($phpbb_dispatcher->trigger_event('core.memberlist_modify_sql_query_data', compact($vars)));

// Count the users ...

		if ($sql_where)
{

 
			$sql = 'SELECT COUNT(u.user_id) AS total_users
FROM ' . USERS_TABLE . " u$sql_from

			$sql = 'SELECT COUNT(u.user_id) AS total_users
FROM ' . USERS_TABLE . " u$sql_from

				WHERE u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ")

			WHERE " . $db->sql_in_set('u.user_type', $user_types) . "

				$sql_where";
$result = $db->sql_query($sql);
$total_users = (int) $db->sql_fetchfield('total_users');
$db->sql_freeresult($result);

				$sql_where";
$result = $db->sql_query($sql);
$total_users = (int) $db->sql_fetchfield('total_users');
$db->sql_freeresult($result);

		}
else
{
$total_users = $config['num_users'];
}

 

// Build a relevant pagination_url
$params = $sort_params = array();


// Build a relevant pagination_url
$params = $sort_params = array();

Line 1279Line 1281
			}

$param = call_user_func_array('request_var', $call);

			}

$param = call_user_func_array('request_var', $call);

			$param = urlencode($key) . '=' . ((is_string($param)) ? urlencode($param) : $param);


			// Encode strings, convert everything else to int in order to prevent empty parameters.
$param = urlencode($key) . '=' . ((is_string($param)) ? urlencode($param) : (int) $param);

			$params[] = $param;

if ($key != 'first_char')

			$params[] = $param;

if ($key != 'first_char')

Line 1409Line 1412
			);
}


			);
}


		$user_types = array(USER_NORMAL, USER_FOUNDER);
if ($auth->acl_get('a_user'))
{
$user_types[] = USER_INACTIVE;
}

$start = $pagination->validate_start($start, $config['topics_per_page'], $config['num_users']);

		$start = $pagination->validate_start($start, $config['topics_per_page'], $total_users);








// Get us some users :D
$sql = "SELECT u.user_id


// Get us some users :D
$sql = "SELECT u.user_id