<?php
require_once __DIR__ . '/../config.php';

// Maximaal aantal shoutouts
$max = 200;

$result = $db_conx->query("SELECT id FROM shoutouts ORDER BY id DESC");
$total = $result->num_rows;

if ($total > $max) {
    $limit = $total - $max;
    $db_conx->query("DELETE FROM shoutouts ORDER BY id ASC LIMIT $limit");
    echo "✔ Oude shoutouts verwijderd: $limit";
} else {
    echo "Niks te verwijderen. ($total / $max)";
}
?>