Pman.js

[Pman.Core] / Prune.php

diff --git a/Prune.php b/Prune.php
index 625e7d2..2ed9ea3 100644 (file)
--- a/Prune.php
+++ b/Prune.php
@@ -78,7 +78,10 @@ class Pman_Core_Prune extends Pman
          WHERE action = 'NOTIFY' and event_when < NOW() - INTERVAL 1 WEEK GROUP BY  on_id, on_table HAVING  mm > 2 ORDER BY mm desc;
          */
         
-        DB_DataObject::debugLevel(1);
+        //DB_DataObject::debugLevel(1);
+        $f = DB_DataObject::Factory('Events');
+        $before = $f->count();
+
         $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");
@@ -98,13 +101,15 @@ class Pman_Core_Prune extends Pman
                   AND
                   on_table = '{$q->escape($f->on_table)}'
                   AND
-                  id >= {$f->min_id}
+                  id >  {$f->min_id}  -- allow the first one to stay....
                   AND
                   id <= {$f->max_id}
             ");
         }
         
-        
+        $f = DB_DataObject::Factory('Events');
+        $after = $f->count();
+        echo "DELETED : " . ($before - $after) . " records\n";