$sql = 'UPDATE ' . USERS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . "

WHERE user_id = $user_id";

$db->sql_query($sql);

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

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

'update' => true))

);

}

break;

case 'moveposts':

if (!check_form_key($form_name))

{

$quick_tool_ary += array('active' => (($user_row['user_type'] == USER_INACTIVE) ? 'ACTIVATE' : 'DEACTIVATE'));

}

$quick_tool_ary += array('delsig' => 'DEL_SIG', 'delavatar' => 'DEL_AVATAR', 'moveposts' => 'MOVE_POSTS', 'delposts' => 'DEL_POSTS', 'delattach' => 'DEL_ATTACH');

if ($config['email_enable'] && ($user_row['user_type'] == USER_NORMAL || $user_row['user_type'] == USER_INACTIVE))

{

$quick_tool_ary['reactivate'] = 'FORCE';

case 'feedback':

$user->add_lang('mcp');

// Set up general vars

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

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

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

}

// Sorting

$limit_days = array(0 => $user->lang['ALL_ENTRIES'], 1 => $user->lang['1_DAY'], 7 => $user->lang['7_DAYS'], 14 => $user->lang['2_WEEKS'], 30 => $user->lang['1_MONTH'], 90 => $user->lang['3_MONTHS'], 180 => $user->lang['6_MONTHS'], 365 => $user->lang['1_YEAR']);

$sort_by_text = array('u' => $user->lang['SORT_USERNAME'], 't' => $user->lang['SORT_DATE'], 'i' => $user->lang['SORT_IP'], 'o' => $user->lang['SORT_ACTION']);

'S_BIRTHDAY_DAY_OPTIONS' => $s_birthday_day_options,

'S_BIRTHDAY_MONTH_OPTIONS' => $s_birthday_month_options,

'S_BIRTHDAY_YEAR_OPTIONS' => $s_birthday_year_options,

'S_PROFILE' => true)

);

$s_custom = false;

$dateformat_options .= '<option value="custom"';

{

$dateformat_options .= ' selected="selected"';

$s_custom = true;

$template->assign_vars(array(

'S_PREFS' => true,

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

'VIEW_EMAIL' => $data['viewemail'],

'MASS_EMAIL' => $data['massemail'],

'ALLOW_PM' => $data['allowpm'],

'VIEW_SIGS' => $data['view_sigs'],

'VIEW_AVATARS' => $data['view_avatars'],

'VIEW_WORDCENSOR' => $data['view_wordcensor'],

'S_TOPIC_SORT_DAYS' => $s_limit_topic_days,

'S_TOPIC_SORT_KEY' => $s_sort_topic_key,

'S_TOPIC_SORT_DIR' => $s_sort_topic_dir,

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

}

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

WHERE rank_special = 1

);

break;

case 'sig':

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

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

// Allowing Quote BBCode

$message_parser->parse($enable_bbcode, $enable_urls, $enable_smilies, $config['allow_sig_img'], $config['allow_sig_flash'], true, $config['allow_sig_links'], true, 'sig');

if (sizeof($message_parser->warn_msg))

{

$error[] = implode('<br />', $message_parser->warn_msg);

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

}

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

$error = preg_replace('#^([A-Z_]+)$#e', "(!empty(\$user->lang['\\1'])) ? \$user->lang['\\1'] : '\\1'", $error);

}

$signature_preview = '';

if ($preview)

{

// Now parse it for displaying

'ATTACH_ID' => $row['attach_id'],

'POST_ID' => $row['post_msg_id'],

'TOPIC_ID' => $row['topic_id'],

'S_IN_MESSAGE' => $row['in_message'],

'U_DOWNLOAD' => append_sid("{$phpbb_root_path}download/file.$phpEx", 'mode=view&amp;id=' . $row['attach_id']),

);

}

$db->sql_freeresult($result);

$template->assign_vars(array(

'S_ATTACHMENTS' => true,

'S_ON_PAGE' => on_page($num_attachments, $config['topics_per_page'], $start),

);

break;

case 'groups':

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

$user->add_lang(array('groups', 'acp/groups'));

$group_id = request_var('g', 0);

if ($group_id)

{

// Check the founder only entry for this group to make sure everything is well

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

$founder_manage = (int) $db->sql_fetchfield('group_founder_manage');

$db->sql_freeresult($result);

if ($user->data['user_type'] != USER_FOUNDER && $founder_manage)

{

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

{

$founder_manage = 0;

}

switch ($action)

{

case 'demote':

{

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

}

$error = array();

}

else

'g' => $group_id))

);

}

break;

}

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

$hold_ary = array();

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

{

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

'U_USER_PERMISSIONS' => append_sid("{$phpbb_admin_path}index.$phpEx" ,'i=permissions&amp;mode=setting_user_global&amp;user_id[]=' . $user_id),

'U_USER_FORUM_PERMISSIONS' => append_sid("{$phpbb_admin_path}index.$phpEx", 'i=permissions&amp;mode=setting_user_local&amp;user_id[]=' . $user_id))

);

break;

}