query
("
SELECT
hlstats_PlayerNames.name,
hlstats_PlayerNames.connection_time,
hlstats_PlayerNames.lastuse,
hlstats_PlayerNames.numuses,
hlstats_PlayerNames.kills,
hlstats_PlayerNames.deaths,
IFNULL(ROUND(hlstats_PlayerNames.kills / IF(hlstats_PlayerNames.deaths = 0, 1, hlstats_PlayerNames.deaths), 2), '-') AS kpd,
hlstats_PlayerNames.headshots,
IFNULL(ROUND(hlstats_PlayerNames.headshots / hlstats_PlayerNames.kills, 2), '-') AS hpk,
hlstats_PlayerNames.suicides,
IFNULL(ROUND(hlstats_PlayerNames.hits / hlstats_PlayerNames.shots * 100, 1), 0.0) AS acc
FROM
hlstats_PlayerNames
WHERE
hlstats_PlayerNames.playerId = $player
ORDER BY
$tblAliases->sort $tblAliases->sortorder
LIMIT
$tblAliases->startitem,
$tblAliases->numperpage
");
$resultCount = $db->query
("
SELECT
COUNT(*)
FROM
hlstats_PlayerNames
WHERE
hlstats_PlayerNames.playerId = $player
");
list($numitems) = $db->fetch_row($resultCount);
if ($numitems > 1)
{
?>
0)
{
$tblAliases->draw($result, $numitems, 95);
}
?>