コード例 #1
0
ファイル: database.php プロジェクト: ADarkHero/HexaTriad
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);
        }
    }
}