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