black-sheep-bluff/app/Controllers/Api/AuthController.php
2026-09-18 06:46:56 +02:00

450 lines
18 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
declare(strict_types=1);
/** Auth-API-Controller - 1:1 aus auth.php. */
final class AuthController
{
/** Admin: sich als anderer User anmelden (Impersonation). */
public function impersonate(): void
{
$pdo = Database::pdo();
AuthService::requireAdmin($pdo);
$uid = (int) (input()['user_id'] ?? 0);
$st = $pdo->prepare('SELECT id, role FROM gtl_users WHERE id=?');
$st->execute([$uid]);
$u = $st->fetch();
if (!$u) respond(['error' => 'User nicht gefunden.'], 404);
// ursprünglichen Admin merken (für „Zurück zum Admin")
if (empty($_SESSION['impersonator_id'])) {
$_SESSION['impersonator_id'] = (int) $_SESSION['user_id'];
}
session_regenerate_id(true);
$_SESSION['user_id'] = (int) $u['id'];
$_SESSION['role'] = $u['role'];
respond(['ok' => true]);
}
/** Impersonation beenden: zurück zur ursprünglichen Admin-Sitzung. */
public function stop_impersonating(): void
{
$pdo = Database::pdo();
$adminId = (int) ($_SESSION['impersonator_id'] ?? 0);
if (!$adminId) respond(['error' => 'Keine Admin-Sitzung aktiv.'], 400);
$st = $pdo->prepare('SELECT id, role FROM gtl_users WHERE id=?');
$st->execute([$adminId]);
$u = $st->fetch();
unset($_SESSION['impersonator_id']);
if (!$u || $u['role'] !== 'admin') respond(['error' => 'Admin-Konto nicht mehr gültig.'], 400);
session_regenerate_id(true);
$_SESSION['user_id'] = (int) $u['id'];
$_SESSION['role'] = $u['role'];
respond(['ok' => true]);
}
public function me(): void
{
$pdo = Database::pdo();
if (empty($_SESSION['user_id'])) {
respond(['ok' => true, 'user' => null]);
}
$stmt = $pdo->prepare('SELECT id, username, avatar, role FROM gtl_users WHERE id = ?');
$stmt->execute([$_SESSION['user_id']]);
$user = $stmt->fetch();
respond(['ok' => true, 'user' => $user ? AuthService::publicUser($user) : null,
'impersonating' => !empty($_SESSION['impersonator_id'])]);
}
/** Eigenen Anzeige-/Login-Namen frei ändern (eindeutig, 2–40 Zeichen). */
public function change_username(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$new = trim((string) (input()['username'] ?? ''));
$len = mb_strlen($new);
if ($len < 2 || $len > 40) respond(['error' => 'Name muss 2–40 Zeichen lang sein.'], 400);
if (preg_match('/[\x00-\x1F\x7F]/u', $new)) respond(['error' => 'Ungültige Zeichen im Namen.'], 400);
try {
$pdo->prepare('UPDATE gtl_users SET username=? WHERE id=?')->execute([$new, $me['id']]);
} catch (PDOException $e) {
if ($e->getCode() === '23000') respond(['error' => 'Dieser Name ist bereits vergeben.'], 409);
throw $e;
}
respond(['ok' => true, 'username' => $new]);
}
public function check_username(): void
{
$pdo = Database::pdo();
$username = trim($_GET['username'] ?? '');
$stmt = $pdo->prepare('SELECT id, credential_hash, role FROM gtl_users WHERE username = ?');
$stmt->execute([$username]);
$user = $stmt->fetch();
if (!$user) {
respond(['error' => 'Benutzer nicht gefunden.'], 404);
}
respond([
'ok' => true,
'needs_pin_setup' => ($user['credential_hash'] === null && $user['role'] !== 'admin'),
'is_admin' => ($user['role'] === 'admin'),
]);
}
public function login(): void
{
$pdo = Database::pdo();
$body = input();
$username = trim((string) ($body['username'] ?? ''));
$credential = (string) ($body['credential'] ?? '');
if ($username === '' || $credential === '') {
respond(['error' => 'Username und Credential erforderlich.'], 400);
}
$stmt = $pdo->prepare(
'SELECT id, username, credential_hash, avatar, role FROM gtl_users WHERE username = ?'
);
$stmt->execute([$username]);
$user = $stmt->fetch();
// Generic error to prevent username enumeration
if (!$user || $user['credential_hash'] === null) {
respond(['error' => 'Benutzername oder PIN/Passwort falsch.'], 401);
}
if (!password_verify($credential, $user['credential_hash'])) {
respond(['error' => 'Benutzername oder PIN/Passwort falsch.'], 401);
}
session_regenerate_id(true);
$_SESSION['user_id'] = $user['id'];
$_SESSION['role'] = $user['role'];
$pdo->prepare('UPDATE gtl_users SET last_login = ? WHERE id = ?')
->execute([time(), $user['id']]);
respond(['ok' => true, 'user' => AuthService::publicUser($user)]);
}
public function set_pin(): void
{
$pdo = Database::pdo();
$body = input();
$username = trim((string) ($body['username'] ?? ''));
$pin = (string) ($body['pin'] ?? '');
$confirmPin = (string) ($body['confirmPin'] ?? '');
if (!preg_match('/^\d{4,8}$/', $pin)) {
respond(['error' => 'PIN muss 4–8 Ziffern sein.'], 400);
}
if ($pin !== $confirmPin) {
respond(['error' => 'PINs stimmen nicht überein.'], 400);
}
$stmt = $pdo->prepare(
'SELECT id, credential_hash, role, avatar FROM gtl_users WHERE username = ?'
);
$stmt->execute([$username]);
$user = $stmt->fetch();
if (!$user) {
respond(['error' => 'Benutzer nicht gefunden.'], 404);
}
if ($user['credential_hash'] !== null) {
respond(['error' => 'PIN wurde bereits festgelegt.'], 409);
}
if ($user['role'] === 'admin') {
respond(['error' => 'Admin-Konto nutzt ein Passwort.'], 400);
}
$hash = password_hash($pin, PASSWORD_DEFAULT);
$pdo->prepare('UPDATE gtl_users SET credential_hash = ? WHERE id = ?')
->execute([$hash, $user['id']]);
session_regenerate_id(true);
$_SESSION['user_id'] = $user['id'];
$_SESSION['role'] = $user['role'];
$pdo->prepare('UPDATE gtl_users SET last_login = ? WHERE id = ?')
->execute([time(), $user['id']]);
respond(['ok' => true, 'user' => AuthService::publicUser($user)]);
}
public function change_credential(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$body = input();
$old = (string) ($body['old'] ?? '');
$new = (string) ($body['new'] ?? '');
if ($me['role'] !== 'admin' && !preg_match('/^\d{4,8}$/', $new)) {
respond(['error' => 'Neuer PIN muss 4–8 Ziffern sein.'], 400);
}
if ($me['role'] === 'admin' && strlen($new) < 8) {
respond(['error' => 'Passwort muss mindestens 8 Zeichen haben.'], 400);
}
$stmt = $pdo->prepare('SELECT credential_hash FROM gtl_users WHERE id = ?');
$stmt->execute([$me['id']]);
$row = $stmt->fetch();
if (!$row || !password_verify($old, $row['credential_hash'] ?? '')) {
respond(['error' => 'Aktueller PIN/Passwort falsch.'], 401);
}
$pdo->prepare('UPDATE gtl_users SET credential_hash = ? WHERE id = ?')
->execute([password_hash($new, PASSWORD_DEFAULT), $me['id']]);
respond(['ok' => true]);
}
public function logout(): void
{
$pdo = Database::pdo();
session_destroy();
respond(['ok' => true]);
}
public function create_user(): void
{
$pdo = Database::pdo();
AuthService::requireAdmin($pdo);
$body = input();
$username = trim((string) ($body['username'] ?? ''));
if (!preg_match('/^[a-zA-Z0-9_\-]{2,40}$/', $username)) {
respond(['error' => 'Username: 2–40 Zeichen, nur Buchstaben, Zahlen, _ und -.'], 400);
}
try {
$pdo->prepare(
"INSERT INTO gtl_users (username, role, created_at) VALUES (?, 'user', ?)"
)->execute([$username, time()]);
$uid = (int) $pdo->lastInsertId();
$pdo->prepare('INSERT INTO gtl_user_stats (user_id) VALUES (?)')->execute([$uid]);
respond(['ok' => true, 'user_id' => $uid, 'username' => $username]);
} catch (PDOException $e) {
if ($e->getCode() === '23000') {
respond(['error' => 'Username bereits vergeben.'], 409);
}
throw $e;
}
}
public function reset_pin(): void
{
$pdo = Database::pdo();
AuthService::requireAdmin($pdo);
$body = input();
$uid = (int) ($body['user_id'] ?? 0);
$stmt = $pdo->prepare("SELECT role FROM gtl_users WHERE id = ?");
$stmt->execute([$uid]);
$target = $stmt->fetch();
if (!$target) respond(['error' => 'User nicht gefunden.'], 404);
if ($target['role'] === 'admin') respond(['error' => 'Admin-PIN kann hier nicht zurückgesetzt werden.'], 400);
$pdo->prepare('UPDATE gtl_users SET credential_hash = NULL WHERE id = ?')
->execute([$uid]);
respond(['ok' => true]);
}
public function delete_user(): void
{
$pdo = Database::pdo();
AuthService::requireAdmin($pdo);
$body = input();
$uid = (int) ($body['user_id'] ?? 0);
if ($uid === (int) ($_SESSION['user_id'] ?? 0)) {
respond(['error' => 'Du kannst dich nicht selbst löschen.'], 400);
}
$pdo->prepare('DELETE FROM gtl_users WHERE id = ? AND role != "admin"')
->execute([$uid]);
respond(['ok' => true]);
}
public function get_users(): void
{
$pdo = Database::pdo();
AuthService::requireAdmin($pdo);
$stmt = $pdo->query(
'SELECT u.id, u.username, u.avatar, u.role, u.created_at, u.last_login,
(u.credential_hash IS NULL AND u.role != "admin") AS needs_pin_setup,
s.games_played, s.games_won
FROM gtl_users u
LEFT JOIN gtl_user_stats s ON s.user_id = u.id
ORDER BY u.created_at ASC'
);
respond(['ok' => true, 'users' => $stmt->fetchAll()]);
}
public function save_color(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$body = input();
$color = trim($body['color'] ?? '');
if (!preg_match('/^#[0-9a-fA-F]{6}$/', $color)) {
respond(['error' => 'Ungültige Farbe.'], 400);
}
$pdo->prepare('UPDATE gtl_users SET color=? WHERE id=?')
->execute([$color, $me['id']]);
respond(['ok' => true]);
}
/** Vollständiger Name-Stil: Farbe(n), Stil (solid/gradient/rainbow), Font. */
public function save_name_style(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$b = input();
$color = trim((string) ($b['color'] ?? ''));
if (!preg_match('/^#[0-9a-fA-F]{6}$/', $color)) respond(['error' => 'Ungültige Farbe.'], 400);
$style = (string) ($b['name_style'] ?? 'solid');
if (!in_array($style, ['solid', 'gradient', 'rainbow'], true)) $style = 'solid';
$color2 = trim((string) ($b['color2'] ?? ''));
$color2v = preg_match('/^#[0-9a-fA-F]{6}$/', $color2) ? $color2 : null;
$font = (string) ($b['name_font'] ?? '');
$fonts = ['inter', 'sora', 'pacifico', 'lobster', 'bungee', 'bangers', 'orbitron', 'pressstart'];
$fontv = in_array($font, $fonts, true) ? $font : null;
$pdo->prepare('UPDATE gtl_users SET color=?, color2=?, name_style=?, name_font=? WHERE id=?')
->execute([$color, $color2v, $style, $fontv, $me['id']]);
respond(['ok' => true]);
}
public function get_profile(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$stmt = $pdo->prepare(
'SELECT u.id, u.username, u.avatar, u.role, u.created_at, u.last_login, u.color, u.sticker,
u.color2, u.name_style, u.name_font, u.theme,
s.*
FROM gtl_users u
LEFT JOIN gtl_user_stats s ON s.user_id = u.id
WHERE u.id = ?'
);
$stmt->execute([$me['id']]);
$profile = $stmt->fetch();
respond(['ok' => true, 'profile' => $profile]);
}
public function get_history(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$page = max(1, (int) ($_GET['page'] ?? 1));
$limit = 20;
$offset = ($page - 1) * $limit;
$stmt = $pdo->prepare(
'SELECT r.id AS round_id, r.room_code, r.round_num, r.played_at, r.outcome,
rp.was_imposter, rp.voted_out
FROM gtl_round_players rp
JOIN gtl_game_rounds r ON r.id = rp.round_id
WHERE rp.user_id = ?
ORDER BY r.played_at DESC
LIMIT ? OFFSET ?'
);
$stmt->execute([$me['id'], $limit, $offset]);
$rounds = $stmt->fetchAll();
$countStmt = $pdo->prepare(
'SELECT COUNT(*) FROM gtl_round_players WHERE user_id = ?'
);
$countStmt->execute([$me['id']]);
$total = (int) $countStmt->fetchColumn();
respond(['ok' => true, 'rounds' => $rounds, 'total' => $total, 'page' => $page]);
}
public function upload_avatar(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$body = input();
$b64 = (string) ($body['imageBase64'] ?? '');
if (!preg_match('#^data:image/(jpeg|png|webp);base64,#', $b64, $m)) {
respond(['error' => 'Nur JPEG, PNG oder WebP erlaubt.'], 400);
}
$ext = $m[1] === 'jpeg' ? 'jpg' : $m[1];
$raw = base64_decode(preg_replace('#^data:image/[^;]+;base64,#', '', $b64) ?? '');
if ($raw === false || strlen($raw) > 2 * 1024 * 1024) {
respond(['error' => 'Bild zu groß (max 2 MB).'], 400);
}
// Validate actual image
$tmpFile = tempnam(sys_get_temp_dir(), 'gtl_');
file_put_contents($tmpFile, $raw);
$info = @getimagesize($tmpFile);
unlink($tmpFile);
if (!$info) {
respond(['error' => 'Ungültige Bilddatei.'], 400);
}
$dir = BSB_UPLOADS . '/avatars';
if (!is_dir($dir)) {
mkdir($dir, 0755, true);
}
// Remove old avatar
$stmt = $pdo->prepare('SELECT avatar FROM gtl_users WHERE id = ?');
$stmt->execute([$me['id']]);
$old = $stmt->fetchColumn();
if ($old && file_exists($dir . '/' . $old)) {
unlink($dir . '/' . $old);
}
$filename = $me['id'] . '_' . time() . '.' . $ext;
file_put_contents($dir . '/' . $filename, $raw);
$pdo->prepare('UPDATE gtl_users SET avatar = ? WHERE id = ?')
->execute([$filename, $me['id']]);
respond(['ok' => true, 'avatar' => $filename]);
}
public function upload_sticker(): void
{
$pdo = Database::pdo();
$me = AuthService::requireAuth($pdo);
$body = input();
$b64 = (string) ($body['imageBase64'] ?? '');
if (!preg_match('#^data:image/(png|gif);base64,#', $b64, $m)) {
respond(['error' => 'Nur PNG oder GIF erlaubt.'], 400);
}
$ext = $m[1];
$raw = base64_decode(preg_replace('#^data:image/[^;]+;base64,#', '', $b64) ?? '');
if ($raw === false || strlen($raw) > 500 * 1024) {
respond(['error' => 'Sticker zu groß (max 500 KB).'], 400);
}
$tmpFile = tempnam(sys_get_temp_dir(), 'gtl_');
file_put_contents($tmpFile, $raw);
$info = @getimagesize($tmpFile);
unlink($tmpFile);
if (!$info || !in_array($info[2], [IMAGETYPE_PNG, IMAGETYPE_GIF], true)) {
respond(['error' => 'Ungültige Sticker-Datei.'], 400);
}
$dir = BSB_UPLOADS . '/sticker';
if (!is_dir($dir)) { mkdir($dir, 0755, true); }
// alten Sticker entfernen
$stmt = $pdo->prepare('SELECT sticker FROM gtl_users WHERE id = ?');
$stmt->execute([$me['id']]);
$old = $stmt->fetchColumn();
if ($old && file_exists($dir . '/' . $old)) { unlink($dir . '/' . $old); }
$filename = $me['id'] . '_' . time() . '.' . $ext;
file_put_contents($dir . '/' . $filename, $raw);
$pdo->prepare('UPDATE gtl_users SET sticker = ? WHERE id = ?')
->execute([$filename, $me['id']]);
respond(['ok' => true, 'sticker' => $filename]);
}
}