Changeset 4229 for extensions/Mail_supervisor/include/fonctions.php

Timestamp:

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

Author:

cljosse

Message:

[mail_supervisor] Addition of jocker in spammers

File:

• extensions/Mail_supervisor/include/fonctions.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 );     
+                                }
         //================================================================================