We could not synchronize checks via GitHub's checks API since Scrutinizer's GitHub App is not installed for this repository.
@@ -98,7 +98,7 @@ |
||
98 | 98 | global $player, $db; |
99 | 99 | $offset = $minRank - 1; |
100 | 100 | $limit = $maxRank - $offset; |
101 | - $db->query('SELECT alliance_id, alliance_' . $stat . ' AS amount FROM alliance WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY amount DESC, alliance_name LIMIT ' . $offset. ', ' . $limit); |
|
101 | + $db->query('SELECT alliance_id, alliance_' . $stat . ' AS amount FROM alliance WHERE game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY amount DESC, alliance_name LIMIT ' . $offset . ', ' . $limit); |
|
102 | 102 | return self::collectAllianceRankings($db, $player, $offset); |
103 | 103 | } |
104 | 104 |
@@ -25,7 +25,7 @@ |
||
25 | 25 | $template->assign('OurRank', $ourRank); |
26 | 26 | } |
27 | 27 | |
28 | -$expRanks = function (int $minRank, int $maxRank) use ($player, $db) : array { |
|
28 | +$expRanks = function(int $minRank, int $maxRank) use ($player, $db) : array { |
|
29 | 29 | $offset = $minRank - 1; |
30 | 30 | $limit = $maxRank - $offset; |
31 | 31 | $db->query('SELECT alliance_id, COALESCE(SUM(experience), 0) amount |
@@ -28,7 +28,7 @@ |
||
28 | 28 | $template->assign('OurRank', $ourRank); |
29 | 29 | } |
30 | 30 | |
31 | -$profitRanks = function (int $minRank, int $maxRank) use ($player, $db, $profitTypeEscaped) : array { |
|
31 | +$profitRanks = function(int $minRank, int $maxRank) use ($player, $db, $profitTypeEscaped) : array { |
|
32 | 32 | $offset = $minRank - 1; |
33 | 33 | $limit = $maxRank - $offset; |
34 | 34 | $db->query('SELECT alliance_id, COALESCE(SUM(amount), 0) amount |
@@ -24,7 +24,7 @@ |
||
24 | 24 | |
25 | 25 | $totalPlayers = $player->getGame()->getTotalPlayers(); |
26 | 26 | |
27 | -$profitRanks = function (int $minRank, int $maxRank) use ($player, $db, $profitTypeEscaped) : array { |
|
27 | +$profitRanks = function(int $minRank, int $maxRank) use ($player, $db, $profitTypeEscaped) : array { |
|
28 | 28 | $offset = $minRank - 1; |
29 | 29 | $limit = $maxRank - $offset; |
30 | 30 | $db->query('SELECT p.*, COALESCE(ph.amount,0) amount FROM player p LEFT JOIN player_hof ph ON p.account_id = ph.account_id AND p.game_id = ph.game_id AND ph.type = ' . $profitTypeEscaped . ' WHERE p.game_id = ' . $db->escapeNumber($player->getGameID()) . ' ORDER BY amount DESC, player_name ASC LIMIT ' . $offset . ', ' . $limit); |