+<?php

+/***************************************************************************

+ * install.php

+ * -------------------

+ * begin : Tuesday, Sept 11, 2001

+ * copyright : (C) 2001 The phpBB Group

+ * email : supportphpbb.com

+ *

+ * $Id$

+ *

+ ***************************************************************************/

+

+/***************************************************************************

+ *

+ * This program is free software; you can redistribute it and/or modify

+ * it under the terms of the GNU General Public License as published by

+ * the Free Software Foundation; either version 2 of the License, or

+ * (at your option) any later version.

+ *

+ ***************************************************************************/

+$phpbb_root_path = '';

+//

+// Initialize a couple of needed variables. It really doesn't matter what we

+// put in userdata... It just has to be set so that message_die will work.

+// Basically all of the following variables are to setup the template engine.

+//

+$userdata = "some false data";

+$theme = array(

+ 'themes_id' => '2',

+ 'themes_name' => 'Default',

+ 'template_name' => 'Default',

+ 'td_color1' => 'CCCCCC',

+ 'td_color2' => 'DDDDDD'

+);

+$default_language = 'english';

+$default_template = 'Default';

+

+$available_dbms[] = array(

+ "LABEL" => "MySQL",

+ "VALUE" => "mysql"

+);

+$available_dbms[] = array(

+ "LABEL" => "MS SQL",

+ "VALUE" => "mssql"

+);

+$available_dbms[] = array(

+ "LABEL" => "Postgres",

+ "VALUE" => "postgres"

+);

+$available_dbms[] = array(

+ "LABEL" => "ODBC - MSAccess",

+ "VALUE" => "odbc:access"

+);

+$available_dbms[] = array(

+ "LABEL" => "ODBC - DB2",

+ "VALUE" => "odbc:db2"

+);

+$available_lang[] = 'english';

+?>

+<?php

+/***************************************************************************

+ * install.php

+ * -------------------

+ * begin : Tuesday, Sept 11, 2001

+ * copyright : (C) 2001 The phpBB Group

+ * email : supportphpbb.com

+ *

+ * $Id$

+ *

+ ***************************************************************************/

+

+/***************************************************************************

+ *

+ * This program is free software; you can redistribute it and/or modify

+ * it under the terms of the GNU General Public License as published by

+ * the Free Software Foundation; either version 2 of the License, or

+ * (at your option) any later version.

+ *

+ ***************************************************************************/

+$phpbb_root_path='./';

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

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

+

+$language = ($HTTP_POST_VARS['language']) ? $HTTP_POST_VARS['language'] : $default_language;

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

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

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

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

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

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

+

+//

+// Create an instance of the template class.

+//

+$template = new Template($phpbb_root_path . "templates/" . $default_template);

+

+

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

+{

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

+}

+if($installed)

+{

+ //

+ // Sorry this has already been installed can't do anything more with it

+ //

+ $template->set_filenames(array(

+ "body" => "install_error.tpl")

+ );

+ $template->assign_vars(array(

+ "L_TITLE" => $lang['Installer_Error'],

+ "L_ERROR" => $lang['Previous_Install'])

+ );

+ $template->pparse('body');

+ die();

+}

+//

+// 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.

+//

+$installStep = ($HTTP_POST_VARS['installStep']) ? $HTTP_POST_VARS['installStep']: $HTTP_GET_VARS['installStep'];

+$dbms = ($HTTP_POST_VARS['dbms']);

+if( !isset($installStep) || $installStep == 0)

+{

+ //

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

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

+ //

+ $template->set_filenames(array(

+ "body" => "install.tpl")

+ );

+ $template->assign_vars(array(

+ "L_INSTRUCT" => $lang['Inst_Step_0'],

+ "L_SUBMIT" => $lang['Start_Install'],

+ "S_FORM_ACTION" => 'install.'.$phpEx)

+ );

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => "installStep",

+ "VALUE" => "1")

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "dbhost",

+ "L_LABEL" => $lang['DB_Host'] . ':')

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "dbname",

+ "L_LABEL" => $lang['DB_Name'] . ':')

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "dbuser",

+ "L_LABEL" => $lang['Database'] . ' ' . $lang['Username'] . ':')

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "dbpasswd",

+ "L_LABEL" => $lang['Database'] . ' ' . $lang['Password'] . ':')

+ );

+ $template->assign_block_vars("selects", array(

+ "NAME" => "language",

+ "L_LABEL" => $lang['Install_lang'])

+ );

+ for($i = 0; $i < count($available_lang); $i++)

+ {

+ $template->assign_block_vars("selects.options", array(

+ "LABEL" => $available_lang[$i],

+ "VALUE" => $available_lang[$i])

+ );

+ }

+ $template->assign_block_vars("selects", array(

+ "NAME" => "dbms",

+ "L_LABEL" => $lang['dbms'])

+ );

+ for($i = 0; $i < count($available_dbms); $i++)

+ {

+ $template->assign_block_vars("selects.options", array(

+ "LABEL" => $available_dbms[$i]['LABEL'],

+ "VALUE" => $available_dbms[$i]['VALUE'])

+ );

+ }

+ $template->pparse("body");

+ exit();

+}

+//

+// If the dbms is set to be odbc then we need to skip most of the

+// steps and go straight to writing the config file. We'll spit

+// out some additional instructions later on what to do after installation

+// for the odbc DBMS.

+//

+if (ereg(':', $dbms) && $installStep < 2)

+{

+ $dbms = explode(':', $dbms);

+ $dbhost = $dbms[1] . ':' . $dbhost;

+ $dbms = $dbms[0];

+ $installStep = 2;

+}

+elseif ( isset($dbms) )

+{

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

+}

+

+$dbms_schema = 'db/'.$dbms.'_schema.sql';

+$dbms_basic = 'db/'.$dbms.'_basic.sql';

+$remove_remarks = ($dbms == 'mysql')?'remove_remarks':'remove_comments';

+$delimiter = ( $dbms == 'mssql' )?'GO':';';

+switch ( $installStep )

+{

+ case 1:

+ //

+ // 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 = $remove_remarks($sql_query);

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

+ $sql_count = count($sql_query);

+ for($i = 0; $i < $sql_count; $i++)

+ {

+ $result = $db->sql_query($sql_query[$i]);

+ if( !$result )

+ {

+ $template->set_filenames(array(

+ "body" => "install_error.tpl")

+ );

+ $template->assign_vars(array(

+ "L_TITLE" => $lang['Installer_Error'],

+ "L_ERROR" => $lang['Install_db_error'])

+ );

+ $template->pparse('body');

+ die();

+ }

+ }

+ //

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

+ //

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

+ $sql_query = $remove_remarks($sql_query);

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

+ $sql_count = count($sql_query);

+ for($i = 0; $i < $sql_count; $i++)

+ {

+ $result = $db->sql_query($sql_query[$i]);

+ if( !$result )

+ {

+ $template->set_filenames(array(

+ "body" => "install_error.tpl")

+ );

+ $template->assign_vars(array(

+ "L_TITLE" => $lang['Installer_Error'],

+ "L_ERROR" => $lang['Install_db_error'])

+ );

+ $template->pparse('body');

+ die();

+ }

+ }

+ //

+ // Then let's prompt for an admin username and password.

+ //

+ $template->set_filenames(array(

+ "body" => "install.tpl")

+ );

+ $template->assign_vars(array(

+ "L_INSTRUCT" => $lang['Inst_Step_1'],

+ "L_SUBMIT" => $lang['Create_User'],

+ "S_FORM_ACTION" => 'install.'.$phpEx)

+ );

+ //

+ // Carry over all of the variables from the last form.

+ //

+ reset( $HTTP_POST_VARS );

+ while( list( $key, $val ) = each( $HTTP_POST_VARS ))

+ {

+ if( $key != 'installStep' )

+ {

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => $key,

+ "VALUE" => $val)

+ );

+ }

+ }

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => "installStep",

+ "VALUE" => "2")

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "admin_name",

+ "L_LABEL" => $lang['Username'])

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "admin_pass1",

+ "L_LABEL" => $lang['Password'])

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "admin_pass2",

+ "L_LABEL" => $lang['Confirm'] . ' ' . $lang['Password'])

+ );

+ $template->pparse('body');

+ exit();

+ break;

+ case 2:

+ //

+ // Ok at this point they have entered their admin password, let's go

+ // ahead and create the admin account with some basic default information

+ // that they can customize later, and write out the config file. After

+ // this we are going to pass them over to the admin_forum.php script

+ // to set up their forum defaults.

+ //

+ if( $dbms == 'odbc' )

+ {

+ //

+ // Output the instructions for the odbc...

+ //

+ $template->set_filenames(array(

+ "body" => "install.tpl")

+ );

+

+ $template->assign_vars(array(

+ "L_INSTRUCT" => $lang['ODBC_Instructs'],

+ "L_SUBMIT" => $lang['OK'],

+ "S_FORM_ACTION" => 'install.'.$phpEx)

+ );

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => "installStep",

+ "VALUE" => '3')

+ );

+ exit();

+ }

+ if( $HTTP_POST_VARS['admin_pass1'] != $HTTP_POST_VARS['admin_pass2'] )

+ {

+ $template->set_filenames(array(

+ "body" => "install.tpl")

+ );

+ $template->assign_vars(array(

+ "L_INSTRUCT" => $lang['Password_mismatch'].'<br>'.$lang['Inst Step 1'],

+ "L_SUBMIT" => $lang['Create_User'],

+ "S_FORM_ACTION" => 'install.'.$phpEx)

+ );

+ $template->pparse("body");

+ exit();

+ //

+ // Output the current PostVars

+ //

+ reset( $HTTP_POST_VARS );

+ while( list( $key, $val ) = each( $HTTP_POST_VARS ))

+ {

+ if( $key != 'installStep' )

+ {

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => $key,

+ "VALUE" => $val)

+ );

+ }

+ }

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => "installStep",

+ "VALUE" => "2")

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "admin_name",

+ "LABEL" => $lang['Username'])

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "admin_pass1",

+ "LABEL" => $lang['Password'])

+ );

+ $template->assign_block_vars("inputs", array(

+ "NAME" => "admin_pass2",

+ "LABEL" => $lang['Confirm'] . ' ' . $lang['Password'])

+ );

+ $template->pparse('body');

+ exit();

+ }

+ else

+ {

+ //

+ // Update the default admin user with their information.

+ //

+ $sql = "UPDATE phpbb_users

+ SET username='".$HTTP_POST_VARS['admin_name']."',

+ user_password='".md5($HTTP_POST_VARS['admin_pass1'])."'

+ WHERE username = 'Admin'";

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

+ if( !$result )

+ {

+ $template->set_filenames(array(

+ "body" => "install_error.tpl")

+ );

+ $template->assign_vars(array(

+ "L_TITLE" => $lang['Installer_Error'],

+ "L_ERROR" => $lang['Install_db_error']. mysql_error())

+ );

+ $template->pparse('body');

+ die();

+ }

+ //

+ // Write out the config file.

+ //

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

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

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

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

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

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

+ $config_data.= '$installed = True;'."\n";

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

+ $config_data.= '?>';

+ @umask(0111);

+ $fp = fopen('config.php', 'w');

+ $result = fputs($fp, $config_data, strlen($config_data));

+ fclose($fp);

+ //

+ // Ok we are basically done with the install process let's go on

+ // and let the user configure their board now.

+ // We are going to do this by calling the admin_board.php from the

+ // normal board admin section.

+ //

+ $template->set_filenames(array(

+ "body" => "install.tpl")

+ );

+ $template->assign_vars(array(

+ "L_INSTRUCT" => $lang['Inst_Step_2'],

+ "L_SUBMIT" => $lang['Finish_Install'],

+ "S_FORM_ACTION" => 'login.'.$phpEx)

+ );

+

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => 'username',

+ "VALUE" => $admin_name)

+ );

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => 'password',

+ "VALUE" => $admin_pass1)

+ );

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => 'submit',

+ "VALUE" => 'Login')

+ );

+ $template->assign_block_vars("hidden_fields", array(

+ "NAME" => 'forward_page',

+ "VALUE" => 'admin/admin_board.'.$phpEx.'?mode=config')

+ );

+ $template->pparse('body');

+ exit();

+ }

+ break;

+}

+// Install Process

+//

+$lang['Installer_Error'] = "An error has occured during installation.";

+$lang['Previous_Install'] = "A previous installtion has been detected.";

+$lang['Inst_Step_0'] = "Thank you for choosing phpBB version 2. Please select your chosen database server, and enter the information for your database server host, database name, username, and password. NOTE: The database should already exist.";

+$lang['Start_Install'] = "Start Install";

+$lang['DB_Host'] = "Database Server Hostname";

+$lang['DB_Name'] = "Your Database Name";

+$lang['Database'] = "Your Database";

+$lang['Install_lang'] = "Choose Language for Installation";

+$lang['dbms'] = "Database Type";

+$lang['Inst_Step_1'] = "Your database tables have been created and filled with some basic default data. Please enter your chosen phpBB Admin Username and Password.";

+$lang['Create_User'] = "Create User";

+$lang['Inst_Step_2'] = "Your admin username has been created. At this point your installation is basically completed, you will now be taken to a screen which will allow you to specify some basic default settings for your board.";

+$lang['Finish_Install'] = "Finish Installation";

+$lang['Install_db_error'] = "An error occured trying to update the database";

+$lang['ODBC_Instructs'] = "Someone please write some odbc instructions in the \$lang['ODBC_Instructs'] variable!";

+

+

+//

+?>

+<HTML>

+<HEAD>

+ <TITLE>phpBB Version 2.0 Installation</TITLE>

+</HEAD>

+<BODY BACKGROUND="WHITE">

+ <FORM action='{S_FORM_ACTION}' method="post" >

+ <!-- BEGIN hidden_fields -->

+ <input type="hidden" name='{hidden_fields.NAME}' value='{hidden_fields.VALUE}'>

+ <!-- END hidden_fields -->

+ <table>

+ <tr>

+ <td>{L_INSTRUCT}</td>

+ </tr>

+ </table>

+ <table>

+ <!-- BEGIN selects -->

+ <tr>

+ <td align="right">{selects.L_LABEL}</td>

+ <td><select name='{selects.NAME}'>

+ <!-- BEGIN options -->

+ <option value='{selects.options.VALUE}'>{selects.options.LABEL}</option>

+ <!-- END options -->

+ </td>

+ </tr>

+ <!-- END selects -->

+ <!-- BEGIN inputs -->

+ <tr>

+ <td align="right">{inputs.L_LABEL}</td>

+ <td><input type="text" name="{inputs.NAME}"></td>

+ </tr>

+ <!-- END inputs -->

+ <tr>

+ <td align="center" colspan="2"><input type="submit" value="{L_SUBMIT}"></td>

+ </tr>

+ </table>

+ </FORM>

+</BODY>

+</HTML>

+<html>

+<head>

+ <title>phpBB Version 2.0 Installer</title>

+</head>

+<body background="white">

+<table>

+<tr>

+ <td>

+ <H1>{L_TITLE}</H1>

+ </td>

+</tr>

+<tr>

+ <td>

+ <table border="0" align="center" width="100%" bgcolor="#000000" cellpadding="0" cellspacing="1">

+ <tr>

+ <td>

+ <table border="0" width="100%" cellpadding="0" cellspacing="1">

+ <tr class="tableheader">

+ <td width="100%" align="center"><b>{L_ERROR}<b></td>

+ </tr>

+ </table>

+ </td>

+ </tr>

+ </table>

+ </td>

+</tr>

+</table>

+</body>

+</html>