Merge pull request #53 from fabrixxm/master

[friendica.git] / include / expire.php

diff --git a/include/expire.php b/include/expire.php
old mode 100644 (file)
new mode 100755 (executable)
index 64dbe25..5fa0ec7
--- 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 for more than two months
+
+       $r = q("delete from item where deleted = 1 and changed < UTC_TIMESTAMP() - INTERVAL 60 DAY");
+       q("optimize table item");
+
        logger('expire: start');
        
        $r = q("SELECT `uid`,`username`,`expire` FROM `user` WHERE `expire` != 0");