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

Timestamp:

02/09/11 21:35:46 (2 years ago)

Author:

Eric

Message:

Bug 1666 fixed : New option to add a customized text in email sent when users lost their password

Files:

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

extensions/NBC_UserAdvManager/trunk/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);
+}
 ?>