<?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) {