+define('IN_PHPBB', true);

+

+// Error reporting level and runtime escaping

+error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables

+// Include essential scripts

+$phpbb_root_path = './../';

+require($phpbb_root_path . 'extension.inc');

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

+include($phpbb_root_path . 'includes/session.'.$phpEx);

+include($phpbb_root_path . 'includes/acm/acm_file.'.$phpEx);

+include($phpbb_root_path . 'includes/functions_admin.'.$phpEx);

+

+// Slash data if necessary

+ $_COOKIE = slash_input_data($_POST);

+// Instantiate classes for future use

+$user = new user();

+$auth = new auth();

+$cache = new acm();

+

+

+// Try opening config file

+if (@file_exists($phpbb_root_path . 'config.'.$phpEx))

+{

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

+

+ if (defined('PHPBB_INSTALLED'))

+ {

+// redirect("../index.$phpEx");

+ }

+}

+

+

+// Obtain various vars

+$stage = (isset($_POST['stage'])) ? intval($_POST['stage']) : 0;

+

+$var_ary = array('language', 'dbms', 'dbhost', 'dbport', 'dbuser', 'dbpasswd', 'dbname', 'table_prefix', 'admin_name', 'admin_pass1', 'admin_pass2', 'board_email1', 'board_email2', 'server_name', 'server_port', 'script_path', 'ftp_path', 'ftp_user', 'ftp_pass');

+

+foreach ($var_ary as $var)

+{

+ $$var = (isset($_POST[$var])) ? htmlspecialchars($_POST[$var]) : false;

+}

+$error = array();

+

+$php_dlls_other = array('zlib', 'mbstring', 'ftp');

+

+ 'firebird' => array(

+ 'LABEL' => 'FireBird',

+ 'SCHEMA' => 'firebird',

+ 'MODULE' => 'interbase',

+ 'DELIM' => ';',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => 'remove_remarks'

+ 'mysql' => array(

+ 'LABEL' => 'MySQL 3.x',

+ 'SCHEMA' => 'mysql',

+ 'MODULE' => 'mysql',

+ 'DELIM' => ';',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => 'remove_remarks'

+ 'mysql4' => array(

+ 'LABEL' => 'MySQL 4.x',

+ 'SCHEMA' => 'mysql',

+ 'MODULE' => 'mysql',

+ 'DELIM' => ';',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => 'remove_remarks'

+ 'mssql' => array(

+ 'LABEL' => 'MS SQL Server 7/2000',

+ 'SCHEMA' => 'mssql',

+ 'MODULE' => 'mssql',

+ 'DELIM' => 'GO',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => 'remove_comments'

+ 'LABEL' => 'MS Access [ ODBC ]',

+ 'SCHEMA' => '',

+ 'MODULE' => 'odbc',

+ 'DELIM' => '',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => ''

+ ),

+ 'mssql-odbc'=> array(

+ 'LABEL' => 'MS SQL Server [ ODBC ]',

+ 'SCHEMA' => 'mssql',

+ 'MODULE' => 'odbc',

+ 'DELIM' => 'GO',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => 'remove_comments'

+ ),

+ 'oracle' => array(

+ 'LABEL' => 'Oracle',

+ 'SCHEMA' => 'oracle',

+ 'MODULE' => 'oracle',

+ 'DELIM' => '',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => 'remove_comments'

+ 'LABEL' => 'PostgreSQL 7.x',

+ 'SCHEMA' => 'postgres',

+ 'MODULE' => 'pgsql',

+ 'DELIM' => ';',

+ 'DELIM_BASIC' => ';',

+ 'COMMENTS' => 'remove_comments'

+$suffix = ((defined('PHP_OS')) && (preg_match('#win#i', PHP_OS))) ? 'dll' : 'so';

+

+

+

+

+

+

+

+

+// Try and load an appropriate language if required

+if (!empty($_SERVER['HTTP_ACCEPT_LANGUAGE']) && !$language)

+ $language = $accept_lang;

+ $language = $accept_lang;

+include($phpbb_root_path . 'language/' . $language . '/lang_main.'.$phpEx);

+include($phpbb_root_path . 'language/' . $language . '/lang_admin.'.$phpEx);

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+

+// Do the installation

+if (isset($_POST['install']))

+ // Check for missing data

+ $var_ary = array(

+ 'admin' => array('admin_name', 'admin_pass1', 'admin_pass2', 'board_email1', 'board_email2'),

+ 'server' => array('server_name', 'server_port', 'script_path')

+ );

+

+ foreach ($var_ary as $var_type => $var_block)

+ {

+ foreach ($var_block as $var)

+ {

+ if (!$$var)

+ {

+ $error[$var_type][] = 'You must fill out all fields in this block';

+ break;

+ }

+ }

+ }

+

+

+ // Check the entered email address and password

+ if ($admin_pass1 != $admin_pass2 && $admin_pass1 != '')

+ {

+ $error['admin'][] = $lang['PASSWORD_MISMATCH'];

+ }

+

+ if ($board_email1 != $board_email2 && $board_email1 != '')

+ {

+ $error['admin'][] = $lang['INSTALL_EMAIL_MISMATCH'];

+ }

+

+

+ // Test the database connectivity

+ if (!@extension_loaded($available_dbms[$dbms]['MODULE']))

+ {

+ if (!@ini_get('enable_dl') || strtolower(@ini_get('enable_dl')) == 'off' || @ini_get('safe_mode') || strtolower(@ini_get('safe_mode')) == 'on' || !@dl($available_dbms[$dbms]['MODULE'] . '.' . $suffix))

+ {

+ $error['db'][] = 'Cannot load the PHP module for the selected database type';

+ }

+ }

+

+ // Include the DB layer

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

+ // Instantiate it and set return on error true

+ $db = new sql_db();

+ $db->sql_return_on_error(true);

+

+ // Try and connect ...

+ if (is_array($db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false)))

+ {

+ $db_error = $db->sql_error();

+ $error['db'][] = 'Could not connect to the database, error message returned:' . '<br />' . (($db_error['message']) ? $db_error['message'] : 'No error message given');

+ }

+

+ // No errors so lets do the twist

+ if (sizeof($error))

+ {

+ $stage = 1;

+ }

+else if (isset($_POST['testdb']))

+ $stage = 1;

+}

+else if (isset($_POST['retest']))

+{

+ $stage = 0;

+}

+else if (isset($_POST['dldone']))

+{

+ // A minor fudge ... we're basically trying to see if the user uploaded

+ // their downloaded config file ... it's not worth IMO trying to

+ // open it and compare all the data. If a user wants to screw up this

+ // simple task ... well ... uhm

+ if (filesize($phpbb_root_path . 'config.'.$phpEx) < 10)

+ {

+ $stage = 3;

+ }

+}

+

+

+

+

+

+

+

+

+

+

+

+// First stage of installation

+//

+// Here we basically imform the user of any potential issues such as no database

+// support, missing directories, etc. We also give some insight into "missing"

+// modules which we'd quite like installed (but which are not essential)

+if ($stage == 0)

+{

+

+ $user->lang = array_merge($lang, array(

+ 'DLL_firebird' => 'Firebird 1.5+',

+ 'DLL_mysql' => 'MySQL 3.23.x',

+ 'DLL_mysql4' => 'MySQL 4.x',

+ 'DLL_mssql' => 'MSSQL Server 2000',

+ 'DLL_mssql-odbc' => 'MSSQL Server 2000 via ODBC',

+ 'DLL_msaccess' => 'MS Access via ODBC',

+ 'DLL_oracle' => 'Oracle',

+ 'DLL_postgres' => 'PostgreSQL 7.x')

+ );

+

+

+ // Test for DB modules

+ $dlls_db = array();

+ $passed['db'] = false;

+ foreach ($available_dbms as $db_name => $db_ary)

+ $dll = $db_ary['MODULE'];

+

+ if (!extension_loaded($dll))

+ {

+ if (!@ini_get('enable_dl') || strtolower(@ini_get('enable_dl')) == 'off' || @ini_get('safe_mode') || strtolower(@ini_get('safe_mode')) == 'on' || !@dl($dll . ".$suffix"))

+ {

+ $dlls_db[$db_name] = '<span style="color:red">' . 'Unavailable' . '</span>';

+ continue;

+ }

+ }

+ $dlls_db[$db_name] = '<span style="color:green">' . 'Available' . '</span>';

+ $passed['db'] = true;

+

+

+ // Test for other modules

+ $dlls_other = array();

+ foreach ($php_dlls_other as $dll)

+ {

+ if (!extension_loaded($dll))

+ {

+ if (!@ini_get('enable_dl') || strtolower(@ini_get('enable_dl')) == 'off' || @ini_get('safe_mode') || strtolower(@ini_get('safe_mode')) == 'on' || !@dl($dll . ".$suffix"))

+ {

+ $dlls_other[$dll] = '<span style="color:red">' . 'Unavailable' . '</span>';

+ continue;

+ }

+ }

+ $dlls_other[$dll] = '<span style="color:green">' . 'Available' . '</span>';

+ }

+

+ inst_page_header($instruction_text, "install.$phpEx");

+

+<p>Before proceeding with full installation phpBB will carry out some tests on your server and basic install. Please ensure you read through the results thoroughly and do not proceed until all tests are passed.</p>

+

+<h1>PHP and Applications</h1>

+

+<h2>Required</h2>

+

+<p>You must be running at least PHP 4.1.0 with support for at least one compatible database. If no support modules are shown as available you should contact your hosting provider or review the relevant PHP installation documentation for advice.</p>

+

+<table cellspacing="1" cellpadding="4" border="0">

+ <td>&bull;&nbsp;<b>PHP version >= 4.1.0: </b></td>

+ <td><?php

+

+ $php_version = phpversion();

+

+ if (version_compare($php_version, '4.1.0') < 0)

+ {

+ $passed['db'] = false;

+ echo '<span style="color:red">No</span>';

+ }

+ else

+ {

+ echo '<span style="color:green">Yes';

+ if (@ini_get('safe_mode') || strtolower(@ini_get('safe_mode')) == 'on')

+ {

+ echo ', safe mode';

+ }

+ echo '</span>';

+ }

+

+?></td>

+ <td rowspan="<?php echo sizeof($dlls_db); ?>" valign="top">&bull;&nbsp;<b>Supported Databases: </b></td>

+<?php

+

+ $i = 0;

+ foreach ($dlls_db as $dll => $available)

+ {

+ echo ($i++ > 0) ? '<tr>' : '';

+

+?>

+ <td><?php echo $user->lang['DLL_' . $dll]; ?> </td>

+ <td><?php echo $available; ?></td>

+ }

+?>

+</table>

+<h2>Optional</h2>

+

+<p>These modules or applications are optional, you do not need these to use phpBB 2.2. However if you do have them they will will enable greater functionality.</p>

+

+<table cellspacing="1" cellpadding="4" border="0">

+ <tr>

+<?php

+ // Optional modules which may be useful to us

+ foreach ($dlls_other as $dll => $yesno)

+ // TEMPORARY LANGUAGE STRINGS

+ $user->lang = array_merge($user->lang, array(

+ 'DLL_mbstring' => 'Multi-byte character support',

+ 'DLL_zlib' => 'zlib Compression support',

+ 'DLL_ftp' => 'Remote FTP support')

+ );

+?>

+ <tr>

+ <td>&bull;&nbsp;<b><?php echo $user->lang['DLL_' . $dll]; ?>: </b></td>

+ <td><?php echo $yesno; ?></td>

+ </tr>

+<?php

+ }

+ $exe = ((defined('PHP_OS')) && (preg_match('#win#i', PHP_OS))) ? '.exe' : '';

+

+ // Imagemagick are you there? Give me a sign or a path ...

+ $imagemagick = '';

+ if (empty($_ENV['MAGICK_HOME']))

+ {

+ $locations = array('C:/WINDOWS/', 'C:/WINNT/', 'C:/WINDOWS/SYSTEM/', 'C:/WINNT/SYSTEM/', 'C:/WINDOWS/SYSTEM32/', 'C:/WINNT/SYSTEM32/', '/usr/bin/', '/usr/sbin/', '/usr/local/bin/', '/usr/local/sbin/', '/opt/', '/usr/imagemagick/', '/usr/bin/imagemagick/');

+

+ foreach ($locations as $location)

+ if (file_exists($location . 'mogrify' . $exe) && is_executable($location . 'mogrify' . $exe))

+ {

+ $imagemagick = str_replace('\\', '/', $location);

+ continue;

+ }

+ $imagemagick = str_replace('\\', '/', $_ENV['MAGICK_HOME']);

+ }

+?>

+ <tr>

+ <td>&bull;&nbsp;<b>Imagemagick support: </b></td>

+ <td><?php echo ($imagemagick) ? '<span style="color:green">Available, ' . $imagemagick . '</span>' : '<span style="color:blue">Cannot determine location</span>'; ?></td>

+ </tr>

+</table>

+<h1 align="center" <?php echo ($passed['db']) ? 'style="color:green">Tests passed' : 'style="color:red">Tests failed'; ?></h2>

+<hr />

+<h1>Directory and file setup</h2>

+<h2>Required</h2>

+<p>In order to function correctly phpBB needs to be able to access or write to certain files or directories. If you see "Does not exist" you need to create the relevant file or directory. If you see "Not writeable" you need to change the permissions on the file or directory to allow phpBB to write to it.</p>

+

+<table cellspacing="1" cellpadding="4" border="0">

+<?php

+

+ $directories = array('cache/', 'cache/templates/', 'cache/themes/', 'cache/tmp/');

+

+ umask(0);

+

+ $passed['files'] = true;

+ foreach ($directories as $dir)

+ {

+ $write = $exists = true;

+ if (file_exists($phpbb_root_path . $dir))

+ if (!is_writeable($phpbb_root_path . $dir))

+ {

+ $write = (@chmod($phpbb_root_path . $dir, 0777)) ? true : false;

+ }

+ }

+ else

+ {

+ $write = $exists = (@mkdir($phpbb_root_path . $dir, 0777)) ? true : false;

+ $passed['files'] = ($exists && $write && $passed['files']) ? true : false;

+

+ $exists = ($exists) ? '<span style="color:green">Exists</span>' : '<span style="color:red">Does not exist</span>';

+ $write = ($write) ? ', <span style="color:green">Writeable</span>' : (($exists) ? ', <span style="color:red">Not writeable</span>' : '');

+

+?>

+ <tr>

+ <td>&bull;&nbsp;<b><?php echo $dir; ?></b></td>

+ <td><?php echo $exists . $write; ?></td>

+ </tr>

+<?php

+?>

+</table>

+<h2>Optional</h2>

+

+<p>These files, directories or permissions are optional. The installation routines will attempt to use various techniques to complete if they do not exist or cannot be written to. However, the presence of these files, directories or permissions will speed installation.</p>

+

+<table cellspacing="1" cellpadding="4" border="0">

+<?php

+

+ // config.php ... let's just warn the user it's not writeable

+ $dir = 'config.'.$phpEx;

+ $write = $exists = true;

+ if (file_exists($phpbb_root_path . $dir))

+ if (!is_writeable($phpbb_root_path . $dir))

+ {

+ $write = false;

+ }

+ else

+ $write = $exists = false;

+

+ $exists = ($exists) ? '<span style="color:green">Exists</span>' : '<span style="color:red">Does not exist</span>';

+ $write = ($write) ? ', <span style="color:green">Writeable</span>' : (($exists) ? ', <span style="color:red">Not writeable</span>' : '');

+

+?>

+ <tr>

+ <td>&bull;&nbsp;<b><?php echo $dir; ?></b></td>

+ <td><?php echo $exists . $write; ?></td>

+ </tr>

+</table>

+

+<h1 align="center" <?php echo ($passed['files']) ? 'style="color:green">Tests passed' : 'style="color:red">Tests failed'; ?></h2>

+

+<hr />

+

+<h1>Next stage</h1>

+

+<?php

+

+ $next_text = ($passed['db'] && $passed['files']) ? 'All the basic tests have been passed and you may proceed to the next stage of installation. If you have changed any permissions, modules, etc. and wish to re-test you can do so if you wish.' : 'Some tests failed and you should correct these problems before proceeding to the next stage. Failure to do so may result in an incomplete installation.';

+

+?>

+

+<p><?php echo $next_text; ?></p>

+

+<table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

+ <tr>

+ <td class="cat" colspan="2" align="center"><input type="hidden" name="stage" value="1" /><input class="liteoption" name="retest" type="submit" value="Test Again" /><?php

+

+ if ($passed['db'] && $passed['files'])

+

+?>&nbsp;&nbsp; <input class="mainoption" name="submit" type="submit" value="Next Stage" /><?php

+

+

+?></td>

+ </tr>

+</table></form>

+

+<div class="copyright" align="center">Powered by phpBB <?php echo $config['version']; ?> &copy; 2003 <a href="http://www.phpbb.com/" target="_phpbb" class="copyright">phpBB Group</a></div>

+

+<br clear="all" />

+

+</body>

+</html>

+<?php

+

+ exit;

+

+}

+

+

+

+

+

+

+

+

+

+

+

+if ($stage == 1)

+{

+ //

+ // ASK THE QUESTIONS

+ //

+ // ASK THE QUESTIONS

+ //

+ if (isset($_POST['testdb']))

+ if (!@extension_loaded($available_dbms[$dbms]['MODULE']))

+ {

+ if (!@ini_get('enable_dl') || strtolower(@ini_get('enable_dl')) == 'off' || @ini_get('safe_mode') || strtolower(@ini_get('safe_mode')) == 'on' || !@dl($available_dbms[$dbms]['MODULE'] . '.' . $suffix))

+ {

+ $error['db'][] = 'Cannot load the PHP module for the selected database type';

+ }

+ }

+

+ // Include the DB layer

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

+

+ // Instantiate it and set return on error true

+ $db = new sql_db();

+ $db->sql_return_on_error(true);

+

+ // Try and connect ...

+ if (is_array($db->sql_connect($dbhost, $dbuser, $dbpasswd, $dbname, $dbport, false)))

+ {

+ $db_error = $db->sql_error();

+ $error['db'][] = 'Could not connect to the database, error message returned:' . '<br />' . (($db_error['message']) ? $db_error['message'] : 'No error message given');

+ }

+

+ if (!sizeof($error['db']))

+ {

+ $error['db'][] = 'CONNECTION SUCCESSFULL';

+ }

+

+

+

+

+ $available_dbms_temp = array();

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

+ if (!extension_loaded($dbms_ary['MODULE']))

+ {

+ if (!@ini_get('enable_dl') || strtolower(@ini_get('enable_dl')) == 'off' || @ini_get('safe_mode') || strtolower(@ini_get('safe_mode')) == 'on' || !@dl($dbms_ary['MODULE'] . ".$suffix"))

+ {

+ continue;

+ }

+ }

+

+ $available_dbms_temp[$type] = $dbms_ary;

+ $available_dbms = &$available_dbms_temp;

+ // Ok we haven't installed before so lets work our way through the various

+ // steps of the install process. This could turn out to be quite a lengty

+ // process.

+

+ // Step 0 gather the pertinant info for database setup...

+ // Namely dbms, dbhost, dbname, dbuser, and dbpasswd.

+ if (!sizeof($error))

+ // Guess at some basic info used for install..

+ if (!empty($_SERVER['SERVER_NAME']) || !empty($_ENV['SERVER_NAME']))

+ $server_name = (!empty($_SERVER['SERVER_NAME'])) ? $_SERVER['SERVER_NAME'] : $_ENV['SERVER_NAME'];

+ }

+ else if (!empty($_SERVER['HTTP_HOST']) || !empty($_ENV['HTTP_HOST']))

+ {

+ $server_name = (!empty($_SERVER['HTTP_HOST'])) ? $_SERVER['HTTP_HOST'] : $_ENV['HTTP_HOST'];

+ }

+ else

+ {

+ $server_name = '';

+ if (!empty($_SERVER['SERVER_PORT']) || !empty($_ENV['SERVER_PORT']))

+ $server_port = (!empty($_SERVER['SERVER_PORT'])) ? $_SERVER['SERVER_PORT'] : $_ENV['SERVER_PORT'];

+ }

+ else

+ {

+ $server_port = '80';

+ $script_path = preg_replace('#install\/install\.'.$phpEx.'#i', '', $_SERVER['PHP_SELF']);

+ }

+ // Generate list of available DB's

+ $dbms_options = '';

+ $selected = ($dbms_name == $dbms) ? ' selected="selected"' : '';

+ $dbms_options .= '<option value="' . $dbms_name . '"' . $selected .'>' . $details['LABEL'] . '</option>';

+

+

+ $s_hidden_fields = '<input type="hidden" name="stage" value="2" />';

+

+

+

+<table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

+ <th colspan="2"><?php echo $lang['ADMIN_CONFIG']; ?></th>

+<?php

+

+ if (sizeof($error['admin']))

+ {

+?>

+ <td class="row3" colspan="2" align="center"><span class="gen" style="color:red"><?php echo implode('<br />', $error['admin']); ?></span></td>

+<?php

+

+ }

+?>

+ <td class="row1" width="50%" width="50%"><span class="gen"><?php echo $lang['DEFAULT_LANG']; ?>: </span></td>

+ <td class="row2"><select name="lang"><?php echo inst_language_select($language); ?></select></td>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['ADMIN_USERNAME']; ?>: </span></td>

+ <td class="row2"><input class="post" type="text" name="admin_name" value="<?php echo ($admin_name != '') ? $admin_name : ''; ?>" /></td>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['ADMIN_EMAIL']; ?>: </span></td>

+ <td class="row2"><input class="post" type="text" name="board_email1" value="<?php echo ($board_email1 != '') ? $board_email1 : ''; ?>" /></td>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['ADMIN_EMAIL_CONFIRM']; ?>: </span></td>

+ <td class="row2"><input class="post" type="text" name="board_email2" value="<?php echo ($board_email2 != '') ? $board_email2 : ''; ?>" /></td>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['ADMIN_PASSWORD']; ?>: </span></td>

+ <td class="row2"><input class="post" type="password" name="admin_pass1" value="<?php echo ($admin_pass1 != '') ? $admin_pass1 : ''; ?>" /></td>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['ADMIN_PASSWORD_CONFIRM']; ?>: </span></td>

+ <td class="row2"><input class="post" type="password" name="admin_pass2" value="<?php echo ($admin_pass2 != '') ? $admin_pass2 : ''; ?>" /></td>

+ <td class="cat" colspan="2">&nbsp;</td>

+</table>

+

+<br clear="all" />

+

+<table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

+ <th colspan="2"><?php echo $lang['DB_CONFIG']; ?></th>

+ if (sizeof($error['db']))

+ <td class="row3" colspan="2" align="center"><span class="gen" style="color:red"><?php echo implode('<br />', $error['db']); ?></span></td>

+ <td class="row1" width="50%"><b><?php echo $lang['DBMS']; ?>: </b></td>

+ <td class="row2"><select name="dbms" onchange="if (document.install_form.upgrade.options[upgrade.selectedIndex].value == 1) { document.install_form.dbms.selectedIndex=0}"><?php echo $dbms_options; ?></select></td>

+ <td class="row1" width="50%"><b><?php echo $lang['DB_HOST']; ?>: </b><br /><span class="gensmall">DSN stands for Data Source Name and is relevant only for ODBC installs.</span></td>

+ <td class="row2"><input class="post" type="text" name="dbhost" value="<?php echo ($dbhost != '') ? $dbhost : ''; ?>" /></td>

+ <td class="row1" width="50%"><b><?php echo 'Database Server Port' . $lang['DB_PORT']; ?>: </b><br /><span class="gensmall">Leave this blank unless you know the server operates on a non-standard port.</span></td>

+ <td class="row2"><input class="post" type="text" name="dbport" value="<?php echo ($dbport != '') ? $dbport : ''; ?>" /></td>

+ <td class="row1" width="50%"><b><?php echo $lang['DB_NAME']; ?>: </b></td>

+ <td class="row2"><input class="post" type="text" name="dbname" value="<?php echo ($dbname != '') ? $dbname : ''; ?>" /></td>

+ <td class="row1" width="50%"><b><?php echo $lang['DB_USERNAME']; ?>: </b></td>

+ <td class="row2"><input class="post" type="text" name="dbuser" value="<?php echo ($dbuser != '') ? $dbuser : ''; ?>" /></td>

+ <td class="row1" width="50%"><b><?php echo $lang['DB_PASSWORD']; ?>: </b></td>

+ <td class="row2"><input class="post" type="password" name="dbpasswd" value="<?php echo ($dbpasswd != '') ? $dbpasswd : ''; ?>" /></td>

+ </tr>

+ <td class="row1" width="50%"><b><?php echo $lang['TABLE_PREFIX']; ?>: </b></td>

+ <td class="row2"><input class="post" type="text" name="table_prefix" value="<?php echo (!empty($table_prefix)) ? $table_prefix : 'phpbb_'; ?>" /></td>

+ <td class="cat" colspan="2" align="center"><input class="liteoption" type="submit" name="testdb" value="Test Connection" /></td>

+ </tr>

+</table>

+

+<br clear="all" />

+

+<table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

+ <tr>

+ <th colspan="2">Server Configuration<?php echo $lang['SERVER_CONFIG']; ?></th>

+ if (sizeof($error['server']))

+ {

+?>

+ <tr>

+ <td class="row3" colspan="2" align="center"><span class="gen" style="color:red"><?php echo implode('<br />', $error['server']); ?></span></td>

+ </tr>

+<?php

+ }

+?>

+ <tr>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['SERVER_NAME']; ?>: </span></td>

+ <td class="row2"><input class="post" type="text" name="server_name" value="<?php echo $server_name; ?>" /></td>

+ </tr>

+ <tr>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['SERVER_PORT']; ?>: </span></td>

+ <td class="row2"><input class="post" type="text" name="server_port" value="<?php echo $server_port; ?>" /></td>

+ </tr>

+ <tr>

+ <td class="row1" width="50%"><span class="gen"><?php echo $lang['SCRIPT_PATH']; ?>: </span></td>

+ <td class="row2"><input class="post" type="text" name="script_path" value="<?php echo $script_path; ?>" /></td>

+ </tr>

+ <tr>

+ <td class="cat" colspan="2" align="center"><?php echo $s_hidden_fields; ?><input class="mainoption" name="install" type="submit" value="Start Install" /></td>

+ </tr>

+</table></form>

+<?php

+

+ inst_page_footer();

+

+

+

+

+

+// Here we attempt to write out the config file. If we cannot write it directly

+// we'll offer the user various options

+if ($stage == 2)

+ $load_extensions = array();

+ $check_exts = array_merge($available_dbms[$dbms]['MODULE'], $php_dlls_other);

+ foreach ($check_exts as $dll)

+ {

+ if (!extension_loaded($dll))

+ {

+ if (!@ini_get('enable_dl') || strtolower(@ini_get('enable_dl')) == 'off' || @ini_get('safe_mode') || strtolower(@ini_get('safe_mode')) == 'on' || !@dl($dll . ".$suffix"))

+ {

+ continue;

+ }

+ $load_extensions[] = "$dll.$suffix";

+ }

+ $load_extensions = implode(',', $load_extensions);

+

+ // Write out the config file.

+ $config_data = "<?php\n";

+ $config_data .= "// phpBB 2.x auto-generated config file\n// Do not change anything in this file!\n";

+ $config_data .= "\$dbms = '$dbms';\n";

+ $config_data .= "\$dbhost = '$dbhost';\n";

+ $config_data .= "\$dbport = '$dbport';\n";

+ $config_data .= "\$dbname = '$dbname';\n";

+ $config_data .= "\$dbuser = '$dbuser';\n";

+ $config_data .= "\$dbpasswd = '$dbpasswd';\n\n";

+ $config_data .= "\$table_prefix = '$table_prefix';\n";

+ $config_data .= "\$acm_type = 'file';\n";

+ $config_data .= "\$load_extensions = '$load_extensions';\n\n";

+ $config_data .= "define('PHPBB_INSTALLED', true);\n";

+ $config_data .= "define('DEBUG', true);\n"; // Comment out when final

+ $config_data .= '?' . '>'; // Done this to prevent highlighting editors getting confused!

+

+ $stage = 3;

+/*

+ // Attempt to write out the config directly ...

+ if (is_writeable($phpbb_root_path . 'config.'.$phpEx))

+ // Lets jump to the DB setup stage ... if nothing goes wrong below

+ $stage = 3;

+ if (!($fp = @fopen($phpbb_root_path . 'config.'.$phpEx, 'w')))

+ // Something went wrong ... so let's try another method

+ $stage = 2;

+ }

+ if (!(@fwrite($fp, $config_data)))

+ {

+ // Something went wrong ... so let's try another method

+ $stage = 2;

+ }

+

+ @fclose($fp);

+ }

+*/

+ if ($stage == 2)

+ {

+ $ignore_ftp = false;

+

+ // User is trying to upload via FTP ... so let's process it

+ if (isset($_POST['sendftp']))

+ {

+ if (($conn_id = @ftp_connect('localhost')))

+ if (@ftp_login($conn_id, $ftp_user, $ftp_pass))

+ // Write out a temp file...

+ $tmp_path = (!@ini_get('safe_mode')) ? false : './' . $config['avatar_path'] . '/tmp';

+ $filename = tempnam($tmp_path, uniqid(rand()) . 'cfg');

+

+ $fp = @fopen($filename, 'w');

+ @fwrite($fp, $config_data);

+ @fclose($fp);

+

+ if (@ftp_chdir($conn_id, $ftp_dir))

+ {

+

+ // Now ftp it across ... if it works, jump to next stage ... else

+ // we'll offer more options

+ if (@ftp_put($conn_id, 'config.' . $phpEx, $filename, FTP_ASCII))

+ {

+ $stage = 3;

+ }

+ else

+ {

+ $ignore_ftp = true;

+ }

+ }

+ else

+ {

+ $error['ftp'][] = 'Could not change to the given directory, please check the path.';

+ }

+ $error['ftp'][] = 'Could not login to ftp server, check your username and password';

+ @ftp_quit($conn_id);

+ }

+ else if (isset($_POST['dlftp']))

+ {

+ header("Content-Type: text/x-delimtext; name=\"config.$phpEx\"");

+ header("Content-disposition: attachment; filename=config.$phpEx");

+ echo $config_data;

+ exit;

+ }

+

+ if ($stage == 2)

+ {

+ inst_page_header($instruction_text, "install.$phpEx");

+

+?>

+

+<p>Unfortunately phpBB could not write the configuration information directly to your config.php. This may be because the file does not exist or is not writeable. A number of options will be listed below enabling you to complete installation of config.php.</p>

+

+<?php

+

+ $s_hidden_fields = '<input type="hidden" name="stage" value="2" />';

+ $s_hidden_fields .= '<input type="hidden" name="dbms" value="' . $dbms . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="table_prefix" value="' . $table_prefix . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="dbhost" value="' . $dbhost . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="dbport" value="' . $dbport . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="dbname" value="' . $dbname . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="dbuser" value="' . $dbuser . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="dbpasswd" value="' . $dbpasswd . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="admin_name" value="' . $admin_name . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="admin_pass1" value="' . $admin_pass1 . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="admin_pass2" value="' . $admin_pass2 . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="server_port" value="' . $server_port . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="server_name" value="' . $server_name . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="script_path" value="' . $script_path . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="board_email1" value="' . $board_email1 . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="board_email2" value="' . $board_email2 . '" />';

+ $s_hidden_fields .= '<input type="hidden" name="language" value="' . $language . '" />';

+

+ // Can we ftp? If we can then let's offer that option on top of download

+ // We first see if the relevant extension is loaded and then whether a server is

+ // listening on the ftp port

+ if (extension_loaded('ftp') && ($fsock = @fsockopen('localhost', 21, $errno, $errstr, 1)) && !$ignore_ftp)

+ @fclose($fsock);

+

+?>

+

+<h1>Transfer config.php by FTP</h1>

+

+<p>phpBB has detected the presence of the ftp module on this server. You may attempt to install your config.php via this if you wish. You will need to supply the information listed below. Remember your username and password are those to your server! (ask your hosting provider for details if you are unsure what these are)</p>

+

+<table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

+ <tr>

+ <th colspan="2">&nbsp;</th>

+ </tr>

+<?php

+

+ if (sizeof($error['ftp']))

+

+?>

+ <tr>

+ <td class="row3" colspan="2" align="center"><span class="gen" style="color:red"><?php echo implode('<br />', $error['ftp']); ?></span></td>

+ </tr>

+<?php

+

+

+?>

+ <tr>

+ <td class="row1" width="50%"><b><?php echo $lang['FTP_PATH']; ?>: </b><br /><span class="gensmall">This is the path from your root directory to that of phpBB2, e.g. htdocs/phpBB2/</span></td>

+ <td class="row2"><input class="post" type="text" name="ftp_dir" size="40" maxlength="255" value="<?php echo $ftp_dir; ?>" /></td>

+ </tr>

+ <tr>

+ <td class="row1" width="50%"><b><?php echo $lang['FTP_USERNAME']; ?>: </b></td>

+ <td class="row2"><input class="post" type="text" name="ftp_user" size="40" maxlength="255" value="<?php echo $ftp_user; ?>" ></td>

+ </tr>

+ <tr>

+ <td class="row1" width="50%"><b><?php echo $lang['FTP_PASSWORD']; ?>: </b></td>

+ <td class="row2"><input class="post" type="password" name="ftp_pass" size="40" maxlength="255" value="<?php echo $ftp_pass; ?>" ></td>

+ </tr>

+ <tr>

+ <td class="cat" colspan="2" align="center"><input class="mainoption" name="sendftp" type="submit" value="Upload" /></td>

+ </tr>

+</table>

+

+<br />

+

+<?php

+

+?>

+

+<h1>Download config.php</h1>

+

+<p>You may download the complete config.php to your own PC. You will then need to upload the file manually, replacing any existing config.php in your phpBB 2.2 root directory. Please remember to upload the file in ASCII format (see your FTP application documentation if you are unsure how to achieve this). When you have uploaded the config.php please click "Done" to move to the next stage.</p>

+

+<table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

+ <tr>

+ <td class="cat" align="center"><input class="mainoption" name="dlftp" type="submit" value="Download" /> &nbsp;&nbsp; <input class="mainoption" name="dldone" type="submit" value="Done" /></td>

+ </tr>

+</table>

+

+<br />

+

+<h1>Retry automatic writing of config.php</h1>

+

+<p>If you wish you can change the permissions on config.php to allow phpBB to write to it. Should you wish to do that you can click Retry below to try again. Remember to return the permissions on config.php after phpBB2 has finished installation.</p>

+

+<table class="bg" width="80%" cellspacing="1" cellpadding="4" border="0" align="center">

+ <tr>

+ <td class="cat" align="center"><input class="mainoption" name="retry" type="submit" value="Retry" /></td>

+ </tr>

+</table>

+

+<?php echo $s_hidden_fields; ?></form>

+

+<?php

+

+

+}

+

+

+

+

+

+

+

+

+

+

+// Do the installation

+if ($stage == 3)

+{

+ if (!extension_loaded($available_dbms[$dbms]['MODULE']))

+ {

+ @dl($available_dbms[$dbms]['MODULE'] . ".$prefix");

+ }

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

+ if ($dbms != 'msaccess')

+ // NOTE: trigger_error does not work here.

+ $db->return_on_error = true;

+

+ $ignore_tables = array();

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

+ // and work on building the table.. probably ought to provide some

+ // kind of feedback to the user as we are working here in order

+ // to let them know we are actually doing something.

+ $sql_query = @fread(@fopen($dbms_schema, 'r'), @filesize($dbms_schema));

+ $sql_query = preg_replace('#phpbb_#is', $table_prefix, $sql_query);

+

+ $sql_query = $remove_remarks($sql_query);

+ $sql_query = split_sql_file($sql_query, $delimiter);

+ $sql_count = count($sql_query);

+

+ foreach ($sql_query as $sql)

+ $sql = trim($sql);

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

+ $ignore_tables[] = preg_replace('#^CREATE TABLE ([a-z_]+?) .*$#is', '\1', $sql);

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

+ }

+ }

+ $ignore_tables = str_replace('\\|', '|', preg_quote(implode('|', $ignore_tables), '#'));

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

+ $sql_query = @fread(@fopen($dbms_basic, 'r'), @filesize($dbms_basic));

+ $sql_query = preg_replace('#phpbb_#', $table_prefix, $sql_query);

+ $sql_query = $remove_remarks($sql_query);

+ $sql_query = split_sql_file($sql_query, $delimiter_basic);

+ $sql_count = count($sql_query);

+ foreach ($sql_query as $sql)

+ {

+ $sql = trim(str_replace('|', ';', $sql));

+ if (preg_match('#' . $ignore_tables . '#i', $sql))

+ {

+ continue;

+ echo "\nMATCH >> " . $sql;

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

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

+ }

+ $current_time = time();

+ // Set default config and post data

+ $sql_ary = array(

+ 'INSERT INTO ' . $table_prefix . "config (config_name, config_value)

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

+ 'INSERT INTO ' . $table_prefix . "config (config_name, config_value)

+ VALUES ('default_lang', '" . $db->sql_escape($language) . "')",

+ 'UPDATE ' . $table_prefix . "config

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

+ WHERE config_name = 'server_name'",

+ 'UPDATE ' . $table_prefix . "config

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

+ WHERE config_name = 'server_port'",

+ 'UPDATE ' . $table_prefix . "config

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

+ WHERE config_name = 'script_path'",

+

+ 'UPDATE ' . $table_prefix . "config

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

+ WHERE config_name = 'board_email'",

+

+ 'UPDATE ' . $table_prefix . "config

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

+ WHERE config_name = 'cookie_domain'",

+

+ 'UPDATE ' . $table_prefix . "config

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

+ WHERE config_name = 'newest_username'",

+

+ 'UPDATE ' . $table_prefix . "users

+ SET username = '" . $db->sql_escape($admin_name) . "', user_password='" . $db->sql_escape(md5($admin_pass1)) . "', user_lang = '" . $db->sql_escape($language) . "', user_email='" . $db->sql_escape($board_email) . "'

+ WHERE username = 'Admin'",

+

+ 'UPDATE ' . $table_prefix . "moderator_cache

+ SET username = '" . $db->sql_escape($admin_name) . "'

+ WHERE username = 'Admin'",

+

+ 'UPDATE ' . $table_prefix . "forums

+ SET forum_last_poster_name = '" . $db->sql_escape($admin_name) . "'

+ WHERE forum_last_poster_name = 'Admin'",

+ 'UPDATE ' . $table_prefix . "topics

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

+ WHERE topic_first_poster_name = 'Admin'

+ OR topic_last_poster_name = 'Admin'",

+ 'UPDATE ' . $table_prefix . "users

+ SET user_regdate = $current_time",

+

+ 'UPDATE ' . $table_prefix . "posts

+ SET post_time = $current_time",

+

+ 'UPDATE ' . $table_prefix . "topics

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

+

+ 'UPDATE ' . $table_prefix . "forums

+ SET forum_last_post_time = $current_time",

+

+ );

+

+ foreach ($sql_ary as $sql)

+ {

+ $sql = trim(str_replace('|', ';', $sql));

+ if (preg_match('#' . $ignore_tables . '#i', $sql))

+ {

+ continue;

+ echo "\nMATCH >> " . $sql;

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

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

+ }

+ $stage = 4;

+}

+// Install completed ... log the user in ... we're done

+if ($stage == 4)

+{

+ // Load the basic configuration data

+ define('SESSIONS_TABLE', $table_prefix . 'sessions');

+ define('USERS_TABLE', $table_prefix . 'users');

+ $sql = "SELECT *

+ FROM {$table_prefix}config";

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

+ $config = array();

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

+ {

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

+ $db->sql_freeresult($result);

+

+

+ $user->start();

+ $auth->login($admin_name, $admin_pass1);

+

+ echo $admin_name . " :: ". $admin_pass1 . " :: ";

+

+echo '<a href="../adm/index.' . $phpEx . $SID . '">HERE</a>';

+exit;

+

+

+

+

+

+<form action="<?php echo $s_action; ?>" name="install_form" method="post">

+function inst_page_footer()

+ $user = array();

+ while ($file = readdir($dir))

+ {

+

+ {

+ continue;

+ }

+ list($displayname) = @file($path . '/iso.txt');

+ $lang[$displayname] = $file;

+ }

+ }

+ @closedir($dir);

+

+ @asort($lang);

+ @reset($lang);

+

+ foreach ($lang as $displayname => $filename)

+ {

+ $user_select .= '<option value="' . $filename . '"' . $selected . '>' . ucwords($displayname) . '</option>';

+