setup/sql/mysql.php

   1 <?php
   2 /*
   3     This program is free software; you can redistribute it and/or modify
   4     it under the terms of the Revised BSD License.
   5
   6     This program is distributed in the hope that it will be useful,
   7     but WITHOUT ANY WARRANTY; without even the implied warranty of
   8     MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
   9     Revised BSD License for more details.
  10
  11     Copyright 2004-2023 iDB Support - https://idb.osdn.jp/support/category.php?act=view&id=1
  12     Copyright 2004-2023 Game Maker 2k - https://idb.osdn.jp/support/category.php?act=view&id=2
  13     iDB Installer made by Game Maker 2k - http://idb.berlios.net/
  14
  15     $FileInfo: mysql.php - Last Update: 6/28/2023 SVN 998 - Author: cooldude2k $
  16 */
  17 $File3Name = basename($_SERVER['SCRIPT_NAME']);
  18 if ($File3Name=="mysql.php"||$File3Name=="/mysql.php") {
  19         require('index.php');
  20         exit(); }
  21 if(!isset($SetupDir['setup'])) { $SetupDir['setup'] = "setup/"; }
  22 if(!isset($SetupDir['convert'])) { $SetupDir['convert'] = "setup/convert/"; }
  23 $query=sql_pre_query("ALTER DATABASE \"".$_POST['DatabaseName']."\" DEFAULT CHARACTER SET ".$Settings['sql_charset']." COLLATE ".$Settings['sql_collate'].";", array(null));
  24 sql_query($query,$SQLStat);
  25 if(isset($Settings['sql_storage_engine'])) {
  26 $result = sql_query(sql_pre_query("SHOW ENGINES;", array(null)),$SQLStat);
  27 $num = sql_num_rows($result);
  28 $i = 0; $SQLEngines = null;
  29 while ($i < $num) {
  30 $SQLEngines[$i] = sql_result($result,$i,"Engine");
  31 ++$i; }
  32 if (!in_array($Settings['sql_storage_engine'], $SQLEngines)) {
  33     $Settings['sql_storage_engine'] = "InnoDB"; } }
  34 if(!isset($Settings['sql_storage_engine'])) {
  35         $Settings['sql_storage_engine'] = "InnoDB"; }
  36 // You can set this to MyISAM or Maria/Aria
  37 if($Settings['sql_storage_engine']=="CSV") {
  38         $SQLStorageEngine = "CSV"; }
  39 if($Settings['sql_storage_engine']=="Maria") {
  40         $SQLStorageEngine = "Maria"; }
  41 if($Settings['sql_storage_engine']=="Aria") {
  42         $SQLStorageEngine = "Aria"; }
  43 if($Settings['sql_storage_engine']=="MyISAM") {
  44         $SQLStorageEngine = "MyISAM"; }
  45 if($Settings['sql_storage_engine']=="InnoDB") {
  46         $SQLStorageEngine = "InnoDB"; }
  47 $parsestr = parse_url($YourWebsite);
  48 if (!filter_var($parsestr['host'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4 | FILTER_FLAG_IPV6) || $parsestr['host'] == "localhost") {
  49         $GuestLocalIP = gethostbyname($parsestr['host']); } else { $GuestLocalIP = $parsestr['host']; }
  50 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."categories\" (\n".
  51 "  \"id\" int(15) NOT NULL auto_increment,\n".
  52 "  \"OrderID\" int(15) NOT NULL default '0',\n".
  53 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  54 "  \"ShowCategory\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  55 "  \"CategoryType\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  56 "  \"SubShowForums\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  57 "  \"InSubCategory\" int(15) NOT NULL default '0',\n".
  58 "  \"PostCountView\" int(15) NOT NULL default '0',\n".
  59 "  \"KarmaCountView\" int(15) NOT NULL default '0',\n".
  60 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
  61 "  PRIMARY KEY  (\"id\")\n".
  62 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
  63 sql_query($query,$SQLStat);
  64 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."categories\" (\"OrderID\", \"Name\", \"ShowCategory\", \"CategoryType\", \"SubShowForums\", \"InSubCategory\", \"PostCountView\", \"KarmaCountView\", \"Description\")\n".
  65 "VALUES (1, 'A Test Category', 'yes', 'category', 'yes', 0, 0, 0, 'A test category that may be removed at any time.');", array(null));
  66 sql_query($query,$SQLStat);
  67 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."catpermissions\" (\n".
  68 "  \"id\" int(15) NOT NULL auto_increment,\n".
  69 "  \"PermissionID\" int(15) NOT NULL default '0',\n".
  70 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  71 "  \"CategoryID\" int(15) NOT NULL default '0',\n".
  72 "  \"CanViewCategory\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  73 "  PRIMARY KEY  (\"id\")\n".
  74 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
  75 sql_query($query,$SQLStat);
  76 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."catpermissions\" (\"PermissionID\", \"Name\", \"CategoryID\", \"CanViewCategory\") VALUES\n".
  77 "(1, 'Admin', 1, 'yes'),\n".
  78 "(2, 'Moderator', 1, 'yes'),\n".
  79 "(3, 'Member', 1, 'yes'),\n".
  80 "(4, 'Guest', 1, 'yes'),\n".
  81 "(5, 'Banned', 1, 'no'),\n".
  82 "(6, 'Validate', 1, 'yes');", array(null));
  83 sql_query($query,$SQLStat);
  84 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."events\" (\n".
  85 "  \"id\" int(15) NOT NULL auto_increment,\n".
  86 "  \"UserID\" int(15) NOT NULL default '0',\n".
  87 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  88 "  \"EventName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  89 "  \"EventText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
  90 "  \"TimeStamp\" int(15) NOT NULL default '0',\n".
  91 "  \"TimeStampEnd\" int(15) NOT NULL default '0',\n".
  92 "  \"EventMonth\" int(5) NOT NULL default '0',\n".
  93 "  \"EventMonthEnd\" int(5) NOT NULL default '0',\n".
  94 "  \"EventDay\" int(5) NOT NULL default '0',\n".
  95 "  \"EventDayEnd\" int(5) NOT NULL default '0',\n".
  96 "  \"EventYear\" int(5) NOT NULL default '0',\n".
  97 "  \"EventYearEnd\" int(5) NOT NULL default '0',\n".
  98 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
  99 "  PRIMARY KEY  (\"id\")\n".
 100 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 101 sql_query($query,$SQLStat);
 102 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."events\" (\"UserID\", \"GuestName\", \"EventName\", \"EventText\", \"TimeStamp\", \"TimeStampEnd\", \"EventMonth\", \"EventMonthEnd\", \"EventDay\", \"EventDayEnd\", \"EventYear\", \"EventYearEnd\", \"IP\") VALUES\n".
 103 "(-1, '".$iDB_Author."', 'iDB Install', 'This is the start date of your board. ^_^', %i, %i, %i, %i, %i, %i, %i, %i, '".$GuestLocalIP."');", array($YourDate,$YourDateEnd,$EventMonth,$EventMonthEnd,$EventDay,$EventDayEnd,$EventYear,$EventYearEnd));
 104 sql_query($query,$SQLStat);
 105 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."forums\" (\n".
 106 "  \"id\" int(15) NOT NULL auto_increment,\n".
 107 "  \"CategoryID\" int(15) NOT NULL default '0',\n".
 108 "  \"OrderID\" int(15) NOT NULL default '0',\n".
 109 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 110 "  \"ShowForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 111 "  \"ForumType\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 112 "  \"InSubForum\" int(15) NOT NULL default '0',\n".
 113 "  \"RedirectURL\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 114 "  \"Redirects\" int(15) NOT NULL default '0',\n".
 115 "  \"NumViews\" int(15) NOT NULL default '0',\n".
 116 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 117 "  \"PostCountAdd\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 118 "  \"PostCountView\" int(15) NOT NULL default '0',\n".
 119 "  \"KarmaCountView\" int(15) NOT NULL default '0',\n".
 120 "  \"CanHaveTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 121 "  \"HotTopicPosts\" int(15) NOT NULL default '0',\n".
 122 "  \"NumPosts\" int(15) NOT NULL default '0',\n".
 123 "  \"NumTopics\" int(15) NOT NULL default '0',\n".
 124 "  PRIMARY KEY  (\"id\")\n".
 125 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 126 sql_query($query,$SQLStat);
 127 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."forums\" (\"CategoryID\", \"OrderID\", \"Name\", \"ShowForum\", \"ForumType\", \"InSubForum\", \"RedirectURL\", \"Redirects\", \"NumViews\", \"Description\", \"PostCountAdd\", \"PostCountView\", \"KarmaCountView\", \"CanHaveTopics\", \"HotTopicPosts\", \"NumPosts\", \"NumTopics\") VALUES\n".
 128 "(1, 1, 'A Test Forum', 'yes', 'forum', 0, 'http://', 0, 0, 'A test forum that may be removed at any time.', 'off', 0, 0, 'yes', 15, 1, 1);", array(null));
 129 sql_query($query,$SQLStat);
 130 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."groups\" (\n".
 131 "  \"id\" int(15) NOT NULL auto_increment,\n".
 132 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 133 "  \"PermissionID\" int(15) NOT NULL default '0',\n".
 134 "  \"NamePrefix\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 135 "  \"NameSuffix\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 136 "  \"CanViewBoard\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 137 "  \"CanViewOffLine\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 138 "  \"CanEditProfile\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 139 "  \"CanAddEvents\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 140 "  \"CanPM\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 141 "  \"CanSearch\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 142 "  \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 143 "  \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 144 "  \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 145 "  \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 146 "  \"CanViewIPAddress\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 147 "  \"CanViewUserAgent\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 148 "  \"FloodControl\" int(5) NOT NULL default '0',\n".
 149 "  \"SearchFlood\" int(5) NOT NULL default '0',\n".
 150 "  \"PromoteTo\" int(15) NOT NULL default '0',\n".
 151 "  \"PromotePosts\" int(15) NOT NULL default '0',\n".
 152 "  \"PromoteKarma\" int(15) NOT NULL default '0',\n".
 153 "  \"HasModCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 154 "  \"HasAdminCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 155 "  \"ViewDBInfo\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 156 "  PRIMARY KEY  (\"id\"),\n".
 157 "  UNIQUE KEY \"Name\" (\"Name\")\n".
 158 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 159 sql_query($query,$SQLStat);
 160 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."groups\" (\"Name\", \"PermissionID\", \"NamePrefix\", \"NameSuffix\", \"CanViewBoard\", \"CanViewOffLine\", \"CanEditProfile\", \"CanAddEvents\", \"CanPM\", \"CanSearch\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanViewIPAddress\", \"CanViewUserAgent\", \"FloodControl\", \"SearchFlood\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
 161 "('Admin', 1, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'yes', 'yes'),\n".
 162 "('Moderator', 2, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'no', 'no'),\n".
 163 "('Member', 3, '', '', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
 164 "('Guest', 4, '', '', 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'yes', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
 165 "('Banned', 5, '', '', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
 166 "('Validate', 6, '', '', 'yes', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no');", array(null));
 167 sql_query($query,$SQLStat);
 168 $query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."levels\" (\n".
 169 "  \"id\" int(15) NOT NULL auto_increment,\n".
 170 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 171 "  \"PromoteTo\" int(15) NOT NULL default '0',\n".
 172 "  \"PromotePosts\" int(15) NOT NULL default '0',\n".
 173 "  \"PromoteKarma\" int(15) NOT NULL default '0',\n".
 174 "  PRIMARY KEY  (\"id\"),\n".
 175 "  UNIQUE KEY \"Name\" (\"Name\")\n".
 176 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 177 sql_query($query,$SQLStat);
 178 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."levels\" (\"id\", \"Name\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\") VALUES\n".
 179 "(-1, 'Guest', 0, 0, 0),\n".
 180 "(1, 'Member', 0, 0, 0);", array(null));
 181 sql_query($query,$SQLStat);
 182 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."members\" (\n".
 183 "  \"id\" int(15) NOT NULL auto_increment,\n".
 184 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 185 "  \"UserPassword\" varchar(256) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 186 "  \"HashType\" varchar(50) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 187 "  \"Email\" varchar(256) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 188 "  \"GroupID\" int(15) NOT NULL default '0',\n".
 189 "  \"LevelID\" int(15) NOT NULL default '0',\n".
 190 "  \"Validated\" varchar(20) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 191 "  \"HiddenMember\" varchar(20) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 192 "  \"WarnLevel\" int(15) NOT NULL default '0',\n".
 193 "  \"Interests\" text COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 194 "  \"Title\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 195 "  \"Joined\" int(15) NOT NULL default '0',\n".
 196 "  \"LastActive\" int(15) NOT NULL default '0',\n".
 197 "  \"LastLogin\" int(15) NOT NULL default '0',\n".
 198 "  \"LastPostTime\" int(15) NOT NULL default '0',\n".
 199 "  \"BanTime\" int(15) NOT NULL default '0',\n".
 200 "  \"BirthDay\" int(5) NOT NULL default '0',\n".
 201 "  \"BirthMonth\" int(5) NOT NULL default '0',\n".
 202 "  \"BirthYear\" int(5) NOT NULL default '0',\n".
 203 "  \"Signature\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 204 "  \"Notes\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 205 "  \"Avatar\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 206 "  \"AvatarSize\" varchar(10) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 207 "  \"Website\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 208 "  \"Location\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 209 "  \"Gender\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 210 "  \"PostCount\" int(15) NOT NULL default '0',\n".
 211 "  \"Karma\" int(15) NOT NULL default '0',\n".
 212 "  \"KarmaUpdate\" int(15) NOT NULL default '0',\n".
 213 "  \"RepliesPerPage\" int(5) NOT NULL default '0',\n".
 214 "  \"TopicsPerPage\" int(5) NOT NULL default '0',\n".
 215 "  \"MessagesPerPage\" int(5) NOT NULL default '0',\n".
 216 "  \"TimeZone\" varchar(256) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 217 "  \"DateFormat\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 218 "  \"TimeFormat\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 219 "  \"UseTheme\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 220 "  \"IgnoreSignitures\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 221 "  \"IgnoreAdvatars\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 222 "  \"IgnoreUsers\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 223 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 224 "  \"Salt\" varchar(50) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 225 "  PRIMARY KEY  (\"id\"),\n".
 226 "  UNIQUE KEY \"Name\" (\"Name\"),\n".
 227 "  UNIQUE KEY \"Email\" (\"Email\")\n".
 228 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 229 sql_query($query,$SQLStat);
 230 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."members\" (\"id\", \"Name\", \"UserPassword\", \"HashType\", \"Email\", \"GroupID\", \"LevelID\", \"Validated\", \"HiddenMember\", \"WarnLevel\", \"Interests\", \"Title\", \"Joined\", \"LastActive\", \"LastLogin\", \"LastPostTime\", \"BanTime\", \"BirthDay\", \"BirthMonth\", \"BirthYear\", \"Signature\", \"Notes\", \"Avatar\", \"AvatarSize\", \"Website\", \"Location\", \"Gender\", \"PostCount\", \"Karma\", \"KarmaUpdate\", \"RepliesPerPage\", \"TopicsPerPage\", \"MessagesPerPage\", \"TimeZone\", \"DateFormat\", \"TimeFormat\", \"UseTheme\", \"IgnoreSignitures\", \"IgnoreAdvatars\", \"IgnoreUsers\", \"IP\", \"Salt\") VALUES\n".
 231 "(-1, 'Guest', '%s', 'GuestPassword', '%s', 4, -1, 'no', 'yes', 0, 'Guest Account', 'Guest', %i, %i, %i, '0', '0', '0', '0', '0', '', 'Your Notes', 'http://', '', '100x100', '%s', 'UnKnow', 0, 0, 0, 10, 10, 10, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s'),\n".
 232 "(1, '%s', '%s', '%s', '%s', 1, 1, 'yes', 'no', 0, '%s', 'Admin', %i, %i, %i, '0', '0', '0', '0', '0', '%s', 'Your Notes', '%s', '', '100x100', '%s', 'UnKnow', 0, 0, 0, 10, 10, 10, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');", array($GuestPassword,$GEmail,$YourDate,$YourDate,$YourDate,$YourWebsite,$_POST['YourOffSet'],$_POST['iDBDateFormat'],$_POST['iDBTimeFormat'],$_POST['DefaultTheme'],'','','',$GuestLocalIP,$GSalt,$_POST['AdminUser'],$NewPassword,$iDBHashType,$_POST['AdminEmail'],"",$YourDate,$YourDate,$YourDate,"","http://",$YourWebsite,$_POST['YourOffSet'],$_POST['iDBDateFormat'],$_POST['iDBTimeFormat'],$_POST['DefaultTheme'],'','','',$UserIP,$YourSalt));
 233 sql_query($query,$SQLStat);
 234 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."mempermissions\" (\n".
 235 "  \"id\" int(15) NOT NULL auto_increment,\n".
 236 "  \"PermissionID\" int(15) NOT NULL default '0',\n".
 237 "  \"CanViewBoard\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 238 "  \"CanViewOffLine\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 239 "  \"CanEditProfile\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 240 "  \"CanAddEvents\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 241 "  \"CanPM\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 242 "  \"CanSearch\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 243 "  \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 244 "  \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 245 "  \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 246 "  \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 247 "  \"CanViewIPAddress\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 248 "  \"CanViewUserAgent\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 249 "  \"FloodControl\" int(5) NOT NULL default '0',\n".
 250 "  \"SearchFlood\" int(5) NOT NULL default '0',\n".
 251 "  \"HasModCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 252 "  \"HasAdminCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 253 "  \"ViewDBInfo\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 254 "  PRIMARY KEY  (\"id\")\n".
 255 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 256 sql_query($query,$SQLStat);
 257 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."mempermissions\" (\"id\", \"PermissionID\", \"CanViewBoard\", \"CanViewOffLine\", \"CanEditProfile\", \"CanAddEvents\", \"CanPM\", \"CanSearch\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanViewIPAddress\", \"CanViewUserAgent\", \"FloodControl\", \"SearchFlood\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
 258 "(-1, 0, 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', -1, -1, 'group', 'group', 'group'),\n".
 259 "(1, 0, 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', -1, -1, 'group', 'group', 'group');", array(null));
 260 //"(-1, 0, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 'no', 'no', 'no'),\n".
 261 //"(1, 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 30, 30, 'yes', 'yes', 'yes');", array(null));
 262 sql_query($query,$SQLStat);
 263 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."messenger\" (\n".
 264 "  \"id\" int(15) NOT NULL auto_increment,\n".
 265 "  \"DiscussionID\" int(15) NOT NULL default '0',\n".
 266 "  \"SenderID\" int(15) NOT NULL default '0',\n".
 267 "  \"ReciverID\" int(15) NOT NULL default '0',\n".
 268 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 269 "  \"MessageTitle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 270 "  \"MessageText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 271 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 272 "  \"DateSend\" int(15) NOT NULL default '0',\n".
 273 "  \"Read\" int(5) NOT NULL default '0',\n".
 274 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 275 "  PRIMARY KEY  (\"id\")\n".
 276 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 277 sql_query($query,$SQLStat);
 278 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."messenger\" (\"DiscussionID\", \"SenderID\", \"ReciverID\", \"GuestName\", \"MessageTitle\", \"MessageText\", \"Description\", \"DateSend\", \"Read\", \"IP\") VALUES\n".
 279 "(0, -1, 1, '".$iDB_Author."', 'Welcome', 'Welcome to your new Internet Discussion Board! :)', 'Welcome %s', %i, 0, '".$GuestLocalIP."');", array($_POST['AdminUser'],$YourDate));
 280 sql_query($query,$SQLStat);
 281 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."permissions\" (\n".
 282 "  \"id\" int(15) NOT NULL auto_increment,\n".
 283 "  \"PermissionID\" int(15) NOT NULL default '0',\n".
 284 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 285 "  \"ForumID\" int(15) NOT NULL default '0',\n".
 286 "  \"CanViewForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 287 "  \"CanMakePolls\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 288 "  \"CanMakeTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 289 "  \"CanMakeReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 290 "  \"CanMakeReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 291 "  \"HideEditPostInfo\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 292 "  \"CanEditTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 293 "  \"CanEditTopicsCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 294 "  \"CanEditReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 295 "  \"CanEditReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 296 "  \"CanDeleteTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 297 "  \"CanDeleteTopicsCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 298 "  \"CanDeleteReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 299 "  \"CanDeleteReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 300 "  \"CanDoublePost\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 301 "  \"CanDoublePostCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 302 "  \"GotoEditPost\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 303 "  \"CanCloseTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 304 "  \"CanPinTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 305 "  \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 306 "  \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 307 "  \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 308 "  \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 309 "  \"CanReportPost\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 310 "  PRIMARY KEY  (\"id\")\n".
 311 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 312 sql_query($query,$SQLStat);
 313 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakePolls\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"HideEditPostInfo\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDoublePost\", \"CanDoublePostCT\", \"GotoEditPost\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanReportPost\") VALUES\n".
 314 "(1, 'Admin', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'),\n".
 315 "(2, 'Moderator', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes', 'yes'),\n".
 316 "(3, 'Member', 1, 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'no', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'yes', 'no', 'yes', 'no', 'no', 'no', 'no', 'no', 'yes', 'no', 'yes'),\n".
 317 "(4, 'Guest', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
 318 "(5, 'Banned', 1, 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
 319 "(6, 'Validate', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');", array(null));
 320 sql_query($query,$SQLStat);
 321 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."polls\" (\n".
 322 "  \"id\" int(15) NOT NULL auto_increment,\n".
 323 "  \"UserID\" int(15) NOT NULL default '0',\n".
 324 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 325 "  \"PollValues\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 326 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 327 "  \"UsersVoted\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 328 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 329 "  PRIMARY KEY  (\"id\")\n".
 330 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 331 sql_query($query,$SQLStat);
 332 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."posts\" (\n".
 333 "  \"id\" int(15) NOT NULL auto_increment,\n".
 334 "  \"TopicID\" int(15) NOT NULL default '0',\n".
 335 "  \"ForumID\" int(15) NOT NULL default '0',\n".
 336 "  \"CategoryID\" int(15) NOT NULL default '0',\n".
 337 "  \"UserID\" int(15) NOT NULL default '0',\n".
 338 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 339 "  \"TimeStamp\" int(15) NOT NULL default '0',\n".
 340 "  \"LastUpdate\" int(15) NOT NULL default '0',\n".
 341 "  \"EditUser\" int(15) NOT NULL default '0',\n".
 342 "  \"EditUserName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 343 "  \"Post\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 344 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 345 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 346 "  \"EditIP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 347 "  PRIMARY KEY  (\"id\")\n".
 348 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 349 sql_query($query,$SQLStat);
 350 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."posts\" (\"TopicID\", \"ForumID\", \"CategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"EditUser\", \"EditUserName\", \"Post\", \"Description\", \"IP\", \"EditIP\") VALUES\n".
 351 "(1, 1, 1, -1, '".$iDB_Author."', %i, %i, 1, '".$_POST['AdminUser']."', 'Welcome to your new Internet Discussion Board! :) ', 'Welcome %s', '".$GuestLocalIP."', '127.0.0.1');", array($YourDate,$YourEditDate,$_POST['AdminUser']));
 352 sql_query($query,$SQLStat);
 353 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."restrictedwords\" (\n".
 354 "  \"id\" int(15) NOT NULL auto_increment,\n".
 355 "  \"Word\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 356 "  \"RestrictedUserName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 357 "  \"RestrictedTopicName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 358 "  \"RestrictedEventName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 359 "  \"RestrictedMessageName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 360 "  \"CaseInsensitive\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 361 "  \"WholeWord\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 362 "  PRIMARY KEY  (\"id\")\n".
 363 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 364 sql_query($query,$SQLStat);
 365 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."sessions\" (\n".
 366 "  \"session_id\" varchar(250) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 367 "  \"session_data\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 368 "  \"serialized_data\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 369 "  \"user_agent\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 370 "  \"ip_address\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 371 "  \"expires\" int(15) NOT NULL default '0',\n".
 372 "  PRIMARY KEY  (\"session_id\")\n".
 373 ") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 374 sql_query($query,$SQLStat);
 375 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."smileys\" (\n".
 376 "  \"id\" int(15) NOT NULL auto_increment,\n".
 377 "  \"FileName\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 378 "  \"SmileName\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 379 "  \"SmileText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 380 "  \"Directory\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 381 "  \"Display\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 382 "  \"ReplaceCI\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 383 "  PRIMARY KEY  (\"id\")\n".
 384 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 385 sql_query($query,$SQLStat);
 386 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."smileys\" (\"FileName\", \"SmileName\", \"SmileText\", \"Directory\", \"Display\", \"ReplaceCI\") VALUES\n".
 387 "('angry.png', 'Angry', ':angry:', 'smileys/', 'yes', 'yes'),\n".
 388 "('closedeyes.png', 'Sleep', 'v_v', 'smileys/', 'yes', 'no'),\n".
 389 "('cool.png', 'Cool', 'B)', 'smileys/', 'yes', 'no'),\n".
 390 "('glare.png', 'Hmph', ':hmph:', 'smileys/', 'yes', 'yes'),\n".
 391 "('glare.png', 'Hmph', '&lt;_&lt;', 'smileys/', 'no', 'no'),\n".
 392 "('happy.png', 'Happy', '^_^', 'smileys/', 'yes', 'no'),\n".
 393 "('hmm.png', 'Hmm', ':unsure:', 'smileys/', 'yes', 'yes'),\n".
 394 "('huh.png', 'Huh', ':huh:', 'smileys/', 'yes', 'yes'),\n".
 395 "('laugh.png', 'lol', ':laugh:', 'smileys/', 'yes', 'yes'),\n".
 396 "('lol.png', 'lol', ':lol:', 'smileys/', 'yes', 'yes'),\n".
 397 "('mad.png', 'Mad', ':mad:', 'smileys/', 'yes', 'yes'),\n".
 398 "('ninja.png', 'Ninja', ':ninja:', 'smileys/', 'yes', 'yes'),\n".
 399 "('ohno.png', 'ohno', ':ohno:', 'smileys/', 'yes', 'yes'),\n".
 400 "('ohmy.png', 'ohmy', ':o', 'smileys/', 'yes', 'yes'),\n".
 401 "('sad.png', 'Sad', ':(', 'smileys/', 'yes', 'no'),\n".
 402 "('sleep.png', 'Sleep', '-_-', 'smileys/', 'yes', 'no'),\n".
 403 "('smile.png', 'Happy', ':)', 'smileys/', 'yes', 'no'),\n".
 404 "('sweat.png', 'Sweat', ':sweat:', 'smileys/', 'yes', 'yes'),\n".
 405 "('tongue.png', 'Tongue', ':P', 'smileys/', 'yes', 'no'),\n".
 406 "('wub.png', 'Wub', ':wub:', 'smileys/', 'yes', 'yes'),\n".
 407 "('x.png', 'X', ':x:', 'smileys/', 'yes', 'yes');", array(null));
 408 sql_query($query,$SQLStat);
 409 /*
 410 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."tagboard\" (\n".
 411 "  \"id\" int(15) NOT NULL auto_increment,\n".
 412 "  \"UserID\" int(15) NOT NULL default '0',\n".
 413 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 414 "  \"TimeStamp\" int(15) NOT NULL default '0',\n".
 415 "  \"Post\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 416 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 417 "  PRIMARY KEY  (\"id\")\n".
 418 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 419 sql_query($query,$SQLStat);
 420 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."tagboard\" VALUES (1,-1,'".$iDB_Author."',".$YourDate.",'Welcome to Your New Tag Board. ^_^','127.0.0.1'), array(null));
 421 sql_query($query,$SQLStat);
 422 */
 423 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."themes\" (\n".
 424 "  \"id\" int(15) NOT NULL auto_increment,\n".
 425 "  \"Name\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 426 "  \"ThemeName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 427 "  \"ThemeMaker\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 428 "  \"ThemeVersion\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 429 "  \"ThemeVersionType\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 430 "  \"ThemeSubVersion\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 431 "  \"MakerURL\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 432 "  \"CopyRight\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 433 "  \"WrapperString\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 434 "  \"CSS\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 435 "  \"CSSType\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 436 "  \"FavIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 437 "  \"OpenGraph\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 438 "  \"TableStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 439 "  \"MiniPageAltStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 440 "  \"PreLogo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 441 "  \"Logo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 442 "  \"LogoStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 443 "  \"SubLogo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 444 "  \"TopicIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 445 "  \"MovedTopicIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 446 "  \"HotTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 447 "  \"MovedHotTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 448 "  \"PinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 449 "  \"AnnouncementTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 450 "  \"MovedPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 451 "  \"HotPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 452 "  \"MovedHotPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 453 "  \"ClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 454 "  \"MovedClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 455 "  \"HotClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 456 "  \"MovedHotClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 457 "  \"PinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 458 "  \"MovedPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 459 "  \"HotPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 460 "  \"MovedHotPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 461 "  \"MessageRead\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 462 "  \"MessageUnread\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 463 "  \"Profile\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 464 "  \"WWW\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 465 "  \"PM\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 466 "  \"TopicLayout\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 467 "  \"AddReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 468 "  \"FastReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 469 "  \"NewTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 470 "  \"QuoteReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 471 "  \"EditReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 472 "  \"DeleteReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 473 "  \"Report\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 474 "  \"LineDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 475 "  \"ButtonDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 476 "  \"LineDividerTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 477 "  \"TitleDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 478 "  \"ForumStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 479 "  \"ForumIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 480 "  \"SubForumIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 481 "  \"RedirectIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 482 "  \"TitleIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 483 "  \"NavLinkIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 484 "  \"NavLinkDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 485 "  \"BoardStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 486 "  \"MemberStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 487 "  \"BirthdayStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 488 "  \"EventStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 489 "  \"OnlineStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 490 "  \"NoAvatar\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 491 "  \"NoAvatarSize\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 492 "  PRIMARY KEY  (\"id\"),\n".
 493 "  UNIQUE KEY \"Name\" (\"Name\")\n".
 494 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 495 sql_query($query,$SQLStat);
 496 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."topics\" (\n".
 497 "  \"id\" int(15) NOT NULL auto_increment,\n".
 498 "  \"PollID\" int(15) NOT NULL default '0',\n".
 499 "  \"ForumID\" int(15) NOT NULL default '0',\n".
 500 "  \"CategoryID\" int(15) NOT NULL default '0',\n".
 501 "  \"OldForumID\" int(15) NOT NULL default '0',\n".
 502 "  \"OldCategoryID\" int(15) NOT NULL default '0',\n".
 503 "  \"UserID\" int(15) NOT NULL default '0',\n".
 504 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 505 "  \"TimeStamp\" int(15) NOT NULL default '0',\n".
 506 "  \"LastUpdate\" int(15) NOT NULL default '0',\n".
 507 "  \"TopicName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 508 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 509 "  \"NumReply\" int(15) NOT NULL default '0',\n".
 510 "  \"NumViews\" int(15) NOT NULL default '0',\n".
 511 "  \"Pinned\" int(5) NOT NULL default '0',\n".
 512 "  \"Closed\" int(5) NOT NULL default '0',\n".
 513 "  PRIMARY KEY  (\"id\")\n".
 514 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 515 sql_query($query,$SQLStat);
 516 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."topics\" (\"PollID\", \"ForumID\", \"CategoryID\", \"OldForumID\", \"OldCategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"TopicName\", \"Description\", \"NumReply\", \"NumViews\", \"Pinned\", \"Closed\") VALUES\n".
 517 "(0, 1, 1, 1, 1, -1, '".$iDB_Author."', %i, %i, 'Welcome', 'Welcome %s', 0, 0, 1, 1);", array($YourDate,$YourDate,$_POST['AdminUser']));
 518 sql_query($query,$SQLStat);
 519 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."wordfilter\" (\n".
 520 "  \"id\" int(15) NOT NULL auto_increment,\n".
 521 "  \"FilterWord\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 522 "  \"Replacement\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 523 "  \"CaseInsensitive\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 524 "  \"WholeWord\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 525 "  PRIMARY KEY  (\"id\")\n".
 526 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 527 sql_query($query,$SQLStat);
 528 $TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "levels", "members", "mempermissions", "messenger", "permissions", "polls", "posts", "restrictedwords", "sessions", "smileys", "themes", "topics", "wordfilter");
 529 $TablePreFix = $_POST['tableprefix'];
 530 function add_prefix($tarray) {
 531 global $TablePreFix;
 532 return $TablePreFix.$tarray; }
 533 $TableChCk = array_map("add_prefix",$TableChCk);
 534 $tcount = count($TableChCk); $ti = 0;
 535 while ($ti < $tcount) {
 536 $OptimizeTea = sql_query(sql_pre_query("OPTIMIZE TABLE \"".$TableChCk[$ti]."\"", array(null)),$SQLStat);
 537 ++$ti; }
 538 ?>