$db->Execute("INSERT INTO {$db->prefix}scheduler VALUES(NULL, 'Y', 0, {$sched_degrade}, 0, 'sched_degrade.php', NULL,unix_timestamp(now()))");
Table_Row("Sector Defences will degrade every {$sched_degrade} minutes.", "Failed", "Inserted");
$db->Execute("INSERT INTO {$db->prefix}scheduler VALUES(NULL, 'Y', 0, {$sched_apocalypse}, 0, 'sched_apocalypse.php', NULL,unix_timestamp(now()))");
Table_Row("The planetary apocalypse will occur every {$sched_apocalypse} minutes.", "Failed", "Inserted");
$db->Execute("INSERT INTO {$db->prefix}scheduler VALUES(NULL, 'Y', 0, {$sched_thegovernor}, 0, 'sched_thegovernor.php', NULL,unix_timestamp(now()))");
Table_Row("The Governor will run every {$sched_thegovernor} minutes.", "Failed", "Inserted");
$db->Execute("INSERT INTO {$db->prefix}scheduler VALUES(NULL, 'Y', 0, {$sched_empire}, 0, 'sched_empire.php', NULL,unix_timestamp(now()))");
Table_Row("Empire will be generated every {$sched_empire} minutes.", "Failed", "Inserted");
if ($bnt_ls === true) {
// $db->Execute("INSERT INTO {$db->prefix}scheduler VALUES(NULL, 'Y', 0, 60, 0, 'bnt_ls_client.php', NULL,unix_timestamp(now()))");
// Table_Row("The public list updater will occur every 60 minutes","Failed","Inserted");
$creating = 1;
// include "bnt_ls_client.php";
}
Table_Footer("Completed successfully");
Table_Header("Inserting Admins Acount Information");
$update = $db->Execute("INSERT INTO {$db->prefix}ibank_accounts (ship_id,balance,loan) VALUES (1,0,0)");
Table_Row("Inserting Admins ibank Information", "Failed", "Inserted");
$stamp = date("Y-m-d H:i:s");
$db->Execute("INSERT INTO {$db->prefix}ships VALUES(NULL,'Game Admin\\'s ship','N','Game Admin','{$adminpass}','{$admin_mail}',0,0,0,0,0,0,0,0,0,0,{$start_armor},0,{$start_credits},0,0,0,0,{$start_energy},0,{$start_fighters},0,{$start_turns},'N',0,1,0,0,'N','N',0,0, '{$stamp}','0000-00-00 00:00:00','0000-00-00 00:00:00',0,0,0,0,0,0,0,'1.1.1.1',0,0,0,0,0,0,'Y','N','N','Y',' ','{$default_lang}', 'N')");
Table_1Col("Admins login Information:<br>Username: '******'<br>Password: '******'");
Table_Row("Inserting Admins Ship Information", "Failed", "Inserted");
$db->Execute("INSERT INTO {$db->prefix}zones VALUES(NULL,'Game Admin\\'s Territory', 1, 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 'Y', 0)");
Table_Row("Inserting Admins Zone Information", "Failed", "Inserted");
Table_Footer("Completed successfully.");
PrintFlush("<br><br><center><br><strong>Congratulations! Universe created successfully.</strong><br>");
PrintFlush("<strong>Click <a href=index.php>here</A> to return to the login screen.</strong></center>");
include_once "footer.php";
break;
default:
echo "<form action=create_universe.php method=post>";
function create_schema()
{
global $maxlen_password;
global $db, $ADODB_SESSION_DB;
// Delete all tables in the database
Table_Header("Dropping Tables");
// Have SQL prepare a query for dropping tables that contains the list of all tables according to SQL.
$drop_tables_stmt = $db->Execute('SELECT CONCAT( "DROP TABLE ", GROUP_CONCAT(TABLE_NAME)) AS stmt FROM information_schema.TABLES WHERE TABLE_SCHEMA = "' . $ADODB_SESSION_DB . '" AND TABLE_NAME LIKE "' . $db->prefix . '%"');
// Use the query to now drop all tables as reported by SQL.
$drop_tables = $db->Execute($drop_tables_stmt->fields['stmt']);
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Dropping all tables", "Failed", "Passed");
Table_Footer("Hover over the failed line to see the error.");
echo "<strong>Dropping stage complete.</strong><p>";
// Create database schema
Table_Header("Creating Tables");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}languages (" . "lang_id smallint(5) NOT NULL AUTO_INCREMENT," . "language varchar(30) NOT NULL DEFAULT 'english'," . "name varchar(75) NOT NULL," . "value varchar(2000) NOT NULL," . "category char(30) NOT NULL," . "PRIMARY KEY (lang_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating languages Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}links (" . "link_id int unsigned NOT NULL auto_increment," . "link_start int unsigned DEFAULT '0' NOT NULL," . "link_dest int unsigned DEFAULT '0' NOT NULL," . "PRIMARY KEY (link_id)," . "KEY link_start (link_start)," . "KEY link_dest (link_dest)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating links Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}planets (" . "planet_id int unsigned NOT NULL auto_increment," . "sector_id int unsigned DEFAULT '0' NOT NULL," . "name tinytext," . "organics bigint(20) DEFAULT '0' NOT NULL," . "ore bigint(20) DEFAULT '0' NOT NULL," . "goods bigint(20) DEFAULT '0' NOT NULL," . "energy bigint(20) DEFAULT '0' NOT NULL," . "colonists bigint(20) DEFAULT '0' NOT NULL," . "credits bigint(20) DEFAULT '0' NOT NULL," . "fighters bigint(20) DEFAULT '0' NOT NULL," . "torps bigint(20) DEFAULT '0' NOT NULL," . "owner int unsigned DEFAULT '0' NOT NULL," . "corp int unsigned DEFAULT '0' NOT NULL," . "base enum('Y','N') DEFAULT 'N' NOT NULL," . "sells enum('Y','N') DEFAULT 'N' NOT NULL," . "prod_organics int DEFAULT '20.0' NOT NULL," . "prod_ore int DEFAULT '0' NOT NULL," . "prod_goods int DEFAULT '0' NOT NULL," . "prod_energy int DEFAULT '0' NOT NULL," . "prod_fighters int DEFAULT '0' NOT NULL," . "prod_torp int DEFAULT '0' NOT NULL," . "defeated enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_homeworld enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_shipyard enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_solarplant enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_research enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_military enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_medical enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_bank enum('Y','N') DEFAULT 'N' NOT NULL," . "facility_hydroponics enum('Y','N') DEFAULT 'N' NOT NULL," . "senator_id int DEFAULT '0' NOT NULL," . "PRIMARY KEY (planet_id)," . "KEY owner (owner)," . "KEY corp (corp)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating planets Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}traderoutes (" . "traderoute_id int unsigned NOT NULL auto_increment," . "source_id int unsigned DEFAULT '0' NOT NULL," . "dest_id int unsigned DEFAULT '0' NOT NULL," . "source_type enum('P','L','C','D') DEFAULT 'P' NOT NULL," . "dest_type enum('P','L','C','D') DEFAULT 'P' NOT NULL," . "move_type enum('R','W') DEFAULT 'W' NOT NULL," . "owner int unsigned DEFAULT '0' NOT NULL," . "circuit enum('1','2') DEFAULT '2' NOT NULL," . "PRIMARY KEY (traderoute_id)," . "KEY owner (owner)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating traderoutes Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}ships (" . "ship_id int unsigned NOT NULL auto_increment," . "ship_name char(20)," . "ship_destroyed enum('Y','N') DEFAULT 'N' NOT NULL," . "character_name char(20) NOT NULL," . "password char(60) NOT NULL," . "email char(60) NOT NULL," . "hull tinyint(3) unsigned DEFAULT '0' NOT NULL," . "engines tinyint(3) unsigned DEFAULT '0' NOT NULL," . "power tinyint(3) unsigned DEFAULT '0' NOT NULL," . "computer tinyint(3) unsigned DEFAULT '0' NOT NULL," . "sensors tinyint(3) unsigned DEFAULT '0' NOT NULL," . "beams tinyint(3) unsigned DEFAULT '0' NOT NULL," . "torp_launchers tinyint(3) DEFAULT '0' NOT NULL," . "torps bigint(20) DEFAULT '0' NOT NULL," . "shields tinyint(3) unsigned DEFAULT '0' NOT NULL," . "armor tinyint(3) unsigned DEFAULT '0' NOT NULL," . "armor_pts bigint(20) DEFAULT '0' NOT NULL," . "cloak tinyint(3) unsigned DEFAULT '0' NOT NULL," . "credits bigint(20) DEFAULT '0' NOT NULL," . "sector int unsigned DEFAULT '0' NOT NULL," . "ship_ore bigint(20) DEFAULT '0' NOT NULL," . "ship_organics bigint(20) DEFAULT '0' NOT NULL," . "ship_goods bigint(20) DEFAULT '0' NOT NULL," . "ship_energy bigint(20) DEFAULT '0' NOT NULL," . "ship_colonists bigint(20) DEFAULT '0' NOT NULL," . "ship_fighters bigint(20) DEFAULT '0' NOT NULL," . "ship_damage smallint(5) DEFAULT '0' NOT NULL," . "turns smallint(4) DEFAULT '0' NOT NULL," . "on_planet enum('Y','N') DEFAULT 'N' NOT NULL," . "dev_warpedit smallint(5) DEFAULT '0' NOT NULL," . "dev_genesis smallint(5) DEFAULT '0' NOT NULL," . "dev_beacon smallint(5) DEFAULT '0' NOT NULL," . "dev_emerwarp smallint(5) DEFAULT '0' NOT NULL," . "dev_escapepod enum('Y','N') DEFAULT 'N' NOT NULL," . "dev_fuelscoop enum('Y','N') DEFAULT 'N' NOT NULL," . "dev_minedeflector bigint(20) DEFAULT '0' NOT NULL," . "turns_used int unsigned DEFAULT '0' NOT NULL," . "last_login datetime," . "last_kami datetime," . "last_sofa datetime," . "ship_kills int DEFAULT '0' NOT NULL," . "ship_deaths int DEFAULT '0' NOT NULL," . "rating int DEFAULT '0' NOT NULL," . "score int DEFAULT '0' NOT NULL," . "points int DEFAULT '0' NOT NULL," . "team int DEFAULT '0' NOT NULL," . "team_invite int DEFAULT '0' NOT NULL," . "ip_address tinytext NOT NULL," . "planet_id int unsigned DEFAULT '0' NOT NULL," . "preset1 int DEFAULT '0' NOT NULL," . "preset2 int DEFAULT '0' NOT NULL," . "preset3 int DEFAULT '0' NOT NULL," . "preset4 int DEFAULT '0' NOT NULL," . "preset5 int DEFAULT '0' NOT NULL," . "trade_colonists enum('Y', 'N') DEFAULT 'Y' NOT NULL," . "trade_fighters enum('Y', 'N') DEFAULT 'N' NOT NULL," . "trade_torps enum('Y', 'N') DEFAULT 'N' NOT NULL," . "trade_energy enum('Y', 'N') DEFAULT 'Y' NOT NULL," . "cleared_defences tinytext," . "lang varchar(30) DEFAULT 'english.inc' NOT NULL," . "dev_lssd enum('Y','N') DEFAULT 'Y' NOT NULL," . "PRIMARY KEY (email)," . "KEY email (email)," . "KEY sector (sector)," . "KEY ship_destroyed (ship_destroyed)," . "KEY on_planet (on_planet)," . "KEY team (team)," . "KEY ship_id (ship_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating ships Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}account (" . "user_id int unsigned NOT NULL auto_increment," . "username char(200) NOT NULL," . "name char(200) NOT NULL," . "handle char(200) NOT NULL," . "active_ship int NOT NULL," . "location char(200) NOT NULL," . "gender tinytext NOT NULL," . "password char(200) NOT NULL," . "email char(200) NOT NULL," . "facebook_id char(200) NOT NULL," . "last_activity datetime," . "registration_date datetime," . "ip tinytext NOT NULL," . "empire_parts bigint(20) DEFAULT '0' NOT NULL," . "empire_research bigint(20) DEFAULT '0' NOT NULL," . "empire_food bigint(20) DEFAULT '0' NOT NULL," . "empire_energy bigint(20) DEFAULT '0' NOT NULL," . "empire_ores bigint(20) DEFAULT '0' NOT NULL," . "PRIMARY KEY (username)," . "KEY handle (handle)," . "KEY username (username)," . "KEY user_id (user_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating User Account Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}universe (" . "sector_id int unsigned NOT NULL auto_increment," . "sector_name tinytext," . "zone_id int DEFAULT '0' NOT NULL," . "port_type enum('ore','organics','goods','energy','special','none') DEFAULT 'none' NOT NULL," . "port_organics bigint(20) DEFAULT '0' NOT NULL," . "port_ore bigint(20) DEFAULT '0' NOT NULL," . "port_goods bigint(20) DEFAULT '0' NOT NULL," . "port_energy bigint(20) DEFAULT '0' NOT NULL," . "KEY zone_id (zone_id)," . "KEY port_type (port_type)," . "beacon tinytext," . "angle1 float(10,2) DEFAULT '0.00' NOT NULL," . "angle2 float(10,2) DEFAULT '0.00' NOT NULL," . "distance bigint(20) unsigned DEFAULT '0' NOT NULL," . "fighters bigint(20) DEFAULT '0' NOT NULL," . "PRIMARY KEY (sector_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating universe Table", "Failed", "Passed");
$db->execute("CREATE TABLE IF NOT EXISTS {$db->prefix}zones (" . "zone_id int unsigned NOT NULL auto_increment," . "zone_name tinytext," . "owner int unsigned DEFAULT '0' NOT NULL," . "corp_zone enum('Y', 'N') DEFAULT 'N' NOT NULL," . "allow_beacon enum('Y','N','L') DEFAULT 'Y' NOT NULL," . "allow_attack enum('Y','N') DEFAULT 'Y' NOT NULL," . "allow_planetattack enum('Y','N') DEFAULT 'Y' NOT NULL," . "allow_warpedit enum('Y','N','L') DEFAULT 'Y' NOT NULL," . "allow_planet enum('Y','L','N') DEFAULT 'Y' NOT NULL," . "allow_trade enum('Y','L','N') DEFAULT 'Y' NOT NULL," . "allow_defenses enum('Y','L','N') DEFAULT 'Y' NOT NULL," . "max_hull int DEFAULT '0' NOT NULL," . "PRIMARY KEY(zone_id)," . "KEY zone_id(zone_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating zones Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}ibank_accounts (" . "ship_id int DEFAULT '0' NOT NULL," . "balance bigint(20) DEFAULT '0'," . "loan bigint(20) DEFAULT '0'," . "loantime datetime," . "PRIMARY KEY(ship_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating ibank_accounts Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}IGB_transfers (" . "transfer_id int NOT NULL auto_increment," . "source_id int DEFAULT '0' NOT NULL," . "dest_id int DEFAULT '0' NOT NULL," . "time datetime," . "amount bigint(20) DEFAULT '0' NOT NULL," . "PRIMARY KEY(transfer_id)," . "KEY amount (amount)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating IGB_transfers Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}teams (" . "id int DEFAULT '0' NOT NULL," . "creator int DEFAULT '0'," . "team_name tinytext," . "description tinytext," . "number_of_members tinyint(3) DEFAULT '0' NOT NULL," . "admin enum('Y','N') NOT NULL default 'N'," . "PRIMARY KEY(id)," . "KEY admin (admin)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating teams Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}news (" . "news_id int(11) NOT NULL auto_increment," . "headline varchar(100) NOT NULL," . "newstext text NOT NULL," . "user_id int(11)," . "date datetime," . "news_type varchar(10)," . "PRIMARY KEY (news_id)," . "KEY news_id (news_id)," . "UNIQUE news_id_2 (news_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating news Table", "Failed", "Passed");
$db->Execute("INSERT INTO {$db->prefix}news (headline, newstext, date, news_type) " . "VALUES ('Big Bang!','Scientists have just discovered the Universe exists!',NOW(), 'col25')");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Inserting first news item", "Failed", "Inserted");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}messages (" . "ID int NOT NULL auto_increment," . "sender_id int NOT NULL default '0'," . "recp_id int NOT NULL default '0'," . "subject varchar(250) NOT NULL default ''," . "sent varchar(19) NULL," . "message longtext NOT NULL," . "notified enum('Y','N') NOT NULL default 'N'," . "PRIMARY KEY (ID) " . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating messages Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}xenobe (" . "xenobe_id char(40) NOT NULL," . "active enum('Y','N') DEFAULT 'Y' NOT NULL," . "aggression smallint(5) DEFAULT '0' NOT NULL," . "orders smallint(5) DEFAULT '0' NOT NULL," . "PRIMARY KEY (xenobe_id)," . "KEY xenobe_id (xenobe_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating xenobe Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}sector_defence (" . "defence_id int unsigned NOT NULL auto_increment," . "ship_id int DEFAULT '0' NOT NULL," . "sector_id int unsigned DEFAULT '0' NOT NULL," . "defence_type enum('M','F') DEFAULT 'M' NOT NULL," . "quantity bigint(20) DEFAULT '0' NOT NULL," . "fm_setting enum('attack','toll') DEFAULT 'toll' NOT NULL," . "PRIMARY KEY (defence_id)," . "KEY sector_id (sector_id)," . "KEY ship_id (ship_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating sector_defence Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}scheduler (" . "sched_id int unsigned NOT NULL auto_increment," . "repeate enum('Y','N') DEFAULT 'N' NOT NULL," . "ticks_left int unsigned DEFAULT '0' NOT NULL," . "ticks_full int unsigned DEFAULT '0' NOT NULL," . "spawn int unsigned DEFAULT '0' NOT NULL," . "sched_file varchar(30) NOT NULL," . "extra_info varchar(50)," . "last_run BIGINT(20)," . "PRIMARY KEY (sched_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
echo $db->ErrorMsg();
Table_Row("Creating scheduler Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}ip_bans (" . "ban_id int unsigned NOT NULL auto_increment," . "ban_mask varchar(16) NOT NULL," . "PRIMARY KEY (ban_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating ip_bans Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}logs (" . "log_id int unsigned NOT NULL auto_increment," . "ship_id int DEFAULT '0' NOT NULL," . "type mediumint(5) DEFAULT '0' NOT NULL," . "time datetime," . "data varchar(255)," . "PRIMARY KEY (log_id)," . "KEY idate (ship_id,time)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating logs Table", "Failed", "Passed");
/*new*/
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}player_logs (" . "log_id int unsigned NOT NULL auto_increment," . "ship_id int DEFAULT '0' NOT NULL," . "type mediumint(5) DEFAULT '0' NOT NULL," . "priority varchar(50)," . "title varchar(255)," . "time datetime," . "data text," . "user_agent varchar(255)," . "user_host varchar(255)," . "user_ip varchar(255)," . "PRIMARY KEY (log_id)," . "KEY idate (ship_id,time)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating New Player logs Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}security_logs (" . "log_id int unsigned NOT NULL auto_increment," . "ship_id int DEFAULT '0' NOT NULL," . "type mediumint(5) DEFAULT '0' NOT NULL," . "time datetime," . "data text," . "user_agent varchar(255)," . "user_host varchar(255)," . "user_ip varchar(255)," . "PRIMARY KEY (log_id)," . "KEY idate (ship_id,time)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating New Player logs Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}bounty (" . "bounty_id int unsigned NOT NULL auto_increment," . "amount bigint(20) unsigned DEFAULT '0' NOT NULL," . "bounty_on int unsigned DEFAULT '0' NOT NULL," . "placed_by int unsigned DEFAULT '0' NOT NULL," . "PRIMARY KEY (bounty_id)," . "KEY bounty_on (bounty_on)," . "KEY placed_by (placed_by)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating session Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}sessions (" . "SESSKEY varchar(32) DEFAULT '' NOT NULL," . "EXPIRY int(11) default '0' NOT NULL," . "EXPIREREF varchar(64)," . "SESSDATA longblob default '' NOT NULL," . "PRIMARY KEY (EXPIRY)," . "KEY SESSKEY(SESSKEY)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating bounty Table", "Failed", "Passed");
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}movement_log (" . "event_id int unsigned NOT NULL auto_increment," . "ship_id int DEFAULT '0' NOT NULL," . "sector_id int DEFAULT '0'," . "time datetime ," . "PRIMARY KEY (event_id)," . "KEY ship_id(ship_id)," . "KEY sector_id (sector_id)" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
$db->Execute("CREATE TABLE IF NOT EXISTS {$db->prefix}adodb_logsql (" . "created datetime NOT NULL," . "sql0 varchar(250) NOT NULL," . "sql1 text NOT NULL," . "params text NOT NULL," . "tracer text NOT NULL," . "timer decimal(16,6) NOT NULL" . ")");
$err = TRUEFALSE(0, $db->ErrorMsg(), "No errors found", $db->ErrorNo() . ": " . $db->ErrorMsg());
Table_Row("Creating adodb_logsql Table", "Failed", "Passed");
Table_Footer("Hover over the failed row to see the error.");
// Finished
echo "<strong>Database schema creation completed successfully.</strong><BR>";
}