$extra['shipprice'] = Price::getItemPrice($killdata['victim']['shipTypeID'], date('Ymd', strtotime($killdata['info']['dttm']))); $extra['lostisk'] = $extra['shipprice'] + destroyedIsk(md5($id), $killdata['items']); $extra['fittedisk'] = fittedIsk(md5($id), $killdata['items']); $extra['relatedtime'] = date('YmdH00', strtotime($killdata['info']['dttm'])); $extra['fittingwheel'] = Detail::eftarray(md5($id), $killdata['items'], @$killdata['victim']['characterID']); $extra['involvedships'] = involvedships($killdata['involved']); $extra['involvedshipscount'] = count($extra['involvedships']); $extra['totalprice'] = usdeurgbp($killdata['info']['zkb']['totalValue']); $extra['destroyedprice'] = usdeurgbp($extra['lostisk']); $extra['droppedprice'] = usdeurgbp($extra['droppedisk']); $extra['fittedprice'] = usdeurgbp($extra['fittedisk']); $extra['efttext'] = Fitting::EFT($extra['fittingwheel']); $extra['dnatext'] = Fitting::DNA($killdata['items'], $killdata['victim']['shipTypeID']); $extra['edkrawmail'] = 'deprecated - use CREST'; $extra['zkbrawmail'] = 'deprecated - use CREST'; $extra['slotCounts'] = Info::getSlotCounts($killdata['victim']['shipTypeID']); $extra['commentID'] = $id; $extra['crest'] = $mdb->findDoc('crestmails', ['killID' => $id, 'processed' => true]); $extra['prevKillID'] = $mdb->findField('killmails', 'killID', ['cacheTime' => 300, 'killID' => ['$lt' => $id]], ['killID' => -1]); $extra['nextKillID'] = $mdb->findField('killmails', 'killID', ['cacheTime' => 300, 'killID' => ['$gt' => $id]], ['killID' => 1]); $extra['warInfo'] = War::getKillIDWarInfo($id); //$extra["insertTime"] = Db::queryField("select insertTime from zz_killmails where killID = :killID", "insertTime", array(":killID" => $id), 300); $systemID = $killdata['info']['system']['solarSystemID']; $data = Info::getWormholeSystemInfo($systemID); $extra['wormhole'] = $data; $url = 'https://' . $_SERVER['SERVER_NAME'] . "/detail/{$id}/"; if ($killdata['victim']['groupID'] == 29) { $query = ['$and' => [['involved.characterID' => (int) $killdata['victim']['characterID']], ['killID' => ['$gte' => $id - 200]], ['killID' => ['$lt' => $id]], ['vGroupID' => ['$ne' => 29]]]]; $relatedKill = $mdb->findDoc('killmails', $query); if ($relatedKill) { $relatedShip = ['killID' => $relatedKill['killID'], 'shipTypeID' => $relatedKill['involved'][0]['shipTypeID']];
$extra["lostisk"] = $killdata["info"]["total_price"] - $extra["droppedisk"]; $extra["fittedisk"] = fittedIsk(md5($id), $killdata["items"]); $extra["relatedtime"] = date("YmdH00", strtotime($killdata["info"]["killTime"])); $extra["fittingwheel"] = eftarray(md5($id), $killdata["items"], $killdata["victim"]["characterID"]); $extra["involvedships"] = involvedships($killdata["involved"]); $extra["involvedshipscount"] = count($extra["involvedships"]); $extra["totalprice"] = usdeurgbp($killdata["info"]["total_price"]); $extra["destroyedprice"] = usdeurgbp($extra["lostisk"]); $extra["droppedprice"] = usdeurgbp($extra["droppedisk"]); $extra["fittedprice"] = usdeurgbp($extra["fittedisk"]); $extra["efttext"] = Fitting::EFT($extra["fittingwheel"]); $extra["dnatext"] = Fitting::DNA($killdata["items"], $killdata["info"]["shipTypeID"]); $extra["edkrawmail"] = Kills::getRawMail($id); $extra["zkbrawmail"] = Kills::getRawMail($id, array(), false); $extra["reports"] = Db::queryField("SELECT count(*) as cnt FROM zz_tickets WHERE killID = :killid", "cnt", array(":killid" => $id), 0); $extra["slotCounts"] = Info::getSlotCounts($killdata["victim"]["shipTypeID"]); $extra["commentID"] = Info::commentID($id); $extra["crest"] = Db::queryRow("select killID, hash from zz_crest_killmail where killID = :killID and processed = 1", array(":killID" => $id), 300); $systemID = $killdata["info"]["solarSystemID"]; $data = Info::getWormholeSystemInfo($systemID); $extra["wormhole"] = $data; $url = "https://" . $_SERVER["SERVER_NAME"] . "/detail/{$id}/"; $app->render("detail.html", array("pageview" => $pageview, "killdata" => $killdata, "extra" => $extra, "message" => $message, "flags" => Info::$effectToSlot, "topDamage" => $topDamage, "finalBlow" => $finalBlow, "url" => $url)); function involvedships($array) { $involved = array(); foreach ($array as $inv) { if (isset($involved[$inv["shipTypeID"]]) && isset($inv["shipName"])) { $involved[$inv["shipTypeID"]] = array("shipName" => $inv["shipName"], "shipTypeID" => $inv["shipTypeID"], "count" => $involved[$inv["shipTypeID"]]["count"] + 1); } elseif (isset($inv["shipTypeID"]) && isset($inv["shipName"])) { $involved[$inv["shipTypeID"]] = array("shipName" => $inv["shipName"], "shipTypeID" => $inv["shipTypeID"], "count" => 1);