Changeset 3826 for extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php

Timestamp:

Sep 5, 2009, 11:37:48 PM (15 years ago)

Author:

Eric

Message:

• Code cleaning : Deletion of old commented parts, PHP 5.3 improvement, HTML compliant for tpl files
• Implementing a monitoring system for using the mail() function (spy log file)
• Finalization of listing table of unvalidated registered
• Preview of upcoming features (coding of management panel)

File:

• extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php (modified) (2 diffs)

extensions/NBC_UserAdvManager/trunk/admin/UserAdvManager_admin.php

@@ -329 +329 @@
         {
           global $conf, $page;
-  
-          $conf_nbc_UserAdvManager_ConfirmMail = isset($conf['nbc_UserAdvManager_ConfirmMail']) ? explode(";" , $conf['nbc_UserAdvManager_ConfirmMail']) : array();  
+          
+                /* Get ConfirmMail configuration */
+          $conf_nbc_UserAdvManager_ConfirmMail = isset($conf['nbc_UserAdvManager_ConfirmMail']) ? explode(";" , $conf['nbc_UserAdvManager_ConfirmMail']) : array();
+          
+                /* Get UserAdvManager configuration */
+                  $conf_nbc_UserAdvManager = isset($conf['nbc_UserAdvManager']) ? explode(";" , $conf['nbc_UserAdvManager']) : array();  
   
           $users = array();
     
-/* search users depending on filters and order */
-//TODO:Adding condition in request [if user in USER_CONFIRM_MAIL_TABLE]
+/* search users depending expiration date */
           $query = '
             SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
@@ -344 +347 @@
                             ui.enabled_high,
                             ui.level,
-                            ui.registration_date
+                            ui.registration_date,
+                            ug.group_id
             FROM '.USERS_TABLE.' AS u
-            INNER JOIN '.USER_INFOS_TABLE.' AS ui
-              ON u.'.$conf['user_fields']['id'].' = ui.user_id
-            LEFT JOIN '.USER_GROUP_TABLE.' AS ug
-              ON u.'.$conf['user_fields']['id'].' = ug.user_id
-            WHERE u.'.$conf['user_fields']['id'].' > 0
-            AND TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= '.$conf_nbc_UserAdvManager_ConfirmMail[1].'
-            ORDER BY id ASC
+                INNER JOIN '.USER_INFOS_TABLE.' AS ui
+                        ON u.'.$conf['user_fields']['id'].' = ui.user_id
+                INNER JOIN '.USER_GROUP_TABLE.' AS ug
+                        ON u.'.$conf['user_fields']['id'].' = ug.user_id
+                WHERE u.'.$conf['user_fields']['id'].' >= 0
+                                AND ug.group_id = "'.$conf_nbc_UserAdvManager[3].'"
+                        AND TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) <= "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'"
+                        ORDER BY id ASC
           ;';