install.php

   1 <?php
   2
   3 include_once('functions/include.install.php');
   4
   5 $version = false;
   6 $table_prefix = 'mlf1_';
   7
   8 if (isset($_POST['language']))
   9         {
  10         $language = $_POST['language'];
  11         $settings['language_file'] = $language;
  12         }
  13
  14 include("lang/".$settings['language_file'] );
  15 include("lang/".$lang['additional_language_file']);
  16 include("db_settings.php");
  17
  18 unset($errors);
  19
  20 if (isset($_POST['form_submitted']))
  21         {
  22         // all fields filled out?
  23         foreach ($_POST as $post)
  24                 {
  25                 if (trim($post) == "")
  26                         {
  27                         $errors[] = $lang['error_form_uncompl'];
  28                         break;
  29                         }
  30                 }
  31
  32         if (empty($errors) && $installation_mode=='installation')
  33                 {
  34                 if ($_POST['admin_pw'] != $_POST['admin_pw_conf']) $errors[] = $lang_add['inst_pw_conf_error'];
  35                 }
  36
  37         // try to connect the database with posted access data:
  38         if (empty($errors))
  39                 {
  40                 $connid = @mysql_connect($_POST['host'], $_POST['user'], $_POST['pw']);
  41                 if (!$connid) $errors[] = $lang_add['db_connection_error']." (MySQL: ".mysql_errno()."<br />".mysql_error().")";
  42                 }
  43         // overwrite database settings file:
  44         if (empty($errors) && empty($_POST['dont_overwrite_settings']))
  45                 {
  46                 clearstatcache();
  47                 $chmod = decoct(fileperms("db_settings.php"));
  48
  49                 $db_settings['host'] = $_POST['host'];
  50                 $db_settings['user'] = $_POST['user'];
  51                 $db_settings['pw'] = $_POST['pw'];
  52                 $db_settings['db'] = $_POST['db'];
  53                 $db_settings['settings_table'] = $_POST['table_prefix'].'settings';
  54                 $db_settings['forum_table'] = $_POST['table_prefix'].'entries';
  55                 $db_settings['category_table'] = $_POST['table_prefix'].'categories';
  56                 $db_settings['userdata_table'] = $_POST['table_prefix'].'userdata';
  57                 $db_settings['smilies_table'] = $_POST['table_prefix'].'smilies';
  58                 $db_settings['banlists_table'] = $_POST['table_prefix'].'banlists';
  59                 $db_settings['banned_ips_table'] = $_POST['table_prefix'].'banned_ips';
  60                 $db_settings['useronline_table'] = $_POST['table_prefix'].'useronline';
  61                 $db_settings['usersettings_table'] = $_POST['table_prefix'].'usersettings';
  62                 $db_settings['us_templates_table'] = $_POST['table_prefix'].'fu_settings';
  63                 $db_settings['usersubscripts_table'] = $_POST['table_prefix'].'subscripts';
  64                 # content of db_settings.php
  65                 $fileSettingsContent  = "<?php\n";
  66                 $fileSettingsContent .= "\$db_settings['host'] = \"".$db_settings['host']."\";\n";
  67                 $fileSettingsContent .= "\$db_settings['user'] = \"".$db_settings['user']."\";\n";
  68                 $fileSettingsContent .= "\$db_settings['pw'] = \"".$db_settings['pw']."\";\n";
  69                 $fileSettingsContent .= "\$db_settings['db'] = \"".$db_settings['db']."\";\n";
  70                 $fileSettingsContent .= "\$db_settings['settings_table'] = \"".$db_settings['settings_table']."\";\n";
  71                 $fileSettingsContent .= "\$db_settings['forum_table'] = \"".$db_settings['forum_table']."\";\n";
  72                 $fileSettingsContent .= "\$db_settings['category_table'] = \"".$db_settings['category_table']."\";\n";
  73                 $fileSettingsContent .= "\$db_settings['userdata_table'] = \"".$db_settings['userdata_table']."\";\n";
  74                 $fileSettingsContent .= "\$db_settings['smilies_table'] = \"".$db_settings['smilies_table']."\";\n";
  75                 $fileSettingsContent .= "\$db_settings['banlists_table'] = \"".$db_settings['banlists_table']."\";\n";
  76                 $fileSettingsContent .= "\$db_settings['banned_ips_table'] = \"".$db_settings['banned_ips_table']."\";\n";
  77                 $fileSettingsContent .= "\$db_settings['useronline_table'] = \"".$db_settings['useronline_table']."\";\n";
  78                 $fileSettingsContent .= "\$db_settings['usersettings_table'] = \"".$db_settings['usersettings_table']."\";\n";
  79                 $fileSettingsContent .= "\$db_settings['us_templates_table'] = \"".$db_settings['us_templates_table']."\";\n";
  80                 $fileSettingsContent .= "\$db_settings['usersubscripts_table'] = \"".$db_settings['usersubscripts_table']."\";\n";
  81                 $fileSettingsContent .= "?>";
  82
  83                 $db_settings_file = @fopen("db_settings.php", "w") or $errors[] = str_replace("CHMOD",$chmod,$lang_add['no_writing_permission']);
  84                 flock($db_settings_file, LOCK_EX);
  85                 fwrite($db_settings_file, $fileSettingsContent);
  86                 flock($db_settings_file, LOCK_UN);
  87                 fclose($db_settings_file);
  88                 }
  89
  90         if (empty($errors))
  91                 {
  92                 # create database if desired:
  93                 if (isset($_POST['create_database']))
  94                         {
  95                         @mysql_query("CREATE DATABASE ".$db_settings['db'], $connid) or $errors[] = $lang_add['db_create_db_error']." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
  96                         }
  97
  98                 # select database:
  99                 if (empty($errors))
 100                         {
 101                         @mysql_select_db($db_settings['db'], $connid) or $errors[] = $lang_add['db_inexistent_error']." (MySQL: ".mysql_errno($connid)."<br />".mysql_errno($connid)."<br />".mysql_error($connid).")";
 102                         }
 103
 104                 # create tables:
 105                 if (empty($errors))
 106                         {
 107                         # create settings table
 108                         $table["settings"]["name"] = $db_settings['settings_table'];
 109                         $table["settings"]["query"] = "CREATE TABLE ".$db_settings['settings_table']." (
 110                         name varchar(255) NOT NULL default '',
 111                         value varchar(255) NOT NULL default '',
 112                         type varchar(30) NOT NULL default '',
 113                         poss_values varchar(160) NOT NULL default '',
 114                         standard varchar(80) NOT NULL default '',
 115                         cat varchar(20) NOT NULL default ''
 116                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 117                         # create posting table
 118                         $table["postings"]["name"] = $db_settings['forum_table'];
 119                         $table["postings"]["query"] = "CREATE TABLE ".$db_settings['forum_table']." (
 120                         id int(11) unsigned NOT NULL auto_increment,
 121                         pid int(11) unsigned NOT NULL default '0',
 122                         tid int(11) unsigned NOT NULL default '0',
 123                         uniqid varchar(255) NOT NULL default '',
 124                         time datetime NOT NULL,
 125                         last_answer timestamp(14) NOT NULL default '0000-00-00 00:00:00',
 126                         edited timestamp(14) NOT NULL default '0000-00-00 00:00:00',
 127                         edited_by varchar(255) NOT NULL default '',
 128                         user_id int(11) unsigned default '0',
 129                         name varchar(255) NOT NULL default '',
 130                         subject varchar(255) NOT NULL default '',
 131                         category int(11) unsigned NOT NULL default '0',
 132                         email varchar(255) NOT NULL default '',
 133                         hp varchar(255) NOT NULL default '',
 134                         place varchar(255) NOT NULL default '',
 135                         ip varchar(39) NOT NULL default '',
 136                         text text NOT NULL,
 137                         show_signature tinyint(4) unsigned default '0',
 138                         email_notify tinyint(4) unsigned default '0',
 139                         marked tinyint(4) unsigned default '0',
 140                         locked tinyint(4) unsigned default '0',
 141                         fixed tinyint(4) unsigned default '0',
 142                         views int(11) unsigned default '0',
 143                         PRIMARY KEY (id),
 144                         KEY tid (tid),
 145                         KEY category (category),
 146                         KEY pid (pid),
 147                         KEY fixed (fixed)
 148                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 149                         # create category table
 150                         $table["category"]["name"] = $db_settings['category_table'];
 151                         $table["category"]["query"] = "CREATE TABLE ".$db_settings['category_table']." (
 152                         id int(11) unsigned NOT NULL auto_increment,
 153                         category_order int(11) unsigned NOT NULL,
 154                         category varchar(255) NOT NULL default '',
 155                         description varchar(255) NOT NULL default '',
 156                         accession tinyint(4) unsigned NOT NULL default '0',
 157                         PRIMARY KEY (id)
 158                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 159                         # create userdata table
 160                         $table["userdata"]["name"] = $db_settings['userdata_table'];
 161                         $table["userdata"]["query"] = "CREATE TABLE ".$db_settings['userdata_table']." (
 162                         user_id int(11) unsigned NOT NULL auto_increment,
 163                         user_type varchar(255) NOT NULL default '',
 164                         user_name varchar(255) NOT NULL default '',
 165                         user_real_name varchar(255) NOT NULL default '',
 166                         user_pw varchar(255) NOT NULL default '',
 167                         user_email varchar(255) NOT NULL default '',
 168                         hide_email tinyint(4) unsigned default '0',
 169                         user_hp varchar(255) NOT NULL default '',
 170                         user_place varchar(255) NOT NULL default '',
 171                         signature varchar(255) NOT NULL default '',
 172                         profile text NOT NULL,
 173                         logins int(11) unsigned NOT NULL default '0',
 174                         last_login timestamp(14) NOT NULL,
 175                         last_logout timestamp(14) NOT NULL,
 176                         user_ip varchar(39) NOT NULL default '',
 177                         registered timestamp(14) NOT NULL,
 178                         user_view varchar(255) NOT NULL default '',
 179                         new_posting_notify tinyint(4) unsigned default '0',
 180                         new_user_notify tinyint(4) unsigned default '0',
 181                         personal_messages tinyint(4) unsigned default '0',
 182                         time_difference tinyint(4) unsigned default '0',
 183                         user_lock tinyint(4) unsigned default '0',
 184                         pwf_code varchar(255) NOT NULL default '',
 185                         activate_code varchar(255) NOT NULL default '',
 186                         PRIMARY KEY (user_id)
 187                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 188                         # create smilies table
 189                         $table["smilies"]["name"] = $db_settings['smilies_table'];
 190                         $table["smilies"]["query"] = "CREATE TABLE ".$db_settings['smilies_table']." (
 191                         id int(11) unsigned NOT NULL auto_increment,
 192                         order_id int(11) unsigned NOT NULL default '0',
 193                         file varchar(100) NOT NULL,
 194                         code_1 varchar(50) NOT NULL default '',
 195                         code_2 varchar(50) NOT NULL default '',
 196                         code_3 varchar(50) NOT NULL default '',
 197                         code_4 varchar(50) NOT NULL default '',
 198                         code_5 varchar(50) NOT NULL default '',
 199                         title varchar(255) NOT NULL,
 200                         PRIMARY KEY (id)
 201                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 202                         # create banlist table
 203                         $table["banlists"]["name"] = $db_settings['banlists_table'];
 204                         $table["banlists"]["query"] = "CREATE TABLE ".$db_settings['banlists_table']." (
 205                         name varchar(255) NOT NULL default '',
 206                         list text NOT NULL
 207                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 208                         # create banned IPs table
 209                         $table["banned_ips"]["name"] = $db_settings['banned_ips_table'];
 210                         $table["banned_ips"]["query"] = "CREATE TABLE ".$db_settings['banned_ips_table']." (
 211                         ip int(10) unsigned NOT NULL DEFAULT '0',
 212                         last_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
 213                         requests smallint(2) unsigned NOT NULL DEFAULT '0',
 214                         UNIQUE KEY ip (ip)
 215                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 216                         #create useronline table
 217                         $table["useronline"]["name"] = $db_settings['useronline_table'];
 218                         $table["useronline"]["query"] = "CREATE TABLE ".$db_settings['useronline_table']." (
 219                         ip char(15) NOT NULL default '',
 220                         time int(14) unsigned NOT NULL default '0',
 221                         user_id int(11) unsigned default '0'
 222                         ) ENGINE=MyISAM  DEFAULT CHARSET=utf8";
 223                         $table["usersettings"]["name"] = $db_settings['usersettings_table'];
 224                         $table["usersettings"]["query"] = "CREATE TABLE ".$db_settings['usersettings_table']." (
 225                         user_id int(12) unsigned NOT NULL,
 226                         name varchar(60) NOT NULL default '',
 227                         value varchar(40) NOT NULL default '',
 228                         PRIMARY KEY  (user_id,name)
 229                         ) ENGINE=MyISAM DEFAULT CHARSET=utf8";
 230                         $table["us_template"]["name"] = $db_settings['us_templates_table'];
 231                         $table["us_template"]["query"] = "CREATE TABLE ".$db_settings['us_templates_table']." (
 232                         name varchar(60) NOT NULL,
 233                         value varchar(40) NOT NULL,
 234                         type enum('string','bool') NOT NULL default 'string'
 235                         ) ENGINE=MyISAM DEFAULT CHARSET=utf8";
 236                         $table["usersubscripts"]["name"] = $db_settings['usersubscripts_table'];
 237                         $table["usersubscripts"]["query"] = "CREATE TABLE ".$db_settings['usersubscripts_table']." (
 238                         user_id int(12) unsigned NOT NULL,
 239                         tid int(12) unsigned NOT NULL,
 240                         UNIQUE KEY user_thread (user_id,tid)
 241                         ) ENGINE=MyISAM DEFAULT CHARSET=utf8;";
 242                         foreach ($table as $tbl)
 243                                 {
 244                                 @mysql_query($tbl["query"], $connid) or $errors[] = str_replace("[table]",$tbl['name'],$lang_add['db_create_table_error'])." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 245                                 }
 246                         }
 247
 248                 # insert admin in userdata table:
 249                 if (empty($errors))
 250                         {
 251                         $fillUserdata = "INSERT INTO ".$db_settings['userdata_table']." SET
 252                         user_type = 'admin',
 253                         user_name = '".mysql_real_escape_string($_POST['admin_name'])."',
 254                         user_real_name = '',
 255                         user_pw = '".md5(trim($_POST['admin_pw']))."',
 256                         user_email = '".mysql_real_escape_string($_POST['admin_email'])."',
 257                         hide_email = '1',
 258                         profile = '',
 259                         registered = NOW(),
 260                         user_view = '".$settings['standard']."',
 261                         personal_messages = '1'";
 262                         @mysql_query($fillUserdata, $connid) or $errors[] = $lang_add['db_insert_admin_error']." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 263                         }
 264
 265                 # insert settings in settings table:
 266                 if (empty($errors))
 267                         {
 268                         # insert default settings:
 269                         while(list($key, $val) = each($settings))
 270                                 {
 271                                 $fillSetting = "INSERT INTO ".$db_settings['settings_table']." SET
 272                                 name = '".mysql_real_escape_string($key)."',
 273                                 value = '".mysql_real_escape_string($val)."'";
 274                                 @mysql_query($fillSetting, $connid) or $errors[] = str_replace("[setting]",$setting,$lang_add['db_insert_settings_error'])." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 275                                 # empty $fillSetting for the next loop
 276                                 $fillSetting = "";
 277                                 }
 278                         # update posted settings:
 279                         $updateSetting["forum_name"] = "UPDATE ".$db_settings['settings_table']."
 280                         SET value='".mysql_real_escape_string($_POST['forum_name'])."'
 281                         WHERE name='forum_name' LIMIT 1";
 282                         $updateSetting["forum_address"] = "UPDATE ".$db_settings['settings_table']."
 283                         SET value='".mysql_real_escape_string($_POST['forum_address'])."'
 284                         WHERE name='forum_address' LIMIT 1";
 285                         $updateSetting["forum_email"] = "UPDATE ".$db_settings['settings_table']."
 286                         SET value='".mysql_real_escape_string($_POST['forum_email'])."'
 287                         WHERE name='forum_email' LIMIT 1";
 288                         @mysql_query($updateSetting["forum_name"], $connid) or $errors[] = str_replace("[setting]",$setting,$lang_add['db_update_settings_error'])." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 289                         @mysql_query($updateSetting["forum_address"], $connid) or $errors[] = str_replace("[setting]",$setting,$lang_add['db_update_settings_error'])." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 290                         @mysql_query($updateSetting["forum_email"], $connid) or $errors[] = str_replace("[setting]",$setting,$lang_add['db_update_settings_error'])." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 291                         }
 292
 293                 # insert smilies in smilies table:
 294                 if (empty($errors))
 295                         {
 296                         $order_id = 1;
 297                         foreach($smilies as $smiley)
 298                                 {
 299                                 $fillSmiley = "INSERT INTO ".$db_settings['smilies_table']." SET
 300                                 order_id = ".intval($order_id).",
 301                                 file = '".mysql_real_escape_string($smiley[0])."',
 302                                 code_1 = '".mysql_real_escape_string($smiley[1])."',
 303                                 code_2 = '".mysql_real_escape_string($smiley[2])."',
 304                                 code_3 = '".mysql_real_escape_string($smiley[3])."',
 305                                 code_4 = '".mysql_real_escape_string($smiley[4])."',
 306                                 code_5 = '".mysql_real_escape_string($smiley[5])."',
 307                                 title = '".mysql_real_escape_string($smiley[6])."'";
 308                                 @mysql_query($fillSmiley, $connid) or $errors[] = str_replace("[setting]",$db_settings['smilies_table'],$lang_add['db_insert_settings_error'])." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 309                                 # empty $fillSmiley for the next loop
 310                                 $fillSmiley = "";
 311                                 $order_id++;
 312                                 }
 313                         }
 314
 315                 # insert banlists:
 316                 if (empty($errors))
 317                         {
 318                         $templateBanlist = array("users", "words");
 319                         foreach ($templateBanlist as $val)
 320                                 {
 321                                 $fillBanlist = "INSERT INTO ". $db_settings['banlists_table'] ." SET
 322                                 name = '". mysql_real_escape_string($val) ."',
 323                                 list = ''";
 324                                 @mysql_query($fillBanlist, $connid) or $errors[] = str_replace("[setting]",$db_settings['banlists_table'],$lang_add['db_insert_settings_error'])." (MySQL: ". mysql_errno($connid) ."<br />". mysql_error($connid) .")";
 325                                 # empty $fillBanlist for the next loop
 326                                 $fillBanlist = "";
 327                                 }
 328                         }
 329
 330                 # insert possible usersettings
 331                 if (empty($errors))
 332                         {
 333                         foreach ($usersettings as $us)
 334                                 {
 335                                 $fillUserSetting = "INSERT INTO ".$db_settings['us_templates_table']." SET
 336                                 name = '".mysql_real_escape_string($us['name'])."',
 337                                 value = '".mysql_real_escape_string($us['value'])."',
 338                                 type = '".mysql_real_escape_string($us['type'])."'";
 339                                 @mysql_query($fillUserSetting, $connid) or $errors[] = str_replace("[setting]",$db_settings['us_templates_table'],$lang_add['db_insert_settings_error'])." (MySQL: ".mysql_errno($connid)."<br />".mysql_error($connid).")";
 340                                 # empty $fillBanlist for the next loop
 341                                 $fillUserSetting = "";
 342                                 }
 343                         }
 344                 # still no errors, so the installation should have been successful!
 345                 if(empty($errors)) $installed = true;
 346                 }
 347         } # End: if (isset($_POST['form_submitted']))
 348 else
 349         {
 350         if (!empty($db_settings['host'])
 351                 and !empty($db_settings['user'])
 352                 and !empty($db_settings['pw'])
 353                 and !empty($db_settings['db']))
 354                 {
 355                 $connid = @mysql_connect($db_settings['host'], $db_settings['user'], $db_settings['pw']);
 356                 if (!$connid) $errors[] = $lang_add['db_connection_error']." (MySQL: ".mysql_errno()."<br />".mysql_error().")";
 357                 else $db_selected = mysql_select_db($db_settings['db'], $connid);
 358                 if ($db_selected === true)
 359                         {
 360                         $checkQuery = "SELECT
 361                         value AS installed_version
 362                         FROM ".$db_settings['settings_table']."
 363                         WHERE name = 'version'";
 364                         $versionResult = mysql_query($checkQuery, $connid);
 365                         if ($versionResult === false)
 366                                 {
 367                                 $errors[] = $lang_add['db_read_settings_error']." [Version] (MySQL: ".mysql_errno()."<br />".mysql_error().")";
 368                                 }
 369                         else
 370                                 {
 371                                 $version = mysql_fetch_row($versionResult, $connid);
 372                                 }
 373                         }
 374                 else
 375                         {
 376                         # $db_selected === false
 377                         $errors[] = $lang_add['db_connection_error']." (MySQL: ".mysql_errno()."<br />".mysql_error().")";
 378                         }
 379                 }
 380         }
 381
 382 # Generierung der Ausgabe
 383 $output  = "";
 384
 385 if (empty($installed))
 386         {
 387         if ($version !== false and !empty($version))
 388                 {
 389                 # forum is installed, provide the link to update.php
 390                 $output .= '<h2>'.$lang_add['installation_mode_update'].'</h2>'."\n";
 391                 $output .= '<p>'.$lang_add['select_version'].': '.$version['installed_version'].'</p>'."\n";
 392                 if (floatval(substr($version['installed_version'],0,2)) < 1.7)
 393                         {
 394                         $output .= '<p>'.$lang_add['version_not_supported'].'</p>'."\n";
 395                         }
 396                 else
 397                         {
 398                         $output .= '<p><a href="update.php">'.$lang_add['forum_update_ok'].'</a></p>'."\n";
 399                         }
 400                 }
 401         else if (empty($language))
 402                 {
 403                 $handle=opendir('./lang/');
 404                 while ($file = readdir($handle))
 405                         {
 406                         if (strrchr($file, ".")==".php" && strrchr($file, "_")!="_add.php")
 407                                 {
 408                                 $languageFile[] = $file;
 409                                 }
 410                         }
 411                 closedir($handle);
 412                 $output .= '<h2>'.$lang_add['language_file_inst'].'</h2>'."\n";
 413                 $output .= '<form action="install.php" method="post">'."\n";
 414                 $output .= '<select name="language" size="1">'."\n";
 415                 foreach ($languageFile as $langFile)
 416                         {
 417                         $output .= '<option value="'.$langFile.'"';
 418                         $output .= ($settings['language_file'] ==$langFile) ? ' selected="selected"' : '';
 419                         $output .= '>'.htmlspecialchars(ucfirst(str_replace(".php","",$langFile))).'</option>'."\n";
 420                         }
 421                 $output .= '</select>'."\n";
 422                 $output .= '<input type="submit" value="'.$lang['submit_button_ok'].'" /></p>'."\n";
 423                 $output .= '</form>'."\n";
 424                 }
 425         else
 426                 {
 427                 $output .= '<h2>'.$lang_add['installation_instructions'].'</h2>';
 428                 if (isset($errors))
 429                         {
 430                         $output .= errorMessages($errors);
 431                         }
 432                 $output .= '<form action="install.php" method="post">';
 433                 $output .= '<fieldset>';
 434                 $output .= '<legend>'.$lang_add['inst_basic_settings'].'</legend>';
 435                 $output .= '<p>'.$lang_add['inst_main_settings_d'].'</p>';
 436                 $output .= '<table class="admintab">';
 437                 $output .= '<tr>';
 438                 $output .= '<td class="admintab-l"><label for="forum-name">'.$lang_add['forum_name'].'</label><br />';
 439                 $output .= '<span class="small">'.$lang_add['forum_name_d'].'</span></td>';
 440                 $output .= '<td class="admintab-r"><input type="text" name="forum_name" value="';
 441                 $output .= (isset($_POST['forum_name'])) ? htmlspecialchars($_POST['forum_name']) : $settings['forum_name'];
 442                 $output .= '" size="40" id="forum-name" /></td>';
 443                 $output .= '</tr><tr>';
 444                 $output .= '<td class="admintab-l"><label for="forum-address">'.$lang_add['forum_address'].'</label><br />';
 445                 $output .= '<span class="small">'.$lang_add['forum_address_d'].'</span></td>';
 446                 $output .= '<td class="admintab-r"><input type="text" name="forum_address" value="';
 447                 if (isset($_POST['forum_address']))
 448                         {
 449                         $output .= htmlspecialchars($_POST['forum_address']);
 450                         }
 451                 else if ($settings['forum_address'] != "")
 452                         {
 453                         $output .= $settings['forum_address'];
 454                         }
 455                 else
 456                         {
 457                         $output .= "http://".$_SERVER['SERVER_NAME'].str_replace("install.php","",$_SERVER['SCRIPT_NAME']);
 458                         }
 459                 $output .= '" size="40" id="forum-address" /></td>';
 460                 $output .= '</tr><tr>';
 461                 $output .= '<td class="admintab-l"><label for="forum-email">'.$lang_add['forum_email'].'</label><br />';
 462                 $output .= '<span class="small">'.$lang_add['forum_email_d'].'</span></td>';
 463                 $output .= '<td class="admintab-r"><input type="text" name="forum_email" value="';
 464                 $output .= (isset($_POST['forum_email'])) ? htmlspecialchars($_POST['forum_email']) : "@";
 465                 $output .= '" size="40" id="forum-email" /></td>';
 466                 $output .= '</tr>';
 467                 $output .= '</table>';
 468                 $output .= '</fieldset>';
 469                 $output .= '<fieldset>';
 470                 $output .= '<legend>'.$lang_add['inst_admin_settings'].'</legend>';
 471                 $output .= '<p>'.$lang_add['inst_admin_settings_d'].'</p>';
 472                 $output .= '<table class="admintab">';
 473                 $output .= '<tr>';
 474                 $output .= '<td class="admintab-l"><label for="admin-name">'.$lang_add['inst_admin_name'].'</label><br />';
 475                 $output .= '<span class="small">'.$lang_add['inst_admin_name_d'].'</span></td>';
 476                 $output .= '<td class="admintab-r"><input type="text" name="admin_name" value="';
 477                 $output .= (isset($_POST['admin_name'])) ? htmlspecialchars($_POST['admin_name']) : '';
 478                 $output .= '" size="40" id="admin-name" /></td>';
 479                 $output .= '</tr><tr>';
 480                 $output .= '<td class="admintab-l"><label for="admin-email">'.$lang_add['inst_admin_email'].'</label><br />';
 481                 $output .= '<span class="small">'.$lang_add['inst_admin_email_d'].'</span></td>';
 482                 $output .= '<td class="admintab-r"><input type="text" name="admin_email" value="';
 483                 $output .= (isset($_POST['admin_email'])) ? htmlspecialchars($_POST['admin_email']) : "@";
 484                 $output .= '" size="40" id="admin-email" /></td>';
 485                 $output .= '</tr><tr>';
 486                 $output .= '<td class="admintab-l"><label for="admin-pw">'.$lang_add['inst_admin_pw'].'</label><br />';
 487                 $output .= '<span class="small">'.$lang_add['inst_admin_pw_d'].'</span></td>';
 488                 $output .= '<td class="admintab-r"><input type="password" name="admin_pw" value="" size="40" id="admin-pw" /></td>';
 489                 $output .= '</tr><tr>';
 490                 $output .= '<td class="admintab-l"><label for="admin-pw-confirm">'.$lang_add['inst_admin_pw_conf'].'</label><br />';
 491                 $output .= '<span class="small">'.$lang_add['inst_admin_pw_conf_d'].'</span></td>';
 492                 $output .= '<td class="admintab-r"><input type="password" name="admin_pw_conf" value="" size="40" id="admin-pw-confirm" /></td>';
 493                 $output .= '</tr>';
 494                 $output .= '</table>';
 495                 $output .= '</fieldset>';
 496                 $output .= '<fieldset>';
 497                 $output .= '<legend>'.$lang_add['inst_db_settings'].'</legend>';
 498                 $output .= '<p>'.$lang_add['inst_db_settings_d'].'</p>';
 499                 $output .= '<ul>';
 500                 $output .= '<li><input type="checkbox" name="create_database" id="create-db-1" value="true"';
 501                 $output .= (isset($_POST['create_database'])) ? ' checked="checked"' : '';
 502                 $output .= ' /><label for="create-db-1">'.$lang_add['create_database'].'</label></li>';
 503                 $output .= '<li><input type="checkbox" name="dont_overwrite_settings" id="create-db-0" value="true"';
 504                 $output .= (isset($_POST['dont_overwrite_settings'])) ? ' checked="checked"' : '';
 505                 $output .= '><label for="create-db-0">'.$lang_add['dont_overwrite_settings'].'</label></li>';
 506                 $output .= '</ul>';
 507                 $output .= '<table class="admintab">';
 508                 $output .= '<tr>';
 509                 $output .= '<td class="admintab-l"><label for="db-host">'.$lang_add['inst_db_host'].'</label><br />';
 510                 $output .= '<span class="small">'.$lang_add['inst_db_host_d'].'</span></td>';
 511                 $output .= '<td class="admintab-r"><input type="text" name="host" value="';
 512                 $output .= (isset($_POST['host'])) ? htmlspecialchars($_POST['host']) : $db_settings['host'];
 513                 $output .= '" size="40" id="db-host" /></td>';
 514                 $output .= '</tr>';
 515                 $output .= '<tr>';
 516                 $output .= '<td class="admintab-l"><label for="db-name">'.$lang_add['inst_db_name'].'</label><br />';
 517                 $output .= '<span class="small">'.$lang_add['inst_db_name_d'].'</span></td>';
 518                 $output .= '<td class="admintab-r"><input type="text" name="db" value="';
 519                 $output .= (isset($_POST['db'])) ? htmlspecialchars($_POST['db']) : $db_settings['db'];
 520                 $output .= '" size="40" id="db-name" /></td>';
 521                 $output .= '</tr>';
 522                 $output .= '<tr>';
 523                 $output .= '<td class="admintab-l"><label for="db-user">'.$lang_add['inst_db_user'].'</label><br />';
 524                 $output .= '<span class="small">'.$lang_add['inst_db_user_d'].'</span></td>';
 525                 $output .= '<td class="admintab-r"><input type="text" name="user" value="';
 526                 $output .= (isset($_POST['user'])) ? htmlspecialchars($_POST['user']) : $db_settings['user'];
 527                 $output .= '" size="40" id="db-user" /></td>';
 528                 $output .= '</tr>';
 529                 $output .= '<tr>';
 530                 $output .= '<td class="admintab-l"><label for="db-pass">'.$lang_add['inst_db_pw'].'</label><br />';
 531                 $output .= '<span class="small">'.$lang_add['inst_db_pw_d'].'</span></td>';
 532                 $output .= '<td class="admintab-r"><input type="password" name="pw" value="';
 533                 $output .= (isset($_POST['pw'])) ? htmlspecialchars($_POST['pw']) : '';
 534                 $output .= '" size="40" id="db-pass" /></td>';
 535                 $output .= '</tr>';
 536                 $output .= '<tr>';
 537                 $output .= '<td class="admintab-l"><label for="db-prefix">'.$lang_add['inst_table_prefix'].'</b><br />';
 538                 $output .= '<span class="small">'.$lang_add['inst_table_prefix_d'].'</span></td>';
 539                 $output .= '<td class="admintab-r"><input type="text" name="table_prefix" value="';
 540                 $output .= (isset($_POST['table_prefix'])) ? htmlspecialchars($_POST['table_prefix']) : $table_prefix;
 541                 $output .= '" size="40" id="db-prefix" /></td>';
 542                 $output .= '</tr>';
 543                 $output .= '</table>';
 544                 $output .= '</fieldset>';
 545                 $output .= '<p><input type="submit" name="form_submitted" value="'.$lang_add['forum_install_ok'].'" /></p>';
 546                 $output .= '<input type="hidden" name="language" value="'.$language.'" />';
 547                 $output .= '<input type="hidden" name="installation_mode" value="installation" />';
 548                 $output .= '</form>';
 549                 }
 550         }
 551 else
 552         {
 553         $output .= '<p class="caution" style="background-image:url(http://www.mylittlehomepage.net/mylittleforum/install/x.gif);">'.$lang_add['installation_complete'].'</p>
 554         <p>'.$lang_add['installation_complete_exp'].'</p>
 555         <p><a href="index.php">'.$lang_add['installation_complete_link'].'</a></p>';
 556         }
 557
 558
 559 ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
 560 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="<?php echo $lang['language']; ?>">
 561 <head>
 562 <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
 563 <title><?php echo $settings['forum_name']." - ".$lang_add['install_title']; ?></title>
 564 <style type="text/css">
 565 <!--
 566 body {
 567 font-family: Verdana,Arial,Helvetica,sans-serif;
 568 color: #000000;
 569 font-size:13px;
 570 background-color: #fffff3;
 571 margin: 0px;
 572 padding: 20px;
 573 }
 574 h1 {
 575 margin: 0px 0px 20px 0px;
 576 font-size: 18px;
 577 font-weight: bold;
 578 }
 579 table.admintab {
 580 border: 1px solid #bacbdf;
 581 }
 582 td.admintab-hl {
 583 width: 100%;
 584 vertical-align: top;
 585 font-size: 13px;
 586 background: #d2ddea;
 587 }
 588 td.admintab-hl h2 {
 589 margin: 3px 0px;
 590 font-size: 15px;
 591 font-weight: bold;
 592 }
 593 td.admintab-hl p {
 594 font-size: 11px;
 595 line-height: 16px;
 596 margin: 0px 0px 3px 0px;
 597 padding: 0px;
 598 }
 599 td.admintab-l {
 600 width: 50%;
 601 vertical-align: top;
 602 font-size: 13px;
 603 background: #f5f5f5;
 604 }
 605 td.admintab-r {
 606 width: 50%;
 607 vertical-align: top;
 608 font-size: 13px;
 609 background: #f5f5f5;
 610 }
 611 .caution {
 612 color: red;
 613 font-weight: bold;
 614 }
 615 .small {
 616 font-size: 11px;
 617 line-height:16px;
 618 }
 619 a:link, a:visited {
 620 color: #0000cc;
 621 text-decoration: none;
 622 }
 623 a:focus, a:hover {
 624 color: #0000ff;
 625 text-decoration: underline;
 626 }
 627 -->
 628 </style>
 629 </head>
 630 <body>
 631 <div>
 632 <h1><?php echo $lang_add['install_title']; ?></h1>
 633 <?php echo $output; ?>
 634 </div>
 635 </body>
 636 </html>