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

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

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

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

- 'img_imagick' => array('lang' => 'IMAGICK_PATH', 'validate' => 'path', 'type' => 'text:20:200', 'explain' => true, 'append' => '&nbsp;&nbsp;<span>[ <a href="' . $this->u_action . '&amp;action=imgmagick">' . $user->lang['SEARCH_IMAGICK'] . '</a> ]</span>'),

- $cfg_array = (isset($_REQUEST['config'])) ? request_var('config', array('' => '')) : $this->new_config;

- if (sizeof($error))

- $size_var = request_var($config_name, '');

- set_config($config_name, $config_value);

- add_log('admin', 'LOG_CONFIG_ATTACH');

- if (!sizeof($error))

- if (!$this->new_config['img_imagick'] && (!isset($supported_types['format']) || !sizeof($supported_types['format'])))

- 'S_THUMBNAIL_SUPPORT' => (!$this->new_config['img_imagick'] && (!isset($supported_types['format']) || !sizeof($supported_types['format']))) ? false : true)

- 'S_WARNING' => (sizeof($error)) ? true : false,

- $extension_change_list = request_var('extension_change_list', array(0));

- $group_select_list = request_var('group_select', array(0));

- for ($i = 0, $size = sizeof($extension_change_list); $i < $size; $i++)

- add_log('admin', 'LOG_ATTACH_EXT_UPDATE', $row['extension']);

- $extension_id_list = request_var('extension_id_list', array(0));

- if (sizeof($extension_id_list))

- add_log('admin', 'LOG_ATTACH_EXT_DEL', $extension_list);

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

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

- if (!sizeof($error))

- if (!sizeof($error))

- add_log('admin', 'LOG_ATTACH_EXT_ADD', $add_extension);

- if (!sizeof($error))

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

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

- $group_name = utf8_normalize_nfc(request_var('group_name', '', true));

- if (!sizeof($error))

- $upload_icon = request_var('upload_icon', 'no_image');

- $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);

- if (!sizeof($allowed_forums))

- 'cat_id' => request_var('special_category', ATTACHMENT_CATEGORY_NONE),

- add_log('admin', 'LOG_ATTACH_EXTGROUP_' . strtoupper($action), $group_name);

- $extension_list = request_var('extensions', array(0));

- if ($action == 'edit' && sizeof($extension_list))

- if (sizeof($extension_list))

- if (!sizeof($error))

- ATTACHMENT_CATEGORY_WM => $user->lang['CAT_WM_FILES'],

- ATTACHMENT_CATEGORY_RM => $user->lang['CAT_RM_FILES'],

- ATTACHMENT_CATEGORY_QUICKTIME => $user->lang['CAT_QUICKTIME_FILES'],

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

- add_log('admin', 'LOG_ATTACH_EXTGROUP_DEL', $group_name);

- 'group_name' => utf8_normalize_nfc(request_var('group_name', '', true)),

- $extensions = array();

-

- 'S_FORUM_IDS' => (sizeof($forum_ids)) ? true : false,

- $delete_files = (isset($_POST['delete'])) ? array_keys(request_var('delete', array('' => 0))) : array();

- $add_files = (isset($_POST['add'])) ? array_keys(request_var('add', array('' => 0))) : array();

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

- if (sizeof($delete_files))

- phpbb_unlink($row['physical_filename'], 'file');

- phpbb_unlink($row['physical_filename'], 'thumbnail');

- if (sizeof($delete_files))

- add_log('admin', 'LOG_ATTACH_ORPHAN_DEL', implode(', ', $delete_files));

- if (sizeof($upload_list))

- add_log('admin', 'LOG_ATTACH_FILEUPLOAD', $post_row['post_id'], $row['real_filename']);

- set_config_count('upload_dir_size', $space_taken, true);

- set_config_count('num_files', $files_added, true);

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

- $delete_files = (isset($_POST['delete'])) ? array_keys(request_var('delete', array('' => 0))) : array();

- if (sizeof($delete_files))

- if ($num_deleted = delete_attachments('attach', $delete_files))

- if (sizeof($delete_files) != $num_deleted)

- add_log('admin', 'LOG_ATTACHMENTS_DELETED', implode(', ', $deleted_filenames));

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

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

- $sort_key = request_var('sk', 't');

- $sort_dir = request_var('sd', 'd');

- for ($i = 0, $end = sizeof($attachments_list); $i < $end; ++$i)

- $display_cat = $extensions[$row['extension']]['display_cat'];

- if (sizeof($error))

- if (sizeof($notify))

- ATTACHMENT_CATEGORY_WM => $user->lang['CAT_WM_FILES'],

- ATTACHMENT_CATEGORY_RM => $user->lang['CAT_RM_FILES'],

- ATTACHMENT_CATEGORY_QUICKTIME => $user->lang['CAT_QUICKTIME_FILES'],

- for ($i = 0; $i < sizeof($group_name); $i++)

- phpbb_chmod($phpbb_root_path . $upload_dir, CHMOD_READ | CHMOD_WRITE);

- if (!phpbb_is_writable($phpbb_root_path . $upload_dir))

- global $db, $user;

- global $request;

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

- $ip_2_fragment = 256;

- $ip_3_fragment = 256;

- $ip_4_fragment = 256;

- if (sizeof($iplist))

- if (sizeof($hostlist))

- add_log('admin', $log_entry, $ip_list_log);

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

- if (sizeof($unip_sql))

- add_log('admin', 'LOG_DOWNLOAD_REMOVE_IP', $l_unip_list);

- // size="8" and maxlength="15" attributes as a fallback for browsers that do not support type="number" yet.

- return '<input type="number" id="' . $key . '" size="8" maxlength="15" min="0" name="config[' . $key . ']" value="' . $value . '" /> <select name="' . $key . '">' . size_select_options($size_var) . '</select>';

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

- $l_ban_cell = $user->lang['USERNAME'];

- $l_ban_cell = $user->lang['IP_HOSTNAME'];

- $l_ban_cell = $user->lang['EMAIL_ADDRESS'];

- global $db, $user, $auth, $template, $cache, $request, $phpbb_dispatcher;

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

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

- $bbcode_id = request_var('bbcode', 0);

- $display_on_posting = request_var('display_on_posting', 0);

- $bbcode_match = request_var('bbcode_match', '');

- $bbcode_tpl = htmlspecialchars_decode(utf8_normalize_nfc(request_var('bbcode_tpl', '', true)));

- $bbcode_helpline = utf8_normalize_nfc(request_var('bbcode_helpline', '', true));

- $bbcode_id = $row['max_bbcode_id'] + 1;

- add_log('admin', $log_action, $data['bbcode_tag']);

- add_log('admin', 'LOG_BBCODE_DELETE', $row['bbcode_tag']);

- * @var string sql_ary The SQL array to get custom bbcode data

- $utf8_pcre_properties = phpbb_pcre_utf8_support();

-

- ($utf8_pcre_properties) ? '!([\p{L}\p{N}\-+,_. ]+)!u' : '!([a-zA-Z0-9\-+,_. ]+)!u' => "$1"

- 'INTTEXT' => ($utf8_pcre_properties) ? '([\p{L}\p{N}\-+,_. ]+)' : '([a-zA-Z0-9\-+,_. ]+)',

- $modifiers .= ($utf8 && $utf8_pcre_properties) ? 'u' : '';

- $repad = $pad + sizeof(array_unique($repad[0]));

- $replace = preg_replace('/(?<!\\\\)\$([0-9]+)/e', "'\${' . (\$1 + \$pad) . '}'", $replace);

- $bbcode_tag = preg_replace('/.*?\[([a-z0-9_-]+=?).*/i', '$1', $bbcode_match);

- $bbcode_search = preg_replace('/.*?\[([a-z0-9_-]+)=?.*/i', '$1', $bbcode_match);

- if (!preg_match('/^[a-zA-Z0-9_-]+=?$/', $bbcode_tag))

- $fp_match = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $fp_match);

- $fp_replace = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $fp_replace);

- $sp_match = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $sp_match);

- $sp_replace = preg_replace('#\[/?' . $bbcode_search . '#ie', "strtolower('\$0')", $sp_replace);

- var $new_config = array();

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

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

- global $cache, $phpbb_container, $phpbb_dispatcher;

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

- 'cookie_domain' => array('lang' => 'COOKIE_DOMAIN', 'validate' => 'string', 'type' => 'text::255', 'explain' => false),

- 'cookie_name' => array('lang' => 'COOKIE_NAME', 'validate' => 'string', 'type' => 'text::16', 'explain' => false),

- 'cookie_path' => array('lang' => 'COOKIE_PATH', 'validate' => 'string', 'type' => 'text::255', 'explain' => false),

- 'cookie_secure' => array('lang' => 'COOKIE_SECURE', 'validate' => 'bool', 'type' => 'radio:disabled_enabled', 'explain' => true),

- 'email_function_name' => array('lang' => 'EMAIL_FUNCTION_NAME', 'validate' => 'string', 'type' => 'text:20:50', 'explain' => true),

- 'smtp_host' => array('lang' => 'SMTP_SERVER', 'validate' => 'string', 'type' => 'text:25:50', 'explain' => false),

- $this->new_config = $config;

- $cfg_array = (isset($_REQUEST['config'])) ? utf8_normalize_nfc(request_var('config', array('' => ''), true)) : $this->new_config;

- if (sizeof($error))

- foreach ($display_vars['vars'] as $config_name => $null)

- if (isset($cfg_array[$config_name])) {

- if ($config_name == 'email_function_name')

- {

- $this->new_config['email_function_name'] = trim(str_replace(array('(', ')'), array('', ''), $this->new_config['email_function_name']));

- $this->new_config['email_function_name'] = (empty($this->new_config['email_function_name']) || !function_exists($this->new_config['email_function_name'])) ? 'mail' : $this->new_config['email_function_name'];

- $config_value = $this->new_config['email_function_name'];

- }

-

- set_config($config_name, $config_value);

- enable_bitfield_column_flag(FORUMS_TABLE, 'forum_flags', log(FORUM_FLAG_QUICK_REPLY, 2));

- set_config($field, '');

- set_config($field, $config_value);

- set_config($config_name, $config_value);

- set_config('auth_method', basename($cfg_array['auth_method']));

- add_log('admin', 'LOG_CONFIG_' . strtoupper($mode));

- 'S_ERROR' => (sizeof($error)) ? true : false,

- global $phpbb_root_path, $phpEx, $phpbb_container;

- $auth_plugins = array();

- return '<input id="' . $key . '" type="number" size="3" maxlength="3" min="1" max="999" name="config[min_name_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="number" size="3" maxlength="3" min="8" max="180" name="config[max_name_chars]" value="' . $this->new_config['max_name_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

- return '<input id="' . $key . '" type="number" size="3" maxlength="3" min="1" max="999" name="config[min_pass_chars]" value="' . $value . '" /> ' . $user->lang['MIN_CHARS'] . '&nbsp;&nbsp;<input type="number" size="3" maxlength="3" min="8" max="255" name="config[max_pass_chars]" value="' . $this->new_config['max_pass_chars'] . '" /> ' . $user->lang['MAX_CHARS'];

- global $user;

-

- <input type=\"text\" name=\"config[$key]\" id=\"$key\" value=\"$value\" maxlength=\"30\" />";

- global $user, $config;

-

- global $user, $config;

-

- global $db, $cache;

- $values = request_var($key, array(0 => 0));

- if (sizeof($values))

- global $user, $config;

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

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

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

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

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

- if ($bot_id || sizeof($mark))

- if ($bot_id || sizeof($mark))

- if ($bot_id || sizeof($mark))

- if (sizeof($user_id_ary))

- add_log('admin', 'LOG_BOT_DELETE', implode(', ', $bot_name_ary));

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

- 'bot_name' => utf8_normalize_nfc(request_var('bot_name', '', true)),

- 'bot_agent' => request_var('bot_agent', ''),

- 'bot_ip' => request_var('bot_ip', ''),

- 'bot_active' => request_var('bot_active', true),

- 'bot_lang' => request_var('bot_lang', $config['default_lang']),

- 'bot_style' => request_var('bot_style' , $config['default_style']),

- if (!sizeof($error))

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

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

- 'S_ERROR' => (sizeof($error)) ? true : false,

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

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

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

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

- 'enable_confirm' => array('tpl' => 'REG_ENABLE', 'default' => false),

- 'enable_post_confirm' => array('tpl' => 'POST_ENABLE', 'default' => false),

- 'confirm_refresh' => array('tpl' => 'CONFIRM_REFRESH', 'default' => false),

- 'max_reg_attempts' => array('tpl' => 'REG_LIMIT', 'default' => 0),

- 'max_login_attempts' => array('tpl' => 'MAX_LOGIN_ATTEMPTS', 'default' => 0),

- $submit = request_var('main_submit', false);

- if ($submit && check_form_key($form_key))

- set_config($config_var, request_var($config_var, $options['default']));

- set_config('captcha_plugin', $selected);

- add_log('admin', 'LOG_CONFIG_VISUAL');

- else if ($submit)

- {

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

- }

- $template->assign_var($options['tpl'], (isset($_POST[$config_var])) ? request_var($config_var, $options['default']) : $config[$config_var]) ;

- global $db, $user, $config, $phpbb_container;

- 'BBCODE_STATUS' => $user->lang('BBCODE_IS_ON', '<a href="' . append_sid("{$phpbb_root_path}faq.$phpEx", 'mode=bbcode') . '">', '</a>'),

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

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

- $this->db_tools = new \phpbb\db\tools($db);

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

- $submit = (isset($_POST['submit'])) ? true : false;

- $type = request_var('type', '');

- $table = array_intersect($this->db_tools->sql_list_tables(), request_var('table', array('')));

- $format = request_var('method', '');

- $where = request_var('where', '');

- if (!sizeof($table))

- switch ($db->get_sql_layer())

- {

- case 'mysqli':

- case 'mysql4':

- case 'mysql':

- $extractor = new mysql_extractor($format, $filename, $time, $download, $store);

- break;

- case 'sqlite':

- $extractor = new sqlite_extractor($format, $filename, $time, $download, $store);

- break;

-

- case 'sqlite3':

- $extractor = new sqlite3_extractor($format, $filename, $time, $download, $store);

- break;

-

- case 'postgres':

- $extractor = new postgres_extractor($format, $filename, $time, $download, $store);

- break;

-

- case 'oracle':

- $extractor = new oracle_extractor($format, $filename, $time, $download, $store);

- break;

-

- case 'mssql':

- case 'mssql_odbc':

- case 'mssqlnative':

- $extractor = new mssql_extractor($format, $filename, $time, $download, $store);

- break;

- }

- case 'sqlite':

- case 'mssql':

- add_log('admin', 'LOG_DB_BACKUP');

- $delete = request_var('delete', '');

- $file = request_var('file', '');

- $download = request_var('download', '');

- add_log('admin', 'LOG_DB_DELETE');

- case 'sqlite':

- case 'mssql':

- add_log('admin', 'LOG_DB_RESTORE');

-class base_extractor

-{

- var $fh;

- var $fp;

- var $write;

- var $close;

- var $store;

- var $download;

- var $time;

- var $format;

- var $run_comp = false;

-

- function base_extractor($format, $filename, $time, $download = false, $store = false)

- {

- global $request;

-

- $this->download = $download;

- $this->store = $store;

- $this->time = $time;

- $this->format = $format;

-

- switch ($format)

- {

- case 'text':

- $ext = '.sql';

- $open = 'fopen';

- $this->write = 'fwrite';

- $this->close = 'fclose';

- $mimetype = 'text/x-sql';

- break;

- case 'bzip2':

- $ext = '.sql.bz2';

- $open = 'bzopen';

- $this->write = 'bzwrite';

- $this->close = 'bzclose';

- $mimetype = 'application/x-bzip2';

- break;

- case 'gzip':

- $ext = '.sql.gz';

- $open = 'gzopen';

- $this->write = 'gzwrite';

- $this->close = 'gzclose';

- $mimetype = 'application/x-gzip';

- break;

- }

-

- if ($download == true)

- {

- $name = $filename . $ext;

- header('Cache-Control: private, no-cache');

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

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

-

- switch ($format)

- {

- case 'bzip2':

- ob_start();

- break;

-

- case 'gzip':

- if (strpos($request->header('Accept-Encoding'), 'gzip') !== false && strpos(strtolower($request->header('User-Agent')), 'msie') === false)

- {

- ob_start('ob_gzhandler');

- }

- else

- {

- $this->run_comp = true;

- }

- break;

- }

- }

-

- if ($store == true)

- {

- global $phpbb_root_path;

- $file = $phpbb_root_path . 'store/' . $filename . $ext;

-

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

-

- if (!$this->fp)

- {

- trigger_error('FILE_WRITE_FAIL', E_USER_ERROR);

- }

- }

- }

-

- function write_end()

- {

- static $close;

-

- if ($this->store)

- {

- if ($close === null)

- {

- $close = $this->close;

- }

- $close($this->fp);

- }

-

- // bzip2 must be written all the way at the end

- if ($this->download && $this->format === 'bzip2')

- {

- $c = ob_get_clean();

- echo bzcompress($c);

- }

- }

-

- function flush($data)

- {

- static $write;

- if ($this->store === true)

- {

- if ($write === null)

- {

- $write = $this->write;

- }

- $write($this->fp, $data);

- }

-

- if ($this->download === true)

- {

- if ($this->format === 'bzip2' || $this->format === 'text' || ($this->format === 'gzip' && !$this->run_comp))

- {

- echo $data;

- }

-

- // we can write the gzip data as soon as we get it

- if ($this->format === 'gzip')

- {

- if ($this->run_comp)

- {

- echo gzencode($data);

- }

- else

- {

- ob_flush();

- flush();

- }

- }

- }

- }

-}

-

-class mysql_extractor extends base_extractor

-{

- function write_start($table_prefix)

- {

- $sql_data = "#\n";

- $sql_data .= "# phpBB Backup Script\n";

- $sql_data .= "# Dump of tables for $table_prefix\n";

- $sql_data .= "# DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

- $sql_data .= "#\n";

- $this->flush($sql_data);

- }

-

- function write_table($table_name)

- {

- global $db;

- static $new_extract;

-

- if ($new_extract === null)

- {

- if ($db->get_sql_layer() === 'mysqli' || version_compare($db->sql_server_info(true), '3.23.20', '>='))

- {

- $new_extract = true;

- }

- else

- {

- $new_extract = false;

- }

- }

-

- if ($new_extract)

- {

- $this->new_write_table($table_name);

- }

- else

- {

- $this->old_write_table($table_name);

- }

- }

-

- function write_data($table_name)

- {

- global $db;

- if ($db->get_sql_layer() === 'mysqli')

- {

- $this->write_data_mysqli($table_name);

- }

- else

- {

- $this->write_data_mysql($table_name);

- }

- }

-

- function write_data_mysqli($table_name)

- {

- global $db;

- $sql = "SELECT *

- FROM $table_name";

- $result = mysqli_query($db->get_db_connect_id(), $sql, MYSQLI_USE_RESULT);

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

- }

-

- $search = array("\\", "'", "\x00", "\x0a", "\x0d", "\x1a", '"');

- $replace = array("\\\\", "\\'", '\0', '\n', '\r', '\Z', '\\"');

- $fields = implode(', ', $field_set);

- $sql_data = 'INSERT INTO ' . $table_name . ' (' . $fields . ') VALUES ';

- $first_set = true;

- $query_len = 0;

- $max_len = get_usable_memory();

-

- while ($row = mysqli_fetch_row($result))

- {

- $values = array();

- if ($first_set)

- {

- $query = $sql_data . '(';

- }

- else

- {

- $query .= ',(';

- }

-

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

- {

- if (!isset($row[$j]) || is_null($row[$j]))

- {

- $values[$j] = 'NULL';

- }

- else if (($field[$j]->flags & 32768) && !($field[$j]->flags & 1024))

- {

- $values[$j] = $row[$j];

- }

- else

- {

- $values[$j] = "'" . str_replace($search, $replace, $row[$j]) . "'";

- }

- }

- $query .= implode(', ', $values) . ')';

-

- $query_len += strlen($query);

- if ($query_len > $max_len)

- {

- $this->flush($query . ";\n\n");

- $query = '';

- $query_len = 0;

- $first_set = true;

- }

- else

- {

- $first_set = false;

- }

- }

- mysqli_free_result($result);

-

- // check to make sure we have nothing left to flush

- if (!$first_set && $query)

- {

- $this->flush($query . ";\n\n");

- }

- }

- }

-

- function write_data_mysql($table_name)

- {

- global $db;

- $sql = "SELECT *

- FROM $table_name";

- $result = mysql_unbuffered_query($sql, $db->get_db_connect_id());

-

- if ($result != false)

- {

- $fields_cnt = mysql_num_fields($result);

-

- // Get field information

- $field = array();

- for ($i = 0; $i < $fields_cnt; $i++)

- {

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

- }

- $field_set = array();

-

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

- {

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

- }

-

- $search = array("\\", "'", "\x00", "\x0a", "\x0d", "\x1a", '"');

- $replace = array("\\\\", "\\'", '\0', '\n', '\r', '\Z', '\\"');

- $fields = implode(', ', $field_set);

- $sql_data = 'INSERT INTO ' . $table_name . ' (' . $fields . ') VALUES ';

- $first_set = true;

- $query_len = 0;

- $max_len = get_usable_memory();

-

- while ($row = mysql_fetch_row($result))

- {

- $values = array();

- if ($first_set)

- {

- $query = $sql_data . '(';

- }

- else

- {

- $query .= ',(';

- }

-

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

- {

- if (!isset($row[$j]) || is_null($row[$j]))

- {

- $values[$j] = 'NULL';

- }

- else if ($field[$j]->numeric && ($field[$j]->type !== 'timestamp'))

- {

- $values[$j] = $row[$j];

- }

- else

- {

- $values[$j] = "'" . str_replace($search, $replace, $row[$j]) . "'";

- }

- }

- $query .= implode(', ', $values) . ')';

-

- $query_len += strlen($query);

- if ($query_len > $max_len)

- {

- $this->flush($query . ";\n\n");

- $query = '';

- $query_len = 0;

- $first_set = true;

- }

- else

- {

- $first_set = false;

- }

- }

- mysql_free_result($result);

-

- // check to make sure we have nothing left to flush

- if (!$first_set && $query)

- {

- $this->flush($query . ";\n\n");

- }

- }

- }

-

- function new_write_table($table_name)

- {

- global $db;

-

- $sql = 'SHOW CREATE TABLE ' . $table_name;

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

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

-

- $sql_data = '# Table: ' . $table_name . "\n";

- $sql_data .= "DROP TABLE IF EXISTS $table_name;\n";

- $this->flush($sql_data . $row['Create Table'] . ";\n\n");

-

- $db->sql_freeresult($result);

- }

-

- function old_write_table($table_name)

- {

- global $db;

-

- $sql_data = '# Table: ' . $table_name . "\n";

- $sql_data .= "DROP TABLE IF EXISTS $table_name;\n";

- $sql_data .= "CREATE TABLE $table_name(\n";

- $rows = array();

-

- $sql = "SHOW FIELDS

- FROM $table_name";

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

-

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

- {

- $line = ' ' . $row['Field'] . ' ' . $row['Type'];

-

- if (!is_null($row['Default']))

- {

- $line .= " DEFAULT '{$row['Default']}'";

- }

-

- if ($row['Null'] != 'YES')

- {

- $line .= ' NOT NULL';

- }

-

- if ($row['Extra'] != '')

- {

- $line .= ' ' . $row['Extra'];

- }

-

- $rows[] = $line;

- }

- $db->sql_freeresult($result);

-

- $sql = "SHOW KEYS

- FROM $table_name";

-

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

-

- $index = array();

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

- {

- $kname = $row['Key_name'];

-

- if ($kname != 'PRIMARY')

- {

- if ($row['Non_unique'] == 0)

- {

- $kname = "UNIQUE|$kname";

- }

- }

-

- if ($row['Sub_part'])

- {

- $row['Column_name'] .= '(' . $row['Sub_part'] . ')';

- }

- $index[$kname][] = $row['Column_name'];

- }

- $db->sql_freeresult($result);

-

- foreach ($index as $key => $columns)

- {

- $line = ' ';

-

- if ($key == 'PRIMARY')

- {

- $line .= 'PRIMARY KEY (' . implode(', ', $columns) . ')';

- }

- else if (strpos($key, 'UNIQUE') === 0)

- {

- $line .= 'UNIQUE ' . substr($key, 7) . ' (' . implode(', ', $columns) . ')';

- }

- else if (strpos($key, 'FULLTEXT') === 0)

- {

- $line .= 'FULLTEXT ' . substr($key, 9) . ' (' . implode(', ', $columns) . ')';

- }

- else

- {

- $line .= "KEY $key (" . implode(', ', $columns) . ')';

- }

-

- $rows[] = $line;

- }

-

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

- $sql_data .= "\n);\n\n";

-

- $this->flush($sql_data);

- }

-}

-

-class sqlite_extractor extends base_extractor

-{

- function write_start($prefix)

- {

- $sql_data = "--\n";

- $sql_data .= "-- phpBB Backup Script\n";

- $sql_data .= "-- Dump of tables for $prefix\n";

- $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

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

- $sql_data .= "BEGIN TRANSACTION;\n";

- $this->flush($sql_data);

- }

-

- function write_table($table_name)

- {

- global $db;

- $sql_data = '-- Table: ' . $table_name . "\n";

- $sql_data .= "DROP TABLE $table_name;\n";

-

- $sql = "SELECT sql

- FROM sqlite_master

- WHERE type = 'table'

- AND name = '" . $db->sql_escape($table_name) . "'

- ORDER BY type DESC, name;";

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

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

- $db->sql_freeresult($result);

-

- // Create Table

- $sql_data .= $row['sql'] . ";\n";

-

- $result = $db->sql_query("PRAGMA index_list('" . $db->sql_escape($table_name) . "');");

-

- $ar = array();

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

- {

- $ar[] = $row;

- }

- $db->sql_freeresult($result);

-

- foreach ($ar as $value)

- {

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

- {

- continue;

- }

-

- $result = $db->sql_query("PRAGMA index_info('" . $db->sql_escape($value['name']) . "');");

-

- $fields = array();

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

- {

- $fields[] = $row['name'];

- }

- $db->sql_freeresult($result);

-

- $sql_data .= 'CREATE ' . ($value['unique'] ? 'UNIQUE ' : '') . 'INDEX ' . $value['name'] . ' on ' . $table_name . ' (' . implode(', ', $fields) . ");\n";

- }

-

- $this->flush($sql_data . "\n");

- }

-

- function write_data($table_name)

- {

- global $db;

-

- $col_types = sqlite_fetch_column_types($db->get_db_connect_id(), $table_name);

-

- $sql = "SELECT *

- FROM $table_name";

- $result = sqlite_unbuffered_query($db->get_db_connect_id(), $sql);

- $rows = sqlite_fetch_all($result, SQLITE_ASSOC);

- $sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

- foreach ($rows as $row)

- {

- foreach ($row as $column_name => $column_data)

- {

- if (is_null($column_data))

- {

- $row[$column_name] = 'NULL';

- }

- else if ($column_data == '')

- {

- $row[$column_name] = "''";

- }

- else if (strpos($col_types[$column_name], 'text') !== false || strpos($col_types[$column_name], 'char') !== false || strpos($col_types[$column_name], 'blob') !== false)

- {

- $row[$column_name] = sanitize_data_generic(str_replace("'", "''", $column_data));

- }

- }

- $this->flush($sql_insert . implode(', ', $row) . ");\n");

- }

- }

-

- function write_end()

- {

- $this->flush("COMMIT;\n");

- parent::write_end();

- }

-}

-

-class sqlite3_extractor extends base_extractor

-{

- function write_start($prefix)

- {

- $sql_data = "--\n";

- $sql_data .= "-- phpBB Backup Script\n";

- $sql_data .= "-- Dump of tables for $prefix\n";

- $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

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

- $sql_data .= "BEGIN TRANSACTION;\n";

- $this->flush($sql_data);

- }

-

- function write_table($table_name)

- {

- global $db;

- $sql_data = '-- Table: ' . $table_name . "\n";

- $sql_data .= "DROP TABLE $table_name;\n";

-

- $sql = "SELECT sql

- FROM sqlite_master

- WHERE type = 'table'

- AND name = '" . $db->sql_escape($table_name) . "'

- ORDER BY name ASC;";

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

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

- $db->sql_freeresult($result);

-

- // Create Table

- $sql_data .= $row['sql'] . ";\n";

-

- $result = $db->sql_query("PRAGMA index_list('" . $db->sql_escape($table_name) . "');");

-

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

- {

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

- {

- continue;

- }

-

- $result2 = $db->sql_query("PRAGMA index_info('" . $db->sql_escape($row['name']) . "');");

-

- $fields = array();

- while ($row2 = $db->sql_fetchrow($result2))

- {

- $fields[] = $row2['name'];

- }

- $db->sql_freeresult($result2);

-

- $sql_data .= 'CREATE ' . ($row['unique'] ? 'UNIQUE ' : '') . 'INDEX ' . $row['name'] . ' ON ' . $table_name . ' (' . implode(', ', $fields) . ");\n";

- }

- $db->sql_freeresult($result);

-

- $this->flush($sql_data . "\n");

- }

-

- function write_data($table_name)

- {

- global $db;

-

- $result = $db->sql_query("PRAGMA table_info('" . $db->sql_escape($table_name) . "');");

-

- $col_types = array();

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

- {

- $col_types[$row['name']] = $row['type'];

- }

- $db->sql_freeresult($result);

-

- $sql_insert = 'INSERT INTO ' . $table_name . ' (' . implode(', ', array_keys($col_types)) . ') VALUES (';

-

- $sql = "SELECT *

- FROM $table_name";

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

-

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

- {

- foreach ($row as $column_name => $column_data)

- {

- if (is_null($column_data))

- {

- $row[$column_name] = 'NULL';

- }

- else if ($column_data === '')

- {

- $row[$column_name] = "''";

- }

- else if (stripos($col_types[$column_name], 'text') !== false || stripos($col_types[$column_name], 'char') !== false || stripos($col_types[$column_name], 'blob') !== false)

- {

- $row[$column_name] = sanitize_data_generic(str_replace("'", "''", $column_data));

- }

- }

- $this->flush($sql_insert . implode(', ', $row) . ");\n");

- }

- }

-

- function write_end()

- {

- $this->flush("COMMIT;\n");

- parent::write_end();

- }

-}

-

-class postgres_extractor extends base_extractor

-{

- function write_start($prefix)

- {

- $sql_data = "--\n";

- $sql_data .= "-- phpBB Backup Script\n";

- $sql_data .= "-- Dump of tables for $prefix\n";

- $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

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

- $sql_data .= "BEGIN TRANSACTION;\n";

- $this->flush($sql_data);

- }

-

- function write_table($table_name)

- {

- global $db;

- static $domains_created = array();

-

- $sql = "SELECT a.domain_name, a.data_type, a.character_maximum_length, a.domain_default

- FROM INFORMATION_SCHEMA.domains a, INFORMATION_SCHEMA.column_domain_usage b

- WHERE a.domain_name = b.domain_name

- AND b.table_name = '{$table_name}'";

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

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

- {

- if (empty($domains_created[$row['domain_name']]))

- {

- $domains_created[$row['domain_name']] = true;

- //$sql_data = "DROP DOMAIN {$row['domain_name']};\n";

- $sql_data = "CREATE DOMAIN {$row['domain_name']} as {$row['data_type']}";

- if (!empty($row['character_maximum_length']))

- {

- $sql_data .= '(' . $row['character_maximum_length'] . ')';

- }

- $sql_data .= ' NOT NULL';

- if (!empty($row['domain_default']))

- {

- $sql_data .= ' DEFAULT ' . $row['domain_default'];

- }

- $this->flush($sql_data . ";\n");

- }

- }

-

- $sql_data = '-- Table: ' . $table_name . "\n";

- $sql_data .= "DROP TABLE $table_name;\n";

- // PGSQL does not "tightly" bind sequences and tables, we must guess...

- $sql = "SELECT relname

- FROM pg_class

- WHERE relkind = 'S'

- AND relname = '{$table_name}_seq'";

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

- // We don't even care about storing the results. We already know the answer if we get rows back.

- if ($db->sql_fetchrow($result))

- {

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

- $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) . "'

- AND a.attnum > 0

- AND a.attrelid = c.oid

- AND a.atttypid = t.oid

- ORDER BY a.attnum";

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

-

- $sql_data .= "CREATE TABLE $table_name(\n";

- $lines = array();

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

- {

- // Get the data from the table

- $sql_get_default = "SELECT pg_get_expr(d.adbin, d.adrelid) as rowdefault

- FROM pg_attrdef d, pg_class c

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

- AND (c.oid = d.adrelid)

- AND d.adnum = " . $row['attnum'];

- $def_res = $db->sql_query($sql_get_default);

- $def_row = $db->sql_fetchrow($def_res);

- $db->sql_freeresult($def_res);

-

- if (empty($def_row))

- {

- unset($row['rowdefault']);

- }

- else

- {

- $row['rowdefault'] = $def_row['rowdefault'];

- }

-

- if ($row['type'] == 'bpchar')

- {

- // Internally stored as bpchar, but isn't accepted in a CREATE TABLE statement.

- $row['type'] = 'char';

- }

-

- $line = ' ' . $row['field'] . ' ' . $row['type'];

-

- if (strpos($row['type'], 'char') !== false)

- {

- if ($row['lengthvar'] > 0)

- {

- $line .= '(' . ($row['lengthvar'] - 4) . ')';

- }

- }

-

- if (strpos($row['type'], 'numeric') !== false)

- {

- $line .= '(';

- $line .= sprintf("%s,%s", (($row['lengthvar'] >> 16) & 0xffff), (($row['lengthvar'] - 4) & 0xffff));

- $line .= ')';

- }

-

- if (isset($row['rowdefault']))

- {

- $line .= ' DEFAULT ' . $row['rowdefault'];

- }

-

- if ($row['notnull'] == 't')

- {

- $line .= ' NOT NULL';

- }

-

- $lines[] = $line;

- }

- $db->sql_freeresult($result);

-

- // Get the listing of primary keys.

- $sql_pri_keys = "SELECT ic.relname as index_name, bc.relname as tab_name, ta.attname as column_name, i.indisunique as unique_key, i.indisprimary as primary_key

- FROM pg_class bc, pg_class ic, pg_index i, pg_attribute ta, pg_attribute ia

- WHERE (bc.oid = i.indrelid)

- AND (ic.oid = i.indexrelid)

- AND (ia.attrelid = i.indexrelid)

- AND (ta.attrelid = bc.oid)

- AND (bc.relname = '" . $db->sql_escape($table_name) . "')

- AND (ta.attrelid = i.indrelid)

- AND (ta.attnum = i.indkey[ia.attnum-1])

- ORDER BY index_name, tab_name, column_name";

-

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

-

- $index_create = $index_rows = $primary_key = array();

-

- // We do this in two steps. It makes placing the comma easier

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

- {

- if ($row['primary_key'] == 't')

- {

- $primary_key[] = $row['column_name'];

- $primary_key_name = $row['index_name'];

- }

- else

- {

- // We have to store this all this info because it is possible to have a multi-column key...

- // we can loop through it again and build the statement

- $index_rows[$row['index_name']]['table'] = $table_name;

- $index_rows[$row['index_name']]['unique'] = ($row['unique_key'] == 't') ? true : false;

- $index_rows[$row['index_name']]['column_names'][] = $row['column_name'];

- }

- }

- $db->sql_freeresult($result);

-

- if (!empty($index_rows))

- {

- foreach ($index_rows as $idx_name => $props)

- {

- $index_create[] = 'CREATE ' . ($props['unique'] ? 'UNIQUE ' : '') . "INDEX $idx_name ON $table_name (" . implode(', ', $props['column_names']) . ");";

- }

- }

-

- if (!empty($primary_key))

- {

- $lines[] = " CONSTRAINT $primary_key_name PRIMARY KEY (" . implode(', ', $primary_key) . ")";

- }

-

- // Generate constraint clauses for CHECK constraints

- $sql_checks = "SELECT conname as index_name, consrc

- FROM pg_constraint, pg_class bc

- WHERE conrelid = bc.oid

- AND bc.relname = '" . $db->sql_escape($table_name) . "'

- AND NOT EXISTS (

- SELECT *

- FROM pg_constraint as c, pg_inherits as i

- WHERE i.inhrelid = pg_constraint.conrelid

- AND c.conname = pg_constraint.conname

- AND c.consrc = pg_constraint.consrc

- AND c.conrelid = i.inhparent

- )";

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

-

- // Add the constraints to the sql file.

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

- {

- if (!is_null($row['consrc']))

- {

- $lines[] = ' CONSTRAINT ' . $row['index_name'] . ' CHECK ' . $row['consrc'];

- }

- }

- $db->sql_freeresult($result);

-

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

- $sql_data .= "\n);\n";

-

- if (!empty($index_create))

- {

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

- }

- $this->flush($sql_data);

- }

-

- function write_data($table_name)

- {

- global $db;

- // Grab all of the data from current table.

- $sql = "SELECT *

- FROM $table_name";

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

-

- $i_num_fields = pg_num_fields($result);

- $seq = '';

-

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $ary_type[] = pg_field_type($result, $i);

- $ary_name[] = pg_field_name($result, $i);

-

- $sql = "SELECT pg_get_expr(d.adbin, d.adrelid) as rowdefault

- FROM pg_attrdef d, pg_class c

- WHERE (c.relname = '{$table_name}')

- AND (c.oid = d.adrelid)

- AND d.adnum = " . strval($i + 1);

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

- if ($row = $db->sql_fetchrow($result2))

- {

- // Determine if we must reset the sequences

- if (strpos($row['rowdefault'], "nextval('") === 0)

- {

- $seq .= "SELECT SETVAL('{$table_name}_seq',(select case when max({$ary_name[$i]})>0 then max({$ary_name[$i]})+1 else 1 end FROM {$table_name}));\n";

- }

- }

- }

-

- $this->flush("COPY $table_name (" . implode(', ', $ary_name) . ') FROM stdin;' . "\n");

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

- {

- $schema_vals = array();

-

- // Build the SQL statement to recreate the data.

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $str_val = $row[$ary_name[$i]];

-

- if (preg_match('#char|text|bool|bytea#i', $ary_type[$i]))

- {

- $str_val = str_replace(array("\n", "\t", "\r", "\b", "\f", "\v"), array('\n', '\t', '\r', '\b', '\f', '\v'), addslashes($str_val));

- $str_empty = '';

- }

- else

- {

- $str_empty = '\N';

- }

-

- if (empty($str_val) && $str_val !== '0')

- {

- $str_val = $str_empty;

- }

-

- $schema_vals[] = $str_val;

- }

-

- // Take the ordered fields and their associated data and build it

- // into a valid sql statement to recreate that field in the data.

- $this->flush(implode("\t", $schema_vals) . "\n");

- }

- $db->sql_freeresult($result);

- $this->flush("\\.\n");

-

- // Write out the sequence statements

- $this->flush($seq);

- }

-

- function write_end()

- {

- $this->flush("COMMIT;\n");

- parent::write_end();

- }

-}

-

-class mssql_extractor extends base_extractor

-{

- function write_end()

- {

- $this->flush("COMMIT\nGO\n");

- parent::write_end();

- }

-

- function write_start($prefix)

- {

- $sql_data = "--\n";

- $sql_data .= "-- phpBB Backup Script\n";

- $sql_data .= "-- Dump of tables for $prefix\n";

- $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

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

- $sql_data .= "BEGIN TRANSACTION\n";

- $sql_data .= "GO\n";

- $this->flush($sql_data);

- }

-

- function write_table($table_name)

- {

- global $db;

- $sql_data = '-- Table: ' . $table_name . "\n";

- $sql_data .= "IF OBJECT_ID(N'$table_name', N'U') IS NOT NULL\n";

- $sql_data .= "DROP TABLE $table_name;\n";

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

- }

- else

- {

- $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'";

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

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

- {

- if (!sizeof($rows))

- {

- $sql_data .= "ALTER TABLE [$table_name] WITH NOCHECK ADD\n";

- $sql_data .= "\tCONSTRAINT [{$row['CONSTRAINT_NAME']}] PRIMARY KEY CLUSTERED \n\t(\n";

- }

- $rows[] = "\t\t[{$row['COLUMN_NAME']}]";

- }

- if (sizeof($rows))

- {

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

- $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);

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

- {

- if ($row['TYPE'] == 3)

- {

- $index[$row['INDEX_NAME']][] = '[' . $row['COLUMN_NAME'] . ']';

- }

- }

- $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";

- }

- $this->flush($sql_data);

- }

-

- function write_data($table_name)

- {

- global $db;

-

- if ($db->get_sql_layer() === 'mssql')

- {

- $this->write_data_mssql($table_name);

- }

- else if($db->get_sql_layer() === 'mssqlnative')

- {

- $this->write_data_mssqlnative($table_name);

- }

- else

- {

- $this->write_data_odbc($table_name);

- }

- }

-

- function write_data_mssql($table_name)

- {

- global $db;

- $ary_type = $ary_name = array();

- $ident_set = false;

- $sql_data = '';

-

- // Grab all of the data from current table.

- $sql = "SELECT *

- FROM $table_name";

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

-

- $retrieved_data = mssql_num_rows($result);

-

- $i_num_fields = mssql_num_fields($result);

-

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $ary_type[$i] = mssql_field_type($result, $i);

- $ary_name[$i] = mssql_field_name($result, $i);

- }

-

- if ($retrieved_data)

- {

- $sql = "SELECT 1 as has_identity

- FROM INFORMATION_SCHEMA.COLUMNS

- WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

- $row2 = $db->sql_fetchrow($result2);

- if (!empty($row2['has_identity']))

- {

- $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

- $ident_set = true;

- }

- $db->sql_freeresult($result2);

- }

-

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

- {

- $schema_vals = $schema_fields = array();

-

- // Build the SQL statement to recreate the data.

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $str_val = $row[$ary_name[$i]];

-

- if (preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

- {

- $str_quote = '';

- $str_empty = "''";

- $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

- }

- else if (preg_match('#date|timestamp#i', $ary_type[$i]))

- {

- if (empty($str_val))

- {

- $str_quote = '';

- }

- else

- {

- $str_quote = "'";

- }

- }

- else

- {

- $str_quote = '';

- $str_empty = 'NULL';

- }

-

- if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

- {

- $str_val = $str_empty;

- }

-

- $schema_vals[$i] = $str_quote . $str_val . $str_quote;

- $schema_fields[$i] = $ary_name[$i];

- }

-

- // Take the ordered fields and their associated data and build it

- // into a valid sql statement to recreate that field in the data.

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

-

- $this->flush($sql_data);

- $sql_data = '';

- }

- $db->sql_freeresult($result);

-

- if ($retrieved_data && $ident_set)

- {

- $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

- }

- $this->flush($sql_data);

- }

-

- function write_data_mssqlnative($table_name)

- {

- global $db;

- $ary_type = $ary_name = array();

- $ident_set = false;

- $sql_data = '';

-

- // Grab all of the data from current table.

- $sql = "SELECT * FROM $table_name";

- $db->mssqlnative_set_query_options(array('Scrollable' => SQLSRV_CURSOR_STATIC));

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

-

- $retrieved_data = $db->mssqlnative_num_rows($result);

-

- if (!$retrieved_data)

- {

- $db->sql_freeresult($result);

- return;

- }

-

- $sql = "SELECT COLUMN_NAME, DATA_TYPE

- FROM INFORMATION_SCHEMA.COLUMNS

- WHERE INFORMATION_SCHEMA.COLUMNS.TABLE_NAME = '" . $db->sql_escape($table_name) . "'";

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

-

- $i_num_fields = 0;

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

- {

- $ary_type[$i_num_fields] = $row['DATA_TYPE'];

- $ary_name[$i_num_fields] = $row['COLUMN_NAME'];

- $i_num_fields++;

- }

- $db->sql_freeresult($result_fields);

-

- $sql = "SELECT 1 as has_identity

- FROM INFORMATION_SCHEMA.COLUMNS

- WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

- $row2 = $db->sql_fetchrow($result2);

-

- if (!empty($row2['has_identity']))

- {

- $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

- $ident_set = true;

- }

- $db->sql_freeresult($result2);

-

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

- {

- $schema_vals = $schema_fields = array();

-

- // Build the SQL statement to recreate the data.

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $str_val = $row[$ary_name[$i]];

-

- // defaults to type number - better quote just to be safe, so check for is_int too

- if (is_int($ary_type[$i]) || preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

- {

- $str_quote = '';

- $str_empty = "''";

- $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

- }

- else if (preg_match('#date|timestamp#i', $ary_type[$i]))

- {

- if (empty($str_val))

- {

- $str_quote = '';

- }

- else

- {

- $str_quote = "'";

- }

- }

- else

- {

- $str_quote = '';

- $str_empty = 'NULL';

- }

-

- if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

- {

- $str_val = $str_empty;

- }

-

- $schema_vals[$i] = $str_quote . $str_val . $str_quote;

- $schema_fields[$i] = $ary_name[$i];

- }

-

- // Take the ordered fields and their associated data and build it

- // into a valid sql statement to recreate that field in the data.

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

-

- $this->flush($sql_data);

- $sql_data = '';

- }

- $db->sql_freeresult($result);

-

- if ($ident_set)

- {

- $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

- }

- $this->flush($sql_data);

- }

-

- function write_data_odbc($table_name)

- {

- global $db;

- $ary_type = $ary_name = array();

- $ident_set = false;

- $sql_data = '';

-

- // Grab all of the data from current table.

- $sql = "SELECT *

- FROM $table_name";

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

-

- $retrieved_data = odbc_num_rows($result);

-

- if ($retrieved_data)

- {

- $sql = "SELECT 1 as has_identity

- FROM INFORMATION_SCHEMA.COLUMNS

- WHERE COLUMNPROPERTY(object_id('$table_name'), COLUMN_NAME, 'IsIdentity') = 1";

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

- $row2 = $db->sql_fetchrow($result2);

- if (!empty($row2['has_identity']))

- {

- $sql_data .= "\nSET IDENTITY_INSERT $table_name ON\nGO\n";

- $ident_set = true;

- }

- $db->sql_freeresult($result2);

- }

-

- $i_num_fields = odbc_num_fields($result);

-

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $ary_type[$i] = odbc_field_type($result, $i + 1);

- $ary_name[$i] = odbc_field_name($result, $i + 1);

- }

-

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

- {

- $schema_vals = $schema_fields = array();

-

- // Build the SQL statement to recreate the data.

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $str_val = $row[$ary_name[$i]];

-

- if (preg_match('#char|text|bool|varbinary#i', $ary_type[$i]))

- {

- $str_quote = '';

- $str_empty = "''";

- $str_val = sanitize_data_mssql(str_replace("'", "''", $str_val));

- }

- else if (preg_match('#date|timestamp#i', $ary_type[$i]))

- {

- if (empty($str_val))

- {

- $str_quote = '';

- }

- else

- {

- $str_quote = "'";

- }

- }

- else

- {

- $str_quote = '';

- $str_empty = 'NULL';

- }

-

- if (empty($str_val) && $str_val !== '0' && !(is_int($str_val) || is_float($str_val)))

- {

- $str_val = $str_empty;

- }

-

- $schema_vals[$i] = $str_quote . $str_val . $str_quote;

- $schema_fields[$i] = $ary_name[$i];

- }

-

- // Take the ordered fields and their associated data and build it

- // into a valid sql statement to recreate that field in the data.

- $sql_data .= "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ");\nGO\n";

-

- $this->flush($sql_data);

-

- $sql_data = '';

-

- }

- $db->sql_freeresult($result);

-

- if ($retrieved_data && $ident_set)

- {

- $sql_data .= "\nSET IDENTITY_INSERT $table_name OFF\nGO\n";

- }

- $this->flush($sql_data);

- }

-

-}

-

-class oracle_extractor extends base_extractor

-{

- function write_table($table_name)

- {

- global $db;

- $sql_data = '-- Table: ' . $table_name . "\n";

- $sql_data .= "DROP TABLE $table_name\n/\n";

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

-

- $sql = "SELECT COLUMN_NAME, DATA_TYPE, DATA_PRECISION, DATA_LENGTH, NULLABLE, DATA_DEFAULT

- FROM ALL_TAB_COLS

- WHERE table_name = '{$table_name}'";

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

-

- $rows = array();

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

- {

- $line = ' "' . $row['column_name'] . '" ' . $row['data_type'];

-

- if ($row['data_type'] !== 'CLOB')

- {

- if ($row['data_type'] !== 'VARCHAR2' && $row['data_type'] !== 'CHAR')

- {

- $line .= '(' . $row['data_precision'] . ')';

- }

- else

- {

- $line .= '(' . $row['data_length'] . ')';

- }

- }

-

- if (!empty($row['data_default']))

- {

- $line .= ' DEFAULT ' . $row['data_default'];

- }

-

- if ($row['nullable'] == 'N')

- {

- $line .= ' NOT NULL';

- }

- $rows[] = $line;

- }

- $db->sql_freeresult($result);

-

- $sql = "SELECT A.CONSTRAINT_NAME, A.COLUMN_NAME

- FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B

- WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME

- AND B.CONSTRAINT_TYPE = 'P'

- AND A.TABLE_NAME = '{$table_name}'";

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

-

- $primary_key = array();

- $contraint_name = '';

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

- {

- $constraint_name = '"' . $row['constraint_name'] . '"';

- $primary_key[] = '"' . $row['column_name'] . '"';

- }

- $db->sql_freeresult($result);

-

- if (sizeof($primary_key))

- {

- $rows[] = " CONSTRAINT {$constraint_name} PRIMARY KEY (" . implode(', ', $primary_key) . ')';

- }

-

- $sql = "SELECT A.CONSTRAINT_NAME, A.COLUMN_NAME

- FROM USER_CONS_COLUMNS A, USER_CONSTRAINTS B

- WHERE A.CONSTRAINT_NAME = B.CONSTRAINT_NAME

- AND B.CONSTRAINT_TYPE = 'U'

- AND A.TABLE_NAME = '{$table_name}'";

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

-

- $unique = array();

- $contraint_name = '';

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

- {

- $constraint_name = '"' . $row['constraint_name'] . '"';

- $unique[] = '"' . $row['column_name'] . '"';

- }

- $db->sql_freeresult($result);

-

- if (sizeof($unique))

- {

- $rows[] = " CONSTRAINT {$constraint_name} UNIQUE (" . implode(', ', $unique) . ')';

- }

-

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

- $sql_data .= "\n)\n/\n";

-

- $sql = "SELECT A.REFERENCED_NAME, C.*

- FROM USER_DEPENDENCIES A, USER_TRIGGERS B, USER_SEQUENCES C

- WHERE A.REFERENCED_TYPE = 'SEQUENCE'

- AND A.NAME = B.TRIGGER_NAME

- AND B.TABLE_NAME = '{$table_name}'

- AND C.SEQUENCE_NAME = A.REFERENCED_NAME";

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

-

- $type = request_var('type', '');

-

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

- {

- $sql_data .= "\nDROP SEQUENCE \"{$row['referenced_name']}\"\n/\n";

- $sql_data .= "\nCREATE SEQUENCE \"{$row['referenced_name']}\"";

-

- if ($type == 'full')

- {

- $sql_data .= ' START WITH ' . $row['last_number'];

- }

-

- $sql_data .= "\n/\n";

- }

- $db->sql_freeresult($result);

-

- $sql = "SELECT DESCRIPTION, WHEN_CLAUSE, TRIGGER_BODY

- FROM USER_TRIGGERS

- WHERE TABLE_NAME = '{$table_name}'";

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

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

- {

- $sql_data .= "\nCREATE OR REPLACE TRIGGER {$row['description']}WHEN ({$row['when_clause']})\n{$row['trigger_body']}\n/\n";

- }

- $db->sql_freeresult($result);

-

- $sql = "SELECT A.INDEX_NAME, B.COLUMN_NAME

- FROM USER_INDEXES A, USER_IND_COLUMNS B

- WHERE A.UNIQUENESS = 'NONUNIQUE'

- AND A.INDEX_NAME = B.INDEX_NAME

- AND B.TABLE_NAME = '{$table_name}'";

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

-

- $index = array();

-

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

- {

- $index[$row['index_name']][] = $row['column_name'];

- }

-

- foreach ($index as $index_name => $column_names)

- {

- $sql_data .= "\nCREATE INDEX $index_name ON $table_name(" . implode(', ', $column_names) . ")\n/\n";

- }

- $db->sql_freeresult($result);

- $this->flush($sql_data);

- }

-

- function write_data($table_name)

- {

- global $db;

- $ary_type = $ary_name = array();

-

- // Grab all of the data from current table.

- $sql = "SELECT *

- FROM $table_name";

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

-

- $i_num_fields = ocinumcols($result);

-

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- $ary_type[$i] = ocicolumntype($result, $i + 1);

- $ary_name[$i] = ocicolumnname($result, $i + 1);

- }

-

- $sql_data = '';

-

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

- {

- $schema_vals = $schema_fields = array();

-

- // Build the SQL statement to recreate the data.

- for ($i = 0; $i < $i_num_fields; $i++)

- {

- // Oracle uses uppercase - we use lowercase

- $str_val = $row[strtolower($ary_name[$i])];

-

- if (preg_match('#char|text|bool|raw|clob#i', $ary_type[$i]))

- {

- $str_quote = '';

- $str_empty = "''";

- $str_val = sanitize_data_oracle($str_val);

- }

- else if (preg_match('#date|timestamp#i', $ary_type[$i]))

- {

- if (empty($str_val))

- {

- $str_quote = '';

- }

- else

- {

- $str_quote = "'";

- }

- }

- else

- {

- $str_quote = '';

- $str_empty = 'NULL';

- }

-

- if (empty($str_val) && $str_val !== '0')

- {

- $str_val = $str_empty;

- }

-

- $schema_vals[$i] = $str_quote . $str_val . $str_quote;

- $schema_fields[$i] = '"' . $ary_name[$i] . '"';

- }

-

- // Take the ordered fields and their associated data and build it

- // into a valid sql statement to recreate that field in the data.

- $sql_data = "INSERT INTO $table_name (" . implode(', ', $schema_fields) . ') VALUES (' . implode(', ', $schema_vals) . ")\n/\n";

-

- $this->flush($sql_data);

- }

- $db->sql_freeresult($result);

- }

-

- function write_start($prefix)

- {

- $sql_data = "--\n";

- $sql_data .= "-- phpBB Backup Script\n";

- $sql_data .= "-- Dump of tables for $prefix\n";

- $sql_data .= "-- DATE : " . gmdate("d-m-Y H:i:s", $this->time) . " GMT\n";

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

- $this->flush($sql_data);

- }

-}

-

- if (sizeof($matches[0]))

- if (sizeof($matches[0]))

- if (sizeof($matches[0]))

- if (!sizeof($array))

- if (sizeof($array))

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

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

-

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

- $disallowed_user = str_replace('*', '%', utf8_normalize_nfc(request_var('disallowed_user', '', true)));

- add_log('admin', 'LOG_DISALLOW_ADD', str_replace('%', '*', $disallowed_user));

- $disallowed_id = request_var('disallowed_id', 0);

- add_log('admin', 'LOG_DISALLOW_DELETE');

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

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $phpbb_dispatcher;

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

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

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

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

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

- if (!sizeof($error))

- if (sizeof($email_list))

- include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

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

- for ($i = 0, $size = sizeof($email_list); $i < $size; $i++)

- for ($j = 0, $list_size = sizeof($email_list[$i]); $j < $list_size; $j++)

- $messenger->{((sizeof($email_list[$i]) == 1) ? 'to' : 'bcc')}($email_row['email'], $email_row['name']);

- add_log('admin', 'LOG_MASS_EMAIL', implode(', ', utf8_normalize_nfc($usernames)));

- add_log('admin', 'LOG_MASS_EMAIL', $group_name);

- 'S_WARNING' => (sizeof($error)) ? true : false,

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

- private $db;

- private $cache;

- global $config, $user, $template, $request, $phpbb_extension_manager, $db, $phpbb_root_path, $phpEx, $phpbb_log, $cache;

- $this->db = $db;

- $this->cache = $cache;

- $user->add_lang(array('install', 'acp/extensions', 'migrator'));

- $action = $request->variable('action', 'list');

- $ext_name = $request->variable('ext_name', '');

- if ($request->is_set_post('cancel'))

- if (in_array($action, array('enable', 'disable', 'delete_data')) && !check_link_hash($request->variable('hash', ''), $action . '.' . $ext_name))

- $md_manager = new \phpbb\extension\metadata_manager($ext_name, $config, $phpbb_extension_manager, $template, $user, $phpbb_root_path);

- catch(\phpbb\extension\exception $e)

- trigger_error($e, E_USER_WARNING);

- confirm_box(false, $user->lang('EXTENSION_FORCE_UNSTABLE_CONFIRM'), $s_hidden_fields);

- $config->set('extension_force_unstable', false);

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

- $config->set('extension_force_unstable', true);

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

- $this->list_enabled_exts($phpbb_extension_manager);

- $this->list_disabled_exts($phpbb_extension_manager);

- $this->list_available_exts($phpbb_extension_manager);

- 'FORCE_UNSTABLE' => $config['extension_force_unstable'],

- add_form_key('version_check_settings');

-

- if (!$md_manager->validate_dir())

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

-

- if (!$md_manager->validate_enable())

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

- $extension = $phpbb_extension_manager->get_extension($ext_name);

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

- if ($phpbb_extension_manager->is_enabled($ext_name))

- $template->assign_vars(array(

- if (!$md_manager->validate_dir())

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

-

- if (!$md_manager->validate_enable())

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

- $extension = $phpbb_extension_manager->get_extension($ext_name);

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

- }

-

- if ($phpbb_extension_manager->is_enabled($ext_name))

- {

- redirect($this->u_action);

- while ($phpbb_extension_manager->enable_step($ext_name))

- $template->assign_var('S_NEXT_STEP', true);

- $this->log->add('admin', $user->data['user_id'], $user->ip, 'LOG_EXT_ENABLE', time(), array($ext_name));

- $template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($user));

- $template->assign_vars(array(

- if (!$phpbb_extension_manager->is_enabled($ext_name))

- $template->assign_vars(array(

- if (!$phpbb_extension_manager->is_enabled($ext_name))

- while ($phpbb_extension_manager->disable_step($ext_name))

- $template->assign_var('S_NEXT_STEP', true);

- $this->log->add('admin', $user->data['user_id'], $user->ip, 'LOG_EXT_DISABLE', time(), array($ext_name));

- $template->assign_vars(array(

- if ($phpbb_extension_manager->is_enabled($ext_name))

- $template->assign_vars(array(

- if ($phpbb_extension_manager->is_enabled($ext_name))

- while ($phpbb_extension_manager->purge_step($ext_name))

- $template->assign_var('S_NEXT_STEP', true);

- $this->log->add('admin', $user->data['user_id'], $user->ip, 'LOG_EXT_PURGE', time(), array($ext_name));

- $template->assign_var('MIGRATOR_ERROR', $e->getLocalisedMessage($user));

- $template->assign_vars(array(

- $md_manager->output_template_data();

- try

- $updates_available = $this->version_check($md_manager, $request->variable('versioncheck_force', false));

- $template->assign_vars(array(

- 'S_UP_TO_DATE' => empty($updates_available),

- 'S_VERSIONCHECK' => true,

- 'UP_TO_DATE_MSG' => $this->user->lang(empty($updates_available) ? 'UP_TO_DATE' : 'NOT_UP_TO_DATE', $md_manager->get_metadata('display-name')),

- ));

- foreach ($updates_available as $branch => $version_data)

- $template->assign_block_vars('updates_available', $version_data);

- catch (\RuntimeException $e)

- $template->assign_vars(array(

- 'S_VERSIONCHECK_STATUS' => $e->getCode(),

- 'VERSIONCHECK_FAIL_REASON' => ($e->getMessage() !== $user->lang('VERSIONCHECK_FAIL')) ? $e->getMessage() : '',

- ));

- $template->assign_vars(array(

- * @param $phpbb_extension_manager An instance of the extension manager

- public function list_enabled_exts(\phpbb\extension\manager $phpbb_extension_manager)

- foreach ($phpbb_extension_manager->all_enabled() as $name => $location)

- $md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

- $force_update = $this->request->variable('versioncheck_force', false);

- $updates = $this->version_check($md_manager, $force_update, !$force_update);

- $enabled_extension_meta_data[$name]['S_UP_TO_DATE'] = empty($updates);

- $enabled_extension_meta_data[$name]['S_VERSIONCHECK'] = true;

- $enabled_extension_meta_data[$name]['U_VERSIONCHECK_FORCE'] = $this->u_action . '&amp;action=details&amp;versioncheck_force=1&amp;ext_name=' . urlencode($md_manager->get_metadata('name'));

- catch(\phpbb\extension\exception $e)

- 'META_DISPLAY_NAME' => $this->user->lang('EXTENSION_INVALID_LIST', $name, $e),

- * @param $phpbb_extension_manager An instance of the extension manager

- public function list_disabled_exts(\phpbb\extension\manager $phpbb_extension_manager)

- foreach ($phpbb_extension_manager->all_disabled() as $name => $location)

- $md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

- $force_update = $this->request->variable('versioncheck_force', false);

- $updates = $this->version_check($md_manager, $force_update, !$force_update);

- $disabled_extension_meta_data[$name]['S_UP_TO_DATE'] = empty($updates);

- $disabled_extension_meta_data[$name]['S_VERSIONCHECK'] = true;

- $disabled_extension_meta_data[$name]['U_VERSIONCHECK_FORCE'] = $this->u_action . '&amp;action=details&amp;versioncheck_force=1&amp;ext_name=' . urlencode($md_manager->get_metadata('name'));

- catch(\phpbb\extension\exception $e)

- 'META_DISPLAY_NAME' => $this->user->lang('EXTENSION_INVALID_LIST', $name, $e),

- $disabeld_extension_meta_data[$name]['S_VERSIONCHECK'] = false;

- * @param $phpbb_extension_manager An instance of the extension manager

- public function list_available_exts(\phpbb\extension\manager $phpbb_extension_manager)

- $uninstalled = array_diff_key($phpbb_extension_manager->all_available(), $phpbb_extension_manager->all_configured());

- $md_manager = $phpbb_extension_manager->create_extension_metadata_manager($name, $this->template);

- $force_update = $this->request->variable('versioncheck_force', false);

- $updates = $this->version_check($md_manager, $force_update, !$force_update);

- $available_extension_meta_data[$name]['S_UP_TO_DATE'] = empty($updates);

- $available_extension_meta_data[$name]['S_VERSIONCHECK'] = true;

- $available_extension_meta_data[$name]['U_VERSIONCHECK_FORCE'] = $this->u_action . '&amp;action=details&amp;versioncheck_force=1&amp;ext_name=' . urlencode($md_manager->get_metadata('name'));

- catch(\phpbb\extension\exception $e)

- 'META_DISPLAY_NAME' => $this->user->lang('EXTENSION_INVALID_LIST', $name, $e),

- catch (\RuntimeException $e)

- {

- $available_extension_meta_data[$name]['S_VERSIONCHECK'] = false;

- }

- * Check the version and return the available updates.

- *

- * @param \phpbb\extension\metadata_manager $md_manager The metadata manager for the version to check.

- * @param bool $force_update Ignores cached data. Defaults to false.

- * @param bool $force_cache Force the use of the cache. Override $force_update.

- * @return string

- * @throws RuntimeException

- protected function version_check(\phpbb\extension\metadata_manager $md_manager, $force_update = false, $force_cache = false)

- $meta = $md_manager->get_metadata('all');

-

- if (!isset($meta['extra']['version-check']))

- {

- throw new \RuntimeException($this->user->lang('NO_VERSIONCHECK'), 1);

- }

-

- $version_check = $meta['extra']['version-check'];

-

- $version_helper = new \phpbb\version_helper($this->cache, $this->config, new \phpbb\file_downloader(), $this->user);

- $version_helper->set_current_version($meta['version']);

- $version_helper->set_file_location($version_check['host'], $version_check['directory'], $version_check['filename']);

- $version_helper->force_stability($this->config['extension_force_unstable'] ? 'unstable' : null);

-

- return $updates = $version_helper->get_suggested_updates($force_update, $force_cache);

- * Sort helper for the table containing the metadata about the extensions.

- protected function sort_extension_meta_data_table($val1, $val2)

- return strnatcasecmp($val1['META_DISPLAY_NAME'], $val2['META_DISPLAY_NAME']);

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

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

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

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

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

- $total = request_var('total', 0);

- $action_subforums = request_var('action_subforums', '');

- $subforums_to_id = request_var('subforums_to_id', 0);

- $action_posts = request_var('action_posts', '');

- $posts_to_id = request_var('posts_to_id', 0);

- if (sizeof($errors))

- 'parent_id' => request_var('forum_parent_id', $this->parent_id),

- 'forum_type' => request_var('forum_type', FORUM_POST),

- 'type_action' => request_var('type_action', ''),

- 'forum_status' => request_var('forum_status', ITEM_UNLOCKED),

- 'forum_name' => utf8_normalize_nfc(request_var('forum_name', '', true)),

- 'forum_link' => request_var('forum_link', ''),

- 'forum_link_track' => request_var('forum_link_track', false),

- 'forum_desc' => utf8_normalize_nfc(request_var('forum_desc', '', true)),

- 'forum_rules' => utf8_normalize_nfc(request_var('forum_rules', '', true)),

- 'forum_rules_link' => request_var('forum_rules_link', ''),

- 'forum_image' => request_var('forum_image', ''),

- 'forum_style' => request_var('forum_style', 0),

- 'display_subforum_list' => request_var('display_subforum_list', false),

- 'display_on_index' => request_var('display_on_index', false),

- 'forum_topics_per_page' => request_var('topics_per_page', 0),

- 'enable_indexing' => request_var('enable_indexing', true),

- 'enable_icons' => request_var('enable_icons', false),

- 'enable_prune' => request_var('enable_prune', false),

- 'enable_post_review' => request_var('enable_post_review', true),

- 'enable_quick_reply' => request_var('enable_quick_reply', false),

- 'enable_shadow_prune' => request_var('enable_shadow_prune', false),

- 'prune_days' => request_var('prune_days', 7),

- 'prune_viewed' => request_var('prune_viewed', 7),

- 'prune_freq' => request_var('prune_freq', 1),

- 'prune_old_polls' => request_var('prune_old_polls', false),

- 'prune_announce' => request_var('prune_announce', false),

- 'prune_sticky' => request_var('prune_sticky', false),

- 'prune_shadow_days' => request_var('prune_shadow_days', 7),

- 'prune_shadow_freq' => request_var('prune_shadow_freq', 1),

- 'forum_password' => request_var('forum_password', '', true),

- 'forum_password_confirm'=> request_var('forum_password_confirm', '', true),

- 'forum_password_unset' => request_var('forum_password_unset', false),

- $forum_data['display_on_index'] = request_var('link_display_on_index', false);

- $forum_data['show_active'] = ($forum_data['forum_type'] == FORUM_POST) ? request_var('display_recent', true) : request_var('display_active', false);

- generate_text_for_storage($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield'], $forum_data['forum_rules_options'], request_var('rules_parse_bbcode', false), request_var('rules_parse_urls', false), request_var('rules_parse_smilies', false));

- generate_text_for_storage($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield'], $forum_data['forum_desc_options'], request_var('desc_parse_bbcode', false), request_var('desc_parse_urls', false), request_var('desc_parse_smilies', false));

- if (!sizeof($errors))

- $forum_perm_from = request_var('forum_perm_from', 0);

- add_log('admin', 'LOG_FORUM_' . strtoupper($action), $row['forum_name'], $move_forum_name);

- $start = request_var('start', $row2['min_topic_id']);

- $topics_done = request_var('topics_done', 0) + (int) $db->sql_fetchfield('num_topics');

- add_log('admin', 'LOG_FORUM_SYNC', $row['forum_name']);

- $forum_data['forum_flags'] += (request_var('forum_link_track', false)) ? FORUM_FLAG_LINK_TRACK : 0;

- $forum_data['forum_flags'] += (request_var('prune_old_polls', false)) ? FORUM_FLAG_PRUNE_POLL : 0;

- $forum_data['forum_flags'] += (request_var('prune_announce', false)) ? FORUM_FLAG_PRUNE_ANNOUNCE : 0;

- $forum_data['forum_flags'] += (request_var('prune_sticky', false)) ? FORUM_FLAG_PRUNE_STICKY : 0;

- $forum_data['forum_flags'] += (request_var('enable_post_review', true)) ? FORUM_FLAG_POST_REVIEW : 0;

- $forum_data['forum_flags'] += (request_var('enable_quick_reply', false)) ? FORUM_FLAG_QUICK_REPLY : 0;

- 'forum_name' => utf8_normalize_nfc(request_var('forum_name', '', true)),

- // Before we are able to display the preview and plane text, we need to parse our request_var()'d value...

- generate_text_for_storage($forum_data['forum_rules'], $forum_data['forum_rules_uid'], $forum_data['forum_rules_bitfield'], $forum_data['forum_rules_options'], request_var('rules_allow_bbcode', false), request_var('rules_allow_urls', false), request_var('rules_allow_smilies', false));

- // Before we are able to display the preview and plane text, we need to parse our request_var()'d value...

- generate_text_for_storage($forum_data['forum_desc'], $forum_data['forum_desc_uid'], $forum_data['forum_desc_bitfield'], $forum_data['forum_desc_options'], request_var('desc_allow_bbcode', false), request_var('desc_allow_urls', false), request_var('desc_allow_smilies', false));

- 'S_ERROR' => (sizeof($errors)) ? true : false,

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

- 'S_ERROR' => (sizeof($errors)) ? true : false,

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

- $forum_perm_from = request_var('forum_perm_from', 0);

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

- do

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

- $db->sql_freeresult($result);

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

- function update_forum_data(&$forum_data)

- global $db, $user, $cache, $phpbb_root_path, $phpbb_container, $phpbb_dispatcher;

- if ($forum_data['forum_name'] == '')

- if (utf8_strlen($forum_data['forum_desc']) > 4000)

- if (utf8_strlen($forum_data['forum_rules']) > 4000)

- if ($forum_data['forum_password'] || $forum_data['forum_password_confirm'])

- if ($forum_data['forum_password'] != $forum_data['forum_password_confirm'])

- $forum_data['forum_password'] = $forum_data['forum_password_confirm'] = '';

- if ($forum_data['prune_days'] < 0 || $forum_data['prune_viewed'] < 0 || $forum_data['prune_freq'] < 0)

- $forum_data['prune_days'] = $forum_data['prune_viewed'] = $forum_data['prune_freq'] = 0;

- array('lang' => 'FORUM_TOPICS_PAGE', 'value' => $forum_data['forum_topics_per_page'], 'column_type' => 'TINT:0'),

- if (!empty($forum_data['forum_image']) && !file_exists($phpbb_root_path . $forum_data['forum_image']))

- $forum_data['forum_flags'] = 0;

- $forum_data['forum_flags'] += ($forum_data['forum_link_track']) ? FORUM_FLAG_LINK_TRACK : 0;

- $forum_data['forum_flags'] += ($forum_data['prune_old_polls']) ? FORUM_FLAG_PRUNE_POLL : 0;

- $forum_data['forum_flags'] += ($forum_data['prune_announce']) ? FORUM_FLAG_PRUNE_ANNOUNCE : 0;

- $forum_data['forum_flags'] += ($forum_data['prune_sticky']) ? FORUM_FLAG_PRUNE_STICKY : 0;

- $forum_data['forum_flags'] += ($forum_data['show_active']) ? FORUM_FLAG_ACTIVE_TOPICS : 0;

- $forum_data['forum_flags'] += ($forum_data['enable_post_review']) ? FORUM_FLAG_POST_REVIEW : 0;

- $forum_data['forum_flags'] += ($forum_data['enable_quick_reply']) ? FORUM_FLAG_QUICK_REPLY : 0;

- $forum_data_sql = $forum_data;

- if (sizeof($errors))

- $forum_data['forum_id'] = $db->sql_nextid();

- add_log('admin', 'LOG_FORUM_ADD', $forum_data['forum_name']);

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

- $action_subforums = request_var('action_subforums', '');

- $subforums_to_id = request_var('subforums_to_id', 0);

- if (sizeof($errors))

- if (sizeof($forum_ids))

- SET allowed_forums = '" . ((sizeof($allowed_forums)) ? serialize($allowed_forums) : '') . "'

- $subforums_to_name = $_row['forum_name'];

-

- if (sizeof($errors))

- if (sizeof($errors))

- $forum_data['forum_id'] = $forum_id;

- add_log('admin', 'LOG_FORUM_EDIT', $forum_data['forum_name']);

- $to_data = $moved_ids = $errors = array();

- $diff = sizeof($moved_forums) * 2;

- for ($i = 0; $i < sizeof($moved_forums); ++$i)

- global $db, $user, $cache;

- if (sizeof($errors))

- if (sizeof($errors))

- $diff = sizeof($forum_ids) * 2;

- if (sizeof($errors))

- SET allowed_forums = '" . ((sizeof($allowed_forums)) ? serialize($allowed_forums) : '') . "'

- add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS_MOVE_FORUMS', $posts_to_name, $subforums_to_name, $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS_FORUMS', $posts_to_name, $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_POSTS_MOVE_FORUMS', $subforums_to_name, $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_MOVE_FORUMS', $subforums_to_name, $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_MOVE_POSTS', $posts_to_name, $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_POSTS_FORUMS', $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_FORUMS', $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_POSTS', $forum_data['forum_name']);

- add_log('admin', 'LOG_FORUM_DEL_FORUM', $forum_data['forum_name']);

- global $db, $config, $phpbb_root_path, $phpEx;

- delete_attachments('topic', $topic_ids, false);

- if (sizeof($ids))

- $start += sizeof($ids);

- while (sizeof($ids) == $batch_size);

- if (sizeof($post_counts))

- set_config('num_posts', (int) $row['stat'], true);

- set_config('num_topics', (int) $row['stat'], true);

- set_config('num_files', (int) $row['stat'], true);

- set_config('upload_dir_size', (float) $row['stat'], true);

- if (!sizeof($target))

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix, $file_uploads;

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

- $action = (isset($_POST['add'])) ? 'add' : ((isset($_POST['addusers'])) ? 'addusers' : request_var('action', ''));

- $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);

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

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

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

- $start = (sizeof($mark_ary) < 200) ? 0 : $start + 200;

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

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

- include($phpbb_root_path . 'includes/functions_display.' . $phpEx);

-

- $data = $submit_ary = array();

- $phpbb_avatar_manager = $phpbb_container->get('avatar.manager');

- $group_name = utf8_normalize_nfc(request_var('group_name', '', true));

- $group_desc = utf8_normalize_nfc(request_var('group_desc', '', true));

- $group_type = request_var('group_type', GROUP_FREE);

- $allow_desc_bbcode = request_var('desc_parse_bbcode', false);

- $allow_desc_urls = request_var('desc_parse_urls', false);

- $allow_desc_smilies = request_var('desc_parse_smilies', false);

- '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),

- 'skip_auth' => request_var('group_skip_auth', 0),

- if (!sizeof($error))

- $group_perm_from = request_var('group_perm_from', 0);

- if (sizeof($error))

- $group_name = utf8_normalize_nfc(request_var('group_name', '', true));

- $config_name = $phpbb_avatar_manager->get_driver_config_name($driver);

- 'avatar' => "acp_avatar_options_{$config_name}.html",

- $back_link = request_var('back_link', '');

- $u_back = append_sid("{$phpbb_admin_path}index.$phpEx", 'i=users&amp;mode=groups&amp;u=' . request_var('u', 0));

- 'S_ERROR' => (sizeof($error)) ? true : false,

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

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

- $this->page_title = 'GROUP_MEMBERS';

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

- $sql = 'SELECT g.group_id, g.group_name, g.group_type

- $sql = 'SELECT COUNT(ug.user_id) AS total_members, ug.group_id

-

- $s_group_select_legend = '';

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

- $category_data = array();

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

- $s_group_select_teampage = '';

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

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

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

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

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

- if (sizeof($smilies))

- $display = 0;

- $display = $row['display_on_posting'];

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

- if ($action == 'add' && $mode == 'smilies' && sizeof($smilies))

- $images = (isset($_POST['image'])) ? array_keys(request_var('image', array('' => 0))) : array();

- $image_id = (isset($_POST['id'])) ? request_var('id', array('' => 0)) : array();

- $image_order = (isset($_POST['order'])) ? request_var('order', array('' => 0)) : array();

- $image_width = (isset($_POST['width'])) ? request_var('width', array('' => 0)) : array();

- $image_height = (isset($_POST['height'])) ? request_var('height', array('' => 0)) : array();

- $image_add = (isset($_POST['add_img'])) ? request_var('add_img', array('' => 0)) : array();

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

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

- $image_display_on_posting = (isset($_POST['display_on_posting'])) ? request_var('display_on_posting', array('' => 0)) : array();

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

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

- $add_emotion = utf8_normalize_nfc(request_var('add_emotion', '', true));

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

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

- $image_order[$add_image] = request_var('add_order', 0);

- $addable_smileys_count = sizeof($images);

- $pak = request_var('pak', '');

- $current = request_var('current', '');

- if ((sizeof($data[1]) != 4 && $mode == 'icons') ||

- ((sizeof($data[1]) != 6 || (empty($data[1][4]) || empty($data[1][5]))) && $mode == 'smilies' ))

- case 'sqlite':

- if ($smiley_count + sizeof($pak_ary) > SMILEY_LIMIT)

- if ((sizeof($data[1]) != 4 && $mode == 'icons') ||

- (sizeof($data[1]) != 6 && $mode == 'smilies'))

- 'MESSAGE_TEXT' => sprintf($user->lang['EXPORT_' . $lang . '_EXPLAIN'], '<a href="' . $this->u_action . '&amp;action=send">', '</a>'),

- $spacer = false;

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

- $alt_text = ($mode == 'smilies') ? $row['code'] : '';

- 'U_MOVE_UP' => $this->u_action . '&amp;action=move_up&amp;id=' . $row[$fields . '_id'] . '&amp;start=' . $pagination_start,

- 'U_MOVE_DOWN' => $this->u_action . '&amp;action=move_down&amp;id=' . $row[$fields . '_id'] . '&amp;start=' . $pagination_start,

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

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $table_prefix;

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

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

- $mark = (isset($_REQUEST['mark'])) ? request_var('mark', array(0)) : array();

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

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

- $sort_key = request_var('sk', 'i');

- $sort_dir = request_var('sd', 'd');

- $per_page = request_var('users_per_page', (int) $config['topics_per_page']);

- if ($submit && sizeof($mark))

- include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

- add_log('admin', 'LOG_USER_ACTIVE', $row['username']);

- add_log('user', $row['user_id'], 'LOG_USER_ACTIVE_USER');

- add_log('admin', 'LOG_INACTIVE_' . strtoupper($action), implode(', ', $user_affected));

- include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);

- add_log('admin', 'LOG_INACTIVE_REMIND', implode(', ', $usernames));

- 'USERNAME_FULL' => get_username_string('full', $row['user_id'], $row['username'], $row['user_colour'], false, append_sid("{$phpbb_admin_path}index.$phpEx", 'i=users&amp;mode=overview')),

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

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

- include_once($phpbb_root_path . 'includes/functions_jabber.' . $phpEx);

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

- $jab_enable = request_var('jab_enable', (bool) $config['jab_enable']);

- $jab_host = request_var('jab_host', (string) $config['jab_host']);

- $jab_port = request_var('jab_port', (int) $config['jab_port']);

- $jab_username = request_var('jab_username', (string) $config['jab_username']);

- $jab_password = request_var('jab_password', (string) $config['jab_password']);

- $jab_package_size = request_var('jab_package_size', (int) $config['jab_package_size']);

- $jab_use_ssl = request_var('jab_use_ssl', (bool) $config['jab_use_ssl']);

- $error = array();

-

- $jabber = new jabber($jab_host, $jab_port, $jab_username, $jab_password, $jab_use_ssl);

- set_config('jab_enable', $jab_enable);

- set_config('jab_host', $jab_host);

- set_config('jab_port', $jab_port);

- set_config('jab_username', $jab_username);

- set_config('jab_password', $jab_password);

- set_config('jab_package_size', $jab_package_size);

- set_config('jab_use_ssl', $jab_use_ssl);

- add_log('admin', 'LOG_' . $log);

- 'JAB_PASSWORD' => $jab_password,

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

- global $phpbb_root_path, $phpEx, $request;

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

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

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

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

- 'lang_english_name' => request_var('lang_english_name', $row['lang_english_name']),

- 'lang_local_name' => utf8_normalize_nfc(request_var('lang_local_name', $row['lang_local_name'], true)),

- 'lang_author' => utf8_normalize_nfc(request_var('lang_author', $row['lang_author'], true)),

- add_log('admin', 'LOG_LANGUAGE_PACK_UPDATED', $sql_ary['lang_english_name']);

- add_log('admin', 'LOG_LANGUAGE_PACK_DELETED', $row['lang_english_name']);

-

- trigger_error(sprintf($user->lang['LANGUAGE_PACK_DELETED'], $row['lang_english_name']) . adm_back_link($this->u_action));

- $lang_iso = request_var('iso', '');

- add_log('admin', 'LOG_LANGUAGE_PACK_INSTALLED', $lang_pack['name']);

- $dp = @opendir("{$phpbb_root_path}language");

- if ($dp)

- while (($file = readdir($dp)) !== false)

- {

- if ($file[0] == '.' || !is_dir($phpbb_root_path . 'language/' . $file))

- {

- continue;

- }

- if (file_exists("{$phpbb_root_path}language/$file/iso.txt"))

- {

- if (!in_array($file, $installed))

- {

- if ($iso = file("{$phpbb_root_path}language/$file/iso.txt"))

- {

- if (sizeof($iso) == 3)

- {

- $new_ary[$file] = array(

- 'iso' => $file,

- 'name' => trim($iso[0]),

- 'local_name'=> trim($iso[1]),

- 'author' => trim($iso[2])

- );

- }

- }

- }

- }

- closedir($dp);

- if (sizeof($new_ary))

- 'U_INSTALL' => $this->u_action . '&amp;action=install&amp;iso=' . urlencode($lang_ary['iso']))

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

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

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

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

- $topic_id = request_var('t', 0);

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

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

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

- $sort_key = request_var('sk', 't');

- $sort_dir = request_var('sd', 'd');

- if ($deletemark && sizeof($marked))

- $keywords = utf8_normalize_nfc(request_var('keywords', '', true));

- $keywords = utf8_normalize_nfc(request_var('keywords', '', true));

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

- 'DATA' => (sizeof($data)) ? implode(' | ', $data) : '',

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

- global $phpbb_root_path, $phpbb_admin_path, $phpEx, $phpbb_container, $phpbb_dispatcher;

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

- set_config('record_online_users', 1, true);

- set_config('record_online_date', time(), true);

- add_log('admin', 'LOG_RESET_ONLINE');

- set_config('num_posts', (int) $db->sql_fetchfield('stat'), true);

- set_config('num_topics', (int) $db->sql_fetchfield('stat'), true);

- set_config('num_users', (int) $db->sql_fetchfield('stat'), true);

- set_config('num_files', (int) $db->sql_fetchfield('stat'), true);

- set_config('upload_dir_size', (float) $db->sql_fetchfield('stat'), true);

- add_log('admin', 'LOG_RESYNC_STATS');

- add_log('admin', 'LOG_RESYNC_POSTCOUNTS');

- add_log('admin', 'LOG_RESYNC_POSTCOUNTS');

- set_config('board_startdate', time() - 1);

- add_log('admin', 'LOG_RESET_DATE');

- case 'sqlite':

- if (sizeof($sql_ary))

- add_log('admin', 'LOG_RESYNC_POST_MARKING');

- add_log('admin', 'LOG_PURGE_CACHE');

- case 'sqlite':

- add_log('admin', 'LOG_PURGE_SESSIONS');

- if ($auth->acl_get('a_server') && version_compare(PHP_VERSION, '5.3.3', '<'))

- 'L_PHP_VERSION_OLD' => sprintf($user->lang['PHP_VERSION_OLD'], '<a href="https://www.phpbb.com/community/viewtopic.php?f=14&amp;t=2152375">', '</a>'),

- $version_helper = $phpbb_container->get('version_helper');

- try

- $recheck = $request->variable('versioncheck_force', false);

- $updates_available = $version_helper->get_suggested_updates($recheck);

- $template->assign_var('S_VERSION_UP_TO_DATE', empty($updates_available));

- catch (\RuntimeException $e)

- $template->assign_vars(array(

- 'S_VERSIONCHECK_FAIL' => true,

- 'VERSIONCHECK_FAIL_REASON' => ($e->getMessage() !== $user->lang('VERSIONCHECK_FAIL')) ? $e->getMessage() : '',

- ));

- $search = new $search_type($error, $phpbb_root_path, $phpEx, $auth, $config, $db, $user);

- if (!defined('PHPBB_DISABLE_CONFIG_CHECK') && file_exists($phpbb_root_path . 'config.' . $phpEx) && phpbb_is_writable($phpbb_root_path . 'config.' . $phpEx))

- set_config('dbms_version', $db->sql_server_info(true));