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

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/maintain.inc.php (modified) (6 diffs)

extensions/NBC_UserAdvManager/trunk/maintain.inc.php

@@ -46 +46 @@
   status enum('webmaster','admin','normal','generic','guest') default NULL,
   date_check datetime default NULL,
+  reminder ENUM('true','false') NULL,
 PRIMARY KEY  (id)
   )
@@ -66 +67 @@
           global $conf;
         
-/* Check for upgrade from 2.10 */
+/* Check for upgrade from 2.10 to 2.11 */
           $query = '
 SELECT *
@@ -74 +75 @@
   $count = mysql_num_rows(pwg_query($query)); 
   
-  /* upgrade from branch 2.10 */
         if ($count == 0)
         {
+         /* upgrade from branch 2.10 to 2.11 */
                 upgrade_210();
         }
 
-/* Check for upgrade from 2.11 */
+
+/* Check for upgrade from 2.11 to 2.12 */
   if (!table_exist(USER_LASTVISIT_TABLE))
   {
-    /* upgrade from branch 2.11 */
+    /* upgrade from branch 2.11 to 2.12 */
                 upgrade_211();
+  }
+
+
+/* Check for upgrade from 2.12 to 2.13 */
+  $query = '
+SELECT *
+FROM '.USER_CONFIRM_MAIL_TABLE.'
+;';
+
+  $result = pwg_query($query);
+        
+        $numfields = mysql_num_fields($result);
+
+  if ($numfields < 6)
+  {
+    /* upgrade from branch 2.12 to 2.13 */
+    upgrade_212();
   }
 }
@@ -120 +139 @@
 }
 
-/* upgrade from branch 2.10 */
+
+/* upgrade from branch 2.10 to 2.11 */
 function upgrade_210()
 {
@@ -139 +159 @@
   pwg_query($q);
 
-upgrade_211();
-}
-
-/* upgrade from branch 2.11 */
+  upgrade_211();
+}
+
+
+/* upgrade from branch 2.11 to 2.12 */
 function upgrade_211()
 {
@@ -179 +200 @@
 ;";
   pwg_query($q);
+
+  upgrade_212();
+}
+
+
+/* upgrade from branch 2.12 to 2.13 */
+function upgrade_212()
+{
+/* Create missing table */
+  $query = "
+ALTER TABLE ".USER_CONFIRM_MAIL_TABLE."
+ADD reminder ENUM('true', 'false') NULL DEFAULT NULL
+;";
+  
+  pwg_query($query);
+
+/* Upgrade plugin configuration */
+        global $conf;
+
+  $conf_nbc_UserAdvManager = isset($conf['nbc_UserAdvManager']) ? explode(";" , $conf['nbc_UserAdvManager']) : array();
+
+  if ((!isset($conf_nbc_UserAdvManager[20])))
+  {
+    $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].';'.$conf_nbc_UserAdvManager[14].';'.$conf_nbc_UserAdvManager[15].';'.$conf_nbc_UserAdvManager[16].';'.$conf_nbc_UserAdvManager[17].';'.$conf_nbc_UserAdvManager[18].';'.$conf_nbc_UserAdvManager[19].';false';
+                
+                $query = '
+UPDATE '.CONFIG_TABLE.'
+SET value="'.$upgrade_nbc_UserAdvManager.'"
+WHERE param="nbc_UserAdvManager"
+LIMIT 1
+;';
+                pwg_query($query);
+  }
 }
 ?>