X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=include%2Fexpire.php;h=a73272a2efd93b47824ebc75526c956dca95d934;hb=b0df06dd726a9b287f3ea87e151dd6823a69cb75;hp=64dbe2536d4d880294f8060bd6e1b684d1af83df;hpb=994011ddb6cc1097214537160a10bf710aedc553;p=friendica.git

diff --git a/include/expire.php b/include/expire.php
index 64dbe2536d..a73272a2ef 100644
--- a/include/expire.php
+++ b/include/expire.php
@@ -2,7 +2,7 @@
 
 require_once("boot.php");
 
-function expire_run($argv, $argc){
+function expire_run(&$argv, &$argc){
 	global $a, $db;
 
 	if(is_null($a)) {
@@ -11,7 +11,7 @@ function expire_run($argv, $argc){
   
 	if(is_null($db)) {
 	    @include(".htconfig.php");
-    	require_once("dba.php");
+    	require_once("include/dba.php");
 	    $db = new dba($db_host, $db_user, $db_pass, $db_data);
     	unset($db_host, $db_user, $db_pass, $db_data);
   	};
@@ -25,10 +25,18 @@ function expire_run($argv, $argc){
 	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");
+
+	// 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");