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