X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FWorker%2FRemoveUnusedContacts.php;h=c2a0719870c721657f2b1491d5d7201c05f17ca9;hb=bf8fb215a9cc554b5ec5b774168a52fb56fa43e6;hp=383a4485f5398d553748b404349065ea38b109d9;hpb=2b8adf50733da5d55c8846b5407946fa4bf78fbf;p=friendica.git diff --git a/src/Worker/RemoveUnusedContacts.php b/src/Worker/RemoveUnusedContacts.php index 383a4485f5..c2a0719870 100644 --- a/src/Worker/RemoveUnusedContacts.php +++ b/src/Worker/RemoveUnusedContacts.php @@ -29,8 +29,10 @@ use Friendica\Model\Photo; /** * Removes public contacts that aren't in use */ -class RemoveUnusedContacts { - public static function execute() { +class RemoveUnusedContacts +{ + public static function execute() + { $condition = ["`uid` = ? AND NOT `self` AND NOT `nurl` IN (SELECT `nurl` FROM `contact` WHERE `uid` != ?) AND (NOT `network` IN (?, ?, ?, ?, ?, ?) OR (`archive` AND `success_update` < UTC_TIMESTAMP() - INTERVAL ? DAY)) AND NOT `id` IN (SELECT `author-id` FROM `item`) AND NOT `id` IN (SELECT `owner-id` FROM `item`)