Changeset 4143 for extensions/NBC_UserAdvManager/trunk/main.inc.php

Timestamp:

Oct 29, 2009, 2:25:30 AM (15 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager] final coding for release 2.12.0 :

• Improving plugin upgrade process (database auto upgrade from branch 2.10 and 2.11 to new branch 2.12)
• Adding new function (Ghost Tracker - Tracking of ghost users) from bug 1194 : fully functionnal.
• Language files updated for new Ghost Tracker feature.
• Some code improvement.

File:

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

extensions/NBC_UserAdvManager/trunk/main.inc.php

@@ -2 +2 @@
 /*
 Plugin Name: NBC UserAdvManager
-Version: 2.12.0a
+Version: 2.12.0
 Description: Permet de renforcer les possibilités de gestion des utilisateurs - Enforce users management
 Plugin URI: http://fr.piwigo.org/ext/extension_view.php?eid=216
@@ -128 +128 @@
 }
 
+
+add_event_handler('loc_begin_index', 'UserAdvManager_GhostTracker');
+
+function UserAdvManager_GhostTracker()
+{
+  global $conf, $user;
+  
+  $conf_nbc_UserAdvManager = isset($conf['nbc_UserAdvManager']) ? explode(";" , $conf['nbc_UserAdvManager']) : array();
+
+  if (isset($conf_nbc_UserAdvManager[17]) and $conf_nbc_UserAdvManager[17] == 'true' and !is_admin() and !is_a_guest())
+  {
+
+    $userid = get_userid($user['username']);
+          
+    /* Looking for existing entry in last visit table */
+    $query = '
+SELECT *
+FROM '.USER_LASTVISIT_TABLE.'
+WHERE user_id = '.$userid.'
+;';
+        
+    $count = mysql_num_rows(pwg_query($query));
+         
+    if ($count == 0)
+    {
+      /* If not, data are inserted in table */
+      $query = '
+INSERT INTO '.USER_LASTVISIT_TABLE.' (user_id, lastvisit, reminder)
+VALUES ('.$userid.', now(), "false")
+;';
+      pwg_query($query);
+    }
+    else if ($count > 0)
+    {
+      /* If yes, data are updated in table */
+      $query = '
+UPDATE '.USER_LASTVISIT_TABLE.'
+SET lastvisit = now(), reminder = "false"
+WHERE user_id = '.$userid.'
+LIMIT 1
+;';
+      pwg_query($query);
+    }
+  }
+}
 
 
@@ -267 +312 @@
         {
           $query = '
-            SELECT '.$conf['user_fields']['email'].' AS email
-              FROM '.USERS_TABLE.'
-            WHERE '.$conf['user_fields']['id'].' = \''.$user['id'].'\'
-            ;';
+SELECT '.$conf['user_fields']['email'].' AS email
+FROM '.USERS_TABLE.'
+WHERE '.$conf['user_fields']['id'].' = \''.$user['id'].'\'
+;';
           
           list($current_email) = mysql_fetch_row(pwg_query($query));
@@ -282 +327 @@
         {
           $query = '
-            SELECT '.$conf['user_fields']['username'].'
-              FROM '.USERS_TABLE.'
-            WHERE '.$conf['user_fields']['id'].' = \''.$user['id'].'\'
-            ;';
+SELECT '.$conf['user_fields']['username'].'
+FROM '.USERS_TABLE.'
+WHERE '.$conf['user_fields']['id'].' = \''.$user['id'].'\'
+;';
         
           list($username) = mysql_fetch_row(pwg_query($query));