Changeset 4938 for extensions/Mail_supervisor/include/save_info.php

Timestamp:

Feb 22, 2010, 2:05:32 PM (14 years ago)

Author:

cljosse

Message:

[Mail_supervisor] Limitation of the number of address IP shown by page

File:

• extensions/Mail_supervisor/include/save_info.php (modified) (2 diffs)

extensions/Mail_supervisor/include/save_info.php

@@ -59 +59 @@
                          array_push($liste_bl,$row);
                                 }
-//================ Liste IP ==============                      
+//================ Liste IP ==============              
+$req = mysql_query('SELECT count(distinct(`IP`)) FROM '.HISTORY_TABLE.'    '); 
+$nbip =  array_pop(mysql_fetch_row($req)) ;
+
+
              $query = '
     SELECT DISTINCT     H.`id`,
@@ -77 +81 @@
         }
         
-        $query .= '
+        $query .= '     
+        GROUP by H.`IP` 
+        ORDER by `id` DESC
+        LIMIT '.(int)($params['per_page']*$params['start']).','.(int)$params['per_page'].'
         
-        GROUP by H.`IP` ;
-        
-        ;'  ;//
+        '   ;
         $result = pwg_query($query);
         $liste_ip=array();