public function retrieveStatsEbot($matchId)
     {
        $fileRemoteMatch=config('tg.fileRemoteMatch');
        $serversEbot=config('tg.serversEbot');

        foreach ($serversEbot as $server) {
             $file=file_get_contents($server.'/'.$fileRemoteMatch);

             $matchsResult=json_decode(str_replace("'", '"', trim(str_replace('},]', '}]', $file))),true);

             foreach ($matchsResult as $match) {
                if ($match["status"] == 13) {
                    $this->retrieveStatsEbots($match["id"]);
                }
             }
        }

         $this->retrieveStatsEbots($matchId);
        return "hola";
    }


    public function getMatchIpServer($matchId){
        Config::set('database.default', 'ebot');
        DB::connection('ebot');
        $matchBot=MatchBot::find($matchId);
        return $matchBot->ip;

    }

    public function retrieveStatsEbots($matchId) {
        $getEbotUsers = $this->getEbotUsers($matchId);
        $getMatchIpServer=$this->getMatchIpServer($matchId);
        Config::set('database.default', 'mysql');
        DB::connection('mysql');

        $ipExplode=explode(":", $getMatchIpServer);

        $gameServer = new GameServer();
        $getGameServerByIp=$gameServer->getGameServerByIp($ipExplode[0],$ipExplode[1]);

        $GameServerModel=GameServer::find($getGameServerByIp->id);
        $GameServerModel->status=0;
        $GameServerModel->users_count=1;
        $GameServerModel->password='';
        $GameServerModel->save();


        $Statitems = new Statitems();

        foreach ($getEbotUsers as $player) {
            $user = new UserGame();

            $steamId=explode(":", $player['steamid']);

            if(count($steamId)>1){
                $getByRemoreId = $user->getByRemoreId($steamId[2]);
            }else{
                $getByRemoreId = $user->getByRemoreId($steamId[1]);
            }

            if ($getByRemoreId) {
                $kills=0;
                $deaths=0;
                $modifyKd=false;
                foreach ($player as $key => $attPlayer) {
                    $getStatByName = $Statitems->getStatByName($key, 1);
                    if ($getStatByName) {
                        if ($attPlayer > 0) {
                            $ScorePlayer = new ScorePlayer();

                            $getScoreUserAndMatch = $ScorePlayer->getScoreUserAndMatch($getByRemoreId->user_id, $matchId, $getStatByName->id)->count();

                            if ($getScoreUserAndMatch == 0) {
                                if($getStatByName->id==40){
                                    $kills=$attPlayer;
                                    $modifyKd=true;
                                }
                                if($getStatByName->id==42){
                                    $deaths=$attPlayer;
                                    $modifyKd=true;
                                }
                                $ScorePlayer->statitem_id = $getStatByName->id;
                                $ScorePlayer->value = $attPlayer;
                                $ScorePlayer->user_id = $getByRemoreId->user_id;
                                $ScorePlayer->match_id = $matchId;
                                $ScorePlayer->save();
                            }
                        }
                    }
                }
                if($modifyKd){
                    if($deaths!=0){
                        $score=$kills/$deaths;
                    }else{
                        $score=$kills;
                    }
                     if($getByRemoreId->score==0){
                        $getByRemoreId->score=$score;
                    }else{
                        $getByRemoreId->score=(($getByRemoreId->score+$score)/2);
                    }
                    $getByRemoreId->save();
                }

            }
        }
    }

    public function getEbotUsers($matchId) {


        Config::set('database.default', 'ebot');
        DB::connection('ebot');
        $players = new Playerbot();
        $playersModel = $players->where('match_id', $matchId)->get();

        $ebotUsers = array();
        foreach ($playersModel as $player) {
            $ebotUsers[] = $player->toArray();
        }

        return $ebotUsers;
    }