Changeset 4282 for extensions/event_cats/admin

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/admin/evntcats_admin.php (modified) (2 diffs)

extensions/event_cats/admin/evntcats_admin.php

@@ -90 +90 @@
 // If no entry exist, default page is 'autolog_new'.
 $page['tab'] = (!($ec_exist_entries = (mysql_num_rows(pwg_query("
-  SELECT * FROM `".EVNTCATS_AUTOLOG_TABLE."`
+  SELECT * FROM `".EVNTCATS_TABLE."`
   WHERE `code` IS NOT NULL ;
 ")) != 0))) ? 'autolog_new' : 'autolog_entries';
 
 $ec_exist_duplic = ((mysql_num_rows(pwg_query("
-    SELECT * FROM `".EVNTCATS_DUPLIC_TABLE."` ;
+  SELECT * FROM `".EVNTCATS_TABLE."`
+  WHERE `code` IS NULL
+  AND `arg1` IS NOT NULL
+  AND `arg2` IS NOT NULL ;
   ")) != 0) or
   (read_ec_conf('duplic_gen') != 0) or
@@ -204 +207 @@
 
 $ec_exist_entries = (mysql_num_rows(pwg_query("
-  SELECT * FROM `".EVNTCATS_AUTOLOG_TABLE."`
+  SELECT * FROM `".EVNTCATS_TABLE."`
   WHERE `code` IS NOT NULL
 ")) != 0);
 
 $ec_exist_duplic = ((mysql_num_rows(pwg_query("
-    SELECT * FROM `".EVNTCATS_DUPLIC_TABLE."` ;
+  SELECT * FROM `".EVNTCATS_TABLE."`
+  WHERE `code` IS NULL
+  AND `arg1` IS NOT NULL
+  AND `arg2` IS NOT NULL ;
   ")) != 0) or
   (read_ec_conf('duplic_gen') != 0) or