define('UPDATES_TO_VERSION', '3.1.0-dev');

define('DEBUG_FROM_VERSION', false);

define('OLDEST_FROM_VERSION', '3.0.0');

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

{

$updates_to_version = UPDATES_TO_VERSION;

$debug_from_version = DEBUG_FROM_VERSION;

$oldest_from_version = OLDEST_FROM_VERSION;

return;

}

define('IN_PHPBB', true);

define('IN_INSTALL', true);

$phpbb_root_path = (defined('PHPBB_ROOT_PATH')) ? PHPBB_ROOT_PATH : './../';

$phpEx = substr(strrchr(__FILE__, '.'), 1);

if (!function_exists('phpbb_require_updated'))

{

function phpbb_require_updated($path, $optional = false)

}

}

phpbb_require_updated('includes/startup.' . $phpEx);

$updates_to_version = UPDATES_TO_VERSION;

$debug_from_version = DEBUG_FROM_VERSION;

$oldest_from_version = OLDEST_FROM_VERSION;

error_reporting(E_ALL);

@set_time_limit(0);

include($phpbb_root_path . 'config.' . $phpEx);

if (!defined('PHPBB_INSTALLED') || empty($dbms) || empty($acm_type))

{

die("Please read: <a href='../docs/INSTALL.html'>INSTALL.html</a> before attempting to update.");

}

if (!empty($load_extensions) && function_exists('dl'))

{

$load_extensions = explode(',', $load_extensions);

foreach ($load_extensions as $extension)

{

@dl(trim($extension));

}

}

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

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

phpbb_require_updated('includes/functions_content.' . $phpEx, true);

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

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

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

require($phpbb_root_path . 'includes/utf/utf_tools.' . $phpEx);

phpbb_require_updated('includes/db/db_tools.' . $phpEx);

if (!defined('LOGIN_ATTEMPT_TABLE'))

{

define('LOGIN_ATTEMPT_TABLE', $table_prefix . 'login_attempts');

}

if (!defined('EXT_TABLE'))

{

define('EXT_TABLE', $table_prefix . 'ext');

}

$phpbb_class_loader_ext = new phpbb_class_loader('phpbb_ext_', $phpbb_root_path . 'ext/', ".$phpEx");

$phpbb_class_loader_ext->register();

$phpbb_class_loader = new phpbb_class_loader('phpbb_', $phpbb_root_path . 'includes/', ".$phpEx");

$phpbb_class_loader->register();

$cache_factory = new phpbb_cache_factory($acm_type);

$cache = $cache_factory->get_service();

$phpbb_class_loader_ext->set_cache($cache->get_driver());

$phpbb_class_loader->set_cache($cache->get_driver());

$phpbb_dispatcher = new phpbb_event_dispatcher();

$request = new phpbb_request();

$user = new phpbb_user();

$db = new $sql_db();

request_var('', 0, false, false, $request); // "dependency injection" for a function

if (file_exists($phpbb_root_path . 'includes/hooks/index.' . $phpEx))

{

require($phpbb_root_path . 'includes/hooks/index.' . $phpEx);

$phpbb_hook = new phpbb_hook(array('exit_handler', 'phpbb_user_session_handler', 'append_sid', array('template', 'display')));

foreach ($cache->obtain_hooks() as $hook)

{

@include($phpbb_root_path . 'includes/hooks/' . $hook . '.' . $phpEx);

}

}

{

$phpbb_hook = false;

}

$db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false, false);

unset($dbpasswd);

$user->ip = '';

if ($request->server('REMOTE_ADDR'))

{

$user->ip = (function_exists('phpbb_ip_normalise')) ? phpbb_ip_normalise($request->server('REMOTE_ADDR')) : $request->server('REMOTE_ADDR');

}

$sql = "SELECT config_value

FROM " . CONFIG_TABLE . "

WHERE config_name = 'default_lang'";

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

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

$db->sql_freeresult($result);

$language = basename(request_var('language', ''));

if (!$language)

{

$language = $row['config_value'];

}

if (!file_exists($phpbb_root_path . 'language/' . $language))

{

die('No language found!');

}

include($phpbb_root_path . 'language/' . $language . '/common.' . $phpEx);

include($phpbb_root_path . 'language/' . $language . '/acp/common.' . $phpEx);

include($phpbb_root_path . 'language/' . $language . '/install.' . $phpEx);

$inline_update = (request_var('type', 0)) ? true : false;

$config = new phpbb_config_db($db, $cache->get_driver(), CONFIG_TABLE);

set_config(null, null, null, $config);

set_config_count(null, null, null, $config);

if (isset($config['assets_version']))

{

set_config('assets_version', $config['assets_version'] + 1);

}

$db_tools = new phpbb_db_tools($db, true);

$database_update_info = database_update_info();

$error_ary = array();

$errored = false;

$sql = 'SELECT topic_id

FROM ' . TOPICS_TABLE . '

AND topic_type = ' . POST_GLOBAL;

$result = $db->sql_query_limit($sql, 1);

$has_global = (int) $db->sql_fetchfield('topic_id');

$db->sql_freeresult($result);

$ga_forum_id = request_var('ga_forum_id', 0);

if ($has_global && !$ga_forum_id)

{

?>

<!DOCTYPE html>

<html dir="<?php echo $lang['DIRECTION']; ?>" lang="<?php echo $lang['USER_LANG']; ?>">

<head>

<meta charset="utf-8">

<title><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></title>

<link href="../adm/style/admin.css" rel="stylesheet" type="text/css" media="screen" />

</head>

<body>

<div id="wrap">

<div id="page-header">&nbsp;</div>

<div id="page-body">

<div id="acp">

<div class="panel">

<span class="corners-top"><span></span></span>

<div id="content">

<div id="main" class="install-body">

<h1><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></h1>

<br />

<form action="" method="post" id="select_ga_forum_id">

<?php

if (isset($lang['SELECT_FORUM_GA']))

{

// Language string is available:

echo $lang['SELECT_FORUM_GA'];

}

else

{

echo 'In phpBB 3.1 the global announcements are linked to forums. Select a forum for your current global announcements (can be moved later):';

}

?>

<select id="ga_forum_id" name="ga_forum_id"><?php echo make_forum_select(false, false, true, true) ?></select>

<input type="submit" name="post" value="<?php echo $lang['SUBMIT']; ?>" class="button1" />

</form>

<?php

_print_footer();

exit_handler();

}

header('Content-type: text/html; charset=UTF-8');

<!DOCTYPE html>

<html dir="<?php echo $lang['DIRECTION']; ?>" lang="<?php echo $lang['USER_LANG']; ?>">

<head>

<meta charset="utf-8">

<title><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></title>

<link href="../adm/style/admin.css" rel="stylesheet" type="text/css" media="screen" />

</head>

<body>

<div id="wrap">

<div id="page-header">&nbsp;</div>

<div id="page-body">

<div id="acp">

<div class="panel">

<span class="corners-top"><span></span></span>

<div id="content">

<div id="main" class="install-body">

<h1><?php echo $lang['UPDATING_TO_LATEST_STABLE']; ?></h1>

<br />

<p><?php echo $lang['DATABASE_TYPE']; ?> :: <strong><?php echo $db->sql_layer; ?></strong><br />

if ($debug_from_version !== false)

{

$config['version'] = $debug_from_version;

}

echo $lang['PREVIOUS_VERSION'] . ' :: <strong>' . $config['version'] . '</strong><br />';

echo $lang['UPDATED_VERSION'] . ' :: <strong>' . $updates_to_version . '</strong></p>';

$current_version = str_replace('rc', 'RC', strtolower($config['version']));

$latest_version = str_replace('rc', 'RC', strtolower($updates_to_version));

$orig_version = $config['version'];

if (empty($config['dbms_version']))

{

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

$db->sql_return_on_error(true);

$sql = 'SELECT 1 FROM RDB$DATABASE

WHERE BIN_AND(10, 1) = 0';

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

if (!$result || $db->sql_error_triggered)

{

echo '<br /><br />';

echo '<h1>' . $lang['ERROR'] . '</h1><br />';

echo '<p>' . $lang['FIREBIRD_DBMS_UPDATE_REQUIRED'] . '</p>';

_print_footer();

exit_handler();

exit;

}

$db->sql_freeresult($result);

$db->sql_return_on_error(false);

}

if ($db->sql_layer == 'mysql' || $db->sql_layer == 'mysql4' || $db->sql_layer == 'mysqli')

{

// Verify by fetching column... if the column type matches the new type we update dbms_version...

$sql = "SHOW COLUMNS FROM " . CONFIG_TABLE;

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

$column_type = '';

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

{

$field = strtolower($row['Field']);

if ($field == 'config_value')

{

$column_type = strtolower($row['Type']);

break;

}

}

$db->sql_freeresult($result);

// If column type is blob, but mysql version says we are on > 4.1.3, then the schema needs an update

if (strpos($column_type, 'blob') !== false && version_compare($db->sql_server_info(true), '4.1.3', '>='))

{

echo '<br /><br />';

echo '<h1>' . $lang['ERROR'] . '</h1><br />';

echo '<p>' . sprintf($lang['MYSQL_SCHEMA_UPDATE_REQUIRED'], $config['dbms_version'], $db->sql_server_info(true)) . '</p>';

_print_footer();

exit_handler();

exit;

}

}

if (version_compare($current_version, $oldest_from_version, '<'))

{

echo '<br /><br /><h1>' . $lang['ERROR'] . '</h1><br />';

echo '<p>' . sprintf($lang['DB_UPDATE_NOT_SUPPORTED'], $oldest_from_version, $current_version) . '</p>';

_print_footer();

exit_handler();

exit;

}

if ($inline_update)

{

if ($current_version !== $latest_version)

{

set_config('version_update_from', $orig_version);

}

}

{

// If not called from the update script, we will actually remove the traces

$db->sql_query('DELETE FROM ' . CONFIG_TABLE . " WHERE config_name = 'version_update_from'");

}

<br /><br />

<h1><?php echo $lang['UPDATE_DATABASE_SCHEMA']; ?></h1>

<br />

<p><?php echo $lang['PROGRESS']; ?> :: <strong>

flush();

$no_updates = true;

$versions = array_keys($database_update_info);

for ($i = 0; $i < sizeof($versions); $i++)

{

$version = $versions[$i];

$schema_changes = $database_update_info[$version];

$next_version = (isset($versions[$i + 1])) ? $versions[$i + 1] : $updates_to_version;

// If the installed version to be updated to is < than the current version, and if the current version is >= as the version to be updated to next, we will skip the process

if (version_compare($version, $current_version, '<') && version_compare($current_version, $next_version, '>='))

{

continue;

}

if (!sizeof($schema_changes))

{

continue;

}

$no_updates = false;

// We run one index after the other... to be consistent with schema changes...

foreach ($schema_changes as $key => $changes)

{

$statements = $db_tools->perform_schema_changes(array($key => $changes));

foreach ($statements as $sql)

{

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

}

}

}

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

$error_ary = array();

$errored = $no_updates = false;

<br /><br />

<h1><?php echo $lang['UPDATING_DATA']; ?></h1>

<br />

<p><?php echo $lang['PROGRESS']; ?> :: <strong>

flush();

$no_updates = true;

$versions = array_keys($database_update_info);

for ($i = 0; $i < sizeof($versions); $i++)

{

$version = $versions[$i];

$next_version = (isset($versions[$i + 1])) ? $versions[$i + 1] : $updates_to_version;

// If the installed version to be updated to is < than the current version, and if the current version is >= as the version to be updated to next, we will skip the process

if (version_compare($version, $current_version, '<') && version_compare($current_version, $next_version, '>='))

{

continue;

}

change_database_data($no_updates, $version);

}

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

$error_ary = array();

$errored = $no_updates = false;

<br /><br />

<h1><?php echo $lang['UPDATE_VERSION_OPTIMIZE']; ?></h1>

<br />

<p><?php echo $lang['PROGRESS']; ?> :: <strong>

flush();

if ($debug_from_version === false)

{

// update the version

$sql = "UPDATE " . CONFIG_TABLE . "

WHERE config_name = 'version'";

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

}

$sql = 'UPDATE ' . USERS_TABLE . "

user_perm_from = 0";

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

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

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

<br />

<h1><?php echo $lang['UPDATE_COMPLETED']; ?></h1>

<br />

if (!$inline_update)

{

<p style="color:red"><?php echo $lang['UPDATE_FILES_NOTICE']; ?></p>

<p><?php echo $lang['COMPLETE_LOGIN_TO_BOARD']; ?></p>

}

{

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

<p><a href="<?php echo append_sid("{$phpbb_root_path}install/index.{$phpEx}", "mode=update&amp;sub=file_check&amp;language=$language"); ?>" class="button1"><?php echo (isset($lang['CONTINUE_UPDATE_NOW'])) ? $lang['CONTINUE_UPDATE_NOW'] : 'Continue the update process now'; ?></a></p>

}

add_log('admin', 'LOG_UPDATE_DATABASE', $orig_version, $updates_to_version);

$cache->purge();

_print_footer();

garbage_collection();

if (function_exists('exit_handler'))

{

exit_handler();

}

function _print_footer()

}

function _sql($sql, &$errored, &$error_ary, $echo_dot = true)

}

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

}

function _add_modules($modules_to_install)

}

function database_update_info()