<?php
/**
* Project: Tremstats
* File: top_teamkillers.php
*
* For license and version information, see /index.php
*/
require_once 'core/init.inc.php';
$last_game = $db->GetRow("SELECT game_id FROM games ORDER BY game_id DESC LIMIT 0, 1");
$game_cutoff = $last_game['game_id'] - TRESHOLD_MAX_GAMES_PAUSED;
$custom_orders = array('rank' => 'player_rank', 'player' => 'player_name_uncolored', 'average_kills' => 'average_kills_to_enemy', 'average_team_kills' => 'average_kills_to_team', 'average_deaths' => 'average_deaths_by_enemy');
$order = get_custom_sort($custom_orders, 'rank');
$db->Execute("SET @n := 0");
$db->Execute("CREATE TEMPORARY TABLE tmp (\n SELECT player_id,\n @n := @n + 1 AS player_rank,\n player_name,\n player_name_uncolored,\n IF (player_games_played = 0, 0, player_kills / player_games_played) AS average_kills_to_enemy,\n IF (player_games_played = 0, 0, player_teamkills / player_games_played) AS average_kills_to_team,\n IF (player_games_played = 0, 0, player_deaths_enemy / player_games_played) AS average_deaths_by_enemy\n FROM players\n WHERE player_games_played >= ?\n AND player_last_game_id > ?\n ORDER BY average_kills_to_team DESC\n )", array(TRESHOLD_MIN_GAMES_PLAYED, $game_cutoff));
$pagelister->SetQuery("SELECT player_id,\n player_rank,\n player_name,\n average_kills_to_enemy,\n average_kills_to_team,\n average_deaths_by_enemy\n FROM tmp\n ORDER BY " . $order);
$top = $db->GetAll($pagelister->GetQuery());
// Assign variables to template
$tpl->assign('top', $top);
// Show the template
$tpl->display('top_teamkillers.tpl.php');
<?php
/**
* Project: Tremstats
* File: search_player.php
*
* For license and version information, see /index.php
*/
require_once 'core/init.inc.php';
if (isset($_GET['query'])) {
$custom_orders = array('player' => 'player_name_uncolored', 'kills' => 'player_kills', 'deaths' => 'player_deaths', 'efficiency' => 'player_total_efficiency');
$order = get_custom_sort($custom_orders, 'player');
$pagelister->SetQuery("SELECT player_id,\n player_name,\n player_kills,\n player_deaths,\n player_total_efficiency\n FROM players\n WHERE player_name_uncolored LIKE '%" . $_GET['query'] . "%'\n ORDER BY " . $order);
$players = $db->GetAll($pagelister->GetQuery());
// Maybe an alias?
$players_tjw = $db->GetAll("SELECT player_id,\n nick_name AS player_name,\n player_name AS player_tjw_name,\n player_kills,\n player_deaths,\n player_total_efficiency\n FROM players JOIN nicks ON players.player_id = nicks.nick_player_id\n WHERE nicks.nick_name_uncolored LIKE '%" . $_GET['query'] . "%' AND nicks.nick_name_uncolored != players.player_name_uncolored\n ORDER BY " . $order);
// Assign variables to template
$tpl->assign('players', array_merge($players, $players_tjw));
}
// Show the template
$tpl->display('search_player.tpl.php');
