create_ranking_menu PHP 코드 예제들

예제 #1

0

파일 보기

파일: rankings_alliance_vs_alliance.php 프로젝트: smrealms/smrv2.0

<?php

require_once get_file_loc('SmrAlliance.class.inc');
$template->assign('PageTopic', 'Alliance VS Alliance Rankings');
require_once get_file_loc('menu.inc');
create_ranking_menu(1, 3);
$db2 = new SmrMySqlDatabase();
$container = array();
$container['url'] = 'skeleton.php';
$container['body'] = 'rankings_alliance_vs_alliance.php';
$PHP_OUTPUT .= create_echo_form($container);
if (isset($_REQUEST['alliancer'])) {
    SmrSession::updateVar('alliancer', $_REQUEST['alliancer']);
}
$alliancer = $var['alliancer'];
$PHP_OUTPUT .= '<div align="center">';
$PHP_OUTPUT .= '<p>Here are the rankings of alliances vs other alliances<br />';
$PHP_OUTPUT .= 'Click on an alliances name for more detailed death stats.</p>';
$PHP_OUTPUT .= '<table class="standard" width="95%">';
$PHP_OUTPUT .= '<tr>';
$PHP_OUTPUT .= '<th rowspan="9">Killed</th><th colspan="8">Killers</th></tr><tr><td></td>';
if (empty($alliancer)) {
    $alliance_vs = array();
    $db->query('SELECT * FROM alliance WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY alliance_kills DESC, alliance_name LIMIT 5');
    while ($db->nextRecord()) {
        $alliance_vs[] = $db->getField('alliance_id');
    }
    //$PHP_OUTPUT.=('empty '.$alliancer);
} else {
    $alliance_vs = $alliancer;
}

예제 #2

0

파일 보기

파일: rankings_player_death.php 프로젝트: smrealms/smrv2.0

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

예제 #3

0

파일 보기

파일: rankings_alliance_experience.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Alliance Experience Rankings');
require_once get_file_loc('Rankings.inc');
require_once get_file_loc('menu.inc');
create_ranking_menu(1, 0);
$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 (
					SELECT alliance_id, alliance_name, SUM(experience) amount
					FROM alliance
					LEFT JOIN player USING (game_id, alliance_id)
					WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . '
					GROUP BY alliance_id, alliance_name
				) t, (
					SELECT SUM(experience) amount
					FROM alliance
					LEFT JOIN player USING (game_id, alliance_id)
					WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . '
					AND alliance_id = ' . $db->escapeNumber($player->getAllianceID()) . '
				) us
				WHERE (
					t.amount > us.amount
					OR (
						t.amount = us.amount
						AND alliance_name <= ' . $db->escapeString($player->getAllianceName()) . '

예제 #4

0

파일 보기

파일: rankings_player_kills.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Kill Rankings');
require_once get_file_loc('Rankings.inc');
require_once get_file_loc('menu.inc');
create_ranking_menu(0, 2);
// what rank are we?
$db->query('SELECT count(*) FROM player
			WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . '
			AND (
				kills > ' . $db->escapeNumber($player->getKills()) . '
				OR (
					kills = ' . $db->escapeNumber($player->getKills()) . '
					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, kills amount FROM player WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY kills 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_kills.php')));
$lowerLimit = $var['MinRank'] - 1;
$db->query('SELECT account_id, kills amount FROM player WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY kills DESC, player_name LIMIT ' . $lowerLimit . ', ' . ($var['MaxRank'] - $lowerLimit));
$template->assignByRef('FilteredRankings', Rankings::collectRankings($db, $player, $lowerLimit));

예제 #5

0

파일 보기

파일: rankings_sector_kill.php 프로젝트: smrealms/smrv2.0

<?php

require_once get_file_loc('SmrSector.class.inc');
$template->assign('PageTopic', 'Sector Death Rankings');
require_once get_file_loc('menu.inc');
create_ranking_menu(3, 0);
$PHP_OUTPUT .= '<div align="center">';
$PHP_OUTPUT .= '<p>Here are the most deadly Sectors!</p>';
$PHP_OUTPUT .= '<table class="standard" width="60%">';
$PHP_OUTPUT .= '<tr>';
$PHP_OUTPUT .= '<th>Rank</th>';
$PHP_OUTPUT .= '<th>Sector</th>';
$PHP_OUTPUT .= '<th>Battles</th>';
$PHP_OUTPUT .= '</tr>';
$db->query('SELECT * FROM sector WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY battles DESC, sector_id LIMIT 10');
$rank = 0;
while ($db->nextRecord()) {
    // get current player
    $curr_sector =& SmrSector::getSector($player->getGameID(), $db->getField('sector_id'));
    // increase rank counter
    $rank++;
    $PHP_OUTPUT .= '<tr>';
    $PHP_OUTPUT .= '<td valign="top" class="center';
    if ($player->getSectorID() == $curr_sector->getSectorID()) {
        $PHP_OUTPUT .= ' bold';
    }
    $PHP_OUTPUT .= '">' . $rank . '</td>';
    $PHP_OUTPUT .= '<td valign="top" class="center';
    if ($player->getSectorID() == $curr_sector->getSectorID()) {
        $PHP_OUTPUT .= ' bold';
    }

예제 #6

0

파일 보기

파일: rankings_player_profit.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Profit Rankings');
require_once get_file_loc('Rankings.inc');
require_once get_file_loc('menu.inc');
create_ranking_menu(0, 1);
$profitType = array('Trade', 'Money', 'Profit');
$profitTypeEscaped = $db->escapeArray($profitType, false, true, ':', false);
// what rank are we?
$db->query('SELECT count(*)
			FROM player p
			LEFT JOIN player_hof ph ON p.account_id = ph.account_id AND p.game_id = ph.game_id AND ph.type = ' . $profitTypeEscaped . '
			WHERE p.game_id = ' . $db->escapeNumber($player->getGameID()) . '
			AND (
				amount > ' . $db->escapeNumber($player->getHOF($profitType)) . '
				OR (
					COALESCE(amount,0) = ' . $db->escapeNumber($player->getHOF($profitType)) . '
					AND player_name <= ' . $db->escapeString($player->getPlayerName()) . '
				)
			)');
$db->nextRecord();
$ourRank = $db->getInt('count(*)');
$template->assign('OurRank', $ourRank);
$totalPlayers = $player->getGame()->getTotalPlayers();
$db->query('SELECT p.account_id, COALESCE(ph.amount,0) amount FROM player p LEFT JOIN player_hof ph ON p.account_id = ph.account_id AND p.game_id = ph.game_id AND ph.type = ' . $profitTypeEscaped . ' WHERE p.game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY amount DESC, player_name ASC 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_profit.php')));
$lowerLimit = $var['MinRank'] - 1;
$db->query('SELECT p.account_id, COALESCE(ph.amount,0) amount FROM player p LEFT JOIN player_hof ph ON p.account_id = ph.account_id AND p.game_id = ph.game_id AND ph.type = ' . $profitTypeEscaped . ' WHERE p.game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY amount DESC, player_name ASC LIMIT ' . $lowerLimit . ', ' . ($var['MaxRank'] - $lowerLimit));
$template->assignByRef('FilteredRankings', Rankings::collectRankings($db, $player, $lowerLimit));

예제 #7

0

파일 보기

파일: rankings_race.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Racial Standings');
require_once get_file_loc('menu.inc');
create_ranking_menu(2, 0);
$PHP_OUTPUT .= '<div align=center>';
$PHP_OUTPUT .= '<p>Here are the rankings of the races by their experience</p>';
$PHP_OUTPUT .= '<table class="standard" width="95%">';
$PHP_OUTPUT .= '<tr>';
$PHP_OUTPUT .= '<th>Rank</th>';
$PHP_OUTPUT .= '<th>Race</th>';
$PHP_OUTPUT .= '<th>Total Experience</th>';
$PHP_OUTPUT .= '<th>Average Experience</th>';
$PHP_OUTPUT .= '<th>Total Traders</th>';
$PHP_OUTPUT .= '</tr>';
$rank = 0;
$db2 = new SmrMySqlDatabase();
$db->query('SELECT race_id, race_name, SUM(experience) as experience_sum, COUNT(*) as members FROM player JOIN race USING(race_id) WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' GROUP BY race_id ORDER BY experience_sum DESC');
while ($db->nextRecord()) {
    $rank++;
    $race_id = $db->getInt('race_id');
    $db2->query('SELECT * FROM player WHERE race_id = ' . $db2->escapeNumber($race_id) . ' AND game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND out_of_game = \'TRUE\'');
    if ($player->getRaceID() == $race_id) {
        $style = ' class="bold"';
    } elseif ($db2->nextRecord()) {
        $style = ' class="red"';
    } else {
        $style = '';
    }
    //	if ($db2->nextRecord()) $style .=
    $PHP_OUTPUT .= '<tr>';

예제 #8

0

파일 보기

파일: rankings_player_experience.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Experience Rankings');
require_once get_file_loc('Rankings.inc');
require_once get_file_loc('menu.inc');
create_ranking_menu(0, 0);
// what rank are we?
$db->query('SELECT count(*) FROM player
			WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . '
			AND (
				experience > ' . $db->escapeNumber($player->getExperience()) . '
				OR (
					experience = ' . $db->escapeNumber($player->getExperience()) . '
					AND player_name <= ' . $db->escapeString($player->getPlayerName()) . '
				)
			)');
$db->nextRecord();
$ourRank = $db->getInt('count(*)');
$template->assign('OurRank', $ourRank);
$totalPlayers = $player->getGame()->getTotalPlayers();
$db->query('SELECT account_id, experience amount FROM player WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY experience 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_experience.php')));
$lowerLimit = $var['MinRank'] - 1;
$db->query('SELECT account_id, experience amount FROM player WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY experience DESC, player_name LIMIT ' . $lowerLimit . ', ' . ($var['MaxRank'] - $lowerLimit));
$template->assignByRef('FilteredRankings', Rankings::collectRankings($db, $player, $lowerLimit));

예제 #9

0

파일 보기

파일: rankings_race_kills.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Racial Standings');
require_once get_file_loc('menu.inc');
create_ranking_menu(2, 1);
$PHP_OUTPUT .= '<div align=center>';
$PHP_OUTPUT .= '<p>Here are the rankings of the races by their kills</p>';
$PHP_OUTPUT .= '<table class="standard" width="95%">';
$PHP_OUTPUT .= '<tr>';
$PHP_OUTPUT .= '<th>Rank</th>';
$PHP_OUTPUT .= '<th>Race</th>';
$PHP_OUTPUT .= '<th>Kills</th>';
$PHP_OUTPUT .= '</tr>';
$rank = 0;
$db2 = new SmrMySqlDatabase();
$db->query('SELECT race_id, race_name, sum(kills) as kill_sum, count(*) FROM player JOIN race USING(race_id) WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' GROUP BY race_id ORDER BY kill_sum DESC');
while ($db->nextRecord()) {
    $rank++;
    $race_id = $db->getInt('race_id');
    $db2->query('SELECT * FROM player WHERE race_id = ' . $db2->escapeNumber($race_id) . ' AND game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND out_of_game = \'TRUE\'');
    if ($player->getRaceID() == $race_id) {
        $style = ' class="bold"';
    } elseif ($db2->nextRecord()) {
        $style = ' class="red"';
    } else {
        $style = '';
    }
    $PHP_OUTPUT .= '<tr>';
    $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $rank . '</td>';
    $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db->getField('race_name') . '</td>';
    $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db->getInt('kill_sum') . '</td>';

예제 #10

0

파일 보기

파일: rankings_alliance_kills.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Alliance Kill Rankings');
require_once get_file_loc('Rankings.inc');
require_once get_file_loc('menu.inc');
create_ranking_menu(1, 2);
$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_kills > ' . $db->escapeNumber($player->getAlliance()->getKills()) . '
					OR (
						alliance_kills = ' . $db->escapeNumber($player->getAlliance()->getKills()) . '
						AND alliance_name <= ' . $db->escapeString($player->getAllianceName()) . '
					)
				)');
    $db->nextRecord();
    $ourRank = $db->getInt('count(*)');
    $template->assign('OurRank', $ourRank);
}
$db->query('SELECT alliance_id, alliance_kills 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;

예제 #11

0

파일 보기

파일: rankings_alliance_profit.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Alliance Profit Rankings');
require_once get_file_loc('Rankings.inc');
require_once get_file_loc('menu.inc');
create_ranking_menu(1, 1);
$db->query('SELECT count(*) FROM alliance
			WHERE game_id = ' . $db->escapeNumber($player->getGameID()));
$db->nextRecord();
$numAlliances = $db->getInt('count(*)');
$profitType = array('Trade', 'Money', 'Profit');
$profitTypeEscaped = $db->escapeArray($profitType, false, true, ':', false);
$ourRank = 0;
if ($player->hasAlliance()) {
    $db->query('SELECT count(*)
				FROM (
					SELECT alliance_id, alliance_name, SUM(amount) amount
					FROM alliance
					LEFT JOIN player p USING (game_id, alliance_id)
					LEFT JOIN player_hof ph ON p.account_id = ph.account_id AND p.game_id = ph.game_id AND ph.type = ' . $profitTypeEscaped . '
					WHERE p.game_id = ' . $db->escapeNumber($player->getGameID()) . '
					GROUP BY alliance_id, alliance_name
				) t, (
					SELECT SUM(amount) amount
					FROM alliance
					LEFT JOIN player p USING (game_id, alliance_id)
					LEFT JOIN player_hof ph ON p.account_id = ph.account_id AND p.game_id = ph.game_id AND ph.type = ' . $profitTypeEscaped . '
					WHERE p.game_id = ' . $db->escapeNumber($player->getGameID()) . '
					AND alliance_id = ' . $db->escapeNumber($player->getAllianceID()) . '
				) us
				WHERE (

예제 #12

0

파일 보기

파일: rankings_race_death.php 프로젝트: smrealms/smrv2.0

<?php

$template->assign('PageTopic', 'Racial Standings');
require_once get_file_loc('menu.inc');
create_ranking_menu(2, 2);
$PHP_OUTPUT .= '<div align=center>';
$PHP_OUTPUT .= '<p>Here are the rankings of the races by their deaths</p>';
$PHP_OUTPUT .= '<table class="standard" width="95%">';
$PHP_OUTPUT .= '<tr>';
$PHP_OUTPUT .= '<th>Rank</th>';
$PHP_OUTPUT .= '<th>Race</th>';
$PHP_OUTPUT .= '<th>Deaths</th>';
$PHP_OUTPUT .= '</tr>';
$rank = 0;
$db2 = new SmrMySqlDatabase();
$db->query('SELECT race_id, race_name, sum(deaths) as death_sum, count(*) FROM player JOIN race USING(race_id) WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' GROUP BY race_id ORDER BY death_sum DESC');
while ($db->nextRecord()) {
    $rank++;
    $race_id = $db->getInt('race_id');
    $db2->query('SELECT * FROM player WHERE race_id = ' . $db2->escapeNumber($race_id) . ' AND game_id = ' . $db2->escapeNumber($player->getGameID()) . ' AND out_of_game = \'TRUE\'');
    if ($player->getRaceID() == $race_id) {
        $style = ' class="bold"';
    } elseif ($db2->nextRecord()) {
        $style = ' class="red"';
    } else {
        $style = '';
    }
    $PHP_OUTPUT .= '<tr>';
    $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $rank . '</td>';
    $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db->getField('race_name') . '</td>';
    $PHP_OUTPUT .= '<td align="center"' . $style . '>' . $db->getInt('death_sum') . '</td>';

PHP create_ranking_menu 예제들