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