<?php
$template->assign('PageTopic', 'Death Rankings');
require_once get_file_loc('Rankings.inc');
require_once get_file_loc('menu.inc');
create_ranking_menu(0, 3);
// what rank are we?
$db->query('SELECT count(*) FROM player
WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . '
AND (
deaths > ' . $db->escapeNumber($player->getDeaths()) . '
OR (
deaths = ' . $db->escapeNumber($player->getDeaths()) . '
AND player_name <= ' . $db->escapeString($player->getPlayerName(), true) . '
)
)');
$db->nextRecord();
$ourRank = $db->getInt('count(*)');
$template->assign('OurRank', $ourRank);
$totalPlayers = $player->getGame()->getTotalPlayers();
$db->query('SELECT account_id, deaths amount FROM player WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY deaths DESC, player_name LIMIT 10');
$template->assignByRef('Rankings', Rankings::collectRankings($db, $player, 0));
Rankings::calculateMinMaxRanks($ourRank, $totalPlayers);
$template->assign('FilterRankingsHREF', SmrSession::getNewHREF(create_container('skeleton.php', 'rankings_player_death.php')));
$lowerLimit = $var['MinRank'] - 1;
$db->query('SELECT account_id, deaths amount FROM player WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY deaths DESC, player_name LIMIT ' . $lowerLimit . ', ' . ($var['MaxRank'] - $lowerLimit));
$template->assignByRef('FilteredRankings', Rankings::collectRankings($db, $player, $lowerLimit));
require_once get_file_loc('menu.inc');
create_ranking_menu(1, 3);
$db->query('SELECT count(*) FROM alliance
WHERE game_id = ' . $db->escapeNumber($player->getGameID()));
$db->nextRecord();
$numAlliances = $db->getInt('count(*)');
$ourRank = 0;
if ($player->hasAlliance()) {
$db->query('SELECT count(*)
FROM alliance
WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . '
AND (
alliance_deaths > ' . $db->escapeNumber($player->getAlliance()->getDeaths()) . '
OR (
alliance_deaths = ' . $db->escapeNumber($player->getAlliance()->getDeaths()) . '
AND alliance_name <= ' . $db->escapeString($player->getAllianceName()) . '
)
)');
$db->nextRecord();
$ourRank = $db->getInt('count(*)');
$template->assign('OurRank', $ourRank);
}
$db->query('SELECT alliance_id, alliance_deaths amount FROM alliance
WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY amount DESC, alliance_name LIMIT 10');
$template->assignByRef('Rankings', Rankings::collectAllianceRankings($db, $player, 0));
Rankings::calculateMinMaxRanks($ourRank, $numAlliances);
$lowerLimit = $var['MinRank'] - 1;
$db->query('SELECT alliance_id, alliance_deaths amount FROM alliance
WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY amount DESC, alliance_name LIMIT ' . $lowerLimit . ', ' . ($var['MaxRank'] - $lowerLimit));
$template->assignByRef('FilteredRankings', Rankings::collectAllianceRankings($db, $player, 0));
$template->assign('FilterRankingsHREF', SmrSession::getNewHREF(create_container('skeleton.php', 'rankings_alliance_death.php')));
<?php
@session_start();
if (!@(require "Config/Main.php")) {
die;
}
if (file_exists($_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "Templates/{$MainTemplate}/Rankings.tpl.php")) {
$tpl = new Template();
$InitTime = microtime(1);
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/MuDatabase.class.php";
$db = new MuDatabase();
require_once $_SERVER['DOCUMENT_ROOT'] . "/" . $_SESSION['SiteFolder'] . "System/Rankings.class.php";
$rk = new Rankings($db);
$my_array['ranking'] = "";
if (substr_count($_GET['c'], "/") > 0) {
$my_url = explode("/", $_GET['c']);
$type = $my_url[1];
isset($my_url[2]) ? $param1 = $my_url[2] : ($param1 = "");
isset($my_url[3]) ? $param2 = $my_url[3] : ($param2 = "");
isset($my_url[4]) ? $param3 = $my_url[4] : ($param3 = "");
} else {
$type = false;
$param1 = false;
$param2 = false;
$param3 = false;
}
$my_array['type'] = $type;
$my_array['param1'] = $param1;
$my_array['param2'] = $param2;
$my_array['param3'] = $param3;
if ($type) {
