Changeset 4282 for extensions/event_cats/include/evntcats_main_funcs.inc.php

Timestamp:

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

Author:

LucMorizur

Message:

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

File:

• extensions/event_cats/include/evntcats_main_funcs.inc.php (modified) (4 diffs)

extensions/event_cats/include/evntcats_main_funcs.inc.php

@@ -155 +155 @@
       if ($new_action == '') {
         if (!pwg_query("
-          UPDATE `".EVNTCATS_AUTOLOG_TABLE."`
+          UPDATE `".EVNTCATS_TABLE."`
           SET `forced` = 'false'
           WHERE `id` = ".$ec_entry['id']
@@ -247 +247 @@
   
   $q = pwg_query("
-    SELECT * FROM `".EVNTCATS_AUTOLOG_TABLE."`
+    SELECT * FROM `".EVNTCATS_TABLE."`
     WHERE `code` IS NOT NULL
     ORDER BY `id`
@@ -370 +370 @@
   $groups_granted_ids = order_by_name(
     array_from_query("
-      SELECT `val`
-        FROM ".EVNTCATS_DUPLIC_TABLE."
-        WHERE `item` = 'grp'
+      SELECT `arg2`
+        FROM ".EVNTCATS_TABLE."
+        WHERE `code` IS NULL
+          AND `arg1` = '1'
+          AND `arg2` IS NOT NULL
       ;",
-      'val'
+      'arg2'
     ),
     $groups
@@ -382 +384 @@
   $users_granted_direct_ids = order_by_name(
     array_from_query("
-      SELECT `val`
-        FROM ".EVNTCATS_DUPLIC_TABLE."
-        WHERE `item` = 'usr'
+      SELECT `arg2`
+        FROM ".EVNTCATS_TABLE."
+        WHERE `code` IS NULL
+          AND `arg1` = '2'
+          AND `arg2` IS NOT NULL
       ;",
-      'val'
+      'arg2'
     ),
     $ec_lists['user_ids']