Changeset 4276 for extensions/event_cats/maintain.inc.php

Timestamp:

Nov 16, 2009, 1:26:06 AM (14 years ago)

Author:

LucMorizur

Message:

[Event Cats] Duplication management, add table and begin $_POST analysis

File:

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

extensions/event_cats/maintain.inc.php

@@ -36 +36 @@
 include_once(EVNTCATS_PATH.'include/ec_conf.inc.php');
 
+// ***********************************************************************
 function plugin_uninstall() {
-  global $prefixeTable, $ec_conf;
+  global $prefixeTable;
 
-  unset($ec_conf);
         pwg_query("DELETE FROM `".CONFIG_TABLE."` WHERE `param` = 'event_cats' LIMIT 1;");
-        return pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats`;');
+        pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats_duplic`;');
+        return pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats_autolog`;');
 }
 
+// ***********************************************************************
 function plugin_install() {
   global $prefixeTable;
   
   plugin_uninstall();
+  
   // create table for plugin, if it doesn't exist yet
-  $q = pwg_query("
-    CREATE TABLE `".$prefixeTable."event_cats` (
+  $r = (pwg_query("
+    CREATE TABLE `".$prefixeTable."event_cats_autolog` (
       `id`      SMALLINT(5)             UNSIGNED NOT NULL     AUTO_INCREMENT ,
       `code`    VARCHAR(32)                               DEFAULT NULL ,
@@ -63 +66 @@
     )
     DEFAULT CHARACTER SET utf8;
-  ");
+  ") !== false);
 
 /*
@@ -131 +134 @@
 
 */
-  pwg_query("
+  
+  if ($r) $r = (pwg_query("
+    CREATE TABLE `".$prefixeTable."event_cats_duplic` (
+      `item`  VARCHAR(5) NOT NULL ,
+      `val` VARCHAR(32) NOT NULL ,
+      KEY `item` (`item`),
+      KEY `val` (`val`)
+    )
+    DEFAULT CHARACTER SET utf8;
+  ") !== false);
+
+/*
+Explanations on table structure :
+
+item  : the code used as "autolog" argument. If thie code provided by the
+          visitor does not exist in the table, the administrator can choose
+          whether the visitor is redirected to the home page (nothing
+          happens) or to the "access denied" page ;
+value : the account concerned in following values ;
+
+*/
+  
+  if ($r) $r = (pwg_query("
     INSERT INTO `".CONFIG_TABLE."` (`param`,`value`,`comment`)
     VALUES ('event_cats','0','Paramètres du plugin Event Cats');
-  ");
-  change_ec_conf('activated', '0');
-  return $q;
+  ") !== false);
+  
+  if ($r) $r = (change_ec_conf('activated', '0'));
+  
+  if ($r) return true;
+  else {
+    plugin_uninstall();
+    return false;
+  }
 }
 
+// ***********************************************************************
 function plugin_activate() {
   change_ec_conf('activated', '1');
 }
 
+// ***********************************************************************
 function plugin_deactivate() {
   change_ec_conf('activated', '0');