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