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