$convertor_data = array(

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

'version' => '1.0.3',

'author' => '<a href="http://www.phpbb.com/">phpBB Group</a>',

'dbms' => $dbms,

'dbhost' => $dbhost,

'avatar_filesize' => 'avatar_filesize',

'avatar_max_width' => 'avatar_max_width',

'avatar_max_height' => 'avatar_max_height',

'board_timezone' => 'board_timezone',

'allow_privmsg' => 'not(privmsg_disable)',

'gzip_compress' => 'gzip_compress',

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('topic_last_view_time', 'posts.post_time', 'intval'),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('poll_length', 'vote_desc.vote_length', 'null_to_zero'),

array('poll_max_options', 1, ''),

array('topic_type', 'topics.topic_type', 'phpbb_convert_topic_type'),

array('topic_first_post_id', 'topics.topic_first_post_id', ''),

array('poll_start', 'vote_desc.vote_start', 'null_to_zero'),

array('poll_length', 'vote_desc.vote_length', 'null_to_zero'),

array('poll_max_options', 1, ''),

array('poll_option_id', 'vote_results.vote_option_id', ''),

array('topic_id', 'vote_desc.topic_id', ''),

array('', 'topics.topic_poster AS poster_id', 'phpbb_user_id'),

array('poll_option_total', 'vote_results.vote_result', ''),

'where' => 'vote_results.vote_id = vote_desc.vote_id',

{

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' ON');

break;

}

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' OFF');

break;

case 'mssql':

case 'mssql_odbc':

$map_dbms = 'mssql';

break;

*

*/

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

// Which oldest version does this updater support?

// Return if we "just include it" to find out for which version the database update is responsible for

if (defined('IN_PHPBB') && defined('IN_INSTALL'))

{

return;

}

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

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

{

}

error_reporting(E_ALL);

@set_time_limit(0);

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

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

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

require($phpbb_root_path . 'includes/db/' . $dbms . '.' . $phpEx);

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

{

}

$user = new user();

}

$db->sql_freeresult($result);

$database_update_info = database_update_info();

set_config('dbms_version', $db->sql_server_info(true));

}

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

{

// We do not trust any PHP5 function enabled, we will simply test for a function new in 2.1

</div>

<div id="page-footer">

</div>

</div>

$db->sql_return_on_error(true);

{

}

$db->sql_return_on_error(false);

'3.0.7-PL1' => array(),

// No changes from 3.0.8-RC1 to 3.0.8

'3.0.8-RC1' => array(),

);

}

// No changes from 3.0.8-RC1 to 3.0.8

case '3.0.8-RC1':

break;

{

}

{

{

{

}

}

}

{

}

{

}

{

}

{

{

}

{

}

}

}

}

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

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

// @todo Review this test and see if we can find out what it is which prevents PHP 4.2.x from even displaying the page with requirements on it

if (version_compare(PHP_VERSION, '4.3.3') < 0)

{

die('You are running an unsupported PHP version. Please upgrade to PHP 4.3.3 or higher before trying to install phpBB 3.0');

}

{

}

{

}

}

// Try to override some limits - maybe it helps some...

@set_time_limit(0);

$mem_limit = @ini_get('memory_limit');

// Include essential scripts

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

include($phpbb_root_path . 'includes/auth.' . $phpEx);

include($phpbb_root_path . 'includes/session.' . $phpEx);

echo ' </div>';

echo ' </div>';

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

echo ' </div>';

echo '</div>';

echo '</body>';

fix_empty_primary_groups();

}

update_dynamic_config();

function main($mode, $sub)

{

switch ($sub)

{

case 'intro':

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

$template->assign_vars(array(

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

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

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

// Remove the lock file

@unlink($phpbb_root_path . 'cache/install_lock');

'S_LEGEND' => false,

));

{

// Check for url_fopen

if (@ini_get('allow_url_fopen') == '1' || strtolower(@ini_get('allow_url_fopen')) == 'on')

$error[] = $lang['INST_ERR_NO_DB'];

$connect_test = false;

}

else

{

$connect_test = connect_check_db(true, $error, $available_dbms[$data['dbms']], $data['table_prefix'], $data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport']);

@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_schema = 'schemas/' . $available_dbms[$data['dbms']]['SCHEMA'] . '_schema.sql';

// How should we treat this schema?

$delimiter = $available_dbms[$data['dbms']]['DELIM'];

$sql_query = @file_get_contents($dbms_schema);

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

if (!$user_id)

{

$this->p_master->db_error('Unable to insert bot into users table', $db->sql_error_sql, __LINE__, __FILE__, true);

continue;

}

$messenger->to($data['board_email1'], $data['admin_name']);

$messenger->assign_vars(array(

'USERNAME' => htmlspecialchars_decode($data['admin_name']),

}

/**

* Generate a list of available mail server authentication methods

*/

function mail_auth_select($selected_method)

'dbname' => array('lang' => 'DB_NAME', 'type' => 'text:25:100', 'explain' => false),

'dbuser' => array('lang' => 'DB_USERNAME', 'type' => 'text:25:100', 'explain' => false),

'dbpasswd' => array('lang' => 'DB_PASSWORD', 'type' => 'password:25:100', 'explain' => false),

);

var $admin_config_options = array(

'legend1' => 'ADMIN_CONFIG',

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

END;;

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

forum_id INTEGER DEFAULT 0 NOT NULL,

/*

/*

Table: 'phpbb_attachments'

/*

Table: 'phpbb_moderator_cache'

*/

CREATE TABLE [phpbb_moderator_cache] (

) ON [PRIMARY]

GO

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

bbcode_tag varbinary(16) DEFAULT '' NOT NULL,

bbcode_helpline blob NOT NULL,

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

);

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

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

#

# Table: 'phpbb_attachments'

CREATE TABLE phpbb_attachments (

attach_id mediumint(8) UNSIGNED NOT NULL auto_increment,

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

bbcode_helpline varchar(255) DEFAULT '' NOT NULL,

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

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

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

/*

/*

This first section is optional, however its probably the best method

Table: 'phpbb_bbcodes'

*/

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar2(16) DEFAULT '' ,

bbcode_helpline varchar2(765) DEFAULT '' ,

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

/*

Table: 'phpbb_moderator_cache'

*/

CREATE TABLE phpbb_moderator_cache (

/*

BEGIN;

Table: 'phpbb_bbcodes'

*/

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

bbcode_helpline varchar(255) DEFAULT '' NOT NULL,

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

CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);

/*

Table: 'phpbb_moderator_cache'

*/

CREATE TABLE phpbb_moderator_cache (

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

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

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

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

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

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

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

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_function_name', 'mail');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('email_package_size', '20');

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

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('feed_limit_post', '15');

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('img_min_thumb_filesize', '12000');

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

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

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_icons_path', 'images/upload_icons');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('upload_path', 'files');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_expire_days', '90');

INSERT INTO phpbb_config (config_name, config_value) VALUES ('warnings_gc', '14400');

# No Avatar (u_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_attach', 'u_chgavatar', 'u_viewonline', 'u_chggrp', 'u_chgname', 'u_ignoreflood', 'u_pm_attach', 'u_pm_emailpm', 'u_pm_flash', 'u_savedrafts', 'u_search', 'u_sendemail', 'u_sendim', 'u_masspm', 'u_masspm_group');

# Full Moderator (m_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 10, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%';

INSERT INTO phpbb_reports_reasons (reason_title, reason_description, reason_order) VALUES ('other', '{L_REPORT_OTHER}', 4);

# -- extension_groups

# -- extensions

INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'gif');

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogg');

INSERT INTO phpbb_extensions (group_id, extension) VALUES (9, 'ogm');

#

BEGIN TRANSACTION;

# Table: 'phpbb_attachments'

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar(16) NOT NULL DEFAULT '',

bbcode_helpline varchar(255) NOT NULL DEFAULT '',

display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '0',

CREATE INDEX phpbb_log_reportee_id ON phpbb_log (reportee_id);

CREATE INDEX phpbb_log_user_id ON phpbb_log (user_id);

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

forum_id INTEGER UNSIGNED NOT NULL DEFAULT '0',