function get($m="", $opts=array())
{
- echo "start?";
- // prune irrelivant stuff..
+ // prune irrelivant stuff..
*/
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");
$f->having("mm > 2");
$f->orderBy('mm desc') ;
$f->limit(10000);
- exit;
$ar = $f->fetchAll();
+
foreach($ar as $f) {
$q = DB_DataObject::Factory('Events');
$q->query("DELETE FROM Events where
AND
on_table = '{$q->escape($f->on_table)}'
AND
- id > {$f->min_id}
+ id >= {$f->min_id}
AND
- id < {$f->max_id}
+ id <= {$f->max_id}
");
}
-
+ $f = DB_DataObject::Factory('Events');
+ $after = $f->count();
+ echo "DELETED : " . ($before - $after) . " records\n";