<?php
header('Content-Type: application/json');
require_once '../../config/database.php';

try {
    $database = new Database();
    $db = $database->getConnection();
    
    // Get active stories that haven't expired
    $query = "SELECT id, title, image, link, duration, views_count 
              FROM stories 
              WHERE is_active = 1 
              AND (expires_at IS NULL OR expires_at > NOW())
              ORDER BY order_position ASC, created_at DESC";
    
    $stmt = $db->prepare($query);
    $stmt->execute();
    $stories = $stmt->fetchAll(PDO::FETCH_ASSOC);
    
    // Add full image URLs
    foreach ($stories as &$story) {
        $story['image'] = '../' . $story['image'];
    }
    
    echo json_encode($stories);
    
} catch (Exception $e) {
    http_response_code(500);
    echo json_encode(['error' => $e->getMessage()]);
}