include($phpbb_root_path . 'config.' . $phpEx);

unset($dbpasswd);

/**

* $convertor_data provides some basic information about this convertor which is

* used on the initial list of convertors and to populate the default settings

'forum_name' => 'phpBB 2.0.x',

'version' => '1.0.3',

'phpbb_version' => '3.1.0-dev',

'dbms' => $dbms,

'dbhost' => $dbhost,

'dbport' => $dbport,

*

*/

define('UPDATES_TO_VERSION', '3.1.0-dev');

// Enter any version to update from to test updates. The version within the db will not be updated.

$debug_from_version = DEBUG_FROM_VERSION;

$oldest_from_version = OLDEST_FROM_VERSION;

@set_time_limit(0);

// Include essential scripts

die("Please read: <a href='../docs/INSTALL.html'>INSTALL.html</a> before attempting to update.");

}

// Include files

require($phpbb_root_path . 'includes/class_loader.' . $phpEx);

require($phpbb_root_path . 'includes/functions.' . $phpEx);

phpbb_require_updated('includes/functions_content.' . $phpEx, true);

require($phpbb_root_path . 'includes/functions_admin.' . $phpEx);

require($phpbb_root_path . 'includes/constants.' . $phpEx);

require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

phpbb_require_updated('includes/db/db_tools.' . $phpEx);

define('EXT_TABLE', $table_prefix . 'ext');

}

$phpbb_class_loader->register();

// set up caching

// make sure request_var uses this request instance

request_var('', 0, false, false, $request); // "dependency injection" for a function

require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

$phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('template', 'display')));

{

@include($phpbb_root_path . 'includes/hooks/' . $hook . '.' . $phpEx);

}

$inline_update = (request_var('type', 0)) ? true : false;

// To let set_config() calls succeed, we need to make the config array available globally

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

<title><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></title>

</head>

<title><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></title>

</head>

add_log('admin', 'LOG_UPDATE_DATABASE', $orig_version, $updates_to_version);

// Now we purge the session table as well as all cache files

_print_footer();

</div>

<div id="page-footer">

</div>

</div>

{

global $db;

{

echo "<br />\n{$sql}\n<br />";

}

function _add_modules($modules_to_install)

{

// modules require an extension manager

if (empty($phpbb_extension_manager))

{

}

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

$_module->remove_cache_file();

}

/****************************************************************************

* ADD YOUR DATABASE SCHEMA CHANGES HERE *

*****************************************************************************/

'3.0.10-RC3' => array(),

// No changes from 3.0.10 to 3.0.11-RC1

'3.0.10' => array(),

/** @todo DROP LOGIN_ATTEMPT_TABLE.attempt_id in 3.0.12-RC1 */

'style_parent_tree' => array('TEXT', ''),

),

REPORTS_TABLE => array(

),

),

'change_columns' => array(

GROUPS_TABLE => array(

'group_legend' => array('UINT', 0),

),

),

),

);

*****************************************************************************/

function change_database_data(&$no_updates, $version)

{

switch ($version)

{

),

);

$statements = $db_tools->perform_schema_changes($changes);

foreach ($statements as $sql)

'user_email' => '',

'user_lang' => $config['default_lang'],

'user_style' => $config['default_style'],

'user_dateformat' => $config['default_dateformat'],

'user_allow_massemail' => 0,

);

}

$db->sql_freeresult($result);

if ($db_tools->sql_layer == 'firebird')

{

);

{

}

}

$no_updates = false;

break;

$no_updates = false;

break;

// Changes from 3.1.0-dev to 3.1.0-A1

case '3.1.0-dev':

set_config('search_type', 'phpbb_search_' . $config['search_type']);

}

if (!isset($config['load_jquery_cdn']))

{

set_config('load_jquery_cdn', 0);

unset($next_legend);

}

// Install modules

$modules_to_install = array(

'position' => array(

'auth' => '',

'cat' => 'UCP_PROFILE',

),

);

_add_modules($modules_to_install);

$sql = 'DELETE FROM ' . MODULES_TABLE . "

WHERE (module_basename = 'styles' OR module_basename = 'acp_styles') AND (module_mode = 'imageset' OR module_mode = 'theme' OR module_mode = 'template')";

_sql($sql, $errored, $error_ary);

// Create config value for displaying last subject on forum list

if (!isset($config['display_last_subject']))

$config->set('display_last_subject', '1');

}

if (!isset($config['assets_version']))

{

$config->set('assets_version', '1');

}

break;

}

}

*

*/

/**#@+

* @ignore

*/

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

{

}

function phpbb_require_updated($path, $optional = false)

}

@ini_set('memory_limit', $mem_limit);

// Include essential scripts

require($phpbb_root_path . 'includes/class_loader.' . $phpEx);

require($phpbb_root_path . 'includes/functions.' . $phpEx);

phpbb_require_updated('includes/functions_content.' . $phpEx, true);

include($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

require($phpbb_root_path . 'includes/functions_install.' . $phpEx);

$phpbb_class_loader->register();

// make sure request_var uses this request instance

request_var('', 0, false, false, $request); // "dependency injection" for a function

require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

$phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('template', 'display')));

{

@include($phpbb_root_path . 'includes/hooks/' . $hook . '.' . $phpEx);

}

$phpbb_style_resource_locator = new phpbb_style_resource_locator();

$phpbb_style_path_provider = new phpbb_style_path_provider();

$phpbb_style = new phpbb_style($phpbb_root_path, $phpEx, $config, $user, $phpbb_style_resource_locator, $phpbb_style_path_provider, $template);

$phpbb_style->set_ext_dir_prefix('adm/');

$template->assign_var('T_ASSETS_PATH', '../assets');

$install = new module();

}

define('HEADER_INC', true);

$template->assign_vars(array(

'L_CHANGE' => $lang['CHANGE'],

'L_INSTALL_PANEL' => $lang['INSTALL_PANEL'],

'L_SELECT_LANG' => $lang['SELECT_LANG'],

'L_SKIP' => $lang['SKIP'],

'PAGE_TITLE' => $this->get_page_title(),

'S_CONTENT_DIRECTION' => $lang['DIRECTION'],

'S_CONTENT_FLOW_BEGIN' => ($lang['DIRECTION'] == 'ltr') ? 'left' : 'right',

*/

function error($error, $line, $file, $skip = false)

{

if ($skip)

{

echo '<head>';

echo '<meta charset="utf-8">';

echo '<title>' . $lang['INST_ERR_FATAL'] . '</title>';

echo '</head>';

echo '<body id="errorpage">';

echo '<div id="wrap">';

echo ' </div>';

echo ' </div>';

echo ' <div id="page-footer">';

echo ' </div>';

echo '</div>';

echo '</body>';

require($phpbb_root_path . 'config.' . $phpEx);

require($phpbb_root_path . 'includes/constants.' . $phpEx);

require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

unset($dbpasswd);

require($phpbb_root_path . 'config.' . $phpEx);

require($phpbb_root_path . 'includes/constants.' . $phpEx);

require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

unset($dbpasswd);

require($phpbb_root_path . 'config.' . $phpEx);

require($phpbb_root_path . 'includes/constants.' . $phpEx);

require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

unset($dbpasswd);

if ($src_dbms != $dbms || $src_dbhost != $dbhost || $src_dbport != $dbport || $src_dbname != $dbname || $src_dbuser != $dbuser)

{

$src_db->sql_connect($src_dbhost, $src_dbuser, htmlspecialchars_decode($src_dbpasswd), $src_dbname, $src_dbport, false, true);

$same_db = false;

}

*/

function convert_data($sub)

{

global $convert, $convert_row, $message_parser, $skip_rows, $language;

global $request;

require($phpbb_root_path . 'config.' . $phpEx);

require($phpbb_root_path . 'includes/constants.' . $phpEx);

require($phpbb_root_path . 'includes/functions_convert.' . $phpEx);

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, true);

unset($dbpasswd);

$src_db = $same_db = null;

if ($convert->src_dbms != $dbms || $convert->src_dbhost != $dbhost || $convert->src_dbport != $dbport || $convert->src_dbname != $dbname || $convert->src_dbuser != $dbuser)

{

$src_db->sql_connect($convert->src_dbhost, $convert->src_dbuser, htmlspecialchars_decode($convert->src_dbpasswd), $convert->src_dbname, $convert->src_dbport, false, true);

$same_db = false;

}

}

$error = false;

if ($error)

{

}

else if (sizeof($missing_tables))

{

}

$url = $this->save_convert_progress('&amp;confirm=1');

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

'TITLE' => "skip_rows = $skip_rows",

));

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

}

// When we reach this point, either the current table has been processed or we're running out of time.

{

$skip_rows = 0;

$current_table++;

sync('topic', 'range', 'topic_id BETWEEN ' . $sync_batch . ' AND ' . $end, true, true);

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

'RESULT' => $user->lang['DONE'],

));

function finish_conversion()

{

global $db, $phpbb_root_path, $phpEx, $convert, $config, $language, $user, $template;

$db->sql_query('DELETE FROM ' . CONFIG_TABLE . "

WHERE config_name = 'convert_progress'

$db->sql_query('DELETE FROM ' . SESSIONS_TABLE);

@unlink($phpbb_root_path . 'cache/data_global.' . $phpEx);

// And finally, add a note to the log

add_log('admin', 'LOG_INSTALL_CONVERTED', $convert->convertor_data['forum_name'], $config['version']);

global $convert;

// Can we use IGNORE with this DBMS?

$insert_query = 'INSERT ' . $sql_ignore . 'INTO ' . $schema['target'] . ' (';

$aliases = array();

function main($mode, $sub)

{

switch ($sub)

{

case 'intro':

$this->page_title = $lang['SUB_INTRO'];

break;

case 'final':

$this->build_search_index($mode, $sub);

$this->add_modules($mode, $sub);

$this->add_language($mode, $sub);

// Test the minimum PHP version

$php_version = PHP_VERSION;

{

$result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

}

'S_EXPLAIN' => true,

'S_LEGEND' => false,

));

// Check for php json support

if (@extension_loaded('json'))

{

'S_LEGEND' => false,

));

$passed['mbstring'] = true;

if (@extension_loaded('mbstring'))

{

{

if (!@extension_loaded($dll))

{

}

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

$written = false;

// Create a list of any PHP modules we wish to have loaded

$available_dbms = get_available_dbms($data['dbms']);

// Create a lock file to indicate that there is an install in progress

$fp = @fopen($phpbb_root_path . 'cache/install_lock', 'wb');

@chmod($phpbb_root_path . 'cache/install_lock', 0777);

// Time to convert the data provided into a config file

// Attempt to write out the config file directly. If it works, this is the easiest way to do it ...

if ((file_exists($phpbb_root_path . 'config.' . $phpEx) && phpbb_is_writable($phpbb_root_path . 'config.' . $phpEx)) || phpbb_is_writable($phpbb_root_path))

$dbms = $available_dbms[$data['dbms']]['DRIVER'];

// Instantiate the database

$db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false);

// NOTE: trigger_error does not work here.

$sql_query = preg_replace('#phpbb_#i', $data['table_prefix'], $sql_query);

$sql_query = split_sql_file($sql_query, $delimiter);

// Change language strings...

$sql_query = preg_replace_callback('#\{L_([A-Z0-9\-_]*)\}#s', 'adjust_language_keys_callback', $sql_query);

$sql_query = split_sql_file($sql_query, ';');

foreach ($sql_query as $sql)

WHERE config_name = 'dbms_version'",

);

{

$sql_ary[] = 'UPDATE ' . $data['table_prefix'] . "config

SET config_value = 'phpbb_captcha_gd'

*/

function build_search_index($mode, $sub)

{

// Obtain any submitted data

$data = $this->get_submitted_data();

$dbms = $available_dbms[$data['dbms']]['DRIVER'];

// Instantiate the database

$db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false);

// NOTE: trigger_error does not work here.

set_config_count(null, null, null, $config);

$error = false;

$sql = 'SELECT post_id, post_subject, post_text, poster_id, forum_id

FROM ' . POSTS_TABLE;

*/

function add_modules($mode, $sub)

{

// modules require an extension manager

if (empty($phpbb_extension_manager))

{

}

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

foreach ($this->module_categories[$module_class] as $cat_name => $subs)

{

$module_data = array(

'module_enabled' => 1,

'module_display' => 1,

'parent_id' => 0,

{

foreach ($subs as $level2_name)

{

$module_data = array(

'module_enabled' => 1,

'module_display' => 1,

'parent_id' => (int) $categories[$cat_name]['id'],

'user_email' => '',

'user_lang' => $data['default_lang'],

'user_style' => 1,

'user_dateformat' => $lang['default_dateformat'],

'user_allow_massemail' => 0,

);

$user_id = user_add($user_row);

*/

function email_admin($mode, $sub)

{

$this->page_title = $lang['STAGE_FINAL'];

'TITLE' => $lang['INSTALL_CONGRATS'],

'BODY' => sprintf($lang['INSTALL_CONGRATS_EXPLAIN'], $config['version'], append_sid($phpbb_root_path . 'install/index.' . $phpEx, 'mode=convert&amp;language=' . $data['language']), '../docs/README.html'),

'L_SUBMIT' => $lang['INSTALL_LOGIN'],

));

}

'Alexa [Bot]' => array('ia_archiver', ''),

'Alta Vista [Bot]' => array('Scooter/', ''),

'Ask Jeeves [Bot]' => array('Ask Jeeves', ''),

'FAST Enterprise [Crawler]' => array('FAST Enterprise Crawler', ''),

'FAST WebCrawler [Crawler]' => array('FAST-WebCrawler/', ''),

'Francis [Bot]' => array('http://www.neomo.de/', ''),

'MSN NewsBlogs' => array('msnbot-NewsBlogs/', ''),

'MSN [Bot]' => array('msnbot/', ''),

'MSNbot Media' => array('msnbot-media/', ''),

'Nutch [Bot]' => array('http://lucene.apache.org/nutch/', ''),

'Online link [Validator]' => array('online link validator', ''),

'psbot [Picsearch]' => array('psbot/0', ''),

'Sensis [Crawler]' => array('Sensis Web Crawler', ''),

'SEO Crawler' => array('SEO search Crawler/', ''),

'Seoma [Crawler]' => array('Seoma [SEO Crawler]', ''),

'SEOSearch [Crawler]' => array('SEOsearch/', ''),

'Snappy [Bot]' => array('Snappy/1.1 ( http://www.urltrends.com/ )', ''),

'Steeler [Crawler]' => array('http://www.tkl.iis.u-tokyo.ac.jp/~crawler/', ''),

'Telekom [Bot]' => array('crawleradmin.t-info@telekom.de', ''),

'TurnitinBot [Bot]' => array('TurnitinBot/', ''),

'W3 [Sitesearch]' => array('W3 SiteSearch Crawler', ''),

'W3C [Linkcheck]' => array('W3C-checklink/', ''),

'YaCy [Bot]' => array('yacybot', ''),

'Yahoo MMCrawler [Bot]' => array('Yahoo-MMCrawler/', ''),

'Yahoo Slurp [Bot]' => array('Yahoo! DE Slurp', ''),

'ACP_PERMISSION_ROLES',

'ACP_PERMISSION_MASKS',

),

'ACP_STYLE_MANAGEMENT',

),

'ACP_CAT_MAINTENANCE' => array(

'ACP_FORUM_LOGS',

'UCP_ZEBRA' => null,

),

);

var $module_extras = array(

'acp' => array(

function main($mode, $sub)

{

$this->tpl_name = 'install_update';

$this->page_title = 'UPDATE_INSTALLATION';

// Init DB

require($phpbb_root_path . 'config.' . $phpEx);

require($phpbb_root_path . 'includes/constants.' . $phpEx);

// Special options for conflicts/modified files

define('MERGE_NEW_FILE', 3);

define('MERGE_MOD_FILE', 4);

// Connect to DB

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, false);

}

// Set custom template again. ;)

$template->assign_vars(array(

'S_USER_LANG' => $user->lang['USER_LANG'],

if ($this->test_update === false)

{

// Got the updater template itself updated? If so, we are able to directly use it - but only if all three files are present

{

$this->tpl_name = '../../install/update/new/adm/style/install_update';

}

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

$update_list = ($request->variable('check_again', false, false, phpbb_request_interface::POST)) ? false : $cache->get('_update_list');

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

if ($update_list !== false)

$template->assign_vars(array(

'S_FILE_CHECK' => true,

'S_ALL_UP_TO_DATE' => $all_up_to_date,

'S_VERSION_UP_TO_DATE' => $up_to_date,

'U_ACTION' => append_sid($this->p_master->module_url, "language=$language&amp;mode=$mode&amp;sub=file_check"),

'U_UPDATE_ACTION' => append_sid($this->p_master->module_url, "language=$language&amp;mode=$mode&amp;sub=update_files"),

$test_connection = false;

if ($test_ftp_connection || $submit)

{

$test_connection = $transfer->open_session();

// Make sure that the directory is correct by checking for the existence of common.php

}

else

{

$transfer->open_session();

}

*/

function show_diff(&$update_list)

{

$this->tpl_name = 'install_update_diff';

// Got the diff template itself updated? If so, we are able to directly use it

{

$this->tpl_name = '../../install/update/new/adm/style/install_update_diff';

}

field_default_value VARCHAR(255) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

field_validation VARCHAR(20) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

field_required INTEGER DEFAULT 0 NOT NULL,

field_show_on_reg INTEGER DEFAULT 0 NOT NULL,

field_show_on_pm INTEGER DEFAULT 0 NOT NULL,

field_show_on_vt INTEGER DEFAULT 0 NOT NULL,

report_closed INTEGER DEFAULT 0 NOT NULL,

report_time INTEGER DEFAULT 0 NOT NULL,

report_text BLOB SUB_TYPE TEXT CHARACTER SET UTF8 DEFAULT '' NOT NULL,

);;

ALTER TABLE phpbb_reports ADD PRIMARY KEY (report_id);;

user_inactive_time INTEGER DEFAULT 0 NOT NULL,

user_posts INTEGER DEFAULT 0 NOT NULL,

user_lang VARCHAR(30) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_dateformat VARCHAR(30) CHARACTER SET UTF8 DEFAULT 'd M Y H:i' NOT NULL COLLATE UNICODE,

user_style INTEGER DEFAULT 0 NOT NULL,

user_rank INTEGER DEFAULT 0 NOT NULL,

[field_default_value] [varchar] (255) DEFAULT ('') NOT NULL ,

[field_validation] [varchar] (20) DEFAULT ('') NOT NULL ,

[field_required] [int] DEFAULT (0) NOT NULL ,

[field_show_on_reg] [int] DEFAULT (0) NOT NULL ,

[field_show_on_pm] [int] DEFAULT (0) NOT NULL ,

[field_show_on_vt] [int] DEFAULT (0) NOT NULL ,

[report_closed] [int] DEFAULT (0) NOT NULL ,

[report_time] [int] DEFAULT (0) NOT NULL ,

[report_text] [text] DEFAULT ('') NOT NULL ,

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

[user_inactive_time] [int] DEFAULT (0) NOT NULL ,

[user_posts] [int] DEFAULT (0) NOT NULL ,

[user_lang] [varchar] (30) DEFAULT ('') NOT NULL ,

[user_dateformat] [varchar] (30) DEFAULT ('d M Y H:i') NOT NULL ,

[user_style] [int] DEFAULT (0) NOT NULL ,

[user_rank] [int] DEFAULT (0) NOT NULL ,

field_default_value blob NOT NULL,

field_validation varbinary(60) DEFAULT '' NOT NULL,

field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumblob NOT NULL,

reported_post_text mediumblob NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_lang varbinary(30) DEFAULT '' NOT NULL,

user_dateformat varbinary(90) DEFAULT 'd M Y H:i' NOT NULL,

user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

field_default_value varchar(255) DEFAULT '' NOT NULL,

field_validation varchar(20) DEFAULT '' NOT NULL,

field_required tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_reg tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_pm tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

field_show_on_vt tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

report_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

report_text mediumtext NOT NULL,

reported_post_text mediumtext NOT NULL,

PRIMARY KEY (report_id),

KEY post_id (post_id),

KEY pm_id (pm_id)

user_inactive_time int(11) UNSIGNED DEFAULT '0' NOT NULL,

user_posts mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_lang varchar(30) DEFAULT '' NOT NULL,

user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,

user_style mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

user_rank mediumint(8) UNSIGNED DEFAULT '0' NOT NULL,

field_default_value varchar2(765) DEFAULT '' ,

field_validation varchar2(60) DEFAULT '' ,

field_required number(1) DEFAULT '0' NOT NULL,

field_show_on_reg number(1) DEFAULT '0' NOT NULL,

field_show_on_pm number(1) DEFAULT '0' NOT NULL,

field_show_on_vt number(1) DEFAULT '0' NOT NULL,

report_time number(11) DEFAULT '0' NOT NULL,

report_text clob DEFAULT '' ,

reported_post_text clob DEFAULT '' ,

CONSTRAINT pk_phpbb_reports PRIMARY KEY (report_id)

)

/

user_inactive_time number(11) DEFAULT '0' NOT NULL,

user_posts number(8) DEFAULT '0' NOT NULL,

user_lang varchar2(30) DEFAULT '' ,

user_dateformat varchar2(90) DEFAULT 'd M Y H:i' NOT NULL,

user_style number(8) DEFAULT '0' NOT NULL,

user_rank number(8) DEFAULT '0' NOT NULL,

field_default_value varchar(255) DEFAULT '' NOT NULL,

field_validation varchar(20) DEFAULT '' NOT NULL,

field_required INT2 DEFAULT '0' NOT NULL CHECK (field_required >= 0),

field_show_on_reg INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_reg >= 0),

field_show_on_pm INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_pm >= 0),

field_show_on_vt INT2 DEFAULT '0' NOT NULL CHECK (field_show_on_vt >= 0),

report_time INT4 DEFAULT '0' NOT NULL CHECK (report_time >= 0),

report_text TEXT DEFAULT '' NOT NULL,

reported_post_text TEXT DEFAULT '' NOT NULL,

PRIMARY KEY (report_id)

);

user_inactive_time INT4 DEFAULT '0' NOT NULL CHECK (user_inactive_time >= 0),

user_posts INT4 DEFAULT '0' NOT NULL CHECK (user_posts >= 0),

user_lang varchar(30) DEFAULT '' NOT NULL,

user_dateformat varchar(30) DEFAULT 'd M Y H:i' NOT NULL,

user_style INT4 DEFAULT '0' NOT NULL CHECK (user_style >= 0),

user_rank INT4 DEFAULT '0' NOT NULL CHECK (user_rank >= 0),

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_contact', 'contact@yourdomain.tld');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable_msg', '');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email', 'address@yourdomain.tld');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig', '{L_CONFIG_BOARD_EMAIL_SIG}');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_hide_emails', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('browser_check', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_interval', '10');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('bump_type', 'd');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_native_load_upd', '1');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_native_max_chars', '14');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('fulltext_native_min_chars', '3');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress', '0');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold', '25');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('icons_path', 'images/icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_gc', '3600');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length', '3600');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc', '{L_CONFIG_SITE_DESC}');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename', '{L_CONFIG_SITENAME}');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path', 'images/smilies');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_per_page', '50');

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_bots', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_clearlogs', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_email', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_fauth', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_forum', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('a_forumadd', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chggrp', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgname', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_chgpasswd', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_download', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_hideonline', 1);

INSERT INTO phpbb_acl_options (auth_option, is_global) VALUES ('u_ignoreflood', 1);

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 22, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option NOT IN ('f_announce', 'f_attach', 'f_bump', 'f_delete', 'f_flash', 'f_icons', 'f_ignoreflood', 'f_sticky', 'f_user_lock', 'f_votechg');

# New Member (u_)

# New Member (f_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 24, auth_option_id, 0 FROM phpbb_acl_options WHERE auth_option LIKE 'f_%' AND auth_option IN ('f_noapprove');

field_default_value varchar(255) NOT NULL DEFAULT '',

field_validation varchar(20) NOT NULL DEFAULT '',

field_required INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_reg INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_pm INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_show_on_vt INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_closed INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

report_text mediumtext(16777215) NOT NULL DEFAULT '',

);

CREATE INDEX phpbb_reports_post_id ON phpbb_reports (post_id);

user_inactive_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_posts INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_lang varchar(30) NOT NULL DEFAULT '',

user_dateformat varchar(30) NOT NULL DEFAULT 'd M Y H:i',

user_style INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_rank INTEGER UNSIGNED NOT NULL DEFAULT '0',