erdo
/
exit-game


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
							<?php
include 'db_config.php'; 

$sql = "SELECT DISTINCT sp.* FROM spiele sp
        JOIN scores sc ON sp.id = sc.spiel_id
        ORDER BY sp.titel ASC";
$stmt = $pdo->query($sql);
$playedGames = $stmt->fetchAll();
?>
<!DOCTYPE html>
<html lang="de">
<head>
    <meta charset="UTF-8">
    <title>Gespielte Spiele</title>
    <style>
        /* THEME VARIABLEN */
        :root { 
            --bg: #f4f7f6; --card: #ffffff; --text: #333; --border: #ddd; --accent: #e67e22;
        }
        .dark-theme { 
            --bg: #121212cf; --card: #1e1e1e; --text: #ffffff; --border: #333; 
        }

        body { font-family: 'Segoe UI', sans-serif; background: var(--bg); color: var(--text); padding: 20px; transition: 0.3s; }
        
        header { display: flex; justify-content: space-between; align-items: center; margin-bottom: 20px; }
        
        .grid { display: grid; grid-template-columns: repeat(auto-fill, minmax(200px, 1fr)); gap: 20px; }
        .item { background: var(--card); padding: 10px; border-radius: 8px; text-align: center; border: 1px solid var(--border); box-shadow: 0 4px 10px rgba(0,0,0,0.1); }
        .item img { width: 100%; border-radius: 4px; height: 150px; object-fit: cover; background: #2a2a2a; }
        
        h1 { color: var(--accent); margin: 0; }
        .back { 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>

    <header>
        <a href="index.php" class="back">← Dashboard</a>
        <div style="display: flex; align-items: center; gap: 15px;">
            <button onclick="toggleTheme()" class="theme-toggle" id="theme-icon">🌙</button>
        </div>
    </header>

    <h1>📂 Gelöste Abenteuer</h1>
    <p style="margin-bottom: 30px; opacity: 0.8;">Diese Spiele wurden bereits erfolgreich beendet.</p>

    <div class="grid">
        <?php foreach ($playedGames as $game): ?>
            <div class="item">
                <img src="<?= htmlspecialchars($game['bild_url']) ?>" onerror="this.src='https://via.placeholder.com/200x150?text=Kein+Bild'">
                <p style="font-weight: bold; margin-top: 10px;"><?= htmlspecialchars($game['titel']) ?></p>
            </div>
        <?php endforeach; ?>
    </div>

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

    // Icon beim Laden anpassen
    if (localStorage.getItem('theme') === 'dark') {
        document.getElementById('theme-icon').innerText = '☀️';
    }
</script>
</body>
</html>