Changeset 9136 for extensions/NBC_UserAdvManager/branches/2.20/include/upgradedb.inc.php

Timestamp:

Feb 9, 2011, 9:39:22 PM (13 years ago)

Author:

Eric

Message:

Bug 1666 merged from trunk to branch 2.20

File:

• extensions/NBC_UserAdvManager/branches/2.20/include/upgradedb.inc.php (modified) (1 diff)

extensions/NBC_UserAdvManager/branches/2.20/include/upgradedb.inc.php

@@ -312 +312 @@
   pwg_query($query);
 }
+
+
+/* upgrade from 2.16.x to 2.20.0 */
+/* ***************************** */
+function upgrade_216_220()
+{
+  global $conf;
+
+  $uam_new_version = "2.20.0";
+
+  // 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[29] = 'false';
+  $Newconf_UAM[30] = 'You have requested a password reset on our gallery. Please, find below your new connection settings.';
+  
+  $update_conf = serialize($Newconf_UAM);
+    
+  $query = '
+UPDATE '.CONFIG_TABLE.'
+SET value="'.addslashes($update_conf).'"
+WHERE param="UserAdvManager"
+LIMIT 1
+;';
+
+        pwg_query($query);
+
+  // Update plugin version 
+  $query = '
+UPDATE '.CONFIG_TABLE.'
+SET value="'.$uam_new_version.'"
+WHERE param="UserAdvManager_Version"
+LIMIT 1
+;';
+  
+  pwg_query($query);
+}
 ?>