}
//---------------------------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) {
if ($v->bYellowCard == 'true') {
$sql = "insert into card (card_id,iminutes,card_color) value({$k}+1,{$v->iMinute},'yellow')";
mysqli_query($con, $sql);
} else {
$sql = "insert into card (card_id,iminutes,card_color) value({$k}+1,{$v->iMinute},'red')";
mysqli_query($con, $sql);
}
$playerid = "select player_id from player where player_name='{$v->sPlayerName}'";
$playerID = $con->query($playerid);
if ($playerID->num_rows > 0) {
while ($row = $playerID->fetch_assoc()) {
$id = $row["player_id"];
$cardId = $k + 1;
