Filter out high Bot Bootcamp players.

[iBotPeaches]

We find in situations some players are padding leaderboards via immense amount of "Bot Bootcamp" (ie playing bots)

We will run a task at the end of an update to get a summarized (groupBy) and check for the bootcamp being over some value (somewhere between 20-50%)

Check the top ten people to see an average.

        $playlistBreakdown = DB::query()
            ->from('game_players')
            ->select('playlists.name', new Expression('COUNT(*) as total'))
            ->where('player_id', $this->id)
            ->join('games', 'game_players.game_id', '=', 'games.id')
            ->join('playlists', 'games.playlist_id', '=', 'playlists.id')
            ->groupBy('playlists.name')
            ->get();

SELECT
    `playlists`.`name`,
    COUNT(*) AS total
FROM
    `game_players`
INNER JOIN `games` ON `game_players`.`game_id` = `games`.`id`
INNER JOIN `playlists` ON `games`.`playlist_id` = `playlists`.`id`
WHERE
    `player_id` = 1
GROUP BY
    `playlists`.`name`
ORDER BY
    total
DESC
    ;

[iBotPeaches]

{"name":"Ranked Arena","total":"1342"},
{"name":"Big Team Battle","total":"171"},
{"name":"Fracture: Tenrai - Fiesta","total":"60"},
{"name":"Super Fiesta","total":"45"},
{"name":"Quick Play","total":"35"},
{"name":"Community Collection","total":"24"},
{"name":"Cyber Showdown - Attrition","total":"20"},
{"name":"Tactical Slayer","total":"19"},
{"name":"Last Spartan Standing","total":"15"},
{"name":"Entrenched","total":"15"},
{"name":"Ranked Doubles","total":"12"},
{"name":"Squad Battle","total":"12"},
{"name":"Team Slayer","total":"12"},
{"name":"Ranked Survivors","total":"10"},
{"name":"Land Grab","total":"7"},
{"name":"Infection","total":"5"},
{"name":"Team Doubles","total":"4"},
{"name":"Big Team Social","total":"4"},
{"name":"Team Snipers","total":"4"},
{"name":"FFA Slayer","total":"3"},
{"name":"King of the Hill","total":"2"},
{"name":"New BTB Unlimited","total":"2"},
{"name":"Bot Bootcamp","total":"2"},
{"name":"Social Skirmish","total":"2"},
{"name":"Joint Ops","total":"2"},
{"name":"Ranked Slayer","total":"1"},
{"name":"Team Survivors","total":"1"}

me

{"name":"Super Fiesta","total":"5270"},
{"name":"Team Slayer","total":"1186"},
{"name":"Big Team Battle","total":"359"},
{"name":"Big Team Social","total":"256"},
{"name":"Ranked Arena","total":"221"},
{"name":"Quick Play","total":"177"},
{"name":"Community Collection","total":"147"},
{"name":"Land Grab","total":"86"},
{"name":"Team Doubles","total":"70"},
{"name":"Ranked Doubles","total":"63"},
{"name":"Tactical Slayer","total":"62"},
{"name":"Entrenched","total":"62"},
{"name":"Team Snipers","total":"50"},
{"name":"Bot Bootcamp","total":"46"},
{"name":"Last Spartan Standing","total":"26"},
{"name":"Rumble Pit","total":"22"},
{"name":"Social Slayer","total":"17"},
{"name":"Ranked Survivors","total":"4"},
{"name":"Ranked FFA","total":"4"},
{"name":"Joint Ops","total":"1"},
{"name":"Fracture: Tenrai - Fiesta","total":"1"}

Random Top Ten user

[iBotPeaches]

Top Ten user with a lot of botcamp.

{"name":"Bot Bootcamp","total":"7427"},
{"name":"Quick Play","total":"1105"},
{"name":"Social Slayer","total":"202"},
{"name":"Social Skirmish","total":"93"},
{"name":"Tactical Slayer","total":"70"},
{"name":"Big Team Social","total":"67"},
{"name":"Team Slayer","total":"44"},
{"name":"Squad Battle","total":"22"},
{"name":"New BTB Unlimited","total":"10"},
{"name":"Dredge 24\/7","total":"9"},
{"name":"Community Collection","total":"8"},
{"name":"Combat Workshop - BTB Heavies","total":"2"},
{"name":"Big Team Battle","total":"2"},
{"name":"Joint Ops","total":"1"},
{"name":"Lone Wolves","total":"1"},
{"name":"Super Fiesta","total":"1"}

[iBotPeaches]

Merged the first part. Want to be sure we properly flag users.