Skip to content

Instantly share code, notes, and snippets.

@auxiliary-character
Last active August 29, 2015 14:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save auxiliary-character/d860760cdbf29b6c4bbe to your computer and use it in GitHub Desktop.
Save auxiliary-character/d860760cdbf29b6c4bbe to your computer and use it in GitHub Desktop.
<?php
function getTopPlayers($mysqli, $dbPrefix, $stat, $page)
{
$query;
switch ($stat) {
//irrelevant stuff removed
default:
$query = "SELECT player_id,SUM(?) AS value FROM {?}player "
. (usesSnapshots($mysqli, $dbPrefix) ? " WHERE snapshot_name='main_snapshot'" : "")
. " GROUP BY player_id ORDER BY SUM(?) DESC LIMIT 15 OFFSET ?";
}
$result = $mysqli->query($query,getDatabaseColumnNameFromPlayerStat($stat),$dbPrefix,getDatabaseColumnNameFromPlayerStat($stat),(($page - 1) * 15));
return $result;
}
?>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment