From 312b5d6e873d53b78db4bef628fe01391a30cdb0 Mon Sep 17 00:00:00 2001
From: ilotterytea <iltsu@alright.party>
Date: Wed, 18 Jun 2025 15:00:49 +0500
Subject: feat: file bans

---
 lib/partials.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib/partials.php')

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);
-- 
cgit v1.2.3