<?php
require_once "conn.php";
$adminemail = "admin@yoursite.com";
$adminpass = "admin";
$adminname = "Admin";

/******* Access Levels Table *****************************************/
$sql = <<<EOS
CREATE TABLE forum_access_levels (
  access_lvl tinyint(4) NOT NULL auto_increment,
  access_name varchar(50) NOT NULL default '',
  PRIMARY KEY (access_lvl)
)
EOS;
$result = mysql_query($sql);
switch(mysql_errno()) {
  case 1050:
    break;
  case 0:
    $sql = "INSERT IGNORE INTO forum_access_levels
      VALUES (1,'User')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT IGNORE INTO forum_access_levels
      VALUES (2,'Moderator')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT IGNORE INTO forum_access_levels
      VALUES (3,'Administrator')";
    $result = mysql_query($sql) or die(mysql_error());
    break;
  default:
    die(mysql_error());
    break;
}
$a_tables[] = "forum_access_levels";

/******* Admin Table *************************************************/
$sql = <<<EOS
CREATE TABLE  forum_admin (
  id int(11) NOT NULL auto_increment,
  title varchar(100) NOT NULL default '',
  value varchar(255) NOT NULL default '',
  constant varchar(100) NOT NULL default '',
  PRIMARY KEY  (id)
)
EOS;
$result = mysql_query($sql);
switch(mysql_errno()) {
  case 1050:
    break;
  case 0:
    $sql = "INSERT INTO forum_admin VALUES (NULL,
      'Board Title', 'Comic Book Appreciation Forums', 'title')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT INTO forum_admin VALUES (NULL, ".
           "'Board Description', 'The place to discuss your favorite ".
           "comic books, movies, and more!', 'description')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT INTO forum_admin VALUES (NULL, ".
           "'Admin Email', '$adminemail', 'admin_email')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT INTO forum_admin VALUES (NULL, 'Copyright', ".
           "'Â© 2003 CBA Inc.  All rights reserved.', ".
           "'copyright')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT INTO forum_admin VALUES (NULL, ".
           "'Board Titlebar', 'CBA Forums', 'titlebar')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT INTO forum_admin VALUES (NULL, ".
           "'Pagination Limit', '10', 'pageLimit')";
    $result = mysql_query($sql) or die(mysql_error());
    $sql = "INSERT INTO forum_admin VALUES (NULL, ".
           "'Pagination Range', '7', 'pageRange')";
    $result = mysql_query($sql) or die(mysql_error());
    break;
  default:
    die(mysql_error());
    break;
}
$a_tables[] = "forum_admin";

/******* BBcode Table ************************************************/
$sql = <<<EOS
CREATE TABLE IF NOT EXISTS forum_bbcode (
  id int(11) NOT NULL auto_increment,
  template varchar(255) NOT NULL default '',
  replacement varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
)
EOS;
$result = mysql_query($sql) or die(mysql_error());
$a_tables[] = "forum_bbcode";

/******* Forum Table *************************************************/
$sql = <<<EOS
CREATE TABLE  forum_forum (
  id int(11) NOT NULL auto_increment,
  forum_name varchar(100) NOT NULL default '',
  forum_desc varchar(255) NOT NULL default '',
  forum_moderator int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
)
EOS;
$result = mysql_query($sql);
switch(mysql_errno()) {
  case 1050:
    break;
  case 0:
    $sql = "INSERT INTO forum_forum VALUES (NULL, 'New Forum', ".
           "'This is the initial forum created when installing the ".
           "database.  Change the name and the description after ".
           "installation.', 1)";
    $result = mysql_query($sql) or die(mysql_error());
    break;
  default:
    die(mysql_error());
    break;
}
$a_tables[] = "forum_forum";

/******* Post Count Table ********************************************/
$sql = <<<EOS
CREATE TABLE forum_postcount (
  user_id int(11) NOT NULL default '0',
  count int(9) NOT NULL default '0',
  PRIMARY KEY  (user_id)
)
EOS;
$result = mysql_query($sql);
switch(mysql_errno()) {
  case 1050:
    break;
  case 0:
    $sql = "INSERT INTO forum_postcount VALUES (1,1)";
    $result = mysql_query($sql) or die(mysql_error());
    break;
  default:
    die(mysql_error());
    break;
}
$a_tables[] = "forum_postcount";

/******* Posts Table *************************************************/
$sql = <<<EOS
CREATE TABLE  forum_posts (
  id int(11) NOT NULL auto_increment,
  topic_id int(11) NOT NULL default '0',
  forum_id int(11) NOT NULL default '0',
  author_id int(11) NOT NULL default '0',
  update_id int(11) NOT NULL default '0',
  date_posted datetime NOT NULL default '0000-00-00 00:00:00',
  date_updated datetime NOT NULL default '0000-00-00 00:00:00',
  subject varchar(255) NOT NULL default '',
  body mediumtext NOT NULL,
  PRIMARY KEY  (id),
  KEY IdxArticle (forum_id,topic_id,author_id,date_posted),
  FULLTEXT KEY IdxText (subject,body)
)
EOS;
$result = mysql_query($sql);
switch(mysql_errno()) {
  case 1050:
    break;
  case 0:
    $sql = "INSERT INTO forum_posts VALUES (NULL, 0, 1, 1, 0, '".
    date("Y-m-d H:i:s", time())."', 0, 'Welcome', 'Welcome to your ".
    "new Bulletin Board System. Do not forget to change your admin ".
    "password after installation. Have fun!')";
    $result = mysql_query($sql) or die(mysql_error());
    break;
  default:
    die(mysql_error());
    break;
}
$a_tables[] = "forum_posts";

/******* Users Table *************************************************/
$sql = <<<EOS
CREATE TABLE  forum_users (
  id int(11) NOT NULL auto_increment,
  email varchar(255) NOT NULL default '',
  passwd varchar(50) NOT NULL default '',
  name varchar(100) NOT NULL default '',
  access_lvl tinyint(4) NOT NULL default '1',
  signature varchar(255) NOT NULL default '',
  date_joined datetime NOT NULL default '0000-00-00 00:00:00',
  last_login datetime NOT NULL default '0000-00-00 00:00:00',
  PRIMARY KEY  (id),
  UNIQUE KEY uniq_email (email)
)
EOS;
$result = mysql_query($sql);
switch(mysql_errno()) {
  case 1050:
    break;
  case 0:
    $datetime = date("Y-m-d H:i:s",time());
    $sql = "INSERT IGNORE INTO forum_users VALUES (NULL, ".
           "'$adminemail', '$adminpass', '$adminname', 3, '', ".
           "'$datetime', 0)";
    $result = mysql_query($sql) or die(mysql_error());
    break;
  default:
    die(mysql_error());
    break;
}
$a_tables[] = "forum_users";

/******* Display Results *********************************************/
require("config.php");
echo "<html><head><title>Forum Tables Created " .
     $datetime . "</title>";
echo "<link rel='stylesheet' type='text/css' ";
echo "href='forum_styles.css'>";
echo "</head><body>";
echo "<div class='bodysmall'>";
echo "<h1>".$admin['title']['value']."</h1>";
echo "<H3>Forum Tables created:</h3>\n<ul>";
foreach ($a_tables as $table) {
  $table = str_replace("forum_","",$table);
  $table = str_replace("_", " ",$table);
  $table = ucWords($table);
  echo "<li>$table</li>\n";
}
echo "</ul>\n<h3>Here is your initial login information:</h3>\n";
echo "<ul><li><strong>login</strong>: " . $adminemail . "</li>\n";
echo "<li><strong>password</strong>: " . $adminpass . "</li></ul>\n";
echo "<h3><a href='login.php?e=".$adminemail."'>Log In</a> ";
echo "to the site now.</h3></div>";
echo "<div class='copyright'>".$admin['copyright']['value']."</div>";
echo "</body></html>";
?>