Changeset 2815 for trunk

Timestamp:

Nov 1, 2008, 10:19:20 PM (16 years ago)

Author:

patdenice

Message:

• bugs correction in upgrade_1.7.0.php.
• only non-standard plugins are deactivated during upgrade.

Location:

trunk

Files:

• admin/include/functions_upgrade.php (modified) (1 diff)
• install/upgrade_1.7.0.php (modified) (3 diffs)
• upgrade.php (modified) (1 diff)

trunk/admin/include/functions_upgrade.php

@@ -95 +95 @@
 }
 
+// Deactivate all non-standard plugins
+function deactivate_non_standard_plugins()
+{
+  global $page;
+
+  $standard_plugins = array(
+    'add_index',
+    'admin_advices',
+    'admin_multi_view',
+    'c13y_upgrade',
+    'event_tracer',
+    'language_switch',
+    'LocalFilesEditor'
+    );
+
+  $query = '
+SELECT id
+FROM '.PREFIX_TABLE.'plugins
+WHERE state = "active"
+AND id NOT IN ("' . implode('","', $standard_plugins) . '")
+;';
+
+  $result = pwg_query($query);
+  $plugins = array();
+  while ($row = mysql_fetch_assoc($result))
+  {
+    array_push($plugins, $row['id']);
+  }
+
+  if (!empty($plugins))
+  {
+    $query = '
+UPDATE '.PREFIX_TABLE.'plugins
+SET state="inactive"
+WHERE id IN ("' . implode('","', $plugins) . '")
+;';
+    mysql_query($query);
+
+    array_push(
+      $page['infos'],
+      'As a precaution, following plugins have been deactivated. You must check for plugins upgrade before reactiving them:
+<pre>' . implode(', ', $plugins) . '</pre>'
+      );
+  }
+}
+
 ?>

trunk/install/upgrade_1.7.0.php

@@ -34 +34 @@
 }
 
-define('PREFIX_TABLE', $prefixeTable);
 define('UPGRADES_PATH', PHPWG_ROOT_PATH.'install/db');
 
@@ -69 +68 @@
       'id' => $upgrade_id,
       'applied' => CURRENT_DATE,
-      'description' => '[migration from 1.7.0 to '.RELEASE.'] not applied',
+      'description' => '[migration from 1.7.0 to '.PHPWG_VERSION.'] not applied',
       )
     );
 }
-mass_inserts(
-  '`'.UPGRADE_TABLE.'`',
-  array_keys($inserts[0]),
-  $inserts
-  );
+
+if (!empty($inserts))
+{
+  mass_inserts(
+    '`'.UPGRADE_TABLE.'`',
+    array_keys($inserts[0]),
+    $inserts
+    );
+}
 
 // +-----------------------------------------------------------------------+
@@ -107 +110 @@
   (id, applied, description)
   VALUES
-  (\''.$upgrade_id.'\', NOW(), \'[migration from 1.7.0 to '.RELEASE.'] '.$upgrade_description.'\')
+  (\''.$upgrade_id.'\', NOW(), \'[migration from 1.7.0 to '.PHPWG_VERSION.'] '.$upgrade_description.'\')
 ;';
   pwg_query($query);

trunk/upgrade.php

@@ -238 +238 @@
     if (in_array(PREFIX_TABLE.'plugins', $tables))
     {
-      $query = '
-UPDATE '.PREFIX_TABLE.'plugins SET state="inactive" WHERE state="active"
-;';
-      mysql_query($query);
-
-      if (mysql_affected_rows() > 0)
-      {
-        array_push(
-          $page['infos'],
-          'As a precaution, all activated plugins have been deactivated.
-You must check for plugins upgrade before reactiving them.'
-        );
-      }
+      deactivate_non_standard_plugins();
     }