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: sqlite.php - Last Update: 04/06/2010 SVN 462 - Author: cooldude2k $
+ $FileInfo: sqlite.php - Last Update: 4/2/2022 SVN 940 - Author: cooldude2k $
*/
$File3Name = basename($_SERVER['SCRIPT_NAME']);
if ($File3Name=="sqlite.php"||$File3Name=="/sqlite.php") {
$query=sql_pre_query("ALTER DATABASE \"".$_POST['DatabaseName']."\" DEFAULT CHARACTER SET ".$SQLCharset." COLLATE ".$SQLCollate.";", array(null));
sql_query($query,$SQLStat);
*/
+$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 \"".$_POST['tableprefix']."categories\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
" \"OrderID\" INTEGER NOT NULL default '0',\n".
" \"EventDay\" INTEGER NOT NULL default '0',\n".
" \"EventDayEnd\" INTEGER NOT NULL default '0',\n".
" \"EventYear\" INTEGER NOT NULL default '0',\n".
-" \"EventYearEnd\" INTEGER NOT NULL default '0'\n".
+" \"EventYearEnd\" INTEGER NOT NULL default '0',\n".
+" \"IP\" VARCHAR(64) NOT NULL default ''\n".
");", 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\") VALUES\n".
-"(-1, '".$iDB_Author."', 'iDB Install', 'This is the start date of your board. ^_^', %i, %i, %i, %i, %i, %i, %i, %i);", array($YourDate,$YourDateEnd,$EventMonth,$EventMonthEnd,$EventDay,$EventDayEnd,$EventYear,$EventYearEnd));
+$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, '".$GuestLocalIP."');", array($YourDate,$YourDateEnd,$EventMonth,$EventMonthEnd,$EventDay,$EventDayEnd,$EventYear,$EventYearEnd));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."forums\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
" \"CanAddEvents\" VARCHAR(5) NOT NULL default '',\n".
" \"CanPM\" VARCHAR(5) NOT NULL default '',\n".
" \"CanSearch\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanExecPHP\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanDoHTML\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanUseBBTags\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanModForum\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanViewIPAddress\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanViewUserAgent\" VARCHAR(5) NOT NULL default '',\n".
" \"FloodControl\" INTEGER NOT NULL default '0',\n".
" \"SearchFlood\" INTEGER NOT NULL default '0',\n".
" \"PromoteTo\" INTEGER NOT NULL default '0',\n".
" \"ViewDBInfo\" VARCHAR(5) NOT NULL default ''\n".
");", 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\", \"FloodControl\", \"SearchFlood\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
-"('Admin', 1, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'yes', 'yes');", 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');", 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\", \"FloodControl\", \"SearchFlood\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
-"('Moderator', 2, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', '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".
+"('Moderator', 2, '', '', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes', 'yes', 'yes', 30, 30, 0, 0, 0, 'yes', 'no', 'no');", 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\", \"FloodControl\", \"SearchFlood\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
-"('Member', 3, '', '', 'yes', 'no', 'yes', 'yes', 'yes', '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".
+"('Member', 3, '', '', 'yes', 'no', 'yes', 'yes', 'yes', '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("INSERT INTO \"".$_POST['tableprefix']."groups\" (\"Name\", \"PermissionID\", \"NamePrefix\", \"NameSuffix\", \"CanViewBoard\", \"CanViewOffLine\", \"CanEditProfile\", \"CanAddEvents\", \"CanPM\", \"CanSearch\", \"FloodControl\", \"SearchFlood\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
-"('Guest', 4, '', '', 'yes', 'no', 'no', 'no', 'no', 'no', 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".
+"('Guest', 4, '', '', 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'yes', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no');", 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\", \"FloodControl\", \"SearchFlood\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
-"('Banned', 5, '', '', 'no', 'no', 'no', 'no', 'no', 'no', 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".
+"('Banned', 5, '', '', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 0, 0, 0, 'no', 'no', 'no');", 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\", \"FloodControl\", \"SearchFlood\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\", \"HasModCP\", \"HasAdminCP\", \"ViewDBInfo\") VALUES\n".
-"('Validate', 6, '', '', 'yes', 'no', 'yes', 'no', '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".
+"('Validate', 6, '', '', 'yes', 'no', 'yes', 'no', 'no', 'yes', 'no', 'no', 'no', 'yes', '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\" INTEGER PRIMARY KEY NOT NULL,\n".
+" \"Name\" VARCHAR(150) UNIQUE NOT NULL default '',\n".
+" \"PromoteTo\" INTEGER NOT NULL default '0',\n".
+" \"PromotePosts\" INTEGER NOT NULL default '0',\n".
+" \"PromoteKarma\" INTEGER NOT NULL default '0'\n".
+");", 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);", array(null));
+sql_query($query,$SQLStat);
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."levels\" (\"id\", \"Name\", \"PromoteTo\", \"PromotePosts\", \"PromoteKarma\") VALUES\n".
+"(1, 'Member', 0, 0, 0);", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."members\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
" \"Name\" VARCHAR(150) UNIQUE NOT NULL default '',\n".
-" \"UserPassword\" VARCHAR(250) NOT NULL default '',\n".
+" \"UserPassword\" VARCHAR(256) NOT NULL default '',\n".
" \"HashType\" VARCHAR(50) NOT NULL default '',\n".
-" \"Email\" VARCHAR(150) UNIQUE NOT NULL default '',\n".
+" \"Email\" VARCHAR(256) UNIQUE NOT NULL default '',\n".
" \"GroupID\" INTEGER NOT NULL default '0',\n".
+" \"LevelID\" INTEGER NOT NULL default '0',\n".
" \"Validated\" VARCHAR(20) NOT NULL default '',\n".
" \"HiddenMember\" VARCHAR(20) NOT NULL default '',\n".
" \"WarnLevel\" INTEGER NOT NULL default '0',\n".
-" \"Interests\" VARCHAR(150) NOT NULL default '',\n".
+" \"Interests\" TEXT NOT NULL default '',\n".
" \"Title\" VARCHAR(150) NOT NULL default '',\n".
" \"Joined\" INTEGER NOT NULL default '0',\n".
" \"LastActive\" INTEGER NOT NULL default '0',\n".
+" \"LastLogin\" INTEGER NOT NULL default '0',\n".
" \"LastPostTime\" INTEGER NOT NULL default '0',\n".
" \"BanTime\" INTEGER NOT NULL default '0',\n".
" \"BirthDay\" INTEGER NOT NULL default '0',\n".
" \"Avatar\" VARCHAR(150) NOT NULL default '',\n".
" \"AvatarSize\" VARCHAR(10) NOT NULL default '',\n".
" \"Website\" VARCHAR(150) NOT NULL default '',\n".
+" \"Location\" VARCHAR(150) NOT NULL default '',\n".
" \"Gender\" VARCHAR(15) NOT NULL default '',\n".
" \"PostCount\" INTEGER NOT NULL default '0',\n".
" \"Karma\" INTEGER NOT NULL default '0',\n".
" \"RepliesPerPage\" INTEGER NOT NULL default '0',\n".
" \"TopicsPerPage\" INTEGER NOT NULL default '0',\n".
" \"MessagesPerPage\" INTEGER NOT NULL default '0',\n".
-" \"TimeZone\" VARCHAR(5) NOT NULL default '0',\n".
-" \"DST\" VARCHAR(5) NOT NULL default '0',\n".
-" \"UseTheme\" VARCHAR(26) NOT NULL default '0',\n".
-" \"IP\" VARCHAR(20) NOT NULL default '',\n".
+" \"TimeZone\" VARCHAR(256) NOT NULL default '',\n".
+" \"DateFormat\" VARCHAR(15) NOT NULL default '',\n".
+" \"TimeFormat\" VARCHAR(15) NOT NULL default '',\n".
+" \"UseTheme\" VARCHAR(32) NOT NULL default '',\n".
+" \"IgnoreSignitures\" VARCHAR(32) NOT NULL default '',\n".
+" \"IgnoreAdvatars\" VARCHAR(32) NOT NULL default '',\n".
+" \"IgnoreUsers\" VARCHAR(32) NOT NULL default '',\n".
+" \"IP\" VARCHAR(64) NOT NULL default '',\n".
" \"Salt\" VARCHAR(50) NOT NULL default ''\n".
");", 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');", array($GuestPassword,$GEmail,$YourDate,$YourDate,$YourWebsite,$AdminTime,$AdminDST,$GSalt));
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."members\" (\"id\", \"Name\", \"UserPassword\", \"HashType\", \"Email\", \"GroupID\", \"LevelID\", \"Validated\", \"HiddenMember\", \"WarnLevel\", \"Interests\", \"Title\", \"Joined\", \"LastActive\", \"LastLogin\", \"LastPostTime\", \"BanTime\", \"BirthDay\", \"BirthMonth\", \"BirthYear\", \"Signature\", \"Notes\", \"Avatar\", \"AvatarSize\", \"Website\", \"Location\", \"Gender\", \"PostCount\", \"Karma\", \"KarmaUpdate\", \"RepliesPerPage\", \"TopicsPerPage\", \"MessagesPerPage\", \"TimeZone\", \"DateFormat\", \"TimeFormat\", \"UseTheme\", \"IgnoreSignitures\", \"IgnoreAdvatars\", \"IgnoreUsers\", \"IP\", \"Salt\") VALUES\n".
+"(-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', '%s', '%s', '%s', '%s', '%s');", array($GuestPassword,$GEmail,$YourDate,$YourDate,$YourDate,$YourWebsite,$_POST['YourOffSet'],$_POST['iDBDateFormat'],$_POST['iDBTimeFormat'],$_POST['DefaultTheme'],'','','',$GuestLocalIP,$GSalt));
+sql_query($query,$SQLStat);
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."members\" (\"id\", \"Name\", \"UserPassword\", \"HashType\", \"Email\", \"GroupID\", \"LevelID\", \"Validated\", \"HiddenMember\", \"WarnLevel\", \"Interests\", \"Title\", \"Joined\", \"LastActive\", \"LastLogin\", \"LastPostTime\", \"BanTime\", \"BirthDay\", \"BirthMonth\", \"BirthYear\", \"Signature\", \"Notes\", \"Avatar\", \"AvatarSize\", \"Website\", \"Location\", \"Gender\", \"PostCount\", \"Karma\", \"KarmaUpdate\", \"RepliesPerPage\", \"TopicsPerPage\", \"MessagesPerPage\", \"TimeZone\", \"DateFormat\", \"TimeFormat\", \"UseTheme\", \"IgnoreSignitures\", \"IgnoreAdvatars\", \"IgnoreUsers\", \"IP\", \"Salt\") VALUES\n".
+"(1, '%s', '%s', '%s', '%s', 1, 1, 'yes', 'no', 0, '%s', 'Admin', %i, %i, %i, '0', '0', '0', '0', '0', '%s', 'Your Notes', '%s', '', '100x100', '%s', 'UnKnow', 0, 0, 0, 10, 10, 10, '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s');", array($_POST['AdminUser'],$NewPassword,$iDBHashType,$_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 \"".$_POST['tableprefix']."mempermissions\" (\n".
+" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
+" \"PermissionID\" INTEGER NOT NULL default '0',\n".
+" \"CanViewBoard\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanViewOffLine\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanEditProfile\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanAddEvents\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanPM\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanSearch\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanExecPHP\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanDoHTML\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanUseBBTags\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanModForum\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanViewIPAddress\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanViewUserAgent\" VARCHAR(5) NOT NULL default '',\n".
+" \"FloodControl\" INTEGER NOT NULL default '0',\n".
+" \"SearchFlood\" INTEGER NOT NULL default '0',\n".
+" \"HasModCP\" VARCHAR(5) NOT NULL default '',\n".
+" \"HasAdminCP\" VARCHAR(5) NOT NULL default '',\n".
+" \"ViewDBInfo\" VARCHAR(5) NOT NULL default ''\n".
+");", 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');", array(null));
+//"(-1, 0, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 30, 30, 'no', 'no', 'no');", 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, '%s', '%s', '".$iDBHashType."', '%s', 1, 'yes', 'no', 0, '%s', 'Admin', %i, %i, '0', '0', '0', '0', '0', '%s', 'Your Notes', '%s', '100x100', '%s', 'UnKnow', 0, 0, 0, 10, 10, 10, '%s', '%s', '".$_POST['DefaultTheme']."', '%s', '%s');", array($_POST['AdminUser'],$NewPassword,$_POST['AdminEmail'],$Interests,$YourDate,$YourDate,$NewSignature,$Avatar,$YourWebsite,$AdminTime,$AdminDST,$UserIP,$YourSalt));
+$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');", array(null));
+//"(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 \"".$_POST['tableprefix']."messenger\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
+" \"DiscussionID\" INTEGER NOT NULL default '0',\n".
" \"SenderID\" INTEGER NOT NULL default '0',\n".
" \"ReciverID\" INTEGER NOT NULL default '0',\n".
" \"GuestName\" VARCHAR(150) NOT NULL default '',\n".
" \"MessageText\" TEXT NOT NULL,\n".
" \"Description\" TEXT NOT NULL,\n".
" \"DateSend\" INTEGER NOT NULL default '0',\n".
-" \"Read\" INTEGER NOT NULL default '0'\n".
+" \"Read\" INTEGER NOT NULL default '0',\n".
+" \"IP\" VARCHAR(64) NOT NULL default ''\n".
");", array(null));
sql_query($query,$SQLStat);
-$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."messenger\" (\"SenderID\", \"ReciverID\", \"GuestName\", \"MessageTitle\", \"MessageText\", \"Description\", \"DateSend\", \"Read\") 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);", 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 \"".$_POST['tableprefix']."permissions\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
" \"Name\" VARCHAR(150) NOT NULL default '',\n".
" \"ForumID\" INTEGER NOT NULL default '0',\n".
" \"CanViewForum\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanMakePolls\" VARCHAR(5) NOT NULL default '',\n".
" \"CanMakeTopics\" VARCHAR(5) NOT NULL default '',\n".
" \"CanMakeReplys\" VARCHAR(5) NOT NULL default '',\n".
" \"CanMakeReplysCT\" VARCHAR(5) NOT NULL default '',\n".
+" \"HideEditPostInfo\" VARCHAR(5) NOT NULL default '',\n".
" \"CanEditTopics\" VARCHAR(5) NOT NULL default '',\n".
" \"CanEditTopicsCT\" VARCHAR(5) NOT NULL default '',\n".
" \"CanEditReplys\" VARCHAR(5) NOT NULL default '',\n".
" \"CanDeleteTopicsCT\" VARCHAR(5) NOT NULL default '',\n".
" \"CanDeleteReplys\" VARCHAR(5) NOT NULL default '',\n".
" \"CanDeleteReplysCT\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanDoublePost\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanDoublePostCT\" VARCHAR(5) NOT NULL default '',\n".
+" \"GotoEditPost\" VARCHAR(5) NOT NULL default '',\n".
" \"CanCloseTopics\" VARCHAR(5) NOT NULL default '',\n".
" \"CanPinTopics\" VARCHAR(5) NOT NULL default '',\n".
-" \"CanDohtml\" VARCHAR(5) NOT NULL default '',\n".
-" \"CanUseBBags\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanExecPHP\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanDoHTML\" VARCHAR(5) NOT NULL default '',\n".
+" \"CanUseBBTags\" VARCHAR(5) NOT NULL default '',\n".
" \"CanModForum\" VARCHAR(5) NOT NULL default ''\n".
+" \"CanReportPost\" VARCHAR(5) NOT NULL default ''\n".
");", 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');", array(null));
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakePolls\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"HideEditPostInfo\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDoublePost\", \"CanDoublePostCT\", \"GotoEditPost\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanReportPost\") VALUES\n".
+"(1, 'Admin', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');", 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".
-"(2, 'Moderator', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes');", array(null));
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakePolls\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"HideEditPostInfo\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDoublePost\", \"CanDoublePostCT\", \"GotoEditPost\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanReportPost\") VALUES\n".
+"(2, 'Moderator', 1, 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'yes', 'yes', 'yes', 'no', 'no', 'yes', 'yes', 'yes');", 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".
-"(3, 'Member', 1, 'yes', 'yes', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'no', 'no', 'no', 'no', 'yes', 'no');", array(null));
+$query = sql_pre_query("INSERT INTO \"".$_POST['tableprefix']."permissions\" (\"PermissionID\", \"Name\", \"ForumID\", \"CanViewForum\", \"CanMakePolls\", \"CanMakeTopics\", \"CanMakeReplys\", \"CanMakeReplysCT\", \"HideEditPostInfo\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDoublePost\", \"CanDoublePostCT\", \"GotoEditPost\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanReportPost\") VALUES\n".
+"(3, 'Member', 1, 'yes', 'yes', 'yes', 'yes', 'no', 'yes', 'no', 'no', 'yes', 'no', 'yes', 'no', 'yes', 'yes', 'no', 'yes', 'no', 'no', 'no', 'no', 'no', 'yes', 'no', 'yes');", 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".
-"(4, 'Guest', 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\", \"HideEditPostInfo\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDoublePost\", \"CanDoublePostCT\", \"GotoEditPost\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanReportPost\") VALUES\n".
+"(4, 'Guest', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');", 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".
-"(5, 'Banned', 1, 'no', '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\", \"HideEditPostInfo\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDoublePost\", \"CanDoublePostCT\", \"GotoEditPost\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanReportPost\") VALUES\n".
+"(5, 'Banned', 1, 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');", 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".
-"(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\", \"HideEditPostInfo\", \"CanEditTopics\", \"CanEditTopicsCT\", \"CanEditReplys\", \"CanEditReplysCT\", \"CanDeleteTopics\", \"CanDeleteTopicsCT\", \"CanDoublePost\", \"CanDoublePostCT\", \"GotoEditPost\", \"CanDeleteReplys\", \"CanDeleteReplysCT\", \"CanCloseTopics\", \"CanPinTopics\", \"CanExecPHP\", \"CanDoHTML\", \"CanUseBBTags\", \"CanModForum\", \"CanReportPost\") VALUES\n".
+"(6, 'Validate', 1, 'yes', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no', 'no');", array(null));
+sql_query($query,$SQLStat);
+$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."polls\" (\n".
+" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
+" \"UserID\" INTEGER NOT NULL default '0',\n".
+" \"GuestName\" VARCHAR(150) NOT NULL default '',\n".
+" \"PollValues\" TEXT NOT NULL,\n".
+" \"Description\" TEXT NOT NULL,\n".
+" \"UsersVoted\" TEXT NOT NULL,\n".
+" \"IP\" VARCHAR(64) NOT NULL default ''\n".
+");", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."posts\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
" \"EditUserName\" VARCHAR(150) NOT NULL default '',\n".
" \"Post\" TEXT NOT NULL,\n".
" \"Description\" TEXT NOT NULL,\n".
-" \"IP\" VARCHAR(20) NOT NULL default '',\n".
-" \"EditIP\" VARCHAR(20) NOT NULL default ''\n".
+" \"IP\" VARCHAR(64) NOT NULL default '',\n".
+" \"EditIP\" VARCHAR(64) NOT NULL default ''\n".
");", 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 \"".$_POST['tableprefix']."restrictedwords\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
");", array(null));
sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."sessions\" (\n".
-" \"session_id\" VARCHAR(150) PRIMARY KEY NOT NULL default '',\n".
+" \"session_id\" VARCHAR(250) PRIMARY KEY NOT NULL default '',\n".
" \"session_data\" TEXT NOT NULL,\n".
+" \"serialized_data\" TEXT NOT NULL,\n".
+" \"user_agent\" TEXT NOT NULL,\n".
+" \"ip_address\" VARCHAR(64) NOT NULL default '',\n".
" \"expires\" INTEGER NOT NULL default '0'\n".
");", array(null));
sql_query($query,$SQLStat);
" \"GuestName\" VARCHAR(150) NOT NULL default '',\n".
" \"TimeStamp\" INTEGER NOT NULL default '0',\n".
" \"Post\" TEXT NOT NULL,\n".
-" \"IP\" VARCHAR(20) NOT NULL default ''
+" \"IP\" VARCHAR(64) NOT NULL default ''
");", 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 \"".$_POST['tableprefix']."themes\" (\n".
+" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
+" \"Name\" VARCHAR(32) UNIQUE NOT NULL default '',\n".
+" \"ThemeName\" VARCHAR(150) NOT NULL default '',\n".
+" \"ThemeMaker\" VARCHAR(150) NOT NULL default '',\n".
+" \"ThemeVersion\" VARCHAR(150) NOT NULL default '',\n".
+" \"ThemeVersionType\" VARCHAR(150) NOT NULL default '',\n".
+" \"ThemeSubVersion\" VARCHAR(150) NOT NULL default '',\n".
+" \"MakerURL\" VARCHAR(150) NOT NULL default '',\n".
+" \"CopyRight\" VARCHAR(150) NOT NULL default '',\n".
+" \"WrapperString\" TEXT NOT NULL default '',\n".
+" \"CSS\" TEXT NOT NULL,\n".
+" \"CSSType\" VARCHAR(150) NOT NULL default '',\n".
+" \"FavIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"OpenGraph\" VARCHAR(150) NOT NULL default '',\n".
+" \"TableStyle\" VARCHAR(150) NOT NULL default '',\n".
+" \"MiniPageAltStyle\" VARCHAR(150) NOT NULL default '',\n".
+" \"PreLogo\" VARCHAR(150) NOT NULL default '',\n".
+" \"Logo\" VARCHAR(150) NOT NULL default '',\n".
+" \"LogoStyle\" VARCHAR(150) NOT NULL default '',\n".
+" \"SubLogo\" VARCHAR(150) NOT NULL default '',\n".
+" \"TopicIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedTopicIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"HotTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedHotTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"PinTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"AnnouncementTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedPinTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"HotPinTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedHotPinTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"ClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"HotClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedHotClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"PinClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedPinClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"HotPinClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MovedHotPinClosedTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"MessageRead\" VARCHAR(150) NOT NULL default '',\n".
+" \"MessageUnread\" VARCHAR(150) NOT NULL default '',\n".
+" \"Profile\" VARCHAR(150) NOT NULL default '',\n".
+" \"WWW\" VARCHAR(150) NOT NULL default '',\n".
+" \"PM\" VARCHAR(150) NOT NULL default '',\n".
+" \"TopicLayout\" VARCHAR(150) NOT NULL default '',\n".
+" \"AddReply\" VARCHAR(150) NOT NULL default '',\n".
+" \"FastReply\" VARCHAR(150) NOT NULL default '',\n".
+" \"NewTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"QuoteReply\" VARCHAR(150) NOT NULL default '',\n".
+" \"EditReply\" VARCHAR(150) NOT NULL default '',\n".
+" \"DeleteReply\" VARCHAR(150) NOT NULL default '',\n".
+" \"Report\" VARCHAR(150) NOT NULL default '',\n".
+" \"LineDivider\" VARCHAR(150) NOT NULL default '',\n".
+" \"ButtonDivider\" VARCHAR(150) NOT NULL default '',\n".
+" \"LineDividerTopic\" VARCHAR(150) NOT NULL default '',\n".
+" \"TitleDivider\" VARCHAR(150) NOT NULL default '',\n".
+" \"ForumStyle\" VARCHAR(150) NOT NULL default '',\n".
+" \"ForumIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"SubForumIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"RedirectIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"TitleIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"NavLinkIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"NavLinkDivider\" VARCHAR(150) NOT NULL default '',\n".
+" \"BoardStatsIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"MemberStatsIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"BirthdayStatsIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"EventStatsIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"OnlineStatsIcon\" VARCHAR(150) NOT NULL default '',\n".
+" \"NoAvatar\" VARCHAR(150) NOT NULL default '',\n".
+" \"NoAvatarSize\" VARCHAR(150) NOT NULL default ''\n".
+");", array(null));
+sql_query($query,$SQLStat);
$query=sql_pre_query("CREATE TABLE \"".$_POST['tableprefix']."topics\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".
+" \"PollID\" INTEGER NOT NULL default '0',\n".
" \"ForumID\" INTEGER NOT NULL default '0',\n".
" \"CategoryID\" INTEGER NOT NULL default '0',\n".
" \"OldForumID\" INTEGER NOT NULL default '0',\n".
" \"Closed\" INTEGER NOT NULL default '0'\n".
");", 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 \"".$_POST['tableprefix']."wordfilter\" (\n".
" \"id\" INTEGER PRIMARY KEY NOT NULL,\n".