Changeset 16937 for extensions/header_manager/maintain.inc.php

Timestamp:

Jul 23, 2012, 4:41:12 PM (12 years ago)

Author:

mistic100

Message:

ability to define a specific banner for an album + apply to sub-cats
(needs Piwigo 2.4.2 for tabs)

File:

• extensions/header_manager/maintain.inc.php (modified) (3 diffs)

extensions/header_manager/maintain.inc.php

@@ -2 +2 @@
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
-define('HEADER_MANAGER_DIR', PWG_LOCAL_DIR . 'banners/');
+define('header_dir', PWG_LOCAL_DIR . 'banners/');
 
 define(
@@ -17 +17 @@
 function plugin_install() 
 {
+  global $prefixeTable;
+  
+        pwg_query(
+'CREATE TABLE IF NOT EXISTS `' .$prefixeTable . 'category_banner` (
+  `category_id` smallint(5) unsigned NOT NULL,
+  `image` varchar(255) NOT NULL,
+  `deep` tinyint(1) DEFAULT 1,
+  PRIMARY KEY (`category_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8
+;');
+
   conf_update_param('header_manager', header_manager_default_config);
-  mkdir(HEADER_MANAGER_DIR, 0755);
+  mkdir(header_dir, 0755);
 }
 
 function plugin_activate()
 {
-  global $conf;
+  global $conf, $prefixeTable;
 
   if (empty($conf['header_manager']))
@@ -29 +40 @@
     conf_update_param('header_manager', header_manager_default_config);
   }
-  if (!file_exists(HEADER_MANAGER_DIR)) 
+  if (!file_exists(header_dir)) 
   {
-    mkdir(HEADER_MANAGER_DIR, 0755);
+    mkdir(header_dir, 0755);
   }
+  
+  pwg_query(
+'CREATE TABLE IF NOT EXISTS `' .$prefixeTable . 'category_banner` (
+  `category_id` smallint(5) unsigned NOT NULL,
+  `image` varchar(255) NOT NULL,
+  `deep` tinyint(1) DEFAULT 1,
+  PRIMARY KEY (`category_id`)
+) ENGINE=MyISAM DEFAULT CHARSET=utf8
+;');
 }
 
 function plugin_uninstall() 
 {
+  global $prefixeTable;
+  
+  pwg_query('DROP TABLE `' .$prefixeTable . 'category_banner`;');
   pwg_query('DELETE FROM `'. CONFIG_TABLE .'` WHERE param = "header_manager" LIMIT 1;');
 }