feat: we are using SQL databases now

1 files changed, 6 insertions, 3 deletions

diff --git a/lib/file.php b/lib/file.php
index fe7dae1..fc3e38a 100644
--- a/lib/file.php
+++ b/lib/file.php
@@ -19,12 +19,11 @@ function verify_mimetype(string $file_path, string $mimetype): bool
     throw new RuntimeException("Illegal type for MIME verifications: $mimetype");
 }
 
-function delete_file(string $file_id, string $file_extension): bool
+function delete_file(string $file_id, string $file_extension, PDO|null $db = null): bool
 {
     $paths = [
         FILE_UPLOAD_DIRECTORY . "/{$file_id}.{$file_extension}",
-        FILE_THUMBNAIL_DIRECTORY . "/{$file_id}.webp",
-        FILE_METADATA_DIRECTORY . "/{$file_id}.metadata.json"
+        FILE_THUMBNAIL_DIRECTORY . "/{$file_id}.webp"
     ];
 
     foreach ($paths as $path) {
@@ -33,6 +32,10 @@ function delete_file(string $file_id, string $file_extension): bool
         }
     }
 
+    if ($db) {
+        $db->prepare('DELETE FROM files WHERE id = ? AND extension = ?')->execute([$file_id, $file_extension]);
+    }
+
     return true;
 }