function updatePoints($id, $user, $pointbonus) { $playerpoint = getPlayerColor($id, $user); if ($playerpoint == "red") { $playerpoint = "PointsR"; $playerpoint2 = "PointsB"; $opponent = "PlayerBlue"; } else { $playerpoint = "PointsB"; $playerpoint2 = "PointsR"; $opponent = "PlayerRed"; } $sql = "SELECT " . $playerpoint . " FROM field WHERE FieldID = '{$id}'"; $result = mysql_query($sql); if ($result) { while ($ar = mysql_fetch_array($result, MYSQL_ASSOC)) { $points = $ar[$playerpoint]; } } $points = $points + $pointbonus; $sql = "UPDATE field SET " . $playerpoint . "='{$points}' WHERE FieldID = '{$id}'"; mysql_query($sql); //Win-Condition $field = new hand(getField($id), true); $fieldcards = $field->countHand(); $status = getGameStatus($id); if (($points > 36 || $fieldcards == 36) && $status == 1) { $sql = "SELECT " . $playerpoint2 . " FROM field WHERE FieldID = '{$id}'"; $result = mysql_query($sql); if ($result) { while ($ar = mysql_fetch_array($result, MYSQL_ASSOC)) { $points2 = $ar[$playerpoint2]; } } $sql = "SELECT " . $opponent . " FROM field WHERE FieldID = '{$id}'"; $result = mysql_query($sql); if ($result) { while ($ar = mysql_fetch_array($result, MYSQL_ASSOC)) { $player = $ar[$playerpoint2]; } } if ($points == $points2) { drawgame($id, $user, $player); } elseif ($points > $points2) { $playercolor = getPlayerColor($id, $user); wingame($id, $user, $player, $playercolor); } else { $playercolor = getPlayerColor($id, $player); wingame($id, $player, $user, $playercolor); } } }