Changeset 18927 for extensions/Comments_on_Albums/maintain.inc.php

Timestamp:

Nov 4, 2012, 3:59:38 PM (11 years ago)

Author:

mistic100

Message:

update with Piwigo 2.5 features (website url, email, mandatory email and username)

File:

• extensions/Comments_on_Albums/maintain.inc.php (modified) (2 diffs)

extensions/Comments_on_Albums/maintain.inc.php

@@ -2 +2 @@
 if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
 
+defined('COA_ID') or define('COA_ID', basename(dirname(__FILE__)));
+include_once(PHPWG_PLUGINS_PATH . COA_ID . '/include/install.inc.php');
+
 function plugin_install() 
 {
-  global $prefixeTable;
-
-  pwg_query("
-CREATE TABLE `" . $prefixeTable . "comments_categories` (
-  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
-  `category_id` mediumint(8) unsigned NOT NULL DEFAULT '0',
-  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
-  `author` varchar(255) DEFAULT NULL,
-  `author_id` smallint(5) DEFAULT NULL,
-  `anonymous_id` varchar(45) NOT NULL,
-  `content` longtext,
-  `validated` enum('true','false') NOT NULL DEFAULT 'false',
-  `validation_date` datetime DEFAULT NULL,
-  PRIMARY KEY (`id`)
-) DEFAULT CHARSET=utf8
-;");
+  coa_install();
+  define('coa_installed', true);
 }
 
 function plugin_activate()
 {
-  global $conf, $prefixeTable;
-  
-  if (isset($conf['comments_on_albums']))
+  if (!defined('coa_installed'))
   {
-    pwg_query('DELETE FROM '.CONFIG_TABLE.' WHERE param="comments_on_albums" LIMIT 1;');
-  }
-  
-  $query = 'SHOW COLUMNS FROM `' . $prefixeTable . 'comments_categories`;';
-  $columns = hash_from_query($query, 'Field');
-  if (!isset($columns['anonymous_id']))
-  {
-    pwg_query('ALTER TABLE `' . $prefixeTable . 'comments_categories` ADD `anonymous_id` VARCHAR( 45 ) DEFAULT NULL;');
+    coa_install();
   }
 }
@@ -43 +23 @@
   global $prefixeTable;
 
-  pwg_query("DROP TABLE `" . $prefixeTable . "comments_categories`;");
+  pwg_query('DROP TABLE `' . $prefixeTable . 'comments_categories`;');
 }
+
 ?>