Форум программистов [Powered by Invision Power Board]

Код

 $colors = array('black', 'white');
        if (!empty($_POST['color'])) {
            $color = $_POST['color'];
        }

        else
            $color = $colors[mt_rand(0, 1)];
        if ($color == 'white') {
            $white = $_SESSION['user_id'];
            $black = 0;
        }
        if ($color == 'black') {
            $black = $_SESSION['user_id'];
            $white = 0;
        }
        $cost = (int) $_POST['cost'];
        $time_start = date("Y-m-d H:i:s");
        $pawnWhiteFields = array('a2', 'b2', 'c2', 'd2', 'e2', 'f2', 'g2', 'h2');
        $pawnBlackFields = array('a7', 'b7', 'c7', 'd7', 'e7', 'f7', 'g7', 'h7');
        $rookWhiteFields = array('a1', 'h1');
        $rookBlackFields = array('a8', 'h8');
        $knightWhiteFields = array('b1', 'g1');
        $knightBlackFields = array('b8', 'g8');
        $bishopWhiteFields = array('c1', 'f1');
        $bishopBlackFields = array('c8', 'f8');
        mysql_query("INSERT INTO chess_games(white_player, black_player, time_start, cost) VALUES('$white', '$black', '$time_start', '$cost')");
        if (!mysql_error()) {
            $gameId = mysql_insert_id();
            $sql = '';
            $updated = date("Y-m-d H:i:s");
            for ($i = 0; $i < 8; $i++) {
                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'p', 'white', '$pawnWhiteFields[$i]', '$updated');";
                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'p', 'black', '$pawnBlackFields[$i]', '$updated');";
                //header("Location: index.php?gameid=".mysql_insert_id());
            }
            for ($i = 0; $i < 2; $i++) {
                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'r', 'white', '$rookWhiteFields[$i]', '$updated');";
                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'r', 'black', '$rookBlackFields[$i]', '$updated');";

                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'k', 'white', '$knightWhiteFields[$i]', '$updated');";
                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'k', 'black', '$knightBlackFields[$i]', '$updated');";

                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'b', 'white', '$bishopWhiteFields[$i]', '$updated');";
                $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'b', 'black', '$bishopBlackFields[$i]', '$updated');";
            }
            $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'q', 'white', 'd1', '$updated');";
            $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'q', 'black', 'd8', '$updated');";

            $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'k', 'white', 'e1', '$updated');";
            $sql.= "INSERT INTO chess_positions(game_id, piece_type, piece_color, 
                piece_field, updated) VALUES ('$gameId', 'k', 'black', 'e8', '$updated');";