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