diff options
author | Mario <mario@mariovavti.com> | 2021-12-17 20:26:36 +0100 |
---|---|---|
committer | Mario <mario@mariovavti.com> | 2021-12-17 20:26:36 +0100 |
commit | b90d98fc2be5f04cf2ffa62933f9ffd81d45dec5 (patch) | |
tree | 05fbbd085063923d4a6edf6f463504fd43cd0269 /include/connections.php | |
parent | 2bd69495d2bfce0481e47421cee700aa08eee54f (diff) | |
download | volse-hubzilla-b90d98fc2be5f04cf2ffa62933f9ffd81d45dec5.tar.gz volse-hubzilla-b90d98fc2be5f04cf2ffa62933f9ffd81d45dec5.tar.bz2 volse-hubzilla-b90d98fc2be5f04cf2ffa62933f9ffd81d45dec5.zip |
implement background deleting of items in contact_remove()
Diffstat (limited to 'include/connections.php')
-rw-r--r-- | include/connections.php | 103 |
1 files changed, 58 insertions, 45 deletions
diff --git a/include/connections.php b/include/connections.php index fbbf59c72..98cd4bbb5 100644 --- a/include/connections.php +++ b/include/connections.php @@ -1,5 +1,6 @@ <?php /** @file */ +use Zotlabs\Daemon\Master; function abook_store_lowlevel($arr) { @@ -389,51 +390,8 @@ function contact_remove($channel_id, $abook_id) { } } - $r = q("select id, parent from item where (owner_xchan = '%s' or author_xchan = '%s') and uid = %d and item_retained = 0 and item_starred = 0", - dbesc($abook['abook_xchan']), - dbesc($abook['abook_xchan']), - intval($channel_id) - ); - if($r) { - $already_saved = []; - foreach($r as $rr) { - $w = $x = $y = null; - - // optimise so we only process newly seen parent items - if (in_array($rr['parent'],$already_saved)) { - continue; - } - // if this isn't the parent, fetch the parent's item_retained and item_starred to see if the conversation - // should be retained - if($rr['id'] != $rr['parent']) { - $w = q("select id, item_retained, item_starred from item where id = %d", - intval($rr['parent']) - ); - if($w) { - // see if the conversation was filed - $x = q("select uid from term where otype = %d and oid = %d and ttype = %d limit 1", - intval(TERM_OBJ_POST), - intval($w[0]['id']), - intval(TERM_FILE) - ); - if (intval($w[0]['item_retained']) || intval($w[0]['item_starred']) || $x) { - $already_saved[] = $rr['parent']; - continue; - } - } - } - // see if this item was filed - $y = q("select uid from term where otype = %d and oid = %d and ttype = %d limit 1", - intval(TERM_OBJ_POST), - intval($rr['id']), - intval(TERM_FILE) - ); - if ($y) { - continue; - } - drop_item($rr['id'],false); - } - } + // remove items in the background as this can take some time + Master::Summon(['Delxitems', $channel_id, $abook['abook_xchan']]); q("delete from abook where abook_id = %d and abook_channel = %d", intval($abook['abook_id']), @@ -463,7 +421,62 @@ function contact_remove($channel_id, $abook_id) { return true; } +function remove_abook_items($channel_id, $xchan_hash) { + + $r = q("select id from item where (owner_xchan = '%s' or author_xchan = '%s') and uid = %d and item_retained = 0 and item_starred = 0", + dbesc($xchan_hash), + dbesc($xchan_hash), + intval($channel_id) + ); + if (! $r) { + return; + } + + $already_saved = []; + foreach ($r as $rr) { + $w = $x = $y = null; + + // optimise so we only process newly seen parent items + if (in_array($rr['parent'], $already_saved)) { + continue; + } + + // if this isn't the parent, fetch the parent's item_retained and item_starred to see if the conversation + // should be retained + if ($rr['id'] != $rr['parent']) { + $w = q("select id, item_retained, item_starred from item where id = %d", + intval($rr['parent']) + ); + + if ($w) { + // see if the conversation was filed + $x = q("select uid from term where otype = %d and oid = %d and ttype = %d limit 1", + intval(TERM_OBJ_POST), + intval($w[0]['id']), + intval(TERM_FILE) + ); + + if (intval($w[0]['item_retained']) || intval($w[0]['item_starred']) || $x) { + $already_saved[] = $rr['parent']; + continue; + } + } + } + + // see if this item was filed + $y = q("select uid from term where otype = %d and oid = %d and ttype = %d limit 1", + intval(TERM_OBJ_POST), + intval($rr['id']), + intval(TERM_FILE) + ); + + if ($y) { + continue; + } + drop_item($rr['id'],false); + } +} function random_profile() { $randfunc = db_getfunc('rand'); |