Changeset 9310 for extensions/AdditionalPages/admin/upgrade.inc.php

Timestamp:

Feb 19, 2011, 11:13:22 PM (13 years ago)

Author:

patdenice

Message:

Lot of optimization.
Add privacy level management.

File:

• extensions/AdditionalPages/admin/upgrade.inc.php (moved) (moved from extensions/AdditionalPages/admin/upgrade_from_21.php) (3 diffs)

extensions/AdditionalPages/admin/upgrade.inc.php

@@ -5 +5 @@
 global $prefixeTable, $conf;
 
-load_conf_from_db('param = "additional_pages"');
-$old_conf = explode ("," , $conf['additional_pages']);
+$query = 'SHOW FULL COLUMNS FROM ' . $prefixeTable . 'additionalpages;';
+$result = array_from_query($query, 'Collation');
+if (strpos($result[4], 'utf8') === false)
+{
+  $query = 'ALTER TABLE ' . $prefixeTable . 'additionalpages
+MODIFY COLUMN lang varchar(255) CHARACTER SET utf8 NOT NULL,
+MODIFY COLUMN title varchar(255) CHARACTER SET utf8 NOT NULL,
+MODIFY COLUMN text longtext CHARACTER SET utf8 NOT NULL,
+DEFAULT CHARACTER SET utf8;';
 
-$query = 'ALTER TABLE ' . $prefixeTable . 'additionalpages
+  pwg_query($query);
+}
+
+if ($conf['additional_pages'] === false)
+{
+  load_conf_from_db('param = "additional_pages"');
+  $old_conf = explode ("," , $conf['additional_pages']);
+
+  $query = '
+ALTER TABLE ' . $prefixeTable . 'additionalpages
 CHANGE `id` `id` SMALLINT( 5 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
 CHANGE `pos` `pos` SMALLINT( 5 ) NULL DEFAULT NULL ,
@@ -17 +33 @@
 ADD `permalink` VARCHAR( 64 ) NULL DEFAULT NULL ,
 ADD `standalone` ENUM( "true", "false" ) NOT NULL DEFAULT "false";';
-pwg_query($query);
+  pwg_query($query);
 
-$query = '
+  $query = '
 SELECT id, pos, title, lang
 FROM '.$prefixeTable.'additionalpages
 ORDER BY pos ASC
 ;';
-$result = pwg_query($query);
-while ($row = mysql_fetch_assoc($result))
-{
-  $title = $row['title'];
-  $authorized_users = 'NULL';
-  $authorized_groups = 'NULL';
+  $result = pwg_query($query);
+  while ($row = pwg_db_fetch_assoc($result))
+  {
+    $title = $row['title'];
+    $authorized_users = 'NULL';
+    $authorized_groups = 'NULL';
 
-  if ($old_conf[7] == 'on' and strpos($title , '/user_id='))
-  {
-    $array = explode('/user_id=' , $title);
-    $title = $array[0];
-    $authorized_users = !empty($array[1]) ? '"'.$array[1].'"' : '"admin"';
-  }
-  if ($old_conf[6] == 'on' and strpos($title , '/group_id='))
-  {
-    $array = explode('/group_id=' , $title);
-    $title = $array[0];
-    $authorized_groups = !empty($array[1]) ? '"'.$array[1].'"' : 'NULL';
-  }
+    if ($old_conf[7] == 'on' and strpos($title , '/user_id='))
+    {
+      $array = explode('/user_id=' , $title);
+      $title = $array[0];
+      $authorized_users = !empty($array[1]) ? '"'.$array[1].'"' : '"admin"';
+    }
+    if ($old_conf[6] == 'on' and strpos($title , '/group_id='))
+    {
+      $array = explode('/group_id=' , $title);
+      $title = $array[0];
+      $authorized_groups = !empty($array[1]) ? '"'.$array[1].'"' : 'NULL';
+    }
 
-  $position = $row['pos'];
-  if ($row['pos'] === '0')
-    $position = '-100';
-  elseif (empty($row['pos']))
-    $position = '0';
+    $position = $row['pos'];
+    if ($row['pos'] === '0')
+      $position = '-100';
+    elseif (empty($row['pos']))
+      $position = '0';
 
-  $language = $row['lang'] != 'ALL' ? '"'.$row['lang'].'"' : 'NULL';
+    $language = $row['lang'] != 'ALL' ? '"'.$row['lang'].'"' : 'NULL';
 
-  $query = '
+    $query = '
 UPDATE '.$prefixeTable.'additionalpages
 SET title = "'.addslashes($title).'",
@@ -61 +77 @@
 WHERE id = '.$row['id'].'
 ;';
-  pwg_query($query);
+    pwg_query($query);
+  }
+
+  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(
+    'show_home' => @($old_conf[2] == 'on'),
+    'group_perm' => @($old_conf[6] == 'on'),
+    'user_perm' => @($old_conf[7] == 'on'),
+    'homepage' => null,
+    );
+
+  $languages = explode('/', $old_conf[0]);
+  $new_conf['languages'] = array();
+  foreach($languages as $language)
+  {
+    $array = explode(':', $language);
+    if (!isset($array[1])) $new_conf['languages']['default'] = $array[0];
+    else $new_conf['languages'][$array[0]] = $array[1];
+  }
+
+  $conf['additional_pages'] = $new_conf;
+
+  conf_update_param('additional_pages', pwg_db_real_escape_string(serialize($new_conf)));
 }
 
-if ($old_conf[1] == 'off')
+if (!isset($conf['additional_pages']['level_perm']))
 {
-  $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)));
+  $query = '
+ALTER TABLE ' . $prefixeTable . 'additionalpages
+ADD `level` TINYINT( 3 ) UNSIGNED NOT NULL DEFAULT "0" AFTER `groups`
+;';
+  pwg_query($query);
+
+  $query = '
+UPDATE ' . $prefixeTable . 'additionalpages
+SET users = CONCAT( users, ",admin,webmaster" )
+WHERE users IS NOT NULL
+;';
+  pwg_query($query);
+
+  $conf['additional_pages']['level_perm'] = false;
+
+  conf_update_param('additional_pages', pwg_db_real_escape_string(serialize($conf['additional_pages'])));
 }
 
-$new_conf = array(
-  'show_home' => @($old_conf[2] == 'on'),
-  'group_perm' => @($old_conf[6] == 'on'),
-  'user_perm' => @($old_conf[7] == 'on'),
-  'homepage' => null,
-  );
-
-$languages = explode('/', $old_conf[0]);
-$new_conf['languages'] = array();
-foreach($languages as $language)
-{
-  $array = explode(':', $language);
-  if (!isset($array[1])) $new_conf['languages']['default'] = $array[0];
-  else $new_conf['languages'][$array[0]] = $array[1];
-}
-
-$conf['additional_pages'] = $new_conf;
-
-conf_update_param('additional_pages', pwg_db_real_escape_string(serialize($new_conf)));
-
 ?>