-<!-- INCLUDE install_header.html -->

-<!-- INCLUDE install_footer.html --> \ No newline at end of file

-<!-- INCLUDE install_header.html -->

-<!-- INCLUDE install_footer.html --> \ No newline at end of file

-<!-- INCLUDE install_header.html -->

-<!-- INCLUDE install_footer.html --> \ No newline at end of file

-<!-- INCLUDE install_header.html -->

-<!-- INCLUDE install_footer.html -->

-* Returns an array of available DBMS with some data, if a DBMS is specified it will only

-* return data for that DBMS and will load its extension if necessary.

-function get_available_dbms($dbms = false, $return_unavailable = false, $only_20x_options = false)

- global $lang;

- 'SCHEMA' => 'firebird',

- 'DELIM' => ';;',

- 'COMMENTS' => 'remove_remarks',

- 'DRIVER' => 'firebird',

- '2.0.x' => false,

- 'SCHEMA' => 'mysql',

- 'DELIM' => ';',

- 'COMMENTS' => 'remove_remarks',

- '2.0.x' => true,

- 'SCHEMA' => 'mysql',

- 'DELIM' => ';',

- 'COMMENTS' => 'remove_remarks',

- 'DRIVER' => 'mysql',

- '2.0.x' => true,

- 'SCHEMA' => 'mssql',

- 'DELIM' => 'GO',

- 'COMMENTS' => 'remove_comments',

- 'DRIVER' => 'mssql',

- '2.0.x' => true,

- 'SCHEMA' => 'mssql',

- 'DELIM' => 'GO',

- 'COMMENTS' => 'remove_comments',

- 'DRIVER' => 'mssql_odbc',

- '2.0.x' => true,

- 'SCHEMA' => 'mssql',

- 'DELIM' => 'GO',

- 'COMMENTS' => 'remove_comments',

- 'DRIVER' => 'mssql_2005',

- '2.0.x' => true,

- 'SCHEMA' => 'db2',

- 'DELIM' => ';',

- 'COMMENTS' => 'remove_comments',

- 'DRIVER' => 'db2',

- '2.0.x' => false,

- 'SCHEMA' => 'oracle',

- 'DELIM' => '/',

- 'COMMENTS' => 'remove_comments',

- 'DRIVER' => 'oracle',

- '2.0.x' => false,

- 'SCHEMA' => 'postgres',

- 'DELIM' => ';',

- 'COMMENTS' => 'remove_comments',

- 'DRIVER' => 'postgres',

- '2.0.x' => true,

- 'SCHEMA' => 'sqlite',

- 'DELIM' => ';',

- 'COMMENTS' => 'remove_remarks',

- 'DRIVER' => 'sqlite',

- '2.0.x' => false,

- if ($only_20x_options && !$db_ary['2.0.x'])

-function dbms_select($default = '', $only_20x_options = false)

- global $lang;

- $available_dbms = get_available_dbms(false, false, $only_20x_options);

- $dbms_options .= '<option value="' . $dbms_name . '"' . $selected .'>' . $lang['DLL_' . strtoupper($dbms_name)] . '</option>';

-function connect_check_db($error_connect, &$error, $dbms_details, $table_prefix, $dbhost, $dbuser, $dbpasswd, $dbname, $dbport, $prefix_may_exist = false, $load_dbal = true, $unicode_check = true)

- global $lang;

-

- if ($load_dbal)

- {

- // Include the DB layer

- include(PHPBB_ROOT_PATH . 'includes/db/' . $dbms . '.' . PHP_EXT);

- }

- // Instantiate it and set return on error true

- $sql_db = 'dbal_' . $dbms;

- $db = new $sql_db();

- $error[] = $lang['INST_ERR_DB_NO_NAME'];

- if ($dbms_details['DRIVER'] == 'sqlite' && stripos(phpbb_realpath($dbhost), phpbb_realpath('../')) === 0)

- $error[] = $lang['INST_ERR_DB_FORUM_PATH'];

- $error[] = $lang['INST_ERR_PREFIX_INVALID'];

- $error[] = sprintf($lang['INST_ERR_PREFIX_TOO_LONG'], $prefix_length);

- $error[] = $lang['INST_ERR_DB_CONNECT'] . '<br />' . (($db_error['message']) ? $db_error['message'] : $lang['INST_ERR_DB_NO_ERROR']);

- $error[] = $lang['INST_ERR_PREFIX'];

- if (version_compare(mysql_get_server_info($db->db_connect_id), '4.1.3', '<'))

- $error[] = $lang['INST_ERR_DB_NO_MYSQL'];

- if (version_compare(mysqli_get_server_info($db->db_connect_id), '4.1.3', '<'))

- $error[] = $lang['INST_ERR_DB_NO_MYSQLI'];

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

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

- $error[] = $lang['INST_ERR_DB_NO_FIREBIRD'];

- $error[] = $lang['INST_ERR_DB_NO_FIREBIRD_PS'];

- $error[] = $lang['INST_ERR_DB_NO_FIREBIRD'];

- $error[] = $lang['INST_ERR_DB_NO_FIREBIRD'];

- $error[] = $lang['INST_ERR_DB_NO_FIREBIRD_PS'];

- $error[] = $lang['INST_ERR_DB_NO_ORACLE'];

- $error[] = $lang['INST_ERR_DB_NO_ORACLE_NLS'];

- $error[] = $lang['INST_ERR_DB_NO_POSTGRES'];

-/**

-* remove_remarks will strip the sql comment lines out of an uploaded sql file

-*/

-function remove_remarks(&$sql)

-{

- $sql = preg_replace('/\n{2,}/', "\n", preg_replace('/^#.*$/m', "\n", $sql));

-}

-

-/**

-* split_sql_file will split an uploaded sql file into single sql statements.

-* Note: expects trim() to have already been run on $sql.

-*/

-function split_sql_file($sql, $delimiter)

-{

- $sql = str_replace("\r" , '', $sql);

- $data = preg_split('/' . preg_quote($delimiter, '/') . '$/m', $sql);

-

- $data = array_map('trim', $data);

-

- // The empty case

- $end_data = end($data);

-

- if (empty($end_data))

- {

- unset($data[key($data)]);

- }

-

- return $data;

-}

-

-/**

-* For replacing {L_*} strings with preg_replace_callback

-*/

-function adjust_language_keys_callback($matches)

-{

- if (!empty($matches[1]))

- {

- global $lang, $db;

-

- return (!empty($lang[$matches[1]])) ? $db->sql_escape($lang[$matches[1]]) : $db->sql_escape($matches[1]);

- }

-}

-

-// Report all errors, except notices

-error_reporting(E_ALL ^ E_NOTICE);

-// @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, '5.2.0') < 0)

-{

- die('You are running an unsupported PHP version. Please upgrade to PHP 5.2.0 or higher before trying to install phpBB 3.0');

-}

-

-/*

-* Remove variables created by register_globals from the global scope

-* Thanks to Matt Kavanagh

-*/

-function deregister_globals()

-{

- $not_unset = array(

- 'GLOBALS' => true,

- '_GET' => true,

- '_POST' => true,

- '_COOKIE' => true,

- '_REQUEST' => true,

- '_SERVER' => true,

- '_SESSION' => true,

- '_ENV' => true,

- '_FILES' => true,

- 'phpEx' => true,

- 'phpbb_root_path' => true

- );

-

- // Not only will array_merge and array_keys give a warning if

- // a parameter is not an array, array_merge will actually fail.

- // So we check if _SESSION has been initialised.

- if (!isset($_SESSION) || !is_array($_SESSION))

- {

- $_SESSION = array();

- }

-

- // Merge all into one extremely huge array; unset this later

- $input = array_merge(

- array_keys($_GET),

- array_keys($_POST),

- array_keys($_COOKIE),

- array_keys($_SERVER),

- array_keys($_SESSION),

- array_keys($_ENV),

- array_keys($_FILES)

- );

-

- foreach ($input as $varname)

- {

- if (isset($not_unset[$varname]))

- {

- // Hacking attempt. No point in continuing unless it's a COOKIE

- if ($varname !== 'GLOBALS' || isset($_GET['GLOBALS']) || isset($_POST['GLOBALS']) || isset($_SERVER['GLOBALS']) || isset($_SESSION['GLOBALS']) || isset($_ENV['GLOBALS']) || isset($_FILES['GLOBALS']))

- {

- exit;

- }

- else

- {

- $cookie = &$_COOKIE;

- while (isset($cookie['GLOBALS']))

- {

- foreach ($cookie['GLOBALS'] as $registered_var => $value)

- {

- if (!isset($not_unset[$registered_var]))

- {

- unset($GLOBALS[$registered_var]);

- }

- }

- $cookie = &$cookie['GLOBALS'];

- }

- }

- }

-

- unset($GLOBALS[$varname]);

- }

-

- unset($input);

-}

-// If we are on PHP >= 6.0.0 we do not need some code

-if (version_compare(PHP_VERSION, '6.0.0-dev', '>='))

-{

- /**

- * @ignore

- */

- define('STRIP', false);

-}

-else

-{

- @set_magic_quotes_runtime(0);

-

- // Be paranoid with passed vars

- if (@ini_get('register_globals') == '1' || strtolower(@ini_get('register_globals')) == 'on')

- {

- deregister_globals();

- }

-

- define('STRIP', (get_magic_quotes_gpc()) ? true : false);

-}

-

-// Try to override some limits - maybe it helps some...

-// Include essential scripts

-require(PHPBB_ROOT_PATH . 'includes/functions.' . PHP_EXT);

-

-if (file_exists(PHPBB_ROOT_PATH . 'includes/functions_content.' . PHP_EXT))

-{

- require(PHPBB_ROOT_PATH . 'includes/functions_content.' . PHP_EXT);

-}

-

-include(PHPBB_ROOT_PATH . 'includes/auth.' . PHP_EXT);

-include(PHPBB_ROOT_PATH . 'includes/session.' . PHP_EXT);

-include(PHPBB_ROOT_PATH . 'includes/template.' . PHP_EXT);

-include(PHPBB_ROOT_PATH . 'includes/acm/acm_file.' . PHP_EXT);

-include(PHPBB_ROOT_PATH . 'includes/cache.' . PHP_EXT);

-include(PHPBB_ROOT_PATH . 'includes/functions_admin.' . PHP_EXT);

-include(PHPBB_ROOT_PATH . 'includes/utf/utf_tools.' . PHP_EXT);

-require(PHPBB_ROOT_PATH . 'includes/functions_install.' . PHP_EXT);

-

-// Try and load an appropriate language if required

-// usually we would need every single constant here - and it would be consistent. For 3.0.x, use a dirty hack... :(

-$user = new user();

-$auth = new auth();

-$template = new template();

-

-// Set some standard variables we want to force

-phpbb::$config['load_tplcompile'] = '1';

-

-$template->set_custom_template('../adm/style', 'admin');

-$template->assign_var('T_TEMPLATE_PATH', '../adm/style');

-$template->set_filenames(array(

- global $db;

-

- global $template, $lang, $stage;

- $template->assign_vars(array(

- 'L_CHANGE' => $lang['CHANGE'],

- 'L_INSTALL_PANEL' => $lang['INSTALL_PANEL'],

- 'L_SELECT_LANG' => $lang['SELECT_LANG'],

- 'L_SKIP' => $lang['SKIP'],

- 'S_CONTENT_DIRECTION' => $lang['DIRECTION'],

- 'S_CONTENT_FLOW_BEGIN' => ($lang['DIRECTION'] == 'ltr') ? 'left' : 'right',

- 'S_CONTENT_FLOW_END' => ($lang['DIRECTION'] == 'ltr') ? 'right' : 'left',

- 'S_USER_LANG' => $lang['USER_LANG'],

- global $db, $template;

-

- $template->display('body');

- if (!empty($db) && is_object($db))

- $db->sql_close();

- global $lang;

-

- return (isset($lang[$this->module->page_title])) ? $lang[$this->module->page_title] : $this->module->page_title;

- }

-

- /**

- * Generate an HTTP/1.1 header to redirect the user to another page

- * This is used during the installation when we do not have a database available to call the normal redirect function

- * @param string $page The page to redirect to relative to the installer root path

- */

- function redirect($page)

- {

- // HTTP_HOST is having the correct browser url in most cases...

- $server_name = (!empty($_SERVER['HTTP_HOST'])) ? strtolower($_SERVER['HTTP_HOST']) : ((!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME'));

- $server_port = (!empty($_SERVER['SERVER_PORT'])) ? (int) $_SERVER['SERVER_PORT'] : (int) getenv('SERVER_PORT');

- $secure = (isset($_SERVER['HTTPS']) && $_SERVER['HTTPS'] == 'on') ? 1 : 0;

-

- $script_name = (!empty($_SERVER['PHP_SELF'])) ? $_SERVER['PHP_SELF'] : getenv('PHP_SELF');

- if (!$script_name)

- {

- $script_name = (!empty($_SERVER['REQUEST_URI'])) ? $_SERVER['REQUEST_URI'] : getenv('REQUEST_URI');

- }

-

- // Replace backslashes and doubled slashes (could happen on some proxy setups)

- $script_name = str_replace(array('\\', '//'), '/', $script_name);

- $script_path = trim(dirname($script_name));

-

- $url = (($secure) ? 'https://' : 'http://') . $server_name;

-

- if ($server_port && (($secure && $server_port <> 443) || (!$secure && $server_port <> 80)))

- {

- // HTTP HOST can carry a port number...

- if (strpos($server_name, ':') === false)

- {

- $url .= ':' . $server_port;

- }

- }

-

- $url .= $script_path . '/' . $page;

- header('Location: ' . $url);

- exit;

- global $lang, $template, $language;

-

- $url = $this->module_url . "?mode=$cat&amp;language=$language";

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

- $l_option = (!empty($lang['SUB_' . $option])) ? $lang['SUB_' . $option] : preg_replace('#_#', ' ', $option);

- $url = $this->module_url . '?mode=' . $this->mode . "&amp;sub=$option&amp;language=$language";

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

- $l_option = (!empty($lang['STAGE_' . $option])) ? $lang['STAGE_' . $option] : preg_replace('#_#', ' ', $option);

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

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

- function error($error, $line, $file, $skip = false)

- global $lang, $db, $template;

-

- if ($skip)

- {

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

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['INST_ERR'],

- ));

-

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

- 'TITLE' => basename($file) . ' [ ' . $line . ' ]',

- 'RESULT' => '<b style="color:red">' . $error . '</b>',

- ));

-

- return;

- }

- echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';

- echo '<html xmlns="http://www.w3.org/1999/xhtml" dir="ltr">';

- echo '<head>';

- echo '<meta http-equiv="content-type" content="text/html; charset=utf-8" />';

- echo '<title>' . $lang['INST_ERR_FATAL'] . '</title>';

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

- echo '</head>';

- echo '<body id="errorpage">';

- echo '<div id="wrap">';

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

- echo ' </div>';

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

- echo ' <div id="acp">';

- echo ' <div class="panel">';

- echo ' <span class="corners-top"><span></span></span>';

- echo ' <div id="content">';

- echo ' <h1>' . $lang['INST_ERR_FATAL'] . '</h1>';

- echo ' <p>' . $lang['INST_ERR_FATAL'] . "</p>\n";

- echo ' <p>' . basename($file) . ' [ ' . $line . " ]</p>\n";

- echo ' <p><b>' . $error . "</b></p>\n";

- echo ' </div>';

- echo ' <span class="corners-bottom"><span></span></span>';

- echo ' </div>';

- echo ' </div>';

- echo ' </div>';

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

- echo ' Powered by phpBB &copy; 2000, 2002, 2005, 2007 <a href="http://www.phpbb.com/">phpBB Group</a>';

- echo ' </div>';

- echo '</div>';

- echo '</body>';

- echo '</html>';

-

- if (!empty($db) && is_object($db))

- {

- $db->sql_close();

- }

- exit_handler();

- function db_error($error, $sql, $line, $file, $skip = false)

- global $lang, $db, $template;

-

- if ($skip)

- {

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

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['INST_ERR_FATAL'],

- ));

-

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

- 'TITLE' => basename($file) . ' [ ' . $line . ' ]',

- 'RESULT' => '<b style="color:red">' . $error . '</b><br />&#187; SQL:' . $sql,

- ));

-

- return;

- }

-

- $template->set_filenames(array(

- 'body' => 'install_error.html')

- );

- $this->page_header();

- $this->generate_navigation();

-

- $template->assign_vars(array(

- 'MESSAGE_TITLE' => $lang['INST_ERR_FATAL_DB'],

- 'MESSAGE_TEXT' => '<p>' . basename($file) . ' [ ' . $line . ' ]</p><p>SQL : ' . $sql . '</p><p><b>' . $error . '</b></p>',

- // Rollback if in transaction

- if ($db->transaction)

- {

- $db->sql_transaction('rollback');

- }

- $this->page_footer();

- global $lang;

- $tpl_no = '<label><input type="radio" name="' . $name . '" value="0"' . $key_no . ' class="radio" /> ' . (($type_no) ? $lang['NO'] : $lang['DISABLED']) . '</label>';

- $tpl_yes = '<label><input type="radio" name="' . $name . '" value="1"' . $key_yes . ' class="radio" /> ' . (($type_no) ? $lang['YES'] : $lang['ENABLED']) . '</label>';

- global $lang, $template, $language;

- $this->page_title = $lang['SUB_INTRO'];

-

- $template->assign_vars(array(

- 'TITLE' => $lang['INSTALL_INTRO'],

- 'BODY' => $lang['INSTALL_INTRO_BODY'],

- 'L_SUBMIT' => $lang['NEXT_STEP'],

- 'S_LANG_SELECT' => '<select id="language" name="language">' . $this->p_master->inst_language_select($language) . '</select>',

- 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language",

-

- $this->obtain_database_settings($mode, $sub);

- $this->obtain_admin_settings($mode, $sub);

- $this->create_config_file($mode, $sub);

- $this->obtain_advanced_settings($mode, $sub);

- $this->load_schema($mode, $sub);

- $this->tpl_name = 'install_install';

- global $lang, $template, $language;

-

- $this->page_title = $lang['STAGE_REQUIREMENTS'];

-

- $template->assign_vars(array(

- 'TITLE' => $lang['REQUIREMENTS_TITLE'],

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

- ));

-

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

- 'LEGEND' => $lang['PHP_SETTINGS'],

- 'LEGEND_EXPLAIN' => $lang['PHP_SETTINGS_EXPLAIN'],

- $php_version = PHP_VERSION;

-

- if (version_compare($php_version, '5.2.0') < 0)

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- $result = '<strong style="color:green">' . $lang['YES'];

- $result .= ', ' . $lang['PHP_SAFE_MODE'];

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

- 'TITLE' => $lang['PHP_VERSION_REQD'],

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

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

- 'TITLE' => $lang['PHP_REGISTER_GLOBALS'],

- 'TITLE_EXPLAIN' => $lang['PHP_REGISTER_GLOBALS_EXPLAIN'],

- 'S_LEGEND' => false,

-

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

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

- 'TITLE' => $lang['PHP_URL_FOPEN_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PHP_URL_FOPEN_SUPPORT_EXPLAIN'],

- 'S_LEGEND' => false,

-

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

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

- 'TITLE' => $lang['PHP_GETIMAGESIZE_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PHP_GETIMAGESIZE_SUPPORT_EXPLAIN'],

- 'S_LEGEND' => false,

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

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

- 'TITLE' => $lang['PCRE_UTF_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PCRE_UTF_SUPPORT_EXPLAIN'],

- 'S_LEGEND' => false,

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

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

- 'TITLE' => $lang['PCRE_UNI_PROP_SUPPORT'],

- 'TITLE_EXPLAIN' => $lang['PCRE_UNI_PROP_SUPPORT_EXPLAIN'],

- 'S_LEGEND' => false,

-/**

-* Better not enabling and adding to the loaded extensions due to the specific requirements needed

- if (!@extension_loaded('mbstring'))

- {

- can_load_dll('mbstring');

- }

-*/

-

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

- 'LEGEND' => $lang['MBSTRING_CHECK'],

- 'LEGEND_EXPLAIN' => $lang['MBSTRING_CHECK_EXPLAIN'],

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

- $result = '<strong style="color:red">' . $lang['NO'] . '</strong>';

- $result = '<strong style="color:green">' . $lang['YES'] . '</strong>';

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

- 'TITLE' => $lang['MBSTRING_' . strtoupper($mb_checks[0])],

- 'TITLE_EXPLAIN' => $lang['MBSTRING_' . strtoupper($mb_checks[0]) . '_EXPLAIN'],

- 'S_LEGEND' => false,

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

- 'LEGEND' => $lang['PHP_SUPPORTED_DB'],

- 'LEGEND_EXPLAIN' => $lang['PHP_SUPPORTED_DB_EXPLAIN'],

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

- 'TITLE' => $lang['DLL_' . strtoupper($db_name)],

- 'RESULT' => '<span style="color:red">' . $lang['UNAVAILABLE'] . '</span>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'TITLE' => $lang['DLL_' . strtoupper($db_name)],

- 'RESULT' => '<strong style="color:green">' . $lang['AVAILABLE'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'LEGEND' => $lang['PHP_OPTIONAL_MODULE'],

- 'LEGEND_EXPLAIN' => $lang['PHP_OPTIONAL_MODULE_EXPLAIN'],

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

- 'TITLE' => $lang['DLL_' . strtoupper($dll)],

- 'RESULT' => '<strong style="color:red">' . $lang['UNAVAILABLE'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'TITLE' => $lang['DLL_' . strtoupper($dll)],

- 'RESULT' => '<strong style="color:green">' . $lang['AVAILABLE'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'TITLE' => $lang['APP_MAGICK'],

- 'RESULT' => ($img_imagick) ? '<strong style="color:green">' . $lang['AVAILABLE'] . ', ' . $img_imagick . '</strong>' : '<strong style="color:blue">' . $lang['NO_LOCATION'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'LEGEND' => $lang['FILES_REQUIRED'],

- 'LEGEND_EXPLAIN' => $lang['FILES_REQUIRED_EXPLAIN'],

- $exists = ($exists) ? '<strong style="color:green">' . $lang['FOUND'] . '</strong>' : '<strong style="color:red">' . $lang['NOT_FOUND'] . '</strong>';

- $write = ($write) ? ', <strong style="color:green">' . $lang['WRITABLE'] . '</strong>' : (($exists) ? ', <strong style="color:red">' . $lang['UNWRITABLE'] . '</strong>' : '');

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

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'LEGEND' => $lang['FILES_OPTIONAL'],

- 'LEGEND_EXPLAIN' => $lang['FILES_OPTIONAL_EXPLAIN'],

- $exists_str = ($exists) ? '<strong style="color:green">' . $lang['FOUND'] . '</strong>' : '<strong style="color:red">' . $lang['NOT_FOUND'] . '</strong>';

- $write_str = ($write) ? ', <strong style="color:green">' . $lang['WRITABLE'] . '</strong>' : (($exists) ? ', <strong style="color:red">' . $lang['UNWRITABLE'] . '</strong>' : '');

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

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- $url = (!in_array(false, $passed)) ? $this->p_master->module_url . "?mode=$mode&amp;sub=database&amp;language=$language" : $this->p_master->module_url . "?mode=$mode&amp;sub=requirements&amp;language=$language ";

- $submit = (!in_array(false, $passed)) ? $lang['INSTALL_START'] : $lang['INSTALL_TEST'];

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $submit,

- 'S_HIDDEN' => $s_hidden_fields,

- 'U_ACTION' => $url,

- function obtain_database_settings($mode, $sub)

- global $lang, $template;

-

- $this->page_title = $lang['STAGE_DATABASE'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- $available_dbms = get_available_dbms(false, true);

- if (!isset($available_dbms[$data['dbms']]) || !$available_dbms[$data['dbms']]['AVAILABLE'])

- $error['db'][] = $lang['INST_ERR_NO_DB'];

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

- 'S_LEGEND' => true,

- 'LEGEND' => $lang['DB_CONNECTION'],

- 'LEGEND_EXPLAIN' => false,

- ));

-

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

- 'TITLE' => $lang['DB_TEST'],

- 'RESULT' => '<strong style="color:green">' . $lang['SUCCESSFUL_CONNECT'] . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'TITLE' => $lang['DB_TEST'],

- 'RESULT' => '<strong style="color:red">' . implode('<br />', $error) . '</strong>',

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- // Update the list of available DBMS modules to only contain those which can be used

- $available_dbms_temp = array();

- foreach ($available_dbms as $type => $dbms_ary)

- {

- if (!$dbms_ary['AVAILABLE'])

- {

- continue;

- }

-

- $available_dbms_temp[$type] = $dbms_ary;

- }

-

- $available_dbms = &$available_dbms_temp;

-

-

- foreach ($this->db_config_options as $config_key => $vars)

- {

- if (!is_array($vars) && strpos($config_key, 'legend') === false)

- {

- continue;

- }

-

- if (strpos($config_key, 'legend') !== false)

- {

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

- 'S_LEGEND' => true,

- 'LEGEND' => $lang[$vars])

- );

-

- continue;

- }

-

- $options = isset($vars['options']) ? $vars['options'] : '';

-

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

- 'KEY' => $config_key,

- 'TITLE' => $lang[$vars['lang']],

- 'S_EXPLAIN' => $vars['explain'],

- 'S_LEGEND' => false,

- 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '',

- 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options),

- )

- );

- }

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

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

- foreach ($this->db_config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

- $url = ($connect_test) ? $this->p_master->module_url . "?mode=$mode&amp;sub=administrator" : $this->p_master->module_url . "?mode=$mode&amp;sub=database";

- $submit = $lang['NEXT_STEP'];

-

- $template->assign_vars(array(

- 'L_SUBMIT' => $submit,

- function obtain_admin_settings($mode, $sub)

- global $lang, $template;

-

- $this->page_title = $lang['STAGE_ADMINISTRATOR'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

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

-

- if ($data['admin_name'] == '' || $data['admin_pass1'] == '' || $data['admin_pass2'] == '' || $data['board_email1'] == '' || $data['board_email2'] == '')

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

- $error[] = $lang['INST_ERR_PASSWORD_MISMATCH'];

- $error[] = $lang['INST_ERR_USER_TOO_SHORT'];

- $error[] = $lang['INST_ERR_USER_TOO_LONG'];

- $error[] = $lang['INST_ERR_PASSWORD_TOO_SHORT'];

- $error[] = $lang['INST_ERR_PASSWORD_TOO_LONG'];

- if ($data['board_email1'] != $data['board_email2'] && $data['board_email1'] != '')

- $error[] = $lang['INST_ERR_EMAIL_MISMATCH'];

- if ($data['board_email1'] != '' && !preg_match('/^' . get_preg_expression('email') . '$/i', $data['board_email1']))

- $error[] = $lang['INST_ERR_EMAIL_INVALID'];

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

- 'LEGEND' => $lang['STAGE_ADMINISTRATOR'],

- 'LEGEND_EXPLAIN' => false,

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

- 'TITLE' => $lang['ADMIN_TEST'],

- 'RESULT' => '<strong style="color:green">' . $lang['TESTS_PASSED'] . '</strong>',

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

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

- 'TITLE' => $lang['ADMIN_TEST'],

-

- 'S_EXPLAIN' => false,

- 'S_LEGEND' => false,

- foreach ($this->admin_config_options as $config_key => $vars)

- {

- if (!is_array($vars) && strpos($config_key, 'legend') === false)

- {

- continue;

- }

-

- if (strpos($config_key, 'legend') !== false)

- {

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

- 'S_LEGEND' => true,

- 'LEGEND' => $lang[$vars])

- );

-

- continue;

- }

-

- $options = isset($vars['options']) ? $vars['options'] : '';

-

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

- 'KEY' => $config_key,

- 'TITLE' => $lang[$vars['lang']],

- 'S_EXPLAIN' => $vars['explain'],

- 'S_LEGEND' => false,

- 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '',

- 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options),

- )

- );

- }

- foreach ($this->admin_config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

- }

-

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

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

-

- foreach ($this->db_config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- $submit = $lang['NEXT_STEP'];

- $url = ($passed) ? $this->p_master->module_url . "?mode=$mode&amp;sub=config_file" : $this->p_master->module_url . "?mode=$mode&amp;sub=administrator";

- $template->assign_vars(array(

- 'L_SUBMIT' => $submit,

- function create_config_file($mode, $sub)

- global $lang, $template;

-

- $this->page_title = $lang['STAGE_CONFIG_FILE'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

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

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

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

- $config_options = array_merge($this->db_config_options, $this->admin_config_options);

-

- foreach ($config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- }

-

- $template->assign_vars(array(

- 'BODY' => $lang['CONFIG_FILE_UNABLE_WRITE'],

- 'L_DL_CONFIG' => $lang['DL_CONFIG'],

- 'L_DL_CONFIG_EXPLAIN' => $lang['DL_CONFIG_EXPLAIN'],

- 'L_DL_DONE' => $lang['DONE'],

- 'L_DL_DOWNLOAD' => $lang['DL_DOWNLOAD'],

- 'S_SHOW_DOWNLOAD' => true,

- 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&amp;sub=config_file",

- return;

- $template->assign_vars(array(

- 'BODY' => $lang['CONFIG_FILE_WRITTEN'],

- 'L_SUBMIT' => $lang['NEXT_STEP'],

- 'U_ACTION' => $this->p_master->module_url . "?mode=$mode&amp;sub=advanced",

- return;

- function obtain_advanced_settings($mode, $sub)

- global $lang, $template;

-

- $this->page_title = $lang['STAGE_ADVANCED'];

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

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

- $s_hidden_fields .= '<input type="hidden" name="language" value="' . $data['language'] . '" />';

-

- // HTTP_HOST is having the correct browser url in most cases...

- $server_name = (!empty($_SERVER['HTTP_HOST'])) ? strtolower($_SERVER['HTTP_HOST']) : ((!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME'));

-

- // HTTP HOST can carry a port number...

- if (strpos($server_name, ':') !== false)

- {

- $server_name = substr($server_name, 0, strpos($server_name, ':'));

- }

- $data['server_name'] = ($data['server_name'] !== '') ? $data['server_name'] : $server_name;

- $data['server_port'] = ($data['server_port'] !== '') ? $data['server_port'] : ((!empty($_SERVER['SERVER_PORT'])) ? (int) $_SERVER['SERVER_PORT'] : (int) getenv('SERVER_PORT'));

- $name = (!empty($_SERVER['PHP_SELF'])) ? $_SERVER['PHP_SELF'] : getenv('PHP_SELF');

- if (!$name)

- {

- $name = (!empty($_SERVER['REQUEST_URI'])) ? $_SERVER['REQUEST_URI'] : getenv('REQUEST_URI');

- }

-

- $name = str_replace(array('\\', '//', '/install'), '/', $name);

- $data['script_path'] = trim(dirname($name));

- }

-

- foreach ($this->advanced_config_options as $config_key => $vars)

- {

- if (!is_array($vars) && strpos($config_key, 'legend') === false)

- {

- continue;

- }

-

- if (strpos($config_key, 'legend') !== false)

- {

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

- 'S_LEGEND' => true,

- 'LEGEND' => $lang[$vars])

- );

-

- continue;

- }

-

- $options = isset($vars['options']) ? $vars['options'] : '';

-

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

- 'KEY' => $config_key,

- 'TITLE' => $lang[$vars['lang']],

- 'S_EXPLAIN' => $vars['explain'],

- 'S_LEGEND' => false,

- 'TITLE_EXPLAIN' => ($vars['explain']) ? $lang[$vars['lang'] . '_EXPLAIN'] : '',

- 'CONTENT' => $this->p_master->input_field($config_key, $vars['type'], $data[$config_key], $options),

- )

- );

- }

-

- $config_options = array_merge($this->db_config_options, $this->admin_config_options);

- foreach ($config_options as $config_key => $vars)

- {

- if (!is_array($vars))

- {

- continue;

- }

- $s_hidden_fields .= '<input type="hidden" name="' . $config_key . '" value="' . $data[$config_key] . '" />';

- $submit = $lang['NEXT_STEP'];

-

- $url = $this->p_master->module_url . "?mode=$mode&amp;sub=create_table";

- $template->assign_vars(array(

- 'BODY' => $lang['STAGE_ADVANCED_EXPLAIN'],

- 'L_SUBMIT' => $submit,

- 'U_ACTION' => $url,

- function load_schema($mode, $sub)

- global $db, $lang, $template;

-

- $this->page_title = $lang['STAGE_CREATE_TABLE'];

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- // HTTP_HOST is having the correct browser url in most cases...

- $server_name = (!empty($_SERVER['HTTP_HOST'])) ? strtolower($_SERVER['HTTP_HOST']) : ((!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : getenv('SERVER_NAME'));

- $referer = (!empty($_SERVER['HTTP_REFERER'])) ? strtolower($_SERVER['HTTP_REFERER']) : getenv('HTTP_REFERER');

-

- // HTTP HOST can carry a port number...

- if (strpos($server_name, ':') !== false)

- {

- $server_name = substr($server_name, 0, strpos($server_name, ':'));

- }

-

- $cookie_domain = ($data['server_name'] != '') ? $data['server_name'] : $server_name;

-

- // Try to come up with the best solution for cookie domain...

- if (strpos($cookie_domain, 'www.') === 0)

- {

- $cookie_domain = str_replace('www.', '.', $cookie_domain);

- }

-

- $dbms = $available_dbms[$data['dbms']]['DRIVER'];

-

- // Load the appropriate database class if not already loaded

- include(PHPBB_ROOT_PATH . 'includes/db/' . $dbms . '.' . PHP_EXT);

-

- // Instantiate the database

- $db = new $sql_db();

- $db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false);

- // NOTE: trigger_error does not work here.

- $db->sql_return_on_error(true);

- // Ok we have the db info go ahead and read in the relevant schema

- // and work on building the table

- $dbms_schema = 'schemas/' . $available_dbms[$data['dbms']]['SCHEMA'] . '_schema.sql';

- // How should we treat this schema?

- $remove_remarks = $available_dbms[$data['dbms']]['COMMENTS'];

- $delimiter = $available_dbms[$data['dbms']]['DELIM'];

- include(PHPBB_ROOT_PATH . 'includes/db/db_tools.php');

- include(PHPBB_ROOT_PATH . 'install/schemas/schema_data.php');

-

- // we must set return_statements to true so that we can handle the errors

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

- // Change prefix

- $table_name = preg_replace('#phpbb_#i', $data['table_prefix'], $table_name);

- $statements = $db_tools->sql_create_table($table_name, $table_data);

- foreach ($statements as $sql)

- {

- if (!$db->sql_query($sql))

- {

- $error = $db->sql_error();

- $this->p_master->db_error($error['message'], $sql, __LINE__, __FILE__);

- }

- }

- // Ok tables have been built, let's fill in the basic information

- $sql_query = file_get_contents('schemas/schema_data.sql');

- // Deal with any special comments

- switch ($data['dbms'])

- {

- case 'mssql':

- case 'mssql_odbc':

- case 'mssql_2005':

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

- break;

- case 'postgres':

- $sql_query = preg_replace('#\# POSTGRES (BEGIN|COMMIT) \##s', '\1; ', $sql_query);

- break;

- }

-

- // Change prefix

- $sql_query = preg_replace('#phpbb_#i', $data['table_prefix'], $sql_query);

-

- // Change language strings...

- $sql_query = preg_replace_callback('#\{L_([A-Z0-9\-_]*)\}#s', 'adjust_language_keys_callback', $sql_query);

- // Since there is only one schema file we know the comment style and are able to remove it directly with remove_remarks

- remove_remarks($sql_query);

- $sql_query = split_sql_file($sql_query, ';');

- foreach ($sql_query as $sql)

- //$sql = trim(str_replace('|', ';', $sql));

- if (!$db->sql_query($sql))

- {

- $error = $db->sql_error();

- $this->p_master->db_error($error['message'], $sql, __LINE__, __FILE__);

- }

- unset($sql_query);

-

- $current_time = time();

-

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

- // Set default config and post data, this applies to all DB's

- $sql_ary = array(

- 'INSERT INTO ' . $data['table_prefix'] . "config (config_name, config_value)

- VALUES ('board_startdate', '$current_time')",

-

- 'INSERT INTO ' . $data['table_prefix'] . "config (config_name, config_value)

- VALUES ('default_lang', '" . $db->sql_escape($data['default_lang']) . "')",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['img_imagick']) . "'

- WHERE config_name = 'img_imagick'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['server_name']) . "'

- WHERE config_name = 'server_name'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['server_port']) . "'

- WHERE config_name = 'server_port'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['board_email1']) . "'

- WHERE config_name = 'board_email'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['board_email1']) . "'

- WHERE config_name = 'board_contact'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($cookie_domain) . "'

- WHERE config_name = 'cookie_domain'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($lang['default_dateformat']) . "'

- WHERE config_name = 'default_dateformat'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['email_enable']) . "'

- WHERE config_name = 'email_enable'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_delivery']) . "'

- WHERE config_name = 'smtp_delivery'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_host']) . "'

- WHERE config_name = 'smtp_host'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_auth']) . "'

- WHERE config_name = 'smtp_auth_method'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_user']) . "'

- WHERE config_name = 'smtp_username'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['smtp_pass']) . "'

- WHERE config_name = 'smtp_password'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['cookie_secure']) . "'

- WHERE config_name = 'cookie_secure'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['force_server_vars']) . "'

- WHERE config_name = 'force_server_vars'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['script_path']) . "'

- WHERE config_name = 'script_path'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['server_protocol']) . "'

- WHERE config_name = 'server_protocol'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE config_name = 'newest_username'",

-

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . md5(mt_rand()) . "'

- WHERE config_name = 'avatar_salt'",

-

- 'UPDATE ' . $data['table_prefix'] . "users

- SET username = '" . $db->sql_escape($data['admin_name']) . "', user_password='" . $db->sql_escape(md5($data['admin_pass1'])) . "', user_ip = '" . $db->sql_escape($user_ip) . "', user_lang = '" . $db->sql_escape($data['default_lang']) . "', user_email='" . $db->sql_escape($data['board_email1']) . "', user_dateformat='" . $db->sql_escape($lang['default_dateformat']) . "', user_email_hash = " . hexdec(crc32($data['board_email1']) . strlen($data['board_email1'])) . ", username_clean = '" . $db->sql_escape(utf8_clean_string($data['admin_name'])) . "'

- WHERE username = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "moderator_cache

- SET username = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE username = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "forums

- SET forum_last_poster_name = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE forum_last_poster_name = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "topics

- SET topic_first_poster_name = '" . $db->sql_escape($data['admin_name']) . "', topic_last_poster_name = '" . $db->sql_escape($data['admin_name']) . "'

- WHERE topic_first_poster_name = 'Admin'

- OR topic_last_poster_name = 'Admin'",

-

- 'UPDATE ' . $data['table_prefix'] . "users

- SET user_regdate = $current_time",

- 'UPDATE ' . $data['table_prefix'] . "posts

- SET post_time = $current_time, poster_ip = '" . $db->sql_escape($user_ip) . "'",

- 'UPDATE ' . $data['table_prefix'] . "topics

- SET topic_time = $current_time, topic_last_post_time = $current_time",

- 'UPDATE ' . $data['table_prefix'] . "forums

- SET forum_last_post_time = $current_time",

- 'UPDATE ' . $data['table_prefix'] . "config

- SET config_value = '" . $db->sql_escape($db->sql_server_info(true)) . "'

- WHERE config_name = 'dbms_version'",

- );

- if (@extension_loaded('gd') || can_load_dll('gd'))

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

- SET config_value = 'phpbb_captcha_gd'

- WHERE config_name = 'captcha_plugin'";

- $ref = substr($referer, strpos($referer, '://') + 3);

- if (!(stripos($ref, $server_name) === 0))

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

- SET config_value = '0'

- WHERE config_name = 'referer_validation'";

- // We set a (semi-)unique cookie name to bypass login issues related to the cookie name.

- $cookie_name = 'phpbb3_';

- $rand_str = md5(mt_rand());

- $rand_str = str_replace('0', 'z', base_convert($rand_str, 16, 35));

- $rand_str = substr($rand_str, 0, 5);

- $cookie_name .= strtolower($rand_str);

-

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

- SET config_value = '" . $db->sql_escape($cookie_name) . "'

- WHERE config_name = 'cookie_name'";

-

- foreach ($sql_ary as $sql)

- //$sql = trim(str_replace('|', ';', $sql));

- if (!$db->sql_query($sql))

- $error = $db->sql_error();

- $this->p_master->db_error($error['message'], $sql, __LINE__, __FILE__);

- }

-

- $submit = $lang['NEXT_STEP'];

- $url = $this->p_master->module_url . "?mode=$mode&amp;sub=final";

- $template->assign_vars(array(

- 'BODY' => $lang['STAGE_CREATE_TABLE_EXPLAIN'],

- 'L_SUBMIT' => $submit,

- 'U_ACTION' => $url,

- global $db, $lang;

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

- $table_prefix = $data['table_prefix'];

-

- // If we get here and the extension isn't loaded it should be safe to just go ahead and load it

- $available_dbms = get_available_dbms($data['dbms']);

-

- if (!isset($available_dbms[$data['dbms']]))

- {

- // Someone's been silly and tried providing a non-existant dbms

- $this->p_master->redirect('index.' . PHP_EXT . '?mode=install');

- }

-

- $dbms = $available_dbms[$data['dbms']]['DRIVER'];

-

- // Load the appropriate database class if not already loaded

- include(PHPBB_ROOT_PATH . 'includes/db/' . $dbms . '.' . PHP_EXT);

-

- // Instantiate the database

- $db = new $sql_db();

- $db->sql_connect($data['dbhost'], $data['dbuser'], htmlspecialchars_decode($data['dbpasswd']), $data['dbname'], $data['dbport'], false, false);

-

- // NOTE: trigger_error does not work here.

- $db->sql_return_on_error(true);

-

- include_once(PHPBB_ROOT_PATH . 'includes/constants.' . PHP_EXT);

- include_once(PHPBB_ROOT_PATH . 'includes/search/fulltext_native.' . PHP_EXT);

- /* Fill the config array - it is needed by those functions we call

- $sql = 'SELECT *

- FROM ' . CONFIG_TABLE;

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

-

- $config = array();

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

- {

- $config[$row['config_name']] = $row['config_value'];

- }

- $db->sql_freeresult($result);

-*/

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

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

- $db->sql_freeresult($result);

- global $db, $lang;

-

- include_once(PHPBB_ROOT_PATH . 'includes/acp/acp_modules.' . PHP_EXT);

- // Check for last sql error happened

- if ($db->sql_error_triggered)

- {

- $error = $db->sql_error($db->sql_error_sql);

- $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

- }

-

- // Check for last sql error happened

- if ($db->sql_error_triggered)

- {

- $error = $db->sql_error($db->sql_error_sql);

- $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

- }

-

-

- // Check for last sql error happened

- if ($db->sql_error_triggered)

- {

- $error = $db->sql_error($db->sql_error_sql);

- $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

- }

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

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

- $db->sql_freeresult($result);

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

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

- $db->sql_freeresult($result);

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

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

- $db->sql_freeresult($result);

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

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

- $db->sql_freeresult($result);

- WHERE module_langname = '" . $db->sql_escape($cat_name) . "'

- AND module_class = '" . $db->sql_escape($module_class) . "'";

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

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

- $db->sql_freeresult($result);

- WHERE module_langname = '" . $db->sql_escape($mod_name) . "'

- AND module_class = '" . $db->sql_escape($module_class) . "'

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

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

- $db->sql_freeresult($result);

-

- // Check for last sql error happened

- if ($db->sql_error_triggered)

- {

- $error = $db->sql_error($db->sql_error_sql);

- $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

- }

- global $db, $lang;

-

- $this->error('Unable to access the language directory', __LINE__, __FILE__);

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

-

- if ($db->sql_error_triggered)

- {

- $error = $db->sql_error($db->sql_error_sql);

- $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

- }

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

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

- $db->sql_freeresult($result);

- $db->sql_multi_insert(STYLES_IMAGESET_DATA_TABLE, $sql_ary);

-

- if ($db->sql_error_triggered)

- {

- $error = $db->sql_error($db->sql_error_sql);

- $this->p_master->db_error($error['message'], $db->sql_error_sql, __LINE__, __FILE__);

- }

- global $db, $lang;

-

- // Obtain any submitted data

- $data = $this->get_submitted_data();

-

- // Fill the config array - it is needed by those functions we call

- $sql = 'SELECT *

- FROM ' . CONFIG_TABLE;

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

-

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

- $group_id = (int) $db->sql_fetchfield('group_id');

- $db->sql_freeresult($result);

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

- include(PHPBB_ROOT_PATH . 'includes/functions_user.' . PHP_EXT);

- 'user_lang' => $data['default_lang'],

- 'user_dateformat' => $lang['default_dateformat'],

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

- $sql = 'INSERT INTO ' . BOTS_TABLE . ' ' . $db->sql_build_array('INSERT', array(

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

- global $auth, $db, $lang, $template, $user;

-

- $this->page_title = $lang['STAGE_FINAL'];

-

- $sql = 'SELECT *

- FROM ' . CONFIG_TABLE;

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

- $user->session_begin();

- $auth->login($data['admin_name'], $data['admin_pass1'], false, true, true);

- // OK, Now that we've reached this point we can be confident that everything

- // is installed and working......I hope :)

- // So it's time to send an email to the administrator confirming the details

- // they entered

- $messenger->to($data['board_email1'], $data['admin_name']);

- $messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);

- $messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);

- $messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);

-

- $template->assign_vars(array(

- 'TITLE' => $lang['INSTALL_CONGRATS'],

- 'BODY' => sprintf($lang['INSTALL_CONGRATS_EXPLAIN'], phpbb::$config['version'], append_sid('install/index', 'mode=convert&amp;language=' . $data['language']), '../docs/README.html'),

- 'L_SUBMIT' => $lang['INSTALL_LOGIN'],

- 'U_ACTION' => append_sid('adm/index'),

- global $lang;

-

- $s_smtp_auth_options .= '<option value="' . $method . '"' . (($selected_method == $method) ? ' selected="selected"' : '') . '>' . $lang['SMTP_' . str_replace('-', '_', $method)] . '</option>';

- 'board_email1' => strtolower(request_var('board_email1', '')),

- 'board_email2' => strtolower(request_var('board_email2', '')),

- 'board_email1' => array('lang' => 'CONTACT_EMAIL', 'type' => 'text:25:100', 'explain' => false),

- 'board_email2' => array('lang' => 'CONTACT_EMAIL_CONFIRM', 'type' => 'text:25:100', 'explain' => false),

- global $lang, $template, $language;

-

- $title = $lang['SUB_INTRO'];

- $body = $lang['OVERVIEW_BODY'];

- $title = $lang['GPL'];

- $body = implode("<br/>\n", file('../docs/COPYING'));

- $title = $lang['SUB_SUPPORT'];

- $body = $lang['SUPPORT_BODY'];

- $this->tpl_name = 'install_main';

- $template->assign_vars(array(

- 'S_LANG_SELECT' => '<select id="language" name="language">' . $this->p_master->inst_language_select($language) . '</select>',

- global $template, $user, $db, $auth;

- // Init DB

- require(PHPBB_ROOT_PATH . 'config.' . PHP_EXT);

- require(PHPBB_ROOT_PATH . 'includes/db/' . $dbms . '.' . PHP_EXT);

- require(PHPBB_ROOT_PATH . 'includes/constants.' . PHP_EXT);

-

- // Special options for conflicts/modified files

- define('MERGE_NO_MERGE_NEW', 1);

- define('MERGE_NO_MERGE_MOD', 2);

- define('MERGE_NEW_FILE', 3);

- define('MERGE_MOD_FILE', 4);

-

- $db = new $sql_db();

-

- // Connect to DB

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

-

- // We do not need this any longer, unset for safety purposes

- unset($dbpasswd);

-

- // First of all, init the user session

- $user->session_begin();

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

-

- $user->setup('install');