require_once("boot.php");
-function expire_run($argv, $argc){
+function expire_run(&$argv, &$argc){
global $a, $db;
if(is_null($a)) {
$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");
+
+ // 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');
$r = q("SELECT `uid`,`username`,`expire` FROM `user` WHERE `expire` != 0");