Changeset 9266 for extensions/NBC_UserAdvManager/trunk/include/functions.inc.php

Timestamp:

Feb 17, 2011, 6:16:36 PM (13 years ago)

Author:

Eric

Message:

bug 2055 fixed : New automated task for unvalidated registers (auto email reminder sent and auto deletion if already reminded).
Localisation files cleanup : all keys for "enable" and "disable" options have been replaced by one unic key.

File:

• extensions/NBC_UserAdvManager/trunk/include/functions.inc.php (modified) (8 diffs)

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

@@ -328 +328 @@
   }
 
+  // Performing User validation scheduled tasks
+  if ((isset($conf_UAM[31]) and $conf_UAM[31] == 'true'))
+  {
+    UAM_USR_ScheduledTasks();
+  }
+
   if ((isset($conf_UAM[21]) and $conf_UAM[21] == 'true'))
   {
@@ -401 +407 @@
         }
 
-        // If never reminded before, set reminder True
-        if ($reminder) // If user already reminded for ghost account
+        // If user already reminded for ghost account
+        if ($reminder)
         {
           // delete account
@@ -410 +416 @@
           invalidate_user_cache();
           logout_user();
-          redirect(UAM_PATH.'del_account.php');
+          redirect(UAM_PATH.'GT_del_account.php');
         }
         }
@@ -523 +529 @@
   }
 }
+
+/**
+ * Triggered on UAM_LoginTasks()
+ * 
+ * Executes optional post-login tasks for unvalidated users
+ * 
+ */
+function UAM_USR_ScheduledTasks()
+{
+  global $conf, $user, $page;
+
+  if (!defined('PHPWG_ROOT_PATH'))
+  {
+    die('Hacking attempt!');
+  }
+          
+  include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');
+
+  $conf_UAM = unserialize($conf['UserAdvManager']);
+  
+  $collection = array();
+  $reminder = false;
+  
+  $page['filtered_users'] = get_unvalid_user_autotasks();
+
+  foreach($page['filtered_users'] as $listed_user)
+  {
+    array_push($collection, $listed_user['id']);
+  }
+
+  // Unvalidated accounts auto email sending and autodeletion if user already reminded
+  if ((isset($conf_UAM[31]) and $conf_UAM[31] == 'true'))
+  {
+    if (count($collection) > 0)
+        {
+      // Process if a non-admin nor webmaster user is logged
+      if (in_array($user['id'], $collection))
+        {
+        // Check ConfirmMail reminder state
+        $query = '
+SELECT reminder
+FROM '.USER_CONFIRM_MAIL_TABLE.'
+WHERE user_id = '.$user['id'].';';
+
+        $result = pwg_db_fetch_assoc(pwg_query($query));
+
+        if (isset($result['reminder']) and $result['reminder'] == 'true')
+        {
+          $reminder = true;
+        }
+        else
+        {
+          $reminder = false;
+        }
+
+        // If never reminded before, send reminder and set reminder True
+        if (!$reminder and isset($conf_UAM[33]) and $conf_UAM[33] == 'true')
+        {
+                  $typemail = 1;
+          
+          // Get current user informations
+          $query = "
+SELECT id, username, mail_address
+FROM ".USERS_TABLE."
+WHERE id = '".$user['id']."'
+;";
+          $data = pwg_db_fetch_assoc(pwg_query($query));
+
+          ResendMail2User($typemail,$user['id'],stripslashes($data['username']),$data['mail_address'],true);
+        }
+
+        // If already reminded before, delete user
+        if ($reminder)
+        {
+          // delete account
+          delete_user($user['id']);
+
+          // Logged-in user cleanup, session destruction and redirected to custom page
+          invalidate_user_cache();
+          logout_user();
+          redirect(UAM_PATH.'USR_del_account.php');
+        }
+        }
+      else // Process if an admin or webmaster user is logged
+      {
+        foreach ($collection as $user_id)
+        {
+          // Check reminder state
+          $query = '
+SELECT reminder
+FROM '.USER_CONFIRM_MAIL_TABLE.'
+WHERE user_id = '.$user_id.';';
+
+          $result = pwg_db_fetch_assoc(pwg_query($query));
+
+          if (isset($result['reminder']) and $result['reminder'] == 'true')
+          {
+            $reminder = true;
+          }
+          else
+          {
+            $reminder = false;
+          }
+
+          // If never reminded before, send reminder and set reminder True
+          if (!$reminder and isset($conf_UAM[33]) and $conf_UAM[33] == 'true')
+          {
+            $typemail = 1;
+          
+            // Get current user informations
+            $query = "
+SELECT id, username, mail_address
+FROM ".USERS_TABLE."
+WHERE id = '".$user_id."'
+;";
+            $data = pwg_db_fetch_assoc(pwg_query($query));
+
+            ResendMail2User($typemail,$user_id,stripslashes($data['username']),$data['mail_address'],true);
+          }
+          elseif ($reminder) // If user already reminded for account validation
+          {
+            // delete account
+            delete_user($user_id);
+          }
+        }
+      }
+    }
+  }
+}
+
 
 /**
@@ -1441 +1577 @@
 ;";
     $data = pwg_db_fetch_assoc(pwg_query($query));
-        
-    //if (!empty($data) and isset($data['user_id']) and !isset($data['date_check']))
+
     if (!empty($data) and isset($data['user_id']))
     {
@@ -1478 +1613 @@
                                                 $query = '
 UPDATE '.USER_CONFIRM_MAIL_TABLE.'
-SET date_check="'.$dbnow.'"
+SET date_check="'.$dbnow.'", reminder="false"
 WHERE id = "'.$id.'"
 ;';
@@ -1850 +1985 @@
 
 /**
+ * Function called from functions.inc.php - Get all users who haven't validate their registration in configured time
+ * to delete or remail them automatically
+ * 
+ * @return : List of users
+ * 
+ */
+function get_unvalid_user_autotasks()
+{
+        global $conf, $page;
+          
+        // Get ConfirmMail configuration
+  $conf_UAM_ConfirmMail = unserialize($conf['UserAdvManager_ConfirmMail']);
+  
+  $users = array();
+
+        // search users depending expiration date
+  $query = '
+SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
+                ui.registration_date
+FROM '.USERS_TABLE.' AS u
+  INNER JOIN '.USER_INFOS_TABLE.' AS ui
+    ON u.'.$conf['user_fields']['id'].' = ui.user_id
+WHERE u.'.$conf['user_fields']['id'].' >= 3
+  AND (TO_DAYS(NOW()) - TO_DAYS(ui.registration_date) >= "'.$conf_UAM_ConfirmMail[1].'")
+ORDER BY ui.registration_date ASC;';
+
+        $result = pwg_query($query);
+      
+  while ($row = pwg_db_fetch_assoc($result))
+  {
+    array_push($users, $row);
+        }
+
+        return $users;
+}
+
+/**
  * Function called from UAM_admin.php - Get ghost users
  * 
@@ -1925 +2097 @@
   while ($row = pwg_db_fetch_assoc($result))
   {
-        $user = $row;
-    $user['groups'] = array();
-
-    array_push($users, $user);
-        }
-
-        // add group lists
-  $user_ids = array();
-  foreach ($users as $i => $user)
-  {
-        $user_ids[$i] = $user['id'];
+    array_push($users, $row);
         }