X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=Prune.php;h=c0a6c2986e46132d4b201693beb27883792c44d5;hb=bd1d8f5687ffaab8dea1beced450363703e8b393;hp=fd6cdba358e96ce853685ac656e55a946d6cc148;hpb=cc3e16b63954adc4ffb3655cfddd2c064543a4fe;p=Pman.Core 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}