$sql = 'SELECT group_id

FROM ' . GROUPS_TABLE . "

WHERE group_name = 'ADMINISTRATORS'";

// Get group memberships for the admin id ary...

$admin_memberships = group_memberships($admin_group_id, $admin_id_ary);

$sql = 'SELECT forum_id, forum_name

FROM ' . FORUMS_TABLE;

$forums = array();

{

$forums[$row['forum_id']] = $row['forum_name'];

}

'SELECT' => 'u.user_id, u.group_id as default_group, u.username, u.username_clean, u.user_colour, u.user_rank, u.user_posts, u.user_allow_pm, g.group_id, g.group_name, g.group_colour, g.group_type, ug.user_id as ug_user_id',

'FROM' => array(

)

),

AND u.group_id = g.group_id',

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

));

{

$which_row = (in_array($row['user_id'], $admin_id_ary)) ? 'admin' : 'mod';

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

));

}

$template->assign_vars(array(

'PM_IMG' => phpbb::$user->img('icon_contact_pm', phpbb::$user->lang['SEND_PRIVATE_MESSAGE']))

FROM " . USERS_TABLE . "

WHERE user_id = $user_id

AND user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')';

if (!$row)

{

// Get user...

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

if (!$member)

{

AND g.group_id = ug.group_id" . ((!phpbb::$acl->acl_gets('a_group', 'a_groupadd', 'a_groupdel')) ? ' AND g.group_type <> ' . GROUP_HIDDEN : '') . '

AND ug.user_pending = 0

ORDER BY g.group_type, g.group_name';

$group_options = '';

{

$group_options .= '<option value="' . $row['group_id'] . '"' . (($row['group_id'] == $member['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

// What colour is the zebra

$sql = 'SELECT friend, foe

WHERE zebra_id = ' . $user_id . '

AND user_id = ' . phpbb::$user->data['user_id'];

$foe = ($row['foe']) ? true : false;

$friend = ($row['friend']) ? true : false;

if (phpbb::$config['load_onlinetrack'])

{

$sql = 'SELECT MAX(session_time) AS session_time, MIN(session_viewonline) AS session_viewonline

FROM ' . SESSIONS_TABLE . "

WHERE session_user_id = $user_id";

$member['session_time'] = (isset($row['session_time'])) ? $row['session_time'] : 0;

$member['session_viewonline'] = (isset($row['session_viewonline'])) ? $row['session_viewonline'] : 0;

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

AND post_approved = 0';

}

else

{

FROM ' . USERS_TABLE . "

WHERE user_id = $user_id

AND user_type IN (" . phpbb::USER_NORMAL . ', ' . phpbb::USER_FOUNDER . ')';

if (!$row)

{

$sql = 'SELECT forum_id, topic_title

FROM ' . TOPICS_TABLE . "

WHERE topic_id = $topic_id";

if (!$row)

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET user_emailtime = ' . time() . '

WHERE user_id = ' . phpbb::$user->data['user_id'];

include_once(PHPBB_ROOT_PATH . 'includes/functions_messenger.' . PHP_EXT);

$messenger = new messenger(false);

$s_find_active_time .= '<option value="' . $key . '"' . $selected . '>' . $value . '</option>';

}

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

$sql_where .= (sizeof($joined) > 1) ? " AND u.user_regdate " . $find_key_match[$joined_select] . ' ' . gmmktime(0, 0, 0, intval($joined[1]), intval($joined[2]), intval($joined[0])) : '';

$sql_where .= (phpbb::$acl->acl_get('u_viewonline') && sizeof($active) > 1) ? " AND u.user_lastvisit " . $find_key_match[$active_select] . ' ' . gmmktime(0, 0, 0, $active[1], intval($active[2]), intval($active[0])) : '';

}

else

{

}

if ($ips === false)

FROM ' . POSTS_TABLE . '

WHERE poster_ip ' . ((strpos($ips, '%') !== false) ? 'LIKE' : 'IN') . " ($ips)

AND forum_id IN (0, " . implode(', ', $ip_forums) . ')';

{

$ip_sql = array();

do

{

$ip_sql[] = $row['poster_id'];

}

}

else

{

}

unset($ip_forums);

}

}

}

{

for ($i = 97; $i < 123; $i++)

{

}

}

else if ($first_char)

{

}

// Are we looking at a usergroup? If so, fetch additional info

FROM ' . GROUPS_TABLE . ' g

LEFT JOIN ' . USER_GROUP_TABLE . ' ug ON (ug.user_pending = 0 AND ug.user_id = ' . phpbb::$user->data['user_id'] . " AND ug.group_id = $group_id)

WHERE g.group_id = $group_id";

if (!$group_row)

{

FROM ' . USERS_TABLE . " u$sql_from

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

$sql_where";

}

else

{

$sql .= ' ORDER BY g.group_name ASC';

}

{

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

$s_group_select .= '<option value="' . $row['group_id'] . '"' . (($group_selected == $row['group_id']) ? ' selected="selected"' : '') . '>' . (($row['group_type'] == GROUP_SPECIAL) ? phpbb::$user->lang['G_' . $row['group_name']] : $row['group_name']) . '</option>';

}

if ($group_selected !== 0 && !in_array($group_selected, $group_ids))

{

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

$sql_where

ORDER BY $order_by";

$user_list = array();

{

$user_list[] = (int) $row['user_id'];

}

$leaders_set = false;

// So, did we get any users?

if (sizeof($user_list))

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

FROM ' . SESSIONS_TABLE . '

WHERE session_time >= ' . (time() - phpbb::$config['session_length']) . '

GROUP BY session_user_id';

$session_times = array();

{

$session_times[$row['session_user_id']] = $row['session_time'];

}

// Do the SQL thang

if ($mode == 'group')

$sql_select

FROM " . USERS_TABLE . " u

$sql_from

$sql_where_data";

}

else

{

$sql = 'SELECT *

FROM ' . USERS_TABLE . '

}

$id_cache = array();

{

$row['session_time'] = (!empty($session_times[$row['user_id']])) ? $session_times[$row['user_id']] : 0;

$row['last_visit'] = (!empty($row['session_time'])) ? $row['session_time'] : $row['user_lastvisit'];

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

}

// Load custom profile fields

if (phpbb::$config['load_cpf_memberlist'])