Changeset 4135 for extensions/NBC_UserAdvManager/trunk/maintain.inc.php

Timestamp:

Oct 28, 2009, 3:36:29 PM (15 years ago)

Author:

Eric

Message:

[NBC_UserAdvManager] pre 2.12.0 identified as 2.12.0a :

• Improving plugin upgrade process
• Adding new function (Ghost Tracker - Tracking of ghost users) from bug 1194 : Only admin panel and database requests are coded.
• Language files updated for new Ghost Tracker feature.

File:

• extensions/NBC_UserAdvManager/trunk/maintain.inc.php (modified) (7 diffs)

extensions/NBC_UserAdvManager/trunk/maintain.inc.php

@@ -5 +5 @@
 
 include_once (NBC_UserAdvManager_PATH.'include/constants.php');
+include_once (NBC_UserAdvManager_PATH.'include/functions_UserAdvManager.inc.php');
 
 function plugin_install()
@@ -12 +13 @@
   $q = '
     INSERT INTO '.CONFIG_TABLE.' (param, value, comment)
-    VALUES ("nbc_UserAdvManager","true;false;false;-1;-1;-1;false;false;;-1;;;false;;false;100;false","Parametres du plugin nbc UserAdvManager")
+    VALUES ("nbc_UserAdvManager","true;false;false;-1;-1;-1;false;false;;-1;;;false;;false;100;false,false","Parametres du plugin nbc UserAdvManager")
   ;';
   pwg_query($q);
@@ -37 +38 @@
       status enum('webmaster','admin','normal','generic','guest') default NULL,
       date_check datetime default NULL,
+      lastvisit DATETIME NULL DEFAULT NULL,
+      reminder ENUM('true','false') NULL DEFAULT NULL
       PRIMARY KEY  (id)
+    )
+  ;";
+  pwg_query($q);
+
+        $q = "
+    CREATE TABLE IF NOT EXISTS ".USER_LASTVISIT_TABLE." (
+      user_id SMALLINT(5) NOT NULL DEFAULT '0',
+      lastvisit DATETIME NULL DEFAULT NULL,
+      reminder ENUM('true','false') NULL,
+      PRIMARY KEY (`user_id`)
     )
   ;";
@@ -47 +60 @@
           global $conf;
         
-/* Check for upgrade */
+/* Check for upgrade from 2.10 */
           $query = '
     SELECT *
-                FROM '.CONFIG_TABLE.'
+                  FROM '.CONFIG_TABLE.'
     WHERE param = "nbc_UserAdvManager_ConfirmMail"
   ;';
@@ -60 +73 @@
                 upgrade_210();
         }
+
+/* Check for upgrade from 2.11 */
+  if (!table_exist(USER_LASTVISIT_TABLE))
+  {
+    /* upgrade from branch 2.11 */
+                upgrade_211();
+  }
 }
+
 
 function plugin_uninstall()
@@ -88 +109 @@
   $q = 'DROP TABLE '.USER_CONFIRM_MAIL_TABLE.';';
   pwg_query( $q );
+
+  $q = 'DROP TABLE '.USER_LASTVISIT_TABLE.';';
+  pwg_query( $q );
 }
 
+/* upgrade from branch 2.10 */
 function upgrade_210()
 {
@@ -107 +132 @@
   ;';
   pwg_query($q);
+
+upgrade_211();
+}
+
+/* upgrade from branch 2.11 */
+function upgrade_211()
+{
+        global $conf;
+
+  $conf_nbc_UserAdvManager = isset($conf['nbc_UserAdvManager']) ? explode(";" , $conf['nbc_UserAdvManager']) : array();
+
+  if ((!isset($conf_nbc_UserAdvManager[14]) and !isset($conf_nbc_UserAdvManager[15])) and !isset($conf_nbc_UserAdvManager[16]) and !isset($conf_nbc_UserAdvManager[17]))
+  {
+    $upgrade_nbc_UserAdvManager = $conf_nbc_UserAdvManager[0].';'.$conf_nbc_UserAdvManager[1].';'.$conf_nbc_UserAdvManager[2].';'.$conf_nbc_UserAdvManager[3].';'.$conf_nbc_UserAdvManager[4].';'.$conf_nbc_UserAdvManager[5].';'.$conf_nbc_UserAdvManager[6].';'.$conf_nbc_UserAdvManager[7].';'.$conf_nbc_UserAdvManager[8].';'.$conf_nbc_UserAdvManager[9].';'.$conf_nbc_UserAdvManager[10].';'.$conf_nbc_UserAdvManager[11].';'.$conf_nbc_UserAdvManager[12].';'.$conf_nbc_UserAdvManager[13].';false;100;false;false';
+                
+                $query = '
+                UPDATE '.CONFIG_TABLE.'
+                SET value="'.$upgrade_nbc_UserAdvManager.'"
+                WHERE param="nbc_UserAdvManager"
+                LIMIT 1
+                ;';
+                
+                pwg_query($query);
+  }
+  
+        $q = "
+    CREATE TABLE IF NOT EXISTS ".USER_LASTVISIT_TABLE." (
+      user_id SMALLINT(5) NOT NULL DEFAULT '0',
+      lastvisit DATETIME NULL DEFAULT NULL,
+      reminder ENUM('true','false') NULL,
+      PRIMARY KEY (`user_id`)
+    )
+  ;";
+  pwg_query($q);
 }
 ?>