$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&form=acp_ban&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 . "&id=$bot_id&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 . "&id=$bot_id&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);