is_string($k) && $k !== '' )); if ($normalQ === '') respond(['error' => 'Normale Frage darf nicht leer sein.'], 400); if ($imposterQ === '') respond(['error' => 'Imposter-Frage darf nicht leer sein.'], 400); if (!empty($imposterKeys)) { $in = implode(',', array_fill(0, count($imposterKeys), '?')); $chk = $pdo->prepare("SELECT pkey FROM gtl_players WHERE room_code=? AND pkey IN ($in)"); $chk->execute(array_merge([$code], $imposterKeys)); $valid = array_column($chk->fetchAll(), 'pkey'); $imposterKeys = array_values(array_intersect($imposterKeys, $valid)); } $pdo->prepare( 'UPDATE gtl_rooms SET normal_question=?, imposter_question=?, liar_keys=?, voted_out_keys=NULL, round_outcome=NULL, voting_open=0, reveal_index=-1, revealed_keys=NULL, questions_revealed=0, updated_at=? WHERE code=?' )->execute([$normalQ, $imposterQ, json_encode($imposterKeys), $now, $code]); $ps = $pdo->prepare('SELECT pkey FROM gtl_players WHERE room_code=?'); $ps->execute([$code]); $upd = $pdo->prepare( 'UPDATE gtl_players SET question=?, vote_for=NULL, vote_locked=0, vote_request=0, late_join=0, updated_at=? WHERE room_code=? AND pkey=?' ); foreach (array_column($ps->fetchAll(), 'pkey') as $pk) { $q = in_array($pk, $imposterKeys, true) ? $imposterQ : $normalQ; $upd->execute([$q, $now, $code, $pk]); } respond(['ok' => true, 'state' => RoomService::loadRoom($pdo, $code)]); } public function submit_answer(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $pkey = (string) ($body['pkey'] ?? ''); $answer = substr(trim((string) ($body['answer'] ?? '')), 0, 2000); if ($answer === '') respond(['error' => 'Antwort darf nicht leer sein.'], 400); $pdo->prepare( 'UPDATE gtl_players SET answer=?, answered=1, updated_at=? WHERE room_code=? AND pkey=?' )->execute([$answer, $now, $code, $pkey]); $pdo->prepare('UPDATE gtl_rooms SET updated_at=? WHERE code=?')->execute([$now, $code]); respond(['ok' => true]); } public function delete_answer(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $pkey = (string) ($body['pkey'] ?? ''); if ($code === '' || $pkey === '') respond(['error' => 'Fehlende Parameter.'], 400); $pdo->prepare( 'UPDATE gtl_players SET answer=NULL, answered=0, vote_for=NULL, updated_at=? WHERE room_code=? AND pkey=?' )->execute([$now, $code, $pkey]); respond(['ok' => true, 'state' => RoomService::loadRoom($pdo, $code)]); } public function reveal(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; // Alle gleichzeitig aufdecken $body = input(); $code = slugCode((string) ($body['code'] ?? '')); // Collect all player pkeys for this room $pkStmt = $pdo->prepare('SELECT pkey FROM gtl_players WHERE room_code=?'); $pkStmt->execute([$code]); $allKeys = array_column($pkStmt->fetchAll(), 'pkey'); $pdo->prepare('UPDATE gtl_rooms SET revealed=1, reveal_index=9999, revealed_keys=?, updated_at=? WHERE code=?') ->execute([json_encode($allKeys), $now, $code]); respond(['ok' => true, 'state' => RoomService::loadRoom($pdo, $code)]); } public function reveal_answer(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; // Gezielt eine Antwort aufdecken (Host klickt Spielerkarte) $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $rpkey = (string) ($body['pkey'] ?? ''); if ($rpkey === '') respond(['error' => 'pkey fehlt.'], 400); $rkStmt = $pdo->prepare('SELECT revealed_keys FROM gtl_rooms WHERE code=?'); $rkStmt->execute([$code]); $rkRow = $rkStmt->fetch(); if (!$rkRow) respond(['error' => 'Raum nicht gefunden.'], 404); $j2 = fn($v) => (!empty($v) && is_string($v)) ? (json_decode($v, true) ?: []) : []; $rkeys = $j2($rkRow['revealed_keys'] ?? ''); if (!in_array($rpkey, $rkeys, true)) { $rkeys[] = $rpkey; } $pdo->prepare('UPDATE gtl_rooms SET revealed=1, reveal_index=?, revealed_keys=?, updated_at=? WHERE code=?') ->execute([count($rkeys), json_encode($rkeys), $now, $code]); respond(['ok' => true, 'state' => RoomService::loadRoom($pdo, $code)]); } public function reveal_questions(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; // Leiter deckt die echte Frage für die Imposter auf (Knopfdruck) $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $pdo->prepare('UPDATE gtl_rooms SET questions_revealed=1, updated_at=? WHERE code=?') ->execute([$now, $code]); respond(['ok' => true, 'state' => RoomService::loadRoom($pdo, $code)]); } public function reveal_next(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; // Legacy: Nächste Antwort sequenziell aufdecken (fallback) $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $riRow = $pdo->prepare('SELECT reveal_index FROM gtl_rooms WHERE code=?'); $riRow->execute([$code]); $riData = $riRow->fetch(); if (!$riData) respond(['error' => 'Raum nicht gefunden.'], 404); $newIdx = (int) $riData['reveal_index'] + 1; $pdo->prepare('UPDATE gtl_rooms SET revealed=1, reveal_index=?, updated_at=? WHERE code=?') ->execute([$newIdx, $now, $code]); respond(['ok' => true, 'state' => RoomService::loadRoom($pdo, $code)]); } public function update_weights(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $weights = (string) ($body['weights'] ?? ''); $decoded = json_decode($weights, true); if (!is_array($decoded)) respond(['error' => 'Ungültiges JSON für Imposter-Gewichte.'], 400); $pdo->prepare('UPDATE gtl_rooms SET imposter_weights=?, updated_at=? WHERE code=?') ->execute([$weights, $now, $code]); respond(['ok' => true]); } public function get_host_history(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; $code = slugCode((string) ($_GET['code'] ?? '')); if ($code === '') respond(['error' => 'Code fehlt.'], 400); $stmt = $pdo->prepare( 'SELECT r.id AS round_id, r.round_num, r.played_at, r.outcome, rp.player_name, rp.pkey, rp.was_imposter, rp.voted_out, rp.question, rp.answer, u.avatar FROM gtl_game_rounds r JOIN gtl_round_players rp ON rp.round_id = r.id LEFT JOIN gtl_users u ON u.id = rp.user_id WHERE r.room_code = ? ORDER BY r.round_num DESC, rp.id ASC' ); $stmt->execute([$code]); $rows = $stmt->fetchAll(); $grouped = []; foreach ($rows as $row) { $rn = (int) $row['round_num']; if (!isset($grouped[$rn])) { $grouped[$rn] = [ 'round_num' => $rn, 'played_at' => (int) $row['played_at'], 'outcome' => $row['outcome'], 'players' => [], ]; } $grouped[$rn]['players'][] = [ 'name' => $row['player_name'], 'pkey' => $row['pkey'], 'avatar' => $row['avatar'] ?? null, 'was_imposter'=> (bool) $row['was_imposter'], 'voted_out' => (bool) $row['voted_out'], 'question' => $row['question'] ?? '', 'answer' => $row['answer'] ?? '', ]; } respond(['ok' => true, 'history' => array_values($grouped)]); } public function score(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $pkey = (string) ($body['pkey'] ?? ''); $delta = (int) ($body['delta'] ?? 0); $pdo->prepare('UPDATE gtl_players SET score=score+?, updated_at=? WHERE room_code=? AND pkey=?') ->execute([$delta, $now, $code, $pkey]); respond(['ok' => true]); } public function new_round(): void { $pdo = Database::pdo(); $now = time(); $authUserId = $_SESSION['user_id'] ?? null; $body = input(); $code = slugCode((string) ($body['code'] ?? '')); $state = RoomService::loadRoom($pdo, $code); // Aktuelle Runde zuerst archivieren (falls noch nicht geschehen) if ($state && !empty($state['players'])) { RoomService::archiveRound($pdo, $state, $now); } $pdo->prepare( 'UPDATE gtl_rooms SET revealed=0, liar_keys=NULL, voted_out_keys=NULL, round_outcome=NULL, normal_question=NULL, imposter_question=NULL, voting_open=0, reveal_index=-1, revealed_keys=NULL, questions_revealed=0, active_emojis=NULL, round_num=round_num+1, updated_at=? WHERE code=?' )->execute([$now, $code]); $pdo->prepare( 'UPDATE gtl_players SET question=NULL, answer=NULL, answered=0, vote_for=NULL, vote_locked=0, vote_request=0, late_join=0, updated_at=? WHERE room_code=?' )->execute([$now, $code]); respond(['ok' => true, 'state' => RoomService::loadRoom($pdo, $code)]); } }