Changeset 4925

Timestamp:

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

Author:

cljosse

Message:

[Mail_supervisor] Fix Bug in SQL

Location:

extensions/Mail_supervisor

Files:

• include/fonctions.php (modified) (3 diffs)
• include/function_test_send.php (modified) (2 diffs)
• language/fr_FR/plugin.lang.php (modified) (1 diff)
• main.inc.php (modified) (1 diff)

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);

extensions/Mail_supervisor/include/function_test_send.php

@@ -75 +75 @@
    
         $args['from'] = $conf_mail['formated_email_webmaster'];
-        
+
       if (function_exists('get_user_language_desc') and isset($message) and $message <> '')
         $message = get_user_language_desc($message)."\n\n";
-      
   
         //==================================================================
@@ -111 +110 @@
                $infos_message .='<br />'.l10n('Sv_no_receiver_available') ;
         }
-        
+
 }
 //===============================================================================================================

extensions/Mail_supervisor/language/fr_FR/plugin.lang.php

@@ -116 +116 @@
 $lang['Sv_message_texte %s %s %s %s'] ='
  %s
-             '. l10n('hello') .'  "%s"  ,
-         %s
-            '. l10n('See you soon.') .' 
-              %s
+         '. l10n('hello') .'  "%s"  ,
+  %s
+         '. l10n('See you soon.') .'  %s
           '; 
 ?>

extensions/Mail_supervisor/main.inc.php

@@ -2 +2 @@
 /*
 Plugin Name: Mail supervisor
-Version: 1.3.5
+Version: 1.3.6
 Description: Mail supervisor surveille l'envoie des mails.
 Plugin URI: http://piwigo.org/ext/extension_view.php?eid=315