From b6b10c28ec80659b9cd729a1912167b249782c86 Mon Sep 17 00:00:00 2001 From: Alan Knowles Date: Wed, 9 Dec 2015 17:27:12 +0800 Subject: [PATCH] Prune.php --- Prune.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/Prune.php b/Prune.php index c4642f61..9414f36d 100644 --- a/Prune.php +++ b/Prune.php @@ -79,12 +79,14 @@ class Pman_Core_Prune extends Pman $f->limit(1000); $ar = $f->fetchAll(); foreach($ar as $f) { - $f = DB_DataObject::Factory('Events'); - $f->query("DELETE FROM Events where + $q = DB_DataObject::Factory('Events'); + $q->query("DELETE FROM Events where action = 'NOTIFY' AND on_id = {$f->on_id} AND + on_table = '{$q->escape($f->on_table)}' + AND id > {$f->min_id} AND id < {$f->max_id} "); } -- 2.39.2