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

// Already the new user id ;)

$user_id = $convert->row['poster_id'];

$message = str_replace('<', '&lt;', $message);

$message = str_replace('>', '&gt;', $message);

// make the post UTF-8

$message = phpbb_set_encoding($message);

*

*/

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

$debug_from_version = false;

unset($dbpasswd);

$user->ip = (!empty($_SERVER['REMOTE_ADDR'])) ? htmlspecialchars($_SERVER['REMOTE_ADDR']) : '';

$sql = "SELECT config_value

FROM " . CONFIG_TABLE . "

<p><?php echo ((isset($lang['INLINE_UPDATE_SUCCESSFUL'])) ? $lang['INLINE_UPDATE_SUCCESSFUL'] : 'The database update was successful. Now you need to continue the update process.'); ?></p>

<?php

}

FROM ' . MODULES_TABLE . "

WHERE module_class = '" . $db->sql_escape($module_data['class']) . "'

AND parent_id = {$parent_id}

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

$steps = (int) $db->sql_fetchfield('num_modules');

$db->sql_freeresult($result);

'pm_id' => array('pm_id'),

),

POSTS_TABLE => array(

),

),

),

'3.0.7-RC2' => array(),

// No changes from 3.0.7 to 3.0.7-PL1

'3.0.7' => array(),

);

}

// No changes from 3.0.7 to 3.0.7-PL1

case '3.0.7':

break;

}

}

'VARBINARY' => '[varchar] (255)',

),

'oracle' => array(

'INT:' => 'number(%d)',

'BINT' => 'number(20)',

* A list of supported DBMS. We change this class to support more DBMS, the DBMS itself only need to follow some rules.

* @var array

*/

/**

* This is set to true if user only wants to return the 'to-be-executed' SQL statement(s) (as an array).

$this->sql_layer = 'mssql';

break;

default:

$this->sql_layer = $this->db->sql_layer;

break;

* drop_columns: Removing/Dropping columns

* add_primary_keys: adding primary keys

* add_unique_index: adding an unique index

*

* The values are in this format:

* {TABLE NAME} => array(

// same deal with PostgreSQL, we must perform more complex operations than

// we technically could

case 'mssql':

$sql = "SELECT c.name

FROM syscolumns c

LEFT JOIN sysobjects o ON c.id = o.id

*/

function sql_index_exists($table_name, $index_name)

{

{

$sql = "EXEC sp_statistics '$table_name'";

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

*/

function sql_unique_index_exists($table_name, $index_name)

{

{

$sql = "EXEC sp_statistics '$table_name'";

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

break;

case 'mssql':

$sql .= " {$column_type} ";

$sql_default = " {$column_type} ";

break;

case 'mssql':

// Does not support AFTER, only through temporary table

$statements[] = 'ALTER TABLE [' . $table_name . '] ADD [' . $column_name . '] ' . $column_data['column_type_sql_default'];

break;

break;

case 'mssql':

$statements[] = 'ALTER TABLE [' . $table_name . '] DROP COLUMN [' . $column_name . ']';

break;

switch ($this->sql_layer)

{

case 'mssql':

$statements[] = 'DROP INDEX ' . $table_name . '.' . $index_name;

break;

break;

case 'mssql':

$sql = "ALTER TABLE [{$table_name}] WITH NOCHECK ADD ";

$sql .= "CONSTRAINT [PK_{$table_name}] PRIMARY KEY CLUSTERED (";

$sql .= '[' . implode("],\n\t\t[", $column) . ']';

break;

case 'mssql':

$statements[] = 'CREATE UNIQUE INDEX ' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ') ON [PRIMARY]';

break;

}

{

$statements = array();

switch ($this->sql_layer)

{

case 'firebird':

break;

case 'mysql_40':

case 'mysql_41':

$statements[] = 'CREATE INDEX ' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ')';

break;

case 'mssql':

$statements[] = 'CREATE INDEX ' . $index_name . ' ON ' . $table_name . '(' . implode(', ', $column) . ') ON [PRIMARY]';

break;

}

break;

case 'mssql':

$statements[] = 'ALTER TABLE [' . $table_name . '] ALTER COLUMN [' . $column_name . '] ' . $column_data['column_type_sql'];

if (!empty($column_data['default']))

}

}

// Thanks MySQL, for silently converting...

case 'mysql':

case 'mysql4':

{

$convert->mysql_convert = true;

}

$this->p_master->error($user->lang['DEV_NO_TEST_FILE'], __LINE__, __FILE__);

}

{

if (!$local_path)

{

{

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' ON');

break;

}

{

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . $schema['target'] . ' OFF');

break;

$write = $exists = true;

if (file_exists($phpbb_root_path . $dir))

{

{

$write = false;

}

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

{

// Assume it will work ... if nothing goes wrong below

$written = true;

{

case 'mssql':

case 'mssql_odbc':

$sql_query = preg_replace('#\# MSSQL IDENTITY (phpbb_[a-z_]+) (ON|OFF) \##s', 'SET IDENTITY_INSERT \1 \2;', $sql_query);

break;

$current_time = time();

$user_ip = (!empty($_SERVER['REMOTE_ADDR'])) ? htmlspecialchars($_SERVER['REMOTE_ADDR']) : '';

if ($data['script_path'] !== '/')

{

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

SET config_value = 'phpbb_captcha_gd'

WHERE config_name = 'captcha_plugin'";

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

SET config_value = '1'

WHERE config_name = 'captcha_gd'";

'Alta Vista [Bot]' => array('Scooter/', ''),

'Ask Jeeves [Bot]' => array('Ask Jeeves', ''),

'Baidu [Spider]' => array('Baiduspider+(', ''),

'Exabot [Bot]' => array('Exabot/', ''),

'FAST Enterprise [Crawler]' => array('FAST Enterprise Crawler', ''),

'FAST WebCrawler [Crawler]' => array('FAST-WebCrawler/', ''),

function main($mode, $sub)

{

$this->tpl_name = 'install_update';

$this->page_title = 'UPDATE_INSTALLATION';

$user->session_begin();

$auth->acl($user->data);

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

if ($sub == 'intro')

// still, the acp template is never stored in the database

$user->theme['template_storedb'] = false;

// Get current and latest version

if (($latest_version = $cache->get('_version_info')) === false)

{

return;

}

// Check if the update files stored are for the latest version...

if ($this->latest_version != $this->update_info['version']['to'])

{

$template->assign_vars(array(

'S_INTRO' => true,

));

// Make sure the update list is destroyed.

'S_UP_TO_DATE' => $up_to_date,

'S_VERSION_CHECK' => true,

'LATEST_VERSION' => $this->latest_version,

'CURRENT_VERSION' => $this->current_version)

'S_DB_UPDATE' => true,

'S_DB_UPDATE_FINISHED' => ($config['version'] == $this->update_info['version']['to']) ? true : false,

'U_DB_UPDATE' => append_sid($phpbb_root_path . 'install/database_update.' . $phpEx, 'type=1&amp;language=' . $user->data['user_lang']),

));

break;

// Refresh the page if we are still not finished...

if ($update_list['status'] != -1)

{

meta_refresh(2, $refresh_url);

$template->assign_vars(array(

$file_part = $filename;

}

if (isset($file_struct['as_expected']) && $file_struct['as_expected'])

{

'S_FILE_CHECK' => true,

'S_ALL_UP_TO_DATE' => $all_up_to_date,

'S_VERSION_UP_TO_DATE' => $up_to_date,

));

if ($all_up_to_date)

$params[] = 'download=1';

}

meta_refresh(3, $redirect_url);

$template->assign_vars(array(

$template->assign_vars(array(

'S_DOWNLOAD_FILES' => true,

'RADIO_BUTTONS' => $radio_buttons,

'S_HIDDEN_FIELDS' => $s_hidden_fields)

);

'S_FTP_UPLOAD' => true,

'UPLOAD_METHOD' => $method,

'S_HIDDEN_FIELDS' => $s_hidden_fields,

));

$template->assign_vars(array(

'S_UPLOAD_SUCCESS' => true,

);

return;

}

*/

/*

Table: 'phpbb_attachments'

*/

) ON [PRIMARY]

GO

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 ('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 ('load_onlinetrack', '1');

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

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

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

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

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

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('ranks_path', 'images/ranks');

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

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

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

# -- Forums

INSERT INTO phpbb_forums (forum_name, forum_desc, left_id, right_id, parent_id, forum_type, forum_posts, forum_topics, forum_topics_real, forum_last_post_id, forum_last_poster_id, forum_last_poster_name, forum_last_poster_colour, forum_last_post_time, forum_link, forum_password, forum_image, forum_rules, forum_rules_link, forum_rules_uid, forum_desc_uid, prune_days, prune_viewed, forum_parents) VALUES ('{L_FORUMS_FIRST_CATEGORY}', '', 1, 4, 0, 0, 1, 1, 1, 1, 2, 'Admin', 'AA0000', 972086460, '', '', '', '', '', '', '', 0, 0, '');

# -- Users / Anonymous user

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, user_allow_massemail) VALUES (2, 1, 'Anonymous', 'anonymous', 0, '', '', 'en', 1, 0, '', 0, '', '', '', '', '', 't', 'a', 't', 'd', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 0);

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

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