2 /***************************************************************************
5 * begin : Tuesday, Sept 11, 2001
6 * copyright : (C) 2001 The phpBB Group
7 * email : support@phpbb.com
9 * $Id: install.php,v 1.6.2.14 2005/12/29 11:51:11 acydburn Exp $
11 ***************************************************************************/
13 /***************************************************************************
15 * This program is free software; you can redistribute it and/or modify
16 * it under the terms of the GNU General Public License as published by
17 * the Free Software Foundation; either version 2 of the License, or
18 * (at your option) any later version.
20 ***************************************************************************/
25 function page_header($text, $form_action = false)
30 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
33 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $lang['ENCODING']; ?>">
34 <meta http-equiv="Content-Style-Type" content="text/css">
35 <title><?php echo $lang['Welcome_install'];?></title>
36 <link rel="stylesheet" href="../templates/subSilver/subSilver.css" type="text/css">
37 <style type="text/css">
39 th { background-image: url('../templates/subSilver/images/cellpic3.gif') }
40 td.cat { background-image: url('../templates/subSilver/images/cellpic1.gif') }
41 td.rowpic { background-image: url('../templates/subSilver/images/cellpic2.jpg'); background-repeat: repeat-y }
42 td.catHead,td.catSides,td.catLeft,td.catRight,td.catBottom { background-image: url('../templates/subSilver/images/cellpic1.gif') }
44 /* Import the fancy styles for IE only (NS4.x doesn't use the @import function) */
45 @import url("../templates/subSilver/formIE.css");
49 <body bgcolor="#E5E5E5" text="#000000" link="#006699" vlink="#5584AA">
51 <table width="100%" border="0" cellspacing="0" cellpadding="10" align="center">
53 <td class="bodyline" width="100%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
55 <td><table width="100%" border="0" cellspacing="0" cellpadding="0">
57 <td><img src="../templates/subSilver/images/logo_phpBB.gif" border="0" alt="Forum Home" vspace="1" /></td>
58 <td align="center" width="100%" valign="middle"><span class="maintitle"><?php echo $lang['Welcome_install'];?></span></td>
66 <td colspan="2"><table width="90%" border="0" align="center" cellspacing="0" cellpadding="0">
68 <td><span class="gen"><?php echo $text; ?></span></td>
76 <td width="100%"><table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline"><form action="<?php echo ($form_action) ? $form_action : 'install.'.$phpEx; ?>" name="install" method="post">
81 function page_footer()
97 function page_common_form($hidden, $submit)
102 <td class="catBottom" align="center" colspan="2"><?php echo $hidden; ?><input class="mainoption" type="submit" value="<?php echo $submit; ?>" /></td>
108 function page_upgrade_form()
114 <td class="catBottom" align="center" colspan="2"><?php echo $lang['continue_upgrade']; ?></td>
117 <td class="catBottom" align="center" colspan="2"><input type="submit" name="upgrade_now" value="<?php echo $lang['upgrade_submit']; ?>" /></td>
123 function page_error($error_title, $error)
128 <th><?php echo $error_title; ?></th>
131 <td class="row1" align="center"><span class="gen"><?php echo $error; ?></span></td>
137 // Guess an initial language ... borrowed from phpBB 2.2 it's not perfect,
138 // really it should do a straight match first pass and then try a "fuzzy"
139 // match on a second pass instead of a straight "fuzzy" match.
140 function guess_lang()
142 global $phpbb_root_path, $HTTP_SERVER_VARS;
144 // The order here _is_ important, at least for major_minor
145 // matches. Don't go moving these around without checking with
148 'arabic' => 'ar([_-][a-z]+)?',
153 'german' => 'de([_-][a-z]+)?',
154 'english' => 'en([_-][a-z]+)?',
157 'french' => 'fr([_-][a-z]+)?',
159 'spanish_argentina' => 'es[_-]ar',
160 'spanish' => 'es([_-][a-z]+)?',
169 'indonesian' => 'id([_-][a-z]+)?',
170 'italian' => 'it([_-][a-z]+)?',
171 'japanese' => 'ja([_-][a-z]+)?',
172 'korean' => 'ko([_-][a-z]+)?',
174 'lithuanian' => 'lt',
175 'macedonian' => 'mk',
176 'dutch' => 'nl([_-][a-z]+)?',
180 'portuguese_brazil' => 'pt[_-]br',
181 'portuguese' => 'pt([_-][a-z]+)?',
182 'romanian' => 'ro([_-][a-z]+)?',
183 'russian' => 'ru([_-][a-z]+)?',
184 'slovenian' => 'sl([_-][a-z]+)?',
186 'serbian' => 'sr([_-][a-z]+)?',
187 'slovak' => 'sv([_-][a-z]+)?',
188 'swedish' => 'sv([_-][a-z]+)?',
189 'thai' => 'th([_-][a-z]+)?',
190 'turkish' => 'tr([_-][a-z]+)?',
191 'ukranian' => 'uk([_-][a-z]+)?',
193 'viatnamese' => 'vi',
194 'chinese_traditional_taiwan'=> 'zh[_-]tw',
195 'chinese_simplified' => 'zh',
198 if (isset($HTTP_SERVER_VARS['HTTP_ACCEPT_LANGUAGE']))
200 $accept_lang_ary = explode(',', $HTTP_SERVER_VARS['HTTP_ACCEPT_LANGUAGE']);
201 for ($i = 0; $i < sizeof($accept_lang_ary); $i++)
204 while (list($lang, $match) = each($match_lang))
206 if (preg_match('#' . $match . '#i', trim($accept_lang_ary[$i])))
208 if (file_exists(@phpbb_realpath($phpbb_root_path . 'language/lang_' . $lang)))
225 error_reporting (E_ERROR | E_WARNING | E_PARSE); // This will NOT report uninitialized variables
226 set_magic_quotes_runtime(0); // Disable magic_quotes_runtime
228 // PHP5 with register_long_arrays off?
229 if (!isset($HTTP_POST_VARS) && isset($_POST))
231 $HTTP_POST_VARS = $_POST;
232 $HTTP_GET_VARS = $_GET;
233 $HTTP_SERVER_VARS = $_SERVER;
234 $HTTP_COOKIE_VARS = $_COOKIE;
235 $HTTP_ENV_VARS = $_ENV;
236 $HTTP_POST_FILES = $_FILES;
238 // _SESSION is the only superglobal which is conditionally set
239 if (isset($_SESSION))
241 $HTTP_SESSION_VARS = $_SESSION;
245 // Slash data if it isn't slashed
246 if (!get_magic_quotes_gpc())
248 if (is_array($HTTP_GET_VARS))
250 while (list($k, $v) = each($HTTP_GET_VARS))
252 if (is_array($HTTP_GET_VARS[$k]))
254 while (list($k2, $v2) = each($HTTP_GET_VARS[$k]))
256 $HTTP_GET_VARS[$k][$k2] = addslashes($v2);
258 @reset($HTTP_GET_VARS[$k]);
262 $HTTP_GET_VARS[$k] = addslashes($v);
265 @reset($HTTP_GET_VARS);
268 if (is_array($HTTP_POST_VARS))
270 while (list($k, $v) = each($HTTP_POST_VARS))
272 if (is_array($HTTP_POST_VARS[$k]))
274 while (list($k2, $v2) = each($HTTP_POST_VARS[$k]))
276 $HTTP_POST_VARS[$k][$k2] = addslashes($v2);
278 @reset($HTTP_POST_VARS[$k]);
282 $HTTP_POST_VARS[$k] = addslashes($v);
285 @reset($HTTP_POST_VARS);
288 if (is_array($HTTP_COOKIE_VARS))
290 while (list($k, $v) = each($HTTP_COOKIE_VARS))
292 if (is_array($HTTP_COOKIE_VARS[$k]))
294 while (list($k2, $v2) = each($HTTP_COOKIE_VARS[$k]))
296 $HTTP_COOKIE_VARS[$k][$k2] = addslashes($v2);
298 @reset($HTTP_COOKIE_VARS[$k]);
302 $HTTP_COOKIE_VARS[$k] = addslashes($v);
305 @reset($HTTP_COOKIE_VARS);
310 define('IN_PHPBB', true);
311 // Uncomment the following line to completely disable the ftp option...
312 // define('NO_FTP', true);
313 $phpbb_root_path = './../';
314 include($phpbb_root_path.'extension.inc');
316 // Initialise some basic arrays
321 // Include some required functions
322 include($phpbb_root_path.'includes/constants.'.$phpEx);
323 include($phpbb_root_path.'includes/functions.'.$phpEx);
324 include($phpbb_root_path.'includes/sessions.'.$phpEx);
326 // Define schema info
327 $available_dbms = array(
329 'LABEL' => 'MySQL 3.x',
332 'DELIM_BASIC' => ';',
333 'COMMENTS' => 'remove_remarks'
336 'LABEL' => 'MySQL 4.x/5.x',
339 'DELIM_BASIC' => ';',
340 'COMMENTS' => 'remove_remarks'
343 'LABEL' => 'PostgreSQL 7.x',
344 'SCHEMA' => 'postgres',
346 'DELIM_BASIC' => ';',
347 'COMMENTS' => 'remove_comments'
350 'LABEL' => 'MS SQL Server 7/2000',
353 'DELIM_BASIC' => ';',
354 'COMMENTS' => 'remove_comments'
357 'LABEL' => 'MS Access [ ODBC ]',
360 'DELIM_BASIC' => ';',
363 'mssql-odbc' => array(
364 'LABEL' => 'MS SQL Server [ ODBC ]',
367 'DELIM_BASIC' => ';',
368 'COMMENTS' => 'remove_comments'
372 // Obtain various vars
373 $confirm = (isset($HTTP_POST_VARS['confirm'])) ? true : false;
374 $cancel = (isset($HTTP_POST_VARS['cancel'])) ? true : false;
376 if (isset($HTTP_POST_VARS['install_step']) || isset($HTTP_GET_VARS['install_step']))
378 $install_step = (isset($HTTP_POST_VARS['install_step'])) ? $HTTP_POST_VARS['install_step'] : $HTTP_GET_VARS['install_step'];
385 $upgrade = (!empty($HTTP_POST_VARS['upgrade'])) ? $HTTP_POST_VARS['upgrade']: '';
386 $upgrade_now = (!empty($HTTP_POST_VARS['upgrade_now'])) ? $HTTP_POST_VARS['upgrade_now']:'';
388 $dbms = isset($HTTP_POST_VARS['dbms']) ? $HTTP_POST_VARS['dbms'] : '';
390 $dbhost = (!empty($HTTP_POST_VARS['dbhost'])) ? $HTTP_POST_VARS['dbhost'] : 'localhost';
391 $dbuser = (!empty($HTTP_POST_VARS['dbuser'])) ? $HTTP_POST_VARS['dbuser'] : '';
392 $dbpasswd = (!empty($HTTP_POST_VARS['dbpasswd'])) ? $HTTP_POST_VARS['dbpasswd'] : '';
393 $dbname = (!empty($HTTP_POST_VARS['dbname'])) ? $HTTP_POST_VARS['dbname'] : '';
395 $table_prefix = (!empty($HTTP_POST_VARS['prefix'])) ? $HTTP_POST_VARS['prefix'] : '';
397 $admin_name = (!empty($HTTP_POST_VARS['admin_name'])) ? $HTTP_POST_VARS['admin_name'] : '';
398 $admin_pass1 = (!empty($HTTP_POST_VARS['admin_pass1'])) ? $HTTP_POST_VARS['admin_pass1'] : '';
399 $admin_pass2 = (!empty($HTTP_POST_VARS['admin_pass2'])) ? $HTTP_POST_VARS['admin_pass2'] : '';
401 $ftp_path = (!empty($HTTP_POST_VARS['ftp_path'])) ? $HTTP_POST_VARS['ftp_path'] : '';
402 $ftp_user = (!empty($HTTP_POST_VARS['ftp_user'])) ? $HTTP_POST_VARS['ftp_user'] : '';
403 $ftp_pass = (!empty($HTTP_POST_VARS['ftp_pass'])) ? $HTTP_POST_VARS['ftp_pass'] : '';
405 if (isset($HTTP_POST_VARS['lang']) && preg_match('#^[a-z_]+$#', $HTTP_POST_VARS['lang']))
407 $language = strip_tags($HTTP_POST_VARS['lang']);
411 $language = guess_lang();
414 $board_email = (!empty($HTTP_POST_VARS['board_email'])) ? $HTTP_POST_VARS['board_email'] : '';
415 $script_path = (!empty($HTTP_POST_VARS['script_path'])) ? $HTTP_POST_VARS['script_path'] : str_replace('install', '', dirname($HTTP_SERVER_VARS['PHP_SELF']));
417 if (!empty($HTTP_POST_VARS['server_name']))
419 $server_name = $HTTP_POST_VARS['server_name'];
423 // Guess at some basic info used for install..
424 if (!empty($HTTP_SERVER_VARS['SERVER_NAME']) || !empty($HTTP_ENV_VARS['SERVER_NAME']))
426 $server_name = (!empty($HTTP_SERVER_VARS['SERVER_NAME'])) ? $HTTP_SERVER_VARS['SERVER_NAME'] : $HTTP_ENV_VARS['SERVER_NAME'];
428 else if (!empty($HTTP_SERVER_VARS['HTTP_HOST']) || !empty($HTTP_ENV_VARS['HTTP_HOST']))
430 $server_name = (!empty($HTTP_SERVER_VARS['HTTP_HOST'])) ? $HTTP_SERVER_VARS['HTTP_HOST'] : $HTTP_ENV_VARS['HTTP_HOST'];
438 if (!empty($HTTP_POST_VARS['server_port']))
440 $server_port = $HTTP_POST_VARS['server_port'];
444 if (!empty($HTTP_SERVER_VARS['SERVER_PORT']) || !empty($HTTP_ENV_VARS['SERVER_PORT']))
446 $server_port = (!empty($HTTP_SERVER_VARS['SERVER_PORT'])) ? $HTTP_SERVER_VARS['SERVER_PORT'] : $HTTP_ENV_VARS['SERVER_PORT'];
454 // Open config.php ... if it exists
455 if (@file_exists(@phpbb_realpath('config.'.$phpEx)))
457 include($phpbb_root_path.'config.'.$phpEx);
460 // Is phpBB already installed? Yes? Redirect to the index
461 if (defined("PHPBB_INSTALLED"))
463 redirect('../index.'.$phpEx);
466 // Import language file, setup template ...
467 include($phpbb_root_path.'language/lang_' . $language . '/lang_main.'.$phpEx);
468 include($phpbb_root_path.'language/lang_' . $language . '/lang_admin.'.$phpEx);
470 // Ok for the time being I'm commenting this out whilst I'm working on
471 // better integration of the install with upgrade as per Bart's request
475 // require('upgrade.'.$phpEx);
479 // What do we need to do?
480 if (!empty($HTTP_POST_VARS['send_file']) && $HTTP_POST_VARS['send_file'] == 1 && empty($HTTP_POST_VARS['upgrade_now']))
482 header('Content-Type: text/x-delimtext; name="config.' . $phpEx . '"');
483 header('Content-disposition: attachment; filename="config.' . $phpEx . '"');
485 // We need to stripslashes no matter what the setting of magic_quotes_gpc is
486 // because we add slashes at the top if its off, and they are added automaticlly
488 echo stripslashes($HTTP_POST_VARS['config_data']);
492 else if (!empty($HTTP_POST_VARS['send_file']) && $HTTP_POST_VARS['send_file'] == 2)
494 $s_hidden_fields = '<input type="hidden" name="config_data" value="' . htmlspecialchars(stripslashes($HTTP_POST_VARS['config_data'])) . '" />';
495 $s_hidden_fields .= '<input type="hidden" name="ftp_file" value="1" />';
499 $s_hidden_fields .= '<input type="hidden" name="upgrade" value="1" />';
502 page_header($lang['ftp_instructs']);
506 <th colspan="2"><?php echo $lang['ftp_info']; ?></th>
509 <td class="row1" align="right"><span class="gen"><?php echo $lang['ftp_path']; ?></span></td>
510 <td class="row2"><input type="text" name="ftp_dir"></td>
513 <td class="row1" align="right"><span class="gen"><?php echo $lang['ftp_username']; ?></span></td>
514 <td class="row2"><input type="text" name="ftp_user"></td>
517 <td class="row1" align="right"><span class="gen"><?php echo $lang['ftp_password']; ?></span></td>
518 <td class="row2"><input type="password" name="ftp_pass"></td>
522 page_common_form($s_hidden_fields, $lang['Transfer_config']);
527 else if (!empty($HTTP_POST_VARS['ftp_file']))
529 // Try to connect ...
530 $conn_id = @ftp_connect('localhost');
531 $login_result = @ftp_login($conn_id, "$ftp_user", "$ftp_pass");
533 if (!$conn_id || !$login_result)
535 page_header($lang['NoFTP_config']);
537 // Error couldn't get connected... Go back to option to send file...
538 $s_hidden_fields = '<input type="hidden" name="config_data" value="' . htmlspecialchars(stripslashes($HTTP_POST_VARS['config_data'])) . '" />';
539 $s_hidden_fields .= '<input type="hidden" name="send_file" value="1" />';
541 // If we're upgrading ...
544 $s_hidden_fields .= '<input type="hidden" name="upgrade" value="1" />';
545 $s_hidden_fields .= '<input type="hidden" name="dbms" value="'.$dmbs.'" />';
546 $s_hidden_fields .= '<input type="hidden" name="prefix" value="'.$table_prefix.'" />';
547 $s_hidden_fields .= '<input type="hidden" name="dbhost" value="'.$dbhost.'" />';
548 $s_hidden_fields .= '<input type="hidden" name="dbname" value="'.$dbname.'" />';
549 $s_hidden_fields .= '<input type="hidden" name="dbuser" value="'.$dbuser.'" />';
550 $s_hidden_fields .= '<input type="hidden" name="dbpasswd" value="'.$dbpasswd.'" />';
551 $s_hidden_fields .= '<input type="hidden" name="install_step" value="1" />';
552 $s_hidden_fields .= '<input type="hidden" name="admin_pass1" value="1" />';
553 $s_hidden_fields .= '<input type="hidden" name="admin_pass2" value="1" />';
554 $s_hidden_fields .= '<input type="hidden" name="server_port" value="'.$server_port.'" />';
555 $s_hidden_fields .= '<input type="hidden" name="server_name" value="'.$server_name.'" />';
556 $s_hidden_fields .= '<input type="hidden" name="script_path" value="'.$script_path.'" />';
557 $s_hidden_fields .= '<input type="hidden" name="board_email" value="'.$board_email.'" />';
563 page_common_form($s_hidden_fields, $lang['Download_config']);
572 // Write out a temp file...
573 $tmpfname = @tempnam('/tmp', 'cfg');
575 @unlink($tmpfname); // unlink for safety on php4.0.3+
577 $fp = @fopen($tmpfname, 'w');
579 @fwrite($fp, stripslashes($HTTP_POST_VARS['config_data']));
583 // Now ftp it across.
584 @ftp_chdir($conn_id, $ftp_dir);
586 $res = ftp_put($conn_id, 'config.'.$phpEx, $tmpfname, FTP_ASCII);
594 require('upgrade.'.$phpEx);
598 // Ok we are basically done with the install process let's go on
599 // and let the user configure their board now. We are going to do
600 // this by calling the admin_board.php from the normal board admin
602 $s_hidden_fields = '<input type="hidden" name="username" value="' . $admin_name . '" />';
603 $s_hidden_fields .= '<input type="hidden" name="password" value="' . $admin_pass1 . '" />';
604 $s_hidden_fields .= '<input type="hidden" name="redirect" value="../admin/index.'.$phpEx.'" />';
605 $s_hidden_fields .= '<input type="hidden" name="submit" value="' . $lang['Login'] . '" />';
607 page_header($lang['Inst_Step_2']);
608 page_common_form($s_hidden_fields, $lang['Finish_Install']);
613 else if ((empty($install_step) || $admin_pass1 != $admin_pass2 || empty($admin_pass1) || empty($dbhost)))
615 // Ok we haven't installed before so lets work our way through the various
616 // steps of the install process. This could turn out to be quite a lengty
619 // Step 0 gather the pertinant info for database setup...
620 // Namely dbms, dbhost, dbname, dbuser, and dbpasswd.
621 $instruction_text = $lang['Inst_Step_0'];
623 if (!empty($install_step))
625 if ((($HTTP_POST_VARS['admin_pass1'] != $HTTP_POST_VARS['admin_pass2'])) ||
626 (empty($HTTP_POST_VARS['admin_pass1']) || empty($dbhost)) && $HTTP_POST_VARS['cur_lang'] == $language)
628 $error = $lang['Password_mismatch'];
632 $dirname = $phpbb_root_path . 'language';
633 $dir = opendir($dirname);
635 $lang_options = array();
636 while ($file = readdir($dir))
638 if (preg_match('#^lang_#i', $file) && !is_file(@phpbb_realpath($dirname . '/' . $file)) && !is_link(@phpbb_realpath($dirname . '/' . $file)))
640 $filename = trim(str_replace('lang_', '', $file));
641 $displayname = preg_replace('/^(.*?)_(.*)$/', '\1 [ \2 ]', $filename);
642 $displayname = preg_replace('/\[(.*?)_(.*)\]/', '[ \1 - \2 ]', $displayname);
643 $lang_options[$displayname] = $filename;
649 @asort($lang_options);
650 @reset($lang_options);
652 $lang_select = '<select name="lang" onchange="this.form.submit()">';
653 while (list($displayname, $filename) = @each($lang_options))
655 $selected = ($language == $filename) ? ' selected="selected"' : '';
656 $lang_select .= '<option value="' . $filename . '"' . $selected . '>' . ucwords($displayname) . '</option>';
658 $lang_select .= '</select>';
660 $dbms_select = '<select name="dbms" onchange="if(this.form.upgrade.options[this.form.upgrade.selectedIndex].value == 1){ this.selectedIndex = 0;}">';
661 while (list($dbms_name, $details) = @each($available_dbms))
663 $selected = ($dbms_name == $dbms) ? 'selected="selected"' : '';
664 $dbms_select .= '<option value="' . $dbms_name . '">' . $details['LABEL'] . '</option>';
666 $dbms_select .= '</select>';
668 $upgrade_option = '<select name="upgrade"';
669 $upgrade_option .= 'onchange="if (this.options[this.selectedIndex].value == 1) { this.form.dbms.selectedIndex = 0; }">';
670 $upgrade_option .= '<option value="0">' . $lang['Install'] . '</option>';
671 $upgrade_option .= '<option value="1">' . $lang['Upgrade'] . '</option></select>';
673 $s_hidden_fields = '<input type="hidden" name="install_step" value="1" /><input type="hidden" name="cur_lang" value="' . $language . '" />';
675 page_header($instruction_text);
679 <th colspan="2"><?php echo $lang['Initial_config']; ?></th>
682 <td class="row1" align="right" width="30%"><span class="gen"><?php echo $lang['Default_lang']; ?>: </span></td>
683 <td class="row2"><?php echo $lang_select; ?></td>
686 <td class="row1" align="right"><span class="gen"><?php echo $lang['dbms']; ?>: </span></td>
687 <td class="row2"><?php echo $dbms_select; ?></td>
690 <td class="row1" align="right"><span class="gen"><?php echo $lang['Install_Method']; ?>:</span></td>
691 <td class="row2"><?php echo $upgrade_option; ?></td>
694 <th colspan="2"><?php echo $lang['DB_config']; ?></th>
697 <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Host']; ?>: </span></td>
698 <td class="row2"><input type="text" name="dbhost" value="<?php echo ($dbhost != '') ? $dbhost : ''; ?>" /></td>
701 <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Name']; ?>: </span></td>
702 <td class="row2"><input type="text" name="dbname" value="<?php echo ($dbname != '') ? $dbname : ''; ?>" /></td>
705 <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Username']; ?>: </span></td>
706 <td class="row2"><input type="text" name="dbuser" value="<?php echo ($dbuser != '') ? $dbuser : ''; ?>" /></td>
709 <td class="row1" align="right"><span class="gen"><?php echo $lang['DB_Password']; ?>: </span></td>
710 <td class="row2"><input type="password" name="dbpasswd" value="<?php echo ($dbpasswd != '') ? $dbpasswd : ''; ?>" /></td>
713 <td class="row1" align="right"><span class="gen"><?php echo $lang['Table_Prefix']; ?>: </span></td>
714 <td class="row2"><input type="text" name="prefix" value="<?php echo (!empty($table_prefix)) ? $table_prefix : "phpbb_"; ?>" /></td>
717 <th colspan="2"><?php echo $lang['Admin_config']; ?></th>
725 <td class="row1" colspan="2" align="center"><span class="gen" style="color:red"><?php echo $error; ?></span></td>
732 <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_email']; ?>: </span></td>
733 <td class="row2"><input type="text" name="board_email" value="<?php echo ($board_email != '') ? $board_email : ''; ?>" /></td>
736 <td class="row1" align="right"><span class="gen"><?php echo $lang['Server_name']; ?>: </span></td>
737 <td class="row2"><input type="text" name="server_name" value="<?php echo $server_name; ?>" /></td>
740 <td class="row1" align="right"><span class="gen"><?php echo $lang['Server_port']; ?>: </span></td>
741 <td class="row2"><input type="text" name="server_port" value="<?php echo $server_port; ?>" /></td>
744 <td class="row1" align="right"><span class="gen"><?php echo $lang['Script_path']; ?>: </span></td>
745 <td class="row2"><input type="text" name="script_path" value="<?php echo $script_path; ?>" /></td>
748 <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_Username']; ?>: </span></td>
749 <td class="row2"><input type="text" name="admin_name" value="<?php echo ($admin_name != '') ? $admin_name : ''; ?>" /></td>
752 <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_Password']; ?>: </span></td>
753 <td class="row2"><input type="password" name="admin_pass1" value="<?php echo ($admin_pass1 != '') ? $admin_pass1 : ''; ?>" /></td>
756 <td class="row1" align="right"><span class="gen"><?php echo $lang['Admin_Password_confirm']; ?>: </span></td>
757 <td class="row2"><input type="password" name="admin_pass2" value="<?php echo ($admin_pass2 != '') ? $admin_pass2 : ''; ?>" /></td>
761 page_common_form($s_hidden_fields, $lang['Start_Install']);
767 // Go ahead and create the DB, then populate it
769 // MS Access is slightly different in that a pre-built, pre-
770 // populated DB is supplied, all we need do here is update
771 // the relevant entries
778 $check_exts = 'odbc';
779 $check_other = 'odbc';
783 $check_exts = 'mssql';
784 $check_other = 'sybase';
789 $check_exts = 'mysql';
790 $check_other = 'mysql';
794 $check_exts = 'pgsql';
795 $check_other = 'pgsql';
799 if (!extension_loaded($check_exts) && !extension_loaded($check_other))
801 page_header($lang['Install'], '');
802 page_error($lang['Installer_Error'], $lang['Install_No_Ext']);
807 include($phpbb_root_path.'includes/db.'.$phpEx);
810 $dbms_schema = 'schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_schema.sql';
811 $dbms_basic = 'schemas/' . $available_dbms[$dbms]['SCHEMA'] . '_basic.sql';
813 $remove_remarks = $available_dbms[$dbms]['COMMENTS'];;
814 $delimiter = $available_dbms[$dbms]['DELIM'];
815 $delimiter_basic = $available_dbms[$dbms]['DELIM_BASIC'];
817 if ($install_step == 1)
821 if ($dbms != 'msaccess')
823 // Load in the sql parser
824 include($phpbb_root_path.'includes/sql_parse.'.$phpEx);
826 // Ok we have the db info go ahead and read in the relevant schema
827 // and work on building the table.. probably ought to provide some
828 // kind of feedback to the user as we are working here in order
829 // to let them know we are actually doing something.
830 $sql_query = @fread(@fopen($dbms_schema, 'r'), @filesize($dbms_schema));
831 $sql_query = preg_replace('/phpbb_/', $table_prefix, $sql_query);
833 $sql_query = $remove_remarks($sql_query);
834 $sql_query = split_sql_file($sql_query, $delimiter);
836 for ($i = 0; $i < sizeof($sql_query); $i++)
838 if (trim($sql_query[$i]) != '')
840 if (!($result = $db->sql_query($sql_query[$i])))
842 $error = $db->sql_error();
844 page_header($lang['Install'], '');
845 page_error($lang['Installer_Error'], $lang['Install_db_error'] . '<br />' . $error['message']);
852 // Ok tables have been built, let's fill in the basic information
853 $sql_query = @fread(@fopen($dbms_basic, 'r'), @filesize($dbms_basic));
854 $sql_query = preg_replace('/phpbb_/', $table_prefix, $sql_query);
856 $sql_query = $remove_remarks($sql_query);
857 $sql_query = split_sql_file($sql_query, $delimiter_basic);
859 for($i = 0; $i < sizeof($sql_query); $i++)
861 if (trim($sql_query[$i]) != '')
863 if (!($result = $db->sql_query($sql_query[$i])))
865 $error = $db->sql_error();
867 page_header($lang['Install'], '');
868 page_error($lang['Installer_Error'], $lang['Install_db_error'] . '<br />' . $error['message']);
876 // Ok at this point they have entered their admin password, let's go
877 // ahead and create the admin account with some basic default information
878 // that they can customize later, and write out the config file. After
879 // this we are going to pass them over to the admin_forum.php script
880 // to set up their forum defaults.
883 // Update the default admin user with their information.
884 $sql = "INSERT INTO " . $table_prefix . "config (config_name, config_value)
885 VALUES ('board_startdate', " . time() . ")";
886 if (!$db->sql_query($sql))
888 $error .= "Could not insert board_startdate :: " . $sql . " :: " . __LINE__ . " :: " . __FILE__ . "<br /><br />";
891 $sql = "INSERT INTO " . $table_prefix . "config (config_name, config_value)
892 VALUES ('default_lang', '" . str_replace("\'", "''", $language) . "')";
893 if (!$db->sql_query($sql))
895 $error .= "Could not insert default_lang :: " . $sql . " :: " . __LINE__ . " :: " . __FILE__ . "<br /><br />";
898 $update_config = array(
899 'board_email' => $board_email,
900 'script_path' => $script_path,
901 'server_port' => $server_port,
902 'server_name' => $server_name,
905 while (list($config_name, $config_value) = each($update_config))
907 $sql = "UPDATE " . $table_prefix . "config
908 SET config_value = '$config_value'
909 WHERE config_name = '$config_name'";
910 if (!$db->sql_query($sql))
912 $error .= "Could not insert default_lang :: " . $sql . " :: " . __LINE__ . " :: " . __FILE__ . "<br /><br />";
916 $admin_pass_md5 = ($confirm && $userdata['user_level'] == ADMIN) ? $admin_pass1 : md5($admin_pass1);
918 $sql = "UPDATE " . $table_prefix . "users
919 SET username = '" . str_replace("\'", "''", $admin_name) . "', user_password='" . str_replace("\'", "''", $admin_pass_md5) . "', user_lang = '" . str_replace("\'", "''", $language) . "', user_email='" . str_replace("\'", "''", $board_email) . "'
920 WHERE username = 'Admin'";
921 if (!$db->sql_query($sql))
923 $error .= "Could not update admin info :: " . $sql . " :: " . __LINE__ . " :: " . __FILE__ . "<br /><br />";
926 $sql = "UPDATE " . $table_prefix . "users
927 SET user_regdate = " . time();
928 if (!$db->sql_query($sql))
930 $error .= "Could not update user_regdate :: " . $sql . " :: " . __LINE__ . " :: " . __FILE__ . "<br /><br />";
935 page_header($lang['Install'], '');
936 page_error($lang['Installer_Error'], $lang['Install_db_error'] . '<br /><br />' . $error);
944 // Write out the config file.
945 $config_data = '<?php'."\n\n";
946 $config_data .= "\n// phpBB 2.x auto-generated config file\n// Do not change anything in this file!\n\n";
947 $config_data .= '$dbms = \'' . $dbms . '\';' . "\n\n";
948 $config_data .= '$dbhost = \'' . $dbhost . '\';' . "\n";
949 $config_data .= '$dbname = \'' . $dbname . '\';' . "\n";
950 $config_data .= '$dbuser = \'' . $dbuser . '\';' . "\n";
951 $config_data .= '$dbpasswd = \'' . $dbpasswd . '\';' . "\n\n";
952 $config_data .= '$table_prefix = \'' . $table_prefix . '\';' . "\n\n";
953 $config_data .= 'define(\'PHPBB_INSTALLED\', true);'."\n\n";
954 $config_data .= '?' . '>'; // Done this to prevent highlighting editors getting confused!
959 // Unable to open the file writeable do something here as an attempt
960 // to get around that...
961 if (!($fp = @fopen($phpbb_root_path . 'config.'.$phpEx, 'w')))
963 $s_hidden_fields = '<input type="hidden" name="config_data" value="' . htmlspecialchars($config_data) . '" />';
965 if (@extension_loaded('ftp') && !defined('NO_FTP'))
967 page_header($lang['Unwriteable_config'] . '<p>' . $lang['ftp_option'] . '</p>');
971 <th colspan="2"><?php echo $lang['ftp_choose']; ?></th>
974 <td class="row1" align="right" width="50%"><span class="gen"><?php echo $lang['Attempt_ftp']; ?></span></td>
975 <td class="row2"><input type="radio" name="send_file" value="2"></td>
978 <td class="row1" align="right" width="50%"><span class="gen"><?php echo $lang['Send_file']; ?></span></td>
979 <td class="row2"><input type="radio" name="send_file" value="1"></td>
986 page_header($lang['Unwriteable_config']);
987 $s_hidden_fields .= '<input type="hidden" name="send_file" value="1" />';
992 $s_hidden_fields .= '<input type="hidden" name="upgrade" value="1" />';
993 $s_hidden_fields .= '<input type="hidden" name="dbms" value="'.$dbms.'" />';
994 $s_hidden_fields .= '<input type="hidden" name="prefix" value="'.$table_prefix.'" />';
995 $s_hidden_fields .= '<input type="hidden" name="dbhost" value="'.$dbhost.'" />';
996 $s_hidden_fields .= '<input type="hidden" name="dbname" value="'.$dbname.'" />';
997 $s_hidden_fields .= '<input type="hidden" name="dbuser" value="'.$dbuser.'" />';
998 $s_hidden_fields .= '<input type="hidden" name="dbpasswd" value="'.$dbpasswd.'" />';
999 $s_hidden_fields .= '<input type="hidden" name="install_step" value="1" />';
1000 $s_hidden_fields .= '<input type="hidden" name="admin_pass1" value="1" />';
1001 $s_hidden_fields .= '<input type="hidden" name="admin_pass2" value="1" />';
1002 $s_hidden_fields .= '<input type="hidden" name="server_port" value="'.$server_port.'" />';
1003 $s_hidden_fields .= '<input type="hidden" name="server_name" value="'.$server_name.'" />';
1004 $s_hidden_fields .= '<input type="hidden" name="script_path" value="'.$script_path.'" />';
1005 $s_hidden_fields .= '<input type="hidden" name="board_email" value="'.$board_email.'" />';
1007 page_upgrade_form();
1012 page_common_form($s_hidden_fields, $lang['Download_config']);
1019 $result = @fputs($fp, $config_data, strlen($config_data));
1022 $upgrade_now = $lang['upgrade_submit'];
1025 // First off let's check and see if we are supposed to be doing an upgrade.
1026 if ($upgrade == 1 && $upgrade_now == $lang['upgrade_submit'])
1028 define('INSTALLING', true);
1029 require('upgrade.'.$phpEx);
1033 // Ok we are basically done with the install process let's go on
1034 // and let the user configure their board now. We are going to do
1035 // this by calling the admin_board.php from the normal board admin
1037 $s_hidden_fields = '<input type="hidden" name="username" value="' . $admin_name . '" />';
1038 $s_hidden_fields .= '<input type="hidden" name="password" value="' . $admin_pass1 . '" />';
1039 $s_hidden_fields .= '<input type="hidden" name="redirect" value="admin/index.'.$phpEx.'" />';
1040 $s_hidden_fields .= '<input type="hidden" name="login" value="true" />';
1042 page_header($lang['Inst_Step_2'], '../login.'.$phpEx);
1043 page_common_form($s_hidden_fields, $lang['Finish_Install']);