X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;ds=sidebyside;f=include%2Fexpire.php;h=35b109a50a487156ac53fe3d3ec66bfb1c9906e6;hb=47fd9226c3f0b90f460fe2031fa46cbb49a87100;hp=098125a79864efb3315fe75ebd2319b6eca5a0de;hpb=5a6da8b447430174ae231a3b8203fd4bd8416cc1;p=friendica.git diff --git a/include/expire.php b/include/expire.php index 098125a798..35b109a50a 100644 --- a/include/expire.php +++ b/include/expire.php @@ -11,13 +11,12 @@ function expire_run(&$argv, &$argc){ // 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"); + $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`"); - } + if(intval(get_config('system','optimize_items'))) + q("optimize table item"); logger('expire: start');