MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
Revised BSD License for more details.
- Copyright 2004-2010 iDB Support - http://idb.berlios.de/
- Copyright 2004-2010 Game Maker 2k - http://gamemaker2k.org/
+ Copyright 2004-2019 iDB Support - https://idb.osdn.jp/support/category.php?act=view&id=1
+ Copyright 2004-2019 Game Maker 2k - https://idb.osdn.jp/support/category.php?act=view&id=2
iDB Installer made by Game Maker 2k - http://idb.berlios.net/
- $FileInfo: mysql.php - Last Update: 11/05/2010 SVN 596 - Author: cooldude2k $
+ $FileInfo: mysql.php - Last Update: 08/02/2019 SVN 905 - Author: cooldude2k $
*/
$File3Name = basename($_SERVER['SCRIPT_NAME']);
if ($File3Name=="mysql.php"||$File3Name=="/mysql.php") {
exit(); }
if(!isset($SetupDir['setup'])) { $SetupDir['setup'] = "setup/"; }
if(!isset($SetupDir['convert'])) { $SetupDir['convert'] = "setup/convert/"; }
-$query=sql_pre_query("ALTER DATABASE \"".$_POST['DatabaseName']."\" DEFAULT CHARACTER SET ".$SQLCharset." COLLATE ".$SQLCollate.";", array(null));
+$query=sql_pre_query("ALTER DATABASE \"".$_POST['DatabaseName']."\" DEFAULT CHARACTER SET ".$Settings['sql_charset']." COLLATE ".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
-// You can set this to MyISAM or MARIA
-$SQLStorageEngine = "MyISAM";
+if(isset($Settings['sql_storage_engine'])) {
+$result = sql_query(sql_pre_query("SHOW ENGINES;", array(null)),$SQLStat);
+$num = sql_num_rows($result);
+$i = 0; $SQLEngines = null;
+while ($i < $num) {
+$SQLEngines[$i] = sql_result($result,$i,"Engine");
+++$i; }
+if (!in_array($Settings['sql_storage_engine'], $SQLEngines)) {
+ $Settings['sql_storage_engine'] = "InnoDB"; } }
+if(!isset($Settings['sql_storage_engine'])) {
+ $Settings['sql_storage_engine'] = "InnoDB"; }
+// You can set this to MyISAM or Maria/Aria
+if($Settings['sql_storage_engine']=="CSV") {
+ $SQLStorageEngine = "CSV"; }
+if($Settings['sql_storage_engine']=="Maria") {
+ $SQLStorageEngine = "Maria"; }
+if($Settings['sql_storage_engine']=="Aria") {
+ $SQLStorageEngine = "Aria"; }
+if($Settings['sql_storage_engine']=="MyISAM") {
+ $SQLStorageEngine = "MyISAM"; }
+if($Settings['sql_storage_engine']=="InnoDB") {
+ $SQLStorageEngine = "InnoDB"; }
+$parsestr = parse_url($YourWebsite);
+if (!filter_var($parsestr['host'], FILTER_VALIDATE_IP, FILTER_FLAG_IPV4 | FILTER_FLAG_IPV6) || $parsestr['host'] == "localhost") {
+ $GuestLocalIP = gethostbyname($parsestr['host']); } else { $GuestLocalIP = $parsestr['host']; }
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."categories\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
" \"OrderID\" int(15) NOT NULL default '0',\n".
-" \"Name\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ShowCategory\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CategoryType\" varchar(15) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"SubShowForums\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ShowCategory\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CategoryType\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"SubShowForums\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"InSubCategory\" int(15) NOT NULL default '0',\n".
" \"PostCountView\" int(15) NOT NULL default '0',\n".
" \"KarmaCountView\" int(15) NOT NULL default '0',\n".
-" \"Description\" text COLLATE ".$SQLCollate." NOT NULL,\n".
+" \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."categories\" (\"OrderID\", \"Name\", \"ShowCategory\", \"CategoryType\", \"SubShowForums\", \"InSubCategory\", \"PostCountView\", \"KarmaCountView\", \"Description\")\n".
"VALUES (1, 'A Test Category', 'yes', 'category', 'yes', 0, 0, 0, 'A test category that may be removed at any time.');", array(null));
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."catpermissions\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
" \"PermissionID\" int(15) NOT NULL default '0',\n".
-" \"Name\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"CategoryID\" int(15) NOT NULL default '0',\n".
-" \"CanViewCategory\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"CanViewCategory\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."catpermissions\" (\"PermissionID\", \"Name\", \"CategoryID\", \"CanViewCategory\") VALUES\n".
"(1, 'Admin', 1, 'yes'),\n".
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."events\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
" \"UserID\" int(15) NOT NULL default '0',\n".
-" \"GuestName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"EventName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"EventText\" text COLLATE ".$SQLCollate." NOT NULL,\n".
+" \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"EventName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"EventText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
" \"TimeStamp\" int(15) NOT NULL default '0',\n".
" \"TimeStampEnd\" int(15) NOT NULL default '0',\n".
" \"EventMonth\" int(5) NOT NULL default '0',\n".
" \"EventDayEnd\" int(5) NOT NULL default '0',\n".
" \"EventYear\" int(5) NOT NULL default '0',\n".
" \"EventYearEnd\" int(5) NOT NULL default '0',\n".
-" \"IP\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."events\" (\"UserID\", \"GuestName\", \"EventName\", \"EventText\", \"TimeStamp\", \"TimeStampEnd\", \"EventMonth\", \"EventMonthEnd\", \"EventDay\", \"EventDayEnd\", \"EventYear\", \"EventYearEnd\", \"IP\") VALUES\n".
-"(-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));
+"(-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));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."forums\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
" \"CategoryID\" int(15) NOT NULL default '0',\n".
" \"OrderID\" int(15) NOT NULL default '0',\n".
-" \"Name\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ShowForum\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ForumType\" varchar(15) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ShowForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ForumType\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"InSubForum\" int(15) NOT NULL default '0',\n".
-" \"RedirectURL\" text COLLATE ".$SQLCollate." NOT NULL,\n".
+" \"RedirectURL\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
" \"Redirects\" int(15) NOT NULL default '0',\n".
" \"NumViews\" int(15) NOT NULL default '0',\n".
-" \"Description\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"PostCountAdd\" varchar(15) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"PostCountAdd\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"PostCountView\" int(15) NOT NULL default '0',\n".
" \"KarmaCountView\" int(15) NOT NULL default '0',\n".
-" \"CanHaveTopics\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"CanHaveTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"HotTopicPosts\" int(15) NOT NULL default '0',\n".
" \"NumPosts\" int(15) NOT NULL default '0',\n".
" \"NumTopics\" int(15) NOT NULL default '0',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$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".
"(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));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."groups\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
-" \"Name\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"PermissionID\" int(15) NOT NULL default '0',\n".
-" \"NamePrefix\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"NameSuffix\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanViewBoard\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanViewOffLine\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanEditProfile\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanAddEvents\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanPM\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanSearch\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanUseBBags\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanModForum\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"NamePrefix\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"NameSuffix\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanViewBoard\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanViewOffLine\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanEditProfile\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanAddEvents\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanPM\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanSearch\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanViewIPAddress\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanViewUserAgent\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"FloodControl\" int(5) NOT NULL default '0',\n".
" \"SearchFlood\" int(5) NOT NULL default '0',\n".
" \"PromoteTo\" int(15) NOT NULL default '0',\n".
" \"PromotePosts\" int(15) NOT NULL default '0',\n".
" \"PromoteKarma\" int(15) NOT NULL default '0',\n".
-" \"HasModCP\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"HasAdminCP\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ViewDBInfo\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"HasModCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HasAdminCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ViewDBInfo\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\"),\n".
" UNIQUE KEY \"Name\" (\"Name\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
-$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".
-"('Admin', 1, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'yes', 'yes'),\n".
-"('Moderator', 2, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'no', 'no'),\n".
-"('Member', 3, '', '', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
-"('Guest', 4, '', '', 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'yes', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
-"('Banned', 5, '', '', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
-"('Validate', 6, '', '', 'yes', 'no', 'yes', 'no', 'no', 'yes', 'no', 'yes', 30, 30, 0, 0, 0, 'no', 'no', 'no');", array(null));
+$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".
+"('Admin', 1, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'yes', 'yes'),\n".
+"('Moderator', 2, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'no', 'no'),\n".
+"('Member', 3, '', '', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
+"('Guest', 4, '', '', 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'yes', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
+"('Banned', 5, '', '', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no'),\n".
+"('Validate', 6, '', '', 'yes', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no');", array(null));
+sql_query($query,$SQLStat);
+$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."levels\" (\n".
+" \"id\" int(15) NOT NULL auto_increment,\n".
+" \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"PromoteTo\" int(15) NOT NULL default '0',\n".
+" \"PromotePosts\" int(15) NOT NULL default '0',\n".
+" \"PromoteKarma\" int(15) NOT NULL default '0',\n".
+" PRIMARY KEY (\"id\"),\n".
+" UNIQUE KEY \"Name\" (\"Name\")\n".
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
+sql_query($query,$SQLStat);
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."levels\" (\"id\", \"Name\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\") VALUES\n".
+"(-1, 'Guest', 0, 0, 0),\n".
+"(1, 'Member', 0, 0, 0);", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."members\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
-" \"Name\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"UserPassword\" varchar(250) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"HashType\" varchar(50) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Email\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"UserPassword\" varchar(256) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HashType\" varchar(50) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Email\" varchar(256) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"GroupID\" int(15) NOT NULL default '0',\n".
-" \"Validated\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"HiddenMember\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"WarnLevel\" int(10) NOT NULL default '0',\n".
-" \"Interests\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Title\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"LevelID\" int(15) NOT NULL default '0',\n".
+" \"Validated\" varchar(20) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HiddenMember\" varchar(20) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"WarnLevel\" int(15) NOT NULL default '0',\n".
+" \"Interests\" text COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Title\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"Joined\" int(15) NOT NULL default '0',\n".
" \"LastActive\" int(15) NOT NULL default '0',\n".
+" \"LastLogin\" int(15) NOT NULL default '0',\n".
" \"LastPostTime\" int(15) NOT NULL default '0',\n".
" \"BanTime\" int(15) NOT NULL default '0',\n".
" \"BirthDay\" int(5) NOT NULL default '0',\n".
" \"BirthMonth\" int(5) NOT NULL default '0',\n".
" \"BirthYear\" int(5) NOT NULL default '0',\n".
-" \"Signature\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"Notes\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"Avatar\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"AvatarSize\" varchar(10) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Website\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Gender\" varchar(15) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Signature\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Notes\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Avatar\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"AvatarSize\" varchar(10) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Website\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Gender\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"PostCount\" int(15) NOT NULL default '0',\n".
" \"Karma\" int(15) NOT NULL default '0',\n".
" \"KarmaUpdate\" int(15) NOT NULL default '0',\n".
" \"RepliesPerPage\" int(5) NOT NULL default '0',\n".
" \"TopicsPerPage\" int(5) NOT NULL default '0',\n".
" \"MessagesPerPage\" int(5) NOT NULL default '0',\n".
-" \"TimeZone\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '0',\n".
-" \"DST\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '0',\n".
-" \"UseTheme\" varchar(32) COLLATE ".$SQLCollate." NOT NULL default '0',\n".
-" \"IP\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Salt\" varchar(50) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"TimeZone\" varchar(256) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
+" \"DateFormat\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
+" \"TimeFormat\" varchar(15) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
+" \"UseTheme\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '0',\n".
+" \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Salt\" varchar(50) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\"),\n".
" UNIQUE KEY \"Name\" (\"Name\"),\n".
" UNIQUE KEY \"Email\" (\"Email\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
-$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".
-"(-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".
-"(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));
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."members\" (\"id\", \"Name\", \"UserPassword\", \"HashType\", \"Email\", \"GroupID\", \"LevelID\", \"Validated\", \"HiddenMember\", \"WarnLevel\", \"Interests\", \"Title\", \"Joined\", \"LastActive\", \"LastLogin\", \"LastPostTime\", \"BanTime\", \"BirthDay\", \"BirthMonth\", \"BirthYear\", \"Signature\", \"Notes\", \"Avatar\", \"AvatarSize\", \"Website\", \"Gender\", \"PostCount\", \"Karma\", \"KarmaUpdate\", \"RepliesPerPage\", \"TopicsPerPage\", \"MessagesPerPage\", \"TimeZone\", \"DateFormat\", \"TimeFormat\", \"UseTheme\", \"IP\", \"Salt\") VALUES\n".
+"(-1, 'Guest', '%s', 'GuestPassword', '%s', 4, -1, 'no', 'yes', 0, 'Guest Account', 'Guest', %i, %i, %i, '0', '0', '0', '0', '0', '', 'Your Notes', 'http://', '100x100', '%s', 'UnKnow', 1, 0, 0, 10, 10, 10, '%s', '%s', '%s', '%s', '".$GuestLocalIP."', '%s'),\n".
+"(1, '%s', '%s', '".$iDBHashType."', '%s', 1, 1, 'yes', 'no', 0, '%s', 'Admin', %i, %i, %i, '0', '0', '0', '0', '0', '%s', 'Your Notes', '%s', '100x100', '%s', 'UnKnow', 0, 0, 0, 10, 10, 10, '%s', '%s', '%s', '%s', '%s', '%s');", array($GuestPassword,$GEmail,$YourDate,$YourDate,$YourDate,$YourWebsite,$_POST['YourOffSet'],$_POST['iDBDateFormat'],$_POST['iDBTimeFormat'],$_POST['DefaultTheme'],$GSalt,$_POST['AdminUser'],$NewPassword,$_POST['AdminEmail'],"",$YourDate,$YourDate,$YourDate,"","http://",$YourWebsite,$_POST['YourOffSet'],$_POST['iDBDateFormat'],$_POST['iDBTimeFormat'],$_POST['DefaultTheme'],$UserIP,$YourSalt));
+sql_query($query,$SQLStat);
+$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."mempermissions\" (\n".
+" \"id\" int(15) NOT NULL auto_increment,\n".
+" \"PermissionID\" int(15) NOT NULL default '0',\n".
+" \"CanViewBoard\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanViewOffLine\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanEditProfile\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanAddEvents\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanPM\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanSearch\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanViewIPAddress\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanViewUserAgent\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"FloodControl\" int(5) NOT NULL default '0',\n".
+" \"SearchFlood\" int(5) NOT NULL default '0',\n".
+" \"HasModCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HasAdminCP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ViewDBInfo\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" PRIMARY KEY (\"id\")\n".
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
+sql_query($query,$SQLStat);
+$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".
+"(-1, 0, 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', -1, -1, 'group', 'group', 'group'),\n".
+"(1, 0, 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', 'group', -1, -1, 'group', 'group', 'group');", array(null));
+//"(-1, 0, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 'no', 'no', 'no'),\n".
+//"(1, 0, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 30, 30, 'yes', 'yes', 'yes');", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."messenger\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
+" \"DiscussionID\" int(15) NOT NULL default '0',\n".
" \"SenderID\" int(15) NOT NULL default '0',\n".
" \"ReciverID\" int(15) NOT NULL default '0',\n".
-" \"GuestName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MessageTitle\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MessageText\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"Description\" text COLLATE ".$SQLCollate." NOT NULL,\n".
+" \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MessageTitle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MessageText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
" \"DateSend\" int(15) NOT NULL default '0',\n".
" \"Read\" int(5) NOT NULL default '0',\n".
-" \"IP\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
-$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."messenger\" (\"SenderID\", \"ReciverID\", \"GuestName\", \"MessageTitle\", \"MessageText\", \"Description\", \"DateSend\", \"Read\", \"IP\") VALUES\n".
-"(-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));
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."messenger\" (\"DiscussionID\", \"SenderID\", \"ReciverID\", \"GuestName\", \"MessageTitle\", \"MessageText\", \"Description\", \"DateSend\", \"Read\", \"IP\") VALUES\n".
+"(0, -1, 1, '".$iDB_Author."', 'Welcome', 'Welcome to your new Internet Discussion Board! :)', 'Welcome %s', %i, 0, '".$GuestLocalIP."');", array($_POST['AdminUser'],$YourDate));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."permissions\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
" \"PermissionID\" int(15) NOT NULL default '0',\n".
-" \"Name\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Name\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"ForumID\" int(15) NOT NULL default '0',\n".
-" \"CanViewForum\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanMakeTopics\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanMakeReplys\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanMakeReplysCT\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanEditTopics\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanEditTopicsCT\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanEditReplys\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanEditReplysCT\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanDeleteTopics\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanDeleteTopicsCT\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanDeleteReplys\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanDeleteReplysCT\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanCloseTopics\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanPinTopics\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanDoHTML\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanUseBBags\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CanModForum\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"CanViewForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanMakePolls\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanMakeTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanMakeReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanMakeReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanEditTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanEditTopicsCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanEditReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanEditReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanDeleteTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanDeleteTopicsCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanDeleteReplys\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanDeleteReplysCT\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanCloseTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanPinTopics\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanExecPHP\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanDoHTML\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanUseBBTags\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CanModForum\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
-$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".
-"(1, 'Admin', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'),\n".
-"(2, 'Moderator', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'),\n".
-"(3, 'Member', 1, 'yes', 'yes', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'no', 'no', 'no', 'yes', 'no'),\n".
-"(4, 'Guest', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
-"(5, 'Banned', 1, 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
-"(6, 'Validate', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');", array(null));
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakePolls\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\") VALUES\n".
+"(1, 'Admin', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes'),\n".
+"(2, 'Moderator', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes'),\n".
+"(3, 'Member', 1, 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'no', 'no', 'no', 'no', 'yes', 'no'),\n".
+"(4, 'Guest', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
+"(5, 'Banned', 1, 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no'),\n".
+"(6, 'Validate', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');", array(null));
+sql_query($query,$SQLStat);
+$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."polls\" (\n".
+" \"id\" int(15) NOT NULL auto_increment,\n".
+" \"UserID\" int(15) NOT NULL default '0',\n".
+" \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"PollValues\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"UsersVoted\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" PRIMARY KEY (\"id\")\n".
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."posts\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
" \"ForumID\" int(15) NOT NULL default '0',\n".
" \"CategoryID\" int(15) NOT NULL default '0',\n".
" \"UserID\" int(15) NOT NULL default '0',\n".
-" \"GuestName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"TimeStamp\" int(15) NOT NULL default '0',\n".
" \"LastUpdate\" int(15) NOT NULL default '0',\n".
" \"EditUser\" int(15) NOT NULL default '0',\n".
-" \"EditUserName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Post\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"Description\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"IP\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"EditIP\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"EditUserName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Post\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"EditIP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."posts\" (\"TopicID\", \"ForumID\", \"CategoryID\", \"UserID\", \"GuestName\", \"TimeStamp\", \"LastUpdate\", \"EditUser\", \"EditUserName\", \"Post\", \"Description\", \"IP\", \"EditIP\") VALUES\n".
-"(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']));
+"(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']));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."restrictedwords\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
-" \"Word\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"RestrictedUserName\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"RestrictedTopicName\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"RestrictedEventName\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"RestrictedMessageName\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CaseInsensitive\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"WholeWord\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Word\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"RestrictedUserName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"RestrictedTopicName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"RestrictedEventName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"RestrictedMessageName\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CaseInsensitive\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"WholeWord\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."sessions\" (\n".
-" \"session_id\" VARCHAR(250) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"session_data\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"user_agent\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"ip_address\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"session_id\" VARCHAR(250) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"session_data\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"serialized_data\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"user_agent\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"ip_address\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"expires\" int(15) NOT NULL default '0',\n".
" PRIMARY KEY (\"session_id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."smileys\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
-" \"FileName\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"SmileName\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"SmileText\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"Directory\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"Display\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ReplaceCI\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"FileName\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"SmileName\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"SmileText\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Directory\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Display\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ReplaceCI\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."smileys\" (\"FileName\", \"SmileName\", \"SmileText\", \"Directory\", \"Display\", \"ReplaceCI\") VALUES\n".
"('angry.png', 'Angry', ':angry:', 'smileys/', 'yes', 'yes'),\n".
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."tagboard\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
" \"UserID\" int(15) NOT NULL default '0',\n".
-" \"GuestName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"TimeStamp\" int(15) NOT NULL default '0',\n".
-" \"Post\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"IP\" varchar(20) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Post\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"IP\" varchar(64) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$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));
sql_query($query,$SQLStat);
*/
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."themes\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
-" \"Name\" varchar(32) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ThemeName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ThemeMaker\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ThemeVersion\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ThemeVersionType\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ThemeSubVersion\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MakerURL\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CopyRight\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"CSS\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"CSSType\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"FavIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"TableStyle\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MiniPageAltStyle\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"PreLogo\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Logo\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"LogoStyle\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"SubLogo\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"TopicIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedTopicIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"HotTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedHotTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"PinTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"AnnouncementTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedPinTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"HotPinTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedHotPinTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"HotClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedHotClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"PinClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedPinClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"HotPinClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MovedHotPinClosedTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MessageRead\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"MessageUnread\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Profile\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"WWW\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"PM\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"TopicLayout\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"AddReply\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"FastReply\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"NewTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"QuoteReply\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"EditReply\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"DeleteReply\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Report\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"LineDivider\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ButtonDivider\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"LineDividerTopic\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"TitleDivider\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ForumStyle\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"ForumIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"SubForumIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"RedirectIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"TitleIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"NavLinkIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"NavLinkDivider\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"StatsIcon\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"NoAvatar\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"NoAvatarSize\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"Name\" varchar(32) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ThemeName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ThemeMaker\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ThemeVersion\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ThemeVersionType\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ThemeSubVersion\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MakerURL\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"CopyRight\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"WrapperString\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"CSS\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"CSSType\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"FavIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"TableStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MiniPageAltStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"PreLogo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Logo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"LogoStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"SubLogo\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"TopicIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedTopicIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HotTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedHotTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"PinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"AnnouncementTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HotPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedHotPinTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HotClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedHotClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"PinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"HotPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MovedHotPinClosedTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MessageRead\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MessageUnread\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Profile\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"WWW\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"PM\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"TopicLayout\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"AddReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"FastReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"NewTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"QuoteReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"EditReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"DeleteReply\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Report\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"LineDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ButtonDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"LineDividerTopic\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"TitleDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ForumStyle\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"ForumIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"SubForumIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"RedirectIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"TitleIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"NavLinkIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"NavLinkDivider\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"BoardStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"MemberStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"BirthdayStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"EventStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"OnlineStatsIcon\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"NoAvatar\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"NoAvatarSize\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\"),\n".
" UNIQUE KEY \"Name\" (\"Name\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."topics\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
+" \"PollID\" int(15) NOT NULL default '0',\n".
" \"ForumID\" int(15) NOT NULL default '0',\n".
" \"CategoryID\" int(15) NOT NULL default '0',\n".
" \"OldForumID\" int(15) NOT NULL default '0',\n".
" \"OldCategoryID\" int(15) NOT NULL default '0',\n".
" \"UserID\" int(15) NOT NULL default '0',\n".
-" \"GuestName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"GuestName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" \"TimeStamp\" int(15) NOT NULL default '0',\n".
" \"LastUpdate\" int(15) NOT NULL default '0',\n".
-" \"TopicName\" varchar(150) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"Description\" text COLLATE ".$SQLCollate." NOT NULL,\n".
+" \"TopicName\" varchar(150) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"Description\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
" \"NumReply\" int(15) NOT NULL default '0',\n".
" \"NumViews\" int(15) NOT NULL default '0',\n".
" \"Pinned\" int(5) NOT NULL default '0',\n".
" \"Closed\" int(5) NOT NULL default '0',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
-$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".
-"(1, 1, 1, 1, -1, '".$iDB_Author."', %i, %i, 'Welcome', 'Welcome %s', 0, 0, 1, 1);", array($YourDate,$YourDate,$_POST['AdminUser']));
+$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".
+"(0, 1, 1, 1, 1, -1, '".$iDB_Author."', %i, %i, 'Welcome', 'Welcome %s', 0, 0, 1, 1);", array($YourDate,$YourDate,$_POST['AdminUser']));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE IF NOT EXISTS \"".$_POST['tableprefix']."wordfilter\" (\n".
" \"id\" int(15) NOT NULL auto_increment,\n".
-" \"FilterWord\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"Replacement\" text COLLATE ".$SQLCollate." NOT NULL,\n".
-" \"CaseInsensitive\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
-" \"WholeWord\" varchar(5) COLLATE ".$SQLCollate." NOT NULL default '',\n".
+" \"FilterWord\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"Replacement\" text COLLATE ".$Settings['sql_collate']." NOT NULL,\n".
+" \"CaseInsensitive\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
+" \"WholeWord\" varchar(5) COLLATE ".$Settings['sql_collate']." NOT NULL default '',\n".
" PRIMARY KEY (\"id\")\n".
-") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$SQLCharset." COLLATE=".$SQLCollate.";", array(null));
+") ENGINE=".$SQLStorageEngine." DEFAULT CHARSET=".$Settings['sql_charset']." COLLATE=".$Settings['sql_collate'].";", array(null));
sql_query($query,$SQLStat);
-$TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "members", "messenger", "permissions", "posts", "restrictedwords", "sessions", "smileys", "topics", "wordfilter");
+$TableChCk = array("categories", "catpermissions", "events", "forums", "groups", "levels", "members", "mempermissions", "messenger", "permissions", "polls", "posts", "restrictedwords", "sessions", "smileys", "themes", "topics", "wordfilter");
$TablePreFix = $_POST['tableprefix'];
function add_prefix($tarray) {
global $TablePreFix;