*

*/

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

{

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

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

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

$cache = new cache();

$db = new $sql_db();

$database_update_info = array(

// Changes within this version

'3.0.b3' => array(

// Change the following columns...

'change_columns' => array(

),

),

// Add the following columns

'add_columns' => array(

),

),

),

// Latest version

);

// Determine mapping database type

flush();

{

}

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

flush();

$sql = "UPDATE " . CONFIG_TABLE . "

SET config_value = '$updates_to_version'

WHERE config_name = 'version'";

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

// this should be done for each version in future along with

// the version number update

switch ($db->sql_layer)

</div>

<div id="page-footer">

</div>

</div>

{

global $db;

$db->sql_return_on_error(true);

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

}

/**

*/

function prepare_column_data($dbms, $column_data)

{

$sql .= " {$column_type} ";

// For hexadecimal values do not use single quotes

{

$sql .= (strpos($column_data[1], '0x') === 0) ? "DEFAULT {$column_data[1]} " : "DEFAULT '{$column_data[1]}' ";

}

break;

case 'oracle':

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

break;

}

else

{

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

}

break;

function sql_column_change($dbms, $table_name, $column_name, $column_data)

{

global $dbms_type_map, $db;

$column_data = prepare_column_data($dbms, $column_data);

}

}

?> \ No newline at end of file

$module = $this->filename;

if (!class_exists($module))

{

}

$this->module = new $module($this);

/**

*/

{

// Someone has tried to access the file direct. This is not a good idea, so exit

exit;

'BODY' => $lang['REQUIREMENTS_EXPLAIN'],

));

// Test for basic PHP settings

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

'S_LEGEND' => false,

));

// Test for available database modules

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

'S_LEGEND' => true,

$passed['files'] = true;

foreach ($directories as $dir)

{

if (file_exists($phpbb_root_path . $dir) && is_dir($phpbb_root_path . $dir))

{

if (!is_writeable($phpbb_root_path . $dir))

{

}

}

{

}

$passed['files'] = ($exists && $write && $passed['files']) ? true : false;

// And finally where do we want to go next (well today is taken isn't it :P)

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

$template->assign_vars(array(

$default_lang = ($default_lang !== '') ? $default_lang : $language;

if (isset($_POST['check']))

{

$error = array();

// Check the entered email address and password

{

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

}

$config_data .= "\$load_extensions = '$load_extensions';\n\n";

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

$config_data .= "@define('DEBUG', true);\n"; // @todo Comment out when final

$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 (is_dir($path) && !is_link($path) && file_exists($path . '/iso.txt'))

{

$lang_pack = file("{$phpbb_root_path}language/$path/iso.txt");

$sql_ary = array(

'lang_iso' => basename($path),

'lang_dir' => basename($path),

'lang_english_name' => trim(htmlspecialchars($lang_pack[0])),

);

$db->sql_query('INSERT INTO ' . LANG_TABLE . ' ' . $db->sql_build_array('INSERT', $sql_ary));

}

break;

if (version_compare(sqlite_libversion(), '2.8.2', '<'))

{

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

/**

* A list of the web-crawlers/bots we recognise by default

*/

var $bot_list = array(

);

/**

var $latest_version;

var $current_version;

function install_update(&$p_master)

{

$this->p_master = &$p_master;

include_once($phpbb_root_path . 'includes/diff/diff.' . $phpEx);

if (!$user->data['is_registered'])

{

login_box('', $user->lang['LOGIN_UPDATE_EXPLAIN']);

{

trigger_error($user->lang['NO_AUTH_UPDATE']);

}

// If we are within the intro page we need to make sure we get up-to-date version info

if ($sub == 'intro')

return;

}

// Make sure we stay at the file check if checking the files again

if (!empty($_POST['check_again']))

{

$status = request_var('status', '');

$file = request_var('file', '');

// First of all make sure the file is within our file update list with the correct status

$found_entry = array();

if (empty($found_entry))

{

}

// If the status is 'up_to_date' then we do not need to show a diff

return $update_list;

}

// not modified?

foreach ($this->update_info['files'] as $index => $file)

// If the file is not modified we are finished here...

if ($diff->is_empty())

{

$update_list['not_modified'][] = $update_ary;

return;

}

$info = explode("\n", $info);

$info = trim($info[0]);

}

break;

case 'update_info':

if ($info !== false)

{

$info['custom'] = array();

$sql = 'SELECT template_name, template_path

FROM ' . STYLES_TEMPLATE_TABLE . "

WHERE template_name NOT IN ('subSilver', 'BLABLA')";

}

}

}

}

break;

CREATE TABLE phpbb_bbcodes (

bbcode_id INTEGER DEFAULT 0 NOT NULL,

bbcode_tag VARCHAR(16) CHARACTER SET NONE DEFAULT '' NOT NULL,

display_on_posting INTEGER DEFAULT 0 NOT NULL,

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

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

# Table: 'phpbb_config'

CREATE TABLE phpbb_config (

config_name VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

is_dynamic INTEGER DEFAULT 0 NOT NULL

);;

CREATE TABLE phpbb_groups (

group_id INTEGER NOT NULL,

group_type INTEGER DEFAULT 1 NOT NULL,

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

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

group_desc_bitfield VARCHAR(255) CHARACTER SET NONE DEFAULT '' NOT NULL,

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

user_password VARCHAR(40) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_passchg INTEGER DEFAULT 0 NOT NULL,

user_email VARCHAR(100) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

user_email_hash DOUBLE PRECISION DEFAULT 0 NOT NULL,

user_birthday VARCHAR(10) CHARACTER SET NONE DEFAULT '' NOT NULL,

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

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

user_website VARCHAR(200) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE,

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

user_actkey VARCHAR(32) CHARACTER SET NONE DEFAULT '' NOT NULL,

user_newpasswd VARCHAR(32) CHARACTER SET UTF8 DEFAULT '' NOT NULL COLLATE UNICODE

CREATE TABLE [phpbb_groups] (

[group_id] [int] IDENTITY (1, 1) NOT NULL ,

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

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

[group_desc] [varchar] (4000) DEFAULT ('') NOT NULL ,

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

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

[user_password] [varchar] (40) DEFAULT ('') NOT NULL ,

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

[user_email] [varchar] (100) DEFAULT ('') NOT NULL ,

[user_email_hash] [float] DEFAULT (0) NOT NULL ,

[user_birthday] [varchar] (10) DEFAULT ('') NOT NULL ,

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

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

[user_website] [varchar] (200) DEFAULT ('') NOT NULL ,

[user_interests] [varchar] (4000) DEFAULT ('') NOT NULL ,

[user_actkey] [varchar] (32) DEFAULT ('') NOT NULL ,

[user_newpasswd] [varchar] (32) DEFAULT ('') NOT NULL

CREATE TABLE phpbb_bbcodes (

bbcode_id tinyint(3) DEFAULT '0' NOT NULL,

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

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

bbcode_match text NOT NULL,

bbcode_tpl mediumtext NOT NULL,

# Table: 'phpbb_config'

CREATE TABLE phpbb_config (

config_name varchar(255) DEFAULT '' NOT NULL,

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

PRIMARY KEY (config_name),

KEY is_dynamic (is_dynamic)

CREATE TABLE phpbb_groups (

group_id mediumint(8) UNSIGNED NOT NULL auto_increment,

group_type tinyint(4) DEFAULT '1' NOT NULL,

group_name text NOT NULL,

group_desc text NOT NULL,

group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

username_clean text NOT NULL,

user_password varchar(120) DEFAULT '' NOT NULL,

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

user_email text NOT NULL,

user_email_hash bigint(20) DEFAULT '0' NOT NULL,

user_birthday varchar(10) DEFAULT '' NOT NULL,

CREATE TABLE phpbb_groups (

group_id mediumint(8) UNSIGNED NOT NULL auto_increment,

group_type tinyint(4) DEFAULT '1' NOT NULL,

group_name varchar(255) DEFAULT '' NOT NULL,

group_desc text NOT NULL,

group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

username_clean varchar(255) DEFAULT '' NOT NULL,

user_password varchar(40) DEFAULT '' NOT NULL,

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

user_email varchar(100) DEFAULT '' NOT NULL,

user_email_hash bigint(20) DEFAULT '0' NOT NULL,

user_birthday varchar(10) DEFAULT '' NOT NULL,

user_msnm varchar(255) DEFAULT '' NOT NULL,

user_jabber varchar(255) DEFAULT '' NOT NULL,

user_website varchar(200) DEFAULT '' NOT NULL,

user_interests text NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(32) DEFAULT '' NOT NULL,

CREATE TABLE phpbb_bbcodes (

bbcode_id number(3) DEFAULT '0' NOT NULL,

bbcode_tag varchar2(16) DEFAULT '' ,

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

bbcode_match clob DEFAULT '' ,

bbcode_tpl clob DEFAULT '' ,

*/

CREATE TABLE phpbb_config (

config_name varchar2(255) DEFAULT '' ,

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

CONSTRAINT pk_phpbb_config PRIMARY KEY (config_name)

)

CREATE TABLE phpbb_groups (

group_id number(8) NOT NULL,

group_type number(4) DEFAULT '1' NOT NULL,

group_name varchar2(255) DEFAULT '' ,

group_desc clob DEFAULT '' ,

group_desc_bitfield varchar2(255) DEFAULT '' ,

username_clean varchar2(255) DEFAULT '' ,

user_password varchar2(120) DEFAULT '' ,

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

user_email varchar2(300) DEFAULT '' ,

user_email_hash number(20) DEFAULT '0' NOT NULL,

user_birthday varchar2(10) DEFAULT '' ,

user_msnm varchar2(765) DEFAULT '' ,

user_jabber varchar2(765) DEFAULT '' ,

user_website varchar2(600) DEFAULT '' ,

user_interests clob DEFAULT '' ,

user_actkey varchar2(32) DEFAULT '' ,

user_newpasswd varchar2(96) DEFAULT '' ,

CREATE TABLE phpbb_groups (

group_id INT4 DEFAULT nextval('phpbb_groups_seq'),

group_type INT2 DEFAULT '1' NOT NULL,

group_name varchar_ci DEFAULT '' NOT NULL,

group_desc varchar(4000) DEFAULT '' NOT NULL,

group_desc_bitfield varchar(255) DEFAULT '' NOT NULL,

username_clean varchar_ci DEFAULT '' NOT NULL,

user_password varchar(40) DEFAULT '' NOT NULL,

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

user_email varchar(100) DEFAULT '' NOT NULL,

user_email_hash INT8 DEFAULT '0' NOT NULL,

user_birthday varchar(10) DEFAULT '' NOT NULL,

user_msnm varchar(255) DEFAULT '' NOT NULL,

user_jabber varchar(255) DEFAULT '' NOT NULL,

user_website varchar(200) DEFAULT '' NOT NULL,

user_interests varchar(4000) DEFAULT '' NOT NULL,

user_actkey varchar(32) DEFAULT '' NOT NULL,

user_newpasswd varchar(32) DEFAULT '' 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');

INSERT INTO phpbb_users (user_type, group_id, username, username_clean, user_regdate, user_password, user_email, user_lang, user_style, user_rank, user_colour, user_posts, user_permissions, user_ip, user_birthday, user_lastpage, user_last_confirm_key, user_post_sortby_type, user_post_sortby_dir, user_topic_sortby_type, user_topic_sortby_dir, user_avatar, user_sig, user_sig_bbcode_uid, user_from, user_icq, user_aim, user_yim, user_msnm, user_jabber, user_website, user_occ, user_interests, user_actkey, user_newpasswd) VALUES (3, 5, 'Admin', 'admin', 0, '21232f297a57a5a743894a0e4a801fc3', 'admin@yourdomain.com', 'en', 1, 1, 'AA0000', 1, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

# -- Groups

# -- User -> Group

INSERT INTO phpbb_user_group (group_id, user_id, user_pending, group_leader) VALUES (1, 1, 0, 0);

CREATE TABLE phpbb_groups (

group_id INTEGER PRIMARY KEY NOT NULL ,

group_type tinyint(4) NOT NULL DEFAULT '1',

group_name varchar(255) NOT NULL DEFAULT '',

group_desc text(65535) NOT NULL DEFAULT '',

group_desc_bitfield varchar(255) NOT NULL DEFAULT '',

username_clean varchar(255) NOT NULL DEFAULT '',

user_password varchar(40) NOT NULL DEFAULT '',

user_passchg INTEGER UNSIGNED NOT NULL DEFAULT '0',

user_email varchar(100) NOT NULL DEFAULT '',

user_email_hash bigint(20) NOT NULL DEFAULT '0',

user_birthday varchar(10) NOT NULL DEFAULT '',

user_msnm varchar(255) NOT NULL DEFAULT '',

user_jabber varchar(255) NOT NULL DEFAULT '',

user_website varchar(200) NOT NULL DEFAULT '',

user_interests text(65535) NOT NULL DEFAULT '',

user_actkey varchar(32) NOT NULL DEFAULT '',

user_newpasswd varchar(32) NOT NULL DEFAULT ''