projects
/
Pman.Core
/ commitdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
| commitdiff |
tree
raw
|
patch
|
inline
| side by side (parent:
cc3e16b
)
Prune.php
author
Alan Knowles
<alan@roojs.com>
Wed, 9 Dec 2015 09:26:11 +0000
(17:26 +0800)
committer
Alan Knowles
<alan@roojs.com>
Wed, 9 Dec 2015 09:26:11 +0000
(17:26 +0800)
Prune.php
patch
|
blob
|
history
diff --git
a/Prune.php
b/Prune.php
index
fd6cdba
..
c0a6c29
100644
(file)
--- 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 = 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') ;
$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
$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}
on_id = {$f->on_id}
AND
id > {$f->min_id} AND id < {$f->max_id}