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

Timestamp:

Nov 16, 2009, 11:06:18 PM (15 years ago)

Author:

LucMorizur

Message:

[Event Cats] Duplication management : found last problem :-) !

File:

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

extensions/event_cats/maintain.inc.php

@@ -41 +41 @@
 
         pwg_query("DELETE FROM `".CONFIG_TABLE."` WHERE `param` = 'event_cats' LIMIT 1;");
-        pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats_duplic`;');
-        return pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats_autolog`;');
+        return pwg_query('DROP TABLE IF EXISTS `'.$prefixeTable.'event_cats`;');
 }
 
@@ -53 +52 @@
   // create table for plugin, if it doesn't exist yet
   $r = (pwg_query("
-    CREATE TABLE `".$prefixeTable."event_cats_autolog` (
+    CREATE TABLE `".$prefixeTable."event_cats` (
       `id`      SMALLINT(5)             UNSIGNED NOT NULL     AUTO_INCREMENT ,
       `code`    VARCHAR(32)                               DEFAULT NULL ,
@@ -136 +135 @@
   
   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');