X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=src%2FWorker%2FRemoveContact.php;h=28a32160a014c7c830f5f5d5fb71952701792030;hb=d4f7bfa676bc9a8ffcb304912b48b360453d0f3c;hp=8f986eab11559c18630315429dd783910dfa9205;hpb=91f405bac4ae94bc883ab1dd32df468fc7eae324;p=friendica.git diff --git a/src/Worker/RemoveContact.php b/src/Worker/RemoveContact.php index 8f986eab11..28a32160a0 100644 --- a/src/Worker/RemoveContact.php +++ b/src/Worker/RemoveContact.php @@ -1,26 +1,54 @@ . + * */ + namespace Friendica\Worker; +use Friendica\Core\Logger; use Friendica\Database\DBA; use Friendica\Core\Protocol; +use Friendica\Model\Item; -require_once 'include/dba.php'; - +/** + * Removes orphaned data from deleted contacts + */ class RemoveContact { public static function execute($id) { // Only delete if the contact is to be deleted - $condition = ['network' => Protocol::PHANTOM, 'id' => $id]; - $r = DBA::exists('contact', $condition); - if (!DBA::isResult($r)) { + $contact = DBA::selectFirst('contact', ['uid'], ['deleted' => true]); + if (!DBA::isResult($contact)) { return; } // Now we delete the contact and all depending tables + $condition = ['uid' => $contact['uid'], 'contact-id' => $id]; + do { + $items = Item::select(['id', 'guid'], $condition, ['limit' => 100]); + while ($item = Item::fetch($items)) { + Logger::info('Delete removed contact item', ['id' => $item['id'], 'guid' => $item['guid']]); + DBA::delete('item', ['id' => $item['id']]); + } + DBA::close($items); + } while (Item::exists($condition)); + DBA::delete('contact', ['id' => $id]); } }