query('SELECT COUNT(id) AS all_files FROM files WHERE id NOT IN (SELECT id FROM file_bans)');
$stmt->execute();
$max_pages = ceil(($stmt->fetch(PDO::FETCH_ASSOC)['all_files'] ?: 0) / $limit);
$page = min($page, $max_pages - 1);
// getting files
$offset = $page * $limit;
$stmt = $db->query("SELECT f.id, f.mime, f.extension
FROM files f
WHERE f.id NOT IN (SELECT id FROM file_bans)
ORDER BY f.uploaded_at DESC
LIMIT $limit OFFSET $offset
");
$stmt->execute();
$files = $stmt->fetchAll();
?>
File Catalogue (Page <?= $page + 1 ?>/<?= $max_pages ?>) - <?= INSTANCE_NAME ?>
= 0): ?>
← Previous page→ Next page
 ?>)
