mysqli_query($con, $sql);
        }
        $players = $team->sMidFields->string;
        foreach ($players as $n => $m) {
            $sql = "UPDATE player SET team_id ={$v->iId} where player_name='{$m}'";
            mysqli_query($con, $sql);
        }
        $players = $team->sForwards->string;
        foreach ($players as $n => $m) {
            $sql = "UPDATE player SET team_id ={$v->iId} where player_name='{$m}'";
            mysqli_query($con, $sql);
        }
    }
}
//---------------------------AllGames-----------------------------------
$result = $client->AllGames(array());
$games = $result->AllGamesResult->tGameInfo;
foreach ($games as $k => $v) {
    $StadiumName = $v->StadiumInfo->sStadiumName;
    $team1 = $v->Team1->iId;
    $team2 = $v->Team2->iId;
    $sql = "insert into game (game_id,game_description,play_date,play_time,result,score,is_champion,iUTC_offset,game_name,team1_id ,team2_id) values\n                      ({$v->iId},'{$v->sDescription}','{$v->dPlayDate}','{$v->tPlayTime}','{$v->sResult}','{$v->sScore}',false,{$v->iUTCOffset},'{$StadiumName}',{$team1},{$team2})";
    if (!mysqli_query($con, $sql)) {
        echo mysqli_error($con);
        die(mysqli_error($con));
    }
}
//---------------------------AllCards-----------------------------------
$result = $client->AllCards(array());
$cards = $result->AllCardsResult->tCardInfo;
foreach ($cards as $k => $v) {