}

$db->sql_freeresult($result);

{

$sql = 'SELECT topic_id, forum_id, topic_title, topic_posts_approved, topic_posts_unapproved, topic_posts_softdeleted, topic_attachment

FROM ' . TOPICS_TABLE . '

}

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

{

move_topics($move_topic_ary, $new_forum_id, false);

}

{

// Create new topic

// Update post_ids, report_ids, attachment_ids

$forum_id_ary = array_unique($forum_id_ary);

$topic_id_ary = array_unique(array_merge(array_keys($topic_id_ary), $new_topic_id_ary));

{

sync('topic_reported', 'topic_id', $topic_id_ary);

sync('topic', 'topic_id', $topic_id_ary);

}

{

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

}

$update_password = $data['new_password'] && !$passwords_manager->check($data['new_password'], $user_row['user_password']);

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

{

$sql_ary = array();

));

}

{

$sql = 'UPDATE ' . USERS_TABLE . '

SET ' . $db->sql_build_array('UPDATE', $sql_ary) . '

{

$s_hidden_fields['delall'] = 1;

}

{

confirm_box(false, $user->lang['CONFIRM_OPERATION'], build_hidden_fields($s_hidden_fields));

}

{

// Check if there are more occurrences of % than arguments, if there are we fill out the arguments array

// It doesn't matter if we add more arguments than placeholders

{

}

$row['action'] = vsprintf($row['action'], $log_data_ary);

$row['action'] = bbcode_nl2br(censor_text($row['action']));

// validate custom profile fields

$cp->submit_cp_field('profile', $user_row['iso_lang_id'], $cp_data, $cp_error);

{

$error = array_merge($error, $cp_error);

}

$vars = array('data', 'user_id', 'user_row', 'error');

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

{

$sql_ary = array(

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

$error[] = 'FORM_INVALID';

}

{

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

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

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

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

{

$sql = 'UPDATE ' . USERS_TABLE . '

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

'sig'

);

{

$error += $warn_msg;

}

}

else

{

{

$this->optionset($user_row, 'sig_bbcode', $enable_bbcode);

$this->optionset($user_row, 'sig_smilies', $enable_smilies);

$sort_key = $request->variable('sk', 'a');

$sort_dir = $request->variable('sd', 'd');

{

$sql = 'SELECT attach_id

FROM ' . ATTACHMENTS_TABLE . '

$db->sql_freeresult($result);

}

{

if (confirm_box(true))

{

$attachment_manager->delete('attach', $marked);

unset($attachment_manager);

$phpbb_log->add('admin', $user->data['user_id'], $user->ip, 'LOG_ATTACHMENTS_DELETED', false, array(implode($user->lang['COMMA_SEPARATOR'], $log_attachments)));

trigger_error($message . adm_back_link($this->u_action . '&u=' . $user_id));

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

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

// Assign general variables

$template->assign_vars(array(

);

}