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();
foreach ($files as &$f) {
if (str_starts_with($f['mime'], 'video/')) {
$f['color'] = 'blue';
} else if ($f['mime'] == 'application/x-shockwave-flash') {
$f['color'] = 'red';
}
$f['thumb_title'] = "{$f['mime']} ({$f['extension']})";
}
unset($f);
?>
File Catalogue (Page <?= $page + 1 ?>/<?= $max_pages ?>) - <?= INSTANCE_NAME ?>
 ?>)
