WHERE {$fields}_order = $switch_order_id

AND {$fields}_id <> $icon_id";

$db->sql_query($sql);

// Only update the other entry too if the previous entry got updated

{

$sql = "UPDATE $table

SET {$fields}_order = $switch_order_id

$cache->destroy('_icons');

$cache->destroy('sql', $table);

break;

}

$this->remove_cache_file();

}

break;

case 'quickadd':

{

global $db, $user, $auth, $template, $cache, $phpbb_container;

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

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

include_once($phpbb_root_path . 'includes/acp/auth.' . $phpEx);

$form_name = 'acp_permissions';

add_form_key($form_name);

switch ($mode)

{

case 'admin_roles':

{

case 'remove':

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

break;

case 'edit':

// Get role we edit

$sql = 'SELECT *

case 'edit':

if ($action == 'edit')

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

case 'move_up':

case 'move_down':

$order_total = $order * 2 + (($action == 'move_up') ? -1 : 1);

$sql = 'UPDATE ' . ACL_ROLES_TABLE . '

AND role_order IN ($order, " . (($action == 'move_up') ? $order - 1 : $order + 1) . ')';

$db->sql_query($sql);

break;

}

'U_EDIT' => $this->u_action . '&amp;action=edit&amp;role_id=' . $row['role_id'],

'U_REMOVE' => $this->u_action . '&amp;action=remove&amp;role_id=' . $row['role_id'],

'U_DISPLAY_ITEMS' => ($row['role_id'] == $display_item) ? '' : $this->u_action . '&amp;display_item=' . $row['role_id'] . '#assigned_to')

);

$this->tpl_name = 'acp_profile';

$this->page_title = 'ACP_CUSTOM_PROFILE_FIELDS';

$action = (isset($_POST['create'])) ? 'create' : request_var('action', '');

$error = array();

$s_hidden_fields = '';

// Define some default values for each field type

$default_values = array(

FIELD_STRING => array('field_length' => 10, 'field_minlen' => 0, 'field_maxlen' => 20, 'field_validation' => '.*', 'field_novalue' => '', 'field_default_value' => ''),

switch ($action)

{

case 'delete':

if (confirm_box(true))

{

break;

case 'activate':

$sql = 'SELECT lang_id

FROM ' . LANG_TABLE . "

break;

case 'deactivate':

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

SET field_active = 0

case 'move_up':

case 'move_down':

$order_total = $field_order * 2 + (($action == 'move_up') ? -1 : 1);

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

WHERE field_order IN ($field_order, " . (($action == 'move_up') ? $field_order - 1 : $field_order + 1) . ')';

$db->sql_query($sql);

break;

case 'create':

case 'edit':

$step = request_var('step', 1);

$submit = (isset($_REQUEST['next']) || isset($_REQUEST['prev'])) ? true : false;

// We are editing... we need to grab basic things

if ($action == 'edit')

{

$sql = 'SELECT l.*, f.*

FROM ' . PROFILE_LANG_TABLE . ' l, ' . PROFILE_FIELDS_TABLE . ' f

WHERE l.lang_id = ' . $this->edit_lang_id . "

'U_EDIT' => $this->u_action . "&amp;action=edit&amp;field_id=$id",

'U_TRANSLATE' => $this->u_action . "&amp;action=edit&amp;field_id=$id&amp;step=3",

'U_DELETE' => $this->u_action . "&amp;action=delete&amp;field_id=$id",

'S_NEED_EDIT' => $s_need_edit)

);

{

global $db, $user, $auth, $template, $cache;

global $config, $phpbb_root_path, $phpbb_admin_path, $phpEx;

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

case 'move_up':

case 'move_down':

$order_total = $order * 2 + (($action == 'move_up') ? -1 : 1);

$sql = 'UPDATE ' . REPORTS_REASONS_TABLE . '

WHERE reason_order IN (' . $order . ', ' . (($action == 'move_up') ? $order - 1 : $order + 1) . ')';

$db->sql_query($sql);

break;

}

'U_EDIT' => $this->u_action . '&amp;action=edit&amp;id=' . $row['reason_id'],

'U_DELETE' => (!$other_reason) ? $this->u_action . '&amp;action=delete&amp;id=' . $row['reason_id'] : '',

);

}

$db->sql_freeresult($result);

*/

function redirect($url, $return = false, $disable_cd_check = false)

{

$failover_flag = false;

// Relative uri

$pathinfo = pathinfo($url);

{

{

}

}

}

// Make sure no linebreaks are there... to prevent http response splitting for PHP < 4.4.2

}

$hidden_fields_for_jumpbox = phpbb_build_hidden_fields_for_query_params($request, array('f'));

// The following assigns all _common_ variables that may be used at any point in a template.

$template->assign_vars(array(

'UNREAD_NOTIFICATIONS_COUNT' => ($notifications !== false) ? $notifications['unread_count'] : '',

'NOTIFICATIONS_COUNT' => ($notifications !== false) ? $notifications['unread_count'] : '',

'U_VIEW_ALL_NOTIFICATIONS' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=ucp_notifications'),

'U_NOTIFICATION_SETTINGS' => append_sid("{$phpbb_root_path}ucp.$phpEx", 'i=ucp_notifications&amp;mode=notification_options'),

'S_NOTIFICATIONS_DISPLAY' => $config['load_notifications'],

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

'S_IS_ORPHAN' => $attach_row['is_orphan'],

'ASSOC_INDEX' => $count,

'U_VIEW_ATTACHMENT' => $download_link,

'S_HIDDEN' => $hidden)

/**

* Determine methods able to be used

*/

{

$methods = array();

$disabled_functions = explode(',', @ini_get('disable_functions'));

/**

* Requests data

*/

{

global $user;

/**

* Requests data

*/

{

global $user;

// Handle notifications

foreach ($post_info as $post_id => $post_data)

{

$phpbb_notifications->delete_notifications('post_in_queue', $post_id);

$phpbb_notifications->add_notifications(array(

$notify_poster = ($action == 'approve' && isset($_REQUEST['notify_poster'])) ? true : false;

$phpbb_content_visibility = $phpbb_container->get('content.visibility');

foreach ($topic_info as $topic_id => $topic_data)

{

$phpbb_content_visibility->set_topic_visibility(ITEM_APPROVED, $topic_id, $topic_data['forum_id'], $user->data['user_id'], time(), '');

$topic_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", "f={$topic_data['forum_id']}&amp;t={$topic_id}");

// Only send out the mails, when the posts are being approved

if ($action == 'approve')

{

// Handle notifications

$phpbb_notifications = $phpbb_container->get('notification_manager');

foreach ($topic_info as $topic_id => $topic_data)

{

$phpbb_notifications->add_notifications(array(

'quote',

'topic',

if ($notify_poster)

{

}

}

}

}

unset($close_report_posts, $close_report_topics);

foreach ($reports as $report)

{

if ($pm)

{

add_log('mod', 0, 0, 'LOG_PM_REPORT_' . strtoupper($action) . 'D', $post_info[$report['pm_id']]['message_subject']);

}

else

{

add_log('mod', $post_info[$report['post_id']]['forum_id'], $post_info[$report['post_id']]['topic_id'], 'LOG_REPORT_' . strtoupper($action) . 'D', $post_info[$report['post_id']]['post_subject']);

}

}

// Notify reporters

if (sizeof($notify_reporters))

{

foreach ($notify_reporters as $report_id => $reporter)

{

if ($reporter['user_id'] == ANONYMOUS)

'closer_id' => $user->data['user_id'],

'from_user_id' => $post_info[$post_id]['author_id'],

)));

}

else

{

'reporter' => $reporter['user_id'],

'closer_id' => $user->data['user_id'],

)));

}

}

}

'is_orphan' => 1,

'real_filename' => $filedata['real_filename'],

'attach_comment'=> $this->filename_data['filecomment'],

);

$this->attachment_data = array_merge(array(0 => $new_entry), $this->attachment_data);

'is_orphan' => 1,

'real_filename' => $filedata['real_filename'],

'attach_comment'=> $this->filename_data['filecomment'],

);

$this->attachment_data = array_merge(array(0 => $new_entry), $this->attachment_data);

if (isset($this->plupload) && $this->plupload->is_active())

{

// Send the client the attachment data to maintain state

}

}

}

if (sizeof($not_orphan))

{

// Get the attachment data, based on the poster id...

FROM ' . ATTACHMENTS_TABLE . '

WHERE ' . $db->sql_in_set('attach_id', array_keys($not_orphan)) . '

AND poster_id = ' . $check_user_id;

// Regenerate newly uploaded attachments

if (sizeof($orphan))

{

FROM ' . ATTACHMENTS_TABLE . '

WHERE ' . $db->sql_in_set('attach_id', array_keys($orphan)) . '

AND poster_id = ' . $user->data['user_id'] . '

$phpbb_notifications->mark_notifications_read(false, false, $user->data['user_id'], $form_time);

meta_refresh(3, $this->u_action);

trigger_error($message);

}

else