<?php
// next_player.php
header("Content-Type: application/json");
require_once "../connection.php"; // เชื่อมต่อ database

/* ===================== STEP 1: หา player ถัดไป ===================== */
// ดึงคนที่ status = 'ready' หรือ 'waiting' คนแรก (id น้อยที่สุด)
$player = $conn->query("
    SELECT id, code, name 
    FROM players 
    WHERE status IN ('ready','waiting')
    ORDER BY id ASC 
    LIMIT 1
")->fetch_assoc();

/* ===================== STEP 2: ถ้ามี player ===================== */
if ($player) {
    // ตั้ง status เป็น running
    $stmt = $conn->prepare("
        UPDATE players 
        SET status='running', start_time=NOW() 
        WHERE id=?
    ");
    $stmt->bind_param("i", $player['id']);
    $stmt->execute();

    // ส่งข้อมูลกลับ ESP32
    echo json_encode([
        "success" => true,
        "player" => [
            "id"   => $player['id'],
            "code" => $player['code'],
            "name" => $player['name']
        ]
    ]);
    exit;
}

/* ===================== STEP 3: ถ้าไม่มี player ===================== */
echo json_encode([
    "success" => false,
    "message" => "No player ready"
]);
exit;
?>