function generate()
{
global $smarty;
if ($table = $this->getTableStats()) {
// filtering
$solarSystem = SolarSystem::lookup($this->filterSystemName);
$smarty->assign('contract_getactive', 1);
$smarty->assign('version', config::get('fleet_battles_mod_version'));
$stats = array();
if (!config::get('fleet_battles_mod_cache')) {
$smarty->assign('caching', 0);
$stats['tbattles'] = $this->metric_total;
$stats['ainvolved'] = $this->inv_all_time;
$stats['akills'] = $this->kll_all_time;
$stats['alosses'] = $this->lss_all_time;
$stats['akillisk'] = $this->kll_isk_all_time;
$stats['alossisk'] = $this->lss_isk_all_time;
} else {
$smarty->assign('caching', 1);
$statq = DBFactory::getDBQuery();
$whereSql = "";
if ($this->isFiltered) {
$filterTerms = $this->getFilterArgumentsWhereSql();
// build filter-string
if (!empty($filterTerms)) {
$whereSql = "WHERE " . implode(" AND ", $filterTerms);
}
}
$statsql = "SELECT \n COUNT(*) as tbattles, SUM(involved) as ainvolved, SUM(losses) as alosses, SUM(kills) as akills, SUM(killisk) as akillisk, SUM(lossisk) as alossisk, SUM(ownersInvolved) as ainvolvedowners\n FROM kb3_battles_cache bc\n INNER JOIN kb3_systems sys ON sys.sys_name = bc.system\n INNER JOIN kb3_constellations con ON con.con_id = sys.sys_con_id\n INNER JOIN kb3_regions reg ON reg.reg_id = con.con_reg_id\n {$whereSql}";
$statq->execute($statsql);
$stats = $statq->getRow();
}
$smarty->assign('tbattles', $stats['tbattles']);
$smarty->assign('ainvolved', $stats['ainvolved'] / $stats['tbattles']);
$smarty->assign('akills', $stats['akills'] / $stats['tbattles']);
$smarty->assign('alosses', $stats['alosses'] / $stats['tbattles']);
$smarty->assign('ainvolvedowners', $stats['ainvolvedowners'] / $stats['tbattles']);
$stats['aefficiency'] = round($stats['akillisk'] / ($stats['akillisk'] + $stats['alossisk']) * 100, 2);
$stats['abar'] = new BarGraph($stats['aefficiency'], 100, 75);
$smarty->assign('abar', $stats['abar']->generate());
$smarty->assign('aefficiency', $stats['aefficiency']);
// filter
$smarty->assign("filterSystem", $this->filterSystemName);
$smarty->assign("filterRegionId", $this->filterRegionId);
$smarty->assign("filterMonthSelected", $this->filterMonth);
$smarty->assign("filterKillsComparatorSelected", $this->filterKillsComparator);
$smarty->assign("filterKillsCount", $this->filterKillsCount);
$smarty->assign("filterLossesComparatorSelected", $this->filterLossesComparator);
$smarty->assign("filterLossesCount", $this->filterLossesCount);
$smarty->assign("filterEfficiencyComparatorSelected", $this->filterEfficiencyComparator);
$smarty->assign("filterEfficiencyCount", $this->filterEfficiencyCount);
$smarty->assign("filterInvolvedOwnersComparatorSelected", $this->filterInvolvedOwnersComparator);
$smarty->assign("filterInvolvedOwnersCount", $this->filterInvolvedOwnersCount);
$smarty->assign("filterRegions", array_merge(array(array("name" => "All", "id" => -1)), $this->getRegions()));
$smarty->assign("filterMonths", array_merge(array(array("name" => "All", "month" => "1-1")), $this->getMonths()));
$smarty->assign("filterMonths", array_merge(array(array("name" => "All", "month" => "1-1")), $this->getMonths()));
$filterKillsCompatators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$filterLossesComparators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$filterEfficiencyComparators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$filterInvolvedOwnersComparators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$smarty->assign("filterKillsComparators", $filterKillsCompatators);
$smarty->assign("filterLossesComparators", $filterLossesComparators);
$smarty->assign("filterEfficiencyComparators", $filterEfficiencyComparators);
$smarty->assign("filterInvolvedOwnersComparators", $filterInvolvedOwnersComparators);
if (config::get('fleet_battles_mod_displaymetrics')) {
$smarty->assign('minkills', config::get('fleet_battles_mod_minkills'));
$smarty->assign('minisk', config::get('fleet_battles_mod_minisk'));
$smarty->assign('maxtime', config::get('fleet_battles_mod_maxtime'));
}
if (config::get('fleet_battles_mod_cache') && !$this->isFiltered) {
// paginate
if (is_numeric($this->poffset_) && is_numeric($this->plimit_) && $this->plimit_ > 0) {
$table = array_slice($table, $this->poffset_, $this->plimit_);
}
}
$smarty->assign_by_ref('battles', $table);
return $smarty->fetch(dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'template' . DIRECTORY_SEPARATOR . 'battlelisttable_filter.tpl') . $smarty->fetch(dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'template' . DIRECTORY_SEPARATOR . 'battlelisttable.tpl');
} else {
$smarty->assign('tbattles', 0);
$smarty->assign('ainvolved', 0);
$smarty->assign('akills', 0);
$smarty->assign('alosses', 0);
$smarty->assign('ainvolvedowners', 0);
$stats['aefficiency'] = 0;
$stats['abar'] = new BarGraph(0, 100, 75);
$smarty->assign('abar', $stats['abar']->generate());
$smarty->assign('aefficiency', 0);
$smarty->assign('battles', array());
// filter
$smarty->assign("filterSystem", $this->filterSystemName);
$smarty->assign("filterRegionId", $this->filterRegionId);
$smarty->assign("filterMonthSelected", $this->filterMonth);
$smarty->assign("filterKillsComparatorSelected", $this->filterKillsComparator);
$smarty->assign("filterKillsCount", $this->filterKillsCount);
$smarty->assign("filterLossesComparatorSelected", $this->filterLossesComparator);
$smarty->assign("filterLossesCount", $this->filterLossesCount);
$smarty->assign("filterEfficiencyComparatorSelected", $this->filterEfficiencyComparator);
$smarty->assign("filterEfficiencyCount", $this->filterEfficiencyCount);
$smarty->assign("filterInvolvedOwnersComparatorSelected", $this->filterInvolvedOwnersComparator);
$smarty->assign("filterInvolvedOwnersCount", $this->filterInvolvedOwnersCount);
$smarty->assign("filterRegions", array_merge(array(array("name" => "All", "id" => -1)), $this->getRegions()));
$smarty->assign("filterMonths", array_merge(array(array("name" => "All", "month" => "1-1")), $this->getMonths()));
$smarty->assign("filterMonths", array_merge(array(array("name" => "All", "month" => "1-1")), $this->getMonths()));
$filterKillsCompatators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$filterLossesComparators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$filterEfficiencyComparators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$filterInvolvedOwnersComparators = array(array("name" => "gt", "symbol" => ">="), array("name" => "lt", "symbol" => "<="));
$smarty->assign("filterKillsComparators", $filterKillsCompatators);
$smarty->assign("filterLossesComparators", $filterLossesComparators);
$smarty->assign("filterEfficiencyComparators", $filterEfficiencyComparators);
$smarty->assign("filterInvolvedOwnersComparators", $filterInvolvedOwnersComparators);
return $smarty->fetch(dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'template' . DIRECTORY_SEPARATOR . 'battlelisttable_filter.tpl') . $smarty->fetch(dirname(__FILE__) . DIRECTORY_SEPARATOR . '..' . DIRECTORY_SEPARATOR . 'template' . DIRECTORY_SEPARATOR . 'battlelisttable.tpl');
}
}
function parse($checkauth = true)
{
$qry = DBFactory::getDBQuery();
$timestamp = substr($this->killmail_, 0, 16);
$timestamp = str_replace('.', '-', $timestamp);
//trim out any multiple spaces that may exist -
//$this->killmail_ = preg_replace('/ +/', ' ', $this->killmail_);
// header section
$involvedpos = strpos($this->killmail_, "Involved parties:");
if ($involvedpos == 0) {
$this->error("Mail lacks Involved parties header.");
return 0;
}
$header = substr($this->killmail_, 0, $involvedpos);
$timestamp = substr($header, 0, 16);
$victim = explode("\n", trim(substr($this->killmail_, 0, $involvedpos)));
$upper_limit = count($victim);
$victimname = "Unknown";
//lovely default values
$factionname = "None";
$alliancename = "None";
$corpname = "Unknown";
$shipname = "Unknown";
$systemname = "Unknown";
$systemsec = "0.0";
$dmgtaken = '0';
$this->dmgtaken = '0';
$pos = 0;
$moon = "";
for ($counter = 0; $counter <= $upper_limit; $counter++) {
if (preg_match("/Victim: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
$victimname = $matches[1];
}
} elseif (preg_match("/Corp: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
$corpname = $matches[1];
}
} elseif (preg_match("/Alliance: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
$alliancename = $matches[1];
}
if ($alliancename == "Unknown") {
$alliancename = "None";
}
} elseif (preg_match("/Faction: (.*)/", $victim[$counter], $matches)) {
if (strlen($matches[1]) > 5 && $matches[1] != "Unknown") {
//catches faction mails from -A-
$factionname = $matches[1];
} else {
$factionname = "None";
}
} elseif (preg_match("/Destroyed: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
$shipname = $matches[1];
}
} elseif (preg_match("/System: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
//bad assumption here - moon has to come before security.
$systemname = $matches[1];
if (strcmp($moon, 'Unknown') == 0 && $pos == 1) {
$moon = $matches[1];
$victimname = $matches[1];
}
}
} elseif (preg_match("/Security: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
$systemsec = (double) $matches[1];
}
} elseif (preg_match("/Damage Taken: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
$dmgtaken = (int) $matches[1];
$this->dmgtaken = $dmgtaken;
}
} elseif (preg_match("/Moon: (.*)/", $victim[$counter], $matches)) {
if ($matches[1]) {
$moon = $matches[1];
$victimname = $matches[1];
$pos = 1;
} else {
//if the system is valid, it will pick this up, provided it features after
//the moon is listed - which is unlikely unless the mail format
//drastically changes... again :)
$moon = 'Unknown';
$victimname = 'Unknown';
$pos = 1;
}
}
}
//faction warfare stuff
if (strcasecmp($alliancename, 'None') == 0) {
$alliancename = $factionname;
}
//report the errors for the things that make sense.
//we need pilot names, corp names, ship types, and the system to be sure
//the rest aren't required but for completeness, you'd want them in :)
// Customs Offices don't have names. Hack a fix in by accepting mails with
// no victim name but that do have a system.
if (strcmp($victimname, 'Unknown') == 0) {
if (strcmp($systemname, 'Unknown') == 0) {
$this->error('Victim has no name.');
unset($victimname);
//we unset the variable so that it fails the next check
$this->error('Killmail lacks solar system information.');
unset($systemname);
} else {
$victimname = $systemname;
}
}
if (strcmp($corpname, 'Unknown') == 0) {
$this->error('Victim has no corp.');
unset($corpname);
}
if (strcmp($shipname, 'Unknown') == 0) {
$this->error('Victim has no ship type.');
unset($shipname);
}
if (strcmp($systemname, 'Unknown') == 0) {
$this->error('Killmail lacks solar system information.');
unset($systemname);
}
if ($pos == 1) {
$victimname = $moon;
}
if (!isset($timestamp) || !isset($factionname) || !isset($alliancename) || !isset($corpname) || !isset($victimname) || !isset($shipname) || !isset($systemname) || !isset($systemsec)) {
return 0;
}
if ($checkauth) {
$authorized = false;
} else {
$authorized = true;
}
// populate/update database
$alliance = $this->fetchAlliance($alliancename);
$corp = $this->fetchCorp($corpname, $alliance, $timestamp);
$victim = $this->fetchPilot($victimname, $corp, $timestamp);
$system = SolarSystem::lookup($systemname);
if (!$system || !$system->getID()) {
$this->error('System not found.', $systemname);
$system = new SolarSystem();
}
$ship = Ship::lookup($shipname);
if (!$ship || !$ship->getID()) {
$this->error('Ship not found.', $shipname);
$ship = new Ship();
}
$kill = new Kill();
if ($this->externalID) {
$kill->setExternalID($this->externalID);
}
$kill->setTimeStamp($timestamp);
$kill->setVictim($victim);
$kill->setVictimID($victim->getID());
$kill->setVictimCorpID($corp->getID());
$kill->setVictimAllianceID($alliance->getID());
$kill->setVictimShip($ship);
$kill->setSolarSystem($system);
if ($dmgtaken) {
$kill->set('dmgtaken', $dmgtaken);
}
if (config::get('cfg_allianceid') && in_array($alliance->getID(), config::get('cfg_allianceid'))) {
$authorized = true;
} elseif (config::get('cfg_corpid') && in_array($corp->getID(), config::get('cfg_corpid'))) {
$authorized = true;
} elseif (config::get('cfg_pilotid') && in_array($victim->getID(), config::get('cfg_pilotid'))) {
$authorized = true;
}
// involved parties section
$end = strpos($this->killmail_, "Destroyed items:");
if ($end == 0) {
$end = strpos($this->killmail_, "Dropped items:");
if ($end == 0) {
//try to parse to the end of the mail in the event sections are missing
$end = strlen($this->killmail_);
}
}
$involved = explode("\n", trim(substr($this->killmail_, strpos($this->killmail_, "Involved parties:") + 17, $end - (strpos($this->killmail_, "Involved parties:") + 17))));
$ipilot_count = 0;
//allows us to be a bit more specific when errors strike
$i = 0;
$topdamage = 0;
$order = 0;
while ($i < count($involved)) {
$iparts = count($involved);
$finalblow = 0;
while ($i < $iparts) {
$ipilot_count++;
$ipname = "Unknown";
$ianame = "None";
$ifname = "None";
$icname = "None";
$isname = "Unknown";
$iwname = "Unknown";
$idmgdone = '0';
$secstatus = "0.0";
while ($involved[$i] == '') {
//compensates for multiple blank lines between involved parties
$i++;
if ($i > count($involved)) {
$this->error("Involved parties section prematurely ends.");
return 0;
}
}
for ($counter = $i; $counter <= $iparts; $counter++) {
if (preg_match("/Name: (.*)/", $involved[$counter], $matches)) {
if ($matches[1]) {
if (stristr($involved[$counter], '/')) {
$slash = strpos($involved[$counter], '/');
$name = trim(substr($involved[$counter], 5, $slash - 5));
$corporation = trim(substr($involved[$counter], $slash + 1, strlen($involved[$counter]) - $slash + 1));
//now if the corp bit has final blow info, note it
preg_match("/(.*) \\(laid the final blow\\)/", $corporation, $matched);
if ($matched[1]) {
$finalblow = 1;
$iwname = $name;
$end = strpos($corporation, '(') - 1;
$corporation = substr($corporation, 0, $end);
} else {
$finalblow = 0;
$iwname = $name;
}
//alliance lookup for warp disruptors - normal NPCs aren't to be bundled in
$crp = $this->fetchCorp($corporation);
if ($crp && $crp->getExternalID(true) > 0) {
if ($crp->fetchCorp()) {
$al = $crp->getAlliance();
$alName = $al->getName();
if (trim($alName) != "") {
$ianame = $al->getName();
}
}
// else check db for kills with that corp at the same time?
}
$ipname = $name;
$icname = $corporation;
} else {
$ipname = $matches[1];
preg_match("/(.*)\\s*\\(laid the final blow\\)/", $ipname, $matches);
if (isset($matches[1])) {
$ipname = trim($matches[1]);
$finalblow = 1;
} else {
$finalblow = 0;
}
}
}
} else {
if (preg_match("/Alliance: (.*)/", $involved[$counter], $matches)) {
if ($matches[1]) {
$ianame = $matches[1];
}
if ($ianame == "Unknown") {
$ianame = "None";
}
} else {
if (preg_match("/Faction: (.*)/", $involved[$counter], $matches)) {
if (strlen($matches[1]) > 5 && $matches[1] != "Unknown") {
//catches faction mails from -A-
$ifname = $matches[1];
} else {
$ifname = "NONE";
}
} else {
if (preg_match("/Corp: (.*)/", $involved[$counter], $matches)) {
if ($matches[1]) {
$icname = $matches[1];
}
} else {
if (preg_match("/Ship: (.*)/", $involved[$counter], $matches)) {
if ($matches[1]) {
$isname = $matches[1];
}
} else {
if (preg_match("/Weapon: (.*)/", $involved[$counter], $matches)) {
if ($matches[1]) {
$iwname = $matches[1];
}
} else {
if (preg_match("/Security: (.*)/", $involved[$counter], $matches)) {
if ($matches[1]) {
$secstatus = (double) $matches[1];
}
} else {
if (preg_match("/Damage Done: (.*)/", $involved[$counter], $matches)) {
if ($matches[1]) {
$idmgdone = (int) $matches[1];
}
if ($idmgdone > $topdamage) {
$topdamage = $idmgdone;
}
} else {
if ($involved[$counter] == '') {
//allows us to process the involved party. This is the empty line after the
//involved party section
$counter++;
$i = $counter;
break;
} else {
//skip over this entry, it could read anything, we don't care. Handy if/when
//new mail fields get added and we aren't handling them yet.
$counter++;
$i = $counter;
}
}
}
}
}
}
}
}
}
if ($this->needs_final_blow_) {
$finalblow = 1;
$this->needs_final_blow_ = 0;
}
}
// Faction Warfare stuff
if (strcasecmp($ianame, "None") == 0) {
$ianame = $ifname;
}
// end faction warfare stuff
$ialliance = $this->fetchAlliance($ianame);
if (strcmp($icname, 'None') == 0) {
//don't add corp, because pilots have to be in corps.
$this->error('Involved party has no corp. (Party No. ' . $ipilot_count . ')');
$icorp = new Corporation();
} else {
$icorp = $this->fetchCorp($icname, $ialliance, $kill->getTimeStamp());
}
if (preg_match("/^(Mobile \\w+ Warp|\\w+ Control Tower( \\w+)?)/", $iwname)) {
//for involved parties parsed that lack a pilot, but are actually POS or mobile warp disruptors
$ipname = $icname . ' - ' . $iwname;
$ipilot = $this->fetchPilot($ipname, $icorp, $timestamp);
} elseif (strcmp($ipname, 'Unknown') == 0 || empty($ipname)) {
$ipilot = new Pilot();
$this->error('Involved party has no name. (Party No. ' . $ipilot_count . ')');
} else {
//don't add pilot if the pilot's unknown or dud
$ipilot = $this->fetchPilot($ipname, $icorp, $timestamp);
}
$iship = Ship::lookup($isname);
if (!$iship || !$iship->getName()) {
$this->error('Ship not found.', $isname);
}
if (strcmp($iwname, 'Unknown') == 0 && $iship && $iship->getID()) {
$iwname = $iship->getName();
}
$iweapon = Item::lookup($iwname);
if (strcmp($iwname, 'Unknown') == 0) {
$this->error('No weapon found for pilot "' . $ipname . '"');
$iweapon = new Item();
} else {
if (!$iweapon || !$iweapon->getID()) {
$this->error('Weapon not found.', $iwname);
$iweapon = new Item();
}
}
if (config::get('cfg_allianceid') && in_array($ialliance->getID(), config::get('cfg_allianceid'))) {
$authorized = true;
} elseif (config::get('cfg_corpid') && in_array($icorp->getID(), config::get('cfg_corpid'))) {
$authorized = true;
} elseif (config::get('cfg_pilotid') && in_array($ipilot->getID(), config::get('cfg_pilotid'))) {
$authorized = true;
}
if (!$authorized) {
if ($string = config::get('post_permission')) {
if ($string == 'all') {
$authorized = true;
} else {
$tmp = explode(',', $string);
foreach ($tmp as $item) {
if (!$item) {
continue;
}
$typ = substr($item, 0, 1);
$id = substr($item, 1);
if ($typ == 'a') {
if ($ialliance->getID() == $id || $kill->getVictimAllianceID() == $id) {
$authorized = true;
break;
}
} elseif ($typ == 'c') {
if ($icorp->getID() == $id || $kill->getVictimCorpID() == $id) {
$authorized = true;
break;
}
} elseif ($typ == 'p') {
if ($ipilot->getID() == $id || $kill->getVictimID() == $id) {
$authorized = true;
break;
}
}
}
}
}
}
$iparty = new InvolvedParty($ipilot->getID(), $icorp->getID(), $ialliance->getID(), $secstatus, $iship->getID(), $iweapon->getID(), $idmgdone);
$kill->addInvolvedParty($iparty);
if ($finalblow == 1) {
$kill->setFBPilotID($ipilot->getID());
$kill->setFBCorpID($icorp->getID());
$kill->setFBAllianceID($ialliance->getID());
}
if ($topdamage == $idmgdone) {
$kill->setTDPilotID($ipilot->getID());
$kill->setFBCorpID($icorp->getID());
$kill->setFBAllianceID($ialliance->getID());
}
}
}
// Duplicate check does not use items so it's safe to check now
if ($id = $kill->getDupe()) {
$this->dupeid_ = $id;
if ($this->dupeid_ > 0 && $this->externalID) {
//if this is a duplicate and we have an external id then update the existing kill
$qry->execute("UPDATE kb3_kills SET kll_external_id = " . $this->externalID . " WHERE kll_id = " . $this->dupeid_);
$qry->execute("UPDATE kb3_mails SET kll_external_id = " . $this->externalID . ", kll_modified_time = UTC_TIMESTAMP() " . "WHERE kll_id = " . $this->dupeid_ . " AND kll_external_id IS NULL");
}
return -1;
}
// destroyed items section
$destroyedpos = strpos($this->killmail_, "Destroyed items:");
if ($destroyedpos) {
$endpos = strlen($this->killmail_) - $destroyedpos + 16;
$pos = strpos($this->killmail_, "Dropped items:");
if ($pos === false) {
$pos = strlen($this->killmail_);
}
$endpos = $pos - $destroyedpos - 16;
$destroyed = explode("\n", trim(substr($this->killmail_, $destroyedpos + 16, $endpos)));
$destroyed_items = $this->scanForItems($destroyed);
foreach ($destroyed_items as $item) {
$ditem = new DestroyedItem($item['item'], $item['quantity'], '', $item['location'], true);
$kill->addDestroyedItem($ditem);
}
}
$startpos = strpos($this->killmail_, "Dropped items:");
if ($startpos) {
$endpos = strlen($this->killmail_) - $startpos + 14;
$dropped = explode("\n", trim(substr($this->killmail_, $startpos + 14, $endpos)));
$dropped_items = $this->scanForItems($dropped);
foreach ($dropped_items as $item) {
$ditem = new DestroyedItem($item['item'], $item['quantity'], '', $item['location'], true);
$kill->addDroppedItem($ditem);
}
}
if (!$authorized) {
return -2;
}
if ($this->getError()) {
return 0;
}
if ($this->returnmail) {
return $kill;
}
$id = $kill->add();
if ($id == -2) {
$this->error("An error has occurred. Please try again later.");
$id = 0;
}
return $id;
}