Changeset 9272 for extensions/AdditionalPages/admin/upgrade_from_21.php

Timestamp:

02/18/11 11:53:06 (2 years ago)

Author:

patdenice

Message:

New functionalities

Files:

• extensions/AdditionalPages/admin/upgrade_from_21.php (modified) (4 diffs)

extensions/AdditionalPages/admin/upgrade_from_21.php

@@ -19 +19 @@
 SELECT id, pos, title, lang
 FROM '.$prefixeTable.'additionalpages
-ORDER BY pos ASC, id ASC
+ORDER BY pos ASC
 ;';
 $result = pwg_query($query);
@@ -43 +43 @@
   $position = $row['pos'];
   if ($row['pos'] === '0')
-    $position = '-1';
+    $position = '-100';
   elseif (empty($row['pos']))
     $position = '0';
@@ -61 +61 @@
 }
 
+load_conf_from_db('param = "additional_pages"');
 $old_conf = explode ("," , $conf['additional_pages']);
+
+if ($old_conf[1] == 'off')
+{
+  $mb_conf = @unserialize($conf['blk_menubar']);
+  if (!isset($mb_conf['mbAdditionalPages']))
+  {
+    $last = @abs(end($mb_conf));
+    $mb_conf['mbAdditionalPages'] = $last + 50;
+  }
+  $mb_conf['mbAdditionalPages'] = -1 * abs($mb_conf['mbAdditionalPages']);
+  conf_update_param('blk_menubar', pwg_db_real_escape_string(serialize($mb_conf)));
+}
 
 $new_conf = array(
@@ -81 +94 @@
 $conf['additional_pages'] = $new_conf;
 
-$query = '
-UPDATE '.CONFIG_TABLE.'
-SET value = "'.addslashes(serialize($new_conf)).'"
-WHERE param = "additional_pages"
-;';
-pwg_query($query);
+conf_update_param('additional_pages', pwg_db_real_escape_string(serialize($new_conf)));
 
 ?>