Verzeichnisstruktur phpBB-1.0.0


Veröffentlicht
15.12.2000

So funktioniert es

Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück

Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis.
Auf den Verzeichnisnamen klicken, dies zeigt nur das Verzeichnis mit Inhalt an
      (Beispiel Datei-Icons)

Auf das Icon klicken um den Quellcode anzuzeigen

install.php

Zuletzt modifiziert: 09.10.2024, 12:50 - Dateigröße: 28.12 KiB


 001  <?php
 002  /***************************************************************************
 003  *                           install.php  -  description
 004  *                              -------------------
 005  *     begin                : Sat Oct 14 2000
 006  *     copyright            : (C) 2000 by James Atkinson
 007  *     email                : james@totalgeek.org
 008  * 
 009  *     $Id: install.php,v 1.21 2000/12/04 09:20:23 thefinn Exp $
 010  * 
 011  ****************************************************************************/
 012    
 013  /***************************************************************************
 014  *
 015  *   This program is free software; you can redistribute it and/or modify
 016  *   it under the terms of the GNU General Public License as published by
 017  *   the Free Software Foundation; either version 2 of the License, or
 018  *   (at your option) any later version.
 019  *
 020  ***************************************************************************/
 021  include('extention.inc');
 022  ?>
 023  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Strict//EN">
 024            <HTML>
 025            <HEAD>
 026            <TITLE>phpBB - Installation</TITLE>
 027            </HEAD>
 028            <BODY BGCOLOR="#000000" TEXT="#FFFFFF" LINK="#11C6BD" VLINK="#11C6BD">
 029    
 030    
 031  <?php
 032  if($next) {
 033     switch($next) {
 034      case 'database':
 035        if(!$done) {
 036       echo "Testing DB Connection...";
 037       flush();
 038       if(!$db = mysql_connect("$dbserver", "$dbuser", "$dbpass"))
 039         die("<font color=\"#FF0000\">Error, I could not connect to the database at $dbserver. Using username $dbuser and password $dbpass.<BR>Please go back and try again.");
 040       echo "<font color=\"#00FF00\">DB Connection Good!</FONT><BR>";
 041       flush();
 042       echo "Selected database $dbname...";
 043       flush();
 044       if(!@mysql_select_db("$dbname", $db)) {
 045          echo "<font color=\"#FF0000\">Database could not be found</font><BR>";
 046          flush();
 047          echo "Attempting to create database $dbname...";
 048          flush();
 049          if(!$r = mysql_query("CREATE DATABASE $dbname", $db))
 050            die("<font color=\"#FF0000\">Error, count not select or create database $dbname, please create it manually or have your system administrator do it for you and try again.");
 051          mysql_select_db("$dbname", $db);
 052          echo "<font color=\"#00FF00\">Database Created!</font><BR>";
 053          flush();
 054       }
 055       else
 056         echo "<font color=\"#00FF00\">Database Selected!</font><BR>";
 057       flush();
 058       echo "Creating phpBB tables an inserting default data...<BR>";
 059       flush();
 060       $tables = array ("cat" => "CREATE TABLE catagories (
 061                                   cat_id int(10) DEFAULT '0' NOT NULL auto_increment,
 062                                   cat_title varchar(100),
 063                                   cat_order varchar(10),
 064                                   PRIMARY KEY (cat_id)
 065                                   )",
 066                "config" => "CREATE TABLE config (
 067                                  config_id int(10) DEFAULT '0' NOT NULL auto_increment,
 068                                  sitename varchar(100),
 069                                  allow_html int(2),
 070                                  allow_bbcode int(2),
 071                                  allow_sig int(2),
 072                                  allow_namechange int(2) DEFAULT '0',
 073                                  admin_passwd varchar(32),
 074                                  selected int(2) DEFAULT '0' NOT NULL,
 075                                  posts_per_page int(10),
 076                                  hot_threshold int(10),
 077                                  topics_per_page int(10),
 078                                  allow_theme_create int(10),
 079                                  override_themes int(2) DEFAULT '0',
 080                                  email_sig varchar(255),
 081                                  email_from varchar(100),
 082                                  UNIQUE selected (selected),
 083                                  PRIMARY KEY (config_id)
 084                                  )",
 085                "disallow" => "CREATE TABLE disallow (
 086                                  disallow_id int(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
 087                                  disallow_username varchar(50),
 088                                  PRIMARY KEY(disallow_id)
 089                                  )",
 090                "forums" => "CREATE TABLE forums (   
 091                                  forum_id int(10) DEFAULT '0' NOT NULL auto_increment,
 092                                  forum_name varchar(150),
 093                                  forum_desc text, 
 094                                  forum_access int(10) DEFAULT '1',
 095                                  forum_moderator int(10),
 096                                  cat_id int(10),
 097                                  forum_type int(10) DEFAULT '0',
 098                                  forum_pass varchar(60), 
 099                                  PRIMARY KEY (forum_id)
 100                                  )",
 101                "hmf" => "CREATE TABLE headermetafooter (
 102                                     header text,
 103                                     meta text,
 104                                     footer text
 105                                     )",
 106                "ranks" => "CREATE TABLE ranks (
 107                                rank_id int(10) DEFAULT '0' NOT NULL auto_increment,
 108                                rank_title varchar(50) NOT NULL,
 109                                rank_min int(10) NOT NULL,
 110                                rank_max int(10) NOT NULL,
 111                                rank_special int(2) DEFAULT '0',
 112                                rank_image varchar(255),
 113                                PRIMARY KEY(rank_id),
 114                                KEY (rank_min),
 115                                KEY (rank_max) 
 116                                )",
 117                "posts" => "CREATE TABLE posts (
 118                                post_id int(10) DEFAULT '0' NOT NULL auto_increment,
 119                                topic_id int(10) DEFAULT '0' NOT NULL,
 120                                forum_id int(10) DEFAULT '0' NOT NULL,
 121                                poster_id int(10) NOT NULL,
 122                                post_text text,
 123                                post_time varchar(20),
 124                                poster_ip varchar(16),
 125                                KEY(post_id),
 126                                 KEY(forum_id),
 127                                KEY(topic_id),
 128                                    KEY(poster_id),
 129                                PRIMARY KEY (post_id)
 130                                )",
 131                "pmsg" => "CREATE TABLE priv_msgs (
 132                                   msg_id int(10) DEFAULT '0' NOT NULL auto_increment,
 133                                   from_userid int(10) DEFAULT '0' NOT NULL,
 134                                   to_userid int(10) DEFAULT '0' NOT NULL,
 135                                   msg_time varchar(20),
 136                                   poster_ip varchar(16),
 137                                   msg_text text, 
 138                                   PRIMARY KEY (msg_id),
 139                                   KEY msg_id (msg_id),
 140                                   KEY to_userid (to_userid)
 141                                   )",
 142                "sessions" => "CREATE TABLE sessions (
 143                                  sess_id int(10) unsigned DEFAULT '0' NOT NULL,
 144                                  user_id int(10) DEFAULT '0' NOT NULL,
 145                                  start_time int(10) unsigned DEFAULT '0' NOT NULL,
 146                                  remote_ip varchar(15) DEFAULT '' NOT NULL,
 147                                  PRIMARY KEY (sess_id),
 148                                  KEY sess_id (sess_id),
 149                                  KEY start_time (start_time),
 150                                  KEY remote_ip (remote_ip)
 151                                  )",
 152                "themes" => "CREATE TABLE themes (
 153                                  theme_id int(10) DEFAULT '0' NOT NULL auto_increment,
 154                                  theme_name varchar(35),
 155                                  bgcolor varchar(10),
 156                                  textcolor varchar(10),
 157                                  color1 varchar(10), 
 158                                  color2 varchar(10),
 159                                  table_bgcolor varchar(10),
 160                                  header_image varchar(50),
 161                                  newtopic_image varchar(50),
 162                                  reply_image varchar(50),
 163                                  linkcolor varchar(15),
 164                                  vlinkcolor varchar(15),
 165                                  theme_default int(2) DEFAULT '0',
 166                                  fontface varchar(100),
 167                                  fontsize1 varchar(5),
 168                                  fontsize2 varchar(5),
 169                                  fontsize3 varchar(5),
 170                                  fontsize4 varchar(5),
 171                                  tablewidth varchar(10),
 172                                  replylocked_image varchar(255),
 173                                  PRIMARY KEY (theme_id)
 174                                  )",
 175                "topics" => "CREATE TABLE topics (
 176                                  topic_id int(10) DEFAULT '0' NOT NULL auto_increment,
 177                                  topic_title varchar(100),
 178                                  topic_poster int(10),
 179                                  topic_time varchar(20),
 180                                  topic_views int(10) DEFAULT '0' NOT NULL,
 181                                  forum_id int(10) NOT NULL,
 182                                  topic_status int(10) DEFAULT '0' NOT NULL,
 183                                  topic_notify int(2) DEFAULT '0',
 184                                  KEY(topic_id),
 185                                  KEY(forum_id),
 186                                  PRIMARY KEY (topic_id) 
 187                                  )",
 188                "users" => "CREATE TABLE users (
 189                                user_id int(10) DEFAULT '0' NOT NULL auto_increment,
 190                                username varchar(40) DEFAULT '' NOT NULL,
 191                                user_regdate varchar(20) NOT NULL,
 192                                user_password varchar(32) DEFAULT '' NOT NULL,
 193                                user_email varchar(50),
 194                                user_icq varchar(15),
 195                                user_website varchar(100),
 196                                user_occ varchar(100),
 197                                user_from varchar(100),
 198                                user_intrest varchar(150),
 199                                user_sig varchar(255),
 200                                user_viewemail tinyint(2),
 201                                user_theme int(10),
 202                                user_aim varchar(18),  
 203                                user_yim varchar(25),
 204                                user_msnm varchar(25),
 205                                user_posts int(10) DEFAULT '0',
 206                                user_attachsig int(2) DEFAULT '0',
 207                                user_desmile int(2) DEFAULT '0',
 208                                user_html int(2) DEFAULT '0',
 209                                user_bbcode int(2) DEFAULT '0',
 210                                user_rank int(10) DEFAULT '0',
 211                                user_level int(10) DEFAULT '1',
 212                                user_actkey varchar(32),
 213                                user_newpasswd varchar(32),
 214                                PRIMARY KEY (user_id)
 215                                )",
 216                "online" => "CREATE TABLE whosonline (
 217                                  id int(3) DEFAULT '0' NOT NULL auto_increment,
 218                                  ip varchar(255),
 219                                  name varchar(255),   
 220                                  count varchar(255),
 221                                  date varchar(255),
 222                                  username varchar(40),  
 223                                  forum int(10),
 224                                  PRIMARY KEY (id)
 225                                  )",
 226                "acess" => "CREATE TABLE access (   
 227                                 access_id int(10) DEFAULT '0' NOT NULL auto_increment,
 228                                 access_title varchar(20),
 229                                 PRIMARY KEY (access_id)
 230                                 )",
 231   
 232                "smiles" => "CREATE TABLE smiles (
 233                                  id int(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
 234                                  code varchar(50),
 235                                  smile_url varchar(100),
 236                                  emotion varchar(75),
 237                                  PRIMARY KEY(id)
 238                                  )",
 239                "words" => "CREATE TABLE words (
 240                                word_id int(10) NOT NULL AUTO_INCREMENT DEFAULT '0',
 241                                word varchar(100),
 242                                replacement varchar(100),
 243                                PRIMARY KEY(word_id))",
 244                "banlist" => "CREATE TABLE banlist(
 245                                   ban_id int(10) NOT NULL AUTO_INCREMENT DEFAULT '0',
 246                                   ban_userid int(10),
 247                                   ban_ip varchar(16),
 248                                   ban_start int(32),
 249                                   ban_end int(50),
 250                                   ban_time_type int(10),
 251                                   KEY(ban_id),
 252                                   PRIMARY KEY(ban_id))",
 253                "forum_mods" => "CREATE TABLE forum_mods (
 254                                     forum_id int(10) NOT NULL,
 255                                     user_id int(10) NOT NULL
 256                                     )");
 257   
 258       $ta_users_data = "INSERT INTO users (user_id, username, user_regdate) VALUES (-1, 'Anonymous', 'May 12, 1978')";
 259       $ta_access_data = array("INSERT INTO access VALUES (-1, 'Deleted')",
 260                   "INSERT INTO access VALUES (1,'User')",
 261                   "INSERT INTO access VALUES (2,'Moderator')",
 262                   "INSERT INTO access VALUES (3,'Super Moderator')",
 263                   "INSERT INTO access VALUES (4,'Administrator')");
 264       $ta_themes_data = array("default" => "INSERT INTO themes VALUES (1,'Default','#000000','#FFFFFF','#6C706D','#2E4460','#001100','images/header-dark.jpg','images/new_topic-dark.jpg','images/reply-dark.jpg','#11C6BD','#11C6BD', '1', 'sans-serif', '1','2','-2','+1','95%','images/reply_locked-dark.jpg')",
 265                   "ocean" => "INSERT INTO themes VALUES (2,'Ocean','#FFFFFF','#000000','#CCCCCC','#9BB6DA','#000000','images/header.jpg','images/new_topic.jpg','images/reply.jpg','#011001','#2100cc', '0', 'sans-serif', '1','2','-2','+1','95%','images/reply_locked-dark.jpg')",
 266                   "OCPrices.com" => "INSERT INTO themes VALUES (3,'OCPrices.com','#FFFFFF','#000000','#efefef','#cdcdcd','#001100','images/header.jpg','images/new_topic.jpg','images/reply.jpg','#000000','#000000', '0', 'sans-serif', '1','2','-2','+1','95%','images/reply_locked-dark.jpg')");
 267       $ta_smile_data = array(
 268                  "INSERT INTO smiles VALUES (1,':D','icon_biggrin.gif','Very Happy')",
 269                  "INSERT INTO smiles VALUES (2,':-D','icon_biggrin.gif','Very Happy')",
 270                  "INSERT INTO smiles VALUES (3,':grin:','icon_biggrin.gif','Very Happy')",
 271                  "INSERT INTO smiles VALUES (4,':)','icon_smile.gif','Smile')",
 272                  "INSERT INTO smiles VALUES (5,':-)','icon_smile.gif','Smile')",
 273                  "INSERT INTO smiles VALUES (6,':smile:','icon_smile.gif','Smile')",
 274                  "INSERT INTO smiles VALUES (7,':(','icon_frown.gif','Sad')", 
 275                  "INSERT INTO smiles VALUES (8,':-(','icon_frown.gif','Sad')",
 276                  "INSERT INTO smiles VALUES (9,':sad:','icon_frown.gif','Sad')", 
 277                  "INSERT INTO smiles VALUES (10,':o','icon_eek.gif','Surprised')", 
 278                  "INSERT INTO smiles VALUES (11,':-o','icon_eek.gif','Surprised')",
 279                  "INSERT INTO smiles VALUES (12,':eek:','icon_eek.gif','Suprised')", 
 280                  "INSERT INTO smiles VALUES (13,':-?','icon_confused.gif','Confused')",
 281                  "INSERT INTO smiles VALUES (14,':???:','icon_confused.gif','Confused')",
 282                  "INSERT INTO smiles VALUES (15,'8)','icon_cool.gif','Cool')",
 283                  "INSERT INTO smiles VALUES (16,'8-)','icon_cool.gif','Cool')",
 284                  "INSERT INTO smiles VALUES (17,':cool:','icon_cool.gif','Cool')",
 285                  "INSERT INTO smiles VALUES (18,':lol:','icon_lol.gif','Laughing')",
 286                  "INSERT INTO smiles VALUES (19,':x','icon_mad.gif','Mad')",
 287                  "INSERT INTO smiles VALUES (20,':-x','icon_mad.gif','Mad')",
 288                  "INSERT INTO smiles VALUES (21,':mad:','icon_mad.gif','Mad')",
 289                  "INSERT INTO smiles VALUES (22,':P','icon_razz.gif','Razz')",
 290                  "INSERT INTO smiles VALUES (23,':-P','icon_razz.gif','Razz')",
 291                  "INSERT INTO smiles VALUES (24,':razz:','icon_razz.gif','Razz')",
 292                  "INSERT INTO smiles VALUES (25,':oops:','icon_redface.gif','Embaressed')",
 293                  "INSERT INTO smiles VALUES (26,':cry:','icon_cry.gif','Crying (very sad)')",
 294                  "INSERT INTO smiles VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad')",
 295                  "INSERT INTO smiles VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes')",
 296                  "INSERT INTO smiles VALUES (29,':wink:','icon_wink.gif','Wink')",
 297                  "INSERT INTO smiles VALUES (30,';)','icon_wink.gif','Wink')",
 298                  "INSERT INTO smiles VALUES (31,';-)','icon_wink.gif','Wink')");
 299       
 300       echo "<TABLE BORDER=\"0\">\n";
 301       while(list($name, $table) = each($tables)) {
 302          echo "<TR><TD>Creating table $name</TD> ";
 303          if(!$r = mysql_query($table, $db))
 304            die("<TD><font color=\"#FF0000\">ERROR! Could not create table. Reason: <b>". mysql_error()."</b></TD></TR></TABLE>");
 305          echo "<TD><font color=\"#00FF00\">[OK]</FONT></TD></TR>";
 306          flush();
 307       }
 308       echo "<TR><TD>Inserting default data</TD>";
 309       if(!$r = mysql_query($ta_users_data, $db))
 310         die("<TD>Error could not insert data into the users table. Reason: ". mysql_error() ."</TD></TR></TABLE>");
 311       for($x = 0; $x < count($ta_access_data); $x++) {
 312          if(!$r = mysql_query($ta_access_data[$x], $db))
 313            die("<TD>Error, could not insert data into the access table. Reason: ". mysql_error() . "</TD></TR></TABLE>");
 314       }
 315       while(list($name, $theme) = each($ta_themes_data)) {
 316          if(!$r = mysql_query($theme, $db))
 317            die("<TD><font color=\"#FF0000\">ERROR! Could not enter theme data. Reason: <b>". mysql_error()."</b></TD></TR></TABLE>");
 318       }
 319       for($x = 0; $x < count($ta_smile_data); $x++) { 
 320          if(!$r = mysql_query($ta_smile_data[$x], $db))
 321             die("<TD>Error, could not insert data into the access table. Reason: ". mysql_error() . "</TD></TR></TABLE>");
 322       }
 323       echo "<TD><font color=\"#00FF00\">[OK]</FONT></TD></TR>";
 324       echo "</TABLE>";
 325   
 326       echo "<font color=\"#00FF00\">Database Created Successfully!</FONT><BR>";
 327  ?>
 328         <CENTER>
 329         <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 330         <INPUT TYPE="HIDDEN" NAME="dbname" VALUE="<?php echo $dbname ?>">
 331         <INPUT TYPE="HIDDEN" NAME="dbserver" VALUE="<?php echo $dbserver ?>">
 332         <INPUT TYPE="HIDDEN" NAME="dbuser" VALUE="<?php echo $dbuser ?>">
 333         <INPUT TYPE="HIDDEN" NAME="dbpass" VALUE="<?php echo $dbpass ?>">
 334         <INPUT TYPE="HIDDEN" NAME="done" VALUE="1">
 335         <INPUT TYPE="HIDDEN" NAME="next" VALUE="database">
 336         <INPUT TYPE="SUBMIT" VALUE="Next >">
 337         </FORM>
 338         </CENTER>
 339  <?php       
 340         
 341        }
 342        else {
 343       $color1 = "#6C706D";
 344       $color2 = "#2E4460";
 345  ?>
 346          <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 347                 <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 348                       <TR>
 349                       <TD BGCOLOR="#001100">
 350                       <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 351                             <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 352                             <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 353                             </TR>
 354                             <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 355                             <TD COLSPAN="2">Now that you have created your database you must create an 'Administrator', a user who will be able to alter the settings of the forum.</TD>
 356                             </TR>
 357                             <TR>
 358         <TR ALIGN="LEFT">
 359         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Username: *</b><br><FONT SIZE=-2>(Must be unique. No 2 users can have the same Username)</FONT></TD>
 360         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="username" SIZE="25" MAXLENGTH="40"></TD>
 361         </TR>
 362         <TR ALIGN="LEFT">
 363         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Password: *</b></TD>
 364         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="PASSWORD" NAME="password" SIZE="25" MAXLENGTH="25"></TD>
 365         </TR>
 366         <TR ALIGN="LEFT">
 367         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Retype Password: *</b></TD>
 368         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="PASSWORD" NAME="password_rep" SIZE="25" MAXLENGTH="25"></TD>
 369         </TR>
 370         <TR ALIGN="LEFT">
 371         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Email Address: *<b></TD>
 372         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="email" SIZE="25" MAXLENGTH="50"></TD>
 373         </TR>
 374         <TR ALIGN="LEFT">
 375         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>ICQ Number: <b></TD>
 376         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="icq" SIZE="10" MAXLENGTH="15"></TD>
 377         </TR>
 378         <TR ALIGN="LEFT">
 379         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>AIM Name: <b></TD>
 380         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="aim" SIZE="15" MAXLENGTH="18"></TD>
 381         </TR>
 382         <TR ALIGN="LEFT">
 383         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Yahoo Messanger: <b></TD>
 384         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="yim" SIZE="25" MAXLENGTH="25"></TD>
 385         </TR>
 386         <TR ALIGN="LEFT">
 387         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>MSN Messanger: <b></TD>
 388         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="msnm" SIZE="25" MAXLENGTH="25"></TD>
 389         </TR>
 390         <TR ALIGN="LEFT">
 391         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Web Site Address: <b></TD>
 392         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="website" SIZE="25" MAXLENGTH="40" VALUE="http://"></TD>
 393         </TR>
 394         <TR ALIGN="LEFT">
 395         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Location: <b></TD>
 396         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="from" SIZE="25" MAXLENGTH="40"></TD>
 397         </TR>
 398         <TR ALIGN="LEFT">
 399         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Occupation: <b></TD>
 400         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="occ" SIZE="25" MAXLENGTH="40"></TD>
 401         </TR>
 402         <TR ALIGN="LEFT">
 403         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Intrests: <b></TD>
 404         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="intrest" SIZE="25" MAXLENGTH="40"></TD>
 405         </TR>
 406         <TR ALIGN="LEFT">
 407         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Signature:</b><br><font size=-2>This is a block of text that can be added to posts you make.<BR>255 chars max!</font></TD>
 408         <TD  BGCOLOR="<?php echo $color2?>"><TEXTAREA NAME="sig" ROWS=6 COLS=45></TEXTAREA></TD>
 409         </TR>
 410         <TR ALIGN="LEFT">
 411         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Options:</b></TD>
 412         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="CHECKBOX" NAME="viewemail" VALUE="1"> Allow other users to view my email address<BR>
 413         <INPUT TYPE="CHECKBOX" NAME="cookie_username" VALUE="1"> Store username in a cookie for 1 year.<BR>
 414         </TD>
 415         </TR>
 416         <TR ALIGN="LEFT">
 417         <TD  BGCOLOR="<?php echo $color1?>" colspan = 2><font size=-1>Items marked with a * are required</font></TD>
 418         </TR>
 419         <TR>
 420         <TD  BGCOLOR="<?php echo $color1?>" colspan=2 ALIGN="CENTER">
 421         <INPUT TYPE="HIDDEN" NAME="dbname" VALUE="<?php echo $dbname ?>">
 422         <INPUT TYPE="HIDDEN" NAME="dbserver" VALUE="<?php echo $dbserver ?>">
 423         <INPUT TYPE="HIDDEN" NAME="dbuser" VALUE="<?php echo $dbuser ?>">
 424         <INPUT TYPE="HIDDEN" NAME="dbpass" VALUE="<?php echo $dbpass ?>">
 425         <INPUT TYPE="HIDDEN" NAME="next" VALUE="user">
 426         <INPUT TYPE="SUBMIT" VALUE="Next >">&nbsp;<INPUT TYPE="RESET" VALUE="Clear">
 427         </TR>
 428         </TABLE></TD></TR></TABLE>
 429         </FORM>
 430  <?php       
 431       
 432        }
 433        break;
 434      case 'user':
 435        if(!$db = mysql_connect("$dbserver", "$dbuser", "$dbpass"))
 436      die("<font color=\"#FF0000\">Error, I could not connect to the database at $dbserver. Using username $dbuser and password $dbpass.<BR>Please go back and try again.");
 437        mysql_select_db("$dbname", $db);
 438       
 439        if($password == '' || $username == '' || $email == '')
 440      die("Error - you did not fill in all the required fields, please go back and fill them in.");
 441        
 442        if($password != $password_rep)
 443      die("The passwords you entered do not match. Please go back and try again");
 444        $sig = str_replace("\n", "<BR>", $sig);
 445        $sig = addslashes($sig);
 446        $occ = addslashes($occ);
 447        $intrest = addslashes($intrest);
 448        $from = addslashes($from);
 449        $passwd = md5($password);   
 450        $hint = addslashes($hint);
 451        $regdate = date("M d, Y");
 452        
 453        if(trim($website) == "http://")
 454      $website = "";
 455        
 456        if($viewemail == 1) {
 457       $sqlviewemail = "1";
 458        }
 459        else {
 460       $sqlviewemail = "0";
 461        }
 462        $sql = "INSERT INTO users (user_id, username, user_regdate, user_email, user_icq, user_password, user_occ, user_intrest, user_from, user_website, user_sig, 
 463                       user_aim, user_viewemail, user_yim, user_msnm, user_level) 
 464                               VALUES (1 , '$username', '$regdate', '$email', '$icq', '$passwd', '$occ', '$intrest', '$from', '$website', '$sig',
 465                   '$aim', '$sqlviewemail', '$yim', '$msnm', 4)";  
 466        if(!$result = mysql_query($sql, $db))
 467      die("An Error Occurred while trying to add the information into the database. Please go back and try again. <BR>$sql<BR>$mysql_error()");
 468        $color1 = "#6C706D";
 469        $color2 = "#2E4460";
 470        
 471  ?>
 472      <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 473      <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 474      <TR>
 475      <TD BGCOLOR="#001100">
 476      <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 477      <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 478      <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 479      </TR>
 480      <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 481      <TD COLSPAN="2">Administrator user, <b><?php echo $username ?></b> has been created successfully. Next you must set some forum wide options.</TD>
 482      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 483      <TD>Site Name:</TD>
 484      <TD><INPUT TYPE="TEXT" NAME="name" SIZE="30" MAXLENGTH="100"></TD>
 485      </TR>
 486      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 487      <TD>Email From Address:<br><font size="-1"><i>(This is the email address that will appear on all emails sent by the forums)</i></td>
 488      <TD><INPUT TYPE="TEXT" NAME="email_from" SIZE="30" MAXLENGTH="100"></TD>
 489      </TR>         
 490      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 491      <TD>Email Signature:<br><font size="-1"><i>(This is the email signature that will appear at the end of all emails sent by the forums)
 492      <TD><TEXTAREA NAME="email_sig" ROWS="5" COLS="15"></TEXTAREA></TD>                                                    
 493      </TR>  
 494      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 495      <TD>Allow HTML:</TD>
 496      <TD><INPUT TYPE="RADIO" NAME="html" VALUE="1" CHECKED> Yes <INPUT TYPE="RADIO" NAME="html" VALUE="0"> No</TD>
 497      </TR>
 498      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 499      <TD>Allow BBCode:</TD>
 500      <TD><INPUT TYPE="RADIO" NAME="bb" VALUE="1"CHECKED> Yes <INPUT TYPE="RADIO" NAME="bb" VALUE="0"> No</TD>
 501      </TR>                    
 502      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 503      <TD>Allow Signatures:</TD>
 504      <TD><INPUT TYPE="RADIO" NAME="sig" VALUE="1" CHECKED> Yes <INPUT TYPE="RADIO" NAME="sig" VALUE="0"> No</TD>
 505      </TR>
 506      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 507      <TD>Hot Topic Threshold:</FONT></TD>
 508      <TD><INPUT TYPE="TEXT" NAME="hot" SIZE="3" MAXLENGTH="3"></TD>
 509      </TR>
 510      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 511      <TD>Posts per Page:</FONT><br></TD>
 512      <TD><INPUT TYPE="TEXT" NAME="ppp" SIZE="3" MAXLENGTH="3" VALUE="<?php echo $posts_per_page?>"></TD>
 513      </TR>
 514      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 515      <TD>Topics per Forum:</TD>
 516      <TD><INPUT TYPE="TEXT" NAME="tpp" SIZE="3" MAXLENGTH="3" VALUE="<?php echo $topics_per_page?>"></TD>
 517      </TR>
 518      <TD BGCOLOR="<?php echo $color1?>" colspan=2 ALIGN="CENTER">
 519      <INPUT TYPE="HIDDEN" NAME="dbname" VALUE="<?php echo $dbname ?>">
 520      <INPUT TYPE="HIDDEN" NAME="dbserver" VALUE="<?php echo $dbserver ?>">
 521      <INPUT TYPE="HIDDEN" NAME="dbuser" VALUE="<?php echo $dbuser ?>">
 522      <INPUT TYPE="HIDDEN" NAME="dbpass" VALUE="<?php echo $dbpass ?>">
 523      <INPUT TYPE="HIDDEN" NAME="next" VALUE="options">
 524      <INPUT TYPE="SUBMIT" VALUE="Next >">&nbsp;<INPUT TYPE="RESET" VALUE="Clear">
 525      </TR>
 526      </TABLE></TD></TR></TABLE>
 527      </FORM>
 528  <?php    
 529      
 530        break;
 531      case 'options':
 532        $config_file = file("./config.$phpEx");
 533        if($config_file[count($config_file)] != "?>") {
 534       if(!$fp = fopen("./config.$phpEx", "a"))
 535         die("Error opening config.$phpEx, please check and make sure it exists in the same directory as this installation script and then try again.");
 536       $config_data = '$dbhost = "'.$dbserver.'";'."\n".
 537         '$dbname = "'.$dbname.'";'."\n".
 538         '$dbuser = "'.$dbuser.'";'."\n".
 539         '$dbpasswd = "'.$dbpass.'";'."\n".
 540         '?>'."\n";
 541        
 542       fputs($fp, $config_data);
 543       fclose($fp);
 544        }
 545        if(!$db = mysql_connect("$dbserver", "$dbuser", "$dbpass"))
 546      die("<font color=\"#FF0000\">Error, I could not connect to the database at $dbserver. Using username $dbuser and password $dbpass.<BR>Please go back and try again.");
 547        mysql_select_db("$dbname", $db);
 548        
 549        $name = addslashes($name);
 550        $email_sig = addslashes($email_sig);
 551        $sql = "INSERT INTO config (sitename, allow_html, allow_bbcode, allow_sig, hot_threshold, posts_per_page, topics_per_page, allow_theme_create, email_from, email_sig, selected) ";
 552        $sql .= "VALUES ('$name', $html, $bb, $sig, $hot, $ppp, $tpp, 0, '$email_from', '$email_sig', 1)";
 553        $result = mysql_query($sql, $db);
 554        if (!$result) {
 555       echo mysql_error() . "<br>";
 556       die("Error - Cannot update the database.</FONT");
 557        }
 558  ?>
 559  <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 560                     <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 561                           <TR>
 562                           <TD BGCOLOR="#001100">
 563                           <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 564                                 <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 565                                 <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 566                                 </TR>
 567                                 <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 568                                 <TD COLSPAN="2">Congratulations! You have now successfully installed phpBB.<P>Please make sure you have have also edited your config.php file correctly, and that
 569  you have read the INSTALL file that came with this software package.<P>You may now proceed to the <a href="admin/">Administration Area</a> and configure your forums and other settings.<P>Thank you for choosing phpBB<BR> - The phpBB
 570  Team.<BR> - <a href="http://www.phpbb.com/" target="_blank">http://www.phpBB.com/</a></TD>
 571  </TR>
 572  </TABLE></TD></TR></TABLE>             
 573  <?php
 574        break;
 575        }
 576  }
 577  else {
 578   
 579  ?>
 580      <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 581      <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 582            <TR>
 583            <TD BGCOLOR="#001100">
 584            <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 585                  <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 586                  <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 587                  </TR>
 588                  <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 589                  <TD COLSPAN="2">Thank you for choosing phpBB. This install will take only a few minutes of your time and when it is complete you will
 590                      have a forum that is ready to be posted to.<BR>The first step is to setup your database. In the form below please fill
 591                      in all areas of the form and press the 'next' button.
 592                  </TD>
 593                  </TR>
 594                  <TR ALIGN="LEFT">
 595                      <TD BGCOLOR="#6C706D">Database Server Address:</TD>
 596                  <TD BGCOLOR="#2E4460"><INPUT TYPE="TEXT" NAME="dbserver" SIZE="30"></TD>
 597                  </TR>
 598                  <TR>
 599                      <TD BGCOLOR="#6C706D">Database Name:</TD>
 600                  <TD BGCOLOR="#2E4460"><INPUT TYPE="TEXT" NAME="dbname" SIZE="30"></TD>
 601                  <TR>
 602                  <TD BGCOLOR="#6C706D">Database User name:</TD>
 603                  <TD BGCOLOR="#2E4460"><INPUT TYPE="TEXT" NAME="dbuser" SIZE="30"></TD>
 604                  </TR>
 605                  <TR>
 606                      <TD BGCOLOR="#6C706D">Database Password:</TD>
 607                  <TD BGCOLOR="#2E4460"><INPUT TYPE="PASSWORD" NAME="dbpass" SIZE="30"></TD>
 608                  </TR>
 609                  <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 610                  <TD COLSPAN="2"><INPUT TYPE="HIDDEN" NAME="next" VALUE="database"><INPUT TYPE="SUBMIT" VALUE="Next >"></TD>
 611                  </TR>
 612            </TABLE>
 613      </TD>
 614      </TR>
 615        </TABLE>
 616  <?php      
 617   
 618  }
 619  ?>
 620  </BODY>
 621  </HTML>
 622   
 623      
 624   

Powered by TreeView® & SyntaxHighlight® PHP-Tools © St. Frank

Verzeichnisstruktur phpBB-1.0.0

Zuletzt modifiziert: 09.10.2024, 12:50 - Dateigröße: 28.12 KiB

install.php


 001  <?php
 002  /***************************************************************************
 003  *                           install.php  -  description
 004  *                              -------------------
 005  *     begin                : Sat Oct 14 2000
 006  *     copyright            : (C) 2000 by James Atkinson
 007  *     email                : james@totalgeek.org
 008  * 
 009  *     $Id: install.php,v 1.21 2000/12/04 09:20:23 thefinn Exp $
 010  * 
 011  ****************************************************************************/
 012    
 013  /***************************************************************************
 014  *
 015  *   This program is free software; you can redistribute it and/or modify
 016  *   it under the terms of the GNU General Public License as published by
 017  *   the Free Software Foundation; either version 2 of the License, or
 018  *   (at your option) any later version.
 019  *
 020  ***************************************************************************/
 021  include('extention.inc');
 022  ?>
 023  <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Strict//EN">
 024            <HTML>
 025            <HEAD>
 026            <TITLE>phpBB - Installation</TITLE>
 027            </HEAD>
 028            <BODY BGCOLOR="#000000" TEXT="#FFFFFF" LINK="#11C6BD" VLINK="#11C6BD">
 029    
 030    
 031  <?php
 032  if($next) {
 033     switch($next) {
 034      case 'database':
 035        if(!$done) {
 036       echo "Testing DB Connection...";
 037       flush();
 038       if(!$db = mysql_connect("$dbserver", "$dbuser", "$dbpass"))
 039         die("<font color=\"#FF0000\">Error, I could not connect to the database at $dbserver. Using username $dbuser and password $dbpass.<BR>Please go back and try again.");
 040       echo "<font color=\"#00FF00\">DB Connection Good!</FONT><BR>";
 041       flush();
 042       echo "Selected database $dbname...";
 043       flush();
 044       if(!@mysql_select_db("$dbname", $db)) {
 045          echo "<font color=\"#FF0000\">Database could not be found</font><BR>";
 046          flush();
 047          echo "Attempting to create database $dbname...";
 048          flush();
 049          if(!$r = mysql_query("CREATE DATABASE $dbname", $db))
 050            die("<font color=\"#FF0000\">Error, count not select or create database $dbname, please create it manually or have your system administrator do it for you and try again.");
 051          mysql_select_db("$dbname", $db);
 052          echo "<font color=\"#00FF00\">Database Created!</font><BR>";
 053          flush();
 054       }
 055       else
 056         echo "<font color=\"#00FF00\">Database Selected!</font><BR>";
 057       flush();
 058       echo "Creating phpBB tables an inserting default data...<BR>";
 059       flush();
 060       $tables = array ("cat" => "CREATE TABLE catagories (
 061                                   cat_id int(10) DEFAULT '0' NOT NULL auto_increment,
 062                                   cat_title varchar(100),
 063                                   cat_order varchar(10),
 064                                   PRIMARY KEY (cat_id)
 065                                   )",
 066                "config" => "CREATE TABLE config (
 067                                  config_id int(10) DEFAULT '0' NOT NULL auto_increment,
 068                                  sitename varchar(100),
 069                                  allow_html int(2),
 070                                  allow_bbcode int(2),
 071                                  allow_sig int(2),
 072                                  allow_namechange int(2) DEFAULT '0',
 073                                  admin_passwd varchar(32),
 074                                  selected int(2) DEFAULT '0' NOT NULL,
 075                                  posts_per_page int(10),
 076                                  hot_threshold int(10),
 077                                  topics_per_page int(10),
 078                                  allow_theme_create int(10),
 079                                  override_themes int(2) DEFAULT '0',
 080                                  email_sig varchar(255),
 081                                  email_from varchar(100),
 082                                  UNIQUE selected (selected),
 083                                  PRIMARY KEY (config_id)
 084                                  )",
 085                "disallow" => "CREATE TABLE disallow (
 086                                  disallow_id int(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
 087                                  disallow_username varchar(50),
 088                                  PRIMARY KEY(disallow_id)
 089                                  )",
 090                "forums" => "CREATE TABLE forums (   
 091                                  forum_id int(10) DEFAULT '0' NOT NULL auto_increment,
 092                                  forum_name varchar(150),
 093                                  forum_desc text, 
 094                                  forum_access int(10) DEFAULT '1',
 095                                  forum_moderator int(10),
 096                                  cat_id int(10),
 097                                  forum_type int(10) DEFAULT '0',
 098                                  forum_pass varchar(60), 
 099                                  PRIMARY KEY (forum_id)
 100                                  )",
 101                "hmf" => "CREATE TABLE headermetafooter (
 102                                     header text,
 103                                     meta text,
 104                                     footer text
 105                                     )",
 106                "ranks" => "CREATE TABLE ranks (
 107                                rank_id int(10) DEFAULT '0' NOT NULL auto_increment,
 108                                rank_title varchar(50) NOT NULL,
 109                                rank_min int(10) NOT NULL,
 110                                rank_max int(10) NOT NULL,
 111                                rank_special int(2) DEFAULT '0',
 112                                rank_image varchar(255),
 113                                PRIMARY KEY(rank_id),
 114                                KEY (rank_min),
 115                                KEY (rank_max) 
 116                                )",
 117                "posts" => "CREATE TABLE posts (
 118                                post_id int(10) DEFAULT '0' NOT NULL auto_increment,
 119                                topic_id int(10) DEFAULT '0' NOT NULL,
 120                                forum_id int(10) DEFAULT '0' NOT NULL,
 121                                poster_id int(10) NOT NULL,
 122                                post_text text,
 123                                post_time varchar(20),
 124                                poster_ip varchar(16),
 125                                KEY(post_id),
 126                                 KEY(forum_id),
 127                                KEY(topic_id),
 128                                    KEY(poster_id),
 129                                PRIMARY KEY (post_id)
 130                                )",
 131                "pmsg" => "CREATE TABLE priv_msgs (
 132                                   msg_id int(10) DEFAULT '0' NOT NULL auto_increment,
 133                                   from_userid int(10) DEFAULT '0' NOT NULL,
 134                                   to_userid int(10) DEFAULT '0' NOT NULL,
 135                                   msg_time varchar(20),
 136                                   poster_ip varchar(16),
 137                                   msg_text text, 
 138                                   PRIMARY KEY (msg_id),
 139                                   KEY msg_id (msg_id),
 140                                   KEY to_userid (to_userid)
 141                                   )",
 142                "sessions" => "CREATE TABLE sessions (
 143                                  sess_id int(10) unsigned DEFAULT '0' NOT NULL,
 144                                  user_id int(10) DEFAULT '0' NOT NULL,
 145                                  start_time int(10) unsigned DEFAULT '0' NOT NULL,
 146                                  remote_ip varchar(15) DEFAULT '' NOT NULL,
 147                                  PRIMARY KEY (sess_id),
 148                                  KEY sess_id (sess_id),
 149                                  KEY start_time (start_time),
 150                                  KEY remote_ip (remote_ip)
 151                                  )",
 152                "themes" => "CREATE TABLE themes (
 153                                  theme_id int(10) DEFAULT '0' NOT NULL auto_increment,
 154                                  theme_name varchar(35),
 155                                  bgcolor varchar(10),
 156                                  textcolor varchar(10),
 157                                  color1 varchar(10), 
 158                                  color2 varchar(10),
 159                                  table_bgcolor varchar(10),
 160                                  header_image varchar(50),
 161                                  newtopic_image varchar(50),
 162                                  reply_image varchar(50),
 163                                  linkcolor varchar(15),
 164                                  vlinkcolor varchar(15),
 165                                  theme_default int(2) DEFAULT '0',
 166                                  fontface varchar(100),
 167                                  fontsize1 varchar(5),
 168                                  fontsize2 varchar(5),
 169                                  fontsize3 varchar(5),
 170                                  fontsize4 varchar(5),
 171                                  tablewidth varchar(10),
 172                                  replylocked_image varchar(255),
 173                                  PRIMARY KEY (theme_id)
 174                                  )",
 175                "topics" => "CREATE TABLE topics (
 176                                  topic_id int(10) DEFAULT '0' NOT NULL auto_increment,
 177                                  topic_title varchar(100),
 178                                  topic_poster int(10),
 179                                  topic_time varchar(20),
 180                                  topic_views int(10) DEFAULT '0' NOT NULL,
 181                                  forum_id int(10) NOT NULL,
 182                                  topic_status int(10) DEFAULT '0' NOT NULL,
 183                                  topic_notify int(2) DEFAULT '0',
 184                                  KEY(topic_id),
 185                                  KEY(forum_id),
 186                                  PRIMARY KEY (topic_id) 
 187                                  )",
 188                "users" => "CREATE TABLE users (
 189                                user_id int(10) DEFAULT '0' NOT NULL auto_increment,
 190                                username varchar(40) DEFAULT '' NOT NULL,
 191                                user_regdate varchar(20) NOT NULL,
 192                                user_password varchar(32) DEFAULT '' NOT NULL,
 193                                user_email varchar(50),
 194                                user_icq varchar(15),
 195                                user_website varchar(100),
 196                                user_occ varchar(100),
 197                                user_from varchar(100),
 198                                user_intrest varchar(150),
 199                                user_sig varchar(255),
 200                                user_viewemail tinyint(2),
 201                                user_theme int(10),
 202                                user_aim varchar(18),  
 203                                user_yim varchar(25),
 204                                user_msnm varchar(25),
 205                                user_posts int(10) DEFAULT '0',
 206                                user_attachsig int(2) DEFAULT '0',
 207                                user_desmile int(2) DEFAULT '0',
 208                                user_html int(2) DEFAULT '0',
 209                                user_bbcode int(2) DEFAULT '0',
 210                                user_rank int(10) DEFAULT '0',
 211                                user_level int(10) DEFAULT '1',
 212                                user_actkey varchar(32),
 213                                user_newpasswd varchar(32),
 214                                PRIMARY KEY (user_id)
 215                                )",
 216                "online" => "CREATE TABLE whosonline (
 217                                  id int(3) DEFAULT '0' NOT NULL auto_increment,
 218                                  ip varchar(255),
 219                                  name varchar(255),   
 220                                  count varchar(255),
 221                                  date varchar(255),
 222                                  username varchar(40),  
 223                                  forum int(10),
 224                                  PRIMARY KEY (id)
 225                                  )",
 226                "acess" => "CREATE TABLE access (   
 227                                 access_id int(10) DEFAULT '0' NOT NULL auto_increment,
 228                                 access_title varchar(20),
 229                                 PRIMARY KEY (access_id)
 230                                 )",
 231   
 232                "smiles" => "CREATE TABLE smiles (
 233                                  id int(10) DEFAULT '0' NOT NULL AUTO_INCREMENT,
 234                                  code varchar(50),
 235                                  smile_url varchar(100),
 236                                  emotion varchar(75),
 237                                  PRIMARY KEY(id)
 238                                  )",
 239                "words" => "CREATE TABLE words (
 240                                word_id int(10) NOT NULL AUTO_INCREMENT DEFAULT '0',
 241                                word varchar(100),
 242                                replacement varchar(100),
 243                                PRIMARY KEY(word_id))",
 244                "banlist" => "CREATE TABLE banlist(
 245                                   ban_id int(10) NOT NULL AUTO_INCREMENT DEFAULT '0',
 246                                   ban_userid int(10),
 247                                   ban_ip varchar(16),
 248                                   ban_start int(32),
 249                                   ban_end int(50),
 250                                   ban_time_type int(10),
 251                                   KEY(ban_id),
 252                                   PRIMARY KEY(ban_id))",
 253                "forum_mods" => "CREATE TABLE forum_mods (
 254                                     forum_id int(10) NOT NULL,
 255                                     user_id int(10) NOT NULL
 256                                     )");
 257   
 258       $ta_users_data = "INSERT INTO users (user_id, username, user_regdate) VALUES (-1, 'Anonymous', 'May 12, 1978')";
 259       $ta_access_data = array("INSERT INTO access VALUES (-1, 'Deleted')",
 260                   "INSERT INTO access VALUES (1,'User')",
 261                   "INSERT INTO access VALUES (2,'Moderator')",
 262                   "INSERT INTO access VALUES (3,'Super Moderator')",
 263                   "INSERT INTO access VALUES (4,'Administrator')");
 264       $ta_themes_data = array("default" => "INSERT INTO themes VALUES (1,'Default','#000000','#FFFFFF','#6C706D','#2E4460','#001100','images/header-dark.jpg','images/new_topic-dark.jpg','images/reply-dark.jpg','#11C6BD','#11C6BD', '1', 'sans-serif', '1','2','-2','+1','95%','images/reply_locked-dark.jpg')",
 265                   "ocean" => "INSERT INTO themes VALUES (2,'Ocean','#FFFFFF','#000000','#CCCCCC','#9BB6DA','#000000','images/header.jpg','images/new_topic.jpg','images/reply.jpg','#011001','#2100cc', '0', 'sans-serif', '1','2','-2','+1','95%','images/reply_locked-dark.jpg')",
 266                   "OCPrices.com" => "INSERT INTO themes VALUES (3,'OCPrices.com','#FFFFFF','#000000','#efefef','#cdcdcd','#001100','images/header.jpg','images/new_topic.jpg','images/reply.jpg','#000000','#000000', '0', 'sans-serif', '1','2','-2','+1','95%','images/reply_locked-dark.jpg')");
 267       $ta_smile_data = array(
 268                  "INSERT INTO smiles VALUES (1,':D','icon_biggrin.gif','Very Happy')",
 269                  "INSERT INTO smiles VALUES (2,':-D','icon_biggrin.gif','Very Happy')",
 270                  "INSERT INTO smiles VALUES (3,':grin:','icon_biggrin.gif','Very Happy')",
 271                  "INSERT INTO smiles VALUES (4,':)','icon_smile.gif','Smile')",
 272                  "INSERT INTO smiles VALUES (5,':-)','icon_smile.gif','Smile')",
 273                  "INSERT INTO smiles VALUES (6,':smile:','icon_smile.gif','Smile')",
 274                  "INSERT INTO smiles VALUES (7,':(','icon_frown.gif','Sad')", 
 275                  "INSERT INTO smiles VALUES (8,':-(','icon_frown.gif','Sad')",
 276                  "INSERT INTO smiles VALUES (9,':sad:','icon_frown.gif','Sad')", 
 277                  "INSERT INTO smiles VALUES (10,':o','icon_eek.gif','Surprised')", 
 278                  "INSERT INTO smiles VALUES (11,':-o','icon_eek.gif','Surprised')",
 279                  "INSERT INTO smiles VALUES (12,':eek:','icon_eek.gif','Suprised')", 
 280                  "INSERT INTO smiles VALUES (13,':-?','icon_confused.gif','Confused')",
 281                  "INSERT INTO smiles VALUES (14,':???:','icon_confused.gif','Confused')",
 282                  "INSERT INTO smiles VALUES (15,'8)','icon_cool.gif','Cool')",
 283                  "INSERT INTO smiles VALUES (16,'8-)','icon_cool.gif','Cool')",
 284                  "INSERT INTO smiles VALUES (17,':cool:','icon_cool.gif','Cool')",
 285                  "INSERT INTO smiles VALUES (18,':lol:','icon_lol.gif','Laughing')",
 286                  "INSERT INTO smiles VALUES (19,':x','icon_mad.gif','Mad')",
 287                  "INSERT INTO smiles VALUES (20,':-x','icon_mad.gif','Mad')",
 288                  "INSERT INTO smiles VALUES (21,':mad:','icon_mad.gif','Mad')",
 289                  "INSERT INTO smiles VALUES (22,':P','icon_razz.gif','Razz')",
 290                  "INSERT INTO smiles VALUES (23,':-P','icon_razz.gif','Razz')",
 291                  "INSERT INTO smiles VALUES (24,':razz:','icon_razz.gif','Razz')",
 292                  "INSERT INTO smiles VALUES (25,':oops:','icon_redface.gif','Embaressed')",
 293                  "INSERT INTO smiles VALUES (26,':cry:','icon_cry.gif','Crying (very sad)')",
 294                  "INSERT INTO smiles VALUES (27,':evil:','icon_evil.gif','Evil or Very Mad')",
 295                  "INSERT INTO smiles VALUES (28,':roll:','icon_rolleyes.gif','Rolling Eyes')",
 296                  "INSERT INTO smiles VALUES (29,':wink:','icon_wink.gif','Wink')",
 297                  "INSERT INTO smiles VALUES (30,';)','icon_wink.gif','Wink')",
 298                  "INSERT INTO smiles VALUES (31,';-)','icon_wink.gif','Wink')");
 299       
 300       echo "<TABLE BORDER=\"0\">\n";
 301       while(list($name, $table) = each($tables)) {
 302          echo "<TR><TD>Creating table $name</TD> ";
 303          if(!$r = mysql_query($table, $db))
 304            die("<TD><font color=\"#FF0000\">ERROR! Could not create table. Reason: <b>". mysql_error()."</b></TD></TR></TABLE>");
 305          echo "<TD><font color=\"#00FF00\">[OK]</FONT></TD></TR>";
 306          flush();
 307       }
 308       echo "<TR><TD>Inserting default data</TD>";
 309       if(!$r = mysql_query($ta_users_data, $db))
 310         die("<TD>Error could not insert data into the users table. Reason: ". mysql_error() ."</TD></TR></TABLE>");
 311       for($x = 0; $x < count($ta_access_data); $x++) {
 312          if(!$r = mysql_query($ta_access_data[$x], $db))
 313            die("<TD>Error, could not insert data into the access table. Reason: ". mysql_error() . "</TD></TR></TABLE>");
 314       }
 315       while(list($name, $theme) = each($ta_themes_data)) {
 316          if(!$r = mysql_query($theme, $db))
 317            die("<TD><font color=\"#FF0000\">ERROR! Could not enter theme data. Reason: <b>". mysql_error()."</b></TD></TR></TABLE>");
 318       }
 319       for($x = 0; $x < count($ta_smile_data); $x++) { 
 320          if(!$r = mysql_query($ta_smile_data[$x], $db))
 321             die("<TD>Error, could not insert data into the access table. Reason: ". mysql_error() . "</TD></TR></TABLE>");
 322       }
 323       echo "<TD><font color=\"#00FF00\">[OK]</FONT></TD></TR>";
 324       echo "</TABLE>";
 325   
 326       echo "<font color=\"#00FF00\">Database Created Successfully!</FONT><BR>";
 327  ?>
 328         <CENTER>
 329         <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 330         <INPUT TYPE="HIDDEN" NAME="dbname" VALUE="<?php echo $dbname ?>">
 331         <INPUT TYPE="HIDDEN" NAME="dbserver" VALUE="<?php echo $dbserver ?>">
 332         <INPUT TYPE="HIDDEN" NAME="dbuser" VALUE="<?php echo $dbuser ?>">
 333         <INPUT TYPE="HIDDEN" NAME="dbpass" VALUE="<?php echo $dbpass ?>">
 334         <INPUT TYPE="HIDDEN" NAME="done" VALUE="1">
 335         <INPUT TYPE="HIDDEN" NAME="next" VALUE="database">
 336         <INPUT TYPE="SUBMIT" VALUE="Next >">
 337         </FORM>
 338         </CENTER>
 339  <?php       
 340         
 341        }
 342        else {
 343       $color1 = "#6C706D";
 344       $color2 = "#2E4460";
 345  ?>
 346          <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 347                 <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 348                       <TR>
 349                       <TD BGCOLOR="#001100">
 350                       <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 351                             <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 352                             <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 353                             </TR>
 354                             <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 355                             <TD COLSPAN="2">Now that you have created your database you must create an 'Administrator', a user who will be able to alter the settings of the forum.</TD>
 356                             </TR>
 357                             <TR>
 358         <TR ALIGN="LEFT">
 359         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Username: *</b><br><FONT SIZE=-2>(Must be unique. No 2 users can have the same Username)</FONT></TD>
 360         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="username" SIZE="25" MAXLENGTH="40"></TD>
 361         </TR>
 362         <TR ALIGN="LEFT">
 363         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Password: *</b></TD>
 364         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="PASSWORD" NAME="password" SIZE="25" MAXLENGTH="25"></TD>
 365         </TR>
 366         <TR ALIGN="LEFT">
 367         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Retype Password: *</b></TD>
 368         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="PASSWORD" NAME="password_rep" SIZE="25" MAXLENGTH="25"></TD>
 369         </TR>
 370         <TR ALIGN="LEFT">
 371         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Email Address: *<b></TD>
 372         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="email" SIZE="25" MAXLENGTH="50"></TD>
 373         </TR>
 374         <TR ALIGN="LEFT">
 375         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>ICQ Number: <b></TD>
 376         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="icq" SIZE="10" MAXLENGTH="15"></TD>
 377         </TR>
 378         <TR ALIGN="LEFT">
 379         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>AIM Name: <b></TD>
 380         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="aim" SIZE="15" MAXLENGTH="18"></TD>
 381         </TR>
 382         <TR ALIGN="LEFT">
 383         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Yahoo Messanger: <b></TD>
 384         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="yim" SIZE="25" MAXLENGTH="25"></TD>
 385         </TR>
 386         <TR ALIGN="LEFT">
 387         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>MSN Messanger: <b></TD>
 388         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="msnm" SIZE="25" MAXLENGTH="25"></TD>
 389         </TR>
 390         <TR ALIGN="LEFT">
 391         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Web Site Address: <b></TD>
 392         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="website" SIZE="25" MAXLENGTH="40" VALUE="http://"></TD>
 393         </TR>
 394         <TR ALIGN="LEFT">
 395         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Location: <b></TD>
 396         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="from" SIZE="25" MAXLENGTH="40"></TD>
 397         </TR>
 398         <TR ALIGN="LEFT">
 399         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Occupation: <b></TD>
 400         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="occ" SIZE="25" MAXLENGTH="40"></TD>
 401         </TR>
 402         <TR ALIGN="LEFT">
 403         <TD  BGCOLOR="<?php echo $color1?>"  width=25%><b>Intrests: <b></TD>
 404         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="TEXT" NAME="intrest" SIZE="25" MAXLENGTH="40"></TD>
 405         </TR>
 406         <TR ALIGN="LEFT">
 407         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Signature:</b><br><font size=-2>This is a block of text that can be added to posts you make.<BR>255 chars max!</font></TD>
 408         <TD  BGCOLOR="<?php echo $color2?>"><TEXTAREA NAME="sig" ROWS=6 COLS=45></TEXTAREA></TD>
 409         </TR>
 410         <TR ALIGN="LEFT">
 411         <TD  BGCOLOR="<?php echo $color1?>" width=25%><b>Options:</b></TD>
 412         <TD  BGCOLOR="<?php echo $color2?>"><INPUT TYPE="CHECKBOX" NAME="viewemail" VALUE="1"> Allow other users to view my email address<BR>
 413         <INPUT TYPE="CHECKBOX" NAME="cookie_username" VALUE="1"> Store username in a cookie for 1 year.<BR>
 414         </TD>
 415         </TR>
 416         <TR ALIGN="LEFT">
 417         <TD  BGCOLOR="<?php echo $color1?>" colspan = 2><font size=-1>Items marked with a * are required</font></TD>
 418         </TR>
 419         <TR>
 420         <TD  BGCOLOR="<?php echo $color1?>" colspan=2 ALIGN="CENTER">
 421         <INPUT TYPE="HIDDEN" NAME="dbname" VALUE="<?php echo $dbname ?>">
 422         <INPUT TYPE="HIDDEN" NAME="dbserver" VALUE="<?php echo $dbserver ?>">
 423         <INPUT TYPE="HIDDEN" NAME="dbuser" VALUE="<?php echo $dbuser ?>">
 424         <INPUT TYPE="HIDDEN" NAME="dbpass" VALUE="<?php echo $dbpass ?>">
 425         <INPUT TYPE="HIDDEN" NAME="next" VALUE="user">
 426         <INPUT TYPE="SUBMIT" VALUE="Next >">&nbsp;<INPUT TYPE="RESET" VALUE="Clear">
 427         </TR>
 428         </TABLE></TD></TR></TABLE>
 429         </FORM>
 430  <?php       
 431       
 432        }
 433        break;
 434      case 'user':
 435        if(!$db = mysql_connect("$dbserver", "$dbuser", "$dbpass"))
 436      die("<font color=\"#FF0000\">Error, I could not connect to the database at $dbserver. Using username $dbuser and password $dbpass.<BR>Please go back and try again.");
 437        mysql_select_db("$dbname", $db);
 438       
 439        if($password == '' || $username == '' || $email == '')
 440      die("Error - you did not fill in all the required fields, please go back and fill them in.");
 441        
 442        if($password != $password_rep)
 443      die("The passwords you entered do not match. Please go back and try again");
 444        $sig = str_replace("\n", "<BR>", $sig);
 445        $sig = addslashes($sig);
 446        $occ = addslashes($occ);
 447        $intrest = addslashes($intrest);
 448        $from = addslashes($from);
 449        $passwd = md5($password);   
 450        $hint = addslashes($hint);
 451        $regdate = date("M d, Y");
 452        
 453        if(trim($website) == "http://")
 454      $website = "";
 455        
 456        if($viewemail == 1) {
 457       $sqlviewemail = "1";
 458        }
 459        else {
 460       $sqlviewemail = "0";
 461        }
 462        $sql = "INSERT INTO users (user_id, username, user_regdate, user_email, user_icq, user_password, user_occ, user_intrest, user_from, user_website, user_sig, 
 463                       user_aim, user_viewemail, user_yim, user_msnm, user_level) 
 464                               VALUES (1 , '$username', '$regdate', '$email', '$icq', '$passwd', '$occ', '$intrest', '$from', '$website', '$sig',
 465                   '$aim', '$sqlviewemail', '$yim', '$msnm', 4)";  
 466        if(!$result = mysql_query($sql, $db))
 467      die("An Error Occurred while trying to add the information into the database. Please go back and try again. <BR>$sql<BR>$mysql_error()");
 468        $color1 = "#6C706D";
 469        $color2 = "#2E4460";
 470        
 471  ?>
 472      <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 473      <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 474      <TR>
 475      <TD BGCOLOR="#001100">
 476      <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 477      <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 478      <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 479      </TR>
 480      <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 481      <TD COLSPAN="2">Administrator user, <b><?php echo $username ?></b> has been created successfully. Next you must set some forum wide options.</TD>
 482      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 483      <TD>Site Name:</TD>
 484      <TD><INPUT TYPE="TEXT" NAME="name" SIZE="30" MAXLENGTH="100"></TD>
 485      </TR>
 486      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 487      <TD>Email From Address:<br><font size="-1"><i>(This is the email address that will appear on all emails sent by the forums)</i></td>
 488      <TD><INPUT TYPE="TEXT" NAME="email_from" SIZE="30" MAXLENGTH="100"></TD>
 489      </TR>         
 490      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 491      <TD>Email Signature:<br><font size="-1"><i>(This is the email signature that will appear at the end of all emails sent by the forums)
 492      <TD><TEXTAREA NAME="email_sig" ROWS="5" COLS="15"></TEXTAREA></TD>                                                    
 493      </TR>  
 494      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 495      <TD>Allow HTML:</TD>
 496      <TD><INPUT TYPE="RADIO" NAME="html" VALUE="1" CHECKED> Yes <INPUT TYPE="RADIO" NAME="html" VALUE="0"> No</TD>
 497      </TR>
 498      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 499      <TD>Allow BBCode:</TD>
 500      <TD><INPUT TYPE="RADIO" NAME="bb" VALUE="1"CHECKED> Yes <INPUT TYPE="RADIO" NAME="bb" VALUE="0"> No</TD>
 501      </TR>                    
 502      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 503      <TD>Allow Signatures:</TD>
 504      <TD><INPUT TYPE="RADIO" NAME="sig" VALUE="1" CHECKED> Yes <INPUT TYPE="RADIO" NAME="sig" VALUE="0"> No</TD>
 505      </TR>
 506      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 507      <TD>Hot Topic Threshold:</FONT></TD>
 508      <TD><INPUT TYPE="TEXT" NAME="hot" SIZE="3" MAXLENGTH="3"></TD>
 509      </TR>
 510      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 511      <TD>Posts per Page:</FONT><br></TD>
 512      <TD><INPUT TYPE="TEXT" NAME="ppp" SIZE="3" MAXLENGTH="3" VALUE="<?php echo $posts_per_page?>"></TD>
 513      </TR>
 514      <TR BGCOLOR="<?php echo $color2?>" ALIGN="LEFT">
 515      <TD>Topics per Forum:</TD>
 516      <TD><INPUT TYPE="TEXT" NAME="tpp" SIZE="3" MAXLENGTH="3" VALUE="<?php echo $topics_per_page?>"></TD>
 517      </TR>
 518      <TD BGCOLOR="<?php echo $color1?>" colspan=2 ALIGN="CENTER">
 519      <INPUT TYPE="HIDDEN" NAME="dbname" VALUE="<?php echo $dbname ?>">
 520      <INPUT TYPE="HIDDEN" NAME="dbserver" VALUE="<?php echo $dbserver ?>">
 521      <INPUT TYPE="HIDDEN" NAME="dbuser" VALUE="<?php echo $dbuser ?>">
 522      <INPUT TYPE="HIDDEN" NAME="dbpass" VALUE="<?php echo $dbpass ?>">
 523      <INPUT TYPE="HIDDEN" NAME="next" VALUE="options">
 524      <INPUT TYPE="SUBMIT" VALUE="Next >">&nbsp;<INPUT TYPE="RESET" VALUE="Clear">
 525      </TR>
 526      </TABLE></TD></TR></TABLE>
 527      </FORM>
 528  <?php    
 529      
 530        break;
 531      case 'options':
 532        $config_file = file("./config.$phpEx");
 533        if($config_file[count($config_file)] != "?>") {
 534       if(!$fp = fopen("./config.$phpEx", "a"))
 535         die("Error opening config.$phpEx, please check and make sure it exists in the same directory as this installation script and then try again.");
 536       $config_data = '$dbhost = "'.$dbserver.'";'."\n".
 537         '$dbname = "'.$dbname.'";'."\n".
 538         '$dbuser = "'.$dbuser.'";'."\n".
 539         '$dbpasswd = "'.$dbpass.'";'."\n".
 540         '?>'."\n";
 541        
 542       fputs($fp, $config_data);
 543       fclose($fp);
 544        }
 545        if(!$db = mysql_connect("$dbserver", "$dbuser", "$dbpass"))
 546      die("<font color=\"#FF0000\">Error, I could not connect to the database at $dbserver. Using username $dbuser and password $dbpass.<BR>Please go back and try again.");
 547        mysql_select_db("$dbname", $db);
 548        
 549        $name = addslashes($name);
 550        $email_sig = addslashes($email_sig);
 551        $sql = "INSERT INTO config (sitename, allow_html, allow_bbcode, allow_sig, hot_threshold, posts_per_page, topics_per_page, allow_theme_create, email_from, email_sig, selected) ";
 552        $sql .= "VALUES ('$name', $html, $bb, $sig, $hot, $ppp, $tpp, 0, '$email_from', '$email_sig', 1)";
 553        $result = mysql_query($sql, $db);
 554        if (!$result) {
 555       echo mysql_error() . "<br>";
 556       die("Error - Cannot update the database.</FONT");
 557        }
 558  ?>
 559  <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 560                     <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 561                           <TR>
 562                           <TD BGCOLOR="#001100">
 563                           <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 564                                 <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 565                                 <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 566                                 </TR>
 567                                 <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 568                                 <TD COLSPAN="2">Congratulations! You have now successfully installed phpBB.<P>Please make sure you have have also edited your config.php file correctly, and that
 569  you have read the INSTALL file that came with this software package.<P>You may now proceed to the <a href="admin/">Administration Area</a> and configure your forums and other settings.<P>Thank you for choosing phpBB<BR> - The phpBB
 570  Team.<BR> - <a href="http://www.phpbb.com/" target="_blank">http://www.phpBB.com/</a></TD>
 571  </TR>
 572  </TABLE></TD></TR></TABLE>             
 573  <?php
 574        break;
 575        }
 576  }
 577  else {
 578   
 579  ?>
 580      <FORM METHOD="POST" ACTION="<?php echo $PHP_SELF ?>">
 581      <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="95%">
 582            <TR>
 583            <TD BGCOLOR="#001100">
 584            <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="1" WIDTH="100%">
 585                  <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 586                  <TD COLSPAN="2"><b>phpBB Installer</b></TD>
 587                  </TR>
 588                  <TR BGCOLOR="#2E4460" ALIGN="LEFT">
 589                  <TD COLSPAN="2">Thank you for choosing phpBB. This install will take only a few minutes of your time and when it is complete you will
 590                      have a forum that is ready to be posted to.<BR>The first step is to setup your database. In the form below please fill
 591                      in all areas of the form and press the 'next' button.
 592                  </TD>
 593                  </TR>
 594                  <TR ALIGN="LEFT">
 595                      <TD BGCOLOR="#6C706D">Database Server Address:</TD>
 596                  <TD BGCOLOR="#2E4460"><INPUT TYPE="TEXT" NAME="dbserver" SIZE="30"></TD>
 597                  </TR>
 598                  <TR>
 599                      <TD BGCOLOR="#6C706D">Database Name:</TD>
 600                  <TD BGCOLOR="#2E4460"><INPUT TYPE="TEXT" NAME="dbname" SIZE="30"></TD>
 601                  <TR>
 602                  <TD BGCOLOR="#6C706D">Database User name:</TD>
 603                  <TD BGCOLOR="#2E4460"><INPUT TYPE="TEXT" NAME="dbuser" SIZE="30"></TD>
 604                  </TR>
 605                  <TR>
 606                      <TD BGCOLOR="#6C706D">Database Password:</TD>
 607                  <TD BGCOLOR="#2E4460"><INPUT TYPE="PASSWORD" NAME="dbpass" SIZE="30"></TD>
 608                  </TR>
 609                  <TR BGCOLOR="#6C706D" ALIGN="CENTER">
 610                  <TD COLSPAN="2"><INPUT TYPE="HIDDEN" NAME="next" VALUE="database"><INPUT TYPE="SUBMIT" VALUE="Next >"></TD>
 611                  </TR>
 612            </TABLE>
 613      </TD>
 614      </TR>
 615        </TABLE>
 616  <?php      
 617   
 618  }
 619  ?>
 620  </BODY>
 621  </HTML>
 622   
 623      
 624   

Powered by TreeView® & SyntaxHighlight® PHP-Tools © St. Frank