Changeset 7955 for extensions/NBC_UserAdvManager/trunk/include/upgradedb.inc.php

Timestamp:

Nov 30, 2010, 5:24:38 PM (13 years ago)

Author:

Eric

Message:

• Bug 1585 fixed : Adding plugin's version number in #_config table
• Performing old code cleanup
• 1st step to branch 2.16

File:

• extensions/NBC_UserAdvManager/trunk/include/upgradedb.inc.php (modified) (2 diffs)

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

@@ -208 +208 @@
 }
 
-/* upgrade from branch 2.15.3 to 2.15.4 */
-/* ************************************ */
+/* upgrade from 2.15.3 to 2.15.4 */
+/* ***************************** */
 function upgrade_2153_2154()
 {
@@ -267 +267 @@
   pwg_query($query);
 }
+
+/* upgrade from 2.15.9 to 2.16.0 */
+/* ***************************** */
+function upgrade_2159_2160()
+{
+  global $conf;
+
+/* Upgrading options */
+  $query = '
+SELECT value
+  FROM '.CONFIG_TABLE.'
+WHERE param = "UserAdvManager"
+;';
+
+  $result = pwg_query($query);
+  $conf_UAM = pwg_db_fetch_assoc($result);
+    
+  $Newconf_UAM = unserialize($conf_UAM['value']);
+  
+  $Newconf_UAM[22] = 'false';
+  $Newconf_UAM[23] = 'false';
+  $Newconf_UAM[24] = 'false';
+  $Newconf_UAM[25] = 'Sorry, your account has been deleted due to a too long time passed since your last visit.';
+  $Newconf_UAM[26] = 'Sorry, your account has been deprecated due to a too long time passed since your last visit. Please, use the following link to revalidate your account.';
+  
+  $update_conf = serialize($Newconf_UAM);
+    
+  $query = '
+      UPDATE '.CONFIG_TABLE.'
+                        SET value="'.addslashes($update_conf).'"
+                        WHERE param="UserAdvManager"
+                        LIMIT 1
+                ;';
+
+        pwg_query($query);
+
+  // Insert a new config entry for futur plugin's version check
+  $query = '
+INSERT INTO '.CONFIG_TABLE.' (param, value, comment)
+VALUES ("UserAdvManager_Version","2.15.8","UAM version check")
+  ;';
+  
+  pwg_query($query);
+}
 ?>