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
$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));
