EVE-KILL / zKillboard

view/ship.php

<?php

/* zKillboard

 * Copyright (C) 2012-2015 EVE-KILL Team and EVSCO.

 *

 * This program is free software: you can redistribute it and/or modify

 * it under the terms of the GNU Affero General Public License as published by

 * the Free Software Foundation, either version 3 of the License, or

 * (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful,

 * but WITHOUT ANY WARRANTY; without even the implied warranty of

 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

 * GNU Affero General Public License for more details.

 *

 * You should have received a copy of the GNU Affero General Public License

 * along with this program.  If not, see <http://www.gnu.org/licenses/>.

 */


// Find the shipTypeID

if(!is_numeric($shipType))

	$shipTypeID = (int) Db::queryField("SELECT typeID FROM ccp_invTypes WHERE typeName = :typeName", "typeID", array(":typeName" => $shipType), 3600);

else // Verify it exists

	$shipTypeID = (int) Db::queryField("SELECT typeID FROM ccp_invTypes WHERE typeID = :typeID", "typeID", array(":typeID" => (int) $shipType), 3600);


// If the shipTypeID we get from above is zero, don't even bother anymore.....

if($shipTypeID == 0)

	$app->redirect("/");

elseif(!is_numeric($shipType)) // if shipType isn't numeric, we redirect TO the shipTypeID!

	$app->redirect("/ship/{$shipTypeID}/");


// Now we figure out all the parameters

$parameters = Util::convertUriToParameters();


// Unset the shipType => id, and make it shipTypeID => id

unset($parameters["shipType"]);

$parameters["shipTypeID"] = $shipTypeID;

$parameters["index"] = "shipTypeID_dttm";


// Make sure that the pageType is correct..

$subPageTypes = array("page", "groupID", "month", "year", "shipTypeID");

if(in_array($pageType, $subPageTypes))

	$pageType = "overview";


// Some defaults

@$page = max(1, $parameters["page"]);

It seems like you do not handle an error condition here. This can introduce security issues, and is generally not recommended.

$limit = 50;

$parameters["limit"] = $limit;

$parameters["page"] = $page;


// and now we fetch the info!

$detail = Info::getShipDetails($shipTypeID, $parameters);

The call to Info::getShipDetails() has too many arguments starting with $parameters.

// Define the page information and scope etc.

$pageName = isset($detail["shipTypeName"]) ? $detail["shipTypeName"] : "???";

$columnName = "shipTypeID";

$mixedKills = $pageType == "overview" && UserConfig::get("mixKillsWithLosses", true);


// Load kills for the various pages.

$mixed = $pageType == "overview" ? Kills::getKills($parameters) : array();

$kills = $pageType ==  "kills" ? Kills::getKills($parameters) : array();

$losses = $pageType == "losses" ? Kills::getKills($parameters) : array();


// Solo parameters

//$soloParams = $parameters;

//if (!isset($parameters["kills"]) || !isset($parameters["losses"])) {

//	$soloParams["mixed"] = true;

//}


// Solo kills

//$soloKills = Kills::getKills($soloParams);

//$solo = Kills::mergeKillArrays($soloKills, array(), $limit, $columnName, $shipTypeID);


$topLists = array();

$topKills = array();

if ($pageType == "top" || $pageType == "topalltime") {

	$topParameters = $parameters; // array("limit" => 10, "kills" => true, "$columnName" => $shipTypeID);

	$topParameters["limit"] = 10;


	if ($pageType != "topalltime") {

		if (!isset($topParameters["year"])) {

			$topParameters["year"] = date("Y");

		}


		if (!isset($topParameters["month"])) {

			$topParameters["month"] = date("m");

		}


	}

	if (!array_key_exists("kills", $topParameters) && !array_key_exists("losses", $topParameters)) {

		$topParameters["kills"] = true;

	}


	$topLists[] = array("type" => "character", "data" => Stats::getTopPilots($topParameters, true));

	$topLists[] = array("type" => "corporation", "data" => Stats::getTopCorps($topParameters, true));

	$topLists[] = array("type" => "alliance", "data" => Stats::getTopAllis($topParameters, true));

	$topLists[] = array("type" => "ship", "data" => Stats::getTopShips($topParameters, true));

	$topLists[] = array("type" => "system", "data" => Stats::getTopSystems($topParameters, true));

	$topLists[] = array("type" => "weapon", "data" => Stats::getTopWeapons($topParameters, true));

}

else

{

	$p = $parameters;

	$numDays = 7;

	$p["limit"] = 10;

	$p["pastSeconds"] = $numDays * 86400;

	$p["kills"] = $pageType != "losses";


	$topLists[] = Info::doMakeCommon("Top Characters", "characterID", Stats::getTopPilots($p));

	$topLists[] = Info::doMakeCommon("Top Corporations", "corporationID", Stats::getTopCorps($p));

	$topLists[] = Info::doMakeCommon("Top Systems", "solarSystemID", Stats::getTopSystems($p));


	$p["limit"] = 5;

	$topKills = Stats::getTopIsk($p);

}


// Fix the history data!

$detail["history"] = $pageType == "stats" ? Summary::getMonthlyHistory($columnName, $shipTypeID) : array();


// Stats

$cnt = 0;

$cnid = 0;

$stats = array();

$totalcount = ceil(count($detail["stats"]) / 4);

foreach ($detail["stats"] as $q) {

	if ($cnt == $totalcount) {

		$cnid++;

		$cnt = 0;

	}

	$stats[$cnid][] = $q;

	$cnt++;

}


// Mixed kills yo!

if ($mixedKills)

	$kills = Kills::mergeKillArrays($mixed, array(), $limit, $columnName, $shipTypeID);


// Find the next and previous shipTypeID

$prevID = Db::queryField("select typeID from ccp_invTypes where typeID < :id order by typeID desc limit 1", "typeID", array(":id" => $shipTypeID), 300);

$nextID = Db::queryField("select typeID from ccp_invTypes where typeID > :id order by typeID asc limit 1", "typeID", array(":id" => $shipTypeID), 300);


$renderParams = array(

	"pageName" => $pageName,

	"kills" => $kills,

	"losses" => $losses,

	"detail" => $detail,

	"page" => $page,

	"topKills" => $topKills,

	"mixed" => $mixedKills,

	"key" => "ship",

	"id" => $shipTypeID,

	"pageType" => $pageType,

//	"solo" => $solo,

	"topLists" => $topLists,

	"summaryTable" => $stats,

	"pager" => (sizeof($kills) + sizeof($losses) >= $limit),

	"datepicker" => true,

	"prevID" => $prevID,

	"nextID" => $nextID

);


$app->etag(md5(serialize($renderParams)));

$app->expires("+5 minutes");

$app->render("overview.html", $renderParams);