Changeset 10707 for extensions/UserAdvManager/branches/2.20/include/upgradedb.inc.php

Timestamp:

04/30/11 21:13:57 (2 years ago)

Author:

Eric

Message:

r10706 merged from trunk to branch 2.20

Files:

• extensions/UserAdvManager/branches/2.20/include/upgradedb.inc.php (modified) (2 diffs)

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

@@ -31 +31 @@
   $plugin =  PluginInfos(UAM_PATH);
   $version = $plugin['version'];
-  
-  // Update plugin version 
+
+  // Update plugin version in #_config table
   $query = '
 UPDATE '.CONFIG_TABLE.'
@@ -41 +41 @@
 
   pwg_query($query);
+
+
+// Check #_plugin table consistency
+// Only useful if a previous version upgrade has not worked correctly (rare case)
+  $query = '
+SELECT version
+  FROM '.PLUGINS_TABLE.'
+WHERE id = "UserAdvManager"
+;';
+  
+  $data = pwg_db_fetch_assoc(pwg_query($query));
+  
+  if (empty($data['version']) or $data['version'] <> $version)
+  {
+    $query = '
+UPDATE '.PLUGINS_TABLE.'
+SET version="'.$version.'"
+WHERE id = "UserAdvManager"
+LIMIT 1
+;';
+
+    pwg_query($query);
+  }
 }