prune old expired and deleted items

1 files changed, 5 insertions, 0 deletions

diff --git a/include/expire.php b/include/expire.php
index 64dbe2536..7608b9054 100755
--- a/include/expire.php
+++ b/include/expire.php
@@ -29,6 +29,11 @@ function expire_run($argv, $argc){
 	$a->set_baseurl(get_config('system','url'));
 
 
+	// physically remove anything that has been deleted from more than two months
+
+	$r = q("delete from item where deleted = 1 and changed < UTC_TIMESTAMP() - INTERVAL 60 DAY");
+
+
 	logger('expire: start');
 	
 	$r = q("SELECT `uid`,`username`,`expire` FROM `user` WHERE `expire` != 0");