array('topic_moved_id', 0, ''),

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

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

array('poll_title', 'vote_desc.vote_text', array('function1' => 'null_to_str', 'function2' => 'phpbb_set_encoding', 'function3' => 'utf8_htmlspecialchars')),

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_vote_change', 0, ''),

'where' => 'topics.topic_moved_id = 0',

),

{

$birthday = (int) $birthday;

{

return ' 0- 0- 0';

}

*

*/

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

{

return;

),

),

),

);

// Determine mapping database type

$modify_users = request_var('modify_users', array(0 => ''));

$new_usernames = request_var('new_usernames', array(0 => ''), true);

if (!class_exists('utf_new_normalizer'))

{

if (!file_exists($phpbb_root_path . 'install/data/new_normalizer.' . $phpEx))

$no_updates = false;

}

_write_result($no_updates, $errored, $error_ary);

$error_ary = array();

global $db, $template;

$template->display('body');

// Close our DB connection.

if (!empty($db) && is_object($db))

{

*/

function redirect($page)

{

$server_port = (!empty($_SERVER['SERVER_PORT'])) ? (int) $_SERVER['SERVER_PORT'] : (int) getenv('SERVER_PORT');

$secure = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? 1 : 0;

if ($server_port && (($secure && $server_port <> 443) || (!$secure && $server_port <> 80)))

{

}

$url .= $script_path . '/' . $page;

$l_cat = (!empty($lang['CAT_' . $cat])) ? $lang['CAT_' . $cat] : preg_replace('#_#', ' ', $cat);

$cat = strtolower($cat);

$url = $this->module_url . "?mode=$cat&amp;language=$language";

if ($this->mode == $cat)

{

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

$error = array();

if ($submit)

{

{

$error[] = sprintf($lang['COULD_NOT_FIND_PATH'], $forum_path);

}

}

else

{

}

// The forum prefix of the old and the new forum can only be the same if two different databases are used.

{

$sql_db = 'dbal_' . $src_dbms;

$src_db = new $sql_db();

$same_db = false;

}

else

}

$sql_db = 'dbal_' . $convert->src_dbms;

$src_db = new $sql_db();

$same_db = false;

}

else

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

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

));

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

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

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

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

));

case 'database':

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

break;

case 'administrator':

case 'config_file':

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

break;

case 'advanced':

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

// We also give feedback on whether we're running in safe mode

$result = '<strong style="color:green">' . $lang['YES'];

{

$result .= ', ' . $lang['PHP_SAFE_MODE'];

}

'S_EXPLAIN' => true,

'S_LEGEND' => false,

));

// Check for url_fopen

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

{

'S_EXPLAIN' => true,

'S_LEGEND' => false,

));

// Check for getimagesize

if (@function_exists('getimagesize'))

{

}

else

{

}

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

$s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

}

}

$s_hidden_fields .= ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : '';

$s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

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

$config_data = "<?php\n";

$config_data .= "// phpBB 3.0.x auto-generated configuration file\n// Do not change anything in this file!\n";

$config_data .= "// @define('DEBUG', true);\n";

$config_data .= "// @define('DEBUG_EXTRA', true);\n";

$config_data .= '?' . '>'; // Done this to prevent highlighting editors getting confused!

// 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) && is_writable($phpbb_root_path . 'config.' . $phpEx)) || is_writable($phpbb_root_path))

{

$s_hidden_fields = ($data['img_imagick']) ? '<input type="hidden" name="img_imagick" value="' . addslashes($data['img_imagick']) . '" />' : '';

$s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

$data['email_enable'] = ($data['email_enable'] !== '') ? $data['email_enable'] : true;

$data['server_port'] = ($data['server_port'] !== '') ? $data['server_port'] : ((!empty($_SERVER['SERVER_PORT'])) ? (int) $_SERVER['SERVER_PORT'] : (int) getenv('SERVER_PORT'));

$data['server_protocol'] = ($data['server_protocol'] !== '') ? $data['server_protocol'] : ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? 'https://' : 'http://');

$data['cookie_secure'] = ($data['cookie_secure'] !== '') ? $data['cookie_secure'] : ((isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? true : false);

$this->p_master->redirect("index.$phpEx?mode=install");

}

// Try to come up with the best solution for cookie domain...

if (strpos($cookie_domain, 'www.') === 0)

// Instantiate the database

$db = new $sql_db();

// NOTE: trigger_error does not work here.

$db->sql_return_on_error(true);

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

SET config_value = '" . $db->sql_escape($data['admin_name']) . "'

WHERE config_name = 'newest_username'",

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

SET config_value = '" . md5(mt_rand()) . "'

WHERE config_name = 'avatar_salt'",

'UPDATE ' . $data['table_prefix'] . "users

SET username = '" . $db->sql_escape($data['admin_name']) . "', user_password='" . $db->sql_escape(md5($data['admin_pass1'])) . "', user_ip = '" . $db->sql_escape($user_ip) . "', user_lang = '" . $db->sql_escape($data['default_lang']) . "', user_email='" . $db->sql_escape($data['board_email1']) . "', user_dateformat='" . $db->sql_escape($lang['default_dateformat']) . "', user_email_hash = " . (crc32($data['board_email1']) . strlen($data['board_email1'])) . ", username_clean = '" . $db->sql_escape(utf8_clean_string($data['admin_name'])) . "'

WHERE username = 'Admin'",

// Instantiate the database

$db = new $sql_db();

// NOTE: trigger_error does not work here.

$db->sql_return_on_error(true);

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

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

$db->sql_freeresult($result);

$_module->move_module_by($row, 'move_up', 4);

// Move permissions intro screen module 4 up...

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

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

$db->sql_freeresult($result);

$_module->move_module_by($row, 'move_up', 4);

// Move manage users screen module 5 up...

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

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

$db->sql_freeresult($result);

$_module->move_module_by($row, 'move_up', 5);

}

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

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

$db->sql_freeresult($result);

$_module->move_module_by($row, 'move_down', 4);

}

if (is_dir($path) && file_exists($path . '/iso.txt'))

{

$lang_pack = array(

'lang_iso' => basename($path),

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

'user_allow_massemail' => 0,

);

$user_id = user_add($user_row);

if (!$user_id)

'dbhost' => request_var('dbhost', ''),

'dbport' => request_var('dbport', ''),

'dbuser' => request_var('dbuser', ''),

'dbname' => request_var('dbname', ''),

'table_prefix' => request_var('table_prefix', ''),

'default_lang' => basename(request_var('default_lang', '')),

{

var $p_master;

var $update_info;

var $old_location;

var $new_location;

var $latest_version;

{

continue;

}

$methods[] = $type;

}

return;

}

{

foreach ($this->update_info['custom'][$file] as $_file)

{

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

forum_last_poster_colour VARCHAR(6) CHARACTER SET NONE DEFAULT '' NOT NULL,

forum_flags INTEGER DEFAULT 32 NOT NULL,

display_on_index INTEGER DEFAULT 1 NOT NULL,

enable_indexing INTEGER DEFAULT 1 NOT NULL,

enable_icons INTEGER DEFAULT 1 NOT NULL,

ALTER TABLE phpbb_groups ADD PRIMARY KEY (group_id);;

CREATE GENERATOR phpbb_groups_gen;;

SET GENERATOR phpbb_groups_gen TO 0;;

CREATE TABLE phpbb_sessions (

session_id CHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,

session_user_id INTEGER DEFAULT 0 NOT NULL,

session_last_visit INTEGER DEFAULT 0 NOT NULL,

session_start INTEGER DEFAULT 0 NOT NULL,

session_time INTEGER DEFAULT 0 NOT NULL,

CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions(session_time);;

CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions(session_user_id);;

# Table: 'phpbb_sessions_keys'

CREATE TABLE phpbb_sessions_keys (

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

[forum_last_poster_colour] [varchar] (6) DEFAULT ('') NOT NULL ,

[forum_flags] [int] DEFAULT (32) NOT NULL ,

[display_on_index] [int] DEFAULT (1) NOT NULL ,

[enable_indexing] [int] DEFAULT (1) NOT NULL ,

[enable_icons] [int] DEFAULT (1) NOT NULL ,

) ON [PRIMARY]

GO

GO

CREATE TABLE [phpbb_sessions] (

[session_id] [char] (32) DEFAULT ('') NOT NULL ,

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

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

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

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

CREATE INDEX [session_user_id] ON [phpbb_sessions]([session_user_id]) ON [PRIMARY]

GO

/*

Table: 'phpbb_sessions_keys'

forum_last_poster_name blob NOT NULL,

forum_last_poster_colour varbinary(6) DEFAULT '' NOT NULL,

forum_flags tinyint(4) DEFAULT '32' NOT NULL,

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

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

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

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

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

PRIMARY KEY (group_id),

);

CREATE TABLE phpbb_sessions (

session_id binary(32) DEFAULT '' NOT NULL,

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

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

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

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

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

PRIMARY KEY (session_id),

KEY session_time (session_time),

);

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

forum_flags tinyint(4) DEFAULT '32' NOT NULL,

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

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

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

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

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

PRIMARY KEY (group_id),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

CREATE TABLE phpbb_sessions (

session_id char(32) DEFAULT '' NOT NULL,

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

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

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

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

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

PRIMARY KEY (session_id),

KEY session_time (session_time),

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

forum_last_poster_name varchar2(765) DEFAULT '' ,

forum_last_poster_colour varchar2(6) DEFAULT '' ,

forum_flags number(4) DEFAULT '32' NOT NULL,

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

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

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

)

/

/

CREATE SEQUENCE phpbb_groups_seq

CREATE TABLE phpbb_sessions (

session_id char(32) DEFAULT '' ,

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

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

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

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

/

CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id)

/

/*

Table: 'phpbb_sessions_keys'

forum_last_poster_name varchar(255) DEFAULT '' NOT NULL,

forum_last_poster_colour varchar(6) DEFAULT '' NOT NULL,

forum_flags INT2 DEFAULT '32' NOT NULL,

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

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

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

PRIMARY KEY (group_id)

);

/*

Table: 'phpbb_icons'

CREATE TABLE phpbb_sessions (

session_id char(32) DEFAULT '' NOT NULL,

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

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

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

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

CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time);

CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id);

/*

Table: 'phpbb_sessions_keys'

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

INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':(', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 10);

INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':-(', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 11);

INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':sad:', 'icon_e_sad.gif', '{L_SMILIES_SAD}', 15, 17, 12);

INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':?', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 17);

INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':-?', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 18);

INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':???:', 'icon_e_confused.gif', '{L_SMILIES_CONFUSED}', 15, 17, 19);

INSERT INTO phpbb_smilies (code, smiley_url, emotion, smiley_width, smiley_height, smiley_order) VALUES (':geek:', 'icon_e_geek.gif', '{L_SMILIES_GEEK}', 17, 17, 41);

# -- icons

INSERT INTO phpbb_icons (icons_url, icons_width, icons_height, icons_order, display_on_posting) VALUES ('misc/fire.gif', 16, 16, 1, 1);

forum_last_poster_name varchar(255) NOT NULL DEFAULT '',

forum_last_poster_colour varchar(6) NOT NULL DEFAULT '',

forum_flags tinyint(4) NOT NULL DEFAULT '32',

display_on_index INTEGER UNSIGNED NOT NULL DEFAULT '1',

enable_indexing INTEGER UNSIGNED NOT NULL DEFAULT '1',

enable_icons INTEGER UNSIGNED NOT NULL DEFAULT '1',

group_legend INTEGER UNSIGNED NOT NULL DEFAULT '1'

);

# Table: 'phpbb_icons'

CREATE TABLE phpbb_icons (

CREATE TABLE phpbb_sessions (

session_id char(32) NOT NULL DEFAULT '',

session_user_id INTEGER UNSIGNED NOT NULL DEFAULT '0',

session_last_visit INTEGER UNSIGNED NOT NULL DEFAULT '0',

session_start INTEGER UNSIGNED NOT NULL DEFAULT '0',

session_time INTEGER UNSIGNED NOT NULL DEFAULT '0',

CREATE INDEX phpbb_sessions_session_time ON phpbb_sessions (session_time);

CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions (session_user_id);

# Table: 'phpbb_sessions_keys'

CREATE TABLE phpbb_sessions_keys (