'ICON_MOVE_UP' => '<img src="' . PHPBB_ADMIN_PATH . 'images/icon_up.gif" alt="' . $user->lang['MOVE_UP'] . '" title="' . $user->lang['MOVE_UP'] . '" />',

'ICON_MOVE_UP_DISABLED' => '<img src="' . PHPBB_ADMIN_PATH . 'images/icon_up_disabled.gif" alt="' . $user->lang['MOVE_UP'] . '" title="' . $user->lang['MOVE_UP'] . '" />',

'ICON_MOVE_DOWN' => '<img src="' . PHPBB_ADMIN_PATH . 'images/icon_down.gif" alt="' . $user->lang['MOVE_DOWN'] . '" title="' . $user->lang['MOVE_DOWN'] . '" />',

'ICON_EDIT' => '<img src="' . PHPBB_ADMIN_PATH . 'images/icon_edit.gif" alt="' . $user->lang['EDIT'] . '" title="' . $user->lang['EDIT'] . '" />',

'ICON_EDIT_DISABLED' => '<img src="' . PHPBB_ADMIN_PATH . 'images/icon_edit_disabled.gif" alt="' . $user->lang['EDIT'] . '" title="' . $user->lang['EDIT'] . '" />',

'ICON_DELETE' => '<img src="' . PHPBB_ADMIN_PATH . 'images/icon_delete.gif" alt="' . $user->lang['DELETE'] . '" title="' . $user->lang['DELETE'] . '" />',

$mtime = explode(' ', microtime());

$totaltime = $mtime[0] + $mtime[1] - $starttime;

{

$db->sql_report('display');

}

case 'select':

case 'custom':

$return = '';

if (isset($vars['method']))

{

$args = array($new[$config_key], $key);

}

$return = call_user_func_array($call, $args);

if ($tpl_type[0] == 'select')

$type = 0;

$min = 1;

$max = 2;

foreach ($config_vars as $config_name => $config_definition)

{

if (!isset($cfg_array[$config_name]) || strpos($config_name, 'legend') !== false)

{

continue;

}

if (!isset($config_definition['validate']))

{

continue;

}

$validator = explode(':', $config_definition['validate']);

// Validate a bit. ;) (0 = type, 1 = min, 2= max)

function validate_range($value_ary, &$error)

{

global $user;

$column_types = array(

'BOOL' => array('php_type' => 'int', 'min' => 0, 'max' => 1),

'USINT' => array('php_type' => 'int', 'min' => 0, 'max' => 65535),

'UINT' => array('php_type' => 'int', 'min' => 0, 'max' => (int) 0x7fffffff),

'INT' => array('php_type' => 'int', 'min' => (int) 0x80000000, 'max' => (int) 0x7fffffff),

'TINT' => array('php_type' => 'int', 'min' => -128, 'max' => 127),

'VCHAR' => array('php_type' => 'string', 'min' => 0, 'max' => 255),

);

foreach ($value_ary as $value)

}

break;

$min = (isset($column[1])) ? max($column[1],$type['min']) : $type['min'];

$max = (isset($column[2])) ? min($column[2],$type['max']) : $type['max'];

if ($value['value'] < $min)

set_error_handler(defined('PHPBB_MSG_HANDLER') ? PHPBB_MSG_HANDLER : 'msg_handler');

// enforce the use of the request class

// Instantiate some basic classes

$user = new user();

<p class="good">// Use request var and define a default variable (use the correct type)</p>

<div class="codebox"><pre>

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

</pre></div>

<p class="bad">// $start is an int, the following use of request_var therefore is not allowed</p>

exit;

}

{

// worst-case default

$browser = (!empty($_SERVER['HTTP_USER_AGENT'])) ? htmlspecialchars((string) $_SERVER['HTTP_USER_AGENT']) : 'msie 6.0';

$config = phpbb_cache::obtain_config();

$avatar_group = false;

$exit = false;

/*if ($row['user_pass_convert'])

{

// in phpBB2 passwords were used exactly as they were sent, with addslashes applied

$password_old_format = isset($_REQUEST['password']) ? (string) $_REQUEST['password'] : '';

$password_old_format = (!STRIP) ? addslashes($password_old_format) : $password_old_format;

$password_new_format = '';

if ($disabled)

{

}

set_var($password_new_format, stripslashes($password_old_format), 'string');

$this->cookie_data = array('u' => 0, 'k' => '');

$this->update_session_page = $update_session_page;

{

$this->cookie_data['u'] = request_var(phpbb::$config['cookie_name'] . '_u', 0, false, true);

$this->cookie_data['k'] = request_var(phpbb::$config['cookie_name'] . '_k', '', false, true);

private function session_exist()

{

// If session is empty or does not match the session within the URL (if required - set by NEED_SID), then we need a new session

{

return false;

}

$this->add_lang($lang_set);

unset($lang_set);

{

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

$this->extra_url = array('style=' . $style);

{

global $cache, $starttime, $user;

{

return false;

}

}

/**

* compatability.

* function's use.

* compatability reasons.

*/

function request_var($var_name, $default, $multibyte = false, $cookie = false)

{

}

/**

}

else if ($config['load_anon_lastread'] || $user->data['is_registered'])

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

unset($tracking_topics['tf']);

$tracking_topics['l'] = base_convert(time() - $config['board_startdate'], 10, 36);

$user->set_cookie('track', tracking_serialize($tracking_topics), time() + 31536000);

unset($tracking_topics);

}

else if ($config['load_anon_lastread'] || $user->data['is_registered'])

{

$tracking = ($tracking) ? tracking_unserialize($tracking) : array();

foreach ($forum_id as $f_id)

}

$user->set_cookie('track', tracking_serialize($tracking), time() + 31536000);

unset($tracking);

}

}

else if ($config['load_anon_lastread'] || $user->data['is_registered'])

{

$tracking = ($tracking) ? tracking_unserialize($tracking) : array();

$topic_id36 = base_convert($topic_id, 10, 36);

// If the cookie grows larger than 10000 characters we will remove the smallest value

// This can result in old topics being unread - but most of the time it should be accurate...

{

//echo 'Cookie grown too large' . print_r($tracking, true);

}

$user->set_cookie('track', tracking_serialize($tracking), time() + 31536000);

}

return;

if (!isset($tracking_topics) || !sizeof($tracking_topics))

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

}

}

else if ($config['load_anon_lastread'] || $user->data['is_registered'])

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

if (!$user->data['is_registered'])

$timespan = ($config['form_token_lifetime'] == -1) ? -1 : max(30, $config['form_token_lifetime']);

}

{

$creation_time = abs(request_var('creation_time', 0));

$token = request_var('form_token', '');

{

global $user, $template, $db;

{

return false;

}

$confirm = false;

{

// language frontier

if (request_var('confirm', '') === $user->lang['YES'])

trigger_error('NO_AUTH_ADMIN');

}

{

// Get credential

if ($admin)

}

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

$admin = ($admin) ? 1 : 0;

$viewonline = ($admin) ? $user->data['session_viewonline'] : $viewonline;

$mtime = explode(' ', microtime());

$totaltime = $mtime[0] + $mtime[1] - $starttime;

{

$db->sql_report('display');

}

global $phpbb_hook, $config;

// needs to be run prior to the hook

{

}

if (!empty($phpbb_hook) && $phpbb_hook->call_hook(__FUNCTION__))

}

else if ($config['load_anon_lastread'] || $user->data['is_registered'])

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

if (!$user->data['is_registered'])

if (!is_null($notify_status) && $notify_status !== '')

{

{

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

if ($uid != $user_id)

$message = $user->lang['ERR_UNWATCHING'] . '<br /><br />' . sprintf($user->lang['RETURN_' . strtoupper($mode)], '<a href="' . $redirect_url . '">', '</a>');

trigger_error($message);

}

{

$is_watching = 0;

}

else

{

{

$token = request_var('hash', '');

$redirect_url = append_sid("view$mode", "$u_url=$match_id&amp;start=$start");

{

$is_watching = true;

}

else

{

{

login_box();

}

$forum_id = ($forum_id === false) ? $this->acl_forum_id : $forum_id;

$is_auth = false;

return $is_auth;

}

$msg_ids = request_var('marked_msg_id', array(0));

$cur_folder_id = request_var('cur_folder_id', PRIVMSGS_NO_BOX);

if (!sizeof($msg_ids))

{

WHERE ' . $db->sql_in_set('ug.group_id', array_keys($data['address_list']['g'])) . '

AND ug.user_pending = 0

AND u.user_id = ug.user_id

$sql_allow_pm;

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

{

case FIELD_DATE:

$field_validate = explode('-', $field_value);

$day = (isset($field_validate[0])) ? (int) $field_validate[0] : 0;

$month = (isset($field_validate[1])) ? (int) $field_validate[1] : 0;

$year = (isset($field_validate[2])) ? (int) $field_validate[2] : 0;

return 'FIELD_TOO_LARGE';

}

break;

case FIELD_DROPDOWN:

if ($field_value == $field_data['field_novalue'] && $field_data['field_required'])

{

return 'FIELD_REQUIRED';

}

break;

case FIELD_STRING:

case FIELD_TEXT:

if (empty($field_value) && !$field_data['field_required'])

global $db, $user, $auth;

$this->profile_cache = array();

// Display hidden/no_view fields for admin/moderator

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

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

case 'FIELD_TOO_SMALL':

$error = sprintf($user->lang[$cp_result], $row['lang_name'], $row['field_minlen']);

break;

case 'FIELD_TOO_LONG':

case 'FIELD_TOO_LARGE':

$error = sprintf($user->lang[$cp_result], $row['lang_name'], $row['field_maxlen']);

break;

case 'FIELD_INVALID_CHARS':

switch ($row['field_validation'])

{

}

break;

}

if ($error != '')

{

$cp_error[] = $error;

'S_PROFILE_' . strtoupper($ident) => true

);

}

return $tpl_fields;

}

else

// checkbox - only testing for isset

if ($profile_row['field_type'] == FIELD_BOOL && $profile_row['field_length'] == 2)

{

}

else if ($profile_row['field_type'] == FIELD_INT)

{

{

$value = (request_var($profile_row['field_ident'], '') === '') ? null : request_var($profile_row['field_ident'], $default_value);

}

}

else

{

if (gettype($value) == 'string')

{

$value = utf8_normalize_nfc($value);

$now = getdate();

{

if ($profile_row['field_default_value'] == 'now')

{

$profile_row['s_year_options'] .= '<option value="' . $i . '"' . (($i == $year) ? ' selected="selected"' : '') . ">$i</option>";

}

unset($now);

$profile_row['field_value'] = 0;

$template->assign_block_vars(self::$profile_types[$profile_row['field_type']], array_change_key_case($profile_row, CASE_UPPER));

}

$cp_data['pf_' . $row['field_ident']] = (in_array($row['field_type'], array(FIELD_TEXT, FIELD_STRING))) ? $row['lang_default_value'] : $row['field_default_value'];

}

$db->sql_freeresult($result);

return $cp_data;

}

private function get_profile_field($profile_row)

{

global $config;

$var_name = 'pf_' . $profile_row['field_ident'];

switch ($profile_row['field_type'])

{

case FIELD_DATE:

{

if ($profile_row['field_default_value'] == 'now')

{

$month = request_var($var_name . '_month', 0);

$year = request_var($var_name . '_year', 0);

}

$var = sprintf('%2d-%2d-%4d', $day, $month, $year);

break;

// Checkbox

if ($profile_row['field_length'] == 2)

{

}

else

{

break;

case FIELD_INT:

{

$var = NULL;

}

return $validate_options;

}

/**

* Get string options for second step in ACP

*/

$sql_ary['user_avatar'] = $category . '/' . $sql_ary['user_avatar'];

}

}

{

$sql_ary['user_avatar'] = '';

$sql_ary['user_avatar_type'] = $sql_ary['user_avatar_width'] = $sql_ary['user_avatar_height'] = 0;

$this->filename_data['filecomment'] = utf8_normalize_nfc(request_var('filecomment', '', true));

$upload_file = (isset($_FILES[$form_name]) && $_FILES[$form_name]['name'] != 'none' && trim($_FILES[$form_name]['name'])) ? true : false;

// First of all adjust comments if changed

$actual_comment_list = utf8_normalize_nfc(request_var('comment_list', array(''), true));

global $user, $db, $config;

$this->filename_data['filecomment'] = utf8_normalize_nfc(request_var('filecomment', '', true));

$this->attachment_data = array();

$check_user_id = ($check_user_id === false) ? $user->data['user_id'] : $check_user_id;

$this->p_master->error($lang['DEV_NO_TEST_FILE'], __LINE__, __FILE__);

}

$src_dbms = request_var('src_dbms', $convertor_data['dbms']);

$src_dbhost = request_var('src_dbhost', $convertor_data['dbhost']);

if (!$current_table && !$skip_rows)

{

{

// If avatars / ranks / smilies folders are specified make sure they are writable

$bad_folders = array();

));

return;

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

'S_LEGEND' => true,

$available_dbms = get_available_dbms(false, true);

// Has the user opted to test the connection?

{

if (!isset($available_dbms[$data['dbms']]) || !$available_dbms[$data['dbms']]['AVAILABLE'])

{

$data['default_lang'] = ($data['default_lang'] !== '') ? $data['default_lang'] : $data['language'];

{

$error = array();

}

}

{

// Do a basic check to make sure that the file has been uploaded

// Note that all we check is that the file has _something_ in it

{

// OK, so it didn't work let's try the alternatives

{

// They want a copy of the file to download, so send the relevant headers and dump out the data

header('Content-Type: text/x-delimtext; name="config.' . PHP_EXT . '"');

$this->include_file('includes/diff/renderer.' . PHP_EXT);

// Make sure we stay at the file check if checking the files again

{

$sub = $this->p_master->sub = 'file_check';

}

$action = request_var('action', '');

// We are directly within an update. To make sure our update list is correct we check its status.

$modified = ($update_list !== false) ? @filemtime($cache->cache_dir . 'data_update_list.' . PHP_EXT) : 0;

// Make sure the list is up-to-date

// Choose FTP, if not available use fsock...

$method = basename(request_var('method', ''));

$test_ftp_connection = request_var('test_connection', '');

if (!$method || !class_exists($method))

login_box('', $user->lang['LOGIN_EXPLAIN_MCP']);

}

$action = request_var('action', '');

$action_ary = request_var('action', array('' => 0));

$forum_action = request_var('forum_action', '');

{

$action = key($action_ary);

}

{

$action = $forum_action;

}

}

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

$default_key = 'c';

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

$email_lang = request_var('lang', $config['default_lang']);

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

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

if ($submit)

{

// We validate form and field here, only id/class allowed

$form = (!preg_match('/^[a-z0-9_-]+$/i', $form)) ? '' : $form;

$field = (!preg_match('/^[a-z0-9_-]+$/i', $field)) ? '' : $field;

{

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

$email = strtolower(request_var('email', ''));

foreach ($check_params as $key => $call)

{

{

continue;

}

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

$error = $notify = array();

$action = request_var('action', '');

$form_key = 'acp_attach';

);

$this->new_config = $config;

$error = array();

// We validate the complete config if whished

{

$l_explain = (isset($user->lang[$vars['lang'] . '_EXPLAIN'])) ? $user->lang[$vars['lang'] . '_EXPLAIN'] : '';

}

$content = build_cfg_template($type, $config_key, $this->new_config, $config_key, $vars);

if (empty($content))

{

case 'extensions':

{

if ($submit)

{

// Add Extension?

$add_extension = strtolower(request_var('add_extension', ''));

$add_extension_group = request_var('add_group_select', 0);

if ($add_extension && $add)

{

$template->assign_vars(array(

'S_EXTENSIONS' => true,

'ADD_EXTENSION' => (isset($add_extension)) ? $add_extension : '',

);

$sql = 'SELECT *

$size_select = request_var('size_select', 'b');

$forum_select = request_var('forum_select', false);

$allowed_forums = request_var('allowed_forums', array(0));

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

$max_filesize = ($size_select == 'kb') ? round($max_filesize * 1024) : (($size_select == 'mb') ? round($max_filesize * 1048576) : $max_filesize);

if ($max_filesize == $config['max_filesize'])

{

);

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

switch ($action)

{

if ($submit)

{

$post_ids = request_var('post_id', array('' => 0));

if (sizeof($delete_files))

{

global $db, $user;

{

// Grab the list of entries

$ips = request_var('ips', '');

$ip_list = array_unique(explode("\n", $ips));

$ip_list_log = implode(', ', $ip_list);

$iplist = array();

$hostlist = array();

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

}

{

$unip_sql = request_var('unip', array(0));

include(PHPBB_ROOT_PATH . 'includes/functions_user.' . PHP_EXT);

$current_time = time();

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

'L_NO_BAN_CELL' => $l_no_ban_cell,

'S_USERNAME_BAN' => ($mode == 'user') ? true : false,

'U_ACTION' => $this->u_action,

'U_FIND_USERNAME' => append_sid('memberlist', 'mode=searchuser&amp;form=acp_ban&amp;field=ban'),

));

$user->add_lang('acp/board');

$action = request_var('action', '');

$form_key = 'acp_board';

add_form_key($form_key);

}

$this->new_config = $config;

$error = array();

// We validate the complete config if whished

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

$action = request_var('action', '');

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

$bot_id = request_var('id', 0);

{

$action = 'add';

}

{

$error[] = $user->lang['ERR_BOT_NO_MATCHES'];

}

if ($bot_row['bot_ip'] && !preg_match('#^[\d\.,:]+$#', $bot_row['bot_ip']))

{

if (!$ip_list = gethostbynamel($bot_row['bot_ip']))

{

$error[] = $user->lang['ERR_BOT_AGENT_MATCHES_UA'];

}

$bot_name = false;

if ($bot_id)

{

{

$error[] = $user->lang['BOT_NAME_TAKEN'];

}

if (!sizeof($error))

{

// New bot? Create a new user and group entry

{

trigger_error($user->lang['NO_BOT_GROUP'] . adm_back_link($this->u_action . "&amp;id=$bot_id&amp;action=$action"), E_USER_WARNING);

}

$user_id = user_add(array(

'user_type' => (int) USER_IGNORE,

'user_style' => (int) $bot_row['bot_style'],

'user_allow_massemail' => 0,

));

$sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

'user_id' => (int) $user_id,

'bot_name' => (string) $bot_row['bot_name'],

'bot_ip' => (string) $bot_row['bot_ip'])

);

$db->sql_query($sql);

$log = 'ADDED';

}

else if ($bot_id)

$log = 'UPDATED';

}

$cache->destroy('_bots');

add_log('admin', 'LOG_BOT_' . $log, $bot_row['bot_name']);

trigger_error($user->lang['BOT_' . $log] . adm_back_link($this->u_action));

}

}

else if ($bot_id)

'U_ACTION' => $this->u_action . "&amp;id=$bot_id&amp;action=$action",

'U_BACK' => $this->u_action,

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'BOT_NAME' => $bot_row['bot_name'],

'BOT_IP' => $bot_row['bot_ip'],

'BOT_AGENT' => $bot_row['bot_agent'],

'S_EDIT_BOT' => true,

'S_ACTIVE_OPTIONS' => $s_active_options,

'S_STYLE_OPTIONS' => $style_select,

}

$db->sql_freeresult($result);

}

/**

* Validate bot name against username table

*/

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

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

$db->sql_freeresult($result);

return ($row) ? false : true;

}

}

$selected = request_var('select_captcha', $config['captcha_plugin']);

$configure = request_var('configure', false);

// Oh, they are just here for the view

{

$this->deliver_demo($selected);

}

// Delegate

if ($configure)

{

}

$demo_captcha = phpbb_captcha_factory::get_instance($selected);

foreach ($config_vars as $config_var => $template_var)

{

$template->assign_var($template_var, request_var($config_var, $config[$config_var])) ;

'CAPTCHA_SELECT' => $captcha_select,

));

}

}

}

/**

* Entry point for delivering image CAPTCHAs in the ACP.

*/

function deliver_demo($selected)

{

global $db, $user, $config;

$captcha = phpbb_captcha_factory::get_instance($selected);

$captcha->init(CONFIRM_REG);

$captcha->execute_demo();

garbage_collection();

exit_handler();

}

}

?> \ No newline at end of file

function main($id, $mode)

{

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

$user->add_lang('acp/database');

$this->tpl_name = 'acp_database';

$this->page_title = 'ACP_DATABASE';

$action = request_var('action', '');

$template->assign_vars(array(

'MODE' => $mode

$template->assign_vars(array(

'U_ACTION' => $this->u_action . '&amp;action=download'

));

$available_methods = array('gzip' => 'zlib', 'bzip2' => 'bz2');

foreach ($available_methods as $type => $module)

header('Pragma: no-cache');

header("Content-Type: $mimetype; name=\"$name\"");

header("Content-disposition: attachment; filename=$name");

switch ($format)

{

case 'bzip2':

break;

}

}

if ($store == true)

{

$file = PHPBB_ROOT_PATH . 'store/' . $filename . $ext;

$this->fp = $open($file, 'w');

if (!$this->fp)

{

trigger_error('Unable to write temporary file to storage folder', E_USER_ERROR);

if ($result != false)

{

$fields_cnt = mysqli_num_fields($result);

// Get field information

$field = mysqli_fetch_fields($result);

$field_set = array();

for ($j = 0; $j < $fields_cnt; $j++)

{

$field_set[] = $field[$j]->name;

$first_set = true;

$query_len = 0;

$max_len = get_usable_memory();

while ($row = mysqli_fetch_row($result))

{

$values = array();

$field[] = mysql_fetch_field($result, $i);

}

$field_set = array();

for ($j = 0; $j < $fields_cnt; $j++)

{

$field_set[] = $field[$j]->name;

$ar[] = $row;

}

$db->sql_freeresult($result);

foreach ($ar as $value)

{

if (strpos($value['name'], 'autoindex') !== false)

$sql_data .= "CREATE SEQUENCE {$table_name}_seq;\n";

}

$db->sql_freeresult($result);

$field_query = "SELECT a.attnum, a.attname as field, t.typname as type, a.attlen as length, a.atttypmod as lengthvar, a.attnotnull as notnull

FROM pg_class c, pg_attribute a, pg_type t

WHERE c.relname = '" . $db->sql_escape($table_name) . "'

{

$line .= ' NOT NULL';

}

$lines[] = $line;

}

$db->sql_freeresult($result);

$sql_data .= "GO\n";

$sql_data .= "\nCREATE TABLE [$table_name] (\n";

$rows = array();

$text_flag = false;

$sql = "SELECT COLUMN_NAME, COLUMN_DEFAULT, IS_NULLABLE, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH, COLUMNPROPERTY(object_id(TABLE_NAME), COLUMN_NAME, 'IsIdentity') as IS_IDENTITY

FROM INFORMATION_SCHEMA.COLUMNS

WHERE TABLE_NAME = '$table_name'";

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

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

{

$line = "\t[{$row['COLUMN_NAME']}] [{$row['DATA_TYPE']}]";

if ($row['DATA_TYPE'] == 'text')

{

$text_flag = true;

}

if ($row['IS_IDENTITY'])

{

$line .= ' IDENTITY (1 , 1)';

}

if ($row['CHARACTER_MAXIMUM_LENGTH'] && $row['DATA_TYPE'] !== 'text')

{

$line .= ' (' . $row['CHARACTER_MAXIMUM_LENGTH'] . ')';

}

if ($row['IS_NULLABLE'] == 'YES')

{

$line .= ' NULL';

{

$line .= ' NOT NULL';

}

if ($row['COLUMN_DEFAULT'])

{

$line .= ' DEFAULT ' . $row['COLUMN_DEFAULT'];

}

$rows[] = $line;

}

$db->sql_freeresult($result);

$sql_data .= implode(",\n", $rows);

$sql_data .= "\n) ON [PRIMARY]";

if ($text_flag)

{

$sql_data .= " TEXTIMAGE_ON [PRIMARY]";

}

$sql_data .= "\nGO\n\n";

$rows = array();

$sql = "SELECT CONSTRAINT_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE

WHERE TABLE_NAME = '$table_name'";

$sql_data .= "\n\t) ON [PRIMARY] \nGO\n";

}

$db->sql_freeresult($result);

$index = array();

$sql = "EXEC sp_statistics '$table_name'";

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

}

}

$db->sql_freeresult($result);

foreach ($index as $index_name => $column_name)

{

$index[$index_name] = implode(', ', $column_name);

}

foreach ($index as $index_name => $columns)

{

$sql_data .= "\nCREATE INDEX [$index_name] ON [$table_name]($columns) ON [PRIMARY]\nGO\n";

$ary_type = $ary_name = array();

$ident_set = false;

$sql_data = '';

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

$ary_type = $ary_name = array();

$ident_set = false;

$sql_data = '';

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

FROM syscat.columns

WHERE tabname = '$table_name'";

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

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

{

$line = "\t{$row['colname']} {$row['typename']}";

{

$line .= ' GENERATED BY DEFAULT AS IDENTITY (START WITH 1, INCREMENT BY 1)';

}

if ($row['typename'] == 'VARCHAR' || $row['typename'] == 'CHARACTER' || $row['typename'] == 'CLOB')

{

$line .= ' (' . $row['length'] . ')';

}

if ($row['nulls'] == 'N')

{

$line .= ' NOT NULL';

{

$line .= ' DEFAULT ' . $row['default'];

}

$rows[] = $line;

}

$db->sql_freeresult($result);

{

global $db;

$ary_type = $ary_name = array();

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

{

global $db;

$ary_type = $ary_name = array();

// Grab all of the data from current table.

$sql = "SELECT *

FROM $table_name";

{

$record = '';

$delim_len = strlen($delim);

while (!$eof($fp))

{

$pos = strpos($record, $delim);

$form_key = 'acp_disallow';

add_form_key($form_key);

if (($allow || $disallow) && !check_form_key($form_key))

{

add_form_key($form_key);

// Set some vars

$error = array();

$usernames = request_var('usernames', '', true);

{

// Error checking needs to go here ... if no subject and/or no message then skip

// over the send and return to the form

$priority = request_var('mail_priority_flag', MAIL_NORMAL_PRIORITY);

if (!check_form_key($form_key))

$db->sql_freeresult($result);

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

}

$i = $j = 0;

// Send with BCC, no more than 50 recipients for one mail (to not exceed the limit)

$messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

$messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);

$messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

$messenger->subject(htmlspecialchars_decode($subject));

$messenger->set_mail_priority($priority);

'CONTACT_EMAIL' => $config['board_contact'],

'MESSAGE' => htmlspecialchars_decode($message))

);

if (!($messenger->send($used_method)))

{

$errored = true;

$select_list = '<option value="0"' . ((!$group_id) ? ' selected="selected"' : '') . '>' . $user->lang['ALL_USERS'] . '</option>';

$select_list .= group_select_options($group_id, $exclude);

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

$s_priority_options .= '<option value="' . MAIL_NORMAL_PRIORITY . '" selected="selected">' . $user->lang['MAIL_NORMAL_PRIORITY'] . '</option>';

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

add_form_key($form_key);

$action = request_var('action', '');

$forum_id = request_var('f', 0);

$this->parent_id = request_var('parent_id', 0);

include(PHPBB_ROOT_PATH . 'includes/functions_user.' . PHP_EXT);

// Check and set some common vars

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

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

$name_ary = request_var('usernames', '', true);

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

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

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

// Clear some vars

$submit_ary = array(

'colour' => request_var('group_colour', ''),

'rank' => request_var('group_rank', 0),

'message_limit' => request_var('group_message_limit', 0),

'max_recipients' => request_var('group_max_recipients', 0),

'founder_manage' => 0,

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

{

}

if (!empty($_FILES['uploadfile']['tmp_name']) || $data['uploadurl'] || $data['remotelink'])

$avatar_img = (!empty($group_row['group_avatar'])) ? get_user_avatar($group_row['group_avatar'], $group_row['group_avatar_type'], $group_row['group_avatar_width'], $group_row['group_avatar_height'], 'GROUP_AVATAR') : '<img src="' . PHPBB_ADMIN_PATH . 'images/no_avatar.gif" alt="" />';

if ($config['allow_avatar_local'] && $display_gallery)

{

// Set up general vars

$action = request_var('action', '');

$icon_id = request_var('id', 0);

$mode = ($mode == 'smilies') ? 'smilies' : 'icons';

}

}

}

$sql = "SELECT *

FROM $table

ORDER BY {$fields}_order " . (($icon_id || $action == 'add') ? 'DESC' : 'ASC');

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

$data = array();

$after = false;

$display = 0;

$order_lists = array('', '');

$add_order_lists = array('', '');

$display_count = 0;

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

{

if ($action == 'add')

$colspan = (($mode == 'smilies') ? '7' : '5');

$colspan += ($icon_id) ? 1 : 0;

$colspan += ($action == 'add') ? 2 : 0;

$template->assign_vars(array(

'S_EDIT' => true,

'S_SMILIES' => ($mode == 'smilies') ? true : false,

'S_ADD' => ($action == 'add') ? true : false,

'S_ORDER_LIST_DISPLAY' => $order_list . $order_lists[1],

'S_ORDER_LIST_UNDISPLAY' => $order_list . $order_lists[0],

'S_ORDER_LIST_DISPLAY_COUNT' => $display_count + 1,

'S_ADD_CODE' => true,

'S_IMG_OPTIONS' => $smiley_options,

'S_ADD_ORDER_LIST_DISPLAY' => $add_order_list . $add_order_lists[1],

'S_ADD_ORDER_LIST_UNDISPLAY' => $add_order_list . $add_order_lists[0],

'IMG_SRC' => PHPBB_ROOT_PATH . $img_path . '/' . $default_row['smiley_url'],

'IMG_PATH' => $img_path,

'PHPBB_ROOT_PATH' => PHPBB_ROOT_PATH,

}

return;

break;

case 'create':

case 'modify':

// Get items to create/modify

// Now really get the items

$image_emotion = utf8_normalize_nfc(request_var('emotion', array('' => ''), true));

$image_code = utf8_normalize_nfc(request_var('code', array('' => ''), true));

// Ok, add the relevant bits if we are adding new codes to existing emoticons...

{

$add_image = request_var('add_image', '');

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

$image_width[$add_image] = request_var('add_width', 0);

$image_height[$add_image] = request_var('add_height', 0);

{

$image_display_on_posting[$add_image] = 1;

}

$db->sql_query($sql);

$icons_updated++;

}

}

}

$cache->destroy('_icons');

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

$level = E_USER_NOTICE;

switch ($icons_updated)

{

$suc_lang = "{$lang}_NONE";

$level = E_USER_WARNING;

break;

case 1:

$suc_lang = "{$lang}_ONE";

break;

default:

$suc_lang = $lang;

}

$action = request_var('action', '');

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

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

// Sort keys

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

FROM ' . USERS_TABLE . '

WHERE ' . $db->sql_in_set('user_id', $mark);

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

$user_affected = array();

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

{

unset($usernames);

}

$db->sql_freeresult($result);

break;

}

}

'S_SORT_DIR' => $s_sort_dir,

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

'PAGINATION' => generate_pagination($this->u_action . "&amp;$u_sort_param", $inactive_count, $config['topics_per_page'], $start, true),

'U_ACTION' => $this->u_action . '&amp;start=' . $start,

));

include_once(PHPBB_ROOT_PATH . 'includes/functions_jabber.' . PHP_EXT);

$action = request_var('action', '');

if ($mode != 'settings')

{

* inside the request class. Reducing some of the redundance of this code would certainly

* not hurt either.

*/

include_once(PHPBB_ROOT_PATH . 'includes/functions_user.' . PHP_EXT);

// Check and set some common vars

$action = (empty($action)) ? request_var('action', '') : $action;

$form_name = 'acp_lang';

add_form_key('acp_lang');

$lang_id = request_var('id', 0);

{

$missing_file = request_var('missing_file', array('' => 0));

/**

* @todo Do NOT overwrite a request variable.

*/

}

$selected_lang_file = request_var('language_file', '|common.' . PHP_EXT);

);

/**

*/

$hidden_data .= build_hidden_fields(array('entry' => $_POST['entry']), true, STRIP);

case 'submit_file':

case 'download_file':

case 'upload_data':

if (!$submit || !check_form_key($form_name))

{

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

if (!$safe_mode)

{

$mkdir_ary = array('language', 'language/' . $row['lang_iso']);

if ($this->language_directory)

{

$mkdir_ary[] = 'language/' . $row['lang_iso'] . '/' . $this->language_directory;

}

foreach ($mkdir_ary as $dir)

{

$dir = PHPBB_ROOT_PATH . 'store/' . $dir;

if (!is_dir($dir))

{

if (!@mkdir($dir, 0777))

}

$entry = "\tarray(\n";

foreach ($value as $_key => $_value)

{

$entry .= "\t\t" . (int) $_key . "\t=> '" . $this->prepare_lang_entry($_value) . "',\n";

{

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

}

$this->page_title = 'LANGUAGE_PACK_DETAILS';

$sql = 'SELECT *

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

$lang_entries = $db->sql_fetchrow($result);

$db->sql_freeresult($result);

$lang_iso = $lang_entries['lang_iso'];

$missing_vars = $missing_files = array();

trigger_error($user->lang['WRONG_LANGUAGE_FILE'] . adm_back_link($this->u_action . '&amp;action=details&amp;id=' . $lang_id), E_USER_WARNING);

}

}

{

$store_filename = $this->get_filename($lang_iso, $this->language_directory, $this->language_file, true, true);

if (file_exists(PHPBB_ROOT_PATH . $this->get_filename($lang_iso, '', $file)))

{

$missing_vars[$file] = $this->compare_language_files($config['default_lang'], $lang_iso, '', $file);

if (sizeof($missing_vars[$file]))

{

$is_missing_var = true;

if (file_exists(PHPBB_ROOT_PATH . $this->get_filename($lang_iso, 'acp', $file)))

{

$missing_vars['acp/' . $file] = $this->compare_language_files($config['default_lang'], $lang_iso, 'acp', $file);

if (sizeof($missing_vars['acp/' . $file]))

{

$is_missing_var = true;

if (file_exists(PHPBB_ROOT_PATH . $this->get_filename($lang_iso, 'mods', $file)))

{

$missing_vars['mods/' . $file] = $this->compare_language_files($config['default_lang'], $lang_iso, 'mods', $file);

if (sizeof($missing_vars['mods/' . $file]))

{

$is_missing_var = true;

}

}

}

// More missing files... for example email templates?

foreach ($email_files as $file)

{

$compress->add_data('', 'language/' . $row['lang_iso'] . '/index.html');

$compress->add_data('', 'language/' . $row['lang_iso'] . '/email/index.html');

$compress->add_data('', 'language/' . $row['lang_iso'] . '/acp/index.html');

if (sizeof($mod_files))

{

$compress->add_data('', 'language/' . $row['lang_iso'] . '/mods/index.html');

function get_filename($lang_iso, $directory, $filename, $check_store = false, $only_return_filename = false)

{

global $safe_mode;

$check_filename = "language/$lang_iso/" . (($directory) ? $directory . '/' : '') . $filename;

if ($check_store)

$action = request_var('action', '');

$forum_id = request_var('f', 0);

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

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

// Sort keys

if ($mode == 'mod')

{

$forum_box = '<option value="0">' . $user->lang['ALL_FORUMS'] . '</option>' . make_forum_select($forum_id);

$template->assign_vars(array(

'S_SHOW_FORUMS' => true,

'S_FORUM_BOX' => $forum_box)

foreach ($log_data as $row)

{

$data = array();

$checks = array('viewtopic', 'viewlogs', 'viewforum');

foreach ($checks as $check)

{

}

break;

case 'enable':

case 'disable':

if (!$module_id)

add_log('admin', 'LOG_MODULE_' . strtoupper($action), $this->lang_name($row['module_langname']), $move_module_name);

$this->remove_cache_file();

}

break;

case 'quickadd':

if (!sizeof($errors))

{

$this->remove_cache_file();

trigger_error($user->lang['MODULE_ADDED'] . adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id));

}

}

{

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

}

$module_row = $this->get_module_row($module_id);

// no break

'module_auth' => '',

);

}

$module_data = array();

$module_data['module_basename'] = request_var('module_basename', (string) $module_row['module_basename']);

$module_data['module_langname'] = utf8_normalize_nfc(request_var('module_langname', (string) $module_row['module_langname'], true));

$module_data['module_mode'] = request_var('module_mode', (string) $module_row['module_mode']);

if ($submit)

{

if (!sizeof($errors))

{

$this->remove_cache_file();

trigger_error((($action == 'add') ? $user->lang['MODULE_ADDED'] : $user->lang['MODULE_EDITED']) . adm_back_link($this->u_action . '&amp;parent_id=' . $this->parent_id));

}

}

{

$s_mode_options .= '<option value="' . $m_mode . '"' . (($m_mode == $module_data['module_mode']) ? ' selected="selected"' : '') . '>' . $this->lang_name($m_values['title']) . '</option>';

}

$template->assign_block_vars('m_names.modes', array(

'OPTION' => $m_mode,

'VALUE' => $this->lang_name($m_values['title']),

);

}

}

$s_cat_option = '<option value="0"' . (($module_data['parent_id'] == 0) ? ' selected="selected"' : '') . '>' . $user->lang['NO_PARENT'] . '</option>';

$template->assign_vars(array_merge(array(

'U_EDIT_ACTION' => $this->u_action . '&amp;parent_id=' . $this->parent_id,

'L_TITLE' => $user->lang[strtoupper($action) . '_MODULE'],

'MODULENAME' => $this->lang_name($module_data['module_langname']),

'ACTION' => $action,

'MODULE_ID' => $module_id,

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

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

$db->sql_freeresult($result);

if (!$row)

{

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

return $row;

}

/**

* Get available module information from module files

*/

$fileinfo[str_replace($module_class . '_', '', $module_info['filename'])] = $module_info;

}

}

return $fileinfo;

}

// Sanitise for future path use, it's escaped as appropriate for queries

$p_class = str_replace(array('.', '/', '\\'), '', basename($this->module_class));

$cache->destroy('_modules_' . $p_class);

// Additionally remove sql cache

$this->tpl_name = 'acp_permission_roles';

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

$action = request_var('action', '');

$form_name = 'acp_permissions';

add_form_key($form_name);

{

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

}

$sql = 'SELECT *

FROM ' . ACL_ROLES_TABLE . '

WHERE role_id = ' . $role_id;

{

var $u_action;

var $permission_dropdown;

function main($id, $mode)

{

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

// Set some vars

$action = request_var('action', array('' => 0));

$action = key($action);

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

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

}

$db->sql_freeresult($result);

}

// Map usernames to ids and vice versa

if ($usernames)

{

}

}

unset($username);

// Build forum ids (of all forums are checked or subforum listing used)

if ($all_forums)

{

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

}

// All users/groups selected?

if ($all_users || $all_groups)

{

break;

case 'apply_permissions':

{

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

}

break;

case 'apply_all_permissions':

{

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

}

case 'usergroup':

case 'usergroup_view':

if ((sizeof($user_id) && !$all_users) || (sizeof($group_id) && !$all_groups))

{

}

continue;

}

if ($branch_there)

{

$s_options .= ' [' . $user->lang['PLUS_SUBFORUMS'] . ']';

return $s_options;

}

/**

* Build dropdown field for changing permission types

*/

function build_permission_dropdown($options, $default_option, $permission_scope)

{

global $user, $auth;

$s_dropdown_options = '';

foreach ($options as $setting)

{

{

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

}

$ug_id = $forum_id = 0;

// We loop through the auth settings defined in our submit

list($ug_id, ) = each($psubmit);

list($forum_id, ) = each($psubmit[$ug_id]);

if (!isset($auth_settings[$ug_id][$forum_id]) || !sizeof($auth_settings[$ug_id][$forum_id])))

{

trigger_error('WRONG_PERMISSION_SETTING_FORMAT', E_USER_WARNING);

}

// Do we have a role we want to set?

// Do the admin want to set these permissions to other items too?

$inherit = request_var('inherit', array(0 => array(0)));

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

}

$ug_ids = $forum_ids = array();

// We need to go through the auth settings

function remove_permissions($mode, $permission_type, &$auth_admin, &$user_id, &$group_id, &$forum_id)

{

global $user, $db, $auth;

// User or group to be set?

$ug_type = (sizeof($user_id)) ? 'user' : 'group';

$this->tpl_name = 'acp_profile';

$this->page_title = 'ACP_CUSTOM_PROFILE_FIELDS';

$error = array();

$s_hidden_fields = '';

FROM ' . PROFILE_LANG_TABLE . '

ORDER BY lang_id';

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

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

{

// Which languages are available for each item

'field_id' => $field_id,

)));

}

break;

case 'activate':

{

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

}

$sql = 'SELECT lang_id

FROM ' . LANG_TABLE . "

WHERE lang_iso = '" . $db->sql_escape($config['default_lang']) . "'";

{

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

}

$sql = 'UPDATE ' . PROFILE_FIELDS_TABLE . "

SET field_active = 0

WHERE field_id = $field_id";

case 'create':

case 'edit':

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

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

// The language id of default language

$this->edit_lang_id = $this->lang_defs['iso'][$config['default_lang']];

{

// We are adding a new field, define basic params

$lang_options = $field_row = array();

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

if (!$field_type)

{

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

$cp->vars['lang_default_value'] = utf8_normalize_nfc(request_var('lang_default_value', $field_row['lang_default_value'], true));

// Field option...

{

$field_option = request_var('field_option', '');

}

else if ($field_type == FIELD_TEXT && $key == 'field_length')

{

{

$cp->vars['rows'] = request_var('rows', 0);

$cp->vars['columns'] = request_var('columns', 0);

else if ($field_type == FIELD_DATE && $key == 'field_default_value')

{

$always_now = request_var('always_now', -1);

if ($always_now == 1 || ($always_now === -1 && $var == 'now'))

{

$now = getdate();

/**

* @todo Do NOT overwrite a request variable.

*/

}

else

{

{

$cp->vars['field_default_value_day'] = request_var('field_default_value_day', 0);

$cp->vars['field_default_value_month'] = request_var('field_default_value_month', 0);

/**

* @todo Do NOT overwrite a request variable.

*/

}

else

{

list($cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']) = explode('-', $var);

}

}

/* else if ($field_type == FIELD_BOOL && $key == 'field_default_value')

{

}

$db->sql_freeresult($result);

$sql = 'SELECT lang_id, lang_name, lang_explain, lang_default_value

FROM ' . PROFILE_LANG_TABLE . '

WHERE lang_id <> ' . $this->edit_lang_id . "

}

$db->sql_freeresult($result);

}

foreach ($exclude[3] as $key)

{

$cp->vars[$key] = utf8_normalize_nfc(request_var($key, array(0 => ''), true));

{

$cp->vars[$key][$lang_id] = explode("\n", $options);

}

}

}

}

}

if (sizeof($error))

{

foreach ($key_ary as $key)

{

{

$cp->vars['rows'] = request_var('rows', 0);

$cp->vars['columns'] = request_var('columns', 0);

{

$_new_key_ary[$key] = 'now';

}

{

$cp->vars['field_default_value_day'] = request_var('field_default_value_day', 0);

$cp->vars['field_default_value_month'] = request_var('field_default_value_month', 0);

$_new_key_ary[$key] = sprintf('%2d-%2d-%4d', $cp->vars['field_default_value_day'], $cp->vars['field_default_value_month'], $cp->vars['field_default_value_year']);

}

}

{

$_new_key_ary[$key] = utf8_normalize_nfc(request_var($key, array(array('')), true));

}

else

{

{

$var = false;

}

'L_TITLE' => $user->lang['STEP_' . $step . '_TITLE_' . strtoupper($action)],

'L_EXPLAIN' => $user->lang['STEP_' . $step . '_EXPLAIN_' . strtoupper($action)],

'U_ACTION' => $this->u_action . "&amp;action=$action&amp;step=$step",

'U_BACK' => $this->u_action)

);

{

// Create basic options - only small differences between field types

case 1:

// Build common create options

$template->assign_vars(array(

'S_STEP_ONE' => true,

'LANG_DEFAULT_VALUE' => $cp->vars['lang_default_value'])

);

}

if ($field_type == FIELD_BOOL || $field_type == FIELD_DROPDOWN)

{

// Initialize these array elements if we are creating a new field

'SECOND_LANG_OPTION' => ($field_type == FIELD_BOOL) ? $cp->vars['lang_options'][1] : '')

);

}

break;

case 2:

$template->assign_vars(array(

'S_STEP_TWO' => true,

'L_NEXT_STEP' => (sizeof($this->lang_defs['iso']) == 1) ? $user->lang['SAVE'] : $user->lang['PROFILE_LANG_OPTIONS'])

);

}

}

break;

}

break;

}

$sql = 'SELECT *

FROM ' . PROFILE_FIELDS_TABLE . '

ORDER BY field_order';

$languages[$row['lang_id']] = $row['lang_iso'];

}

$db->sql_freeresult($result);

$options = array();

$options['lang_name'] = 'string';

if ($cp->vars['lang_explain'])

{

$options['lang_explain'] = 'text';

}

switch ($field_type)

{

case FIELD_BOOL:

case FIELD_DROPDOWN:

$options['lang_options'] = 'optionfield';

break;

case FIELD_TEXT:

case FIELD_STRING:

if ($cp->vars['lang_default_value'])

}

break;

}

$lang_options = array();

foreach ($options as $field => $field_type)

if ($field == 'lang_options')

{

$var = (!isset($cp->vars['l_lang_options'][$lang_id]) || !is_array($cp->vars['l_lang_options'][$lang_id])) ? $cp->vars['lang_options'] : $cp->vars['l_lang_options'][$lang_id];

switch ($field_type)

{

case 'two_options':

);

break;

}

if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))

{

$lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];

'TITLE' => $user->lang['CP_' . strtoupper($field)],

'FIELD' => ($field_type == 'string') ? '<dd><input class="medium" type="text" name="l_' . $field . '[' . $lang_id . ']" value="' . ((isset($value[$lang_id])) ? $value[$lang_id] : $var) . '" /></dd>' : '<dd><textarea name="l_' . $field . '[' . $lang_id . ']" rows="3" cols="80">' . ((isset($value[$lang_id])) ? $value[$lang_id] : $var) . '</textarea></dd>'

);

if (isset($user->lang['CP_' . strtoupper($field) . '_EXPLAIN']))

{

$lang_options[$lang_id]['fields'][$field]['EXPLAIN'] = $user->lang['CP_' . strtoupper($field) . '_EXPLAIN'];

WHERE field_id = $field_id";

$db->sql_query($sql);

}

if ($action == 'create')

{

$field_ident = 'pf_' . $field_ident;

{

$sql_ary['field_id'] = $field_id;

$sql_ary['lang_id'] = $default_lang_id;

$profile_sql[] = 'INSERT INTO ' . PROFILE_LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary);

}

else

AND lang_id = " . (int) $default_lang_id;

$db->sql_query($sql);

}

foreach ($cp->vars['lang_options'] as $option_id => $value)

{

$sql_ary = array(

$lang_id = $sql['lang_id'];

$option_id = $sql['option_id'];

unset($sql['lang_id'], $sql['field_id'], $sql['option_id']);

$this->update_insert(PROFILE_FIELDS_LANG_TABLE, $sql, array(

'lang_id' => $lang_id,

'field_id' => $field_id,

$db->sql_query($sql);

}

}

$db->sql_transaction('commit');

if ($action == 'edit')

if (!$row)

{

$sql_ary = array_merge($where_fields, $sql_ary);

if (sizeof($sql_ary))

{

$db->sql_query("INSERT INTO $table " . $db->sql_build_array('INSERT', $sql_ary));

case FIELD_BOOL:

$sql .= 'TINYINT(2) ';

break;

case FIELD_DROPDOWN:

$sql .= 'MEDIUMINT(8) ';

break;

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

$forum_id = request_var('f', array(0));

if ($all_forums)

{

$prune_posted = request_var('prune_days', 0);

$prune_viewed = request_var('prune_vieweddays', 0);

$prune_all = (!$prune_posted && !$prune_viewed) ? true : false;

$prune_flags = 0;

$prune_flags += (request_var('prune_old_polls', 0)) ? 2 : 0;

$prune_flags += (request_var('prune_announce', 0)) ? 4 : 0;

$p_result['topics'] = 0;

$p_result['posts'] = 0;

$log_data = '';

do

{

if (!$auth->acl_get('f_list', $row['forum_id']))

$p_result['topics'] += $return['topics'];

$p_result['posts'] += $return['posts'];

}

if ($prune_viewed)

{

$return = prune($row['forum_id'], 'viewed', $prunedate_viewed, $prune_flags, false);

'NUM_TOPICS' => $p_result['topics'],

'NUM_POSTS' => $p_result['posts'])

);

$log_data .= (($log_data != '') ? ', ' : '') . $row['forum_name'];

}

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

// Sync all pruned forums at once

sync('forum', 'forum_id', $prune_ids, true, true);

add_log('admin', 'LOG_PRUNE', $log_data);

$user->add_lang('memberlist');

if ($prune)

{

{

user_delete('remove', $user_id);

}

$l_log = 'LOG_PRUNE_USER_DEL_DEL';

}

else

{

$s_find_join_time .= '<option value="' . $key . '">' . $value . '</option>';

}

$s_find_active_time = '';

foreach ($find_time as $key => $value)

{

global $user, $db;

$users = request_var('users', '', true);

if ($users)

{

$users = explode("\n", $users);

// Set up general vars

$action = request_var('action', '');

$rank_id = request_var('id', 0);

$this->tpl_name = 'acp_ranks';

'rank_min' => $min_posts,

'rank_image' => htmlspecialchars_decode($rank_image)

);

if ($rank_id)

{

$sql = 'UPDATE ' . RANKS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . " WHERE rank_id = $rank_id";

case 'add':

$data = $ranks = $existing_imgs = array();

$sql = 'SELECT *

FROM ' . RANKS_TABLE . '

ORDER BY rank_min ASC, rank_special ASC';

'S_SPECIAL_RANK' => (!isset($ranks['rank_special']) || $ranks['rank_special']) ? true : false,

'MIN_POSTS' => (isset($ranks['rank_min']) && !$ranks['rank_special']) ? $ranks['rank_min'] : 0)

);

return;

break;

}

$template->assign_vars(array(

'U_ACTION' => $this->u_action)

);

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

'U_DELETE' => $this->u_action . '&amp;action=delete&amp;id=' . $row['rank_id'])

}

$db->sql_freeresult($result);

// Set up general vars

$action = request_var('action', '');

$reason_id = request_var('id', 0);

$this->tpl_name = 'acp_reasons';

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

$max_order = (int) $db->sql_fetchfield('max_reason_order');

$db->sql_freeresult($result);

$sql_ary = array(

'reason_title' => (string) $reason_row['reason_title'],

'reason_description' => (string) $reason_row['reason_description'],

'U_ACTION' => $this->u_action . "&amp;id=$reason_id&amp;action=$action",

'U_BACK' => $this->u_action,

'ERROR_MSG' => (sizeof($error)) ? implode('<br />', $error) : '',

'REASON_TITLE' => $reason_row['reason_title'],

'REASON_DESCRIPTION' => $reason_row['reason_description'],

do

{

++$order;

if ($row['reason_order'] != $order)

{

$sql = 'UPDATE ' . REPORTS_REASONS_TABLE . "

{

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

$search_types = $this->get_search_types();

}

$this->state = explode(',', $config['search_indexing_state']);

{

$action = '';

$this->state = array();

$this->page_title = 'ACP_CAT_STYLES';

$action = request_var('action', '');

$style_id = request_var('id', 0);

// Fill the configuration variables

$template_data = htmlspecialchars_decode($template_data);

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

$text_rows = max(5, min(999, request_var('text_rows', 20)));

// make sure template_file path doesn't go upwards

$template_file = str_replace('..', '.', $template_file);

$source = str_replace('/', '.', request_var('source', ''));

$file_ary = array_diff(request_var('delete', array('')), array(''));

$sql = 'SELECT *

FROM ' . STYLES_TEMPLATE_TABLE . "

$theme_data = htmlspecialchars_decode($theme_data);

$theme_file = utf8_normalize_nfc(request_var('template_file', '', true));

$text_rows = max(5, min(999, request_var('text_rows', 20)));

// make sure theme_file path doesn't go upwards

$theme_file = str_replace('..', '.', $theme_file);

$this->page_title = 'EDIT_IMAGESET';

$imgname = request_var('imgname', '');

$imgpath = request_var('imgpath', '');

}

}

{

if ($valid_name)

{

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

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

$sql_where = '';

switch ($mode)

{

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

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

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

{

global $template, $db, $config, $user, $safe_mode, $cache;

$l_type = strtoupper($mode);

$error = array();

$element_ary = array('template' => STYLES_TEMPLATE_TABLE, 'theme' => STYLES_THEME_TABLE, 'imageset' => STYLES_IMAGESET_TABLE);

$install_path = request_var('path', '');

// Installing, obtain cfg file contents

if ($install_path)

);

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

if ($basis)

{

$user_id = request_var('u', 0);

$action = request_var('action', '');

$form_name = 'acp_users';

add_form_key($form_name);

// Set up general vars

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

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

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

// Generate users avatar

$avatar_img = ($user_row['user_avatar']) ? get_user_avatar($user_row['user_avatar'], $user_row['user_avatar_type'], $user_row['user_avatar_width'], $user_row['user_avatar_height']) : '<img src="' . PHPBB_ADMIN_PATH . 'images/no_avatar.gif" alt="" />';

$avatar_select = basename(request_var('avatar_select', ''));

$category = basename(request_var('category', ''));

$enable_urls = ($config['allow_sig_links']) ? ((request_var('disable_magic_url', false)) ? false : true) : false;

$signature = utf8_normalize_nfc(request_var('signature', (string) $user_row['user_sig'], true));

if ($submit || $preview)

{

case 'attach':

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

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

// Sort keys

class acp_words

{

var $u_action;

function main($id, $mode)

{

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

// Set up general vars

$action = request_var('action', '');

$s_hidden_fields = '';

$word_info = array();

{

case 'edit':

$word_id = request_var('id', 0);

if (!$word_id)

{

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

'REPLACEMENT' => (isset($word_info['replacement'])) ? $word_info['replacement'] : '',

'S_HIDDEN_FIELDS' => $s_hidden_fields)

);

return;

break;

$word_id = request_var('id', 0);

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

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

if (!$word || !$replacement)

{

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

'word' => $word,

'replacement' => $replacement

);

if ($word_id)

{

$db->sql_query('UPDATE ' . WORDS_TABLE . ' SET ' . $db->sql_build_array('UPDATE', $sql_ary) . ' WHERE word_id = ' . $word_id);

// Include the admin banning interface...

include(PHPBB_ROOT_PATH . 'includes/acp/acp_ban.' . PHP_EXT);

$current_time = time();

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

case 'user':

$pre_fill = (string) $db->sql_fetchfield('username');

break;

case 'ip':

$pre_fill = (string) $db->sql_fetchfield('user_ip');

break;

if ($merge_select)

{

// Fixes a "bug" that makes forum_view use the same ordering as topic_view

}

$forum_id = $forum_info['forum_id'];

}

}

}

{

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

}

if ($to_forum_id && !$additional_msg && confirm_box(true))

{

$topic_data = get_topic_data($topic_ids);

$topics_moved = sizeof($topic_ids);

$topics_authed_moved = 0;

confirm_box(false, (sizeof($topic_ids) == 1) ? 'DELETE_TOPIC' : 'DELETE_TOPICS', $s_hidden_fields);

}

{

$redirect = request_var('redirect', 'index.' . PHP_EXT);

$redirect = reapply_sid($redirect);

}

}

}

{

$additional_msg = $user->lang['FORUM_NOT_EXIST'];

}

if (confirm_box(true))

{

// If Topic -> total_topics = total_topics+1, total_posts = total_posts+1, forum_topics = forum_topics+1, forum_posts = forum_posts+1

// If Post -> total_posts = total_posts+1, forum_posts = forum_posts+1, topic_replies = topic_replies+1

'redirect' => $redirect)

);

$disapprove_reason = '';

if ($reason_id)

$forum_id = request_var('f', 0);

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

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

$submitted_id_list = request_var('post_ids', array(0));

$checked_ids = $post_id_list = request_var('post_id_list', array(0));

$post_id = request_var('p', 0);

$forum_id = request_var('f', 0);

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

$sql = 'SELECT u.*, p.*

$user_id = request_var('u', 0);

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

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

$sql_where = ($user_id) ? "user_id = $user_id" : "username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";

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

$sort_dir = request_var('sd', 'a');

$delete_ids = array_keys(request_var('attachment', array(0)));

if ($delete && sizeof($delete_ids))

$return_page = '<br /><br />' . sprintf($user->lang['RETURN_PAGE'], '<a href="' . $this->u_action . '">', '</a>');

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

$error = $data = array();

switch ($mode)

{

case 'membership':

$this->page_title = 'UCP_USERGROUPS_MEMBER';

{

$group_id = ($action == 'change_default') ? request_var('default', 0) : request_var('selected', 0);

if (!$group_id)

case 'manage':

$this->page_title = 'UCP_USERGROUPS_MANAGE';

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

include(PHPBB_ROOT_PATH . 'includes/functions_display.' . PHP_EXT);

add_form_key('ucp_groups');

{

trigger_error($user->lang['NOT_ALLOWED_MANAGE_GROUP'] . $return_page, E_USER_WARNING);

}

$group_name = $group_row['group_name'];

$group_type = $group_row['group_type'];

'GROUP_COLOUR' => (isset($group_row['group_colour'])) ? $group_row['group_colour'] : '',

'GROUP_DESC_DISP' => generate_text_for_display($group_row['group_desc'], $group_row['group_desc_uid'], $group_row['group_desc_bitfield'], $group_row['group_desc_options']),

'GROUP_TYPE' => $group_row['group_type'],

'AVATAR' => $avatar_img,

'AVATAR_IMAGE' => $avatar_img,

'AVATAR_WIDTH' => (isset($group_row['group_avatar_width'])) ? $group_row['group_avatar_width'] : '',

$data = $submit_ary = array();

$error = array();

$submit_ary = array(

'colour' => request_var('group_colour', ''),

'rank' => request_var('group_rank', 0),

'message_limit' => request_var('group_message_limit', 0),

'max_recipients'=> request_var('group_max_recipients', 0),

);

// Only set the rank, colour, etc. if it's changed or if we're adding a new

// group. This prevents existing group members being updated if no changes

// were made.

$group_attributes = array();

$test_variables = array('rank', 'colour', 'avatar', 'avatar_type', 'avatar_width', 'avatar_height', 'receive_pm', 'legend', 'message_limit', 'max_recipients');

foreach ($test_variables as $test)

$type_closed = ($group_type == GROUP_CLOSED) ? ' checked="checked"' : '';

$type_hidden = ($group_type == GROUP_HIDDEN) ? ' checked="checked"' : '';

if ($config['allow_avatar_local'] && $display_gallery)

{

avatar_gallery($category, $avatar_select, 4);

}

$avatars_enabled = ($can_upload || ($config['allow_avatar_local'] || $config['allow_avatar_remote'])) ? true : false;

$template->assign_vars(array(

'GROUP_RECEIVE_PM' => (isset($group_row['group_receive_pm']) && $group_row['group_receive_pm']) ? ' checked="checked"' : '',

'GROUP_MESSAGE_LIMIT' => (isset($group_row['group_message_limit'])) ? $group_row['group_message_limit'] : 0,

'GROUP_MAX_RECIPIENTS' => (isset($group_row['group_max_recipients'])) ? $group_row['group_max_recipients'] : 0,

'GROUP_DESC' => $group_desc_data['text'],

'S_DESC_BBCODE_CHECKED' => $group_desc_data['allow_bbcode'],

'S_DESC_URLS_CHECKED' => $group_desc_data['allow_urls'],

if (!sizeof($mark_ary))

{

$start = 0;

do

{

$sql = 'SELECT user_id

$group_name = ($group_row['group_type'] == GROUP_SPECIAL) ? $user->lang['G_' . $group_row['group_name']] : $group_row['group_name'];

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

if (confirm_box(true))

{

// Add user/s to group

add_form_key('ucp_front_subscribed');

if ($unwatch)

{

}

else

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

}

$user->add_lang('viewforum');

{

$s_hidden_fields = array('unbookmark' => 1);

$url = $this->u_action;

if (!sizeof($topics))

$user->add_lang('posting');

$s_hidden_fields = ($edit) ? '<input type="hidden" name="edit" value="' . $draft_id . '" />' : '';

$draft_subject = $draft_message = '';

$template->assign_vars(array(

'L_TITLE' => $user->lang['UCP_MAIN_' . strtoupper($mode)],

'S_HIDDEN_FIELDS' => (isset($s_hidden_fields)) ? $s_hidden_fields : '',

'S_UCP_ACTION' => $this->u_action,

// First Handle Mark actions and moving messages

$mark_option = request_var('mark_option', '');

$dest_folder = request_var('dest_folder', PRIVMSGS_NO_BOX);

// Move PM

if ($move_pm)

{

$cur_folder_id = request_var('cur_folder_id', PRIVMSGS_NO_BOX);

if (move_pm($user->data['user_id'], $user->data['message_limit'], $move_msg_ids, $dest_folder, $cur_folder_id))

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

$address_list = request_var('address_list', array('' => array(0 => '')));

|| $remove_u || $remove_g || $add_to || $add_bcc;

$action = ($delete && !$preview && !$refresh && $submit) ? 'delete' : $action;

$icon_id = request_var('icon', 0);

if ($submit)

{

$s_hidden_fields = '<input type="hidden" name="lastclick" value="' . $current_time . '" />';

$s_hidden_fields .= (isset($check_value)) ? '<input type="hidden" name="status_switch" value="' . $check_value . '" />' : '';

$form_enctype = (@ini_get('file_uploads') == '0' || strtolower(@ini_get('file_uploads')) == 'off' || !$config['allow_pm_attach'] || !$auth->acl_get('u_pm_attach')) ? '' : ' enctype="multipart/form-data"';

'S_HIDDEN_ADDRESS_FIELD' => $s_hidden_address_field,

'S_HIDDEN_FIELDS' => $s_hidden_fields,

'U_PROGRESS_BAR' => append_sid('posting', 'f=0&amp;mode=popup'),

'UA_PROGRESS_BAR' => addslashes(append_sid('posting', 'f=0&amp;mode=popup')),

));

add_form_key('ucp_pm_options');

// Change "full folder" setting - what to do if folder is full

{

check_form_key('ucp_pm_options', $config['form_token_lifetime'], $redirect_url);

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

trigger_error($message);

}

}

// Add Folder

{

if (check_form_key('ucp_pm_options'))

{

}

// Rename folder

{

if (check_form_key('ucp_pm_options'))

{

}

// Remove Folder

{

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

// Move Messages

case 1:

$num_moved = move_pm($user->data['user_id'], $user->data['message_limit'], $msg_ids, $move_to, $remove_folder_id);

// Something went wrong, only partially moved?

if ($num_moved != $folder_row['pm_count'])

{

}

// Add Rule

{

if (check_form_key('ucp_pm_options'))

{

}

// Remove Rule

{

$delete_id = array_keys(request_var('delete_rule', array(0 => 0)));

$delete_id = (!empty($delete_id[0])) ? $delete_id[0] : 0;

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

$num_messages = (int) $db->sql_fetchfield('num_messages');

$db->sql_freeresult($result);

$folder[PRIVMSGS_INBOX] = array(

'folder_name' => $user->lang['PM_INBOX'],

'message_status' => sprintf($user->lang['FOLDER_MESSAGE_STATUS'], $num_messages, $user->data['message_limit'])

function define_cond_option($hardcoded, $cond_option, $rule_option, $global_rule_conditions)

{

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

$template->assign_vars(array(

'S_COND_DEFINED' => true,

'S_COND_SELECT' => (!$hardcoded && isset($global_rule_conditions[$rule_option])) ? true : false)

{

case 'text':

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

$template->assign_vars(array(

'S_TEXT_CONDITION' => true,

'CURRENT_STRING' => $rule_string,

case 'user':

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

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

if ($rule_string && !$rule_user_id)

{

$sql = 'SELECT user_id

{

$sql .= 'WHERE';

}

ORDER BY g.group_type DESC, g.group_name ASC';

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

$s_group_options = '';

$s_class = ($row['group_type'] == GROUP_SPECIAL) ? ' class="sep"' : '';

$s_selected = ($row['group_id'] == $rule_group_id) ? ' selected="selected"' : '';

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

}

$db->sql_freeresult($result);

WHERE user_id = ' . $user_id . '

ORDER BY rule_id ASC';

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

$count = 0;

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

{

{

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

$folder_info = get_pm_from($folder_id, $folder, $user->data['user_id']);

{

$min_post_time = time() - ($sort_days * 86400);

{

$start = 0;

}

{

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

$error = $data = array();

$s_hidden_fields = '';

$user->add_lang('posting');

$error = $data = array();

$s_hidden_fields = '';

include(PHPBB_ROOT_PATH . 'includes/functions_profile_fields.' . PHP_EXT);

$change_lang = request_var('change_lang', '');

$user_lang = request_var('lang', $user->lang_name);

add_form_key('ucp_register_terms');

}

if ($config['enable_confirm'])

{

include(PHPBB_ROOT_PATH . 'includes/captcha/captcha_factory.' . PHP_EXT);

$captcha = phpbb_captcha_factory::get_instance($config['captcha_plugin']);

$captcha->init(CONFIRM_REG);

}

if ($change_lang || $user_lang != $config['default_lang'])

{

$use_lang = ($change_lang) ? basename($change_lang) : basename($user_lang);

$submit = false;

// Setting back agreed to let the user view the agreement in his/her language

}

$user->lang_name = $lang = $use_lang;

{

$add_lang = ($change_lang) ? '&amp;change_lang=' . urlencode($change_lang) : '';

$add_coppa = ($coppa !== false) ? '&amp;coppa=' . $coppa : '';

$s_hidden_fields = array();

// If we change the language, we want to pass on some more possible parameter.

'lang' => $user->lang_name,

'tz' => request_var('tz', (float) $config['board_timezone']),

));

if ($config['enable_confirm'])

{

$s_hidden_fields = array_merge($s_hidden_fields, $captcha->get_hidden_fields());

{

$str = '';

}

$template->assign_vars(array(

'L_CONFIRM_EXPLAIN' => sprintf($user->lang['CONFIRM_EXPLAIN'], '<a href="mailto:' . htmlspecialchars($config['board_contact']) . '">', '</a>'),

'S_CAPTCHA' => $captcha->get_template(),

$l_reg_cond = $user->lang['UCP_ADMIN_ACTIVATE'];

break;

}

$template->assign_vars(array(

'ERROR' => (sizeof($error)) ? implode('<br />', $error) : '',

'USERNAME' => $data['username'],

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

$email = strtolower(request_var('email', ''));

if ($submit)

{

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

$email = strtolower(request_var('email', ''));

add_form_key('ucp_resend');

{

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

$s_hidden_fields = '';

$l_mode = strtoupper($mode);

$draft_id = request_var('d', 0);

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

$mode = ($delete && !$preview && !$refresh && $submit) ? 'delete' : request_var('mode', '');

$error = $post_data = array();

$captcha = phpbb_captcha_factory::get_instance($config['captcha_plugin']);

$captcha->init(CONFIRM_POST);

}

// Was cancel pressed? If so then redirect to the appropriate page

if ($cancel || ($current_time - $lastclick < 2 && $submit))

{

$post_data['topic_time_limit'] = request_var('topic_time_limit', (($mode != 'post') ? (int) $post_data['topic_time_limit'] : 0));

$post_data['icon_id'] = request_var('icon', 0);

if ($config['allow_topic_notify'] && $user->data['is_registered'])

{

}

else

{

$notify = false;

}

if ($submit)

{

$post_data['poll_length'] = request_var('poll_length', 0);

$post_data['poll_option_text'] = utf8_normalize_nfc(request_var('poll_option_text', '', true));

$post_data['poll_max_options'] = request_var('poll_max_options', 1);

}

// If replying/quoting and last post id has changed

$s_hidden_fields = ($mode == 'reply' || $mode == 'quote') ? '<input type="hidden" name="topic_cur_post_id" value="' . $post_data['topic_last_post_id'] . '" />' : '';

$s_hidden_fields .= '<input type="hidden" name="lastclick" value="' . $current_time . '" />';

// Add the confirm id/code pair to the hidden fields, else an error is displayed on next submit/preview

if ($solved_captcha !== false)

'UA_PROGRESS_BAR' => addslashes(append_sid('posting', "f=$forum_id&amp;mode=popup")),

'S_PRIVMSGS' => false,

'S_EDIT_POST' => ($mode == 'edit') ? true : false,

'S_EDIT_REASON' => ($mode == 'edit' && $auth->acl_get('m_edit', $forum_id)) ? true : false,

'S_DISPLAY_USERNAME' => (!$user->data['is_registered'] || ($mode == 'edit' && $post_data['poster_id'] == ANONYMOUS)) ? true : false,

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

$user_notify = ($user->data['is_registered']) ? request_var('notify', 0) : false;

if (!$post_id)

{

$redirect_url = append_sid('viewtopic', "f=$forum_id&amp;p=$post_id") . "#p$post_id";

// Has the report been cancelled?

{

redirect($redirect_url);

}

if ($config['load_anon_lastread'] || ($user->data['is_registered'] && !$config['load_db_lastread']))

{

$tracking_topics = ($tracking_topics) ? tracking_unserialize($tracking_topics) : array();

}

break;

case 'register':

{

redirect(append_sid('index'));

}

break;

case 'logout':

{

$user->session_kill();

$user->session_begin();

{

$set_time = time() - 31536000;

foreach ($cookies as $cookie_name)

{

$cookie_name = str_replace($config['cookie_name'] . '_', '', $cookie_name);

$user->setup('viewforum', $forum_data['forum_style']);

// Redirect to login upon emailed notification links

{

login_box('', $user->lang['LOGIN_NOTIFY_FORUM']);

}

$topics_count = (int) $db->sql_fetchfield('num_topics');

$db->sql_freeresult($result);

{

$start = 0;

}

}

// Redirect to login or to the correct post upon emailed notification links

{

$jump_to = request_var('e', 0);

$limit_posts_time = "AND p.post_time >= $min_post_time ";

{

$start = 0;

}

// Cookie based guest tracking ... I don't like this but hum ho

// it's oft requested. This relies on "nice" users who don't feel

// the need to delete cookies to mess with results.

if (!empty($cur_voted_list))

{

$cur_voted_id = array_map('intval', explode(',', $cur_voted_list));

// We overwrite the 'f' request variable if there is no forum specified

// to be able to display the correct online list.

// One downside is that the user currently viewing this topic/post is not taken into account.

{

}

// Output the page