Iptables.php
authorAlan Knowles <alan@akbkhome.com>
Fri, 29 Mar 2013 07:29:29 +0000 (15:29 +0800)
committerAlan Knowles <alan@akbkhome.com>
Fri, 29 Mar 2013 07:29:29 +0000 (15:29 +0800)
Iptables.php

index f7a2164..4a8e1f0 100644 (file)
@@ -108,11 +108,12 @@ class Pman_Admin_Iptables extends Pman {
         $e->selectAdd();
         $e->selectAdd(" 
             distinct(ipaddr) as ipaddr
-             max(event_when) + $interval as expires)
-                    
+            max(event_when) + $interval as expires
+                     
         ");
         $e->person_table = DB_DataObject::factory('person')->tableName();
         $e->whereAddIn('person_id', $peps, 'int');
+        $e->groupBy('event_when');
          $e->whereAdd("event_when > NOW() - $interval");