Changeset 3836 for extensions/NBC_UserAdvManager/trunk/include

Timestamp:

Sep 7, 2009, 10:52:49 PM (15 years ago)

Author:

Eric

Message:

New function : Timelimit for user's validation. When exeeded, users can't validate their registration.

Add of admin settings panel for the new function.

Todo : Unvalidated users management.

File:

• extensions/NBC_UserAdvManager/trunk/include/functions_UserAdvManager.inc.php (modified) (4 diffs)

extensions/NBC_UserAdvManager/trunk/include/functions_UserAdvManager.inc.php

@@ -187 +187 @@
   
   $conf_nbc_UserAdvManager = isset($conf['nbc_UserAdvManager']) ? explode(";" , $conf['nbc_UserAdvManager']) : array();
+  $conf_nbc_UserAdvManager_ConfirmMail = isset($conf['nbc_UserAdvManager_ConfirmMail']) ? explode(";" , $conf['nbc_UserAdvManager_ConfirmMail']) : array();
 
   $query = "
@@ -203 +204 @@
     ;";
     $data = mysql_fetch_array(pwg_query($query));
-    
-    
+        
     if (!empty($data) and isset($data['user_id']) and !isset($data['date_check']))
     {
@@ -213 +213 @@
       ;";
       list($registration_date) = mysql_fetch_row(pwg_query($query));
-  
+
+/*              Time limit process              */
+/* ****************** begin ******************* */  
       if (!empty($registration_date))
       {
-// Time limit process
+                // Verify Confirmmail with time limit ON
+                if (isset ($conf_nbc_UserAdvManager_ConfirmMail[1]))
+                {
+                        // 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 set limit
+                        {
+                                list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+
+                                $query = '
+                                        UPDATE '.USER_CONFIRM_MAIL_TABLE.'
+                                        SET date_check="'.$dbnow.'"
+                                        WHERE id = "'.$id.'"
+                                        ;';
+                                pwg_query($query);
+      
+                                if ( $conf_nbc_UserAdvManager[3] <> -1 )
+                                {
+                                        $query = "
+                                                DELETE FROM ".USER_GROUP_TABLE."
+                                                WHERE user_id = '".$data['user_id']."'
+                                                AND group_id = '".$conf_nbc_UserAdvManager[3]."'
+                                                ;";
+                                        pwg_query($query);
+                                }
+            
+                                if ( $conf_nbc_UserAdvManager[4] <> -1 ) // Change user's group 
+                                {
+                                        $query = "
+                                                DELETE FROM ".USER_GROUP_TABLE."
+                                                WHERE user_id = '".$data['user_id']."'
+                                                AND group_id = '".$conf_nbc_UserAdvManager[4]."'
+                                                ;";
+                                        pwg_query($query);
+        
+                                        $query = "
+                                                INSERT INTO ".USER_GROUP_TABLE."
+                                                        (user_id, group_id)
+                                                VALUES
+                                                        ('".$data['user_id']."', '".$conf_nbc_UserAdvManager[4]."')
+                                                ;";
+                                        pwg_query($query);
+                                }
+
+                                if (($conf_nbc_UserAdvManager[5] <> -1 or isset($data['status']))) // Change user's status
+                                {
+                                        $query = "
+                                                UPDATE ".USER_INFOS_TABLE."
+                                                SET status = '".(isset($data['status']) ? $data['status'] : $conf_nbc_UserAdvManager[5])."'
+                                                WHERE user_id = '".$data['user_id']."'
+                                                ;";
+                                        pwg_query($query);
+                                }
+                        // Refresh user's category cache
+                                invalidate_user_cache();
+  
+                                return true;
+                        }
+                        elseif ($deltadays > $conf_nbc_UserAdvManager_ConfirmMail[1]) // If timelimit exeeds
+                        {
+                                return false;
+                        }
+                }
+                // Verify Confirmmail with time limit OFF
+                else
+                {
+                        list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+
+                        $query = '
+                                UPDATE '.USER_CONFIRM_MAIL_TABLE.'
+                                SET date_check="'.$dbnow.'"
+                                WHERE id = "'.$id.'"
+                                ;';
+                        pwg_query($query);
+      
+                        if ( $conf_nbc_UserAdvManager[3] <> -1 )
+                        {
+                                $query = "
+                                        DELETE FROM ".USER_GROUP_TABLE."
+                                        WHERE user_id = '".$data['user_id']."'
+                                        AND group_id = '".$conf_nbc_UserAdvManager[3]."'
+                                        ;";
+                                pwg_query($query);
+                        }
+    
+                        if ( $conf_nbc_UserAdvManager[4] <> -1 )
+                        {
+                                $query = "
+                                        DELETE FROM ".USER_GROUP_TABLE."
+                                        WHERE user_id = '".$data['user_id']."'
+                                        AND group_id = '".$conf_nbc_UserAdvManager[4]."'
+                                        ;";
+                                pwg_query($query);
+
+                                $query = "
+                                        INSERT INTO ".USER_GROUP_TABLE."
+                                                (user_id, group_id)
+                                        VALUES
+                                                ('".$data['user_id']."', '".$conf_nbc_UserAdvManager[4]."')
+                                        ;";
+                                pwg_query($query);
+                        }
+
+                        if ( ( $conf_nbc_UserAdvManager[5] <> -1 or isset($data['status']) ) )
+                        {
+                                $query = "
+                                        UPDATE ".USER_INFOS_TABLE."
+                                        SET status = '".(isset($data['status']) ? $data['status'] : $conf_nbc_UserAdvManager[5])."'
+                                        WHERE user_id = '".$data['user_id']."'
+                                        ;";
+                                pwg_query($query);
+                        }
+// Refresh user's category cache
+                        invalidate_user_cache();
+  
+                        return true;
+                }
       }
-      
-      list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
-  
+/* ****************** end ******************* */ 
+// Original code without time limit
+/*      list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
+
       $query = '
         UPDATE '.USER_CONFIRM_MAIL_TABLE.'
@@ -268 +398 @@
       invalidate_user_cache();
   
-      return true;
+      return true;*/
     }
   }
   else
     return false;
-  
 }