feat: file bans

1 files changed, 1 insertions, 1 deletions

diff --git a/lib/partials.php b/lib/partials.php
index 24e6e70..64b12bd 100644
--- a/lib/partials.php
+++ b/lib/partials.php
@@ -82,7 +82,7 @@ function html_mini_navbar(string|null $subtitle = null)
 function html_footer()
 {
     $db = new PDO(DB_URL, DB_USER, DB_PASS);
-    $stmt = $db->query('SELECT COUNT(*) AS file_count, SUM(size) AS file_overall_size FROM files');
+    $stmt = $db->query('SELECT COUNT(*) AS file_count, SUM(size) AS file_overall_size FROM files WHERE id NOT IN (SELECT id FROM file_bans)');
     $stmt->execute();
 
     $row = $stmt->fetch(PDO::FETCH_ASSOC);