game_edit.php

<?php
// game_edit.php

require_once 'auth_check.php';
require_once 'db_connection.php';
session_start();
requireRole('Jogador');

// 1) Connect
$pdo = getDBConnection();
// 2) Set @myEmail
$loggedEmail = $_SESSION['dbUser'];
$pdo->exec("SET @myEmail = '" . addslashes($loggedEmail) . "'");

// 3) Which game?
$gameID = $_GET['id'] ?? null;
if (!$gameID) {
    die("No game ID specified.");
}

// 4) If POST => “Guardar” or “Retroceder”
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Gather form fields
    $newDescricao  = $_POST['descricao'] ?? '';
    $newIntervaloMinimoAlertas = (int)($_POST['intervalo'] ?? 0);

    // Convert radio “sim”/“nao” to 1/0
    $vAlertaPerigo = ($_POST['alertaPerigo'] ?? 'nao') === 'sim' ? 1 : 0;
    $vAlertaAviso  = ($_POST['alertaAviso']  ?? 'nao') === 'sim' ? 1 : 0;
    $vAlertaInfo   = ($_POST['alertaInfo']   ?? 'nao') === 'sim' ? 1 : 0;

    // If user clicked “Retroceder”
    if (isset($_POST['retroceder'])) {
        header("Location: games.php?msg=Cancelled");
        exit;
    }

    // Otherwise call Alterar_Jogo
    try {
        $stmt = $pdo->prepare("
            CALL Labirinto.Alterar_Jogo(
                :jogoid, :descricao, :intervaloMinimoAlertas,
                :pAlertaPerigo, :pAlertaAviso, :pAlertaInfo
            )
        ");
        $stmt->execute([
            ':jogoid'        => (int)$gameID,
            ':descricao'     => $newDescricao,
            ':intervaloMinimoAlertas' => $newIntervaloMinimoAlertas,
            ':pAlertaPerigo' => $vAlertaPerigo,
            ':pAlertaAviso'  => $vAlertaAviso,
            ':pAlertaInfo'   => $vAlertaInfo
        ]);
        $stmt->closeCursor();

        header("Location: games.php?msg=Updated");
        exit;
    } catch (PDOException $ex) {
        die("Error calling Alterar_Jogo: " . $ex->getMessage());
    }
}

// 5) If GET => fetch existing data with ViewJogo & ViewConfiguracaoAlertas
// (A) ViewJogo(:id)
$stmtJ = $pdo->prepare("CALL Labirinto.ViewJogo(:idParam)");
$stmtJ->execute([':idParam' => (int)$gameID]);
$jRow = $stmtJ->fetch(PDO::FETCH_ASSOC);
$stmtJ->closeCursor();

if (!$jRow) {
    die("No such game or not yours.");
}

// store them
$descricaoCurrent = $jRow['Descricao'];
$intervaloMinimoAlertas = $jRow['IntervaloMinimoAlertas'];

// (B) ViewConfiguracaoAlertas(:id)
$stmtA = $pdo->prepare("CALL Labirinto.ViewConfiguracaoAlertas(:idParam)");
$stmtA->execute([':idParam' => (int)$gameID]);
$alertRows = $stmtA->fetchAll(PDO::FETCH_ASSOC);
$stmtA->closeCursor();

// Turn them into a small map e.g. [1=>1,2=>1,3=>1]
$alertSettings = [];
foreach ($alertRows as $ar) {
    $alertSettings[$ar['IDTipoAlerta']] = $ar['Visibilidade'];
}

// default 1 if missing
$vAlertaTipo1 = $alertSettings[1] ?? 1;
$vAlertaTipo2 = $alertSettings[2] ?? 1;
$vAlertaTipo3 = $alertSettings[3] ?? 1;

// 6) define layout vars and include the content
$pageTitle   = "Editar Jogo #$gameID";
$contentFile = "game_edit_content.php";
include('layout.php');