$convertor_data = array(

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

'version' => '1.0.2',

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

'dbms' => $dbms,

'dbhost' => $dbhost,

@define('DEFAULT_AVATAR_X_CUSTOM', get_config_value('avatar_max_width'));

@define('DEFAULT_AVATAR_Y_CUSTOM', get_config_value('avatar_max_height'));

/**

* Description on how to use the convertor framework.

*

// username_clean in phpBB3 which is not possible, so we'll give the admin a list

// of user ids and usernames and let him deicde what he wants to do with them

'execute_first' => '

import_avatar_gallery();

if (defined("MOD_ATTACHMENT")) phpbb_import_attach_config();

phpbb_insert_forums();

'),

'schema' => array(

array(

'target' => (defined('MOD_ATTACHMENT')) ? ATTACHMENTS_TABLE : '',

array(

'target' => BANLIST_TABLE,

'query_first' => array('target', $convert->truncate_statement . BANLIST_TABLE),

array('ban_ip', 'banlist.ban_ip', 'decode_ban_ip'),

* Checks whether there are any usernames on the old board that would map to the same

* username_clean on phpBB3. Prints out a list if any exist and exits.

*/

{

global $db, $src_db, $convert, $table_prefix, $user, $lang;

}

// create a temporary table in which we store the clean usernames

switch ($map_dbms)

{

case 'firebird':

user_id INTEGER NOT NULL,

username_clean VARCHAR(255) CHARACTER SET UTF8 DEFAULT \'\' NOT NULL COLLATE UNICODE

)';

break;

case 'mssql':

[user_id] [int] NOT NULL ,

[username_clean] [varchar] (255) DEFAULT (\'\') NOT NULL

)';

break;

case 'mysql_40':

user_id mediumint(8) NOT NULL,

username_clean blob NOT NULL

)';

break;

case 'mysql_41':

user_id mediumint(8) NOT NULL,

username_clean varchar(255) DEFAULT \'\' NOT NULL

) CHARACTER SET `utf8` COLLATE `utf8_bin`';

break;

case 'oracle':

user_id number(8) NOT NULL,

username_clean varchar2(255) DEFAULT \'\'

)';

break;

case 'postgres':

user_id INT4 DEFAULT \'0\',

username_clean varchar_ci DEFAULT \'\' NOT NULL

)';

break;

case 'sqlite':

user_id INTEGER NOT NULL DEFAULT \'0\',

username_clean varchar(255) NOT NULL DEFAULT \'\'

)';

$db->sql_query($drop_sql);

$db->sql_return_on_error(false);

$db->sql_query($create_sql);

// now find the clean version of the usernames that collide

$sql = 'SELECT username_clean

GROUP BY username_clean

HAVING COUNT(user_id) > 1';

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

if (sizeof($colliding_names))

{

$sql = 'SELECT user_id, username_clean

WHERE ' . $db->sql_in_set('username_clean', $colliding_names);

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

unset($colliding_names);

$convert->p_master->error('<span style="color:red">' . $user->lang['COLLIDING_USERNAMES_FOUND'] . '</span></b><br /><br />' . $list . '<b>', __LINE__, __FILE__);

}

$db->sql_query($drop_sql);

}

*

*/

// 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'))

// No changes from 3.0.3-RC1 to 3.0.3

'3.0.3-RC1' => array(),

);

// Determine mapping database type

$no_updates = false;

break;

}

}

return trim($text);

}

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_hide INTEGER DEFAULT 0 NOT NULL,

field_no_view INTEGER DEFAULT 0 NOT NULL,

field_active INTEGER DEFAULT 0 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_hide] [int] DEFAULT (0) NOT NULL ,

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

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

forum_desc_uid varbinary(8) DEFAULT '' NOT NULL,

forum_link blob NOT NULL,

forum_password varbinary(120) DEFAULT '' NOT NULL,

forum_image varbinary(255) DEFAULT '' NOT NULL,

forum_rules blob NOT NULL,

forum_rules_link 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_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

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

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

# Table: 'phpbb_styles'

CREATE TABLE phpbb_styles (

style_name blob NOT NULL,

style_copyright blob NOT NULL,

style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

PRIMARY KEY (style_id),

UNIQUE style_name (style_name(255)),

KEY template_id (template_id),

# Table: 'phpbb_styles_template'

CREATE TABLE phpbb_styles_template (

template_name blob NOT NULL,

template_copyright blob NOT NULL,

template_path varbinary(100) DEFAULT '' NOT NULL,

# Table: 'phpbb_styles_template_data'

CREATE TABLE phpbb_styles_template_data (

template_filename varbinary(100) DEFAULT '' NOT NULL,

template_included blob NOT NULL,

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

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_name blob NOT NULL,

theme_copyright blob NOT NULL,

theme_path varbinary(100) DEFAULT '' NOT NULL,

# Table: 'phpbb_styles_imageset'

CREATE TABLE phpbb_styles_imageset (

imageset_name blob NOT NULL,

imageset_copyright blob NOT NULL,

imageset_path varbinary(100) DEFAULT '' NOT NULL,

# Table: 'phpbb_styles_imageset_data'

CREATE TABLE phpbb_styles_imageset_data (

image_name varbinary(200) DEFAULT '' NOT NULL,

image_filename varbinary(200) DEFAULT '' NOT NULL,

image_lang varbinary(30) DEFAULT '' NOT NULL,

image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (image_id),

KEY i_d (imageset_id)

);

user_timezone decimal(5,2) DEFAULT '0' NOT NULL,

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

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

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

user_colour varbinary(6) DEFAULT '' NOT NULL,

user_new_privmsg int(4) DEFAULT '0' NOT NULL,

forum_desc_uid varchar(8) DEFAULT '' NOT NULL,

forum_link varchar(255) DEFAULT '' NOT NULL,

forum_password varchar(40) DEFAULT '' NOT NULL,

forum_image varchar(255) DEFAULT '' NOT NULL,

forum_rules text NOT NULL,

forum_rules_link 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_hide tinyint(1) UNSIGNED DEFAULT '0' NOT NULL,

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

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

# Table: 'phpbb_styles'

CREATE TABLE phpbb_styles (

style_name varchar(255) DEFAULT '' NOT NULL,

style_copyright varchar(255) DEFAULT '' NOT NULL,

style_active tinyint(1) UNSIGNED DEFAULT '1' NOT NULL,

PRIMARY KEY (style_id),

UNIQUE style_name (style_name),

KEY template_id (template_id),

# Table: 'phpbb_styles_template'

CREATE TABLE phpbb_styles_template (

template_name varchar(255) DEFAULT '' NOT NULL,

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

# Table: 'phpbb_styles_template_data'

CREATE TABLE phpbb_styles_template_data (

template_filename varchar(100) DEFAULT '' NOT NULL,

template_included text NOT NULL,

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

# Table: 'phpbb_styles_theme'

CREATE TABLE phpbb_styles_theme (

theme_name varchar(255) DEFAULT '' NOT NULL,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

# Table: 'phpbb_styles_imageset'

CREATE TABLE phpbb_styles_imageset (

imageset_name varchar(255) DEFAULT '' NOT NULL,

imageset_copyright varchar(255) DEFAULT '' NOT NULL,

imageset_path varchar(100) DEFAULT '' NOT NULL,

# Table: 'phpbb_styles_imageset_data'

CREATE TABLE phpbb_styles_imageset_data (

image_name varchar(200) DEFAULT '' NOT NULL,

image_filename varchar(200) DEFAULT '' NOT NULL,

image_lang varchar(30) DEFAULT '' NOT NULL,

image_height smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

image_width smallint(4) UNSIGNED DEFAULT '0' NOT NULL,

PRIMARY KEY (image_id),

KEY i_d (imageset_id)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

user_timezone decimal(5,2) DEFAULT '0' NOT NULL,

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

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

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

user_colour varchar(6) DEFAULT '' NOT NULL,

user_new_privmsg int(4) DEFAULT '0' NOT NULL,

forum_desc_uid varchar2(8) DEFAULT '' ,

forum_link varchar2(765) DEFAULT '' ,

forum_password varchar2(120) DEFAULT '' ,

forum_image varchar2(255) DEFAULT '' ,

forum_rules clob DEFAULT '' ,

forum_rules_link 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_hide number(1) DEFAULT '0' NOT NULL,

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

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

Table: 'phpbb_styles'

*/

CREATE TABLE phpbb_styles (

style_name varchar2(765) DEFAULT '' ,

style_copyright varchar2(765) DEFAULT '' ,

style_active number(1) DEFAULT '1' NOT NULL,

CONSTRAINT pk_phpbb_styles PRIMARY KEY (style_id),

CONSTRAINT u_phpbb_style_name UNIQUE (style_name)

)

Table: 'phpbb_styles_template'

*/

CREATE TABLE phpbb_styles_template (

template_name varchar2(765) DEFAULT '' ,

template_copyright varchar2(765) DEFAULT '' ,

template_path varchar2(100) DEFAULT '' ,

Table: 'phpbb_styles_template_data'

*/

CREATE TABLE phpbb_styles_template_data (

template_filename varchar2(100) DEFAULT '' ,

template_included clob DEFAULT '' ,

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

Table: 'phpbb_styles_theme'

*/

CREATE TABLE phpbb_styles_theme (

theme_name varchar2(765) DEFAULT '' ,

theme_copyright varchar2(765) DEFAULT '' ,

theme_path varchar2(100) DEFAULT '' ,

Table: 'phpbb_styles_imageset'

*/

CREATE TABLE phpbb_styles_imageset (

imageset_name varchar2(765) DEFAULT '' ,

imageset_copyright varchar2(765) DEFAULT '' ,

imageset_path varchar2(100) DEFAULT '' ,

Table: 'phpbb_styles_imageset_data'

*/

CREATE TABLE phpbb_styles_imageset_data (

image_name varchar2(200) DEFAULT '' ,

image_filename varchar2(200) DEFAULT '' ,

image_lang varchar2(30) DEFAULT '' ,

image_height number(4) DEFAULT '0' NOT NULL,

image_width number(4) DEFAULT '0' NOT NULL,

CONSTRAINT pk_phpbb_styles_imageset_data PRIMARY KEY (image_id)

)

/

user_timezone number(5, 2) DEFAULT '0' NOT NULL,

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

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

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

user_colour varchar2(6) DEFAULT '' ,

user_new_privmsg number(4) DEFAULT '0' NOT NULL,

forum_desc_uid varchar(8) DEFAULT '' NOT NULL,

forum_link varchar(255) DEFAULT '' NOT NULL,

forum_password varchar(40) DEFAULT '' NOT NULL,

forum_image varchar(255) DEFAULT '' NOT NULL,

forum_rules varchar(4000) DEFAULT '' NOT NULL,

forum_rules_link 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_hide INT2 DEFAULT '0' NOT NULL CHECK (field_hide >= 0),

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

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

CREATE SEQUENCE phpbb_styles_seq;

CREATE TABLE phpbb_styles (

style_name varchar(255) DEFAULT '' NOT NULL,

style_copyright varchar(255) DEFAULT '' NOT NULL,

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

PRIMARY KEY (style_id)

);

CREATE SEQUENCE phpbb_styles_template_seq;

CREATE TABLE phpbb_styles_template (

template_name varchar(255) DEFAULT '' NOT NULL,

template_copyright varchar(255) DEFAULT '' NOT NULL,

template_path varchar(100) DEFAULT '' NOT NULL,

Table: 'phpbb_styles_template_data'

*/

CREATE TABLE phpbb_styles_template_data (

template_filename varchar(100) DEFAULT '' NOT NULL,

template_included varchar(8000) DEFAULT '' NOT NULL,

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

CREATE SEQUENCE phpbb_styles_theme_seq;

CREATE TABLE phpbb_styles_theme (

theme_name varchar(255) DEFAULT '' NOT NULL,

theme_copyright varchar(255) DEFAULT '' NOT NULL,

theme_path varchar(100) DEFAULT '' NOT NULL,

CREATE SEQUENCE phpbb_styles_imageset_seq;

CREATE TABLE phpbb_styles_imageset (

imageset_name varchar(255) DEFAULT '' NOT NULL,

imageset_copyright varchar(255) DEFAULT '' NOT NULL,

imageset_path varchar(100) DEFAULT '' NOT NULL,

CREATE SEQUENCE phpbb_styles_imageset_data_seq;

CREATE TABLE phpbb_styles_imageset_data (

image_name varchar(200) DEFAULT '' NOT NULL,

image_filename varchar(200) DEFAULT '' NOT NULL,

image_lang varchar(30) DEFAULT '' NOT NULL,

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

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

PRIMARY KEY (image_id)

);

user_timezone decimal(5,2) DEFAULT '0' NOT NULL,

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

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

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

user_colour varchar(6) DEFAULT '' NOT NULL,

user_new_privmsg INT4 DEFAULT '0' NOT NULL,

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

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_hide INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_no_view INTEGER UNSIGNED NOT NULL DEFAULT '0',

field_active INTEGER UNSIGNED NOT NULL DEFAULT '0',