Changeset 9383 for extensions/PWG_Stuffs/admin/upgrade.inc.php

Timestamp:

Feb 26, 2011, 4:28:24 PM (13 years ago)

Author:

patdenice

Message:

Add display option. Optimizations.

File:

• extensions/PWG_Stuffs/admin/upgrade.inc.php (modified) (2 diffs)

extensions/PWG_Stuffs/admin/upgrade.inc.php

@@ -92 +92 @@
   $query = 'ALTER TABLE ' . $prefixeTable . 'stuffs
 CHANGE `type` `path` VARCHAR( 255 ) NULL DEFAULT NULL,
-ADD `parent` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `path`
+ADD `parent` VARCHAR( 255 ) NULL DEFAULT NULL AFTER `path`,
+ADD `level` TINYINT( 3 ) NOT NULL default "0" AFTER `groups`,
+ADD `on_root` enum(\'true\',\'false\') NOT NULL AFTER `on_home`
+;';
+  pwg_query($query);
+
+  $query = 'UPDATE ' . $prefixeTable . 'stuffs
+SET on_root = "false"
+WHERE on_cats = "false"
 ;';
   pwg_query($query);
@@ -107 +115 @@
 ;';
   pwg_query($query);
+
+  $conf['Stuffs'] = array('level_perm' => false);
+
+  $query = 'SELECT id
+FROM '.$prefixeTable.'stuffs
+WHERE users <> "guest,generic,normal,admin,webmaster"
+;';
+  $ids = array_from_query($query, 'id');
+  $conf['Stuffs']['user_perm'] = !empty($ids);
+
+  $query = 'SELECT id
+FROM '.$prefixeTable.'stuffs
+WHERE groups IS NOT NULL
+;';
+  $ids = array_from_query($query, 'id');
+  $conf['Stuffs']['group_perm'] = !empty($ids);
+
+  $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment)
+VALUES ("PWG_Stuffs" , "'.pwg_db_real_escape_string(serialize($conf['Stuffs'])).'" , "PWG Stuffs configuration");';
+  pwg_query($query);  
 }
 
-$query = '
-UPDATE ' . PLUGINS_TABLE . '
-SET version=\''.STUFFS_VERSION.'\'
-WHERE id=\'PWG_Stuffs\'';
-pwg_query($query);
-
 ?>