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

Timestamp:

Apr 16, 2011, 3:53:31 PM (13 years ago)

Author:

cljosse

Message:

[extensions] mail_supervisor fix bug in design

File:

• extensions/Mail_supervisor/include/save_info.php (modified) (1 diff)

extensions/Mail_supervisor/include/save_info.php

@@ -4 +4 @@
 switch (strtolower($info_ip))
  {
-  case  'ajout' :  
+  case  'ajout' :
  $ip_black=str_replace("*","%",$ip_black);
  if (!($ip_black == '')) {
    $query = "
-                SELECT `ip` 
-                FROM `".MAIL_BLACK_LISTE_TABLE."` 
-                    WHERE  '".$ip_black."' LIKE ip 
-                ;";     
-        //==============================================================================                
+            SELECT `ip`
+            FROM `".MAIL_BLACK_LISTE_TABLE."`
+            WHERE  '".$ip_black."' LIKE ip
+        ;";
+    //==============================================================================
   list($count) = mysql_fetch_row(pwg_query($query));
-  //==============================================================================      
+  //==============================================================================
   $valeurs=array( 'NULL',
-                            "'".$ip_black."'",
-                                                 "'".$pays."'",
-                                                 "'".$region."'",       
-                                                 "'".$ville."'",
-                                                 '"adresse"',
-                                                 '"fai" ',
-                                                 $count + 1
-                );
-        ajout_ligne(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs, $valeurs,($count==0)) ;   
+                    "'".$ip_black."'",
+                             "'".$pays."'",
+                             "'".$region."'",
+                             "'".$ville."'",
+                             '"adresse"',
+                             '"fai" ',
+                             $count + 1
+            );
+    ajout_ligne(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs, $valeurs,($count==0)) ;
  }
- 
+
  break;
  //================================================================================================
   case 'raz':
     $ip_black=str_replace('*',"%",$ip_black);
-                $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip`  like '%".$ip_black."%' ";
-                         pwg_query($query);
-   
+        $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip`  like '%".$ip_black."%' ";
+             pwg_query($query);
+
     unset ($_SESSION['pwg_'.'action_spam']);
    break;
-   
-    default:                            
+
+    default:
    break;
-   
-  } 
+
+  }
 //================ Liste Black liste =================
   $query = "
-     SELECT *,  COUNT(`ip`) as total ,  `ip` as blacklist, `ip` as U_DELETE 
+     SELECT *,  COUNT(`ip`) as total ,  `ip` as blacklist, `ip` as U_DELETE
      FROM ".MAIL_BLACK_LISTE_TABLE."
-     GROUP by ip 
+     GROUP by ip
      ;";
-        $liste_bl = array();
+    $liste_bl = array();
  $result = pwg_query($query);
-                while ($row = mysql_fetch_array($result,MYSQL_ASSOC))   {
-                         array_push($liste_bl,$row);
-                                }          
-//================ Liste IP ==============              
-$req = mysql_query('SELECT count(distinct(`IP`)) FROM '.HISTORY_TABLE.'    '); 
+        while ($row = mysql_fetch_array($result,MYSQL_ASSOC))   {
+                 array_push($liste_bl,$row);
+                }
+//================ Liste IP ==============
+$req = mysql_query('SELECT count(distinct(`IP`)) FROM '.HISTORY_TABLE.'    ');
 $nbip =  array_pop(mysql_fetch_row($req)) ;
 
-        $query = 'SELECT DISTINCT       H.`id`,
+    $query = 'SELECT DISTINCT   H.`id`,
             H.`date`,
             H.`time`,
             H.`user_id`,
-            H.`IP`, 
-            COUNT(H.`IP`) as total  
-            FROM '.HISTORY_TABLE.'  AS H 
-            WHERE  "'.$ip.'"not LIKE H.`IP`     ';//
-        if (count($liste_bl)>0){
-        $query .= '     AND  H.`IP` not IN ( SELECT `ip`
+            H.`IP`,
+            COUNT(H.`IP`) as total
+            FROM '.HISTORY_TABLE.'  AS H
+            WHERE  "'.$ip.'"not LIKE H.`IP`     ';//
+    if (count($liste_bl)>0){
+    $query .= ' AND  H.`IP` not IN ( SELECT `ip`
     FROM '.MAIL_BLACK_LISTE_TABLE.' ) ';
-        }
- 
-        $query .= '     
-        GROUP by H.`IP` 
-        ORDER by `id` DESC
-        LIMIT '.(int)($params['per_page']*$params['start']).','.(int)$params['per_page'].'      
-        '   ;
+    }
 
-        $result = pwg_query($query);
-        $liste_ip=array();
-        while ($row = mysql_fetch_array($result,MYSQL_ASSOC))   { 
+    $query .= '
+    GROUP by H.`IP`
+    ORDER by `id` DESC
+    LIMIT '.(int)($params['per_page']*$params['start']).','.(int)$params['per_page'].'
+    '   ;
 
-                  array_push($liste_ip, $row);
-                                }
+    $result = pwg_query($query);
+    $liste_ip=array();
+    while ($row = mysql_fetch_array($result,MYSQL_ASSOC))   {
+
+              array_push($liste_ip, $row);
+                }
 
 ?>