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

{

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

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;

}

}

}

/**

* Handle passed database update array.

* Expected structure...

* Key being one of the following

$sqlite = true;

}

// Change columns?

if (!empty($schema_changes['change_columns']))

{

*/

function sql_prepare_column_data($table_name, $column_name, $column_data)

{

// Get type

if (strpos($column_data[0], ':') !== false)

{

{

$statements = array();

switch ($this->sql_layer)

{

case 'firebird':

{

$statements = array();

// remove index length unless MySQL4

if ('mysql_40' != $this->sql_layer)

{

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

if (!$user_id)

{

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

continue;

}

#

#

END;;

# Table: 'phpbb_moderator_cache'

CREATE TABLE phpbb_moderator_cache (

forum_id INTEGER DEFAULT 0 NOT NULL,

/*

*/

/*

Table: 'phpbb_moderator_cache'

*/

CREATE TABLE [phpbb_moderator_cache] (

) ON [PRIMARY]

GO

#

#

# Table: 'phpbb_attachments'

# 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'

# 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,

/*

*/

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 (

/*

*/

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 ('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_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',