library.php

<?php
require_once 'config/database.php';
require_once 'config/user_auth.php';

// Check if user is logged in
requireLogin();

// Get the requested game if specified
$game_id = isset($_GET['game']) ? (int)$_GET['game'] : 0;
$console = isset($_GET['console']) ? htmlspecialchars($_GET['console']) : '';

$pageTitle = "Game Library";
$username = getUserUsername();

// Get all available consoles
try {
    $stmt = $pdo->query("SELECT * FROM consoles ORDER BY name");
    $consoles = $stmt->fetchAll();
} catch (PDOException $e) {
    $error = "Database error: " . $e->getMessage();
    $consoles = [];
}

// Get games based on filter
try {
    $whereClause = "";
    $params = [];
    
    if ($console) {
        $whereClause = "WHERE c.slug = ?";
        $params[] = $console;
    }
    
    $query = "
        SELECT g.*, c.name as console_name, c.slug as console_slug
        FROM games g
        JOIN consoles c ON g.console_id = c.id
        $whereClause
        ORDER BY g.release_date DESC
    ";
    
    $stmt = $pdo->prepare($query);
    $stmt->execute($params);
    $games = $stmt->fetchAll();
} catch (PDOException $e) {
    $error = "Database error: " . $e->getMessage();
    $games = [];
}

// Get featured games
try {
    $stmt = $pdo->query("
        SELECT g.*, c.name as console_name
        FROM games g
        JOIN consoles c ON g.console_id = c.id
        WHERE g.is_featured = 1
        ORDER BY g.release_date DESC
        LIMIT 3
    ");
    $featuredGames = $stmt->fetchAll();
} catch (PDOException $e) {
    $error = "Database error: " . $e->getMessage();
    $featuredGames = [];
}

// Get recently added games
try {
    $stmt = $pdo->query("
        SELECT g.*, c.name as console_name
        FROM games g
        JOIN consoles c ON g.console_id = c.id
        ORDER BY g.created_at DESC
        LIMIT 8
    ");
    $recentGames = $stmt->fetchAll();
} catch (PDOException $e) {
    $error = "Database error: " . $e->getMessage();
    $recentGames = [];
}

// Include the HTML template
include 'library.html';
?>