From bd1d8f5687ffaab8dea1beced450363703e8b393 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 9 Dec 2015 17:26:11 +0800 Subject: [PATCH] Prune.php --- Prune.php | 4 +--- 1 file changed, 1 insertion(+), 3 deletions(-) diff --git a/Prune.php b/Prune.php index fd6cdba3..c0a6c298 100644 --- a/Prune.php +++ b/Prune.php @@ -72,7 +72,7 @@ class Pman_Core_Prune extends Pman $f = DB_DataObject::Factory('Events'); $f->selectAdd(); $f->selectAdd("on_id, min(id) as min_id, max(id) as max_id, count(*) as mm"); - $f->whereAdd("action = 'NOTIFY' and event_when < NOW() - INTERVAL 2 WEEK"); + $f->whereAdd("action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK"); $f->groupBy('on_id'); $f->having("mm > 2"); $f->orderBy('mm desc') ; @@ -83,8 +83,6 @@ class Pman_Core_Prune extends Pman $f->query("DELETE FROM Events where action = 'NOTIFY' AND - event_when < NOW() - INTERVAL 1 WEEK - AND on_id = {$f->on_id} AND id > {$f->min_id} AND id < {$f->max_id} -- 2.39.2