/**
* Build the summary table showing all kills and losses for the contract.
*/
function summaryTable()
{
$klist = $this->contract->getKillList();
$llist = $this->contract->getLossList();
$killsummary = new KillSummaryTable($klist, $llist);
if ($view == "") {
$killsummary->setFilter(false);
}
return $killsummary->generate();
}
popup| <?php
/**
* @package EDK
*/
require_once 'mods/forum_post/class.killsummarytable.php';
if (isset($_GET['ctr_id'])) {
$ctr_id = intval($_GET['ctr_id']);
$contract = new Contract($ctr_id);
$klist = $contract->getKillList();
$llist = $contract->getLossList();
$killsummary = new KillSummaryTable($klist, $llist);
$killsummary->setBreak(6);
if ($_GET['view'] == "") {
$killsummary->setFilter(false);
}
$name = $contract->getName();
}
if (isset($_GET['kll_id'])) {
$kll_id = intval($_GET['kll_id']);
// this is a fast query to get the system and timestamp
$rqry = DBFactory::getDBQuery();
$rsql = 'SELECT kll_timestamp, kll_system_id from kb3_kills where kll_id = ' . $kll_id;
$rqry->execute($rsql);
$rrow = $rqry->getRow();
$system = new SolarSystem($rrow['kll_system_id']);
// now we get all kills in that system for +-12 hours
$query = 'SELECT kll.kll_timestamp AS ts FROM kb3_kills kll WHERE kll.kll_system_id=' . $rrow['kll_system_id'] . '
AND kll.kll_timestamp <= date_add( \'' . $rrow['kll_timestamp'] . '\', INTERVAL \'12\' HOUR )
AND kll.kll_timestamp >= date_sub( \'' . $rrow['kll_timestamp'] . '\', INTERVAL \'12\' HOUR )
ORDER BY kll.kll_timestamp ASC';
$qry = DBFactory::getDBQuery();
