Prune.php

[Pman.Core] / Prune.php

diff --git a/Prune.php b/Prune.php
index 9414f36..c5ac9bd 100644 (file)
--- a/Prune.php
+++ b/Prune.php
@@ -52,6 +52,8 @@ class Pman_Core_Prune extends Pman
         $f->query("
             DELETE FROM Events where 
                   event_when < NOW() - INTERVAL {$inM} MONTH
+                  AND
+                  action != 'NOTIFY'
                   LIMIT 100000
         ");
         
@@ -68,7 +70,7 @@ class Pman_Core_Prune extends Pman
         // rather than deleting them all, it's probably best to just delete notify events that occured to often.
         // eg. when we tried to deliver multiple times without success...
         
-        
+        //DB_DataObject::debugLevel(1);
         $f = DB_DataObject::Factory('Events');
         $f->selectAdd();
         $f->selectAdd("on_id, on_table, min(id) as min_id, max(id) as max_id, count(*) as mm");
@@ -87,7 +89,9 @@ class Pman_Core_Prune extends Pman
                   AND
                   on_table = '{$q->escape($f->on_table)}'
                   AND
-                  id > {$f->min_id} AND id < {$f->max_id}
+                  id > {$f->min_id}
+                  AND
+                  id < {$f->max_id}
             ");
         }