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();
}
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();
}
asort($kills);
$cnt = 0;
foreach ($kills as $id => $timestamp) {
/**
* Build the killlists that are needed for the options selected.
*/
function killList()
{
global $smarty;
if (isset($this->viewList[$this->view])) {
return call_user_func_array($this->viewList[$this->view], array(&$this));
}
$args = array();
if ($this->crp_external_id) {
$args[] = array('crp_ext_id', $this->crp_external_id, true);
} else {
$args[] = array('crp_id', $this->crp_id, true);
}
$pyear = array('y', $this->pyear, true);
$nyear = array('y', $this->nyear, true);
$pmonth = array('m', $this->pmonth, true);
$nmonth = array('m', $this->nmonth, true);
switch ($this->view) {
case "":
$list = new KillList();
$list->setOrdered(true);
$list->setLimit(10);
$list->addInvolvedCorp($this->crp_id);
if ($this->scl_id) {
$list->addVictimShipClass($this->scl_id);
} else {
$list->setPodsNoobShips(config::get('podnoobs'));
}
if (config::get('comments_count')) {
$list->setCountComments(true);
}
if (config::get('killlist_involved')) {
$list->setCountInvolved(true);
}
$ktab = new KillListTable($list);
$ktab->setLimit(10);
$smarty->assign('kills', $ktab->generate());
$list = new KillList();
$list->setOrdered(true);
$list->setLimit(10);
$list->addVictimCorp($this->crp_id);
if ($this->scl_id) {
$list->addVictimShipClass($this->scl_id);
} else {
$list->setPodsNoobShips(config::get('podnoobs'));
}
if (config::get('comments_count')) {
$list->setCountComments(true);
}
if (config::get('killlist_involved')) {
$list->setCountInvolved(true);
}
$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->addInvolvedCorp($this->crp_id);
if ($this->scl_id) {
$list->addVictimShipClass($this->scl_id);
} else {
$list->setPodsNoobShips(config::get('podnoobs'));
}
$list->setPageSplit(config::get('killcount'));
$pagesplitter = new PageSplitter($list->getCount(), config::get('killcount'));
$table = new KillListTable($list);
$smarty->assign('splitter', $pagesplitter->generate());
$smarty->assign('kills', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_kills'));
break;
case "losses":
$list = new KillList();
$list->setOrdered(true);
$list->addVictimCorp($this->crp_id);
if ($this->scl_id) {
$list->addVictimShipClass($this->scl_id);
} else {
$list->setPodsNoobShips(config::get('podnoobs'));
}
$list->setPageSplit(config::get('killcount'));
$pagesplitter = new PageSplitter($list->getCount(), config::get('killcount'));
$table = new KillListTable($list);
$smarty->assign('splitter', $pagesplitter->generate());
$smarty->assign('losses', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_losses'));
break;
case "pilot_kills":
$smarty->assign('title', 'Top Killers');
$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('crp_id', $this->crp_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_kills', true), $pyear, $pmonth));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_kills', true), $nyear, $nmonth));
$list = new TopList_Kills();
$list->setLimit(30);
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, "Kills");
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_Kills();
$list->setLimit(30);
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Pilot($list, "Kills");
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_scores":
$smarty->assign('title', 'Top Scorers');
$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('crp_id', $this->crp_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_scores', true), $pyear, $pmonth));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_scores', true), $nyear, $nmonth));
$list = new TopList_Score();
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, "Points");
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_Score();
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Pilot($list, "Points");
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_solo":
$smarty->assign('title', 'Top Solokillers');
$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('crp_id', $this->crp_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_solo', true), $pyear, $pmonth));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_solo', true), $nyear, $nmonth));
$list = new TopList_SoloKiller();
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, "Solokills");
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_SoloKiller();
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Pilot($list, "Solokills");
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_damage":
$smarty->assign('title', 'Top Damagedealers');
$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('crp_id', $this->crp_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_damage', true), $pyear, $pmonth));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_damage', true), $nyear, $nmonth));
$list = new TopList_DamageDealer();
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, "Kills");
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_DamageDealer();
$list->addInvolvedCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Pilot($list, "Kills");
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_griefer":
$smarty->assign('title', 'Top Griefers');
$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('crp_id', $this->crp_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_griefer', true), $pyear, $pmonth));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_griefer', true), $nyear, $nmonth));
$list = new TopList_Kills();
$list->addVictimShipClass(20);
// freighter
$list->addVictimShipClass(22);
// exhumer
$list->addVictimShipClass(7);
// industrial
$list->addVictimShipClass(12);
// barge
$list->addVictimShipClass(14);
// transport
$list->addInvolvedCorp($this->crp_id);
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, "Kills");
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_Kills();
$list->addVictimShipClass(20);
// freighter
$list->addVictimShipClass(22);
// exhumer
$list->addVictimShipClass(7);
// industrial
$list->addVictimShipClass(12);
// barge
$list->addVictimShipClass(14);
// transport
$list->addInvolvedCorp($this->crp_id);
$table = new TopTable_Pilot($list, "Kills");
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "pilot_losses":
$smarty->assign('title', 'Top Losers');
$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('crp_id', $this->crp_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'pilot_losses', true), $pyear, $pmonth));
$smarty->assign('url_next', edkURI::build($args, array('view', 'pilot_losses', true), $nyear, $nmonth));
$list = new TopList_Losses();
$list->addVictimCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$list->setMonth($this->month);
$list->setYear($this->year);
$table = new TopTable_Pilot($list, "Losses");
$smarty->assign('monthly_stats', $table->generate());
$list = new TopList_Losses();
$list->addVictimCorp($this->crp_id);
$list->setPodsNoobShips(config::get('podnoobs'));
$table = new TopTable_Pilot($list, "Losses");
$smarty->assign('total_stats', $table->generate());
return $smarty->fetch(get_tpl('detail_kl_monthly'));
break;
case "ships_weapons":
$shiplist = new TopList_Ship();
$shiplist->addInvolvedCorp($this->crp_id);
$shiplisttable = new TopTable_Ship($shiplist);
$smarty->assign('ships', $shiplisttable->generate());
$weaponlist = new TopList_Weapon();
$weaponlist->addInvolvedCorp($this->crp_id);
$weaponlisttable = new TopTable_Weapon($weaponlist);
$smarty->assign('weapons', $weaponlisttable->generate());
return $smarty->fetch(get_tpl('detail_kl_ships_weapons'));
break;
case 'history':
$crpsum = new corpSummary($this->crp_id);
$smarty->assign('title', Language::get('history'));
$smarty->assign('summary', $crpsum->getMonthlySummary());
return $smarty->fetch(get_tpl('detail_history'));
break;
case 'violent_systems':
$smarty->assign('title', 'Most violent systems');
$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('crp_id', $this->crp_id);
$smarty->assign('url_previous', edkURI::build($args, array('view', 'violent_systems', true), $pyear, $pmonth));
$smarty->assign('url_next', edkURI::build($args, array('view', 'violent_systems', true), $nyear, $nmonth));
$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_crp inc\n\t\t\t\t\t\t\twhere kll.kll_system_id = sys.sys_id\n\t\t\t\t\t\t\tand inc.inc_kll_id = kll.kll_id\n\t\t\t\t\t\t\tand inc.inc_crp_id = " . $this->crp_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 inc.inc_timestamp > '{$startdate}'\n\t\t\t\t\t\t\tand inc.inc_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" => edkURI::build(array(array('a', 'system_detail', true), array('sys_id', $row['sys_id'], true))), "name" => $row['sys_name'], "sec" => roundsec($row['sys_sec']), "kills" => $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_crp inc\n\t\t\t\t\t\t\twhere kll.kll_system_id = sys.sys_id\n\t\t\t\t\t\t\tand inc.inc_kll_id = kll.kll_id\n\t\t\t\t\t\t\tand inc.inc_crp_id = " . $this->crp_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" => edkURI::build(array(array('a', 'system_detail', true), array('sys_id', $row['sys_id'], true))), "name" => $row['sys_name'], "sec" => roundsec($row['sys_sec']), "kills" => $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;
}
return $html;
}