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); |