X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=scripts%2Ftriminboxes.php;h=da09817e5b11f5dc491187f9dacf1bd538c26bd3;hb=0fd8e758ade32204b452cc9fd40e071f0ec8c0f6;hp=0d545b3263f5014c78c4ef75056abb14ff08f182;hpb=198afa0a1d61c4db2cf6b66e5801af506462ab9b;p=quix0rs-gnu-social.git diff --git a/scripts/triminboxes.php b/scripts/triminboxes.php index 0d545b3263..da09817e5b 100644 --- a/scripts/triminboxes.php +++ b/scripts/triminboxes.php @@ -1,8 +1,8 @@ #!/usr/bin/env php . */ -# Abort if called from a web server -if (isset($_SERVER) && array_key_exists('REQUEST_METHOD', $_SERVER)) { - print "This script must be run from the command line\n"; - exit(1); -} - -ini_set("max_execution_time", "0"); -ini_set("max_input_time", "0"); -set_time_limit(0); -mb_internal_encoding('UTF-8'); - define('INSTALLDIR', realpath(dirname(__FILE__) . '/..')); -define('LACONICA', true); -// Preset the server at the command line +$shortoptions = 'u::'; +$longoptions = array('start-user-id::'); -$server = ($argc > 2) ? $argv[2] : null; -$path = ($argc > 3) ? $argv[3] : null; +$helptext = << + --start-user-id= User ID to start after. Default is all. -$user = new User(); -if ($argc > 1) { - $user->whereAdd('id > ' . $argv[1]); -} -$cnt = $user->find(); +END_OF_TRIM_HELP; -while ($user->fetch()) { +require_once INSTALLDIR.'/scripts/commandline.inc'; - $inbox_entry = new Notice_inbox(); - $inbox_entry->user_id = $user->id; - $inbox_entry->orderBy('created DESC'); - $inbox_entry->limit(1000, 1); +$id = null; +if (have_option('u')) { + $id = get_option_value('u'); +} else if (have_option('--start-user-id')) { + $id = get_option_value('--start-user-id'); +} else { $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..."; +$user = new User(); - // Wait to let slaves catch up +if (!empty($id)) { + $user->whereAdd('id > ' . $id); +} - usleep($delay * 1000000); +$cnt = $user->find(); - print "DONE.\n"; +while ($user->fetch()) { + Notice_inbox::gc($user->id); }