// 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');