public function execute($parameters, $db)
{
$p = array();
$p["limit"] = 5;
$p["pastSeconds"] = 3 * 86400;
$p["kills"] = true;
Storage::store("Top3dayChars", json_encode(Info::doMakeCommon("Top Characters - Last 3 Days", "characterID", Stats::getTopPilots($p))));
Storage::store("Top3dayCorps", json_encode(Info::doMakeCommon("Top Corporations - Last 3 Days", "corporationID", Stats::getTopCorps($p))));
Storage::store("Top3dayAlli", json_encode(Info::doMakeCommon("Top Alliances - Last 3 Days", "allianceID", Stats::getTopAllis($p))));
Storage::store("TopIsk", json_encode(Stats::getTopIsk(array("pastSeconds" => 3 * 86400, "limit" => 5))));
Storage::store("TopPods", json_encode(Stats::getTopIsk(array("groupID" => 29, "pastSeconds" => 3 * 86400, "limit" => 5))));
Storage::store("TopPoints", json_encode(Stats::getTopPoints("killID", array("losses" => true, "pastSeconds" => 3 * 86400, "limit" => 5))));
Storage::store("KillCount", $db->queryField("select count(*) count from zz_killmails", "count"));
Storage::store("ActualKillCount", $db->queryField("select count(*) count from zz_killmails where processed = 1", "count"));
}
$p['page'] = $page;
$columnName = key($p);
$id = (int) reset($p);
if (sizeof($p) <= 1) {
$app->redirect($fullAddr, 302);
}
$topPoints = array();
$topPods = array();
$p['kills'] = true;
$p['pastSeconds'] = $numDays * 86400;
$top = array();
$top[] = Info::doMakeCommon('Top Characters', 'characterID', Stats::getTopPilots($p));
$top[] = $columnName != 'corporationID' ? Info::doMakeCommon('Top Corporations', 'corporationID', Stats::getTopCorps($p)) : array();
$top[] = $columnName != 'corporationID' && $columnName != 'allianceID' ? Info::doMakeCommon('Top Alliances', 'allianceID', Stats::getTopAllis($p)) : array();
$top[] = Info::doMakeCommon('Top Ships', 'shipTypeID', Stats::getTopShips($p));
$top[] = Info::doMakeCommon('Top Systems', 'solarSystemID', Stats::getTopSystems($p));
$requestUriPager = str_replace('ID', '', $columnName) . "/{$id}/";
$p['limit'] = 5;
$topIsk = Stats::getTopIsk($p);
unset($p['pastSeconds']);
unset($p['kills']);
// get latest kills
$killsLimit = 50;
$p['limit'] = $killsLimit;
$kills = Kills::getKills($p);
$kills = Kills::mergeKillArrays($kills, array(), $killsLimit, $columnName, $id);
Info::addInfo($p);
$pageTitle = array();
foreach ($p as $key => $value) {
if (strpos($key, 'Name') !== false) {
$pageTitle[] = $value;
$columnName = key($p);
$id = (int) reset($p);
if (sizeof($p) <= 1) {
$app->redirect($fullAddr, 302);
}
$topPoints = array();
$topPods = array();
$p['kills'] = true;
$p['pastSeconds'] = $numDays * 86400;
$top = array();
$top[] = Info::doMakeCommon('Top Characters', 'characterID', Stats::getTop('characterID', $p));
$top[] = $columnName != 'corporationID' ? Info::doMakeCommon('Top Corporations', 'corporationID', Stats::getTop('corporationID', $p)) : array();
$top[] = $columnName != 'corporationID' && $columnName != 'allianceID' ? Info::doMakeCommon('Top Alliances', 'allianceID', Stats::getTop('allianceID', $p)) : array();
$top[] = Info::doMakeCommon('Top Ships', 'shipTypeID', Stats::getTop('shipTypeID', $p));
$top[] = Info::doMakeCommon('Top Systems', 'solarSystemID', Stats::getTop('solarSystemID', $p));
$top[] = Info::doMakeCommon('Top Locations', 'locationID', Stats::getTop('locationID', $p));
$requestUriPager = str_replace('ID', '', $columnName) . "/{$id}/";
$p['limit'] = 5;
$topIsk = Stats::getTopIsk($p);
unset($p['pastSeconds']);
unset($p['kills']);
// get latest kills
$killsLimit = 50;
$p['limit'] = $killsLimit;
$kills = Kills::getKills($p);
$kills = Kills::mergeKillArrays($kills, array(), $killsLimit, $columnName, $id);
Info::addInfo($p);
$pageTitle = array();
foreach ($p as $key => $value) {
if (strpos($key, 'Name') !== false) {
$pageTitle[] = $value;
$p['pastSeconds'] = $numDays * 86400;
$p['kills'] = $pageType != 'losses';
if ($key != 'character') {
$topLists[] = Info::doMakeCommon('Top Characters', 'characterID', Stats::getTop('characterID', $p));
if ($key != 'corporation') {
$topLists[] = Info::doMakeCommon('Top Corporations', 'corporationID', Stats::getTop('corporationID', $p));
if ($key != 'alliance') {
$topLists[] = Info::doMakeCommon('Top Alliances', 'allianceID', Stats::getTop('allianceID', $p));
}
}
}
if ($key != 'ship') {
$topLists[] = Info::doMakeCommon('Top Ships', 'shipTypeID', Stats::getTop('shipTypeID', $p));
}
if ($key != 'system') {
$topLists[] = Info::doMakeCommon('Top Systems', 'solarSystemID', Stats::getTop('solarSystemID', $p));
}
$p['limit'] = 5;
$topKills = Stats::getTopIsk($p);
}
$corpList = array();
if ($pageType == 'api') {
$corpList = Info::getCorps($id);
}
$corpStats = array();
if ($pageType == 'corpstats') {
$corpStats = Info::getCorpStats($id, $parameters);
}
$onlyHistory = array('character', 'corporation', 'alliance');
if ($pageType == 'stats' && in_array($key, $onlyHistory)) {
$months = $mdb->findField('statistics', 'months', ['type' => $key . 'ID', 'id' => (int) $id]);
$i = date('i');
if ($i % 15 != 0) {
exit;
}
$p = array();
$numDays = 7;
$p['limit'] = 10;
$p['pastSeconds'] = $numDays * 86400;
$p['kills'] = true;
Storage::store('Kills5b+', json_encode(Kills::getKills(array('iskValue' => 5000000000), true, false)));
Storage::store('Kills10b+', json_encode(Kills::getKills(array('iskValue' => 10000000000), true, false)));
Storage::store('TopChars', json_encode(Info::doMakeCommon('Top Characters', 'characterID', getStats('characterID'))));
Storage::store('TopCorps', json_encode(Info::doMakeCommon('Top Corporations', 'corporationID', getStats('corporationID'))));
Storage::store('TopAllis', json_encode(Info::doMakeCommon('Top Alliances', 'allianceID', getStats('allianceID'))));
Storage::store('TopShips', json_encode(Info::doMakeCommon('Top Ships', 'shipTypeID', getStats('shipTypeID'))));
Storage::store('TopSystems', json_encode(Info::doMakeCommon('Top Systems', 'solarSystemID', getStats('solarSystemID'))));
Storage::store('TopIsk', json_encode(Stats::getTopIsk(array('pastSeconds' => $numDays * 86400, 'limit' => 5))));
// Cleanup old sessions
Db::execute('delete from zz_users_sessions where validTill < now()');
// Keep the account balance table clean
Db::execute('delete from zz_account_balance where balance = 0');
// Cleanup subdomain stuff
Db::execute('update zz_subdomains set adfreeUntil = null where adfreeUntil < now()');
Db::execute("update zz_subdomains set banner = null where banner = ''");
Db::execute("delete from zz_subdomains where adfreeUntil is null and banner is null and (alias is null or alias = '')");
// Expire change expirations
Db::execute('update zz_users set change_expiration = null, change_hash = null where change_expiration < date_sub(now(), interval 3 day)');
function getStats($column)
{
$result = Stats::getTop($column, ['isVictim' => false, 'pastSeconds' => 604800]);
return $result;
$topPods = array();
$topIsk = array();
$topPoints = array();
$topKillers = array();
$page = 1;
$pageTitle = "War {$warID}";
$p['kills'] = true;
if (!$warFinished) {
$p['pastSeconds'] = 7 * 86400;
}
$top = array();
$top[] = Info::doMakeCommon('Top Characters', 'characterID', Stats::getTopPilots($p, $warFinished));
$top[] = Info::doMakeCommon('Top Corporations', 'corporationID', Stats::getTopCorps($p, $warFinished));
$top[] = Info::doMakeCommon('Top Alliances', 'allianceID', Stats::getTopAllis($p, $warFinished));
$top[] = Info::doMakeCommon('Top Ships', 'shipTypeID', Stats::getTopShips($p, $warFinished));
$top[] = Info::doMakeCommon('Top Systems', 'solarSystemID', Stats::getTopSystems($p, $warFinished));
$p['limit'] = 5;
$topIsk = array();
//Stats::getTopIsk($p);
unset($p['pastSeconds']);
unset($p['kills']);
// get latest kills
$killsLimit = 50;
$p['limit'] = $killsLimit;
$preKills = Kills::getKills($p);
$kills = array();
$agrID = $warData['aggressor']['id'];
$dfdID = $warData['defender']['id'];
foreach ($preKills as $kill) {
$victim = $kill['victim'];
if (@$victim['corporationID'] == $dfdID || @$victim['allianceID'] == $dfdID) {
require_once '../init.php';
global $redis;
if (date('i') % 15 != 0) {
exit;
}
$p = array();
$numDays = 7;
$p['limit'] = 10;
$p['pastSeconds'] = $numDays * 86400;
$p['kills'] = true;
$redis->setex('RC:Kills5b+', 3600, json_encode(Kills::getKills(array('iskValue' => 5000000000), true, false)));
$redis->setex('RC:Kills10b+', 3600, json_encode(Kills::getKills(array('iskValue' => 10000000000), true, false)));
$redis->setex('RC:TopChars', 3600, json_encode(Info::doMakeCommon('Top Characters', 'characterID', getStats('characterID'))));
$redis->setex('RC:TopCorps', 3600, json_encode(Info::doMakeCommon('Top Corporations', 'corporationID', getStats('corporationID'))));
$redis->setex('RC:TopAllis', 3600, json_encode(Info::doMakeCommon('Top Alliances', 'allianceID', getStats('allianceID'))));
$redis->setex('RC:TopShips', 3600, json_encode(Info::doMakeCommon('Top Ships', 'shipTypeID', getStats('shipTypeID'))));
$redis->setex('RC:TopSystems', 3600, json_encode(Info::doMakeCommon('Top Systems', 'solarSystemID', getStats('solarSystemID'))));
$redis->setex('RC:TopLocations', 3600, json_encode(Info::doMakeCommon('Top Locations', 'locationID', getStats('locationID'))));
$redis->setex('RC:TopIsk', 3600, json_encode(Stats::getTopIsk(array('pastSeconds' => $numDays * 86400, 'limit' => 5))));
// Cleanup subdomain stuff
Db::execute('update zz_subdomains set adfreeUntil = null where adfreeUntil < now()');
Db::execute("update zz_subdomains set banner = null where banner = ''");
Db::execute("delete from zz_subdomains where adfreeUntil is null and banner is null and (alias is null or alias = '')");
function getStats($column)
{
$result = Stats::getTop($column, ['isVictim' => false, 'pastSeconds' => 604800]);
return $result;
}
$redis->keys('*');
// Helps purge expired ttl's
