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-2019 iDB Support - https://idb.osdn.jp/support/category.php?act=view&id=1
  12     Copyright 2004-2019 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: 08/02/2019 SVN 905 - 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 "  \"Gender\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 209 "  \"PostCount\" int(15) NOT NULL default '0',\n".
 210 "  \"Karma\" int(15) NOT NULL default '0',\n".
 211 "  \"KarmaUpdate\" int(15) NOT NULL default '0',\n".
 212 "  \"RepliesPerPage\" int(5) NOT NULL default '0',\n".
 213 "  \"TopicsPerPage\" int(5) NOT NULL default '0',\n".
 214 "  \"MessagesPerPage\" int(5) NOT NULL default '0',\n".
 215 "  \"TimeZone\" varchar(256) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
 216 "  \"DateFormat\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
 217 "  \"TimeFormat\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
 218 "  \"UseTheme\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
 219 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 220 "  \"Salt\" varchar(50) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 221 "  PRIMARY KEY  (\"id\"),\n".
 222 "  UNIQUE KEY \"Name\" (\"Name\"),\n".
 223 "  UNIQUE KEY \"Email\" (\"Email\")\n".
 224 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 225 sql_query($query,$SQLStat);
 226 $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\", \"Gender\", \"PostCount\", \"Karma\", \"KarmaUpdate\", \"RepliesPerPage\", \"TopicsPerPage\", \"MessagesPerPage\", \"TimeZone\", \"DateFormat\", \"TimeFormat\", \"UseTheme\", \"IP\", \"Salt\") VALUES\n".
 227 "(-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', 1, 0, 0, 10, 10, 10, '%s', '%s', '%s', '%s', '".$GuestLocalIP."', '%s'),\n".
 228 "(1, '%s', '%s', '".$iDBHashType."', '%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');", array($GuestPassword,$GEmail,$YourDate,$YourDate,$YourDate,$YourWebsite,$_POST['YourOffSet'],$_POST['iDBDateFormat'],$_POST['iDBTimeFormat'],$_POST['DefaultTheme'],$GSalt,$_POST['AdminUser'],$NewPassword,$_POST['AdminEmail'],"",$YourDate,$YourDate,$YourDate,"","http://",$YourWebsite,$_POST['YourOffSet'],$_POST['iDBDateFormat'],$_POST['iDBTimeFormat'],$_POST['DefaultTheme'],$UserIP,$YourSalt));
 229 sql_query($query,$SQLStat);
 230 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."mempermissions\" (\n".
 231 "  \"id\" int(15) NOT NULL auto_increment,\n".
 232 "  \"PermissionID\" int(15) NOT NULL default '0',\n".
 233 "  \"CanViewBoard\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 234 "  \"CanViewOffLine\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 235 "  \"CanEditProfile\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 236 "  \"CanAddEvents\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 237 "  \"CanPM\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 238 "  \"CanSearch\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 239 "  \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 240 "  \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 241 "  \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 242 "  \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 243 "  \"CanViewIPAddress\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 244 "  \"CanViewUserAgent\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 245 "  \"FloodControl\" int(5) NOT NULL default '0',\n".
 246 "  \"SearchFlood\" int(5) NOT NULL default '0',\n".
 247 "  \"HasModCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 248 "  \"HasAdminCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 249 "  \"ViewDBInfo\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 250 "  PRIMARY KEY  (\"id\")\n".
 251 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 252 sql_query($query,$SQLStat);
 253 $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".
 254 "(-1, 0, 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', -1, -1, 'group', 'group', 'group'),\n".
 255 "(1, 0, 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', -1, -1, 'group', 'group', 'group');", array(null));
 256 //"(-1, 0, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 'no', 'no', 'no'),\n".
 257 //"(1, 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 30, 30, 'yes', 'yes', 'yes');", array(null));
 258 sql_query($query,$SQLStat);
 259 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."messenger\" (\n".
 260 "  \"id\" int(15) NOT NULL auto_increment,\n".
 261 "  \"DiscussionID\" int(15) NOT NULL default '0',\n".
 262 "  \"SenderID\" int(15) NOT NULL default '0',\n".
 263 "  \"ReciverID\" int(15) NOT NULL default '0',\n".
 264 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 265 "  \"MessageTitle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 266 "  \"MessageText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 267 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 268 "  \"DateSend\" int(15) NOT NULL default '0',\n".
 269 "  \"Read\" int(5) NOT NULL default '0',\n".
 270 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 271 "  PRIMARY KEY  (\"id\")\n".
 272 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 273 sql_query($query,$SQLStat);
 274 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."messenger\" (\"DiscussionID\", \"SenderID\", \"ReciverID\", \"GuestName\", \"MessageTitle\", \"MessageText\", \"Description\", \"DateSend\", \"Read\", \"IP\") VALUES\n".
 275 "(0, -1, 1, '".$iDB_Author."', 'Welcome', 'Welcome to your new Internet Discussion Board! :)', 'Welcome %s', %i, 0, '".$GuestLocalIP."');", array($_POST['AdminUser'],$YourDate));
 276 sql_query($query,$SQLStat);
 277 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."permissions\" (\n".
 278 "  \"id\" int(15) NOT NULL auto_increment,\n".
 279 "  \"PermissionID\" int(15) NOT NULL default '0',\n".
 280 "  \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 281 "  \"ForumID\" int(15) NOT NULL default '0',\n".
 282 "  \"CanViewForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 283 "  \"CanMakePolls\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 284 "  \"CanMakeTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 285 "  \"CanMakeReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 286 "  \"CanMakeReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 287 "  \"CanEditTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 288 "  \"CanEditTopicsCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 289 "  \"CanEditReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 290 "  \"CanEditReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 291 "  \"CanDeleteTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 292 "  \"CanDeleteTopicsCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 293 "  \"CanDeleteReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 294 "  \"CanDeleteReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 295 "  \"CanCloseTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 296 "  \"CanPinTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 297 "  \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 298 "  \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 299 "  \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 300 "  \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 301 "  PRIMARY KEY  (\"id\")\n".
 302 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 303 sql_query($query,$SQLStat);
 304 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakePolls\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\") VALUES\n".
 305 "(1, 'Admin', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'),\n".
 306 "(2, 'Moderator', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes'),\n".
 307 "(3, 'Member', 1, 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'no', 'no', 'no', 'no', 'yes', 'no'),\n".
 308 "(4, 'Guest', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
 309 "(5, 'Banned', 1, 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
 310 "(6, 'Validate', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');", array(null));
 311 sql_query($query,$SQLStat);
 312 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."polls\" (\n".
 313 "  \"id\" int(15) NOT NULL auto_increment,\n".
 314 "  \"UserID\" int(15) NOT NULL default '0',\n".
 315 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 316 "  \"PollValues\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 317 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 318 "  \"UsersVoted\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 319 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 320 "  PRIMARY KEY  (\"id\")\n".
 321 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 322 sql_query($query,$SQLStat);
 323 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."posts\" (\n".
 324 "  \"id\" int(15) NOT NULL auto_increment,\n".
 325 "  \"TopicID\" int(15) NOT NULL default '0',\n".
 326 "  \"ForumID\" int(15) NOT NULL default '0',\n".
 327 "  \"CategoryID\" int(15) NOT NULL default '0',\n".
 328 "  \"UserID\" int(15) NOT NULL default '0',\n".
 329 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 330 "  \"TimeStamp\" int(15) NOT NULL default '0',\n".
 331 "  \"LastUpdate\" int(15) NOT NULL default '0',\n".
 332 "  \"EditUser\" int(15) NOT NULL default '0',\n".
 333 "  \"EditUserName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 334 "  \"Post\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 335 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 336 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 337 "  \"EditIP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 338 "  PRIMARY KEY  (\"id\")\n".
 339 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 340 sql_query($query,$SQLStat);
 341 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."posts\" (\"TopicID\", \"ForumID\", \"CategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"EditUser\", \"EditUserName\", \"Post\", \"Description\", \"IP\", \"EditIP\") VALUES\n".
 342 "(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']));
 343 sql_query($query,$SQLStat);
 344 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."restrictedwords\" (\n".
 345 "  \"id\" int(15) NOT NULL auto_increment,\n".
 346 "  \"Word\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 347 "  \"RestrictedUserName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 348 "  \"RestrictedTopicName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 349 "  \"RestrictedEventName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 350 "  \"RestrictedMessageName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 351 "  \"CaseInsensitive\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 352 "  \"WholeWord\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 353 "  PRIMARY KEY  (\"id\")\n".
 354 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 355 sql_query($query,$SQLStat);
 356 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."sessions\" (\n".
 357 "  \"session_id\" VARCHAR(250) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 358 "  \"session_data\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 359 "  \"serialized_data\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 360 "  \"user_agent\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 361 "  \"ip_address\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 362 "  \"expires\" int(15) NOT NULL default '0',\n".
 363 "  PRIMARY KEY  (\"session_id\")\n".
 364 ") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 365 sql_query($query,$SQLStat);
 366 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."smileys\" (\n".
 367 "  \"id\" int(15) NOT NULL auto_increment,\n".
 368 "  \"FileName\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 369 "  \"SmileName\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 370 "  \"SmileText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 371 "  \"Directory\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 372 "  \"Display\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 373 "  \"ReplaceCI\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 374 "  PRIMARY KEY  (\"id\")\n".
 375 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 376 sql_query($query,$SQLStat);
 377 $query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."smileys\" (\"FileName\", \"SmileName\", \"SmileText\", \"Directory\", \"Display\", \"ReplaceCI\") VALUES\n".
 378 "('angry.png', 'Angry', ':angry:', 'smileys/', 'yes', 'yes'),\n".
 379 "('closedeyes.png', 'Sleep', 'v_v', 'smileys/', 'yes', 'no'),\n".
 380 "('cool.png', 'Cool', 'B)', 'smileys/', 'yes', 'no'),\n".
 381 "('glare.png', 'Hmph', ':hmph:', 'smileys/', 'yes', 'yes'),\n".
 382 "('happy.png', 'Happy', '^_^', 'smileys/', 'yes', 'no'),\n".
 383 "('hmm.png', 'Hmm', ':unsure:', 'smileys/', 'yes', 'yes'),\n".
 384 "('huh.png', 'Huh', ':huh:', 'smileys/', 'yes', 'yes'),\n".
 385 "('laugh.png', 'lol', ':laugh:', 'smileys/', 'yes', 'yes'),\n".
 386 "('lol.png', 'lol', ':lol:', 'smileys/', 'yes', 'yes'),\n".
 387 "('mad.png', 'Mad', ':mad:', 'smileys/', 'yes', 'yes'),\n".
 388 "('ninja.png', 'Ninja', ':ninja:', 'smileys/', 'yes', 'yes'),\n".
 389 "('ohno.png', 'ohno', ':ohno:', 'smileys/', 'yes', 'yes'),\n".
 390 "('ohmy.png', 'ohmy', ':o', 'smileys/', 'yes', 'yes'),\n".
 391 "('sad.png', 'Sad', ':(', 'smileys/', 'yes', 'no'),\n".
 392 "('sleep.png', 'Sleep', '-_-', 'smileys/', 'yes', 'no'),\n".
 393 "('smile.png', 'Happy', ':)', 'smileys/', 'yes', 'no'),\n".
 394 "('sweat.png', 'Sweat', ':sweat:', 'smileys/', 'yes', 'yes'),\n".
 395 "('tongue.png', 'Tongue', ':P', 'smileys/', 'yes', 'no'),\n".
 396 "('wub.png', 'Wub', ':wub:', 'smileys/', 'yes', 'yes'),\n".
 397 "('x.png', 'X', ':x:', 'smileys/', 'yes', 'yes');", array(null));
 398 sql_query($query,$SQLStat);
 399 /*
 400 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."tagboard\" (\n".
 401 "  \"id\" int(15) NOT NULL auto_increment,\n".
 402 "  \"UserID\" int(15) NOT NULL default '0',\n".
 403 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 404 "  \"TimeStamp\" int(15) NOT NULL default '0',\n".
 405 "  \"Post\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 406 "  \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 407 "  PRIMARY KEY  (\"id\")\n".
 408 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 409 sql_query($query,$SQLStat);
 410 $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));
 411 sql_query($query,$SQLStat);
 412 */
 413 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."themes\" (\n".
 414 "  \"id\" int(15) NOT NULL auto_increment,\n".
 415 "  \"Name\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 416 "  \"ThemeName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 417 "  \"ThemeMaker\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 418 "  \"ThemeVersion\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 419 "  \"ThemeVersionType\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 420 "  \"ThemeSubVersion\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 421 "  \"MakerURL\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 422 "  \"CopyRight\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 423 "  \"WrapperString\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 424 "  \"CSS\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 425 "  \"CSSType\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 426 "  \"FavIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 427 "  \"TableStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 428 "  \"MiniPageAltStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 429 "  \"PreLogo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 430 "  \"Logo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 431 "  \"LogoStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 432 "  \"SubLogo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 433 "  \"TopicIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 434 "  \"MovedTopicIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 435 "  \"HotTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 436 "  \"MovedHotTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 437 "  \"PinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 438 "  \"AnnouncementTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 439 "  \"MovedPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 440 "  \"HotPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 441 "  \"MovedHotPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 442 "  \"ClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 443 "  \"MovedClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 444 "  \"HotClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 445 "  \"MovedHotClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 446 "  \"PinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 447 "  \"MovedPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 448 "  \"HotPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 449 "  \"MovedHotPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 450 "  \"MessageRead\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 451 "  \"MessageUnread\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 452 "  \"Profile\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 453 "  \"WWW\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 454 "  \"PM\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 455 "  \"TopicLayout\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 456 "  \"AddReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 457 "  \"FastReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 458 "  \"NewTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 459 "  \"QuoteReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 460 "  \"EditReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 461 "  \"DeleteReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 462 "  \"Report\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 463 "  \"LineDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 464 "  \"ButtonDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 465 "  \"LineDividerTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 466 "  \"TitleDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 467 "  \"ForumStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 468 "  \"ForumIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 469 "  \"SubForumIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 470 "  \"RedirectIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 471 "  \"TitleIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 472 "  \"NavLinkIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 473 "  \"NavLinkDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 474 "  \"BoardStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 475 "  \"MemberStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 476 "  \"BirthdayStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 477 "  \"EventStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 478 "  \"OnlineStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 479 "  \"NoAvatar\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 480 "  \"NoAvatarSize\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 481 "  PRIMARY KEY  (\"id\"),\n".
 482 "  UNIQUE KEY \"Name\" (\"Name\")\n".
 483 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 484 sql_query($query,$SQLStat);
 485 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."topics\" (\n".
 486 "  \"id\" int(15) NOT NULL auto_increment,\n".
 487 "  \"PollID\" int(15) NOT NULL default '0',\n".
 488 "  \"ForumID\" int(15) NOT NULL default '0',\n".
 489 "  \"CategoryID\" int(15) NOT NULL default '0',\n".
 490 "  \"OldForumID\" int(15) NOT NULL default '0',\n".
 491 "  \"OldCategoryID\" int(15) NOT NULL default '0',\n".
 492 "  \"UserID\" int(15) NOT NULL default '0',\n".
 493 "  \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 494 "  \"TimeStamp\" int(15) NOT NULL default '0',\n".
 495 "  \"LastUpdate\" int(15) NOT NULL default '0',\n".
 496 "  \"TopicName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 497 "  \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 498 "  \"NumReply\" int(15) NOT NULL default '0',\n".
 499 "  \"NumViews\" int(15) NOT NULL default '0',\n".
 500 "  \"Pinned\" int(5) NOT NULL default '0',\n".
 501 "  \"Closed\" int(5) NOT NULL default '0',\n".
 502 "  PRIMARY KEY  (\"id\")\n".
 503 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 504 sql_query($query,$SQLStat);
 505 $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".
 506 "(0, 1, 1, 1, 1, -1, '".$iDB_Author."', %i, %i, 'Welcome', 'Welcome %s', 0, 0, 1, 1);", array($YourDate,$YourDate,$_POST['AdminUser']));
 507 sql_query($query,$SQLStat);
 508 $query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."wordfilter\" (\n".
 509 "  \"id\" int(15) NOT NULL auto_increment,\n".
 510 "  \"FilterWord\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 511 "  \"Replacement\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
 512 "  \"CaseInsensitive\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 513 "  \"WholeWord\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
 514 "  PRIMARY KEY  (\"id\")\n".
 515 ") ENGINE=".$SQLStorageEngine."  DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
 516 sql_query($query,$SQLStat);
 517 $TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "levels", "members", "mempermissions", "messenger", "permissions", "polls", "posts", "restrictedwords", "sessions", "smileys", "themes", "topics", "wordfilter");
 518 $TablePreFix = $_POST['tableprefix'];
 519 function add_prefix($tarray) {
 520 global $TablePreFix;
 521 return $TablePreFix.$tarray; }
 522 $TableChCk = array_map("add_prefix",$TableChCk);
 523 $tcount = count($TableChCk); $ti = 0;
 524 while ($ti < $tcount) {
 525 $OptimizeTea = sql_query(sql_pre_query("OPTIMIZE TABLE \"".$TableChCk[$ti]."\"", array(null)),$SQLStat);
 526 ++$ti; }
 527 ?>