erdo
/
exit-game


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137
							<?php
require_once 'db_config.php';
$msg = "";

// Status-Update Logik
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['update_status'])) {
    $stmt = $pdo->prepare("INSERT INTO besitzstatus (spieler_id, spiel_id, status) 
                           VALUES (?, ?, ?) 
                           ON DUPLICATE KEY UPDATE status = VALUES(status)");
    $stmt->execute([(int)$_POST['spieler_id'], (int)$_POST['spiel_id'], $_POST['status']]);
    $msg = "Status aktualisiert!";
}

$spieler = $pdo->query("SELECT * FROM spieler ORDER BY name ASC")->fetchAll();
$spiele = $pdo->query("SELECT s.*, t.bezeichnung as typ_name FROM spiele s LEFT JOIN game_typen t ON s.typ_id = t.id ORDER BY s.titel ASC")->fetchAll();
?>
<!DOCTYPE html>
<html lang="de">
<head>
    <meta charset="UTF-8">
    <title>EXIT - Bestandsverwaltung</title>
    <style>
        /* THEME VARIABLEN */
        :root { 
            --bg: #f4f7f6; --card: #ffffff; --text: #333; --border: #ddd; --accent: #e67e22;
            --table-head: #f8f9fa;
        }
        .dark-theme { 
            --bg: #121212; --card: #1e1e1e; --text: #e0e0e0; --border: #333;
            --table-head: #2a2a2a;
        }

        body { font-family: 'Segoe UI', sans-serif; background: var(--bg); color: var(--text); padding: 20px; transition: 0.3s; }
        .container { max-width: 1200px; margin: auto; }
        
        header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 20px; }
        h1 { color: var(--accent); margin: 0; }
        
        .alert { background: #27ae60; color: white; padding: 10px; border-radius: 5px; margin-bottom: 20px; text-align: center; transition: opacity 0.5s; }
        
        table { width: 100%; border-collapse: collapse; background: var(--card); border-radius: 8px; overflow: hidden; border: 1px solid var(--border); }
        th, td { padding: 12px; border-bottom: 1px solid var(--border); text-align: left; }
        th { background: var(--table-head); color: var(--accent); text-transform: uppercase; font-size: 0.85em; }
        
        .game-info { display: flex; align-items: center; gap: 15px; }
        .game-info img { width: 40px; height: 40px; object-fit: cover; border-radius: 4px; border: 1px solid var(--border); }
        
        select { background: var(--card); color: var(--text); border: 1px solid var(--border); padding: 8px; border-radius: 4px; width: 100%; cursor: pointer; transition: 0.3s; }
        select.besitzt { border-left: 4px solid #27ae60; }
        select.verkauft { border-left: 4px solid #f39c12; }
        select.nicht { border-left: 4px solid #7f8c8d; }
        
        .back-link { color: var(--accent); text-decoration: none; font-weight: bold; border: 1px solid var(--accent); padding: 5px 15px; border-radius: 6px; }
        .theme-toggle { background: var(--card); border: 1px solid var(--border); color: var(--text); padding: 8px 12px; border-radius: 20px; cursor: pointer; font-size: 1.1rem; }
    </style>
    <script>
        if (localStorage.getItem('theme') === 'dark') document.documentElement.classList.add('dark-theme');
    </script>
</head>
<body>
<div class="container">
    <header>
        <a href="index.php" class="back-link">← Dashboard</a>
        <div style="display: flex; align-items: center; gap: 15px;">
            <button onclick="toggleTheme()" class="theme-toggle" id="theme-icon">🌙</button>
        </div>
    </header>

    <h1>📦 Bestandsverwaltung</h1>
    <p style="margin-bottom: 20px; opacity: 0.7;">Wer besitzt welches Spiel?</p>
    
    <?php if ($msg): ?><div class="alert" id="msg-box"><?= $msg ?></div><?php endif; ?>

    <table>
        <thead>
            <tr>
                <th>Spiel</th>
                <?php foreach ($spieler as $s): ?>
                    <th><?= htmlspecialchars($s['name']) ?></th>
                <?php endforeach; ?>
            </tr>
        </thead>
        <tbody>
            <?php foreach ($spiele as $sp): ?>
            <tr>
                <td>
                    <div class="game-info">
                        <img src="<?= htmlspecialchars($sp['bild_url'] ?: 'https://via.placeholder.com/40') ?>">
                        <div>
                            <strong><?= htmlspecialchars($sp['titel']) ?></strong><br>
                            <small style="opacity: 0.6;"><?= htmlspecialchars($sp['typ_name']) ?></small>
                        </div>
                    </div>
                </td>
                <?php foreach ($spieler as $s): 
                    $st_stmt = $pdo->prepare("SELECT status FROM besitzstatus WHERE spieler_id = ? AND spiel_id = ?");
                    $st_stmt->execute([$s['id'], $sp['id']]);
                    $current = $st_stmt->fetchColumn() ?: 'nicht besitzt';
                    $class = ($current == 'besitzt') ? 'besitzt' : (($current == 'verkauft') ? 'verkauft' : 'nicht');
                ?>
                    <td>
                        <form method="POST" style="margin:0;">
                            <input type="hidden" name="update_status" value="1">
                            <input type="hidden" name="spieler_id" value="<?= $s['id'] ?>">
                            <input type="hidden" name="spiel_id" value="<?= $sp['id'] ?>">
                            <select name="status" class="<?= $class ?>" onchange="this.form.submit()">
                                <option value="besitzt" <?= $current == 'besitzt' ? 'selected' : '' ?>>Besitzt</option>
                                <option value="nicht besitzt" <?= $current == 'nicht besitzt' ? 'selected' : '' ?>>Nicht</option>
                                <option value="verkauft" <?= $current == 'verkauft' ? 'selected' : '' ?>>Verkauft</option>
                            </select>
                        </form>
                    </td>
                <?php endforeach; ?>
            </tr>
            <?php endforeach; ?>
        </tbody>
    </table>
</div>

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

    if (localStorage.getItem('theme') === 'dark') {
        document.getElementById('theme-icon').innerText = '☀️';
    }

    setTimeout(function() { 
        var msg = document.getElementById('msg-box'); 
        if(msg) msg.style.opacity = '0'; 
    }, 2000);
</script>
</body>
</html>