<?php
if (!empty($players['data'])) {
if ($page > 1) {
$rank = ($page - 1) * (50 + 1);
} else {
$rank = 1;
}
foreach ($players['data'] as $k => $entry) {
toggleRowClass($rcol);
echo '<tr>', "\n";
echo '<td class="', $rcol, '">';
echo $rank + $k;
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo '<a href="index.php?mode=playerinfo&player=', $entry['killerId'], '">';
echo makeSavePlayerName($entry['killerName']);
echo '</a>';
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo $entry['frags'];
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo '<div class="percentBar"><div class="barContent" style="width:', number_format((int) $entry['percent'], 0), 'px"></div></div>', "\n";
echo '</td>', "\n";
echo '</tr>';
}
echo '<tr><td colspan="4" align="right">';
if ($players['pages'] > 1) {
for ($i = 1; $i <= $players['pages']; $i++) {
if ($players == $i) {
echo "[", $i, "]";
foreach ($awardsHistory['data'] as $k => $entry) {
toggleRowClass($rcol);
echo '<tr>', "\n";
echo '<td class="', $rcol, '">';
echo $entry['name'];
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
if ($entry['d_winner_id']) {
if ($entry['isBot'] === "1") {
echo '<img src="hlstatsimg/bot.png" alt="' . l('BOT') . '" title="' . l('BOT') . '" width="16" height="16" />';
} elseif ($entry['active'] === "1") {
echo '<img src="hlstatsimg/player.gif" alt="' . l('active Player') . '" title="' . l('active Player') . '" width="16" height="16" />';
} else {
echo '<img src="hlstatsimg/player_inactive.gif" alt="' . l('inactive Player') . '" title="' . l('inactive Player') . '" width="16" height="16" />';
}
echo ' <a href="index.php?mode=playerinfo&player=', $entry["d_winner_id"], '"><b>', makeSavePlayerName($entry["d_winner_name"]), '</b></a>';
echo ' (', $entry["d_winner_count"], ' ', htmlspecialchars($entry["verb"]), ')';
} else {
echo '(', l('Nobody') . ')';
}
echo '</td>', "\n";
echo '</tr>';
}
} else {
echo '<tr><td colspan="3">', l('No data recorded'), '</td></tr>';
}
?>
</table>
<p><b><?php
echo l('Note');
?>
</th>
<th><?php
echo l('Kills per Death');
?>
</th>
</tr>
<?php
foreach ($playerKillStats as $entry) {
echo '<tr class="', toggleRowClass($rcol), '">';
echo '<td>';
if ($entry['active'] == "1") {
echo '<img src="hlstatsimg/player.gif" width="16" height="16" alt="', l('Player'), '" alt="', l('Player'), '" />';
} else {
echo '<img src="hlstatsimg/player_inactive.gif" width="16" height="16" alt="', l('Player'), '" alt="', l('Player'), '" />';
}
echo '<a href="index.php?mode=playerinfo&player=', $entry['playerId'], '">', makeSavePlayerName($entry['name']), '</a>';
echo '</td>';
echo '<td>', $entry['kills'], '</td>';
echo '<td>', $entry['deaths'], '</td>';
echo '<td>', number_format((int) $entry['kpd'], 1), '</td>';
echo '</tr>';
}
?>
</table>
<script type="text/javascript" language="javascript">
function changeLimit(num) {
location = "index.php?mode=playerinfo&player=<?php
echo $player;
?>
&killLimit=" + num + "#killstats";
}
<th width="30%"><?php
echo htmlspecialchars($awarddata["name"]);
?>
</th>
<td width="70%">
<?php
if ($awarddata["d_winner_id"]) {
if ($awarddata['isBot'] === "1") {
echo '<img src="hlstatsimg/bot.png" alt="' . l('BOT') . '" title="' . l('BOT') . '" width="16" height="16" />';
} elseif ($awarddata['active'] === "1") {
echo '<img src="hlstatsimg/player.gif" alt="' . l('active Player') . '" title="' . l('active Player') . '" width="16" height="16" />';
} else {
echo '<img src="hlstatsimg/player_inactive.gif" alt="' . l('inactive Player') . '" title="' . l('inactive Player') . '" width="16" height="16" />';
}
echo " <a href=\"index.php?mode=playerinfo&player=" . $awarddata["d_winner_id"] . "\"><b>";
echo makeSavePlayerName($awarddata["d_winner_name"]) . "</b></a> (" . $awarddata["d_winner_count"] . " " . htmlspecialchars($awarddata["verb"]) . ")";
} else {
echo "(", l('Nobody') . ')';
}
?>
</td>
</tr>
<?php
}
?>
</table>
<?php
}
?>
<h1><?php
<?php
// if so show a timeline of player count
if ($g_options['showChart'] == "1") {
require 'class/chart.class.php';
$chartObj = new Chart($game);
$chart = $chartObj->getChart('playerActivity', $playersObj);
if (!empty($chart)) {
echo '<h2>', l('Players per day'), ' - ', l('Last'), ' ', $g_options['DELETEDAYS'], ' ', l('Days'), '</h2>';
echo '<div class="chart"><img src="', $chart, '" /></div>';
}
$chartObj2 = new Chart($game);
$chartObj2->setOption('height', 350);
$chart = $chartObj2->getChart('mostTimeOnline', $playersObj);
if (!empty($chart)) {
echo '<h2>', l('Most time online (hours)'), ' - ', l('Last'), ' ', $g_options['DELETEDAYS'], ' ', l('Days'), '</h2>';
echo '<div class="chart"><img src="', $chart, '" /></div>';
$chartData = $chartObj2->getChartData();
if (!empty($chartData)) {
echo '<h2></h2>';
echo "<ol>\n";
foreach ($chartData as $playerId => $entry) {
echo '<li><a href="index.php?mode=playerinfo&player=', $playerId, '">', makeSavePlayerName($entry['playerName']), '</a> ', getTimeFromSec($entry['timeSec']), '</li>';
}
echo "</ol>\n";
}
}
}
?>
</div>
</div>
$rank = 1;
}
foreach ($members['data'] as $k => $entry) {
toggleRowClass($rcol);
echo '<tr>', "\n";
echo '<td class="', $rcol, '">';
echo $rank + $k;
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
if ($entry['active'] === "1") {
echo '<img src="hlstatsimg/player.gif" alt="active Player" title="active Player" width="16" height="16" />';
} else {
echo '<img src="hlstatsimg/player_inactive.gif" alt="inactive Player" title="inactive Player" width="16" height="16" />';
}
echo '<a href="index.php?mode=playerinfo&player=', $entry['playerId'], '">';
echo makeSavePlayerName($entry['lastName']);
echo '</a>';
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo '<img width="16" height="16" ';
if ($entry['skill'] > $entry['oldSkill']) {
echo 'src="hlstatsimg/skill_up.gif" alt="Up" title="Up"';
} elseif ($entry['skill'] < $entry['oldSkill']) {
echo 'src="hlstatsimg/skill_down.gif" alt="Down" title="Down"';
} else {
echo 'src="hlstatsimg/skill_stay.gif" alt="Stay" title="Stay"';
}
echo ' />';
echo $entry['skill'];
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
foreach ($players['data'] as $k => $entry) {
toggleRowClass($rcol);
echo '<tr>', "\n";
echo '<td class="', $rcol, '">';
echo $rank + $k;
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
if ($entry['isBot'] === "1") {
echo '<img src="hlstatsimg/bot.png" alt="' . l('BOT') . '" title="' . l('BOT') . '" width="16" height="16" />';
} elseif ($entry['active'] === "1") {
echo '<img src="hlstatsimg/player.gif" alt="' . l('active Player') . '" title="' . l('active Player') . '" width="16" height="16" />';
} else {
echo '<img src="hlstatsimg/player_inactive.gif" alt="' . l('inactive Player') . '" title="' . l('inactive Player') . '" width="16" height="16" />';
}
echo ' <a href="index.php?mode=playerinfo&player=', $entry['playerId'], '">';
echo makeSavePlayerName($entry['playerName']);
echo '</a>';
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo $entry['obj_count'];
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo $entry['obj_bonus'];
echo '</td>', "\n";
echo '</tr>';
}
echo '<tr><td colspan="4" align="right">';
if ($players['pages'] > 1) {
for ($i = 1; $i <= $players['pages']; $i++) {
if ($page == $i) {
echo "[", $i, "]";
$playerObj->setOption("sort", 'eventTime');
}
$newSort = "ASC";
if (isset($_GET["sortorder"])) {
$check = validateInput($_GET['sortorder'], 'nospace');
if ($check === true) {
$playerObj->setOption("sortorder", $_GET['sortorder']);
}
if ($_GET["sortorder"] == "ASC") {
$newSort = "DESC";
}
} else {
$playerObj->setOption("sortorder", 'DESC');
}
$gamename = getGameName($playerObj->getParam("game"));
$pl_name = makeSavePlayerName($playerObj->getParam('name'));
pageHeader(array($gamename, l("Chat History"), $pl_name), array($gamename => "index.php?game=" . $playerObj->getParam('game'), l("Player Rankings") => "index.php?mode=players&game=" . $playerObj->getParam('game'), l("Player Details") => "index.php?mode=playerinfo&player={$player}", l("Chat History") => ""), $pl_name);
?>
<div id="sidebar">
<h1><?php
echo l('Options');
?>
</h1>
<div class="left-box">
<ul class="sidemenu">
<li>
<a href="index.php?mode=playerchathistory&player=<?php
echo $player;
?>
"><img src="hlstatsimg/history.gif" width='16' height='16' border='0' hspace="3" align="middle" alt="history.gif"><?php
<?php
if (!empty($players['data'])) {
if ($page > 1) {
$rank = ($page - 1) * (50 + 1);
} else {
$rank = 1;
}
foreach ($players['data'] as $k => $entry) {
toggleRowClass($rcol);
echo '<tr>', "\n";
echo '<td class="', $rcol, '">';
echo $rank + $k;
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo '<a href="index.php?mode=playerinfo&player=', $entry['killerId'], '">';
echo '<img src="hlstatsimg/player.gif" width="16" height="16" /> ', makeSavePlayerName($entry['killerName']);
echo '</a>';
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo $entry['frags'];
echo '</td>', "\n";
echo '</tr>';
}
echo '<tr><td colspan="6" align="right">';
if ($players['pages'] > 1) {
for ($i = 1; $i <= $players['pages']; $i++) {
if ($page == $i) {
echo "[", $i, "]";
} else {
echo "<a href='index.php?", makeQueryString(array('page' => $i)), "'>[", $i, "]</a>";
}
</tr>
<?php
if (!empty($countryPlayers['data'])) {
if ($page > 1) {
$rank = ($page - 1) * (50 + 1);
} else {
$rank = 1;
}
foreach ($countryPlayers['data'] as $k => $entry) {
toggleRowClass($rcol);
echo '<tr>', "\n";
echo '<td class="', $rcol, '">';
echo '<img src="hlstatsimg/site/flag/' . strtolower($entry['countryCode']) . '.png" alt="' . $entry['country'] . '" title="' . $entry['country'] . '" /> ';
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo '<a href="index.php?mode=playerinfo&player=' . $entry['playerId'] . '">' . makeSavePlayerName($entry['name']) . '</a>';
echo '</td>', "\n";
echo '<td class="', $rcol, '">';
echo $entry['obj_count'];
echo '</td>', "\n";
echo '</tr>';
}
echo '<tr><td colspan="4" align="right">';
if ($countryPlayers['pages'] > 1) {
for ($i = 1; $i <= $countryPlayers['pages']; $i++) {
if ($page == $i) {
echo "[", $i, "]";
} else {
echo "<a href='index.php?", makeQueryString(array('page' => $i)), "'>[", $i, "]</a> ";
}
}
/**
* get the players for the current game
* for the players overview page
*
* @return array The players
*/
public function getPlayersOveriew()
{
$ret['data'] = array();
$ret['pages'] = false;
// construct the query with the given options
$queryStr = "SELECT SQL_CALC_FOUND_ROWS\n\t\t\t\tt1.playerId,\n\t\t\t\tt1.lastName,\n\t\t\t\tt1.skill,\n\t\t\t\tt1.oldSkill,\n\t\t\t\tt1.kills,\n\t\t\t\tt1.deaths,\n\t\t\t\tt1.active,\n\t\t\t\tIFNULL(t1.kills/t1.deaths, '-') AS kpd\n\t\t\tFROM\n\t\t\t\t" . DB_PREFIX . "_Players as t1";
// should we hide the bots
if (defined('HIDE_BOTS') && HIDE_BOTS == "1") {
$queryStr .= " INNER JOIN " . DB_PREFIX . "_PlayerUniqueIds as t2 ON t1.playerId = t2.playerId";
}
$queryStr .= " WHERE\n\t\t\t\tt1.game='" . mysql_escape_string($this->_game) . "'\n\t\t\t\tAND t1.hideranking=0\n\t\t\t\tAND t1.kills >= '" . mysql_escape_string($this->_option['minkills']) . "'";
// should we show all the players or not
if (isset($this->_option['showall']) && $this->_option['showall'] === "1") {
$queryStr .= " ";
} else {
$queryStr .= " AND t1.active = '1'";
}
// should we hide the bots
if (defined('HIDE_BOTS') && HIDE_BOTS == "1") {
$queryStr .= " AND t2.uniqueID not like 'BOT:%'";
}
$queryStr .= " ORDER BY ";
if (!empty($this->_option['sort']) && !empty($this->_option['sortorder'])) {
$queryStr .= " " . $this->_option['sort'] . " " . $this->_option['sortorder'] . "";
}
//$queryStr .=" ,t1.lastName ASC";
// calculate the limit
if ($this->_option['page'] === 1) {
$queryStr .= " LIMIT 0,50";
} else {
$start = 50 * ($this->_option['page'] - 1);
$queryStr .= " LIMIT " . $start . ",50";
}
$query = mysql_query($queryStr);
if (mysql_num_rows($query) > 0) {
while ($result = mysql_fetch_assoc($query)) {
$result['kpd'] = number_format((int) $result['kpd'], 1, '.', '');
$result['lastName'] = makeSavePlayerName($result['lastName']);
$pl[] = $result;
}
$ret['data'] = $pl;
}
// get the max count for pagination
$query = mysql_query("SELECT FOUND_ROWS() AS 'rows'");
$result = mysql_fetch_assoc($query);
$ret['pages'] = (int) ceil($result['rows'] / 50);
return $ret;
}
} elseif ('BOT' == $p['uid']) {
$is_bot = 1;
} elseif ('HLTV' == $p['uid']) {
$is_bot = 1;
} elseif ('rcon' == $p['uid']) {
$is_rcon = 1;
} elseif ('0' == $p['uid']) {
$is_bot = 1;
} elseif ('0' == $p['ping']) {
$is_bot = 1;
}
}
$img = "player.gif";
if ($is_bot === 1 || $is_rcon === 1) {
$img = "bot.png";
}
echo '<tr>';
echo '<td><img src="hlstatsimg/', $img, '" alt="icon" width="16"/></td>';
echo '<td><a href="index.php?mode=search&game=' . $server['game'] . '&q=' . urlencode(makeSavePlayerName($p['name'])) . '">', makeSavePlayerName($p['name']), '</a></td>';
echo '<td>', $p['frags'], '</td>';
echo '<td>', Format_Time($p['time']), '</td>';
echo '</tr>';
}
?>
</table>
<?php
}
?>
</div>
</div>
} else {
$rank = 1;
}
foreach ($pData['data'] as $k => $entry) {
$rcol = "row-dark";
echo '<tr>', "\n";
echo '<td class="', toggleRowClass($rcol), '">';
echo $rank + $k;
echo '</td>', "\n";
echo '<td class="', toggleRowClass($rcol), '">';
if ($entry['active'] === "1") {
echo '<img src="hlstatsimg/player.gif" alt="active Player" title="active Player" width="16" height="16" />';
} else {
echo '<img src="hlstatsimg/player_inactive.gif" alt="inactive Player" title="inactive Player" width="16" height="16" />';
}
echo '<a href="index.php?mode=playerinfo&player=', $entry['playerId'], '">', makeSavePlayerName($entry['lastName']), '</a></td>', "\n";
echo '<td class="', toggleRowClass($rcol), '">';
echo '<img width="16" height="16" ';
if ($entry['skill'] > $entry['oldSkill']) {
echo 'src="hlstatsimg/skill_up.gif" alt="Up" title="Up"';
} elseif ($entry['skill'] < $entry['oldSkill']) {
echo 'src="hlstatsimg/skill_down.gif" alt="Down" title="Down"';
} else {
echo 'src="hlstatsimg/skill_stay.gif" alt="Stay" title="Stay"';
}
echo ' />';
echo $entry['skill'], '</td>', "\n";
echo '<td class="', toggleRowClass($rcol), '">', $entry['kills'], '</td>', "\n";
echo '<td class="', toggleRowClass($rcol), '">', $entry['deaths'], '</td>', "\n";
echo '<td class="', toggleRowClass($rcol), '">', $entry['kpd'], '</td>', "\n";
echo '</tr>', "\n";
/**
* get the players for the current game
* for the players overview page
*
* @return array The players
*/
public function getPlayersOveriew()
{
$ret['data'] = array();
$ret['pages'] = false;
// construct the query with the given options
$queryStr = "SELECT SQL_CALC_FOUND_ROWS\n\t\t\t\tt1.playerId,\n\t\t\t\tt1.lastName,\n\t\t\t\tt1.skill,\n\t\t\t\tt1.oldSkill,\n\t\t\t\tt1.kills,\n\t\t\t\tt1.deaths,\n\t\t\t\tt1.active,\n\t\t\t\tt1.isBot,\n\t\t\t\tIFNULL(t1.kills/t1.deaths,0) AS kpd,\n\t\t\t\tt1.skillchangeDate\n\t\t\tFROM `" . DB_PREFIX . "_Players` as t1";
$queryStr .= " WHERE\n\t\t\t\tt1.game='" . $this->_DB->real_escape_string($this->_game) . "'\n\t\t\t\tAND t1.hideranking=0\n\t\t\t\tAND t1.kills >= '" . $this->_DB->real_escape_string($this->_option['minkills']) . "'";
// should we show all the players or not
if (isset($this->_option['showall']) && $this->_option['showall'] === "1") {
$queryStr .= " ";
} else {
$queryStr .= " AND t1.active = '1'";
}
if (isset($this->_option['showToday']) && $this->_option['showToday'] === "1") {
// should we show only players from today
$startDay = time() - 86400;
$queryStr .= " AND t1.skillchangeDate > '" . $startDay . "'";
}
// should we hide the bots
if ($this->_option['showBots'] === "0") {
$queryStr .= " AND t1.isBot = 0";
}
$queryStr .= " ORDER BY ";
if (!empty($this->_option['sort']) && !empty($this->_option['sortorder'])) {
$queryStr .= " " . $this->_option['sort'] . " " . $this->_option['sortorder'] . "";
}
//$queryStr .=" ,t1.lastName ASC";
// calculate the limit
if ($this->_option['page'] === 1) {
$queryStr .= " LIMIT 0,50";
} else {
$start = 50 * ($this->_option['page'] - 1);
$queryStr .= " LIMIT " . $start . ",50";
}
$query = $this->_DB->query($queryStr);
if (SHOW_DEBUG && $this->_DB->error) {
var_dump($this->_DB->error);
}
if ($query->num_rows > 0) {
while ($result = $query->fetch_assoc()) {
$result['kpd'] = number_format($result['kpd'], 2, '.', '');
$result['lastName'] = makeSavePlayerName($result['lastName']);
$pl[$result['playerId']] = $result;
}
$ret['data'] = $pl;
}
// get the max count for pagination
$query = $this->_DB->query("SELECT FOUND_ROWS() AS 'rows'");
$result = $query->fetch_assoc();
$ret['pages'] = (int) ceil($result['rows'] / 50);
return $ret;
}
<td>
<?php
if ($topplayer !== false) {
if ($topplayer['isBot'] === "1") {
echo '<img src="hlstatsimg/bot.png" width="16" height="16" hspace="3" alt="' . l('BOT') . '" border="0" align="middle" />';
}
echo '<a href="index.php?mode=playerinfo&player=' . $topplayer['playerId'] . '">' . makeSavePlayerName($topplayer['lastName']) . '</a>';
} else {
echo '-';
}
?>
</td>
<td>
<?php
if ($topclan !== false) {
echo '<a href="index.php?mode=claninfo&clan=' . $topclan['clanId'] . '&game=' . $gamedata['code'] . '">' . makeSavePlayerName($topclan['name']) . '</a>';
} else {
echo '-';
}
?>
</td>
</tr>
<?php
}
?>
</table>
</div>
<h1><?php
echo l('General Statistics');
?>
</h1>
</h1>
<div class="left-box">
<img src="hlstatsimg/game-<?php
echo $game;
?>
-big.png" alt="<?php
echo $game;
?>
" title="<?php
echo $game;
?>
" width="100px" />
</div>
</div>
<div id="main">
<div class="content">
<?php
if (!empty($timeline)) {
foreach ($timeline as $day => $entry) {
echo '<h1>', $day, '</h1>';
echo '<ul>';
foreach ($entry as $player) {
echo '<li><a href="index.php?mode=playerinfo&player=', $player['playerId'], '">', makeSavePlayerName($player['lastName']), '</a></li>';
}
echo '</ul>';
}
}
?>
</div>
</div>
