{

$sql = 'SELECT user_id

FROM ' . USERS_TABLE . "

if (!$user_id)

{

LEFT JOIN ' . SESSIONS_TABLE . ' s ON (s.session_user_id = u.user_id)

WHERE u.user_id = ' . $user_id . '

ORDER BY s.session_time DESC';

if (!$user_row)

{

AND module_enabled = 1

AND module_class = 'acp'

ORDER BY left_id, module_mode";

$dropdown_modes = array();

{

if (!$this->p_master->module_auth($row['module_auth']))

{

$dropdown_modes[$row['module_mode']] = true;

}

foreach ($dropdown_modes as $module_mode => $null)

{

$sql = 'SELECT DISTINCT poster_ip

FROM ' . POSTS_TABLE . "

WHERE poster_id = $user_id";

{

$ban[] = $row['poster_ip'];

}

$reason = 'USER_ADMIN_BAN_IP_REASON';

$log = 'LOG_USER_BAN_IP';

user_active_flip('deactivate', $user_id, INACTIVE_REMIND);

$sql = 'UPDATE ' . USERS_TABLE . "

WHERE user_id = $user_id";

}

else

{

$sql = 'SELECT user_actkey

FROM ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

$messenger = new messenger(false);

'user_sig_bbcode_bitfield' => ''

);

WHERE user_id = $user_id";

add_log('admin', 'LOG_USER_DEL_SIG', $user_row['username']);

add_log('user', $user_id, 'LOG_USER_DEL_SIG_USER');

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = $user_id";

// Delete old avatar if present

if ($user_row['user_avatar'] && $user_row['user_avatar_type'] != AVATAR_GALLERY)

$sql = 'SELECT forum_name, forum_type

FROM ' . FORUMS_TABLE . "

WHERE forum_id = $new_forum_id";

if (!$forum_info)

{

WHERE poster_id = $user_id

AND forum_id <> $new_forum_id

GROUP BY topic_id";

{

$topic_id_ary[$row['topic_id']] = $row['total_posts'];

}

if (sizeof($topic_id_ary))

{

$sql = 'SELECT topic_id, forum_id, topic_title, topic_replies, topic_replies_real, topic_attachment

FROM ' . TOPICS_TABLE . '

{

if (max($row['topic_replies'], $row['topic_replies_real']) + 1 == $topic_id_ary[$row['topic_id']])

{

$forum_id_ary[] = $row['forum_id'];

}

}

// Entire topic comprises posts by this user, move these topics

foreach ($move_post_ary as $topic_id => $post_ary)

{

// Create new topic

'topic_poster' => $user_id,

'topic_time' => time(),

'forum_id' => $new_forum_id,

'topic_time_limit' => 0,

'topic_attachment' => $post_ary['attach'])

);

// Move posts

$sql = 'UPDATE ' . POSTS_TABLE . "

SET forum_id = $new_forum_id, topic_id = $new_topic_id

WHERE topic_id = $topic_id

AND poster_id = $user_id";

if ($post_ary['attach'])

{

SET topic_id = $new_topic_id

WHERE topic_id = $topic_id

AND poster_id = $user_id";

}

$new_topic_id_ary[] = $new_topic_id;

FROM ' . USERS_TABLE . '

WHERE user_type = ' . phpbb::USER_FOUNDER . '

AND user_id <> ' . $user_id;

if ($row)

{

if (sizeof($sql_ary))

{

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

}

if ($update_username)

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

FROM ' . SESSIONS_TABLE . "

WHERE session_user_id = $user_id";

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

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

FROM ' . POSTS_TABLE . '

WHERE poster_id = ' . $user_id . '

AND post_approved = 0';

$template->assign_vars(array(

'L_NAME_CHARS_EXPLAIN' => sprintf(phpbb::$user->lang[phpbb::$config['allow_name_chars'] . '_EXPLAIN'], phpbb::$config['min_name_chars'], phpbb::$config['max_name_chars']),

{

$sql_in[] = $mark;

}

unset($sql_in);

}

$sql = 'DELETE FROM ' . LOG_TABLE . '

WHERE log_type = ' . LOG_USERS . "

$where_sql";

add_log('admin', 'LOG_CLEAR_USER', $user_row['username']);

}

$sql = 'SELECT lang_id

FROM ' . LANG_TABLE . "

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

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = $user_id";

// Update Custom Fields

if (sizeof($cp_data))

{

{

case 'oracle':

case 'firebird':

}

$sql = 'UPDATE ' . PROFILE_FIELDS_DATA_TABLE . '

WHERE user_id = $user_id";

{

$cp_data['user_id'] = (int) $user_id;

}

}

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = $user_id";

trigger_error(phpbb::$user->lang['USER_PREFS_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

$sql = 'UPDATE ' . USERS_TABLE . "

SET user_rank = $rank_id

WHERE user_id = $user_id";

trigger_error(phpbb::$user->lang['USER_RANK_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

FROM ' . RANKS_TABLE . '

WHERE rank_special = 1

ORDER BY rank_title';

$s_rank_options = '<option value="0"' . ((!$user_row['user_rank']) ? ' selected="selected"' : '') . '>' . phpbb::$user->lang['NO_SPECIAL_RANK'] . '</option>';

{

$selected = ($user_row['user_rank'] && $row['rank_id'] == $user_row['user_rank']) ? ' selected="selected"' : '';

$s_rank_options .= '<option value="' . $row['rank_id'] . '"' . $selected . '>' . $row['rank_title'] . '</option>';

}

$template->assign_vars(array(

'S_RANK' => true,

);

$sql = 'UPDATE ' . USERS_TABLE . '

WHERE user_id = ' . $user_id;

trigger_error(phpbb::$user->lang['USER_SIG_UPDATED'] . adm_back_link($this->u_action . '&amp;u=' . $user_id));

}

FROM ' . ATTACHMENTS_TABLE . '

WHERE poster_id = ' . $user_id . '

AND is_orphan = 0

$marked = array();

{

$marked[] = $row['attach_id'];

}

}

if ($deletemark && sizeof($marked))

{

$sql = 'SELECT real_filename

FROM ' . ATTACHMENTS_TABLE . '

$log_attachments = array();

{

$log_attachments[] = $row['real_filename'];

}

delete_attachments('attach', $marked);

FROM ' . ATTACHMENTS_TABLE . "

WHERE poster_id = $user_id

AND is_orphan = 0";

$sql = 'SELECT a.*, t.topic_title, p.message_subject as message_title

FROM ' . ATTACHMENTS_TABLE . ' a

WHERE a.poster_id = ' . $user_id . "

AND a.is_orphan = 0

ORDER BY $order_by";

{

if ($row['in_message'])

{

'U_VIEW_TOPIC' => $view_topic)

);

}

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

$sql = 'SELECT group_founder_manage

FROM ' . GROUPS_TABLE . '

WHERE group_id = ' . $group_id;

if (!phpbb::$user->is_founder && $founder_manage)

{

WHERE ug.user_id = $user_id

AND g.group_id = ug.group_id

ORDER BY g.group_type DESC, ug.user_pending ASC, g.group_name";

$i = 0;

$group_data = $id_ary = array();

{

$type = ($row['group_type'] == GROUP_SPECIAL) ? 'special' : (($row['user_pending']) ? 'pending' : 'normal');

$i++;

}

// Select box for other groups

$sql = 'SELECT group_id, group_name, group_type, group_founder_manage

FROM ' . GROUPS_TABLE . '

ORDER BY group_type DESC, group_name ASC';

$s_group_options = '';

{

if (!phpbb::$config['coppa_enable'] && $row['group_name'] == 'REGISTERED_COPPA')

{

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

}

$current_type = '';

foreach ($group_data as $group_type => $data_ary)

// Select auth options

$sql = 'SELECT auth_option, is_local, is_global

FROM ' . ACL_OPTIONS_TABLE . '

AND is_global = 1

ORDER BY auth_option';

$hold_ary = array();

{

$hold_ary = $auth_admin->get_mask('view', $user_id, false, false, $row['auth_option'], 'global', phpbb::ACL_NEVER);

$auth_admin->display_mask('view', $row['auth_option'], $hold_ary, 'user', false, false);

}

unset($hold_ary);

}

{

$sql = 'SELECT auth_option, is_local, is_global

FROM ' . ACL_OPTIONS_TABLE . "

AND is_local = 1

ORDER BY is_global DESC, auth_option";

{

$hold_ary = $auth_admin->get_mask('view', $user_id, false, $forum_id, $row['auth_option'], 'local', phpbb::ACL_NEVER);

$auth_admin->display_mask('view', $row['auth_option'], $hold_ary, 'user', true, false);

}

}

$s_forum_options = '<option value="0"' . ((!$forum_id) ? ' selected="selected"' : '') . '>' . phpbb::$user->lang['VIEW_GLOBAL_PERMS'] . '</option>';