Add support for legacy $lang config in App->loadConfig

[friendica.git] / src / Worker / DBClean.php

diff --git a/src/Worker/DBClean.php b/src/Worker/DBClean.php
index 40883d5138420aa50d512bb66fdab2b2e111c4a2..7a0b1f8473fa6120b89562c62386eae82ca4f37c 100644 (file)
--- a/src/Worker/DBClean.php
+++ b/src/Worker/DBClean.php
@@ -10,6 +10,8 @@ use Friendica\Core\Config;
 use Friendica\Core\Worker;
 use dba;
 
+require_once 'include/dba.php';
+
 class DBClean {
        public static function execute($stage = 0) {
 
@@ -17,9 +19,6 @@ class DBClean {
                        return;
                }
 
-               // Get the expire days for step 8 and 9
-               $days = Config::get('system', 'dbclean-expire-days', 0);
-
                if ($stage == 0) {
                        self::forkCleanProcess();
                } else {
@@ -31,6 +30,9 @@ class DBClean {
         * @brief Fork the different DBClean processes
         */
        private static function forkCleanProcess() {
+               // Get the expire days for step 8 and 9
+               $days = Config::get('system', 'dbclean-expire-days', 0);
+
                for ($i = 1; $i <= 10; $i++) {
                        // Execute the background script for a step when it isn't finished.
                        // Execute step 8 and 9 only when $days is defined.
@@ -58,8 +60,6 @@ class DBClean {
         * 10:  Old conversations.
         */
        private static function removeOrphans($stage) {
-               global $db;
-
                $count = 0;
 
                // We split the deletion in many small tasks
@@ -67,21 +67,30 @@ class DBClean {
 
                // Get the expire days for step 8 and 9
                $days = Config::get('system', 'dbclean-expire-days', 0);
+               $days_unclaimed = Config::get('system', 'dbclean-expire-unclaimed', 90);
+
+               if ($days_unclaimed == 0) {
+                       $days_unclaimed = $days;
+               }
 
                if ($stage == 1) {
+                       if ($days_unclaimed <= 0) {
+                               return;
+                       }
+
                        $last_id = Config::get('system', 'dbclean-last-id-1', 0);
 
                        logger("Deleting old global item entries from item table without user copy. Last ID: ".$last_id);
                        $r = dba::p("SELECT `id` FROM `item` WHERE `uid` = 0 AND
                                                NOT EXISTS (SELECT `guid` FROM `item` AS `i` WHERE `item`.`guid` = `i`.`guid` AND `i`.`uid` != 0) AND
-                                               `received` < UTC_TIMESTAMP() - INTERVAL 90 DAY AND `id` >= ?
-                                       ORDER BY `id` LIMIT ".intval($limit), $last_id);
+                                               `received` < UTC_TIMESTAMP() - INTERVAL ? DAY AND `id` >= ?
+                                       ORDER BY `id` LIMIT ".intval($limit), $days_unclaimed, $last_id);
                        $count = dba::num_rows($r);
                        if ($count > 0) {
                                logger("found global item orphans: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["id"];
-                                       dba::delete('item', array('id' => $orphan["id"]));
+                                       dba::delete('item', ['id' => $orphan["id"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 1, $last_id);
                        } else {
@@ -103,7 +112,7 @@ class DBClean {
                                logger("found item orphans without parents: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["id"];
-                                       dba::delete('item', array('id' => $orphan["id"]));
+                                       dba::delete('item', ['id' => $orphan["id"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 2, $last_id);
                        } else {
@@ -129,7 +138,7 @@ class DBClean {
                                logger("found thread orphans: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["iid"];
-                                       dba::delete('thread', array('iid' => $orphan["iid"]));
+                                       dba::delete('thread', ['iid' => $orphan["iid"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 3, $last_id);
                        } else {
@@ -155,7 +164,7 @@ class DBClean {
                                logger("found notify orphans: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["id"];
-                                       dba::delete('notify', array('iid' => $orphan["iid"]));
+                                       dba::delete('notify', ['iid' => $orphan["iid"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 4, $last_id);
                        } else {
@@ -181,7 +190,7 @@ class DBClean {
                                logger("found notify-threads orphans: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["id"];
-                                       dba::delete('notify-threads', array('id' => $orphan["id"]));
+                                       dba::delete('notify-threads', ['id' => $orphan["id"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 5, $last_id);
                        } else {
@@ -207,7 +216,7 @@ class DBClean {
                                logger("found sign orphans: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["id"];
-                                       dba::delete('sign', array('iid' => $orphan["iid"]));
+                                       dba::delete('sign', ['iid' => $orphan["iid"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 6, $last_id);
                        } else {
@@ -233,7 +242,7 @@ class DBClean {
                                logger("found term orphans: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["tid"];
-                                       dba::delete('term', array('oid' => $orphan["oid"]));
+                                       dba::delete('term', ['oid' => $orphan["oid"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 7, $last_id);
                        } else {
@@ -272,7 +281,7 @@ class DBClean {
                                logger("found expired threads: ".$count);
                                while ($thread = dba::fetch($r)) {
                                        $last_id = $thread["iid"];
-                                       dba::delete('thread', array('iid' => $thread["iid"]));
+                                       dba::delete('thread', ['iid' => $thread["iid"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 8, $last_id);
                        } else {
@@ -300,7 +309,7 @@ class DBClean {
                                logger("found global item entries from expired threads: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["id"];
-                                       dba::delete('item', array('id' => $orphan["id"]));
+                                       dba::delete('item', ['id' => $orphan["id"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 9, $last_id);
                        } else {
@@ -312,17 +321,18 @@ class DBClean {
                        Config::set('system', 'dbclean-last-id-9', $last_id);
                } elseif ($stage == 10) {
                        $last_id = Config::get('system', 'dbclean-last-id-10', 0);
+                       $days = intval(Config::get('system', 'dbclean_expire_conversation', 90));
 
                        logger("Deleting old conversations. Last created: ".$last_id);
                        $r = dba::p("SELECT `received`, `item-uri` FROM `conversation`
-                                       WHERE `received` < UTC_TIMESTAMP() - INTERVAL 90 DAY
-                                       ORDER BY `received` LIMIT ".intval($limit));
+                                       WHERE `received` < UTC_TIMESTAMP() - INTERVAL ? DAY
+                                       ORDER BY `received` LIMIT ".intval($limit), $days);
                        $count = dba::num_rows($r);
                        if ($count > 0) {
                                logger("found old conversations: ".$count);
                                while ($orphan = dba::fetch($r)) {
                                        $last_id = $orphan["received"];
-                                       dba::delete('conversation', array('item-uri' => $orphan["item-uri"]));
+                                       dba::delete('conversation', ['item-uri' => $orphan["item-uri"]]);
                                }
                                Worker::add(PRIORITY_MEDIUM, 'DBClean', 10, $last_id);
                        } else {