$user->add_lang(array('posting', 'ucp', 'acp/users'));

$this->tpl_name = 'acp_users';

$error = array();

$username = utf8_normalize_nfc(request_var('username', '', true));

trigger_error($user->lang['NOT_MANAGE_FOUNDER'] . adm_back_link($this->u_action), E_USER_WARNING);

}

switch ($mode)

{

case 'overview':

if ($submit)

{

{

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

{

trigger_error($user->lang['CANNOT_REMOVE_ANONYMOUS'] . adm_back_link($this->u_action . '&u=' . $user_id), E_USER_WARNING);

}

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

{

trigger_error($user->lang['CANNOT_REMOVE_YOURSELF'] . adm_back_link($this->u_action . '&u=' . $user_id), E_USER_WARNING);

{

if ($config['require_activation'] == USER_ACTIVATION_ADMIN)

{

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

$messenger = new messenger(false);

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

{

if ($topic_id_ary[$row['topic_id']][ITEM_APPROVED] == $row['topic_posts_approved']

{

$move_topic_ary[] = $row['topic_id'];

}

sync('forum', 'forum_id', $forum_id_ary, false, true);

}

add_log('admin', 'LOG_USER_MOVE_POSTS', $user_row['username'], $forum_info['forum_name']);

add_log('user', $user_id, 'LOG_USER_MOVE_POSTS_USER', $forum_info['forum_name']);

* @event core.acp_users_overview_run_quicktool

* @var array user_row Current user data

* @var string action Quick tool that should be run

*/

$vars = array('action', 'user_row');

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

$error[] = 'FORM_INVALID';

}

// Which updates do we need to do?

$update_username = ($user_row['username'] != $data['username']) ? $data['username'] : false;

$update_email = ($data['email'] != $user_row['user_email']) ? $data['email'] : false;

if (!sizeof($error))

* @var array user_row Current user data

* @var array data Submitted user data

* @var array sql_ary User data we udpate

*/

$vars = array('user_row', 'data', 'sql_ary');

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

if ($update_password)

{

$sql_ary += array(

'user_passchg' => time(),

'user_pass_convert' => 0,

);

* @event core.acp_users_display_overview

* @var array user_row Array with user data

* @var array quick_tool_ary Ouick tool options

*/

$vars = array('user_row', 'quick_tool_ary');

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

$s_action_options .= '<option value="' . $value . '">' . $user->lang['USER_ADMIN_' . $lang] . '</option>';

}

$inactive_reason = '';

if ($user_row['user_type'] == USER_INACTIVE)

$sql = 'SELECT COUNT(post_id) as posts_in_queue

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

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

$user_row['posts_in_queue'] = (int) $db->sql_fetchfield('posts_in_queue');

$db->sql_freeresult($result);

'U_SHOW_IP' => $this->u_action . "&amp;u=$user_id&amp;ip=" . (($ip == 'ip') ? 'hostname' : 'ip'),

'U_WHOIS' => $this->u_action . "&amp;action=whois&amp;user_ip={$user_row['user_ip']}",

'U_MCP_QUEUE' => ($auth->acl_getf_global('m_approve')) ? append_sid("{$phpbb_root_path}mcp.$phpEx", 'i=queue', true, $user->session_id) : '',

'U_SWITCH_PERMISSIONS' => ($auth->acl_get('a_switchperm') && $user->data['user_id'] != $user_row['user_id']) ? append_sid("{$phpbb_root_path}ucp.$phpEx", "mode=switch_perm&amp;u={$user_row['user_id']}&amp;hash=" . generate_link_hash('switchperm')) : '',

'USER' => $user_row['username'],

'USER_REGISTERED' => $user->format_date($user_row['user_regdate']),

'REGISTERED_IP' => ($ip == 'hostname') ? gethostbyaddr($user_row['user_ip']) : $user_row['user_ip'],

'USER_EMAIL' => $user_row['user_email'],

'USER_WARNINGS' => $user_row['user_warnings'],

'USER_POSTS' => $user_row['user_posts'],

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

$marked = request_var('mark', array(0));

$message = utf8_normalize_nfc(request_var('message', '', true));

// Sort keys

$sort_days = request_var('st', 0);

$start = view_log('user', $log_data, $log_count, $config['topics_per_page'], $start, 0, 0, $user_id, $sql_where, $sql_sort);

$base_url = $this->u_action . "&amp;u=$user_id&amp;$u_sort_param";

$template->assign_vars(array(

'S_FEEDBACK' => true,

'S_LIMIT_DAYS' => $s_limit_days,

'S_SORT_KEY' => $s_sort_key,

WHERE user_id = $user_id";

$db->sql_query($sql);

{

}

}

}

}

}

$template->assign_block_vars('warn', array(

'ID' => $row['warning_id'],

'USERNAME' => ($row['log_operation']) ? get_username_string('full', $row['mod_user_id'], $row['mod_username'], $row['mod_user_colour']) : '-',

case 'profile':

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

$cp_data = $cp_error = array();

$user_row['iso_lang_id'] = $row['lang_id'];

$data = array(

'jabber' => utf8_normalize_nfc(request_var('jabber', $user_row['user_jabber'], true)),

'bday_day' => 0,

'bday_month' => 0,

'bday_year' => 0,

$data['bday_year'] = request_var('bday_year', $data['bday_year']);

$data['user_birthday'] = sprintf('%2d-%2d-%4d', $data['bday_day'], $data['bday_month'], $data['bday_year']);

if ($submit)

{

$error = validate_data($data, array(

'jabber' => array(

array('string', true, 5, 255),

array('jabber')),

'bday_day' => array('num', true, 1, 31),

'bday_month' => array('num', true, 1, 12),

'bday_year' => array('num', true, 1901, gmdate('Y', time())),

if (!sizeof($error))

{

$sql_ary = array(

'user_jabber' => $data['jabber'],

'user_birthday' => $data['user_birthday'],

);

unset($now);

$template->assign_vars(array(

'JABBER' => $data['jabber'],

'S_BIRTHDAY_DAY_OPTIONS' => $s_birthday_day_options,

'S_BIRTHDAY_MONTH_OPTIONS' => $s_birthday_month_options,

'S_BIRTHDAY_YEAR_OPTIONS' => $s_birthday_year_options,

'hideonline' => request_var('hideonline', !$user_row['user_allow_viewonline']),

'notifymethod' => request_var('notifymethod', $user_row['user_notify_type']),

'notifypm' => request_var('notifypm', $user_row['user_notify_pm']),

'allowpm' => request_var('allowpm', $user_row['user_allow_pm']),

'topic_sk' => request_var('topic_sk', ($user_row['user_topic_sortby_type']) ? $user_row['user_topic_sortby_type'] : 't'),

'notify' => request_var('notify', $user_row['user_notify']),

);

if ($submit)

{

$error = validate_data($data, array(

if (!sizeof($error))

{

$this->optionset($user_row, 'viewimg', $data['view_images']);

$this->optionset($user_row, 'viewflash', $data['view_flash']);

$this->optionset($user_row, 'viewsmilies', $data['view_smilies']);

'user_notify' => $data['notify'],

);

{

{

}

}

// Replace "error" strings with their real, localised form

}

$timezone_selects = phpbb_timezone_select($user, $data['tz'], true);

'S_PREFS' => true,

'S_JABBER_DISABLED' => ($config['jab_enable'] && $user_row['user_jabber'] && @extension_loaded('xml')) ? false : true,

'NOTIFY_IM' => ($data['notifymethod'] == NOTIFY_IM) ? true : false,

'NOTIFY_BOTH' => ($data['notifymethod'] == NOTIFY_BOTH) ? true : false,

'NOTIFY_PM' => $data['notifypm'],

'BBCODE' => $data['bbcode'],

'SMILIES' => $data['smilies'],

'ATTACH_SIG' => $data['sig'],

'S_STYLE_OPTIONS' => style_select($data['style']),

'S_TZ_OPTIONS' => $timezone_selects['tz_select'],

'S_TZ_DATE_OPTIONS' => $timezone_selects['tz_dates'],

);

break;

case 'avatar':

$avatar_drivers = $phpbb_avatar_manager->get_enabled_drivers();

// This is normalised data, without the user_ prefix

if ($submit)

{

}

else

{

if ($driver)

{

$driver->delete($avatar_data);

$start = request_var('start', 0);

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

$marked = request_var('mark', array(0));

// Sort keys

$sort_key = request_var('sk', 'a');

WHERE a.poster_id = ' . $user_id . "

AND a.is_orphan = 0

ORDER BY $order_by";

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

{

$db->sql_freeresult($result);

$base_url = $this->u_action . "&amp;u=$user_id&amp;sk=$sort_key&amp;sd=$sort_dir";

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

'S_SORT_KEY' => $s_sort_key,

'S_SORT_DIR' => $s_sort_dir,

));

$error = array();

}

$sql = 'SELECT ug.*, g.*

FROM ' . GROUPS_TABLE . ' g, ' . USER_GROUP_TABLE . " ug

WHERE ug.user_id = $user_id