/**
  * For handling the Round Reports list table.
  *
  * @return view
  */
 public function getRoundReports()
 {
     $sortableColumns = ['created_at', 'id', 'round_time', 'swat_score', 'suspects_score', 'map_id'];
     $orderBy = Request::has('orderBy') && in_array(Request::get('orderBy'), $sortableColumns) ? Request::get('orderBy') : 'created_at';
     $sortDir = Request::has('direction') ? Request::get('direction') : 'desc';
     $rounds = Game::normal()->orderBy($orderBy, $sortDir)->paginate(35);
     return view('statistics.round-reports')->with('rounds', $rounds);
 }
 public function getIndex()
 {
     if (!Cookie::has('seen_donation_info')) {
         $cookie = Cookie::make('seen_donation_info', 'true', 21600);
         Cookie::queue($cookie);
         $show_donation = true;
     } else {
         $show_donation = false;
     }
     if (!Cookie::has('seen_add_info')) {
         $cookie = Cookie::make('seen_add_info', 'true', 4320);
         Cookie::queue($cookie);
         $show_add = true;
     } else {
         $show_add = false;
     }
     /*
     $data1 = '{"0":"DUYFu8ao","1":"1.0.0","2":"10480","3":"1437386880","4":"11cc6f19","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19371","16":"569","17":"900","19":"1","21":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"86","11":"1","17":"1","38":"4"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"71","8":"1","9":"1","15":"1","38":"2"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"66","38":"2"}]}';
     
             {"0":"4VPwFgFe","1":"1.2.0","2":"10480","3":"1464673260","4":"39869856","6":"1.0","7":"Swat4 Server","9":"13","11":"1","12":"16","13":"3","14":"5","15":"300","16":"300","17":"900","22":"5","27_0_0":"0","27_0_1":"127.0.0.1","27_0_3":"1","27_0_5":"Kinnngg","27_0_6":"1","27_0_7":"294","27_0_38":"2","27_0_39_0":"10","27_0_39_1":"16","27_0_39_2":"16","27_0_39_3":"25","27_0_39_4":"25","27_0_39_5":"23","27_0_39_6":"25","27_0_39_7":"25","27_0_39_8":"25","27_0_39_9":"3","27_0_39_10":"19","27_0_39_11":"22","27_0_40_0_0":"10","27_0_40_0_1":"277","27_0_40_0_2":"24","27_0_40_1_0":"25","27_0_40_1_1":"8","27_0_40_1_2":"2"}
     
     
     $data2 = '{"0":"AIq1F3LG","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19301","16":"499","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"19"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"4"}]}';
     
     $data3 = '{"0":"FTuq4Tox","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19331","16":"529","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"48","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"33","38":"1"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"28","38":"1"}]}';
     
     $data4 = '{"0":"aoCjMXOs","1":"1.0.0","2":"10480","3":"1437386940","4":"6512549a","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19457","16":"656","17":"900","19":"1","20":"11","21":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","2":"1","5":"YUG_X_Gmr","7":"98","11":"1","17":"1","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"154","8":"1","9":"1","11":"1","14":"2","15":"1","17":"1","38":"2"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"149","8":"10","13":"2","16":"2","38":"2"},{"0":"6","1":"182.181.184.161","5":"YUG_X_Gmr","7":"58","8":"1","9":"1","15":"1","38":"2"}]}';
     
     $data5 = '{"0":"gZzV5JGQ","1":"1.0.0","2":"10480","3":"1437386880","4":"11cc6f19","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19362","16":"560","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"77","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"62","38":"2"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"58","38":"2"}]}';
     
     $data6 = '{"0":"hdr5q4FG","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19343","16":"541","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"60","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"44","38":"2"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"40","38":"2"}]}';
     
     $data6 = '{"0":"jWO6l3xa","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19339","16":"537","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"56","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"40","38":"2"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"36","38":"2"}]}';
     
     $data7 = '{"0":"kZ4Jk2DK","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19334","16":"532","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"51","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"36","38":"2"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"32","38":"2"}]}';
     
     $data8 = '{"0":"yTuq4Toy","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19331","16":"529","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"48","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"33","38":"1"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"28","38":"1"}]}';
     
     $data9 = '{"0":"gcqo6buP","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19331","16":"529","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"48","38":"2"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"33","38":"1"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo","7":"28","38":"1"}]}';
     
     $data10 = '{"0":"rTjAGcAF","1":"1.0.0","2":"10480","3":"1437386820","4":"481b525e","6":"1.0","7":"[c=FFFF00]WWW.KNIGHTofSORROW.TK (Antics)","11":"3","12":"12","13":"1","14":"5","15":"19301","16":"499","17":"900","19":"1","22":"0","27":[{"0":"0","1":"182.185.80.115","2":"1","5":"YUG_X_Gmr","7":"67","38":"2"},{"0":"1","1":"182.185.83.84","2":"1","5":"YUG_X_Gmr","7":"139"},{"0":"2","1":"182.181.216.180","2":"1","5":"||KhaN||Namo(VIEW)","7":"247","11":"1","17":"1","38":"4"},{"0":"3","1":"182.181.184.161","5":"YUG_X_Gmr","7":"20"},{"0":"4","1":"182.185.27.16","5":"RainBoW","6":"1","7":"4"},{"0":"5","1":"182.181.216.180","5":"||KhaN||_Namo"}]}';
     
     
     $s1 = new App\Server\ServerTracker(json_decode($data1,true));
     $s2 = new App\Server\ServerTracker(json_decode($data2,true));
     $s3 = new App\Server\ServerTracker(json_decode($data3,true));
     $s4 = new App\Server\ServerTracker(json_decode($data4,true));
     $s5 = new App\Server\ServerTracker(json_decode($data5,true));
     $s6 = new App\Server\ServerTracker(json_decode($data6,true));
     $s7 = new App\Server\ServerTracker(json_decode($data7,true));
     $s8 = new App\Server\ServerTracker(json_decode($data8,true));
     $s9 = new App\Server\ServerTracker(json_decode($data9,true));
     $s10 = new App\Server\ServerTracker(json_decode($data10,true));
     $s1->track();
     $s2->track();
     $s3->track();
     $s4->track();
     $s5->track();
     $s6->track();
     $s7->track();
     $s8->track();
     $s9->track();
     $s10->track();
     */
     if (Cache::has('top_players')) {
         $topPlayers = Cache::get('top_players');
     } else {
         $topPlayers = \App\PlayerTotal::with(['country', 'rank'])->orderBy('position')->limit(10)->get();
     }
     $latestGames = \App\Game::normal()->orderBy('created_at', 'desc')->limit(5)->get();
     //return (Carbon\Carbon::now()->subYears(100));
     $player = \App\Player::first();
     $AllTime = new \Illuminate\Support\Collection();
     $PastWeek = new \Illuminate\Support\Collection();
     $PastMonth = new \Illuminate\Support\Collection();
     $PastYear = new \Illuminate\Support\Collection();
     if ($player != null) {
         //All Time Total Score
         if (Cache::has('alltime_totalScore')) {
             $AllTime->totalScore = Cache::get('alltime_totalScore');
         } else {
             $AllTime->totalScore = $player->getBestIn('SUM(score) as totalscore', 'totalscore');
             Cache::put('alltime_totalScore', $AllTime->totalScore, 720);
         }
         //All Time Highest Score
         if (Cache::has('alltime_highestScore')) {
             $AllTime->highestScore = Cache::get('alltime_highestScore');
         } else {
             $AllTime->highestScore = $player->getBestIn('MAX(score) as highestscore', 'highestscore');
             Cache::put('alltime_highestScore', $AllTime->highestScore, 720);
         }
         //All Time Total Arrests
         if (Cache::has('alltime_totalArrests')) {
             $AllTime->totalArrests = Cache::get('alltime_totalArrests');
         } else {
             $AllTime->totalArrests = $player->getBestIn('SUM(arrests) as totalarrests', 'totalarrests');
             Cache::put('alltime_totalArrests', $AllTime->totalArrests, 720);
         }
         //All Time Total Arrested
         if (Cache::has('alltime_totalArrested')) {
             $AllTime->totalArrested = Cache::get('alltime_totalArrested');
         } else {
             $AllTime->totalArrested = $player->getBestIn('SUM(arrested) as totalarrested', 'totalarrested');
             Cache::put('alltime_totalArrested', $AllTime->totalArrested, 720);
         }
         //All Time Total Kills
         if (Cache::has('alltime_totalKills')) {
             $AllTime->totalKills = Cache::get('alltime_totalKills');
         } else {
             $AllTime->totalKills = $player->getBestIn('SUM(kills) as totalkills', 'totalkills');
             Cache::put('alltime_totalKills', $AllTime->totalKills, 720);
         }
         //All Time Total Deaths
         if (Cache::has('alltime_totalDeaths')) {
             $AllTime->totalDeaths = Cache::get('alltime_totalDeaths');
         } else {
             $AllTime->totalDeaths = $player->getBestIn('SUM(deaths) as totaldeaths', 'totaldeaths');
             Cache::put('alltime_totalDeaths', $AllTime->totalDeaths, 720);
         }
         //All Time Best Arrest Steak
         if (Cache::has('alltime_bestArrestStreak')) {
             $AllTime->bestArrestStreak = Cache::get('alltime_bestArrestStreak');
         } else {
             $AllTime->bestArrestStreak = $player->getBestIn('MAX(arrest_streak) as best_arrest_streak', 'best_arrest_streak');
             Cache::put('alltime_bestArrestStreak', $AllTime->bestArrestStreak, 720);
         }
         //All Time best Kill Streak
         if (Cache::has('alltime_bestKillStreak')) {
             $AllTime->bestKillStreak = Cache::get('alltime_bestKillStreak');
         } else {
             $AllTime->bestKillStreak = $player->getBestIn('MAX(kill_streak) as best_kill_streak', 'best_kill_streak');
             Cache::put('alltime_bestKillStreak', $AllTime->bestKillStreak, 720);
         }
         //All Time best Death Streak
         if (Cache::has('alltime_bestDeathStreak')) {
             $AllTime->bestDeathStreak = Cache::get('alltime_bestDeathStreak');
         } else {
             $AllTime->bestDeathStreak = $player->getBestIn('MAX(death_streak) as best_death_streak', 'best_death_streak');
             Cache::put('alltime_bestDeathStreak', $AllTime->bestDeathStreak, 720);
         }
         //All Time Total Team Kills
         if (Cache::has('alltime_totalTeamKills')) {
             $AllTime->totalTeamKills = Cache::get('alltime_totalTeamKills');
         } else {
             $AllTime->totalTeamKills = $player->getBestIn('SUM(team_kills) as totalteamkills', 'totalteamkills');
             Cache::put('alltime_totalTeamKills', $AllTime->totalTeamKills, 720);
         }
         //All Time Total Time Played
         if (Cache::has('alltime_totalTimePlayed')) {
             $AllTime->totalTimePlayed = Cache::get('alltime_totalTimePlayed');
         } else {
             $AllTime->totalTimePlayed = $player->getBestIn('SUM(time_played) as totaltimeplayed', 'totaltimeplayed');
             Cache::put('alltime_totalTimePlayed', $AllTime->totalTimePlayed, 720);
         }
         //All Time bestScorePerMin
         if (Cache::has('alltime_bestScorePerMin')) {
             $AllTime->bestScorePerMin = Cache::get('alltime_bestScorePerMin');
         } else {
             $AllTime->bestScorePerMin = $player->getBestIn('SUM(score)/SUM(time_played)*60 as scorepermin', 'scorepermin');
             Cache::put('alltime_bestScorePerMin', $AllTime->bestScorePerMin, 720);
         }
         //dd($AllTime);
         $pastWeekDate = \Carbon\Carbon::now()->subWeek(1);
         //Past Week totalScore
         if (Cache::has('pastweek_totalScore')) {
             $PastWeek->totalScore = Cache::get('pastweek_totalScore');
         } else {
             $PastWeek->totalScore = $player->getBestIn('SUM(score) as totalscore', 'totalscore', $pastWeekDate);
             Cache::put('pastweek_totalScore', $PastWeek->totalScore, 720);
         }
         //Past Week highestScore
         if (Cache::has('pastweek_highestScore')) {
             $PastWeek->highestScore = Cache::get('pastweek_highestScore');
         } else {
             $PastWeek->highestScore = $player->getBestIn('MAX(score) as highestscore', 'highestscore', $pastWeekDate);
             Cache::put('pastweek_highestScore', $PastWeek->highestScore, 720);
         }
         //Past Week totalArrests
         if (Cache::has('pastweek_totalArrests')) {
             $PastWeek->totalArrests = Cache::get('pastweek_totalArrests');
         } else {
             $PastWeek->totalArrests = $player->getBestIn('SUM(arrests) as totalarrests', 'totalarrests', $pastWeekDate);
             Cache::put('pastweek_totalArrests', $PastWeek->totalArrests, 720);
         }
         //Past Week totalArrested
         if (Cache::has('pastweek_totalArrested')) {
             $PastWeek->totalArrested = Cache::get('pastweek_totalArrested');
         } else {
             $PastWeek->totalArrested = $player->getBestIn('SUM(arrested) as totalarrested', 'totalarrested', $pastWeekDate);
             Cache::put('pastweek_totalArrested', $PastWeek->totalArrested, 720);
         }
         //Past Week totalKills
         if (Cache::has('pastweek_totalKills')) {
             $PastWeek->totalKills = Cache::get('pastweek_totalKills');
         } else {
             $PastWeek->totalKills = $player->getBestIn('SUM(kills) as totalkills', 'totalkills', $pastWeekDate);
             Cache::put('pastweek_totalKills', $PastWeek->totalKills, 720);
         }
         //Past Week totalDeaths
         if (Cache::has('pastweek_totalDeaths')) {
             $PastWeek->totalDeaths = Cache::get('pastweek_totalDeaths');
         } else {
             $PastWeek->totalDeaths = $player->getBestIn('SUM(deaths) as totaldeaths', 'totaldeaths', $pastWeekDate);
             Cache::put('pastweek_totalDeaths', $PastWeek->totalDeaths, 720);
         }
         //Past Week bestArrestStreak
         if (Cache::has('pastweek_bestArrestStreak')) {
             $PastWeek->bestArrestStreak = Cache::get('pastweek_bestArrestStreak');
         } else {
             $PastWeek->bestArrestStreak = $player->getBestIn('MAX(arrest_streak) as best_arrest_streak', 'best_arrest_streak', $pastWeekDate);
             Cache::put('pastweek_bestArrestStreak', $PastWeek->bestArrestStreak, 720);
         }
         //Past Week bestKillStreak
         if (Cache::has('pastweek_bestKillStreak')) {
             $PastWeek->bestKillStreak = Cache::get('pastweek_bestKillStreak');
         } else {
             $PastWeek->bestKillStreak = $player->getBestIn('MAX(kill_streak) as best_kill_streak', 'best_kill_streak', $pastWeekDate);
             Cache::put('pastweek_bestKillStreak', $PastWeek->bestKillStreak, 720);
         }
         //Past Week bestDeathStreak
         if (Cache::has('pastweek_bestDeathStreak')) {
             $PastWeek->bestDeathStreak = Cache::get('pastweek_bestDeathStreak');
         } else {
             $PastWeek->bestDeathStreak = $player->getBestIn('MAX(death_streak) as best_death_streak', 'best_death_streak', $pastWeekDate);
             Cache::put('pastweek_bestDeathStreak', $PastWeek->bestDeathStreak, 720);
         }
         //Past Week totalTeamKills
         if (Cache::has('pastweek_totalTeamKills')) {
             $PastWeek->totalTeamKills = Cache::get('pastweek_totalTeamKills');
         } else {
             $PastWeek->totalTeamKills = $player->getBestIn('SUM(team_kills) as totalteamkills', 'totalteamkills', $pastWeekDate);
             Cache::put('pastweek_totalTeamKills', $PastWeek->totalTeamKills, 720);
         }
         //Past Week totalTimePlayed
         if (Cache::has('pastweek_totalTimePlayed')) {
             $PastWeek->totalTimePlayed = Cache::get('pastweek_totalTimePlayed');
         } else {
             $PastWeek->totalTimePlayed = $player->getBestIn('SUM(time_played) as totaltimeplayed', 'totaltimeplayed', $pastWeekDate);
             Cache::put('pastweek_totalTimePlayed', $PastWeek->totalTimePlayed, 720);
         }
         //Past Week bestScorePerMin
         if (Cache::has('pastweek_bestScorePerMin')) {
             $PastWeek->bestScorePerMin = Cache::get('pastweek_bestScorePerMin');
         } else {
             $PastWeek->bestScorePerMin = $player->getBestIn('SUM(score)/SUM(time_played)*60 as scorepermin', 'scorepermin', $pastWeekDate);
             Cache::put('pastweek_bestScorePerMin', $PastWeek->bestScorePerMin, 720);
         }
         $pastMonthDate = \Carbon\Carbon::now()->subMonth(1);
         //Past Month totalScore
         if (Cache::has('pastmonth_totalScore')) {
             $PastMonth->totalScore = Cache::get('pastmonth_totalScore');
         } else {
             $PastMonth->totalScore = $player->getBestIn('SUM(score) as totalscore', 'totalscore', $pastMonthDate);
             Cache::put('pastmonth_totalScore', $PastMonth->totalScore, 720);
         }
         //Past Month highestScore
         if (Cache::has('pastmonth_highestScore')) {
             $PastMonth->highestScore = Cache::get('pastmonth_highestScore');
         } else {
             $PastMonth->highestScore = $player->getBestIn('MAX(score) as highestscore', 'highestscore', $pastMonthDate);
             Cache::put('pastmonth_highestScore', $PastMonth->highestScore, 720);
         }
         //Past Month totalArrests
         if (Cache::has('pastmonth_totalArrests')) {
             $PastMonth->totalArrests = Cache::get('pastmonth_totalArrests');
         } else {
             $PastMonth->totalArrests = $player->getBestIn('SUM(arrests) as totalarrests', 'totalarrests', $pastMonthDate);
             Cache::put('pastmonth_totalArrests', $PastMonth->totalArrests, 720);
         }
         //Past Month totalArrested
         if (Cache::has('pastmonth_totalArrested')) {
             $PastMonth->totalArrested = Cache::get('pastmonth_totalArrested');
         } else {
             $PastMonth->totalArrested = $player->getBestIn('SUM(arrested) as totalarrested', 'totalarrested', $pastMonthDate);
             Cache::put('pastmonth_totalArrested', $PastMonth->totalArrested, 720);
         }
         //Past Month totalKills
         if (Cache::has('pastmonth_totalKills')) {
             $PastMonth->totalKills = Cache::get('pastmonth_totalKills');
         } else {
             $PastMonth->totalKills = $player->getBestIn('SUM(kills) as totalkills', 'totalkills', $pastMonthDate);
             Cache::put('pastmonth_totalKills', $PastMonth->totalKills, 720);
         }
         //Past Month totalDeaths
         if (Cache::has('pastmonth_totalDeaths')) {
             $PastMonth->totalDeaths = Cache::get('pastmonth_totalDeaths');
         } else {
             $PastMonth->totalDeaths = $player->getBestIn('SUM(deaths) as totaldeaths', 'totaldeaths', $pastMonthDate);
             Cache::put('pastmonth_totalDeaths', $PastMonth->totalDeaths, 720);
         }
         //Past Month bestArrestStreak
         if (Cache::has('pastmonth_bestArrestStreak')) {
             $PastMonth->bestArrestStreak = Cache::get('pastmonth_bestArrestStreak');
         } else {
             $PastMonth->bestArrestStreak = $player->getBestIn('MAX(arrest_streak) as best_arrest_streak', 'best_arrest_streak', $pastMonthDate);
             Cache::put('pastmonth_bestArrestStreak', $PastMonth->bestArrestStreak, 720);
         }
         //Past Month bestKillStreak
         if (Cache::has('pastmonth_bestKillStreak')) {
             $PastMonth->bestKillStreak = Cache::get('pastmonth_bestKillStreak');
         } else {
             $PastMonth->bestKillStreak = $player->getBestIn('MAX(kill_streak) as best_kill_streak', 'best_kill_streak', $pastMonthDate);
             Cache::put('pastmonth_bestKillStreak', $PastMonth->bestKillStreak, 720);
         }
         //Past Month bestDeathStreak
         if (Cache::has('pastmonth_bestDeathStreak')) {
             $PastMonth->bestDeathStreak = Cache::get('pastmonth_bestDeathStreak');
         } else {
             $PastMonth->bestDeathStreak = $player->getBestIn('MAX(death_streak) as best_death_streak', 'best_death_streak', $pastMonthDate);
             Cache::put('pastmonth_bestDeathStreak', $PastMonth->bestDeathStreak, 720);
         }
         //Past Month totalTeamKills
         if (Cache::has('pastmonth_totalTeamKills')) {
             $PastMonth->totalTeamKills = Cache::get('pastmonth_totalTeamKills');
         } else {
             $PastMonth->totalTeamKills = $player->getBestIn('SUM(team_kills) as totalteamkills', 'totalteamkills', $pastMonthDate);
             Cache::put('pastmonth_totalTeamKills', $PastMonth->totalTeamKills, 720);
         }
         //Past Month totalTimePlayed
         if (Cache::has('pastmonth_totalTimePlayed')) {
             $PastMonth->totalTimePlayed = Cache::get('pastmonth_totalTimePlayed');
         } else {
             $PastMonth->totalTimePlayed = $player->getBestIn('SUM(time_played) as totaltimeplayed', 'totaltimeplayed', $pastMonthDate);
             Cache::put('pastmonth_totalTimePlayed', $PastMonth->totalTimePlayed, 720);
         }
         //Past Month bestScorePerMin
         if (Cache::has('pastmonth_bestScorePerMin')) {
             $PastMonth->bestScorePerMin = Cache::get('pastmonth_bestScorePerMin');
         } else {
             $PastMonth->bestScorePerMin = $player->getBestIn('SUM(score)/SUM(time_played)*60 as scorepermin', 'scorepermin', $pastMonthDate);
             Cache::put('pastmonth_bestScorePerMin', $PastMonth->bestScorePerMin, 720);
         }
         $pastYearDate = \Carbon\Carbon::now()->subYear(1);
         //Past Year totalScore
         if (Cache::has('pastyear_totalScore')) {
             $PastYear->totalScore = Cache::get('pastyear_totalScore');
         } else {
             $PastYear->totalScore = $player->getBestIn('SUM(score) as totalscore', 'totalscore', $pastYearDate);
             Cache::put('pastyear_totalScore', $PastYear->totalScore, 720);
         }
         //Past Year highestScore
         if (Cache::has('pastyear_highestScore')) {
             $PastYear->highestScore = Cache::get('pastyear_highestScore');
         } else {
             $PastYear->highestScore = $player->getBestIn('MAX(score) as highestscore', 'highestscore', $pastYearDate);
             Cache::put('pastyear_highestScore', $PastYear->highestScore, 720);
         }
         //Past Year totalArrests
         if (Cache::has('pastyear_totalArrests')) {
             $PastYear->totalArrests = Cache::get('pastyear_totalArrests');
         } else {
             $PastYear->totalArrests = $player->getBestIn('SUM(arrests) as totalarrests', 'totalarrests', $pastYearDate);
             Cache::put('pastyear_totalArrests', $PastYear->totalArrests, 720);
         }
         //Past Year totalArrested
         if (Cache::has('pastyear_totalArrested')) {
             $PastYear->totalArrested = Cache::get('pastyear_totalArrested');
         } else {
             $PastYear->totalArrested = $player->getBestIn('SUM(arrested) as totalarrested', 'totalarrested', $pastYearDate);
             Cache::put('pastyear_totalArrested', $PastYear->totalArrested, 720);
         }
         //Past Year totalKills
         if (Cache::has('pastyear_totalKills')) {
             $PastYear->totalKills = Cache::get('pastyear_totalKills');
         } else {
             $PastYear->totalKills = $player->getBestIn('SUM(kills) as totalkills', 'totalkills', $pastYearDate);
             Cache::put('pastyear_totalKills', $PastYear->totalKills, 720);
         }
         //Past Year totalDeaths
         if (Cache::has('pastyear_totalDeaths')) {
             $PastYear->totalDeaths = Cache::get('pastyear_totalDeaths');
         } else {
             $PastYear->totalDeaths = $player->getBestIn('SUM(deaths) as totaldeaths', 'totaldeaths', $pastYearDate);
             Cache::put('pastyear_totalDeaths', $PastYear->totalDeaths, 720);
         }
         //Past Year bestArrestStreak
         if (Cache::has('pastyear_bestArrestStreak')) {
             $PastYear->bestArrestStreak = Cache::get('pastyear_bestArrestStreak');
         } else {
             $PastYear->bestArrestStreak = $player->getBestIn('MAX(arrest_streak) as best_arrest_streak', 'best_arrest_streak', $pastYearDate);
             Cache::put('pastyear_bestArrestStreak', $PastYear->bestArrestStreak, 720);
         }
         //Past Year bestKillStreak
         if (Cache::has('pastyear_bestKillStreak')) {
             $PastYear->bestKillStreak = Cache::get('pastyear_bestKillStreak');
         } else {
             $PastYear->bestKillStreak = $player->getBestIn('MAX(kill_streak) as best_kill_streak', 'best_kill_streak', $pastYearDate);
             Cache::put('pastyear_bestKillStreak', $PastYear->bestKillStreak, 720);
         }
         //Past Year bestDeathStreak
         if (Cache::has('pastyear_bestDeathStreak')) {
             $PastYear->bestDeathStreak = Cache::get('pastyear_bestDeathStreak');
         } else {
             $PastYear->bestDeathStreak = $player->getBestIn('MAX(death_streak) as best_death_streak', 'best_death_streak', $pastYearDate);
             Cache::put('pastyear_bestDeathStreak', $PastYear->bestDeathStreak, 720);
         }
         //Past Year totalTeamKills
         if (Cache::has('pastyear_totalTeamKills')) {
             $PastYear->totalTeamKills = Cache::get('pastyear_totalTeamKills');
         } else {
             $PastYear->totalTeamKills = $player->getBestIn('SUM(team_kills) as totalteamkills', 'totalteamkills', $pastYearDate);
             Cache::put('pastyear_totalTeamKills', $PastYear->totalTeamKills, 720);
         }
         //Past Year totalTimePlayed
         if (Cache::has('pastyear_totalTimePlayed')) {
             $PastYear->totalTimePlayed = Cache::get('pastyear_totalTimePlayed');
         } else {
             $PastYear->totalTimePlayed = $player->getBestIn('SUM(time_played) as totaltimeplayed', 'totaltimeplayed', $pastYearDate);
             Cache::put('pastyear_totalTimePlayed', $PastYear->totalTimePlayed, 720);
         }
         //Past Year bestScorePerMin
         if (Cache::has('pastyear_bestScorePerMin')) {
             $PastYear->bestScorePerMin = Cache::get('pastyear_bestScorePerMin');
         } else {
             $PastYear->bestScorePerMin = $player->getBestIn('SUM(score)/SUM(time_played)*60 as scorepermin', 'scorepermin', $pastYearDate);
             Cache::put('pastyear_bestScorePerMin', $PastYear->bestScorePerMin, 720);
         }
     } else {
         $AllTime->totalScore = 0;
         $AllTime->highestScore = 0;
         $AllTime->totalArrests = 0;
         $AllTime->totalArrested = 0;
         $AllTime->totalKills = 0;
         $AllTime->totalDeaths = 0;
         $AllTime->bestArrestStreak = 0;
         $AllTime->bestKillStreak = 0;
         $AllTime->bestDeathStreak = 0;
         $AllTime->totalTeamKills = 0;
         $AllTime->totalTimePlayed = 0;
         $AllTime->bestScorePerMin = 0;
         $pastWeekDate = \Carbon\Carbon::now()->subWeek(1);
         $PastWeek->totalScore = 0;
         $PastWeek->highestScore = 0;
         $PastWeek->totalArrests = 0;
         $PastWeek->totalArrested = 0;
         $PastWeek->totalKills = 0;
         $PastWeek->totalDeaths = 0;
         $PastWeek->bestArrestStreak = 0;
         $PastWeek->bestKillStreak = 0;
         $PastWeek->bestDeathStreak = 0;
         $PastWeek->totalTeamKills = 0;
         $PastWeek->totalTimePlayed = 0;
         $PastWeek->bestScorePerMin = 0;
         $pastMonthDate = \Carbon\Carbon::now()->subMonth(1);
         $PastMonth->totalScore = 0;
         $PastMonth->highestScore = 0;
         $PastMonth->totalArrests = 0;
         $PastMonth->totalArrested = 0;
         $PastMonth->totalKills = 0;
         $PastMonth->totalDeaths = 0;
         $PastMonth->bestArrestStreak = 0;
         $PastMonth->bestKillStreak = 0;
         $PastMonth->bestDeathStreak = 0;
         $PastMonth->totalTeamKills = 0;
         $PastMonth->totalTimePlayed = 0;
         $PastMonth->bestScorePerMin = 0;
         $pastYearDate = \Carbon\Carbon::now()->subYear(1);
         $PastYear->totalScore = 0;
         $PastYear->highestScore = 0;
         $PastYear->totalArrests = 0;
         $PastYear->totalArrested = 0;
         $PastYear->totalKills = 0;
         $PastYear->totalDeaths = 0;
         $PastYear->bestArrestStreak = 0;
         $PastYear->bestKillStreak = 0;
         $PastYear->bestDeathStreak = 0;
         $PastYear->totalTeamKills = 0;
         $PastYear->totalTimePlayed = 0;
         $PastYear->bestScorePerMin = 0;
     }
     if ($PastYear->totalScore == null) {
         $PastYear = $AllTime;
     }
     if ($PastMonth->totalScore == null) {
         $PastMonth = $PastYear;
     }
     if ($PastWeek->totalScore == null) {
         $PastWeek = $PastMonth;
     }
     //Latest Feeds
     //$feeds  = Status::with('user')->latest()->limit(5)->get();
     $notifications = Notification::stream()->latest()->limit(5)->get();
     $activeUsers = User::orderBy('updated_at', 'DESC')->limit(50)->get();
     $bans = Ban::orderBy('updated_at', 'desc')->limit(5)->get();
     $array = ['topPlayers' => $topPlayers, 'latestGames' => $latestGames, 'AllTime' => $AllTime, 'PastWeek' => $PastWeek, 'PastMonth' => $PastMonth, 'PastYear' => $PastYear, 'bans' => $bans, 'notifications' => $notifications, 'activeUsers' => $activeUsers, 'show_donation' => $show_donation, 'show_add' => $show_add];
     return view('home', $array);
 }