public function buildStats()
{
// this is a fast query to get the system and timestamp
$rqry = DBFactory::getDBQuery();
if ($this->adjacent) {
$rsql = 'SELECT kll_timestamp, sjp_to as sys_id from kb3_kills
join kb3_systems a ON (a.sys_id = kll_system_id)
join kb3_system_jumps on (sjp_from = a.sys_id)
where kll_id = ' . $this->kll_id . ' UNION
SELECT kll_timestamp, kll_system_id as sys_id from kb3_kills
where kll_id = ' . $this->kll_id;
} else {
$rsql = 'SELECT kll_timestamp, kll_system_id as sys_id from kb3_kills
where kll_id = ' . $this->kll_id;
}
$rqry->execute($rsql);
while ($rrow = $rqry->getRow()) {
$this->systems[] = $rrow['sys_id'];
$basetime = $rrow['kll_timestamp'];
}
// now we get all kills in that system for +-4 hours
$query = 'SELECT kll.kll_timestamp AS ts FROM kb3_kills kll WHERE kll.kll_system_id IN (' . implode(',', $this->systems) . ') AND kll.kll_timestamp <= "' . date('Y-m-d H:i:s', strtotime($basetime) + config::get('fleet_battles_mod_maxtime') * 60 * 60) . '"' . ' AND kll.kll_timestamp >= "' . date('Y-m-d H:i:s', strtotime($basetime) - config::get('fleet_battles_mod_maxtime') * 60 * 60) . '"' . ' ORDER BY kll.kll_timestamp ASC';
$qry = DBFactory::getDBQuery();
$qry->execute($query);
$ts = array();
$timestampsRaw = array();
while ($row = $qry->getRow()) {
$time = strtotime($row['ts']);
$ts[intval(date('H', $time))][] = $row['ts'];
$timestampsRaw[] = $row["ts"];
}
// only for non-battles
if (!$this->displayingBattle) {
// this tricky thing looks for gaps of more than 1 hour and creates an intersection
$baseh = date('H', strtotime($basetime));
$maxc = count($ts);
$times = array();
for ($i = 0; $i < $maxc; $i++) {
$h = ($baseh + $i) % 24;
if (!isset($ts[$h])) {
break;
}
foreach ($ts[$h] as $timestamp) {
$times[] = $timestamp;
}
}
for ($i = 0; $i < $maxc; $i++) {
$h = ($baseh - $i) % 24;
if ($h < 0) {
$h += 24;
}
if (!isset($ts[$h])) {
break;
}
foreach ($ts[$h] as $timestamp) {
$times[] = $timestamp;
}
}
unset($ts);
asort($times);
// we got 2 resulting timestamps
$this->firstts = array_shift($times);
$this->lastts = array_pop($times);
} else {
// take the first and last timestamp from our original query
$this->firstts = array_shift($timestampsRaw);
$this->lastts = array_pop($timestampsRaw);
}
// get parameters for overriding start and end times
// dirty hook for the enlightened circle ;)
$overrideStartTime = str_replace('%20', ' ', edkURI::getArg('starttime'));
$overrideEndTime = str_replace('%20', ' ', edkURI::getArg('endtime'));
if ($overrideStartTime && strtotime($overrideStartTime)) {
$this->firstts = $overrideStartTime;
}
if ($overrideEndTime && strtotime($overrideEndTime)) {
$this->lastts = $overrideEndTime;
}
// unfiltered kill list (no ship class filter applied)
$this->kslist = new KillList();
$this->kslist->setOrdered(true);
foreach ($this->systems as $system) {
$this->kslist->addSystem($system);
}
$this->kslist->setStartDate($this->firstts);
$this->kslist->setEndDate($this->lastts);
involved::load($this->kslist, 'kill');
// unfiltered loss list (no ship class filter applied)
$this->lslist = new KillList();
$this->lslist->setOrdered(true);
foreach ($this->systems as $system) {
$this->lslist->addSystem($system);
}
$this->lslist->setStartDate($this->firstts);
$this->lslist->setEndDate($this->lastts);
involved::load($this->lslist, 'loss');
// filtered kill list (shipclass filter applied)
$this->klist = new KillList();
$this->klist->setOrdered(true);
$this->klist->setCountComments(true);
$this->klist->setCountInvolved(true);
foreach ($this->systems as $system) {
$this->klist->addSystem($system);
}
$this->klist->setStartDate($this->firstts);
$this->klist->setEndDate($this->lastts);
involved::load($this->klist, 'kill');
// filtered loss list (ship class filter applied)
$this->llist = new KillList();
$this->llist->setOrdered(true);
$this->llist->setCountComments(true);
$this->llist->setCountInvolved(true);
foreach ($this->systems as $system) {
$this->llist->addSystem($system);
}
$this->llist->setStartDate($this->firstts);
$this->llist->setEndDate($this->lastts);
involved::load($this->llist, 'loss');
// apply ship class filters
if ($this->scl_id) {
$this->klist->addVictimShipClass($this->scl_id);
$this->llist->addVictimShipClass($this->scl_id);
}
// if manual side assignment is enabled
if (config::get("fleet_battles_mod_sideassign")) {
// get possible side assignments
$sideAssignments = getSideAssignments($this->systems[0], $this->firstts, $this->lastts);
$sideAssignmentMap = array();
// apply
foreach ($sideAssignments as $sideAssignment) {
$this->isFixed = TRUE;
$sideAssignmentMap[$sideAssignment["entity_type"]][$sideAssignment["entity_id"]] = $sideAssignment["side"];
// entity is an alliance
if ($sideAssignment["entity_type"] == "alliance") {
// alliance is an enemy
if ($sideAssignment["side"] == "e") {
$this->kslist->addVictimAlliance($sideAssignment["entity_id"]);
$this->lslist->addInvolvedAlliance($sideAssignment["entity_id"]);
$this->klist->addVictimAlliance($sideAssignment["entity_id"]);
$this->llist->addInvolvedAlliance($sideAssignment["entity_id"]);
} else {
$this->kslist->addInvolvedAlliance($sideAssignment["entity_id"]);
$this->lslist->addVictimAlliance($sideAssignment["entity_id"]);
// also add as involved alliance for blue-on-blue kills
$this->lslist->addInvolvedAlliance($sideAssignment["entity_id"]);
$this->klist->addInvolvedAlliance($sideAssignment["entity_id"]);
$this->llist->addVictimAlliance($sideAssignment["entity_id"]);
// also add as involved alliance for blue-on-blue kills
$this->llist->addInvolvedAlliance($sideAssignment["entity_id"]);
}
} else {
// alliance is an enemy
if ($sideAssignment["side"] == "e") {
$this->kslist->addVictimCorp($sideAssignment["entity_id"]);
$this->lslist->addInvolvedCorp($sideAssignment["entity_id"]);
$this->klist->addVictimCorp($sideAssignment["entity_id"]);
$this->llist->addInvolvedCorp($sideAssignment["entity_id"]);
} else {
$this->kslist->addInvolvedCorp($sideAssignment["entity_id"]);
$this->lslist->addVictimCorp($sideAssignment["entity_id"]);
// also add as involved alliance for blue-on-blue kills
$this->lslist->addInvolvedCorp($sideAssignment["entity_id"]);
$this->klist->addInvolvedCorp($sideAssignment["entity_id"]);
$this->llist->addVictimCorp($sideAssignment["entity_id"]);
// also add as involved alliance for blue-on-blue kills
$this->llist->addInvolvedCorp($sideAssignment["entity_id"]);
}
}
}
}
// we need a summary table first
$this->summaryTable = new KillSummaryTable($this->kslist, $this->lslist);
$this->summaryTable->generate();
$this->destroyed = array();
$this->lossValues = array();
$this->killValues = array();
$this->pilots = array('a' => array(), 'e' => array());
$this->klist->rewind();
$this->damageOverview = array('a' => array(), 'e' => array());
$totalKillIsk = $this->summaryTable->getTotalKillISK();
while ($kill = $this->klist->getKill()) {
handle_involved($kill, 'a', $this->pilots, $sideAssignmentMap, TRUE);
handle_destroyed($kill, 'e', $this->destroyed, $this->pilots, $sideAssignmentMap, TRUE);
// gather data for battle timeline and loss value lists
// for better performance we use this loop so we won't have to loop over the same data again
// ---------------------------------------------------------------------------------------
// gathering kill values
// ---------------------------------------------------------------------------------------
// we dont want our own people on the enemy's side!
if (in_array($kill->getVictimAllianceID(), config::get('cfg_allianceid')) || in_array($kill->getVictimCorpID(), config::get('cfg_corpid')) || in_array($kill->getVictimID(), config::get('cfg_pilotid'))) {
continue;
}
$lossValueRaw = $kill->getISKLoss();
$lossValue = self::formatIskValue($lossValueRaw);
if ($totalKillIsk != 0) {
$percentualLossValue = number_format($lossValueRaw / $totalKillIsk * 100, 2);
} else {
$percentualLossValue = 0.0;
}
if ($lossValueRaw > 0) {
$this->killValues[] = array("victimName" => $kill->getVictimName(), "victimID" => $kill->getVictimID(), "victimUrl" => edkURI::page("pilot_detail", $kill->getVictimID(), "plt_id"), "victimShipName" => $kill->getVictimShipName(), "victimShipImage" => imageUrl::getURL("Ship", $kill->getVictimShipID(), 32), "victimShipClass" => $kill->getVictimShipClassName(), "victimCorpName" => $kill->getVictimCorpName(), "victimCorpID" => $kill->getVictimCorpID(), "victimCorpUrl" => edkURI::page("corp_detail", $kill->getVictimCorpID(), "crp_id"), "victimAllianceName" => $kill->getVictimAllianceName(), "victimAllianceID" => $kill->getVictimAllianceID(), "victimAllianceUrl" => edkURI::page("alliance_detail", $kill->getVictimAllianceID(), "all_id"), "killId" => $kill->getID(), "killUrl" => edkURI::page("kill_detail", $kill->getID(), "kll_id"), "lossValueRaw" => $lossValueRaw, "lossValue" => $lossValue, "lossValuePercentage" => $percentualLossValue);
}
// ---------------------------------------------------------------------------------------
// gathering timeline data
// ---------------------------------------------------------------------------------------
$killTimestamp = strtotime($kill->getTimeStamp());
// increase killtimestamp for pods so they appear AFTER the ship kill in the timeline
$shipClassId = $kill->getVictimShip()->getClass()->getID();
if ($shipClassId == 18 || $shipClassId == 2) {
$killTimestamp += 1;
}
$this->timeLine[] = array("timestamp" => $killTimestamp, "loss" => NULL, "kill" => array("victimName" => $kill->getVictimName(), "victimID" => $kill->getVictimID(), "victimUrl" => edkURI::page("pilot_detail", $kill->getVictimID(), "plt_id"), "victimShipName" => $kill->getVictimShipName(), "victimShipImage" => imageUrl::getURL("Ship", $kill->getVictimShipID(), 32), "victimShipClass" => $kill->getVictimShipClassName(), "victimCorpName" => $kill->getVictimCorpName(), "victimCorpID" => $kill->getVictimCorpID(), "victimCorpUrl" => edkURI::page("corp_detail", $kill->getVictimCorpID(), "crp_id"), "victimAllianceName" => $kill->getVictimAllianceName(), "victimAllianceID" => $kill->getVictimAllianceID(), "victimAllianceUrl" => edkURI::page("alliance_detail", $kill->getVictimAllianceID(), "all_id"), "killId" => $kill->getID(), "killUrl" => edkURI::page("kill_detail", $kill->getID(), "kll_id")));
// ---------------------------------------------------------------------------------------
// gathering damage overview data
// ---------------------------------------------------------------------------------------
$this->damageOverview["a"][] = array("victimName" => $kill->getVictimName(), "victimID" => $kill->getVictimID(), "victimUrl" => edkURI::page("pilot_detail", $kill->getVictimID(), "plt_id"), "victimShipName" => $kill->getVictimShipName(), "victimShipImage" => imageUrl::getURL("Ship", $kill->getVictimShipID(), 32), "victimShipClass" => $kill->getVictimShipClassName(), "victimCorpName" => $kill->getVictimCorpName(), "victimCorpID" => $kill->getVictimCorpID(), "victimCorpUrl" => edkURI::page("corp_detail", $kill->getVictimCorpID(), "crp_id"), "victimAllianceName" => $kill->getVictimAllianceName(), "victimAllianceID" => $kill->getVictimAllianceID(), "victimAllianceUrl" => edkURI::page("alliance_detail", $kill->getVictimAllianceID(), "all_id"), "killId" => $kill->getID(), "killUrl" => edkURI::page("kill_detail", $kill->getID(), "kll_id"), "lossValueRaw" => $lossValueRaw, "lossValue" => $lossValue, "lossValuePercentage" => $percentualLossValue);
}
$this->llist->rewind();
$totalLossIsk = $this->summaryTable->getTotalLossISK();
while ($kill = $this->llist->getKill()) {
handle_involved($kill, 'e', $this->pilots, $sideAssignmentMap, TRUE);
handle_destroyed($kill, 'a', $this->destroyed, $this->pilots, $sideAssignmentMap, TRUE);
// gather data for battle timeline and loss value lists
// for better performance we use this loop so we won't have to loop over the same data again
// ---------------------------------------------------------------------------------------
// gathering loss values
// ---------------------------------------------------------------------------------------
$lossValueRaw = $kill->getISKLoss();
$lossValue = self::formatIskValue($lossValueRaw);
if ($totalLossIsk != 0) {
$percentualLossValue = number_format($lossValueRaw / $totalLossIsk * 100, 2);
} else {
$percentualLossValue = 0.0;
}
if ($lossValueRaw > 0) {
$this->lossValues[] = array("victimName" => $kill->getVictimName(), "victimID" => $kill->getVictimID(), "victimUrl" => edkURI::page("pilot_detail", $kill->getVictimID(), "plt_id"), "victimShipName" => $kill->getVictimShipName(), "victimShipImage" => imageUrl::getURL("Ship", $kill->getVictimShipID(), 32), "victimShipClass" => $kill->getVictimShipClassName(), "victimCorpName" => $kill->getVictimCorpName(), "victimCorpID" => $kill->getVictimCorpID(), "victimCorpUrl" => edkURI::page("corp_detail", $kill->getVictimCorpID(), "crp_id"), "victimAllianceName" => $kill->getVictimAllianceName(), "victimAllianceID" => $kill->getVictimAllianceID(), "victimAllianceUrl" => edkURI::page("alliance_detail", $kill->getVictimAllianceID(), "all_id"), "killId" => $kill->getID(), "killUrl" => edkURI::page("kill_detail", $kill->getID(), "kll_id"), "lossValueRaw" => $lossValueRaw, "lossValue" => $lossValue, "lossValuePercentage" => $percentualLossValue);
}
// ---------------------------------------------------------------------------------------
// gathering timeline data
// ---------------------------------------------------------------------------------------
$killTimestamp = strtotime($kill->getTimeStamp());
$shipClassId = $kill->getVictimShip()->getClass()->getID();
$this->timeLine[] = array("timestamp" => strtotime($kill->getTimeStamp()), "loss" => array("victimName" => $kill->getVictimName(), "victimID" => $kill->getVictimID(), "victimUrl" => edkURI::page("pilot_detail", $kill->getVictimID(), "plt_id"), "victimShipName" => $kill->getVictimShipName(), "victimShipImage" => imageUrl::getURL("Ship", $kill->getVictimShipID(), 32), "victimShipClass" => $kill->getVictimShipClassName(), "victimCorpName" => $kill->getVictimCorpName(), "victimCorpID" => $kill->getVictimCorpID(), "victimCorpUrl" => edkURI::page("corp_detail", $kill->getVictimCorpID(), "crp_id"), "victimAllianceName" => $kill->getVictimAllianceName(), "victimAllianceID" => $kill->getVictimAllianceID(), "victimAllianceUrl" => edkURI::page("alliance_detail", $kill->getVictimAllianceID(), "all_id"), "killId" => $kill->getID(), "killUrl" => edkURI::page("kill_detail", $kill->getID(), "kll_id")), "kill" => NULL);
}
//echo "<pre>"; var_dump($this->pilots); echo "</pre>";
// sort pilot ships, order pods after ships
foreach ($this->pilots as $side => $pilot) {
foreach ($pilot as $id => $kll) {
usort($this->pilots[$side][$id], array($this, 'cmp_ts_func'));
}
}
// sort arrays, ships with high points first
uasort($this->pilots['a'], array($this, 'cmp_func'));
uasort($this->pilots['e'], array($this, 'cmp_func'));
// now get the pods out and mark the ships the've flown as podded
foreach ($this->pilots as $side => $pilot) {
foreach ($pilot as $id => $kll) {
$max = count($kll);
for ($i = 0; $i < $max; $i++) {
// add up total damage for each side
if ($side == "a") {
if (isset($kll[$i]["damage"])) {
$this->damageTotalFriendly += $kll[$i]["damage"];
}
} else {
if (isset($kll[$i]["damage"])) {
$this->damageTotalHostile += $kll[$i]["damage"];
}
}
// this kill has a pod as ship
if ($kll[$i]['shipClass'] == 'Capsule') {
// this pilot made previous kills in another ship
if (isset($kll[$i - 1]['sid'])) {
// this kill is a pod loss
if (isset($kll[$i]['destroyed'])) {
$this->pilots[$side][$id][$i - 1]['podded'] = true;
$this->pilots[$side][$id][$i - 1]['podid'] = $kll[$i]['kll_id'];
$this->pilots[$side][$id][$i - 1]['pod_url'] = edkURI::page("kill_detail", $kll[$i]['kll_id'], "kll_id");
unset($this->pilots[$side][$id][$i]);
} else {
// update stats for previously used ship
$this->pilots[$side][$id][$i - 1]['times'] += $this->pilots[$side][$id][$i]['times'];
$this->pilots[$side][$id][$i - 1]['damage'] += $this->pilots[$side][$id][$i]['damage'];
unset($this->pilots[$side][$id][$i]);
}
}
}
}
}
}
// update battles with current stats
$this->updateBattles();
}
$html = $smarty->fetch(get_tpl('admin_export'));
}
if (isset($_SESSION['admin_kill_export']['do'])) {
if ($string = $_SESSION['admin_kill_export']['to_export']) {
$klist = new KillList();
$llist = new KillList();
$tmp = explode(',', $string);
foreach ($tmp as $item) {
if (!$item) {
continue;
}
$typ = substr($item, 0, 1);
$id = substr($item, 1);
if ($typ == 'a') {
$klist->addInvolvedAlliance(new Alliance($id));
$llist->addVictimAlliance(new Alliance($id));
} elseif ($typ == 'c') {
$klist->addInvolvedCorp(new Corporation($id));
$llist->addVictimCorp(new Corporation($id));
} elseif ($typ == 'p') {
$klist->addInvolvedPilot(new Pilot($id));
$llist->addVictimPilot(new Pilot($id));
}
}
$kills = array();
while ($kill = $klist->getKill()) {
$kills[$kill->getID()] = $kill->getTimestamp();
}
while ($kill = $llist->getKill()) {
$kills[$kill->getID()] = $kill->getTimestamp();
}
/**
* Build the killlists that are needed for the options selected.
*
* @global Smarty $smarty
* @return string
*/
function killList()
{
global $smarty;
if ($this->view == '') {
$smarty->assign('view', Language::get('recent'));
} else {
$smarty->assign('view', $this->view);
}
$args = array(array('a', 'alliance_detail', true), array('all_id', $this->all_id, true));
if (isset($this->viewList[$this->view])) {
return call_user_func_array($this->viewList[$this->view], array(&$this));
}
$scl_id = (int) edkURI::getArg('scl_id');
switch ($this->view) {
default:
$list = new KillList();
$list->setOrdered(true);
if (config::get('comments_count')) {
$list->setCountComments(true);
}
if (config::get('killlist_involved')) {
$list->setCountInvolved(true);
}
$list->setLimit(10);
$list->addInvolvedAlliance($this->alliance);
if ($scl_id) {
$list->addVictimShipClass($scl_id);
} else {
$list->setPodsNoobShips(config::get('podnoobs'));
}
$ktab = new KillListTable($list);
$ktab->setLimit(10);
$smarty->assign('kills', $ktab->generate());
$list = new KillList();
$list->setOrdered(true);
if (config::get('comments_count')) {
$list->setCountComments(true);
}
if (config::get('killlist_involved')) {
$list->setCountInvolved(true);
}
$list->setLimit(10);
$list->addVictimAlliance($this->alliance);
if ($scl_id) {
$list->addVictimShipClass($scl_id);
} else {
$list->setPodsNoobShips(config::get('podnoobs'));
}
$ltab = new KillListTable($list);
$ltab->setLimit(10);
$smarty->assign('losses', $ltab->generate());
return $smarty->fetch(get_tpl('detail_kl_default'));
break;
case "kills":
$list = new KillList();
$list->setOrdered(true);
$list->addInvolvedAlliance($this->alliance);
if ($scl_id) {
$list->addVictimShipClass($scl_id);
}
$list->setPageSplit(config::get('killcount'));
$pagesplitter = new PageSplitter($list->getCount(), config::get('killcount'));
$table = new KillListTable($list);
$smarty->assign('kills', $table->generate());
$smarty->assign('splitter', $pagesplitter->generate());
return $smarty->fetch(get_tpl('detail_kl_kills'));
break;
case "losses":
$list = new KillList();
$list->setOrdered(true);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->addVictimAlliance($this->alliance);
if ($scl_id) {
$list->addVictimShipClass($scl_id);
}
$list->setPageSplit(config::get('killcount'));
$pagesplitter = new PageSplitter($list->getCount(), config::get('killcount'));
$table = new KillListTable($list);
$smarty->assign('losses', $table->generate());
$smarty->assign('splitter', $pagesplitter->generate());
return $smarty->fetch(get_tpl('detail_kl_losses'));
break;
case "corp_kills":
$smarty->assign('title', Language::get('topkillers'));
$smarty->assign('month', $this->monthname);
$smarty->assign('year', $this->year);
$smarty->assign('pmonth', $this->pmonth);
$smarty->assign('pyear', $this->pyear);
$smarty->assign('nmonth', $this->nmonth);
$smarty->assign('nyear', $this->nyear);
$smarty->assign('all_id', $this->all_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'corp_kills', true), array('y', $this->pyear, true), array('m', $this->pmonth, true)));
$smarty->assign('url_next', edkURI::build($args, array('view', 'corp_kills', true), array('y', $this->nyear, true), array('m', $this->nmonth, true)));
$list = new TopList_CorpKills();
$list->addInvolvedAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Corp($list, Language::get('kills'));
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_CorpKills();
$list->addInvolvedAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Corp($list, Language::get('kills'));
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "corp_kills_class":
$smarty->assign('title', Language::get('topdestroyedships'));
// Get all ShipClasses
$sql = "select scl_id, scl_class from kb3_ship_classes\n\t\t\t\t\twhere scl_class not in ('Drone','Unknown') order by scl_class";
$qry = DBFactory::getDBQuery();
$qry->execute($sql);
while ($row = $qry->getRow()) {
$shipclass[] = new Shipclass($row['scl_id']);
}
$newrow = true;
$ships = array();
foreach ($shipclass as $shp) {
$list = new TopList_CorpKills();
$list->addInvolvedAlliance($this->alliance);
$list->addVictimShipClass($shp);
$table = new TopTable_Corp($list, Language::get('kills'));
$content = $table->generate();
$ships[] = array('name' => $shp->getName(), 'table' => $content);
}
$smarty->assignByRef('ships', $ships);
return $smarty->fetch(get_tpl('detail_kl_ships'));
break;
case "kills_class":
$smarty->assign('title', Language::get('topdestroyedships'));
// Get all ShipClasses
$sql = "select scl_id, scl_class from kb3_ship_classes\n\t\t\t\t\twhere scl_class not in ('Drone','Unknown') order by scl_class";
$qry = DBFactory::getDBQuery();
$qry->execute($sql);
while ($row = $qry->getRow()) {
$shipclass[] = new Shipclass($row['scl_id']);
}
foreach ($shipclass as $shp) {
$list = new TopList_Kills();
$list->addInvolvedAlliance($this->alliance);
$list->addVictimShipClass($shp);
$table = new TopTable_Pilot($list, Language::get('kills'));
$content = $table->generate();
$ships[] = array('name' => $shp->getName(), 'table' => $content);
}
$smarty->assignByRef('ships', $ships);
return $smarty->fetch(get_tpl('detail_kl_ships'));
break;
case "corp_losses_class":
$smarty->assign('title', Language::get('toplostships'));
// Get all ShipClasses
$sql = "select scl_id, scl_class from kb3_ship_classes\n\t\t\t\t\twhere scl_class not in ('Drone','Unknown') order by scl_class";
$qry = DBFactory::getDBQuery();
$qry->execute($sql);
while ($row = $qry->getRow()) {
$shipclass[] = new Shipclass($row['scl_id']);
}
foreach ($shipclass as $shp) {
$list = new TopList_CorpLosses();
$list->addVictimAlliance($this->alliance);
$list->addVictimShipClass($shp);
$table = new TopTable_Corp($list, Language::get('losses'));
$content = $table->generate();
$ships[] = array('name' => $shp->getName(), 'table' => $content);
}
$smarty->assignByRef('ships', $ships);
return $smarty->fetch(get_tpl('detail_kl_ships'));
break;
case "losses_class":
$smarty->assign('title', Language::get('toplostships'));
// Get all ShipClasses
$sql = "select scl_id, scl_class from kb3_ship_classes\n\t\t\t\t\twhere scl_class not in ('Drone','Unknown') order by scl_class";
$qry = DBFactory::getDBQuery();
$qry->execute($sql);
while ($row = $qry->getRow()) {
$shipclass[] = new Shipclass($row['scl_id']);
}
foreach ($shipclass as $shp) {
$list = new TopList_Losses();
$list->addVictimAlliance($this->alliance);
$list->addVictimShipClass($shp);
$table = new TopTable_Pilot($list, Language::get('losses'));
$content = $table->generate();
$ships[] = array('name' => $shp->getName(), 'table' => $content);
}
$smarty->assignByRef('ships', $ships);
return $smarty->fetch(get_tpl('detail_kl_ships'));
break;
case "corp_losses":
$smarty->assign('title', Language::get('toplosers'));
$smarty->assign('month', $this->monthname);
$smarty->assign('year', $this->year);
$smarty->assign('pmonth', $this->pmonth);
$smarty->assign('pyear', $this->pyear);
$smarty->assign('nmonth', $this->nmonth);
$smarty->assign('nyear', $this->nyear);
$smarty->assign('all_id', $this->all_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'corp_losses', true), array('y', $this->pyear, true), array('m', $this->pmonth, true)));
$smarty->assign('url_next', edkURI::build($args, array('view', 'corp_losses', true), array('y', $this->nyear, true), array('m', $this->nmonth, true)));
$list = new TopList_CorpLosses();
$list->addVictimAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Corp($list, Language::get('losses'));
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_CorpLosses();
$list->addVictimAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Corp($list, Language::get('losses'));
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_kills":
$smarty->assign('title', Language::get('topkillers'));
$smarty->assign('month', $this->monthname);
$smarty->assign('year', $this->year);
$smarty->assign('pmonth', $this->pmonth);
$smarty->assign('pyear', $this->pyear);
$smarty->assign('nmonth', $this->nmonth);
$smarty->assign('nyear', $this->nyear);
$smarty->assign('all_id', $this->all_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_kills', true), array('y', $this->pyear, true), array('m', $this->pmonth, true)));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_kills', true), array('y', $this->nyear, true), array('m', $this->nmonth, true)));
$list = new TopList_Kills();
$list->setLimit(30);
$list->addInvolvedAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, Language::get('kills'));
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_Kills();
$list->setLimit(30);
$list->addInvolvedAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Pilot($list, Language::get('kills'));
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_scores":
$smarty->assign('title', Language::get('topscorers'));
$smarty->assign('month', $this->monthname);
$smarty->assign('year', $this->year);
$smarty->assign('pmonth', $this->pmonth);
$smarty->assign('pyear', $this->pyear);
$smarty->assign('nmonth', $this->nmonth);
$smarty->assign('nyear', $this->nyear);
$smarty->assign('all_id', $this->all_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_scores', true), array('y', $this->pyear, true), array('m', $this->pmonth, true)));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_scores', true), array('y', $this->nyear, true), array('m', $this->nmonth, true)));
$list = new TopList_Score();
$list->addInvolvedAlliance($this->alliance);
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, Language::get('top_points'));
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_Score();
$list->addInvolvedAlliance($this->alliance);
$table = new TopTable_Pilot($list, Language::get('top_points'));
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_losses":
$smarty->assign('title', Language::get('toplosers'));
$smarty->assign('month', $this->monthname);
$smarty->assign('year', $this->year);
$smarty->assign('pmonth', $this->pmonth);
$smarty->assign('pyear', $this->pyear);
$smarty->assign('nmonth', $this->nmonth);
$smarty->assign('nyear', $this->nyear);
$smarty->assign('all_id', $this->all_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_losses', true), array('y', $this->pyear, true), array('m', $this->pmonth, true)));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_losses', true), array('y', $this->nyear, true), array('m', $this->nmonth, true)));
$list = new TopList_Losses();
$list->addVictimAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, Language::get('losses'));
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_Losses();
$list->addVictimAlliance($this->alliance);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Pilot($list, Language::get('losses'));
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "ships_weapons":
$view = "ships_weapons";
$shiplist = new TopList_Ship();
$shiplist->addInvolvedAlliance($this->alliance);
$shiplisttable = new TopTable_Ship($shiplist);
$smarty->assign('ships', $shiplisttable->generate());
$weaponlist = new TopList_Weapon();
$weaponlist->addInvolvedAlliance($this->alliance);
$weaponlisttable = new TopTable_Weapon($weaponlist);
$smarty->assign('title', Language::get('ships_weapons'));
$smarty->assign('weapons', $weaponlisttable->generate());
return $smarty->fetch(get_tpl('detail_kl_ships_weapons'));
break;
case 'violent_systems':
$smarty->assign('title', Language::get('topmostviolentsys'));
$smarty->assign('month', $this->monthname);
$smarty->assign('year', $this->year);
$smarty->assign('pmonth', $this->pmonth);
$smarty->assign('pyear', $this->pyear);
$smarty->assign('nmonth', $this->nmonth);
$smarty->assign('nyear', $this->nyear);
$smarty->assign('all_id', $this->all_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'violent_systems', true), array('y', $this->pyear, true), array('m', $this->pmonth, true)));
$smarty->assign('url_next', edkURI::build($args, array('view', 'violent_systems', true), array('y', $this->nyear, true), array('m', $this->nmonth, true)));
$startdate = gmdate('Y-m-d H:i', makeStartDate(0, $this->year, $this->month));
$enddate = gmdate('Y-m-d H:i', makeEndDate(0, $this->year, $this->month));
$sql = "select sys.sys_name, sys.sys_sec, sys.sys_id, count(kll.kll_id) as kills\n\t\t\t\t\t\t\tfrom kb3_systems sys, kb3_kills kll, kb3_inv_all ina\n\t\t\t\t\t\t\twhere kll.kll_system_id = sys.sys_id\n\t\t\t\t\t\t\tand ina.ina_kll_id = kll.kll_id\n\t\t\t\t\t\t\tand ina.ina_all_id = " . $this->all_id;
$sql .= " and kll.kll_timestamp > '{$startdate}'\n\t\t\t\t\t\t\tand kll.kll_timestamp < '{$enddate}'\n\t\t\t\t\t\t\tand ina.ina_timestamp > '{$startdate}'\n\t\t\t\t\t\t\tand ina.ina_timestamp < '{$enddate}'\n\t\t\t\t\t\t\tgroup by sys.sys_id\n\t\t\t\t\t\t\torder by kills desc, sys.sys_name asc\n\t\t\t\t\t\t\tlimit 25";
$qry = DBFactory::getDBQuery();
$qry->execute($sql);
$odd = false;
$counter = 1;
$syslist = array();
while ($row = $qry->getRow()) {
if (!$odd) {
$odd = true;
$rowclass = 'kb-table-row-odd';
} else {
$odd = false;
$rowclass = 'kb-table-row-even';
}
$syslist[] = array("counter" => $counter, "url" => "?a=system_detail&sys_id=" . $row['sys_id'], "name" => $row['sys_name'], "sec" => roundsec($row['sys_sec']), "kills" => (int) $row['kills']);
$counter++;
}
$smarty->assignByRef('syslist', $syslist);
$smarty->assign('monthly_stats', $smarty->fetch(get_tpl(violent_systems)));
$sql = "select sys.sys_name, sys.sys_id, sys.sys_sec, count(kll.kll_id) as kills\n\t\t\t\t\t\t\tfrom kb3_systems sys, kb3_kills kll, kb3_inv_all ina\n\t\t\t\t\t\t\twhere kll.kll_system_id = sys.sys_id\n\t\t\t\t\t\t\tand ina.ina_kll_id = kll.kll_id\n\t\t\t\t\t\t\tand ina.ina_all_id = " . $this->all_id;
$sql .= " group by sys.sys_id\n\t\t\t\t\t\t\torder by kills desc, sys.sys_name asc\n\t\t\t\t\t\t\tlimit 25";
$qry = DBFactory::getDBQuery();
$qry->execute($sql);
$odd = false;
$counter = 1;
$syslist = array();
while ($row = $qry->getRow()) {
if (!$odd) {
$odd = true;
$rowclass = 'kb-table-row-odd';
} else {
$odd = false;
$rowclass = 'kb-table-row-even';
}
$syslist[] = array("counter" => $counter, "url" => "?a=system_detail&sys_id=" . $row['sys_id'], "name" => $row['sys_name'], "sec" => roundsec($row['sys_sec']), "kills" => (int) $row['kills']);
$counter++;
}
$smarty->assignByRef('syslist', $syslist);
$smarty->assign('total_stats', $smarty->fetch(get_tpl(violent_systems)));
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case 'corp_list':
return $this->corpList();
break;
case 'history':
$allsum = new allianceSummary($this->alliance);
$smarty->assign('title', Language::get('history'));
$smarty->assign('summary', $allsum->getMonthlySummary());
return $smarty->fetch(get_tpl('detail_history'));
break;
}
return '';
}