X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=scripts%2Ftriminboxes.php;h=da09817e5b11f5dc491187f9dacf1bd538c26bd3;hb=c9eb7c1f0b60cbcf4672bcfca0814dd1bfc1dcf0;hp=5575dd4fc1251e0def93c554bd7b66ba3cc47a5f;hpb=0582381c6631cb8b8e914cebbcf2e387b947c83f;p=quix0rs-gnu-social.git diff --git a/scripts/triminboxes.php b/scripts/triminboxes.php index 5575dd4fc1..da09817e5b 100644 --- a/scripts/triminboxes.php +++ b/scripts/triminboxes.php @@ -1,8 +1,8 @@ #!/usr/bin/env php find(); while ($user->fetch()) { - - $inbox_entry = new Notice_inbox(); - $inbox_entry->user_id = $user->id; - $inbox_entry->orderBy('created DESC'); - $inbox_entry->limit(1000, 1); - - $id = null; - - if ($inbox_entry->find(true)) { - $id = $inbox_entry->notice_id; - } - - $inbox_entry->free(); - unset($inbox_entry); - - if (is_null($id)) { - continue; - } - - $start = microtime(true); - - $old_inbox = new Notice_inbox(); - $cnt = $old_inbox->query('DELETE from notice_inbox WHERE user_id = ' . $user->id . ' AND notice_id < ' . $id); - $old_inbox->free(); - unset($old_inbox); - - print "Deleted $cnt notices for $user->nickname ($user->id).\n"; - - $finish = microtime(true); - - $delay = 3.0 * ($finish - $start); - - print "Delaying $delay seconds..."; - - // Wait to let slaves catch up - - usleep($delay * 1000000); - - print "DONE.\n"; + Notice_inbox::gc($user->id); }