include($phpbb_root_path . 'common.' . $phpEx);

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

if ($mode === 'contactadmin')

{

$template->assign_var('S_IN_MEMBERLIST', true);

// Grab data

// Redirect when old mode is used

if ($mode == 'leaders')

{

if ($user->data['user_id'] != ANONYMOUS)

{

trigger_error('NO_VIEW_USERS');

}

break;

}

$submit = (isset($_POST['submit'])) ? true : false;

$default_key = 'c';

$user_types = array(USER_NORMAL, USER_FOUNDER);

if ($auth->acl_get('a_user'))

}

else

{

$row['u_group'] = append_sid("{$phpbb_root_path}memberlist.$phpEx", 'mode=group&g=' . $row['group_id']);

}

'LEFT_JOIN' => array(

array(

'FROM' => array(USERS_TABLE => 'u'),

),

array(

'FROM' => array(GROUPS_TABLE => 'g'),

),

),

'ORDER_BY' => 'u.username_clean ASC',

);

if (!$auth->acl_get('u_sendim'))

{

trigger_error('NOT_AUTHORISED');

}

include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

$subject = sprintf($user->lang['IM_JABBER_SUBJECT'], $user->data['username'], $config['server_name']);

if (empty($message))

{

}

// Get user...

$result = $db->sql_query($sql);

$member = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$sql_uid_ary = ($auth_hidden_groups) ? array($user_id) : array($user_id, (int) $user->data['user_id']);

// Do the SQL thang

// Divide data into profile data and current user data

$profile_groups = $user_groups = array();

$group_data = $group_sort = array();

foreach ($profile_groups as $row)

{

{

// Skip over hidden groups the user cannot see

continue;

}

$group_sort[$row['group_id']] = utf8_clean_string($row['group_name']);

$group_data[$row['group_id']] = $row;

}

unset($user_groups);

asort($group_sort);

$group_options = '';

foreach ($group_sort as $group_id => $null)

{

$profile_fields = array();

if ($config['load_cpf_viewprofile'])

{

$cp = $phpbb_container->get('profilefields.manager');

$profile_fields = $cp->grab_profile_fields_data($user_id);

$profile_fields = (isset($profile_fields[$user_id])) ? $cp->generate_profile_fields_template_data($profile_fields[$user_id]) : array();

$member['posts_in_queue'] = 0;

}

if (!empty($profile_fields['row']))

{

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

}

if ($user_id)

{

{

trigger_error('NO_EMAIL');

}

$form = $phpbb_container->get('message.form.' . $form_name);

$form->bind($request);

// The basic memberlist

$page_title = $user->lang['MEMBERLIST'];

$template_html = 'memberlist_body.html';

$pagination = $phpbb_container->get('pagination');

// Sorting

$sql_select = $sql_where_data = $sql_from = $sql_where = $order_by = '';

// Search URL parameters, if any of these are in the URL we do a search

$search_params = array('username', 'email', 'jabber', 'search_group_id', 'joined_select', 'active_select', 'count_select', 'joined', 'active', 'count', 'ip');

// We validate form and field here, only id/class allowed

$form = (!preg_match('/^[a-z0-9_-]+$/i', $form)) ? '' : $form;

$field = (!preg_match('/^[a-z0-9_-]+$/i', $field)) ? '' : $field;

{

// when using these, make sure that we actually have values defined in $find_key_match

$find_key_match = array('lt' => '<', 'gt' => '>', 'eq' => '=');

$sql_where .= ($jabber) ? ' AND u.user_jabber ' . $db->sql_like_expression(str_replace('*', $db->get_any_char(), $jabber)) . ' ' : '';

$sql_where .= (is_numeric($count) && isset($find_key_match[$count_select])) ? ' AND u.user_posts ' . $find_key_match[$count_select] . ' ' . (int) $count . ' ' : '';

{

$joined_time = gmmktime(0, 0, 0, (int) $joined[1], (int) $joined[2], (int) $joined[0]);

}

}

{

$active_time = gmmktime(0, 0, 0, (int) $active[1], (int) $active[2], (int) $active[0]);

if ($active_time !== false)

{

}

}

}

}

if ($first_char == 'other')

{

$avatar_img = phpbb_get_group_avatar($group_row);

// ... same for group rank

'title' => null,

'img' => null,

'img_src' => null,

);

if ($group_row['group_rank'])

{

{

}

}

// include modules for manage groups link display or not

$template->assign_vars(array(

'GROUP_DESC' => generate_text_for_display($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_bitfield'], $group_row['group_desc_options']),

'GROUP_COLOR' => $group_row['group_colour'],

'GROUP_TYPE' => $user->lang['GROUP_IS_' . $group_row['l_group_type']],

'AVATAR_IMG' => $avatar_img,

'U_PM' => ($auth->acl_get('u_sendpm') && $auth->acl_get('u_masspm_group') && $group_row['group_receive_pm'] && $config['allow_privmsg'] && $config['allow_mass_pm']) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=pm&amp;mode=compose&amp;g=' . $group_id) : '',

'U_MANAGE' => ($can_manage_group) ? append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=ucp_groups&amp;mode=manage') : false,)

// Build a relevant pagination_url

$params = $sort_params = array();

$check_params = array(

'g' => array('g', 0),

'sk' => array('sk', $default_key),

'count_select' => array('count_select', 'eq'),

'joined' => array('joined', ''),

'active' => array('active', ''),

'ip' => array('ip', ''),

'first_char' => array('first_char', ''),

);

continue;

}

// 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;

}

$sort_params[] = "mode=$mode";

$u_first_char_params = implode('&amp;', $u_first_char_params);

$u_first_char_params .= ($u_first_char_params) ? '&amp;' : '';

}

$first_characters['other'] = $user->lang['OTHER'];

foreach ($first_characters as $char => $desc)

{

'DESC' => $desc,

'VALUE' => $char,

'S_SELECTED' => ($first_char == $char) ? true : false,

'U_SORT' => append_sid("{$phpbb_root_path}memberlist.$phpEx", $u_first_char_params . 'first_char=' . $char) . '#memberlist',

}

// Some search user specific data

if (($mode == '' || $mode == 'searchuser') && ($config['load_search'] || $auth->acl_get('a_')))

{

$s_group_select = '<option value="0"' . ((!$group_selected) ? ' selected="selected"' : '') . '>&nbsp;</option>';

$group_ids = array();

while ($row = $db->sql_fetchrow($result))

{

$group_ids[] = $row['group_id'];

}

$db->sql_freeresult($result);

// Load custom profile fields

if ($config['load_cpf_memberlist'])

{

$cp = $phpbb_container->get('profilefields.manager');

$cp_row = $cp->generate_profile_fields_template_headlines('field_show_on_ml');

$leaders_set = false;

// So, did we get any users?

{

// Session time?! Session time...

$sql = 'SELECT session_user_id, MAX(session_time) AS session_time

// Do the SQL thang

if ($mode == 'group')

{

}

else

{

}

$result = $db->sql_query($sql);

$id_cache = array();

$id_cache[$row['user_id']] = $row;

}

$db->sql_freeresult($result);

if ($config['load_cpf_memberlist'])

{

// Grab all profile fields from users in id cache for later use - similar to the poster cache

}

// do we need to display contact fields as such

/**

* Modify list of users before member row is created

$vars = array('user_list', 'use_contact_fields');

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

{

$user_id = $user_list[$i];

$row = $id_cache[$user_id];

$memberrow = array_merge(phpbb_show_profile($row, false, false, false), array(

'ROW_NUMBER' => $i + ($start + 1),

'S_GROUP_LEADER' => $is_leader,

'S_INACTIVE' => $row['user_type'] == USER_INACTIVE,

'U_VIEW_PROFILE' => get_username_string('profile', $user_id, $row['username']),

));

{

$memberrow = array_merge($memberrow, $cp_row['row']);

}

$template->assign_block_vars('memberrow', $memberrow);

{

foreach ($cp_row['blockrow'] as $field_data)

{

$pagination->generate_template_pagination($pagination_url, 'pagination', 'start', $total_users, $config['topics_per_page'], $start);

// Generate page

'TOTAL_USERS' => $user->lang('LIST_USERS', (int) $total_users),

'PROFILE_IMG' => $user->img('icon_user_profile', $user->lang['PROFILE']),

'S_LEADERS_SET' => $leaders_set,

'S_MODE_SELECT' => $s_sort_key,

'S_ORDER_SELECT' => $s_sort_dir,

);

}

// Output the page