src/Worker/RemoveContact.php

   1 <?php
   2 /**
   3  * @file src/Worker/RemoveContact.php
   4  * @brief Removes orphaned data from deleted contacts
   5  */
   6 namespace Friendica\Worker;
   7
   8 use Friendica\Database\DBA;
   9 use Friendica\Core\Protocol;
  10 use Friendica\Model\Item;
  11
  12 require_once 'include/dba.php';
  13
  14 class RemoveContact {
  15         public static function execute($id) {
  16
  17                 // Only delete if the contact is to be deleted
  18                 $condition = ['network' => Protocol::PHANTOM, 'id' => $id];
  19                 $contact = DBA::selectFirst('contact', ['uid'], $condition);
  20                 if (!DBA::isResult($contact)) {
  21                         return;
  22                 }
  23
  24                 // Now we delete the contact and all depending tables
  25                 $condition = ['uid' => $contact['uid'], 'contact-id' => $id];
  26                 do {
  27                         $items = Item::select(['id'], $condition, ['limit' => 100]);
  28                         while ($item = Item::fetch($items)) {
  29                                 DBA::delete('item', ['id' => $item['id']]);
  30                         }
  31                         DBA::close($items);
  32                 } while (Item::exists($condition));
  33
  34                 DBA::delete('contact', ['id' => $id]);
  35         }
  36 }