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

*

* 'table_format' can take the value 'file' to indicate a config file. In this case array_name

* is set to indicate the name of the array the config values are stored in

* 'table_format' can be an array if the values are stored in a table which is an assosciative array

* (as per phpBB 2.0.x)

* If left empty, values are assumed to be stored in a table where each config setting is

*

*/

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

$debug_from_version = false;

),

),

),

// No changes from 3.0.6-RC2 to 3.0.6-RC3

'3.0.6-RC2' => array(),

// No changes from 3.0.6-RC3 to 3.0.6-RC4

'3.0.6-RC3' => array(),

// No changes from 3.0.6-RC4 to 3.0.6

'3.0.6-RC4' => array(),

);

}

// No changes from 3.0.6-RC4 to 3.0.6

case '3.0.6-RC4':

break;

}

}

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

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

case 'mssql_odbc':

$this->sql_layer = 'mssql';

break;

default:

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

// 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;

case 'postgres':

// Does not support AFTER, only through temporary table

break;

case 'sqlite':

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;

}

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

{

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;

{

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;

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

// Make sure the update list is destroyed.

$cache->destroy('_update_list');

$cache->destroy('_diff_files');

break;

case 'version_check':

case 'file_check':

$cache->destroy('_diff_files');

$this->page_title = 'STAGE_FILE_CHECK';

if ($get_new_list)

{

$cache->put('_update_list', $update_list);

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

);

}

// Now assign the list to the template

foreach ($update_list as $status => $filelist)

{

$diff_url = append_sid($this->p_master->module_url, "mode=$mode&amp;sub=file_check&amp;action=diff&amp;status=$status&amp;file=" . urlencode($file_struct['filename']));

}

}

$all_up_to_date = true;

foreach ($update_list as $status => $filelist)

{

// Before we do anything, let us diff the files and store the raw file information "somewhere"

$get_files = false;

$file_list = $cache->get('_diff_files');

if ($file_list === false || $file_list['status'] != -1)

{

);

}

$processed = 0;

foreach ($update_list as $status => $files)

{

// Skip this file if the user selected to not update it

if (in_array($file_struct['filename'], $no_update))

{

continue;

}

return;

}

$original_filename = ($file_struct['custom']) ? $file_struct['original'] : $file_struct['filename'];

switch ($status)

break;

}

$file_list[$file_struct['filename']] = '_file_' . md5($file_struct['filename']);

$cache->put($file_list[$file_struct['filename']], base64_encode($contents));

break;

}

$file_list[$file_struct['filename']] = '_file_' . md5($file_struct['filename']);

$cache->put($file_list[$file_struct['filename']], base64_encode($contents));

}

}

}

}

$file_list['status'] = -1;

/**

* Collect all file status infos we need for the update by diffing all files

*/

{

global $phpbb_root_path, $phpEx, $user;

else

{

// not modified?

}

$num_bytes_processed += (file_exists($this->new_location . $file)) ? filesize($this->new_location . $file) : 100 * 1024;

/**

* Compare files for storage in update_list

*/

{

global $phpbb_root_path, $user;

if ($custom)

{

$update_ary['original'] = $original_file;

}

// we only want to know if the files are successfully merged and newlines could result in errors (duplicate addition of lines and such things)

// Therefore we check for empty diffs with two methods, preserving newlines and not preserving them (which mostly works best, therefore the first option)

{

$tmp = array(

'file1' => file_get_contents($this->new_location . $original_file),

);

// We need to diff the contents here to make sure the file is really the one we expect

{

$tmp = array(

'file1' => file_get_contents($this->old_location . $original_file),

);

// We need to diff the contents here to make sure the file is really the one we expect

$tmp = array(

'file1' => file_get_contents($this->new_location . $original_file),

);

$diff = new diff($tmp['file1'], $tmp['file2'], $preserve_cr);

ALTER TABLE phpbb_topics_track ADD PRIMARY KEY (user_id, topic_id);;

CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track(forum_id);;

# Table: 'phpbb_topics_posted'

*/

/*

Table: 'phpbb_attachments'

*/

) ON [PRIMARY]

GO

CREATE INDEX [forum_id] ON [phpbb_topics_track]([forum_id]) ON [PRIMARY]

GO

) ON [PRIMARY]

GO

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

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

PRIMARY KEY (user_id, topic_id),

KEY forum_id (forum_id)

);

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

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

PRIMARY KEY (user_id, topic_id),

KEY forum_id (forum_id)

) CHARACTER SET `utf8` COLLATE `utf8_bin`;

)

/

CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id)

/

PRIMARY KEY (user_id, topic_id)

);

CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id);

/*

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 ('feed_enable', '0');

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

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

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

INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval', '15');

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

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

PRIMARY KEY (user_id, topic_id)

);

CREATE INDEX phpbb_topics_track_forum_id ON phpbb_topics_track (forum_id);

# Table: 'phpbb_topics_posted'