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

'avatar_filesize' => 'avatar_filesize',

'avatar_max_width' => 'avatar_max_width',

'avatar_max_height' => 'avatar_max_height',

'board_timezone' => 'board_timezone',

'allow_privmsg' => 'not(privmsg_disable)',

'gzip_compress' => 'gzip_compress',

{

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' ON');

break;

}

case 'mssql':

case 'mssql_odbc':

$db->sql_query('SET IDENTITY_INSERT ' . FORUMS_TABLE . ' OFF');

break;

case 'mssql':

case 'mssql_odbc':

$map_dbms = 'mssql';

break;

*

*/

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

$debug_from_version = false;

{

define('E_DEPRECATED', 8192);

}

error_reporting(E_ALL);

@set_time_limit(0);

set_config('dbms_version', $db->sql_server_info(true));

}

if ($db->sql_layer == 'firebird')

{

// We do not trust any PHP5 function enabled, we will simply test for a function new in 2.1

<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

}

</div>

<div id="page-footer">

</div>

</div>

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

'3.0.7' => array(),

// No changes from 3.0.7-PL1 to 3.0.8-RC1

'3.0.7-PL1' => array(),

);

}

*****************************************************************************/

function change_database_data(&$no_updates, $version)

{

switch ($version)

{

// Changes from 3.0.7-PL1 to 3.0.8-RC1

case '3.0.7-PL1':

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

{

{

}

}

$db->sql_freeresult($result);

_add_modules($modules_to_install);

// add Bing Bot

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

$db->sql_freeresult($result);

{

// end Bing Bot addition

// Delete shadow topics pointing to not existing topics

// Unread posts search load switch

set_config('load_unreads_search', '1');

$no_updates = false;

break;

}

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

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

),

'mssqlnative' => array(

'INT:' => '[int]',

'BINT' => '[float]',

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

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

),

'oracle' => array(

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

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

case 'mssql_odbc':

$this->sql_layer = 'mssql';

break;

case 'mssqlnative':

$this->sql_layer = 'mssqlnative';

break;

}

}

{

define('E_DEPRECATED', 8192);

}

// @todo Review this test and see if we can find out what it is which prevents PHP 4.2.x from even displaying the page with requirements on it

if (version_compare(PHP_VERSION, '4.3.3') < 0)

echo ' </div>';

echo ' </div>';

echo ' <div id="page-footer">';

echo ' </div>';

echo '</div>';

echo '</body>';

if (!$user_id)

{

$this->p_master->db_error('Unable to insert bot into users table', $db->sql_error_sql, __LINE__, __FILE__, true);

continue;

}

}

// Check if the update files are actually meant to update from the current version

{

$this->unequal_version = true;

$template->assign_vars(array(

'S_ERROR' => true,

));

}

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

bbcode_tag varbinary(16) DEFAULT '' NOT NULL,

bbcode_helpline blob NOT NULL,

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

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

bbcode_helpline varchar(255) DEFAULT '' NOT NULL,

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

Table: 'phpbb_bbcodes'

*/

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar2(16) DEFAULT '' ,

bbcode_helpline varchar2(765) DEFAULT '' ,

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

Table: 'phpbb_bbcodes'

*/

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar(16) DEFAULT '' NOT NULL,

bbcode_helpline varchar(255) DEFAULT '' NOT NULL,

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

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

# No Avatar (u_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 9, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'u_%' AND auth_option NOT IN ('u_attach', 'u_chgavatar', 'u_viewonline', 'u_chggrp', 'u_chgname', 'u_ignoreflood', 'u_pm_attach', 'u_pm_emailpm', 'u_pm_flash', 'u_savedrafts', 'u_search', 'u_sendemail', 'u_sendim', 'u_masspm', 'u_masspm_group');

# Full Moderator (m_)

INSERT INTO phpbb_acl_roles_data (role_id, auth_option_id, auth_setting) SELECT 10, auth_option_id, 1 FROM phpbb_acl_options WHERE auth_option LIKE 'm_%';

INSERT INTO phpbb_reports_reasons (reason_title, reason_description, reason_order) VALUES ('other', '{L_REPORT_OTHER}', 4);

# -- extension_groups

# -- extensions

INSERT INTO phpbb_extensions (group_id, extension) VALUES (1, 'gif');

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

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

# Table: 'phpbb_bbcodes'

CREATE TABLE phpbb_bbcodes (

bbcode_tag varchar(16) NOT NULL DEFAULT '',

bbcode_helpline varchar(255) NOT NULL DEFAULT '',

display_on_posting INTEGER UNSIGNED NOT NULL DEFAULT '0',