Changeset 4229 for extensions/Mail_supervisor/include

Timestamp:

Nov 8, 2009, 5:38:51 PM (14 years ago)

Author:

cljosse

Message:

[mail_supervisor] Addition of jocker in spammers

Location:

extensions/Mail_supervisor/include

Files:

• fonctions.php (modified) (4 diffs)
• save_info.php (modified) (4 diffs)

extensions/Mail_supervisor/include/fonctions.php

@@ -595 +595 @@
                 SELECT ".$champs.",COUNT(`id`) as total 
                 FROM `".MAIL_BLACK_LISTE_TABLE."` 
-                    WHERE `ip` LIKE '".$ip."'
+                    WHERE '".$ip."' LIKE `ip` 
                 ;";     
                  $result = @pwg_query($query);
@@ -603 +603 @@
                                         $result = @pwg_query($query);
                                         }
-         $datas = mysql_fetch_array($result,MYSQL_ASSOC);
-
+            $datas = mysql_fetch_array($result,MYSQL_ASSOC);
                  $nb = $datas['total']; 
+                 
 if ($mails_options[5] == 'on')
 {
@@ -635 +635 @@
         if (  $nb > 0 )
         {
-            $erreur_message .= $ip . ' | ' . $pays . ' | ' . $region . ' | ' . $ville . ' ==> ';
+               $query = "
+                SELECT ".$champs.",COUNT(`id`) as total 
+                FROM `".MAIL_BLACK_LISTE_TABLE."` 
+                    WHERE '".$ip."' = `ip` 
+                ;";     
+                 $result = @pwg_query($query);
+ 
+        if (!$result) {
+                                        vérif_base();
+                                        $result = @pwg_query($query);
+                                        }
+            $datas = mysql_fetch_array($result,MYSQL_ASSOC);
+                 $nb = $datas['total']; 
+                 
             $row  = mysql_fetch_row(pwg_query($query));
-            $nb =  ($row[7])+1;
+            $nb =  ($row[7]);
+      $erreur_message .= $ip . ' | ' . $pays . ' | ' . $region . ' | ' . $ville . ' ' . $nb . ' ==> ';  
+  
+         if ($nb == 0)
+                 {
+                        $valeurs=array( 'NULL',
+                            "'".$ip."'",
+                                        "'".$pays."'",
+                                        "'".$region."'",        
+                                        "'".$ville."'",
+                                        '"adresse"',
+                                        '"fai" ',
+                                        1
+              );
+                  ajout_ligne(MAIL_BLACK_LISTE_TABLE,$superv_bl_champs, $valeurs,true) ;        
+                 
+                 } else {
+                  $nb += 1;
          $query ="
                         UPDATE " . MAIL_BLACK_LISTE_TABLE . " 
@@ -649 +679 @@
                  $query .= "            
                         `nb` = " . $nb . "
-                          WHERE ip = '". $ip ."' ;
+                    WHERE '".$ip."' = `ip` 
                 ";
-                                pwg_query($query );
+                
+                                pwg_query($query );     
+                                }
         //================================================================================      
                 

extensions/Mail_supervisor/include/save_info.php

@@ -15 +15 @@
 
   case  'ajout' :
+  
+ $ip_black=str_replace("*","%",$ip_black);
  
 
@@ -21 +23 @@
                 SELECT `ip` 
                 FROM `".MAIL_BLACK_LISTE_TABLE."` 
-                    WHERE ip = '".$ip_black."'
+                    WHERE  '".$ip_black."' LIKE ip 
                 ;";     
-//==============================================================================                
-list($count) = mysql_fetch_row(pwg_query($query));
-//==============================================================================        
+        //==============================================================================                
+        list($count) = mysql_fetch_row(pwg_query($query));
+        //==============================================================================        
         $valeurs=array( 'NULL',
                             "'".$ip_black."'",
@@ -42 +44 @@
   case 'raz':
         $ip_black=str_replace('*',"%",$ip_black);
-                $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip` like '%".$ip_black."%'  ";
+                $query = "DELETE FROM `".MAIL_BLACK_LISTE_TABLE."` WHERE `ip`  like '%".$ip_black."%' ";
                         pwg_query($query);
    break;
@@ -74 +76 @@
         COUNT(H.`IP`) as total  
     FROM '.HISTORY_TABLE.'  AS H 
-        WHERE H.`IP` not LIKE "'.$_SERVER['REMOTE_ADDR'].'"
+        WHERE  "'.$_SERVER['REMOTE_ADDR'].'"not LIKE H.`IP` 
         ';//
         if (count($liste_bl)>0)