Changeset 4380 for extensions/NBC_UserAdvManager/trunk/include

Timestamp:

Nov 28, 2009, 12:58:32 PM (14 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager] Pre 2.13

• Evolution 1239 - New option to add a new tab that shows the number of days since their last visit for each registered user.
• Evolution 1273 - Adding of reminder field in advanced user management tab. This allows to see if a reminder have already been send.
• Evolution 1292 - Adding of navigation bar in tabs where users are listed (when more than 1 page is needed to display users).
• Some code and translations refactory.

File:

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

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

@@ -134 +134 @@
         );        
                         }
+
+/* Set reminder true */      
+      $query = "
+UPDATE ".USER_CONFIRM_MAIL_TABLE."
+SET reminder = 'true'
+WHERE user_id = '".$user_id."'
+;";
+      pwg_query($query);
       
                 break;
@@ -146 +154 @@
           $infos1 = get_user_language_desc($conf_nbc_UserAdvManager_ConfirmMail[2])."\n\n";
         }
-        else $infos1 = l10n($conf_nbc_UserAdvManager_ConfirmMail[2])."\n\n";                            
+        else $infos1 = l10n($conf_nbc_UserAdvManager_ConfirmMail[2])."\n\n";
       }
+      
+/* Set reminder true */      
+      $query = "
+UPDATE ".USER_CONFIRM_MAIL_TABLE."
+SET reminder = 'true'
+WHERE user_id = '".$user_id."'
+;";
+      pwg_query($query);
       
     break;
@@ -786 +802 @@
 WHERE (TO_DAYS(NOW()) - TO_DAYS(lv.lastvisit) >= "'.$conf_nbc_UserAdvManager[18].'")
 ORDER BY id ASC;';
+
+        $result = pwg_query($query);
+      
+  while ($row = mysql_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'];
+        }
+
+        return $users;
+}
+
+
+/* Function called from UserAdvManager.php - Get all users to display the number of days since their last visit */
+function get_user_list()
+{
+        global $conf, $page;
+  
+  $users = array();
+
+        /* search users depending expiration date */
+  $query = '
+SELECT DISTINCT u.'.$conf['user_fields']['id'].' AS id,
+                u.'.$conf['user_fields']['username'].' AS username,
+                u.'.$conf['user_fields']['email'].' AS email,
+                ug.lastvisit
+FROM '.USERS_TABLE.' AS u
+  INNER JOIN '.USER_LASTVISIT_TABLE.' AS ug
+    ON u.'.$conf['user_fields']['id'].' = ug.user_id
+WHERE u.'.$conf['user_fields']['id'].' >= 3
+ORDER BY lastvisit DESC
+;';
 
         $result = pwg_query($query);