From 8e8482355baa55a5c9e3cb3553eecf5a733e2897 Mon Sep 17 00:00:00 2001 From: friendica Date: Tue, 23 Oct 2012 17:14:50 -0700 Subject: more heavy lifting --- include/expire.php | 43 ++++++++++++------------------------------- 1 file changed, 12 insertions(+), 31 deletions(-) (limited to 'include/expire.php') diff --git a/include/expire.php b/include/expire.php index 755cd2494..3a914a41d 100644 --- a/include/expire.php +++ b/include/expire.php @@ -1,50 +1,31 @@ set_baseurl(get_config('system','url')); + cli_startup(); // physically remove anything that has been deleted for more than two months - $r = q("delete from item where deleted = 1 and changed < UTC_TIMESTAMP() - INTERVAL 60 DAY"); + $r = q("delete from item where item_flags & %d and changed < UTC_TIMESTAMP() - INTERVAL 60 DAY", + intval(ITEM_DELETED) + ); // make this optional as it could have a performance impact on large sites if(intval(get_config('system','optimize_items'))) q("optimize table item"); - logger('expire: start'); + logger('expire: start', LOGGER_DEBUG); - $r = q("SELECT `uid`,`username`,`expire` FROM `user` WHERE `expire` != 0"); - if(count($r)) { + + $r = q("SELECT channel_id, channel_address, channel_expire_days from channel where channel_expire_days != 0"); + if($r && count($r)) { foreach($r as $rr) { - logger('Expire: ' . $rr['username'] . ' interval: ' . $rr['expire'], LOGGER_DEBUG); - item_expire($rr['uid'],$rr['expire']); + logger('Expire: ' . $rr['channel_address'] . ' interval: ' . $rr['channel_expire_days'], LOGGER_DEBUG); + item_expire($rr['channel_id'],$rr['channel_expire_days']); } } -- cgit v1.2.3