<?php
require_once 'includes/db.php';

echo "Event 6 Details:\n";
echo "================\n";

// Get all events to see which one is event 6
$stmt = $pdo->query("SELECT event_id, event_name, scoring_format_id FROM events");
$events = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($events as $e) {
    echo "Event {$e['event_id']}: {$e['event_name']} (format: {$e['scoring_format_id']})\n";
}

echo "\n\nScoring Formats:\n";
echo "================\n";
$stmt = $pdo->query("SELECT * FROM scoring_formats");
$formats = $stmt->fetchAll(PDO::FETCH_ASSOC);

foreach ($formats as $f) {
    echo "Format {$f['format_id']}: {$f['format_name']}\n";
    echo "  Aggregation: {$f['aggregation_method']}\n";
    echo "  Scale: {$f['scale_type']}\n\n";
}
