cleanup photo menus

[friendica.git] / include / expire.php

diff --git a/include/expire.php b/include/expire.php
index cf3b7c8e2da981ea8193d9c79cc975d94241a10f..5fa0ec758b3d723b45ac53b2a7b0dd0a951962ec 100644 (file)
--- a/include/expire.php
+++ b/include/expire.php
@@ -22,9 +22,18 @@ function expire_run($argv, $argc){
        require_once('include/items.php');
        require_once('include/Contact.php');
 
+       load_config('config');
+       load_config('system');
+
+
        $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");