add cleanup for ratelimit table

[uguu.git] / src / Classes / expireChecker.php

diff --git a/src/Classes/expireChecker.php b/src/Classes/expireChecker.php
index d13662a70e65d08af97db0d5f3cbca538b5a491b..a66e2fd1e5f09cb8f86a033c6e0df410e0384dce 100755 (executable)
--- a/src/Classes/expireChecker.php
+++ b/src/Classes/expireChecker.php
@@ -37,6 +37,15 @@ class expireChecker
         }
     }
 
+    public function cleanRateLimitDB(): void {
+        $query = match ($this->dbType) {
+            'pgsql' => 'DELETE FROM ratelimit WHERE time < EXTRACT(epoch from NOW() - INTERVAL \'24 HOURS\')',
+            default => 'DELETE FROM ratelimit WHERE time <= strftime(\'%s\', datetime(\'now\', \'-24 HOURS\'));'
+        };
+        $q = $this->DB->prepare($query);
+        $q->execute();
+        $q->closeCursor();
+    }
     public function deleteFiles(array $filenames): void {
         foreach ($filenames as $filename) {
             unlink($this->CONFIG['FILES_ROOT'] . $filename);