erdo
/
exit-game


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256
							<?php
session_start();
require_once 'config.php'; 
require_once 'db_config.php'; 

// --- 1. LOGIN / LOGOUT SCHUTZ ---
if (isset($_GET['logout'])) { session_destroy(); header("Location: admin.php"); exit; }
if (isset($_POST['login_auth'])) {
    if ($_POST['pw'] === ADMIN_PASSWORD) { $_SESSION['admin_auth'] = true; }
}
$is_admin = (isset($_SESSION['admin_auth']) && $_SESSION['admin_auth'] === true);

if (!$is_admin):
?>
<!DOCTYPE html>
<html lang="de">
<head>
    <meta charset="UTF-8">
    <title>Admin Login</title>
    <style>
        body { font-family: sans-serif; display: flex; justify-content: center; align-items: center; height: 100vh; background: #f4f7f6; margin: 0; }
        .login-box { background: white; padding: 30px; border-radius: 8px; box-shadow: 0 2px 10px rgba(0,0,0,0.1); text-align: center; }
        input { width: 100%; padding: 10px; margin: 10px 0; box-sizing: border-box; border: 1px solid #ddd; border-radius: 4px; }
        button { width: 100%; padding: 10px; background: #e67e22; color: white; border: none; cursor: pointer; border-radius: 4px; font-weight: bold; }
    </style>
</head>
<body>
    <div class="login-box">
        <h2>🔒 Admin Login</h2>
        <form method="POST"><input type="password" name="pw" placeholder="Passwort" autofocus required><button type="submit" name="login_auth">Einloggen</button></form>
    </div>
</body>
</html>
<?php exit; endif; ?>

<?php
// --- 2. VERARBEITUNG DER FORMULARE ---
$msg = "";

// SPIELE (Add/Update/Delete)
if (isset($_POST['add_game'])) {
    $stmt = $pdo->prepare("INSERT INTO spiele (game_reihe_id, titel, game_typ_id, game_level_id, ean, bild_url) VALUES (?,?,?,?,?,?)");
    $stmt->execute([(int)$_POST['r_id'], $_POST['titel'], (int)$_POST['t_id'], (int)$_POST['l_id'], $_POST['ean'], $_POST['url']]);
    $msg = "✅ Spiel hinzugefügt!";
}
if (isset($_POST['upd_game'])) {
    $stmt = $pdo->prepare("UPDATE spiele SET game_reihe_id=?, titel=?, game_typ_id=?, game_level_id=?, ean=?, bild_url=? WHERE id=?");
    $stmt->execute([(int)$_POST['r_id'], $_POST['titel'], (int)$_POST['t_id'], (int)$_POST['l_id'], $_POST['ean'], $_POST['url'], (int)$_POST['id']]);
    $msg = "💾 Änderungen gespeichert!";
}

// SPIELER
if (isset($_POST['add_spieler'])) {
    $pdo->prepare("INSERT INTO spieler (name) VALUES (?)")->execute([$_POST['name']]);
}

// REIHEN / TYPEN / LEVEL
if (isset($_POST['add_reihe'])) { $pdo->prepare("INSERT INTO game_reihe (name) VALUES (?)")->execute([$_POST['name']]); }
if (isset($_POST['add_typ']))   { $pdo->prepare("INSERT INTO game_typ (game_reihe_id, bezeichnung) VALUES (?,?)")->execute([$_POST['r_id'], $_POST['bez']]); }
if (isset($_POST['add_level'])) { $pdo->prepare("INSERT INTO game_level (game_reihe_id, bezeichnung) VALUES (?,?)")->execute([$_POST['r_id'], $_POST['bez']]); }

// LÖSCHEN (Universal)
if (isset($_GET['del_table']) && isset($_GET['del_id'])) {
    $allowed = ['spiele', 'spieler', 'game_reihe', 'game_typ', 'game_level'];
    if (in_array($_GET['del_table'], $allowed)) {
        $stmt = $pdo->prepare("DELETE FROM `".$_GET['del_table']."` WHERE id = ?");
        $stmt->execute([(int)$_GET['del_id']]);
        header("Location: admin.php"); exit;
    }
}

// --- 3. DATEN LADEN ---
$reihen  = $pdo->query("SELECT * FROM game_reihe ORDER BY name")->fetchAll();
$typen   = $pdo->query("SELECT * FROM game_typ ORDER BY bezeichnung")->fetchAll();
$levels  = $pdo->query("SELECT * FROM game_level ORDER BY bezeichnung")->fetchAll();
$spieler = $pdo->query("SELECT * FROM spieler ORDER BY name")->fetchAll();
$spiele  = $pdo->query("SELECT s.*, r.name as r_name FROM spiele s LEFT JOIN game_reihe r ON s.game_reihe_id = r.id ORDER BY s.id DESC")->fetchAll();
?>

<!DOCTYPE html>
<html lang="de">
<head>
    <meta charset="UTF-8">
    <title>Admin Dashboard</title>
    <style>
        :root { --accent: #e67e22; --bg: #f4f7f6; --card: #fff; --text: #333; --border: #ddd; }
        .dark-theme { --bg: #1a1a1a; --card: #2d2d2d; --text: #eee; --border: #444; }
        body { font-family: 'Segoe UI', sans-serif; background: var(--bg); color: var(--text); margin: 0; padding: 20px; transition: 0.3s; }
        .container { max-width: 1400px; margin: 0 auto; }
        
        /* Header & Buttons */
        .header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 20px; }
        .header-btns { display: flex; gap: 10px; align-items: center; }
        .btn { padding: 8px 15px; border: none; border-radius: 6px; cursor: pointer; color: white; text-decoration: none; font-weight: bold; font-size: 0.9em; transition: 0.2s; }
        .btn-s { background: #2980b9; } .btn-s:hover { background: #3498db; }
        .btn-d { background: #c0392b; } .btn-d:hover { background: #e74c3c; }
        .btn-a { background: #27ae60; } .btn-a:hover { background: #2ecc71; }
        .btn-nav { background: var(--accent); }
        #theme-icon { background: none; border: none; font-size: 1.4rem; cursor: pointer; padding: 5px; }

        /* Tabs */
        .nav-tabs { display: flex; gap: 5px; margin-bottom: 20px; border-bottom: 2px solid var(--border); padding-bottom: 10px; }
        .t-btn { padding: 10px 20px; border: none; background: transparent; color: var(--text); cursor: pointer; font-weight: bold; border-radius: 6px; }
        .t-btn.active { background: var(--accent); color: white; }
        .tab { display: none; background: var(--card); padding: 25px; border-radius: 12px; box-shadow: 0 4px 15px rgba(0,0,0,0.05); border: 1px solid var(--border); }
        .tab.active { display: block; }

        /* Table & Forms */
        table { width: 100%; border-collapse: collapse; margin-top: 15px; }
        th { text-align: left; padding: 12px; border-bottom: 2px solid var(--border); background: rgba(0,0,0,0.02); }
        td { padding: 10px; border-bottom: 1px solid var(--border); }
        input, select { padding: 9px; border: 1px solid var(--border); border-radius: 6px; background: var(--card); color: var(--text); width: 100%; box-sizing: border-box; }
        .alert { padding: 15px; background: #d4edda; color: #155724; border-radius: 8px; margin-bottom: 20px; text-align: center; font-weight: bold; }
    </style>
</head>
<body>

<div class="container">
    <div class="header">
        <h1>🛠 Admin Dashboard</h1>
        <div class="header-btns">
            <button onclick="toggleTheme()" id="theme-icon">🌙</button>
            <a href="index.php" class="btn btn-nav">Katalog</a>
            <a href="admin.php?logout=1" class="btn btn-d">Logout</a>
        </div>
    </div>

    <?php if($msg): ?><div class="alert" id="msgbox"><?=$msg?></div><?php endif; ?>

    <div class="nav-tabs">
        <button class="t-btn active" onclick="openTab(event, 't-spiele')">🎮 Spiele</button>
        <button class="t-btn" onclick="openTab(event, 't-spieler')">👥 Spieler</button>
        <button class="t-btn" onclick="openTab(event, 't-config')">⚙️ Stammdaten</button>
    </div>

    <div id="t-spiele" class="tab active">
        <h3>Neues Spiel hinzufügen</h3>
        <form method="POST" style="display:grid; grid-template-columns: 1fr 2fr 1fr 1fr 1fr 2fr auto; gap:10px; align-items: end;">
            <div><label>Reihe</label><select name="r_id" id="r_new" onchange="filter('new')" required><option value="">Wählen...</option><?php foreach($reihen as $r): ?><option value="<?=$r['id']?>"><?=$r['name']?></option><?php endforeach; ?></select></div>
            <div><label>Titel</label><input type="text" name="titel" required></div>
            <div><label>Typ</label><select name="t_id" id="t_new"><option value="0" data-p="0">--</option><?php foreach($typen as $t): ?><option data-p="<?=$t['game_reihe_id']?>" value="<?=$t['id']?>"><?=$t['bezeichnung']?></option><?php endforeach; ?></select></div>
            <div><label>Level</label><select name="l_id" id="l_new"><option value="0" data-p="0">--</option><?php foreach($levels as $l): ?><option data-p="<?=$l['game_reihe_id']?>" value="<?=$l['id']?>"><?=$l['bezeichnung']?></option><?php endforeach; ?></select></div>
            <div><label>EAN</label><input type="text" name="ean"></div>
            <div><label>Bild URL</label><input type="text" name="url"></div>
            <button type="submit" name="add_game" class="btn btn-a">Hinzufügen</button>
        </form>

        <hr style="margin: 30px 0; border: 0; border-top: 1px solid var(--border);">

        <table>
            <thead><tr><th>Reihe</th><th>Titel</th><th>Typ</th><th>Level</th><th style="width:100px;">Aktion</th></tr></thead>
            <?php foreach($spiele as $s): ?>
            <form method="POST">
                <input type="hidden" name="id" value="<?=$s['id']?>">
                <tr>
                    <td><select name="r_id" id="r_<?=$s['id']?>" onchange="filter(<?=$s['id']?>)"><?php foreach($reihen as $r): ?><option value="<?=$r['id']?>" <?=$s['game_reihe_id']==$r['id']?'selected':''?>><?=$r['name']?></option><?php endforeach; ?></select></td>
                    <td><input type="text" name="titel" value="<?=htmlspecialchars($s['titel'])?>"></td>
                    <td><select name="t_id" id="t_<?=$s['id']?>"><option value="0" data-p="0">--</option><?php foreach($typen as $t): ?><option data-p="<?=$t['game_reihe_id']?>" value="<?=$t['id']?>" <?=$s['game_typ_id']==$t['id']?'selected':''?>><?=$t['bezeichnung']?></option><?php endforeach; ?></select></td>
                    <td><select name="l_id" id="l_<?=$s['id']?>"><option value="0" data-p="0">--</option><?php foreach($levels as $l): ?><option data-p="<?=$l['game_reihe_id']?>" value="<?=$l['id']?>" <?=$s['game_level_id']==$l['id']?'selected':''?>><?=$l['bezeichnung']?></option><?php endforeach; ?></select></td>
                    <td>
                        <div style="display:flex; gap:5px;">
                            <button type="submit" name="upd_game" class="btn btn-s">💾</button>
                            <a href="?del_table=spiele&del_id=<?=$s['id']?>" class="btn btn-d" onclick="return confirm('Löschen?')">🗑</a>
                        </div>
                    </td>
                </tr>
            </form>
            <?php endforeach; ?>
        </table>
    </div>

    <div id="t-spieler" class="tab">
        <h3>Spieler Profile</h3>
        <form method="POST" style="display:flex; gap:10px; margin-bottom:20px;"><input type="text" name="name" placeholder="Name" required style="max-width:300px;"> <button type="submit" name="add_spieler" class="btn btn-a">Spieler anlegen</button></form>
        <table>
            <?php foreach($spieler as $sl): ?>
            <tr><td><?=$sl['name']?></td><td style="text-align:right;"><a href="?del_table=spieler&del_id=<?=$sl['id']?>" class="btn btn-d">Löschen</a></td></tr>
            <?php endforeach; ?>
        </table>
    </div>

    <div id="t-config" class="tab">
        <div style="display:grid; grid-template-columns: 1fr 1fr 1fr; gap:30px;">
            <div>
                <h4>Reihen</h4>
                <form method="POST" style="display:flex; gap:5px; margin-bottom:15px;"><input type="text" name="name" placeholder="Neu..."><button type="submit" name="add_reihe" class="btn btn-a">+</button></form>
                <div style="max-height:400px; overflow-y:auto;">
                    <?php foreach($reihen as $r): ?> <div style="display:flex; justify-content:space-between; padding:5px; border-bottom:1px solid var(--border);"><span><?=$r['name']?></span> <a href="?del_table=game_reihe&del_id=<?=$r['id']?>" style="color:red; text-decoration:none;">✕</a></div> <?php endforeach; ?>
                </div>
            </div>
            <div>
                <h4>Typen (pro Reihe)</h4>
                <form method="POST">
                    <select name="r_id" style="margin-bottom:5px;"><?php foreach($reihen as $r): ?><option value="<?=$r['id']?>"><?=$r['name']?></option><?php endforeach; ?></select>
                    <div style="display:flex; gap:5px;"><input type="text" name="bez" placeholder="Neu..."><button type="submit" name="add_typ" class="btn btn-a">+</button></div>
                </form>
                <div style="margin-top:15px; font-size:0.85em;">
                    <?php foreach($typen as $t): ?> <div style="padding:3px; border-bottom:1px solid #eee;"><?=$t['bezeichnung']?> <small>(ID: <?=$t['game_reihe_id']?>)</small> <a href="?del_table=game_typ&del_id=<?=$t['id']?>" style="color:red; float:right;">✕</a></div> <?php endforeach; ?>
                </div>
            </div>
            <div>
                <h4>Level (pro Reihe)</h4>
                <form method="POST">
                    <select name="r_id" style="margin-bottom:5px;"><?php foreach($reihen as $r): ?><option value="<?=$r['id']?>"><?=$r['name']?></option><?php endforeach; ?></select>
                    <div style="display:flex; gap:5px;"><input type="text" name="bez" placeholder="Neu..."><button type="submit" name="add_level" class="btn btn-a">+</button></div>
                </form>
                <div style="margin-top:15px; font-size:0.85em;">
                    <?php foreach($levels as $l): ?> <div style="padding:3px; border-bottom:1px solid #eee;"><?=$l['bezeichnung']?> <small>(ID: <?=$l['game_reihe_id']?>)</small> <a href="?del_table=game_level&del_id=<?=$l['id']?>" style="color:red; float:right;">✕</a></div> <?php endforeach; ?>
                </div>
            </div>
        </div>
    </div>
</div>

<script>
    function openTab(evt, tabName) {
        document.querySelectorAll(".tab").forEach(t => t.classList.remove("active"));
        document.querySelectorAll(".t-btn").forEach(b => b.classList.remove("active"));
        document.getElementById(tabName).classList.add("active");
        evt.currentTarget.classList.add("active");
    }

    function toggleTheme() {
        const isDark = document.documentElement.classList.toggle('dark-theme');
        localStorage.setItem('theme', isDark ? 'dark' : 'light');
        document.getElementById('theme-icon').innerText = isDark ? '☀️' : '🌙';
    }

    function filter(id) {
        let reiheSelect = document.getElementById('r_'+id);
        if(!reiheSelect) return;
        let val = reiheSelect.value;
        
        ['t_'+id, 'l_'+id].forEach(sid => {
            let s = document.getElementById(sid);
            if(!s) return;
            s.querySelectorAll('option').forEach(o => {
                let p = o.getAttribute('data-p');
                o.style.display = (p == "0" || p == val) ? "block" : "none";
            });
            if(s.options[s.selectedIndex].style.display == "none") s.value = "0";
        });
    }

    document.addEventListener('DOMContentLoaded', () => {
        if (localStorage.getItem('theme') === 'dark') {
            document.documentElement.classList.add('dark-theme');
            document.getElementById('theme-icon').innerText = '☀️';
        }
        filter('new');
        <?php foreach($spiele as $s): ?> filter(<?=$s['id']?>); <?php endforeach; ?>
        setTimeout(() => { if(document.getElementById('msgbox')) document.getElementById('msgbox').style.display='none'; }, 3000);
    });
</script>
</body>
</html>