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

Timestamp:

Feb 21, 2010, 10:34:04 AM (14 years ago)

Author:

cljosse

Message:

[Mail_supervisor] Fix Bug in SQL

File:

• extensions/Mail_supervisor/include/fonctions.php (modified) (3 diffs)

extensions/Mail_supervisor/include/fonctions.php

@@ -519 +519 @@
      $query = "
                 SELECT `id` , COUNT(`id`) as total 
-                FROM `".$nom_table."` 
+                FROM `".$nom_table."` GROUP by  `id`
                 ;";     
           list($count) = mysql_fetch_row(pwg_query($query));
@@ -751 +751 @@
                 FROM `".MAIL_BLACK_LISTE_TABLE."` 
                     WHERE '".$ip."' LIKE `ip` 
+                        GROUP by `ip` 
                 ;";     
                  $result = @pwg_query($query);
@@ -825 +826 @@
                 FROM `".MAIL_BLACK_LISTE_TABLE."` 
                     WHERE '".$ip."' = `ip` 
+                        GROUP by `ip` 
                 ;";     
                  $result = @pwg_query($query);