282 lines
8.8 KiB
PHP
282 lines
8.8 KiB
PHP
|
<?php
|
||
|
|
/*
|
||
|
|
HLstatsX Community Edition - Real-time player and clan rankings and statistics
|
||
|
|
Copyleft (L) 2008-20XX Nicholas Hastings (nshastings@gmail.com)
|
||
|
|
http://www.hlxcommunity.com
|
||
|
|
|
||
|
|
HLstatsX Community Edition is a continuation of
|
||
|
|
ELstatsNEO - Real-time player and clan rankings and statistics
|
||
|
|
Copyleft (L) 2008-20XX Malte Bayer (steam@neo-soft.org)
|
||
|
|
http://ovrsized.neo-soft.org/
|
||
|
|
|
||
|
|
ELstatsNEO is an very improved & enhanced - so called Ultra-Humongus Edition of HLstatsX
|
||
|
|
HLstatsX - Real-time player and clan rankings and statistics for Half-Life 2
|
||
|
|
http://www.hlstatsx.com/
|
||
|
|
Copyright (C) 2005-2007 Tobias Oetzel (Tobi@hlstatsx.com)
|
||
|
|
|
||
|
|
HLstatsX is an enhanced version of HLstats made by Simon Garner
|
||
|
|
HLstats - Real-time player and clan rankings and statistics for Half-Life
|
||
|
|
http://sourceforge.net/projects/hlstats/
|
||
|
|
Copyright (C) 2001 Simon Garner
|
||
|
|
|
||
|
|
This program is free software; you can redistribute it and/or
|
||
|
|
modify it under the terms of the GNU General Public License
|
||
|
|
as published by the Free Software Foundation; either version 2
|
||
|
|
of the License, or (at your option) any later version.
|
||
|
|
|
||
|
|
This program is distributed in the hope that it will be useful,
|
||
|
|
but WITHOUT ANY WARRANTY; without even the implied warranty of
|
||
|
|
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
|
||
|
|
GNU General Public License for more details.
|
||
|
|
|
||
|
|
You should have received a copy of the GNU General Public License
|
||
|
|
along with this program; if not, write to the Free Software
|
||
|
|
Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
|
||
|
|
|
||
|
|
For support and installation notes visit http://www.hlxcommunity.com
|
||
|
|
*/
|
||
|
|
if ( !defined('IN_HLSTATS') )
|
||
|
|
{
|
||
|
|
die('Do not access this file directly.');
|
||
|
|
}
|
||
|
|
|
||
|
|
// Contents
|
||
|
|
|
||
|
|
$resultGames = $db->query("
|
||
|
|
SELECT
|
||
|
|
code,
|
||
|
|
name
|
||
|
|
FROM
|
||
|
|
hlstats_Games
|
||
|
|
WHERE
|
||
|
|
hidden='0'
|
||
|
|
ORDER BY
|
||
|
|
realgame, name ASC
|
||
|
|
");
|
||
|
|
|
||
|
|
$num_games = $db->num_rows($resultGames);
|
||
|
|
$redirect_to_game = 0;
|
||
|
|
|
||
|
|
if ($num_games == 1 || $game = valid_request($_GET['game'], 0)) {
|
||
|
|
$redirect_to_game++;
|
||
|
|
if ($num_games == 1) {
|
||
|
|
list($game) = $db->fetch_row($resultGames);
|
||
|
|
}
|
||
|
|
|
||
|
|
include(PAGE_PATH . '/game.php');
|
||
|
|
} else {
|
||
|
|
unset($_SESSION['game']);
|
||
|
|
|
||
|
|
pageHeader(array('Contents'), array('Contents' => ''));
|
||
|
|
include(PAGE_PATH . '/voicecomm_serverlist.php');
|
||
|
|
printSectionTitle('Games');
|
||
|
|
?>
|
||
|
|
|
||
|
|
<div class="subblock">
|
||
|
|
|
||
|
|
<table class="data-table">
|
||
|
|
|
||
|
|
<tr class="data-table-head">
|
||
|
|
<td class="fSmall" width="60%" align="left"> Game</td>
|
||
|
|
<td class="fSmall" width="10%" align="center"> Players</td>
|
||
|
|
<td class="fSmall" width="20%" align="center"> Top Player</td>
|
||
|
|
<td class="fSmall" width="10%" align="center"> Top Clan</td>
|
||
|
|
</tr>
|
||
|
|
|
||
|
|
<?php
|
||
|
|
$nonhiddengamestring = "(";
|
||
|
|
while ($gamedata = $db->fetch_row($resultGames))
|
||
|
|
{
|
||
|
|
$nonhiddengamestring .= "'$gamedata[0]',";
|
||
|
|
$result = $db->query("
|
||
|
|
SELECT
|
||
|
|
playerId,
|
||
|
|
lastName,
|
||
|
|
activity
|
||
|
|
FROM
|
||
|
|
hlstats_Players
|
||
|
|
WHERE
|
||
|
|
game='$gamedata[0]'
|
||
|
|
AND hideranking=0
|
||
|
|
ORDER BY
|
||
|
|
".$g_options['rankingtype']." DESC,
|
||
|
|
(kills/IF(deaths=0,1,deaths)) DESC
|
||
|
|
LIMIT 1
|
||
|
|
");
|
||
|
|
|
||
|
|
if ($db->num_rows($result) == 1)
|
||
|
|
{
|
||
|
|
$topplayer = $db->fetch_row($result);
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$topplayer = false;
|
||
|
|
}
|
||
|
|
|
||
|
|
$result = $db->query("
|
||
|
|
SELECT
|
||
|
|
hlstats_Clans.clanId,
|
||
|
|
hlstats_Clans.name,
|
||
|
|
AVG(hlstats_Players.skill) AS skill,
|
||
|
|
AVG(hlstats_Players.kills) AS kills,
|
||
|
|
COUNT(hlstats_Players.playerId) AS numplayers
|
||
|
|
FROM
|
||
|
|
hlstats_Clans
|
||
|
|
LEFT JOIN
|
||
|
|
hlstats_Players
|
||
|
|
ON
|
||
|
|
hlstats_Players.clan = hlstats_Clans.clanId
|
||
|
|
WHERE
|
||
|
|
hlstats_Clans.game='$gamedata[0]'
|
||
|
|
AND hlstats_Clans.hidden = 0
|
||
|
|
AND hlstats_Players.hideranking=0
|
||
|
|
GROUP BY
|
||
|
|
hlstats_Clans.clanId
|
||
|
|
HAVING
|
||
|
|
".$g_options['rankingtype']." IS NOT NULL
|
||
|
|
AND numplayers >= 3
|
||
|
|
ORDER BY
|
||
|
|
".$g_options['rankingtype']." DESC
|
||
|
|
LIMIT 1
|
||
|
|
");
|
||
|
|
|
||
|
|
if ($db->num_rows($result) == 1)
|
||
|
|
{
|
||
|
|
$topclan = $db->fetch_row($result);
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
$topclan = false;
|
||
|
|
}
|
||
|
|
|
||
|
|
$result= $db->query("
|
||
|
|
SELECT
|
||
|
|
SUM(act_players) AS `act_players`,
|
||
|
|
SUM(max_players) AS `max_players`
|
||
|
|
FROM
|
||
|
|
hlstats_Servers
|
||
|
|
WHERE
|
||
|
|
hlstats_Servers.game='$gamedata[0]'
|
||
|
|
");
|
||
|
|
|
||
|
|
$numplayers = $db->fetch_array($result);
|
||
|
|
if ($numplayers['act_players'] == 0 and $numplayers['max_players'] == 0)
|
||
|
|
$numplayers = false;
|
||
|
|
else
|
||
|
|
$player_string = $numplayers['act_players'].'/'.$numplayers['max_players'];
|
||
|
|
?>
|
||
|
|
<tr class="game-table-row">
|
||
|
|
<td class="game-table-cell" style="height:30px">
|
||
|
|
<div style="float:left;line-height:30px;" class="fHeading"> <a href="<?php echo $g_options['scripturl'] . "?game=$gamedata[0]"; ?>"><img src="<?php
|
||
|
|
$image = getImage("/games/$gamedata[0]/game");
|
||
|
|
if ($image)
|
||
|
|
echo $image['url'];
|
||
|
|
else
|
||
|
|
echo IMAGE_PATH . '/game.gif';
|
||
|
|
?>" style="margin-left: 3px; margin-right: 4px;" alt="Game" /></a><a href="<?php echo $g_options['scripturl'] . "?game=$gamedata[0]"; ?>"><?php echo $gamedata[1]; ?></a>
|
||
|
|
</div>
|
||
|
|
<div style="float:right;">
|
||
|
|
<div style="margin-left: 3px; margin-right: 4px; vertical-align:top; text-align:center;"><a href="<?php echo $g_options['scripturl'] . "?mode=clans&game=$gamedata[0]"; ?>"><img src="<?php echo IMAGE_PATH; ?>/clan.gif" alt="Clan Rankings" /></a></div>
|
||
|
|
<div style="vertical-align:bottom; text-align:left;"> <a href="<?php echo $g_options['scripturl'] . "?mode=clans&game=$gamedata[0]"; ?>" class="fSmall">Clans</a> </div>
|
||
|
|
</div>
|
||
|
|
|
||
|
|
<div style="float:right;">
|
||
|
|
<div style="margin-left: 3px; margin-right: 4px; vertical-align:top; text-align:center;"><a href="<?php echo $g_options['scripturl'] . "?mode=players&game=$gamedata[0]"; ?>"><img src="<?php echo IMAGE_PATH; ?>/player.gif" alt="Player Rankings" /></a></div>
|
||
|
|
<div style="vertical-align:bottom; text-align:left;"> <a href="<?php echo $g_options['scripturl'] . "?mode=players&game=$gamedata[0]"; ?>" class="fSmall">Players</a> </div>
|
||
|
|
</div>
|
||
|
|
</td>
|
||
|
|
<td class="game-table-cell" style="text-align:center;"><?php
|
||
|
|
if ($numplayers)
|
||
|
|
{
|
||
|
|
echo $player_string;
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
echo '-';
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</td>
|
||
|
|
<td class="game-table-cell" style="text-align:center;"><?php
|
||
|
|
if ($topplayer)
|
||
|
|
{
|
||
|
|
echo '<a href="' . $g_options['scripturl'] . '?mode=playerinfo&player='
|
||
|
|
. $topplayer[0] . '">'.htmlspecialchars($topplayer[1], ENT_COMPAT).'</a>';
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
echo '-';
|
||
|
|
}
|
||
|
|
?></td>
|
||
|
|
<td class="game-table-cell" style="text-align:center;"><?php
|
||
|
|
if ($topclan)
|
||
|
|
{
|
||
|
|
echo '<a href="' . $g_options['scripturl'] . '?mode=claninfo&clan='
|
||
|
|
. $topclan[0] . '">'.htmlspecialchars($topclan[1], ENT_COMPAT).'</a>';
|
||
|
|
}
|
||
|
|
else
|
||
|
|
{
|
||
|
|
echo '-';
|
||
|
|
}
|
||
|
|
?></td>
|
||
|
|
</tr>
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
</table>
|
||
|
|
|
||
|
|
</div><br /><br />
|
||
|
|
<br />
|
||
|
|
|
||
|
|
<?php
|
||
|
|
printSectionTitle('General Statistics');
|
||
|
|
|
||
|
|
$nonhiddengamestring = preg_replace('/,$/', ')', $nonhiddengamestring);
|
||
|
|
|
||
|
|
$result = $db->query("SELECT COUNT(playerId) FROM hlstats_Players WHERE game IN $nonhiddengamestring");
|
||
|
|
list($num_players) = $db->fetch_row($result);
|
||
|
|
$num_players = number_format($num_players);
|
||
|
|
|
||
|
|
$result = $db->query("SELECT COUNT(clanId) FROM hlstats_Clans WHERE game IN $nonhiddengamestring");
|
||
|
|
list($num_clans) = $db->fetch_row($result);
|
||
|
|
$num_clans = number_format($num_clans);
|
||
|
|
|
||
|
|
$result = $db->query("SELECT COUNT(serverId) FROM hlstats_Servers WHERE game IN $nonhiddengamestring");
|
||
|
|
list($num_servers) = $db->fetch_row($result);
|
||
|
|
$num_servers = number_format($num_servers);
|
||
|
|
|
||
|
|
$result = $db->query("SELECT SUM(kills) FROM hlstats_Servers WHERE game IN $nonhiddengamestring");
|
||
|
|
list($num_kills) = $db->fetch_row($result);
|
||
|
|
$num_kills = number_format($num_kills);
|
||
|
|
|
||
|
|
$result = $db->query("
|
||
|
|
SELECT
|
||
|
|
eventTime
|
||
|
|
FROM
|
||
|
|
hlstats_Events_Frags
|
||
|
|
ORDER BY
|
||
|
|
id DESC
|
||
|
|
LIMIT 1
|
||
|
|
");
|
||
|
|
list($lastevent) = $db->fetch_row($result);
|
||
|
|
?>
|
||
|
|
|
||
|
|
<div class="subblock">
|
||
|
|
|
||
|
|
<ul>
|
||
|
|
<li><?php
|
||
|
|
echo "<strong>$num_players</strong> players and <strong>$num_clans</strong> clans "
|
||
|
|
. "ranked in <strong>$num_games</strong> games on <strong>$num_servers</strong>"
|
||
|
|
. " servers with <strong>$num_kills</strong> kills."; ?></li>
|
||
|
|
<?php
|
||
|
|
if ($lastevent)
|
||
|
|
{
|
||
|
|
echo "\t\t\t\t<li>Last Kill <strong> " . date('g:i:s A, D. M. d, Y', strtotime($lastevent)) . "</strong></li>";
|
||
|
|
}
|
||
|
|
?>
|
||
|
|
<li>All statistics are generated in real-time. Event history data expires after <strong><?php echo $g_options['DeleteDays']; ?></strong> days.</li>
|
||
|
|
</ul>
|
||
|
|
</div>
|
||
|
|
<?php
|
||
|
|
}
|
||
|
|
?>
|