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