function update014()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "014") {
if (is_null(config::get('014updatestatus'))) {
config::set('014updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('014updatestatus') < 1) {
// Add killmail summary. time, hash, trust.
$sql = 'CREATE TABLE IF NOT EXISTS `kb3_mails` (
`kll_id` int(11) NOT NULL auto_increment,
`kll_timestamp` datetime NOT NULL default "0000-00-00 00:00:00",
`kll_external_id` int(8) default NULL,
`kll_hash` BINARY(16) NOT NULL,
`kll_trust` TINYINT NOT NULL DEFAULT 0,
PRIMARY KEY (`kll_id`),
UNIQUE KEY `external_id` (`kll_external_id`),
UNIQUE KEY `time_hash` (`kll_timestamp`,`kll_hash`)
) Engine=InnoDB';
$qry->execute($sql);
}
killCache();
config::set("DBUpdate", "014");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '014' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '014'");
config::del("014updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 014 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update034()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "034") {
if (is_null(config::get('034updatestatus'))) {
config::set('034updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('034updatestatus') < 1) {
$qry->execute("SHOW COLUMNS FROM kb3_invtypes LIKE 'radius'");
if ($qry->recordCount()) {
$sql = "ALTER TABLE `kb3_invtypes` DROP COLUMN `radius` ";
$qry->execute($sql);
}
}
config::set("DBUpdate", "034");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '034' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '034'");
config::del("034updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 034 completed.");
$smarty->display('update.tpl');
die;
}
}
function update022()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "022") {
if (is_null(config::get('022updatestatus'))) {
config::set('022updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('022updatestatus') < 1) {
$qry->execute("DELETE FROM `kb3_ships` WHERE `shp_externalid` = 0 AND `shp_name` NOT LIKE '%Unknown%'");
$qry->execute("DELETE FROM `kb3_ships` WHERE `shp_id` IN (206, 497, 348, 349,352, 354, 606)");
config::set('022updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "22. Delete unused and duplicated ships from ships table.");
$smarty->display('update.tpl');
die;
}
if (config::get('022updatestatus') < 2) {
// Add timestamp column to kb3_inv_detail
$qry->execute("SHOW INDEX FROM `kb3_ships`");
$indextexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'shp_externalid') {
$indextexists = true;
}
}
if (!$indextexists) {
$qry->execute("ALTER TABLE `kb3_ships` ADD UNIQUE `shp_externalid` ( `shp_externalid` ) ");
config::set('022updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "22. Ships table added unique index for external IDs.");
$smarty->display('update.tpl');
die;
}
}
if (config::get('022updatestatus') < 3) {
//not too happy about this one but it does force the ships to use *my* IDs, as it would be if i dumped it - FRK
$qry->execute("INSERT IGNORE INTO `kb3_ships` (`shp_id` ,`shp_name` ,`shp_class` ,`shp_externalid` ,`shp_rce_id` ,`shp_baseprice` ,`shp_techlevel` ,`shp_isfaction`) VALUES (704 , 'Guristas Shuttle', '11', '21628', '1', '10000000', '1', '1');");
$qry->execute("INSERT IGNORE INTO `kb3_ships` (`shp_id` ,`shp_name` ,`shp_class` ,`shp_externalid` ,`shp_rce_id` ,`shp_baseprice` ,`shp_techlevel` ,`shp_isfaction`) VALUES (705 , 'Civilian Gallente Shuttle', '11', '27303', '8', '0', '1', '0');");
config::set('022updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "22. Insert missing shuttles.");
$smarty->display('update.tpl');
die;
}
killCache();
config::set("DBUpdate", "022");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '022' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '022'");
config::del("022updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 022 completed.");
$smarty->display('update.tpl');
die;
}
}
function update021()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "021") {
$qry = DBFactory::getDBQuery(true);
if (is_null(config::get('021updatestatus'))) {
config::set('021updatestatus', 0);
}
if (config::get('021updatestatus') < 1) {
// Add timestamp column to kb3_inv_detail
$qry->execute("SHOW COLUMNS FROM kb3_ships LIKE 'shp_isfaction'");
if (!$qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_ships` ADD `shp_isfaction` TINYINT(1) DEFAULT '0' AFTER `shp_techlevel`;");
config::set('021updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "21. kb3_ships shp_isfaction column added");
$smarty->display('update.tpl');
die;
}
}
if (config::get('021updatestatus') < 3) {
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 3628;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17715;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17718;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17720;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17722;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17736;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17738;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17740;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17918;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17920;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17922;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17924;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17926;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17928;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17930;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 17932;");
$qry->execute("UPDATE kb3_ships SET shp_isfaction = '1' WHERE shp_externalid = 32207;");
config::set('021updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "21. faction tags added");
$smarty->display('update.tpl');
die;
}
killCache();
config::set("DBUpdate", "021");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '021' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '021'");
config::del("021updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 021 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update039()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "039") {
if (is_null(config::get('039updatestatus'))) {
config::set('039updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('039updatestatus') < 1) {
$qry->execute("UPDATE kb3_inv_detail SET ind_shp_id = 11194 WHERE ind_shp_id = 206");
// Kitsune
$qry->execute("UPDATE kb3_inv_detail SET ind_shp_id = 22428 WHERE ind_shp_id = 348");
// Redeemer
$qry->execute("UPDATE kb3_inv_detail SET ind_shp_id = 22430 WHERE ind_shp_id = 349");
// Sin
$qry->execute("UPDATE kb3_inv_detail SET ind_shp_id = 22436 WHERE ind_shp_id = 352");
// Widow
$qry->execute("UPDATE kb3_inv_detail SET ind_shp_id = 22440 WHERE ind_shp_id = 354");
// Panther
config::set('039updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "39. Update kb3_inv_detail.");
$smarty->display('update.tpl');
die;
}
if (config::get('039updatestatus') < 2) {
$qry->execute("UPDATE kb3_kills SET kll_ship_id = 11194 WHERE kll_ship_id = 206");
// Kitsune
$qry->execute("UPDATE kb3_kills SET kll_ship_id = 22428 WHERE kll_ship_id = 348");
// Redeemer
$qry->execute("UPDATE kb3_kills SET kll_ship_id = 22430 WHERE kll_ship_id = 349");
// Sin
$qry->execute("UPDATE kb3_kills SET kll_ship_id = 22436 WHERE kll_ship_id = 352");
// Widow
$qry->execute("UPDATE kb3_kills SET kll_ship_id = 22440 WHERE kll_ship_id = 354");
// Panther
config::set('039updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "39. Update kb3_kills.");
$smarty->display('update.tpl');
die;
}
killCache();
config::set("DBUpdate", "039");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '039' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '039'");
config::del("039updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 039 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update042()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "042") {
if (is_null(config::get('042updatestatus'))) {
config::set('042updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('042updatestatus') < 1) {
$qry->execute("ALTER TABLE kb3_alliances ADD COLUMN all_active TINYINT(1) NOT NULL DEFAULT 1 AFTER all_start_date");
$qry->execute("ALTER TABLE kb3_alliances DROP INDEX all_name");
$qry->execute("ALTER TABLE kb3_alliances ADD UNIQUE all_name_active ( all_name, all_active )");
config::set('042updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "42. Add Active column to alliances.");
$smarty->display('update.tpl');
die;
}
if (config::get('042updatestatus') < 2) {
$qry->execute("ALTER TABLE kb3_corps ADD COLUMN crp_active TINYINT(1) NOT NULL DEFAULT 1 AFTER crp_startdate");
$qry->execute("ALTER TABLE kb3_corps DROP INDEX crp_name");
$qry->execute("ALTER TABLE kb3_corps ADD UNIQUE crp_name_active ( crp_name, crp_active )");
config::set('042updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "42. Add Active column to corps.");
$smarty->display('update.tpl');
die;
}
if (config::get('042updatestatus') < 3) {
$qry->execute("ALTER TABLE kb3_pilots ADD COLUMN plt_active TINYINT(1) NOT NULL DEFAULT 1 AFTER plt_lpoints");
$qry->execute("ALTER TABLE kb3_pilots DROP INDEX plt_name");
$qry->execute("ALTER TABLE kb3_pilots ADD UNIQUE plt_name_active ( plt_name, plt_active )");
config::set('042updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "42. Add Active column to pilots.");
$smarty->display('update.tpl');
die;
}
config::set("DBUpdate", "042");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '042' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '042'");
config::del("042updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 042 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update029()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "029") {
$qry = DBFactory::getDBQuery(true);
$qry2 = DBFactory::getDBQuery(true);
$newrows = array();
$sql = 'SELECT cfg_site FROM kb3_config GROUP BY cfg_site';
$qry->execute($sql);
while ($row = $qry->getRow()) {
$qry2->execute("SELECT cfg_value FROM kb3_config WHERE cfg_site = '" . $row['cfg_site'] . "' AND cfg_key = 'cfg_pilotid'");
if ($row2 = $qry2->getRow()) {
if (is_null($row2['cfg_value']) || is_numeric($row2['cfg_value'])) {
$newrows[] = '"' . $row['cfg_site'] . '", "cfg_pilotid", "' . serialize(array((int) $row['cfg_value'])) . '"';
}
} else {
$newrows[] = '"' . $row['cfg_site'] . '", "cfg_pilotid", "' . serialize(array()) . '"';
}
$qry2->execute("SELECT cfg_value FROM kb3_config WHERE cfg_site = '" . $row['cfg_site'] . "' AND cfg_key = 'cfg_corpid'");
if ($row2 = $qry2->getRow()) {
if (is_null($row2['cfg_value']) || is_numeric($row2['cfg_value'])) {
$newrows[] = '"' . $row['cfg_site'] . '", "cfg_corpid", "' . serialize(array((int) $row['cfg_value'])) . '"';
}
} else {
$newrows[] = '"' . $row['cfg_site'] . '", "cfg_corpid", "' . serialize(array()) . '"';
}
$qry2->execute("SELECT cfg_value FROM kb3_config WHERE cfg_site = '" . $row['cfg_site'] . "' AND cfg_key = 'cfg_allianceid'");
if ($row2 = $qry2->getRow()) {
if (is_null($row2['cfg_value']) || is_numeric($row2['cfg_value'])) {
$newrows[] = '"' . $row['cfg_site'] . '", "cfg_allianceid", "' . serialize(array((int) $row['cfg_value'])) . '"';
}
} else {
$newrows[] = '"' . $row['cfg_site'] . '", "cfg_allianceid", "' . serialize(array()) . '"';
}
}
if ($newrows) {
$qry->execute('REPLACE INTO kb3_config (cfg_site, cfg_key, cfg_value) VALUES' . '(' . join('), (', $newrows) . ')');
}
config::set("DBUpdate", "029");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '029' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '029'");
config::del("029updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 029 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update030()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "030") {
$qry = DBFactory::getDBQuery(true);
$newrows = array();
$sql = 'ALTER TABLE kb3_eveunits MODIFY COLUMN displayName CHAR(25) DEFAULT NULL';
$qry->execute($sql);
config::set("DBUpdate", "030");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '030' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '030'");
config::del("030updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 030 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update038()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "038") {
$qry = DBFactory::getDBQuery(true);
$sql = 'ALTER TABLE `kb3_dgmtypeattributes` CHANGE `typeID` `typeID` INT( 11 ) NOT NULL DEFAULT \'0\';';
$qry->execute($sql);
$qry->execute("SHOW COLUMNS FROM kb3_moons LIKE 'moo_id'");
if (!$qry->recordCount()) {
$sql = 'ALTER TABLE `kb3_moons` CHANGE `itemID` `moo_id` INT( 11 ) NOT NULL ,
CHANGE `itemName` `moo_name` VARCHAR( 127 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL;';
$qry->execute($sql);
}
config::set("DBUpdate", "038");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '038' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '038'");
config::del("038updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 038 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update036()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "036") {
$qry = DBFactory::getDBQuery(true);
$sql = 'CREATE TABLE IF NOT EXISTS `kb3_stations` (
`sta_id` int(10) NOT NULL,
`sta_sys_id` int(10) NOT NULL,
`sta_con_id` int(10) NOT NULL,
`sta_reg_id` int(10) NOT NULL,
`sta_name` varchar(100) NOT NULL
) Engine=MyISAM DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;';
$qry->execute($sql);
config::set("DBUpdate", "036");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '036' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '036'");
config::del("036updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 036 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update041()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "041") {
if (is_null(config::get('041updatestatus'))) {
config::set('041updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('041updatestatus') < 1) {
$qry->execute("ALTER TABLE kb3_kills ADD COLUMN kll_td_plt_id INT(3) NULL DEFAULT NULL\r\t\t\t\tAFTER kll_fb_plt_id");
$qry->execute("delete from kb3_config where cfg_key in ('style_name','kd_showbox')");
config::set('041updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "41. Update kb3_kills.");
$smarty->display('update.tpl');
die;
}
if (config::get('041updatestatus') < 2) {
//set top damage party, don't rely on ind_order = 0
$qry->execute("update kb3_kills\n\t\t\t\tjoin (select ind_kll_id, ind_plt_id from kb3_inv_detail\n\t\t\t\t\tgroup by ind_kll_id\n\t\t\t\t\torder by ind_dmgdone desc\n\t\t\t\t) as inv\n\t\t\t\ton kb3_kills.kll_id = inv.ind_kll_id\n\t\t\t\tset kll_td_plt_id = inv.ind_plt_id");
config::set('041updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "41. Record Final Blow party in kb3_kills.");
$smarty->display('update.tpl');
die;
}
//killCache();
config::set("DBUpdate", "041");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '041' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '041'");
config::del("041updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 041 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update028()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "028") {
$qry = DBFactory::getDBQuery(true);
// create table
$sql = 'CREATE TABLE IF NOT EXISTS `kb3_moons` (
`itemID` int(11) NOT NULL,
`itemName` varchar(127) NOT NULL,
PRIMARY KEY (`itemID`),
KEY `itemName` (`itemName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;';
$qry->execute($sql);
config::set("DBUpdate", "028");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '028' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '028'");
config::del("028updatestatus");
$smarty->assign('url', '?package=CCPDB');
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 028 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update031()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "031") {
if (is_null(config::get('031updatestatus'))) {
config::set('031updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('031updatestatus') < 1) {
// create table
$sql = 'CREATE TABLE IF NOT EXISTS kb3_feeds (
feed_id INT(11) AUTO_INCREMENT NOT NULL,
feed_url text NOT NULL,
feed_lastkill INT(11) NOT NULL,
feed_updated datetime DEFAULT "0000-00-00 00:00:00",
feed_kbsite VARCHAR( 16 ) NOT NULL,
feed_flags TINYINT NOT NULL,
PRIMARY KEY (feed_id))';
$qry->execute($sql);
// get a list of keys for each site to migrate
$sql = "SELECT * FROM kb3_config where cfg_key = 'fetch_idfeeds'";
$qry->execute($sql);
$qry2 = DBFactory::getDBQuery(true);
while ($ret = $qry->getRow()) {
$feed_kbsite = $ret['cfg_site'];
$feeddata = unserialize($ret['cfg_value']);
foreach ($feeddata as $feed) {
$feedurl = $qry2->escape($feed['url']);
$lastkill = (int) $feed['lastkill'];
$trusted = (int) $feed['trusted'];
if (trim($feedurl) == '') {
// empty feed - skip
continue;
}
$feed_flags = FEED_ACTIVE;
if ($trusted) {
$feed_flags |= FEED_TRUSTED;
}
$qry2->execute("SELECT feed_id, feed_lastkill, feed_flags FROM kb3_feeds WHERE feed_url = '{$feedurl}' AND feed_kbsite = '{$feed_kbsite}'");
if ($qry2->recordCount()) {
// OK url already in DB - probably best thing to do is force a full fetch i.e. lastkill = 0:
// We don't know at this point what the end-users intention
$sql = "UPDATE kb3_feeds SET feed_lastkill=0 WHERE feed_url = '{$feedurl}' AND feed_kbsite='{$feed_kbsite}' )";
$qry2->execute($sql);
} else {
$sql = "INSERT INTO kb3_feeds( feed_url, feed_lastkill, feed_kbsite, feed_flags ) VALUES ( '{$feedurl}', {$lastkill}, '{$feed_kbsite}', '{$feed_flags}' )";
$qry2->execute($sql);
}
}
// remove legacy config items
$sql = "DELETE FROM kb3_config where cfg_site = '{$feed_kbsite}' AND ( cfg_key = 'fetch_idfeeds' )";
$qry2->execute($sql);
}
}
config::set("DBUpdate", "031");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '031' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '031'");
config::del("031updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 031 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update035()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "035") {
if (is_null(config::get('035updatestatus'))) {
config::set('035updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
//update item types [in case user does not refresh ccpdb]
if (config::get('035updatestatus') < 1) {
//check for user changes from SMA thread
$sql = "SELECT * from kb3_items_destroyed WHERE itd_itl_id NOT IN (0,1,2,3,4,5,6,7,8,9,87,89,90,116,117,118,119,120,121,133,134,135,136,137,138,139,140,141,142,143,148,149,150,151,154,155)";
$qry->execute("{$sql} LIMIT 1");
if ($qry->recordCount()) {
$smarty->assign('content', "Destroyed items table already has items in custom locations. Update these location IDs as appropriate before continuing (use CCP flags).<br /><br />\n\t\t\t\t\tUse this query in your database to find the offending records:<br /><br />{$sql}");
$smarty->display('update.tpl');
die;
}
$sql = preg_replace('/kb3_items_destroyed/', 'kb3_items_dropped', $sql);
$qry->execute("{$sql} LIMIT 1");
if ($qry->recordCount()) {
$smarty->assign('content', "Dropped items table already has items in custom locations. Update these location IDs as appropriate before continuing (use CCP flags).<br /><br />\n\t\t\t\t\tUse this query in your database to find the offending records:<br /><br />{$sql}");
$smarty->display('update.tpl');
die;
}
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '92' WHERE `itt_slot` = 5");
config::set('035updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (1 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 2) {
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '27' WHERE `itt_slot` = 1");
config::set('035updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (2 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 3) {
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '19' WHERE `itt_slot` = 2");
config::set('035updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (3 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 4) {
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '11' WHERE `itt_slot` = 3");
config::set('035updatestatus', 4);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (4 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 5) {
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '5' WHERE `itt_slot` = 4");
config::set('035updatestatus', 5);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (5 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 6) {
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '87' WHERE `itt_slot` = 6");
config::set('035updatestatus', 6);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (6 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 7) {
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '89' WHERE `itt_slot` = 8");
config::set('035updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (7 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 8) {
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '125' WHERE `itt_slot` = 7");
config::set('035updatestatus', 8);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (8 of 35)");
$smarty->display('update.tpl');
die;
}
// kb3_item_locations
if (config::get('035updatestatus') < 9) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '92' WHERE `itl_id` = 5");
config::set('035updatestatus', 9);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (9 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 10) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '27' WHERE `itl_id` = 1");
config::set('035updatestatus', 10);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (10 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 11) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '19' WHERE `itl_id` = 2");
config::set('035updatestatus', 11);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (11 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 12) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '11' WHERE `itl_id` = 3");
config::set('035updatestatus', 12);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (12 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 13) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '5' WHERE `itl_id` = 4");
config::set('035updatestatus', 13);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (13 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 14) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '87' WHERE `itl_id` = 6");
config::set('035updatestatus', 14);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (14 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 15) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '89' WHERE `itl_id` = 8");
config::set('035updatestatus', 15);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (15 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 16) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '125' WHERE `itl_id` = 7");
config::set('035updatestatus', 16);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (16 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 17) {
$qry->execute("UPDATE `kb3_item_locations` SET `itl_id` = '-1' WHERE `itl_id` = 9");
config::set('035updatestatus', 17);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (17 of 35)");
$smarty->display('update.tpl');
die;
}
// destroyed items
if (config::get('035updatestatus') < 18) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '92' WHERE `itd_itl_id` = 5");
config::set('035updatestatus', 18);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (18 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 19) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '27' WHERE `itd_itl_id` = 1");
config::set('035updatestatus', 19);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (19 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 20) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '19' WHERE `itd_itl_id` = 2");
config::set('035updatestatus', 20);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (20 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 21) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '11' WHERE `itd_itl_id` = 3");
config::set('035updatestatus', 21);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (21 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 22) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '5' WHERE `itd_itl_id` = 4");
config::set('035updatestatus', 22);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (22 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 23) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '87' WHERE `itd_itl_id` = 6");
config::set('035updatestatus', 23);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (23 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 24) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '89' WHERE `itd_itl_id` = 8");
config::set('035updatestatus', 24);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (24 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 25) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '125' WHERE `itd_itl_id` = 7");
config::set('035updatestatus', 25);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (25 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 26) {
$qry->execute("UPDATE `kb3_items_destroyed` SET `itd_itl_id` = '-1' WHERE `itd_itl_id` = 9");
config::set('035updatestatus', 26);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (26 of 35)");
$smarty->display('update.tpl');
die;
}
// dropped items
if (config::get('035updatestatus') < 27) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '92' WHERE `itd_itl_id` = 5");
config::set('035updatestatus', 27);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (27 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 28) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '27' WHERE `itd_itl_id` = 1");
config::set('035updatestatus', 28);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (28 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 29) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '19' WHERE `itd_itl_id` = 2");
config::set('035updatestatus', 29);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (29 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 30) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '11' WHERE `itd_itl_id` = 3");
config::set('035updatestatus', 30);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (30 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 31) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '5' WHERE `itd_itl_id` = 4");
config::set('035updatestatus', 31);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (31 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 32) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '87' WHERE `itd_itl_id` = 6");
config::set('035updatestatus', 32);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (32 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 33) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '89' WHERE `itd_itl_id` = 8");
config::set('035updatestatus', 33);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (33 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 34) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '125' WHERE `itd_itl_id` = 7");
config::set('035updatestatus', 34);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (34 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 35) {
$qry->execute("UPDATE `kb3_items_dropped` SET `itd_itl_id` = '-1' WHERE `itd_itl_id` = 9");
config::set('035updatestatus', 35);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Update (35 of 35)");
$smarty->display('update.tpl');
die;
}
if (config::get('035updatestatus') < 36) {
$qry->execute("SELECT max(kll_id) as max FROM kb3_kills");
$ret = $qry->getRow();
$maxid = $qry->escape($ret['max']);
config::set('035killid', $maxid);
config::set('035updatestatus', 36);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Setting Max Kill ID before conversion");
$smarty->display('update.tpl');
die;
}
config::set("DBUpdate", "035");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '035' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '035'");
config::del("035updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 035 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update033()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "033") {
if (is_null(config::get('033updatestatus'))) {
config::set('033updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('033updatestatus') < 1) {
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_short_name'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_short_name` CHAR(5) NULL ";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_ceo_id'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_ceo_id` INT(11) UNSIGNED NULL ";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_station_id'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_station_id` INT(11) UNSIGNED NULL ";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_description'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_description` TEXT";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_url'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_url` VARCHAR(255)";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_taxrate'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_taxrate` SMALLINT";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_membercount'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_membercount` INT(11) UNSIGNED NULL";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_shares'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_shares` INT(11) UNSIGNED NULL";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_startdate'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` ADD `crp_startdate` DATETIME NULL";
$qry->execute($sql);
}
}
config::set("DBUpdate", "033");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '033' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '033'");
config::del("033updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 033 completed.");
$smarty->display('update.tpl');
die;
}
}
function update012()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "012") {
if (is_null(config::get('012updatestatus'))) {
config::set('012updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('012updatestatus') < 1) {
// Add timestamp column to kb3_inv_detail
$qry->execute("SHOW COLUMNS FROM kb3_inv_detail LIKE 'ind_timestamp'");
if (!$qry->recordCount()) {
$qry->execute("ALTER TABLE kb3_inv_detail ADD ind_timestamp\r\n\t\t\t\t\tDATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' AFTER ind_kll_id");
config::set('012updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_detail timestamp column added");
$smarty->display('update.tpl');
die;
}
}
if (config::get('012updatestatus') < 2) {
// Add timestamp column to kb3_inv_detail
$qry->execute("SHOW INDEX FROM kb3_inv_detail");
$indextexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'ind_timestamp') {
$indextexists = true;
}
}
if (!$indextexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ( `ind_timestamp` ) ");
config::set('012updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_detail timestamp index added");
$smarty->display('update.tpl');
die;
}
}
if (config::get('012updatestatus') < 3) {
// Add pilot,timestamp index to kb3_inv_detail
$qry->execute("SHOW INDEX FROM kb3_inv_detail");
$indexpexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Key_name'] == 'ind_plt_time') {
$indexpexists = true;
}
}
if (!$indexpexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ind_plt_time ( `ind_plt_id`,`ind_timestamp` ) ");
config::set('012updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_detail pilot index added");
$smarty->display('update.tpl');
die;
}
}
if (config::get('012updatestatus') < 4) {
$qry->execute("SHOW TABLES LIKE 'kb3_inv_all'");
if ($qry->recordCount()) {
$qry->execute("DROP TABLE kb3_inv_all");
}
$qry->execute("SHOW TABLES LIKE 'kb3_inv_crp'");
if ($qry->recordCount()) {
$qry->execute("DROP TABLE kb3_inv_crp");
}
$qry->execute("SHOW TABLES LIKE 'kb3_inv_plt'");
if ($qry->recordCount()) {
$qry->execute("DROP TABLE kb3_inv_plt");
}
// kb3_inv_all (kll_id, all_id, timestamp)
$sql = "CREATE TABLE IF NOT EXISTS `kb3_inv_all` (\r\n\t\t\t\t `ina_kll_id` int(6) NOT NULL DEFAULT '0',\r\n\t\t\t\t `ina_all_id` int(3) NOT NULL DEFAULT '0',\r\n\t\t\t\t `ina_timestamp` datetime NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`ina_kll_id`,`ina_all_id`),\r\n\t\t\t\t KEY `ina_all_time` (`ina_all_id`,`ina_timestamp`)\r\n\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8";
$qry->execute($sql);
// kb3_inv_crp (kll_id, crp_id, timestamp)
$sql = "CREATE TABLE IF NOT EXISTS `kb3_inv_crp` (\r\n\t\t\t\t `inc_kll_id` int(6) NOT NULL DEFAULT '0',\r\n\t\t\t\t `inc_crp_id` int(3) NOT NULL DEFAULT '0',\r\n\t\t\t\t `inc_timestamp` datetime NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`inc_kll_id`,`inc_crp_id`),\r\n\t\t\t\t KEY `inc_crp_time` (`inc_crp_id`,`inc_timestamp`)\r\n\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8";
$qry->execute($sql);
config::set('012updatestatus', 4);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_all and kb3_inv_crp created.");
$smarty->display('update.tpl');
die;
}
if (config::get('012updatestatus') < 5) {
$step = 10000;
//$qry->execute("SELECT MAX(kll_id) as cnt FROM kb3_kills");
//$result = $qry->getRow();
//$max = $result['cnt'];
if (!config::get('012_5_status')) {
config::set('012_5_status', '0');
}
// add times to kb3_inv_detail.
$qry->execute("UPDATE kb3_inv_detail join kb3_kills on ind_kll_id = kll_id\r\n\t\t\t\tSET ind_timestamp = kll_timestamp\r\n\t\t\t\tWHERE ind_timestamp < '0001-01-01'\r\n\t\t\t\tAND kll_id >= " . config::get('012_5_status') . "\r\n\t\t\t\tAND kll_id < " . (config::get('012_5_status') + $step));
$qry->execute("SELECT MIN(kll_id) as next FROM kb3_kills WHERE kll_id >= " . (config::get('012_5_status') + $step));
$row = $qry->getRow();
if (!isset($row['next']) || $row['next'] == null) {
config::set('012updatestatus', 5);
config::del('012_5_status');
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_detail timestamp added.");
$smarty->display('update.tpl');
die;
} else {
config::set('012_5_status', $row['next']);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_detail timestamp updated rows " . (config::get('012_5_status') - $step) . " - " . config::get('012_5_status'));
$smarty->display('update.tpl');
die;
}
}
if (config::get('012updatestatus') < 6) {
$step = 10000;
//$qry->execute("SELECT MAX(kll_id) as cnt FROM kb3_kills");
//$result = $qry->getRow();
//$max = $result['cnt'];
if (!config::get('012_6_status')) {
config::set('012_6_status', '0');
}
// add times to kb3_inv_detail.
$qry->execute("INSERT IGNORE INTO kb3_inv_all\r\n\t\t\t\tSELECT ind_kll_id, ind_all_id, ind_timestamp\r\n\t\t\t\tFROM kb3_inv_detail\r\n\t\t\t\tWHERE ind_kll_id >= " . config::get('012_6_status') . "\r\n\t\t\t\t\tAND ind_kll_id < " . (config::get('012_6_status') + $step) . "\r\n\t\t\t\tGROUP BY ind_kll_id, ind_all_id");
$qry->execute("SELECT MIN(kll_id) as next FROM kb3_kills WHERE kll_id >= " . (config::get('012_6_status') + $step));
$row = $qry->getRow();
if (!isset($row['next']) || $row['next'] == null) {
config::del('012_6_status');
config::set('012updatestatus', 6);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_all filled.");
$smarty->display('update.tpl');
die;
} else {
config::set('012_6_status', $row['next']);
$smarty->assign('refresh', 1);
$out = "12. kb3_inv_all rows " . (config::get('012_6_status') - $step);
$out .= " - " . config::get('012_6_status') . " added.";
$smarty->assign('content', $out);
$smarty->display('update.tpl');
die;
}
}
if (config::get('012updatestatus') < 7) {
$step = 10000;
// add times to kb3_inv_detail.
//$qry->execute("SELECT MAX(kll_id) as cnt FROM kb3_kills");
//$result = $qry->getRow();
//$max = $result['cnt'];
if (!config::get('012_7_status')) {
config::set('012_7_status', '0');
}
$qry->execute("INSERT IGNORE INTO kb3_inv_crp\r\n\t\t\t\tSELECT ind_kll_id, ind_crp_id, ind_timestamp\r\n\t\t\t\tFROM kb3_inv_detail\r\n\t\t\t\tWHERE ind_kll_id >= " . config::get('012_7_status') . "\r\n\t\t\t\t\tAND ind_kll_id < " . (config::get('012_7_status') + $step) . "\r\n\t\t\t\tGROUP BY ind_kll_id, ind_crp_id");
$qry->execute("SELECT MIN(kll_id) as next FROM kb3_kills WHERE kll_id >= " . (config::get('012_7_status') + $step));
$row = $qry->getRow();
if (!isset($row['next']) || $row['next'] == null) {
config::del('012_7_status');
config::set('012updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_inv_crp filled.");
$smarty->display('update.tpl');
die;
} else {
config::set('012_7_status', $row['next']);
$smarty->assign('refresh', 1);
$out = "12. kb3_inv_crp rows " . (config::get('012_7_status') - $step);
$out .= " - " . config::get('012_7_status') . " added.";
$smarty->assign('content', $out);
$smarty->display('update.tpl');
die;
}
}
if (config::get('012updatestatus') < 8) {
// add times to kb3_inv_detail.
$qry->execute("ALTER TABLE `kb3_log` CHANGE `log_ip_address` `log_ip_address` VARCHAR( 100 ) NOT NULL");
config::set('012updatestatus', 8);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_log expanded.");
$smarty->display('update.tpl');
die;
}
if (config::get('012updatestatus') < 9) {
// add times to kb3_inv_detail.
$qry->execute("SHOW COLUMNS FROM kb3_comments LIKE 'ip'");
if (!$qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_comments` ADD `ip` VARBINARY( 39 ) NOT NULL DEFAULT '0:0:0:0'");
}
config::set('012updatestatus', 9);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. kb3_comments ip field added.");
$smarty->display('update.tpl');
die;
}
if (config::get('012updatestatus') < 10) {
$qry->execute("UPDATE kb3_config SET cfg_value = 'default' where cfg_key = 'style_name'");
$qry->execute("INSERT IGNORE INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'theme_name', 'default' FROM kb3_config GROUP BY cfg_site");
config::set('012updatestatus', 10);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. theme set to default.");
$smarty->display('update.tpl');
die;
}
if (config::get('012updatestatus') < 11) {
$qry->execute("UPDATE `kb3_navigation` SET url = '?a=self_detail' WHERE descr = 'Stats';");
$qry->execute("DELETE FROM `kb3_navigation` WHERE url = '?a=losses';");
$qry->execute("DELETE FROM `kb3_navigation` WHERE url = '?a=kills';");
config::set('012updatestatus', 11);
$smarty->assign('refresh', 1);
$smarty->assign('content', "12. Navigation updated.");
$smarty->display('update.tpl');
die;
}
killCache();
config::set("DBUpdate", "012");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '012' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '012'");
config::del("012updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 012 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update027()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "027") {
if (is_null(config::get('027updatestatus'))) {
config::set('027updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('027updatestatus') < 1) {
// create table
$sql = 'CREATE TABLE IF NOT EXISTS kb3_api_keys (
key_name VARCHAR( 50 ) NOT NULL,
key_id INT(11) NOT NULL,
key_key VARCHAR( 64 ) NOT NULL,
key_kbsite VARCHAR( 16 ) NOT NULL,
key_flags TINYINT NOT NULL,
PRIMARY KEY (key_name, key_id, key_key, key_kbsite))';
$qry->execute($sql);
// get a list of keys for each site to migrate
$sql = "SELECT * FROM kb3_config where cfg_key = 'API_Key_count'";
$qry->execute($sql);
$qry2 = DBFactory::getDBQuery(true);
while ($ret = $qry->getRow()) {
$key_kbsite = $ret['cfg_site'];
$keycnt = $ret['cfg_value'];
for ($i = 1; $i <= $keycnt; $i++) {
$sql = "SELECT cfg_value FROM kb3_config where cfg_site = '{$key_kbsite}' AND cfg_key = 'API_UserID_{$i}' ";
$qry2->execute($sql);
$ret = $qry2->getRow();
$key_id = $qry->escape($ret['cfg_value']);
$sql = "SELECT cfg_value FROM kb3_config where cfg_site = '{$key_kbsite}' AND cfg_key = 'API_Key_{$i}' ";
$qry2->execute($sql);
$ret = $qry2->getRow();
$key_key = $qry->escape($ret['cfg_value']);
$sql = "SELECT cfg_value FROM kb3_config where cfg_site = '{$key_kbsite}' AND cfg_key = 'API_Name_{$i}' ";
$qry2->execute($sql);
$ret = $qry2->getRow();
$key_name = $qry->escape($ret['cfg_value']);
$sql = "SELECT cfg_value FROM kb3_config where cfg_site = '{$key_kbsite}' AND cfg_key = 'API_Type_{$i}' ";
$qry2->execute($sql);
$ret = $qry2->getRow();
$type = $qry->escape($ret['cfg_value']);
// need to set appropriate flags
// a) legacy key
// b) corp/char
$key_flags = KB_APIKEY_LEGACY;
if ($type == 'corp') {
$key_flags |= KB_APIKEY_CORP;
}
if ($type == 'char') {
$key_flags |= KB_APIKEY_CHAR;
}
if ($key_id != '') {
$sql = "INSERT INTO kb3_api_keys( key_name, key_id, key_key, key_kbsite, key_flags ) VALUES ( '{$key_name}', '{$key_id}', '{$key_key}', '{$key_kbsite}', '{$key_flags}' )";
$qry2->execute($sql);
}
// remove legacy config items
$sql = "DELETE FROM kb3_config where cfg_site = '{$key_kbsite}' AND ( cfg_key = 'API_UserID_{$i}' OR cfg_key = 'API_CharID_{$i}' OR cfg_key = 'API_Key_{$i}' OR cfg_key = 'API_Name_{$i}' OR cfg_key = 'API_Type_{$i}' ) ";
$qry2->execute($sql);
}
}
// remove legacy api config items
$sql = "DELETE FROM kb3_config where cfg_key = 'API_Key_count'";
$qry->execute($sql);
}
config::set("DBUpdate", "027");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '027' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '027'");
config::del("027updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 027 completed.");
$smarty->display('update.tpl');
die;
}
}
function update013()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "013") {
if (is_null(config::get('013updatestatus'))) {
config::set('013updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('013updatestatus') < 1) {
// Add timestamp column to kb3_inv_detail
$qry->execute("SHOW COLUMNS FROM kb3_comments LIKE 'site'");
if (!$qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_comments` ADD `site` CHAR( 16 ) DEFAULT NULL AFTER `id`");
config::set('013updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "13. kb3_comments site column added");
$smarty->display('update.tpl');
die;
}
}
if (config::get('013updatestatus') < 3) {
// Add site column to kb3_comments
$qry->execute("SHOW INDEX FROM kb3_comments");
$indexkexists = false;
$indexsexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Key_name'] == 'kll_id') {
$indexkexists = true;
}
if ($testresult['Key_name'] == 'kll_site_id') {
$indexsexists = true;
}
}
if ($indexkexists) {
$qry->execute("ALTER TABLE kb3_comments DROP INDEX kll_id");
config::set('013updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "13. kb3_comments kll_id index dropped");
$smarty->display('update.tpl');
die;
}
if (!$indexsexists) {
$qry->execute("ALTER TABLE `kb3_comments` ADD INDEX `kll_site_id` ( `kll_id`, `site` ) ");
config::set('013updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "13. kb3_comments kll_site_id index added");
$smarty->display('update.tpl');
die;
}
}
killCache();
config::set("DBUpdate", "013");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '013' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '013'");
config::del("013updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 013 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update037()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "037") {
if (is_null(config::get('037updatestatus'))) {
config::set('037updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
// Fix correct slot for legacy kills post slot conversion
if (config::get('037updatestatus') < 1) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "select distinct( itd_itm_id) from kb3_items_destroyed where itd_itl_id = 0 and itd_kll_id <= " . $maxid;
$qry->execute($sql);
while ($row = $qry->getRow()) {
$itemid = (int) $row['itd_itm_id'];
$qry2 = DBFactory::getDBQuery();
$sql = "select inv.*, kb3_item_types.*, dga.value as techlevel,\n\t\t\t\t\t\t itp.price, dc.value as usedcharge, dl.value as usedlauncher\n\t\t\t\t\t\t from kb3_invtypes inv\n\t\t\t\t\t\t left join kb3_dgmtypeattributes dga on dga.typeID=inv.typeID and dga.attributeID=633\n\t\t\t\t\t\t left join kb3_item_price itp on itp.typeID=inv.typeID\n\t\t\t\t\t\t left join kb3_item_types on groupID=itt_id\n\t\t\t\t\t\t left join kb3_dgmtypeattributes dc on dc.typeID = inv.typeID AND dc.attributeID IN (128)\n\t\t\t\t\t\t left join kb3_dgmtypeattributes dl on dl.typeID = inv.typeID AND dl.attributeID IN (137,602)\n\t\t\t\t\t\t where inv.typeID = '" . $itemid . "'";
if ($qry2->execute($sql)) {
$row_ = $qry2->getRow();
} else {
echo "Error updating item slots";
die;
}
if ($row_ == NULL) {
echo "Error updating item slots";
die;
}
$location = $row_['itt_slot'];
// if item has no slot get the slot from parent item
if ($location == 0) {
$query = "select itt_slot from kb3_item_types\n\t\t\t\t\t\t\t\t\tinner join kb3_dgmtypeattributes d\n\t\t\t\t\t\t\t\t\twhere itt_id = d.value\n\t\t\t\t\t\t\t\t\tand d.typeID = " . $row_['typeID'] . "\n\t\t\t\t\t\t\t\t\tand d.attributeID in (137,602);";
$qry2->execute($query);
$row = $qry2->getRow();
if (!$row['itt_slot']) {
$location = 0;
} else {
$location = $row['itt_slot'];
}
}
if ($location > 0) {
$sql = "UPDATE kb3_items_destroyed SET itd_itl_id = {$location} WHERE itd_itm_id = {$itemid} AND itd_itl_id = 0 and itd_kll_id <= " . $maxid;
$qry2->execute($sql);
}
}
}
config::set('037updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (1 of 8)");
$smarty->display('update.tpl');
die;
}
// Fix correct slot for legacy kills post slot conversion
if (config::get('037updatestatus') < 2) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "select distinct( itd_itm_id) from kb3_items_dropped where itd_itl_id = 0 and itd_kll_id <= " . $maxid;
$qry->execute($sql);
while ($row = $qry->getRow()) {
$itemid = (int) $row['itd_itm_id'];
$qry2 = DBFactory::getDBQuery();
$sql = "select inv.*, kb3_item_types.*, dga.value as techlevel,\n\t\t\t\t\t\t itp.price, dc.value as usedcharge, dl.value as usedlauncher\n\t\t\t\t\t\t from kb3_invtypes inv\n\t\t\t\t\t\t left join kb3_dgmtypeattributes dga on dga.typeID=inv.typeID and dga.attributeID=633\n\t\t\t\t\t\t left join kb3_item_price itp on itp.typeID=inv.typeID\n\t\t\t\t\t\t left join kb3_item_types on groupID=itt_id\n\t\t\t\t\t\t left join kb3_dgmtypeattributes dc on dc.typeID = inv.typeID AND dc.attributeID IN (128)\n\t\t\t\t\t\t left join kb3_dgmtypeattributes dl on dl.typeID = inv.typeID AND dl.attributeID IN (137,602)\n\t\t\t\t\t\t where inv.typeID = '" . $itemid . "'";
if ($qry2->execute($sql)) {
$row_ = $qry2->getRow();
} else {
echo "Error updating item slots";
die;
}
if ($row_ == NULL) {
echo "Error updating item slots";
die;
}
$location = $row_['itt_slot'];
// if item has no slot get the slot from parent item
if ($location == 0) {
$query = "select itt_slot from kb3_item_types\n\t\t\t\t\t\t\t\t\tinner join kb3_dgmtypeattributes d\n\t\t\t\t\t\t\t\t\twhere itt_id = d.value\n\t\t\t\t\t\t\t\t\tand d.typeID = " . $row_['typeID'] . "\n\t\t\t\t\t\t\t\t\tand d.attributeID in (137,602);";
$qry2->execute($query);
$row = $qry2->getRow();
if (!$row['itt_slot']) {
$location = 0;
} else {
$location = $row['itt_slot'];
}
}
if ($location > 0) {
$sql = "UPDATE kb3_items_dropped SET itd_itl_id = {$location} WHERE itd_itm_id = {$itemid} AND itd_itl_id = 0 and itd_kll_id <= " . $maxid;
$qry2->execute($sql);
}
}
}
config::set('037updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (2 of 8)");
$smarty->display('update.tpl');
die;
}
// Set implants as slot on pod's
if (config::get('037updatestatus') < 3) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "select kb3_kills.kll_id from kb3_kills JOIN kb3_ships ON kb3_ships.shp_id = kb3_kills.kll_ship_id \n\t\t\t\t\t where kll_id IN ( select distinct itd_kll_id from kb3_items_destroyed where itd_itl_id = 0 and itd_kll_id <= {$maxid} ) and shp_class = 2";
$qry->execute($sql);
while ($row = $qry->getRow()) {
$killid = (int) $row['kll_id'];
if ($killid > $maxid) {
echo 'error - impossible to hit code hit';
die;
}
$qry2 = DBFactory::getDBQuery();
// 89 = implant
$sql = "UPDATE kb3_items_destroyed SET itd_itl_id = 89 WHERE itd_kll_id = {$killid} AND itd_itl_id = 0 ";
$qry2->execute($sql);
}
}
config::set('037updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (3 of 8)");
$smarty->display('update.tpl');
die;
}
// Ensure JF's do not have anything fitted
if (config::get('037updatestatus') < 4) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "update kb3_items_destroyed set itd_itl_id = 5 where itd_kll_id <= " . $maxid . " AND itd_kll_id IN (Select kb3_kills.kll_id from kb3_kills JOIN kb3_ships ON kb3_ships.shp_id = kb3_kills.kll_ship_id and shp_class = 34)";
$qry->execute($sql);
}
config::set('037updatestatus', 4);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (4 of 8)");
$smarty->display('update.tpl');
die;
}
// Ensure JF's do not have anything fitted
if (config::get('037updatestatus') < 5) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "update kb3_items_dropped set itd_itl_id = 5 where itd_kll_id <= " . $maxid . " AND itd_kll_id IN (Select kb3_kills.kll_id from kb3_kills JOIN kb3_ships ON kb3_ships.shp_id = kb3_kills.kll_ship_id and shp_class = 34)";
$qry->execute($sql);
}
config::set('037updatestatus', 5);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (5 of 8)");
$smarty->display('update.tpl');
die;
}
// Set Cargo Bay for anything legacy in non-capital ships
// We can't set ore hold etc, as old kills only had cargo hold etc.
if (config::get('037updatestatus') < 6) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "update kb3_items_dropped set itd_itl_id = 5 where itd_kll_id <= " . $maxid . " AND itd_itl_id = 0 AND itd_kll_id IN (Select kb3_kills.kll_id from kb3_kills JOIN kb3_ships ON kb3_ships.shp_id = kb3_kills.kll_ship_id and shp_class NOT IN (26,27,28,29,39))";
$qry->execute($sql);
}
config::set('037updatestatus', 6);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (6 of 8)");
$smarty->display('update.tpl');
die;
}
// Set Cargo Bay for anything legacy in non-capital ships
if (config::get('037updatestatus') < 7) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "update kb3_items_destroyed set itd_itl_id = 5 where itd_kll_id <= " . $maxid . " AND itd_itl_id = 0 AND itd_kll_id IN (Select kb3_kills.kll_id from kb3_kills JOIN kb3_ships ON kb3_ships.shp_id = kb3_kills.kll_ship_id and shp_class NOT IN (26,27,28,29,39))";
$qry->execute($sql);
}
config::set('037updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (7 of 8)");
$smarty->display('update.tpl');
die;
}
// fix fuel in dread's -> fuel bay
if (config::get('037updatestatus') < 8) {
$maxid = (int) config::get('035killid');
if ($maxid > 0) {
$sql = "update kb3_items_destroyed set itd_itl_id = 133 where itd_kll_id <= " . $maxid . " AND itd_itl_id = 0 AND\n\t\t\t\t\t\titd_itm_id IN ( 16272, 16273, 16274, 16275, 17887, 17888, 17889 ) AND\n\t\t\t\t\t\titd_kll_id IN (Select kb3_kills.kll_id from kb3_kills JOIN kb3_ships ON kb3_ships.shp_id = kb3_kills.kll_ship_id and shp_class IN (26,27,28,29,19))";
$qry->execute($sql);
}
config::set('037updatestatus', 8);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Slot Data Fixes (8 of 8)");
$smarty->display('update.tpl');
die;
}
// Other stuff in capitals - leave in slot = 0 i.e. corp hanger
config::set("DBUpdate", "037");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '037' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '037'");
config::del("037updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 037 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update040()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "040") {
if (is_null(config::get('040updatestatus'))) {
config::set('040updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('040updatestatus') < 1) {
$qry->execute("SHOW COLUMNS FROM kb3_mails LIKE 'kll_json'");
if (!$qry->recordCount()) {
$sql = 'ALTER TABLE `kb3_mails` ADD COLUMN `kll_json` BLOB';
$qry->execute($sql);
}
config::set('040updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "Adding JSON field");
$smarty->display('update.tpl');
die;
}
if (config::get('040updatestatus') < 2) {
if (config::get('040updatelastkill') > 0) {
$sql = "select kll_id from kb3_mails where kll_trust <> -1 AND kll_id >= " . config::get('040updatelastkill') . " AND kll_json is null limit 500";
} else {
$sql = "select kll_id from kb3_mails where kll_trust <> -1 AND kll_json is null limit 500";
}
$qry->execute($sql);
$out = '';
while ($row = $qry->getRow()) {
$killid = (int) $row['kll_id'];
$xml = killIDToXML($killid);
if ($xml === false) {
config::set('040updatelastkill', $killid);
$out .= "Corrupt Kill: {$killid}<br/>";
die;
continue;
}
$xml2 = (string) str_replace(array("\r", "\r\n", "\n", " ", '<?xmlversion="1.0"?>'), '', $xml->result->rowset->row->asXML());
$killarray = xmlToArray($xml->result->rowset->row);
$killarray['v'] = 1;
$json = json_encode($killarray);
$xmlj = jsonToXML(json_decode($json));
$xmlj = (string) str_replace(array("\r", "\r\n", "\n", " ", "<?xmlversion=\"1.0\"?>"), '', $xmlj);
if ($xmlj == $xml2) {
$kll_json = gzdeflate($json, 9);
$qry2 = DBFactory::getDBQuery(true);
$sql2 = "UPDATE kb3_mails SET kll_json='" . $qry->escape($kll_json) . "' where kll_id = " . $killid;
$qry2->execute($sql2);
} else {
echo 'Failed to convert Kill to JSON format';
echo $xmlj;
//--> encoded
echo "--------------------";
echo $xml2;
// --> correct
die;
continue;
}
}
$sql = "select count(kll_id) as cnt from kb3_mails where kll_trust <> -1 AND kll_json is null";
$qry->execute($sql);
$row = $qry->getRow();
if ($row['cnt'] == 0) {
config::set('040updatestatus', 2);
}
$smarty->assign('refresh', 1);
$smarty->assign('content', "Generating JSON For Kills ({$killid}):<br/>" . $out);
$smarty->display('update.tpl');
die;
}
config::set("DBUpdate", "040");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '040' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '040'");
config::del("040updatestatus");
config::del("040updatelastkill");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 040 completed.");
$smarty->display('update.tpl');
die;
}
}
$tmp = explode(',', $value);
if (count($tmp) != 3) {
continue;
}
$val = array();
for ($i = 0; $i < 3; $i++) {
if (preg_match('/[a-fA-Fx]/', $tmp[$i])) {
$tmp[$i] = str_replace('x', '', $tmp[$i]);
$tmp[$i] = base_convert($tmp[$i], 16, 10);
}
$val[$i] = min(max($tmp[$i], 0), 255);
}
$string = implode(',', $val);
config::set($key, $string);
} else {
config::del($key);
}
}
}
// on submit delete all region cache files
if (is_dir(KB_CACHEDIR . '/img/map/' . KB_SITE)) {
$dir = opendir(KB_CACHEDIR . '/img/map/' . KB_SITE);
while ($file = readdir($dir)) {
if (strpos($file, '.png')) {
@unlink(KB_CACHEDIR . '/img/map/' . KB_SITE . '/' . $file);
}
}
}
}
$options = array();
$options[0]['name'] = 'Region Options';
function update024()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "024") {
if (is_null(config::get('024updatestatus'))) {
config::set('024updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('024updatestatus') < 1) {
$qry->execute("SHOW COLUMNS FROM kb3_systems LIKE 'sys_eve_id'");
if ($qry->recordCount()) {
$qry->execute("SELECT min(sys_eve_id) as min FROM kb3_systems");
$row = $qry->getRow();
$min = $row['min'];
$qry->execute("UPDATE kb3_kills\n\t\t\t\t\tJOIN kb3_systems on sys_id = kll_system_id\n\t\t\t\t\tSET kll_system_id = sys_eve_id\n\t\t\t\t\tWHERE kll_system_id < {$min}");
}
config::set('024updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. Updated kb3_kills systems.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 2) {
$qry->execute("SHOW COLUMNS FROM kb3_systems LIKE 'sys_eve_id'");
if ($qry->recordCount()) {
$qry->execute("SELECT min(sys_eve_id) as min FROM kb3_systems");
$row = $qry->getRow();
$min = $row['min'];
$qry->execute("UPDATE kb3_contract_details\n\t\t\t\t\tJOIN kb3_systems on sys_id = ctd_sys_id\n\t\t\t\t\tSET ctd_sys_id = sys_eve_id\n\t\t\t\t\tWHERE ctd_sys_id < {$min}");
}
config::set('024updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. Updated kb3_contract_details.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 3) {
$qry->execute("SHOW COLUMNS FROM kb3_systems LIKE 'sys_eve_id'");
if ($qry->recordCount()) {
$qry->execute("UPDATE kb3_systems SET sys_id = sys_eve_id");
}
config::set('024updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. kb3_systems is updated.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 4) {
$qry->execute("SHOW COLUMNS FROM kb3_ships LIKE 'shp_externalid'");
if ($qry->recordCount()) {
$qry->execute("UPDATE kb3_kills JOIN kb3_ships ON kll_ship_id =" . " shp_id SET kll_ship_id = shp_externalid");
}
config::set('024updatestatus', 4);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. kb3_kills ships are updated.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 5) {
$qry->execute("SHOW COLUMNS FROM kb3_ships LIKE 'shp_externalid'");
if ($qry->recordCount()) {
$qry->execute("UPDATE kb3_inv_detail JOIN kb3_ships ON ind_shp_id =" . " shp_id SET ind_shp_id = shp_externalid");
}
config::set('024updatestatus', 5);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. kb3_inv_detail ships are updated.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 6) {
$qry->execute("SHOW COLUMNS FROM kb3_ships LIKE 'shp_externalid'");
if ($qry->recordCount()) {
$qry->execute("UPDATE kb3_ships SET shp_id = shp_id+100000");
$qry->execute("UPDATE kb3_ships SET shp_id = shp_externalid");
}
config::set('024updatestatus', 6);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. kb3_ships is updated.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 7) {
$qry->execute("SHOW COLUMNS FROM kb3_ships LIKE 'shp_externalid'");
if ($qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_ships`" . " DROP `shp_name`," . " DROP `shp_externalid`," . " DROP `shp_rce_id`," . " DROP `shp_baseprice`," . " DROP `shp_techlevel`," . " DROP `shp_isfaction`");
}
config::set('024updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. kb3_ships shrunk.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 8) {
$qry->execute("SHOW TABLES LIKE 'kb3_ships_values'");
if ($qry->recordCount()) {
$qry->execute("DROP TABLE kb3_ships_values");
}
config::set('024updatestatus', 8);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. kb3_ships_values removed.");
$smarty->display('update.tpl');
die;
}
if (config::get('024updatestatus') < 9) {
$qry->execute("SHOW COLUMNS FROM kb3_systems LIKE 'sys_eve_id'");
if ($qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_systems` DROP `sys_eve_id`");
}
config::set('024updatestatus', 9);
$smarty->assign('refresh', 1);
$smarty->assign('content', "24. kb3_systems shrunk.");
$smarty->display('update.tpl');
die;
}
killCache();
config::set("DBUpdate", "024");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '024' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '024'");
config::del("024updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 024 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update007()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "007") {
$qry = DBFactory::getDBQuery(true);
if (is_null(config::get('007updatestatus'))) {
config::set('007updatestatus', 0);
}
if (config::get('007updatestatus') < 1) {
// Add columns for external ids.
$qry->execute("SHOW COLUMNS FROM kb3_alliances LIKE 'all_external_id'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_alliances` " . "ADD `all_external_id` INT( 11 ) UNSIGNED NULL " . "DEFAULT NULL , ADD UNIQUE ( all_external_id )";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_external_id'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_corps` " . "ADD `crp_external_id` INT( 11 ) UNSIGNED NULL " . "DEFAULT NULL , ADD UNIQUE ( crp_external_id )";
$qry->execute($sql);
}
$qry->execute("SHOW COLUMNS FROM kb3_kills LIKE 'kll_external_id'");
if (!$qry->recordCount()) {
$sql = "ALTER TABLE `kb3_kills` " . "ADD `kll_external_id` INT( 11 ) UNSIGNED NULL " . "DEFAULT NULL , ADD UNIQUE ( kll_external_id )";
$qry->execute($sql);
}
config::set('007updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. External ID columns added");
$smarty->display('update.tpl');
die;
}
// Add isk loss column to kb3_kills
if (config::get('007updatestatus') < 8) {
// Update price with items destroyed and ship value, excluding
// blueprints since default cost is for BPO and BPC looks identical
if (config::get('007updatestatus') < 2) {
$sql = "CREATE TABLE IF NOT EXISTS `tmp_price_ship` (\r\n\t\t\t\t `kll_id` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t `value` float NOT NULL DEFAULT '0',\r\n\t\t\t\t PRIMARY KEY (`kll_id`)\r\n\t\t\t\t) ENGINE=MyISAM";
$qry->execute($sql);
$sql = "CREATE TABLE IF NOT EXISTS `tmp_price_destroyed` (\r\n\t\t\t\t `kll_id` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t `value` float NOT NULL DEFAULT '0',\r\n\t\t\t\t PRIMARY KEY (`kll_id`)\r\n\t\t\t\t) ENGINE=MyISAM";
$qry->execute($sql);
$sql = "CREATE TABLE IF NOT EXISTS `tmp_price_dropped` (\r\n\t\t\t\t `kll_id` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t `value` float NOT NULL DEFAULT '0',\r\n\t\t\t\t PRIMARY KEY (`kll_id`)\r\n\t\t\t\t) ENGINE=MyISAM";
$qry->execute($sql);
config::set('007updatestatus', 2);
}
$qry->execute("LOCK TABLES tmp_price_ship WRITE, tmp_price_destroyed WRITE,\r\n\t\t\t\ttmp_price_dropped WRITE, kb3_kills WRITE, kb3_ships WRITE,\r\n\t\t\t\tkb3_ships_values WRITE, kb3_items_destroyed WRITE, kb3_items_dropped WRITE,\r\n\t\t\t\tkb3_invtypes WRITE, kb3_item_price WRITE, kb3_config WRITE");
if (config::get('007updatestatus') < 3) {
$qry->execute("INSERT IGNORE INTO tmp_price_ship select\r\n\t\t\t\t\tkll_id,if(isnull(shp_value),shp_baseprice,shp_value) FROM kb3_kills\r\n\t\t\t\t\tINNER JOIN kb3_ships ON kb3_ships.shp_id = kll_ship_id\r\n\t\t\t\t\tLEFT JOIN kb3_ships_values ON kb3_ships_values.shp_id = kll_ship_id");
$qry->execute($sql);
config::set('007updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Kill values: Ship prices calculated");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 4) {
$sql = "INSERT IGNORE INTO tmp_price_destroyed\r\n\t\t\t\t\tSELECT itd_kll_id,\r\n\t\t\t\t\tsum(if(typeName LIKE '%Blueprint%',0,if(isnull(itd_quantity),\r\n\t\t\t\t\t0,itd_quantity * if(price = 0 OR isnull(price),basePrice,price))))\r\n\t\t\t\t\tFROM kb3_items_destroyed\r\n\t\t\t\t\tLEFT JOIN kb3_item_price ON kb3_item_price.typeID = itd_itm_id\r\n\t\t\t\t\tLEFT JOIN kb3_invtypes ON itd_itm_id = kb3_invtypes.typeID\r\n\t\t\t\t\tGROUP BY itd_kll_id";
$qry->execute($sql);
config::set('007updatestatus', 4);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Kill values: Destroyed item prices calculated");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 5) {
if (config::get('kd_droptototal')) {
$action = "calculated";
$sql = "INSERT INTO tmp_price_dropped\r\n\t\t\t\t\t\tSELECT itd_kll_id,\r\n\t\t\t\t\t\tsum(if(typeName LIKE '%Blueprint%',0,if(isnull(itd_quantity),\r\n\t\t\t\t\t\t0,itd_quantity * if(price = 0 OR isnull(price),basePrice,price))))\r\n\t\t\t\t\t\tFROM kb3_items_dropped\r\n\t\t\t\t\t\tLEFT JOIN kb3_item_price ON kb3_item_price.typeID = itd_itm_id\r\n\t\t\t\t\t\tLEFT JOIN kb3_invtypes ON itd_itm_id = kb3_invtypes.typeID\r\n\t\t\t\t\t\tGROUP BY itd_kll_id";
$qry->execute($sql);
} else {
$action = "ignored";
}
config::set('007updatestatus', 5);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Kill values: Dropped item prices {$action}");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 7) {
$qry->execute("SHOW COLUMNS FROM kb3_kills LIKE 'kll_isk_loss'");
if (!$qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_kills` ADD `kll_isk_loss` FLOAT NOT NULL DEFAULT '0'");
config::set('007updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Kill values: ISK column created");
$smarty->display('update.tpl');
die;
}
config::set('007updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Kill values: ISK column already exists.");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 8) {
// default step size
$step = 8192;
if (!config::get('007.8status')) {
config::set('007.8status', 0);
config::set('007.8step', $step);
}
// If we had to restart then halve the step size up to 4 times.
if (config::get('007.8status') > 0 && config::get('007.8step') >= $step / 2 ^ 4) {
config::set('007.8step', config::get('007.8step') / 2);
}
$qry->execute("SELECT max(kll_id) as max FROM kb3_kills");
$row = $qry->getRow();
$count = $row['max'];
while (config::get('007.8status') < $count) {
$sql = 'UPDATE kb3_kills
natural join tmp_price_ship
left join tmp_price_destroyed on kb3_kills.kll_id = tmp_price_destroyed.kll_id ';
if (config::get('kd_droptototal')) {
$sql .= ' left join tmp_price_dropped on kb3_kills.kll_id = tmp_price_dropped.kll_id ';
}
$sql .= 'SET kb3_kills.kll_isk_loss = tmp_price_ship.value + ifnull(tmp_price_destroyed.value,0) ';
if (config::get('kd_droptototal')) {
$sql .= ' + ifnull(tmp_price_dropped.value,0) ';
}
$sql .= ' WHERE kb3_kills.kll_id >= ' . config::get('007.8status') . ' AND kb3_kills.kll_id < ' . (intval(config::get('007.8status')) + intval(config::get('007.8step')));
$qry->execute($sql);
config::set('007.8status', intval(config::get('007.8status')) + intval(config::get('007.8step')));
}
config::del('007.8status');
config::del('007.8step');
$qry->execute("UNLOCK TABLES");
$qry->execute('DROP TABLE tmp_price_ship');
$qry->execute('DROP TABLE tmp_price_destroyed');
$qry->execute('DROP TABLE tmp_price_dropped');
config::set('007updatestatus', 8);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Kill values: Totals updated");
$smarty->display('update.tpl');
die;
}
}
if (config::get('007updatestatus') < 9) {
$qry->execute("SHOW COLUMNS FROM kb3_kills LIKE 'kll_fb_crp_id'");
if ($qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_kills` DROP `kll_fb_crp_id`");
}
config::set('007updatestatus', 9);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. kll_fb_crp_id column dropped");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 10) {
$qry->execute("SHOW COLUMNS FROM kb3_kills LIKE 'kll_fb_all_id'");
if ($qry->recordCount()) {
$qry->execute("ALTER TABLE `kb3_kills` DROP `kll_fb_all_id`");
}
config::set('007updatestatus', 10);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. kll_fb_all_id column dropped");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 11) {
// Drop unused columns
$qry->execute("SHOW COLUMNS FROM kb3_corps LIKE 'crp_trial'");
if ($qry->recordCount()) {
$qry->execute("ALTER TABLE kb3_corps DROP crp_trial");
}
$qry->execute("SHOW COLUMNS FROM kb3_pilots LIKE 'plt_killpoints'");
if ($qry->recordCount()) {
$qry->execute("ALTER TABLE kb3_pilots DROP plt_killpoints");
}
$qry->execute("SHOW COLUMNS FROM kb3_pilots LIKE 'plt_losspoints'");
if ($qry->recordCount()) {
$qry->execute("ALTER TABLE kb3_pilots DROP plt_losspoints");
}
config::set('007updatestatus', 11);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Unused crp and plt columns dropped");
$smarty->display('update.tpl');
die;
}
// Add corp and alliance index to kb3_inv_detail
$qry->execute("SHOW INDEX FROM kb3_inv_detail");
$indexcexists = false;
$indexaexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'ind_crp_id') {
$indexcexists = true;
} elseif ($testresult['Column_name'] == 'ind_all_id') {
$indexaexists = true;
}
}
if (config::get('007updatestatus') < 12) {
if (!$indexcexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ( `ind_crp_id` ) ");
}
config::set('007updatestatus', 12);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. kb3_inv_detail ind_crp_id index added");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 13) {
if (!$indexaexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ( `ind_all_id` ) ");
}
config::set('007updatestatus', 13);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. kb3_inv_detail ind_all_id index added");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 14) {
// Add table for api cache
$sql = "CREATE TABLE IF NOT EXISTS `kb3_apicache` (\r\n\t\t\t\t `cfg_site` varchar(16) NOT NULL default '',\r\n\t\t\t\t `cfg_key` varchar(32) NOT NULL default '',\r\n\t\t\t\t `cfg_value` text NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`cfg_site`,`cfg_key`)\r\n\t\t\t\t )";
$qry->execute($sql);
$qry->execute("CREATE TABLE IF NOT EXISTS `kb3_apilog` (\r\n\t\t\t\t`log_site` VARCHAR( 20 ) NOT NULL ,\r\n\t\t\t\t`log_keyname` VARCHAR( 20 ) NOT NULL ,\r\n\t\t\t\t`log_posted` INT NOT NULL ,\r\n\t\t\t\t`log_errors` INT NOT NULL ,\r\n\t\t\t\t`log_ignored` INT NOT NULL ,\r\n\t\t\t\t`log_verified` INT NOT NULL ,\r\n\t\t\t\t`log_totalmails` INT NOT NULL ,\r\n\t\t\t\t`log_source` VARCHAR( 20 ) NOT NULL ,\r\n\t\t\t\t`log_type` VARCHAR( 20 ) NOT NULL ,\r\n\t\t\t\t`log_timestamp` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'\r\n\t\t\t\t) ENGINE = MYISAM ");
// set API update complete
config::set('API_DBUpdate', '1');
config::set('007updatestatus', 14);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. API tables added");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 15) {
// Add subsystem slot
$qry->execute("SELECT 1 FROM kb3_item_locations WHERE itl_id = 7");
if (!$qry->recordCount()) {
$qry->execute("INSERT INTO `kb3_item_locations` (`itl_id`, `itl_location`) VALUES(7, 'Subsystem Slot')");
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '7' WHERE `kb3_item_types`.`itt_id` = 954 LIMIT 1");
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '7' WHERE `kb3_item_types`.`itt_id` = 955 LIMIT 1");
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '7' WHERE `kb3_item_types`.`itt_id` = 956 LIMIT 1");
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '7' WHERE `kb3_item_types`.`itt_id` = 957 LIMIT 1");
$qry->execute("UPDATE `kb3_item_types` SET `itt_slot` = '7' WHERE `kb3_item_types`.`itt_id` = 958 LIMIT 1");
}
config::set('007updatestatus', 15);
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Subsystem slots added");
$smarty->display('update.tpl');
die;
}
if (config::get('007updatestatus') < 16) {
$qry->execute('SHOW TABLES');
$qry2 = DBFactory::getDBQuery(true);
while ($row = $qry->getRow()) {
$tablename = implode($row);
if ($tablename == 'kb3_inv_all') {
$qry2->execute("TRUNCATE kb3_inv_all");
}
if ($tablename == 'kb3_inv_crp') {
$qry2->execute("TRUNCATE kb3_inv_crp");
}
if ($tablename == 'kb3_inv_plt') {
$qry2->execute("TRUNCATE kb3_inv_plt");
}
}
killCache();
config::set("DBUpdate", "007");
$qry->execute("UPDATE kb3_config SET cfg_value = '007' WHERE cfg_key = 'DBUpdate'");
config::del('007updatestatus');
$smarty->assign('refresh', 1);
$smarty->assign('content', "7. Empty tables truncated.<br>Update 007 completed.");
$smarty->display('update.tpl');
die;
}
}
}
function update008()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "008") {
if (is_null(config::get('008updatestatus'))) {
config::set('008updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('008updatestatus') < 1) {
// Add pilot, corp and alliance index to kb3_inv_detail
// Incomplete in update007
$qry->execute("SHOW INDEXES FROM kb3_inv_detail");
$indexcexists = false;
$indexaexists = false;
$indexpexists = false;
$indexkexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'ind_kll_id' && $testresult['Seq_in_index'] == 1) {
$indexkexists = true;
}
if ($testresult['Column_name'] == 'ind_crp_id' && $testresult['Seq_in_index'] == 1) {
$indexcexists = true;
}
if ($testresult['Column_name'] == 'ind_all_id' && $testresult['Seq_in_index'] == 1) {
$indexaexists = true;
}
if ($testresult['Column_name'] == 'ind_plt_id' && $testresult['Seq_in_index'] == 1) {
$indexpexists = true;
}
}
if (!$indexkexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ( `ind_kll_id`, `ind_order` ) ");
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. kb3_inv_detail index id_order added");
$smarty->display('update.tpl');
die;
}
if (!$indexcexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ( `ind_crp_id` ) ");
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. kb3_inv_detail index id_order added");
$smarty->display('update.tpl');
die;
}
if (!$indexaexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ( `ind_all_id` ) ");
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. kb3_inv_detail index id_order added");
$smarty->display('update.tpl');
die;
}
if (!$indexpexists) {
$qry->execute("ALTER TABLE `kb3_inv_detail` ADD INDEX ( `ind_plt_id` ) ");
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. kb3_inv_detail index id_order added");
$smarty->display('update.tpl');
die;
}
config::set('008updatestatus', 1);
}
$qry->execute("SHOW INDEXES FROM kb3_corps");
$indexaexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'crp_name' && $testresult['Non_unique'] == 0) {
$indexcexists = true;
}
}
if (!$indexcexists) {
$qry->rewind();
$indexexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Key_name'] == 'UPGRADE8_crp_name') {
$indexexists = true;
}
}
if (!$indexexists) {
$qry->execute("ALTER TABLE `kb3_corps` ADD INDEX `UPGRADE8_crp_name` ( `crp_name` ) ");
}
$sqlcrp = 'select a.crp_id as newid, b.crp_id as oldid from kb3_corps a, kb3_corps b where a.crp_name = b.crp_name and a.crp_id < b.crp_id';
if (config::get('008updatestatus') < 2) {
$qry->execute('update kb3_inv_detail join (' . $sqlcrp . ') c on c.oldid = ind_crp_id set ind_crp_id = c.newid');
config::set('008updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique corp names: updated kb3_inv_detail");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 3) {
$qry->execute('update kb3_pilots join (' . $sqlcrp . ') c on (c.oldid = plt_crp_id) set plt_crp_id = c.newid');
config::set('008updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique corp names: updated kb3_pilots");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 4) {
$qry->execute('update kb3_kills join (' . $sqlcrp . ') c on (c.oldid = kll_crp_id) set kll_crp_id = c.newid');
config::set('008updatestatus', 4);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique corp names: updated kb3_kills");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 6) {
$qry->execute('delete b from kb3_corps a, kb3_corps b where a.crp_name = b.crp_name and a.crp_id < b.crp_id');
config::set('008updatestatus', 6);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique corp names: updated kb3_corps");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 7) {
$qry->execute("ALTER TABLE `kb3_corps` DROP INDEX `UPGRADE8_crp_name`");
$qry->execute("SHOW INDEXES FROM kb3_corps");
$indexcexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'crp_name' && $testresult['Seq_in_index'] == 1) {
$indexcname = $testresult['Key_name'];
$indexcexists = true;
} elseif ($testresult['Key_name'] == $indexcname && $testresult['Seq_in_index'] == 2) {
$indexcexists = false;
}
}
if ($indexcexists) {
$qry->execute("ALTER TABLE `kb3_corps` DROP INDEX `" . $indexcname . "`");
}
$qry->execute("ALTER TABLE `kb3_corps` ADD UNIQUE INDEX ( `crp_name` ) ");
config::set('008updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique corp names: unique index added to kb3_corps");
$smarty->display('update.tpl');
die;
}
}
// Make kb3_alliances.all_name unique without losing kills
$qry->execute("SHOW INDEXES FROM kb3_alliances");
$indexaexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'all_name' && $testresult['Non_unique'] == 0) {
$indexaexists = true;
}
}
if (!$indexaexists) {
$qry->rewind();
$indexexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Key_name'] == 'UPGRADE8_all_name') {
$indexexists = true;
}
}
if (!$indexexists) {
$qry->execute("ALTER TABLE `kb3_alliances` ADD INDEX `UPGRADE8_all_name` ( `all_name` ) ");
}
$sqlall = 'select a.all_id as newid, b.all_id as oldid from kb3_alliances a, kb3_alliances b where a.all_name = b.all_name and a.all_id < b.all_id';
if (config::get('008updatestatus') < 8) {
$qry->execute('update kb3_inv_detail join (' . $sqlall . ') c on c.oldid = ind_all_id set ind_all_id = c.newid');
config::set('008updatestatus', 8);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique all names: updated kb3_inv_detail");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 9) {
$qry->execute('update kb3_corps join (' . $sqlall . ') c on (c.oldid = crp_all_id) set crp_all_id = c.newid');
config::set('008updatestatus', 9);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique all names: updated kb3_corps");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 10) {
$qry->execute('update kb3_kills join (' . $sqlall . ') c on (c.oldid = kll_all_id) set kll_all_id = c.newid');
config::set('008updatestatus', 10);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique all names: updated kb3_kills");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 12) {
$qry->execute('delete b from kb3_alliances a, kb3_alliances b where a.all_name = b.all_name and a.all_id < b.all_id');
config::set('008updatestatus', 12);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique all names: updated kb3_alliances");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 13) {
$qry->execute("ALTER TABLE `kb3_alliances` DROP INDEX `UPGRADE8_all_name`");
$qry->execute("SHOW INDEXES FROM kb3_alliances");
$indexaexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'all_name' && $testresult['Seq_in_index'] == 1) {
$indexaname = $testresult['Key_name'];
$indexaexists = true;
} elseif ($testresult['Key_name'] == $indexaname && $testresult['Seq_in_index'] == 2) {
$indexaexists = false;
}
}
if ($indexaexists) {
$qry->execute("ALTER TABLE `kb3_alliances` DROP INDEX `" . $indexaname . "`");
}
$qry->execute("ALTER TABLE `kb3_alliances` ADD UNIQUE INDEX ( `all_name` ) ");
config::set('008updatestatus', 13);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique all names: unique index applied to kb3_alliances");
$smarty->display('update.tpl');
die;
}
}
// Make kb3_pilots.plt_name unique without losing kills
$qry->execute("SHOW INDEXES FROM kb3_pilots");
$indexaexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'plt_name' && $testresult['Non_unique'] == 0) {
$indexaexists = true;
}
}
if (!$indexaexists) {
$qry->rewind();
$indexexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Key_name'] == 'UPGRADE8_plt_name') {
$indexexists = true;
}
}
if (!$indexexists) {
$qry->execute("ALTER TABLE `kb3_pilots` ADD INDEX `UPGRADE8_plt_name` ( `plt_name` ) ");
}
$sqlplt = 'select a.plt_id as newid, b.plt_id as oldid from kb3_pilots a, kb3_pilots b where a.plt_name = b.plt_name and a.plt_id < b.plt_id';
if (config::get('008updatestatus') < 14) {
$qry->execute('update kb3_inv_detail join (' . $sqlplt . ') c on c.oldid = ind_plt_id set ind_plt_id = c.newid');
config::set('008updatestatus', 14);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique plt names: updated kb3_inv_detail");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 15) {
$qry->execute('update kb3_kills join (' . $sqlplt . ') c on (c.oldid = kll_victim_id) set kll_victim_id = c.newid');
config::set('008updatestatus', 15);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique plt names: updated kb3_kills victim");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 16) {
$qry->execute('update kb3_kills join (' . $sqlplt . ') c on (c.oldid = kll_fb_plt_id) set kll_fb_plt_id = c.newid');
config::set('008updatestatus', 16);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique plt names: updated kb3_kills killer");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 17) {
$qry->execute('delete b from kb3_pilots a, kb3_pilots b where a.plt_name = b.plt_name and a.plt_id < b.plt_id');
config::set('008updatestatus', 17);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique plt names: updated kb3_pilots");
$smarty->display('update.tpl');
die;
}
if (config::get('008updatestatus') < 18) {
$qry->execute("ALTER TABLE `kb3_pilots` DROP INDEX `UPGRADE8_plt_name`");
$qry->execute("SHOW INDEXES FROM kb3_pilots");
$indexpexists = false;
while ($testresult = $qry->getRow()) {
if ($testresult['Column_name'] == 'plt_name' && $testresult['Seq_in_index'] == 1) {
$indexpname = $testresult['Key_name'];
$indexpexists = true;
} elseif ($testresult['Key_name'] == $indexpname && $testresult['Seq_in_index'] == 2) {
$indexpexists = false;
}
}
if ($indexpexists) {
$qry->execute("ALTER TABLE `kb3_pilots` DROP INDEX `" . $indexpname . "`");
}
$qry->execute("ALTER TABLE `kb3_pilots` ADD UNIQUE INDEX ( `plt_name` ) ");
config::set('008updatestatus', 18);
$smarty->assign('refresh', 1);
$smarty->assign('content', "8. Unique plt names: unique index applied to kb3_pilots.");
$smarty->display('update.tpl');
die;
}
}
config::set('cache_update', '*');
config::set('cache_time', '10');
killCache();
config::set("DBUpdate", "008");
$qry->execute("UPDATE kb3_config SET cfg_value = '008' WHERE cfg_key = 'DBUpdate'");
config::del("008updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 008 completed.");
$smarty->display('update.tpl');
die;
}
}
/**
* @package EDK
*/
function update043()
{
global $url, $smarty;
//Checking if this Update already done
if (CURRENT_DB_UPDATE < "043") {
if (is_null(config::get('043updatestatus'))) {
config::set('043updatestatus', 0);
}
$qry = DBFactory::getDBQuery(true);
if (config::get('043updatestatus') < 1) {
$qry->execute("DELETE FROM kb3_sum_alliance");
$qry->execute("DELETE FROM kb3_sum_corp");
$qry->execute("DELETE FROM kb3_sum_pilot");
$qry->execute("UPDATE kb3_pilots SET plt_lpoints=0, plt_kpoints=0");
config::set('043updatestatus', 1);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. Add date summary columns to summary tables.");
$smarty->display('update.tpl');
die;
}
if (config::get('043updatestatus') < 2) {
$qry->execute("ALTER TABLE kb3_sum_alliance ADD COLUMN asm_monthday TINYINT(1) NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_alliance ADD COLUMN asm_year YEAR(4) NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp ADD COLUMN csm_monthday TINYINT(1) NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp ADD COLUMN csm_year YEAR(4) NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot ADD COLUMN psm_monthday TINYINT(1) NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot ADD COLUMN psm_year YEAR(4) NOT NULL");
config::set('043updatestatus', 2);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. Add date summary columns to summary tables.");
$smarty->display('update.tpl');
die;
}
if (config::get('043updatestatus') < 3) {
$qry->execute("ALTER TABLE kb3_sum_alliance DROP PRIMARY KEY, ADD PRIMARY KEY(asm_all_id, asm_shp_id, asm_monthday, asm_year)");
$qry->execute("ALTER TABLE kb3_sum_corp DROP PRIMARY KEY, ADD PRIMARY KEY(csm_crp_id, csm_shp_id, csm_monthday, csm_year)");
$qry->execute("ALTER TABLE kb3_sum_pilot DROP PRIMARY KEY, ADD PRIMARY KEY(psm_plt_id, psm_shp_id, psm_monthday, psm_year)");
config::set('043updatestatus', 3);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. Add date summary columns to summary tables.");
$smarty->display('update.tpl');
die;
}
if (config::get('043updatestatus') < 4) {
config::set('last_summary_id', -1);
config::set('043updatestatus', 4);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. Set config variable for last summary id");
$smarty->display('update.tpl');
die;
}
if (config::get('043updatestatus') < 5) {
$qry->execute("ALTER TABLE kb3_sum_alliance ADD COLUMN asm_kill_loot DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot ADD COLUMN psm_kill_loot DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp ADD COLUMN csm_kill_loot DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_alliance ADD COLUMN asm_loss_loot DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot ADD COLUMN psm_loss_loot DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp ADD COLUMN csm_loss_loot DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_alliance ADD COLUMN asm_kill_points int(11) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp ADD COLUMN csm_kill_points int(11) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot ADD COLUMN psm_kill_points int(11) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_alliance ADD COLUMN asm_loss_points int(11) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp ADD COLUMN csm_loss_points int(11) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot ADD COLUMN psm_loss_points int(11) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_alliance CHANGE COLUMN asm_kill_isk asm_kill_isk DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot CHANGE COLUMN psm_kill_isk psm_kill_isk DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp CHANGE COLUMN csm_kill_isk csm_kill_isk DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_alliance CHANGE COLUMN asm_loss_isk asm_loss_isk DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_pilot CHANGE COLUMN psm_loss_isk psm_loss_isk DECIMAL(15,2) DEFAULT 0 NOT NULL");
$qry->execute("ALTER TABLE kb3_sum_corp CHANGE COLUMN csm_loss_isk csm_loss_isk DECIMAL(15,2) DEFAULT 0 NOT NULL");
config::set('043updatestatus', 5);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. Add additional summary columns to summary tables.");
$smarty->display('update.tpl');
die;
}
if (config::get('043updatestatus') < 6) {
$qry->execute("ALTER TABLE kb3_kills ADD COLUMN kll_isk_loot DECIMAL(14,2) NOT NULL DEFAULT '0'");
config::set('last_kllloot_id', -1);
config::set('043updatestatus', 6);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. add loot value to kills table");
$smarty->display('update.tpl');
die;
}
if (config::get('043updatestatus') < 7) {
$qry->execute("ALTER TABLE kb3_kills MODIFY kll_isk_loss DECIMAL(14,2) NOT NULL DEFAULT '0'");
config::set('043updatestatus', 7);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. modify loss value type in kills table");
$smarty->display('update.tpl');
die;
}
if (config::get('043updatestatus') < 8) {
config::set('last_summary_id', 0);
config::set('043updatestatus', 8);
$smarty->assign('refresh', 1);
$smarty->assign('content', "43. add last_summary_id config variable");
$smarty->display('update.tpl');
die;
}
config::set("DBUpdate", "043");
$qry->execute("INSERT INTO kb3_config (cfg_site, cfg_key, cfg_value) SELECT cfg_site, 'DBUpdate', '043' FROM kb3_config GROUP BY cfg_site ON DUPLICATE KEY UPDATE cfg_value = '043'");
config::del("043updatestatus");
$smarty->assign('refresh', 1);
$smarty->assign('content', "Update 043 completed.");
$smarty->display('update.tpl');
die;
}
}
