Changeset 3921 for extensions/NBC_UserAdvManager/branches/2.11/include/functions_UserAdvManager.inc.php

Timestamp:

Sep 27, 2009, 6:24:29 PM (15 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager] Merged from Trunk in Branch 2.11

File:

• extensions/NBC_UserAdvManager/branches/2.11/include/functions_UserAdvManager.inc.php (modified) (2 diffs)

extensions/NBC_UserAdvManager/branches/2.11/include/functions_UserAdvManager.inc.php

@@ -616 +616 @@
   
   $users = array();
-    
+
         /* search users depending expiration date */
   $query = '
-        SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
+                SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
                                                                                 u.'.$conf['user_fields']['username'].' AS username,
-                    u.'.$conf['user_fields']['email'].' AS email,
-                    ui.status,
-                    ui.adviser,
-                    ui.enabled_high,
-                    ui.level,
-                    ui.registration_date,
-                    ug.group_id
+                                                                                u.'.$conf['user_fields']['email'].' AS email,
+                                                                                ui.status,
+                                                                                ui.adviser,
+                                                                                ui.enabled_high,
+                                                                                ui.level,
+                                                                                ui.registration_date
                 FROM '.USERS_TABLE.' AS u
-                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].'"
-                                OR 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
+    LEFT JOIN '.USER_GROUP_TABLE.' AS ug
+      ON u.'.$conf['user_fields']['id'].' = ug.user_id
+                WHERE u.'.$conf['user_fields']['id'].' >= 3
+                AND (TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'"
+                        OR TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) < "'.$conf_nbc_UserAdvManager_ConfirmMail[1].'")';
+
+        if ($conf_nbc_UserAdvManager[3] <> '-1' and $conf_nbc_UserAdvManager[9] == '-1')
+  {
+    $query.= '
+    AND ug.group_id = '.$conf_nbc_UserAdvManager[3];
+  }
+  if ($conf_nbc_UserAdvManager[3] == '-1' and $conf_nbc_UserAdvManager[9] <> '-1')
+  {
+    $query.= '
+    AND ui.status = \''.$conf_nbc_UserAdvManager[9]."'";
+  }
+  if ($conf_nbc_UserAdvManager[3] <> '-1' and $conf_nbc_UserAdvManager[9] <> '-1')
+  {
+    $query.= '
+    AND ug.group_id = \''.$conf_nbc_UserAdvManager[3]."'";
+  }
+  $query.= '
+  ORDER BY id ASC
+;';
 
         $result = pwg_query($query);
@@ -680 +695 @@
         return $users;
 }
+
+/* Function called from UserAdvManager.php - to determine who is expired or not and giving a different display color */
+function expiration($id)
+{
+        global $conf, $page;
+          
+        /* 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(); 
+        
+        $query = "
+        SELECT registration_date
+    FROM ".USER_INFOS_TABLE."
+    WHERE user_id = '".$id."'
+    ;";
+        list($registration_date) = mysql_fetch_row(pwg_query($query));
+
+/*              Time limit process              */
+/* ****************** begin ******************* */  
+        if (!empty($registration_date))
+  {
+                // dates formating and compare
+                $today = date("d-m-Y"); // Get today's date
+                list($day, $month, $year) = explode('-', $today); // explode date of today                                               
+                $daytimestamp = mktime(0, 0, 0, $month, $day, $year);// Generate UNIX timestamp
+                
+          list($regdate, $regtime) = explode(' ', $registration_date); // Explode date and time from registration date
+                list($regyear, $regmonth, $regday) = explode('-', $regdate); // Explode date from registration date
+                $regtimestamp = mktime(0, 0, 0, $regmonth, $regday, $regyear);// Generate UNIX timestamp
+                        
+                $deltasecs = $daytimestamp - $regtimestamp;// Compare the 2 UNIX timestamps     
+                $deltadays = floor($deltasecs / 86400);// Convert result from seconds to days
+
+                // Condition with the value set for time limit
+                if ($deltadays <= $conf_nbc_UserAdvManager_ConfirmMail[1]) // If Nb of days is less than the limit set
+                {
+                        return false;
+                }
+                else
+                {
+                        return True;
+                }
+        }
+}
 ?>