Changeset 4115 for extensions/event_cats/include

Timestamp:

Oct 26, 2009, 1:36:23 AM (15 years ago)

Author:

LucMorizur

Message:

[Event Cats] the two simplest actions added : delete entry and duplicate entry. Some JS bugs removed.

File:

• extensions/event_cats/include/evntcats_funcs.inc.php (modified) (6 diffs)

extensions/event_cats/include/evntcats_funcs.inc.php

@@ -32 +32 @@
 
 /*
+ * ec_inspect()
+ * goes through ec_lists['ec_table'] to check errors on (multiple) entries
+ * using the same code. Cannot be used elsewhere than here in
+ * build_ec_table() .
+ *
+ * @param
+ *   
+ * @return
+ *   (no return value)
+ */
+function ec_inspect($checked_item, $new_action, $check_ec_nok = true) {
+  global $ec_lists;
+  $first = array();
+  $to_correct = array();
+  
+  // $to_correct is needed cause following code would not work everywhere :
+  /*
+  foreach ($table as $value) {
+    if ($value == $value_to_check and $value == $problem) {
+      foreach ($table as &$value2) { // key index of $table can be reset
+        if ($value2 == $value_to_check) {
+          $value2 = $better_value;
+        }
+      }
+    }
+  }
+  // It works with WinAmp Server, but not on Apache server of Free (french
+  // Internet provider).
+  */
+  
+  foreach ($ec_lists['ec_table'] as &$ec_entry) { // & is not really needed
+    $ec_current_code = $ec_entry['code'];
+    if (
+     $ec_entry['action'] == 'ec_ok' or
+     ($check_ec_nok and $ec_entry['action'] == 'ec_nok')
+    ) {
+      if (isset($first[$ec_current_code])) {
+        // $first[$ec_current_code] is set <=> code has already been met.
+        // Checked item MUST be equal to the first item (thus all items) for
+        // this code.
+        if (
+         $first[$ec_current_code] != $ec_entry[$checked_item] or
+         ($new_action == '' and $ec_entry[$checked_item] == 'true')
+        ) {
+          $to_correct[$ec_current_code] = true; // value not used in fact
+        } // but using $ec_current_code as a key makes a smaller table
+      } // if the error comes back several times
+      else {
+        $first[$ec_current_code] = $ec_entry[$checked_item];
+      }
+    }
+  }
+  foreach ($ec_lists['ec_table'] as &$ec_entry) { // & is needed here
+    if (isset($to_correct[$ec_entry['code']])) {
+      if ($new_action == '') {
+        if (!pwg_query('
+          UPDATE `'.EVNTCATS_TABLE.'`
+          SET `forced` = "false"
+          WHERE `id` = '.$ec_entry['id']
+        )) die('Could not fix a "_f_pb"');
+        $ec_entry['forced'] = 'false';
+      }
+      else $ec_entry['action'] = $new_action;
+    }
+  }
+}
+
+/*
  * build_ec_table()
  * builds a table showing the content of the <pwg>_event_cats database table,
@@ -110 +178 @@
   // Construction of behaviour
   
-  /*
-   * ec_inpect()
-   * goes through ec_lists['ec_table'] to check errors on (multiple) entries
-   * using the same code. Cannot be used elsewhere than here in
-   * build_ec_table() .
-   *
-   * @param
-   *   
-   * @return
-   *   (no return value)
-   */
-  function ec_inpect($checked_item, $new_action, $check_ec_nok = true) {
-    global $ec_lists;
-    $first = array();
-    $to_correct = array();
-    
-    // $to_correct is needed cause following code would not work everywhere :
-    /*
-    foreach ($table as $value) {
-      if ($value == $value_to_check and $value == $problem) {
-        foreach ($table as &$value2) { // key index of $table can be reset
-          if ($value2 == $value_to_check) {
-            $value2 = $better_value;
-          }
-        }
-      }
-    }
-    // It works with WinAmp Server, but not on Apache server of Free (french
-    // Internet provider).
-    */
-    
-    foreach ($ec_lists['ec_table'] as &$ec_entry) { // & is not really needed
-      $ec_current_code = $ec_entry['code'];
-      if (
-       $ec_entry['action'] == 'ec_ok' or
-       ($check_ec_nok and $ec_entry['action'] == 'ec_nok')
-      ) {
-        if (isset($first[$ec_current_code])) {
-          // $first[$ec_current_code] is set <=> code has already been met.
-          // Checked item MUST be equal to the first item (thus all items) for
-          // this code.
-          if (
-           $first[$ec_current_code] != $ec_entry[$checked_item] or
-           ($new_action == '' and $ec_entry[$checked_item] == 'true')
-          ) {
-            $to_correct[$ec_current_code] = true; // value not used in fact
-          } // but using $ec_current_code as a key makes a smaller table
-        } // if the error comes back several times
-        else {
-          $first[$ec_current_code] = $ec_entry[$checked_item];
-        }
-      }
-    }
-    foreach ($ec_lists['ec_table'] as &$ec_entry) { // & is needed here
-      if (isset($to_correct[$ec_entry['code']])) {
-        if ($new_action == '') {
-          if (
-            pwg_query('
-              UPDATE `'.EVNTCATS_TABLE.'`
-              SET `forced` = "false"
-              WHERE `id` = '.$ec_entry['id']
-            ) == null
-          ) die('Could not fix a "_f_pb"');
-          $ec_entry['forced'] = 'false';
-        }
-        else $ec_entry['action'] = $new_action;
-      }
-    }
-  }
-
   // Multiple action params for a single code check
-  ec_inpect('action', 'ec_nok_action_pb');
+  ec_inspect('action', 'ec_nok_action_pb');
   
   // Multiple user_ids for a single code check
-  ec_inpect('user_id', 'ec_nok_userid_pb', false);
+  ec_inspect('user_id', 'ec_nok_userid_pb', false);
   
   // Multiple "forced" params for a single code check
-  ec_inpect('forced', '');
+  ec_inspect('forced', '');
   
   // User id and associated page validities checks
@@ -226 +224 @@
           if (array_key_exists($ec_entry['arg1'], $ec_lists['categories'])) {
             if ($a == 3) { // case 3: // Image
-              if (!mysql_fetch_row(pwg_query('
-               SELECT *
-               FROM `'.IMAGE_CATEGORY_TABLE.'` 
-               WHERE `category_id` = '.$ec_entry['arg1'].'
-                AND `image_id` = '.$ec_entry['arg2']
-              ))) {
+              if (!ec_image_exists($ec_entry['arg1'], $ec_entry['arg2'])) {
                 $ec_entry['action'].= '_img_pb';
               }
@@ -242 +235 @@
       break;
     }
+  }
+}
+
+/*
+ * build_ec_duplicable_codes()
+ * 
+ *
+ * @param
+ *   no parameter passed, the main material on which works the function, is
+ *   the global array variable $ec_lists.
+ * @return
+ *   (no return value)
+ */
+function build_ec_duplicable_codes() {
+  global $ec_lists;
+  $ec_lists['duplicable_codes'] = array();
+  $t                            = array();
+  foreach ($ec_lists['ec_table'] as $ec_entry) {
+    if (
+      is_in($ec_entry['action'], 'ec_ok') and
+      $ec_entry['forced'] == 'false'
+    ) {
+      $t[$ec_entry['id']] = $ec_entry['code'];
+      $ec_lists['duplicable_codes']['codes'][$ec_entry['code']]['id'] =
+       $ec_entry['id'];
+      $ec_lists['duplicable_codes']['codes'][$ec_entry['code']]['user_id'] =
+       $ec_entry['user_id'];
+    }
+  }
+  foreach ($t as $ec_id => $ec_code) {
+    $ec_lists['duplicable_codes']['ids'][$ec_id] =
+     $ec_lists['duplicable_codes']['codes'][$ec_code]['id'];
   }
 }
@@ -332 +357 @@
  */
 function ec_duplicate_entry_OK() {
-  global $page;
-  $page['errors'][] = 'Y\'a sûrement eu une erreur...';
+  global $page, $ec_lists;
+  
+  build_ec_duplicable_codes();
+  if (array_key_exists($_POST['ec_entry_sel'],
+   $ec_lists['duplicable_codes']['ids'])) {
+    $arg1 = ''; $arg2 = '';
+    switch ($_POST['ec_input_action']) {
+      case 'add_p':
+        if (array_key_exists($_POST['ec_in_up_aps'], $ec_lists['add_pages'])) {
+         $arg2 = $_POST['ec_in_up_aps']; }
+        else {
+          $page['errors'][] =
+           l10n('ec_bad_argument1').
+           '$_POST[\'ec_in_up_aps\'] = '.
+           $_POST['ec_in_up_aps']
+          ;
+          return false;
+        }
+      case 'home':
+      break;
+      case 'img':
+      case 'cat':
+        if (array_key_exists($_POST['ec_in_up_cat'],
+         $ec_lists['categories'])) {
+          if ($_POST['ec_input_action'] == 'img') {
+            if (
+             ec_image_exists($_POST['ec_in_up_cat'], $_POST['ec_in_up_img'])
+            ) $arg2 = $_POST['ec_in_up_img'];
+            else {
+              $page['errors'][] =
+               l10n('ec_bad_argument1').
+               '$_POST[\'ec_in_up_img\'] = '.
+               $_POST['ec_in_up_img']
+              ;
+              return false;
+            }
+          }
+          $arg1 = $_POST['ec_in_up_cat'];
+        }
+        else {
+          $page['errors'][] =
+           l10n('ec_bad_argument1').
+           '$_POST[\'ec_in_up_cat\'] = '.
+           $_POST['ec_in_up_cat']
+          ;
+          return false;
+        }
+      break;
+      default:
+        $page['errors'][] =
+         l10n('ec_bad_argument1').
+         '$_POST[\'ec_input_action\'] = '.
+         $_POST['ec_input_action']
+        ;
+        return false;
+    }
+    if (pwg_query("
+      INSERT INTO `".EVNTCATS_TABLE."`
+       (`code`, `user_id`, `action`, `arg1`, `arg2`)
+      VALUES (
+        '".$ec_lists['ec_table'][$_POST['ec_entry_sel']]['code']."',
+        '".$ec_lists['ec_table'][$_POST['ec_entry_sel']]['user_id']."',
+        'ec_ok',
+        '".$arg1."',
+        '".$arg2."'
+      );
+    ")) {
+      $page['infos'][] =
+       l10n('ec_entry_dup_ok_pre').
+       $_POST['ec_entry_sel'].' ('.
+       $ec_lists['ec_table'][$_POST['ec_entry_sel']]['code'].')'.
+       l10n('ec_entry_dup_ok_end')
+      ;
+      build_ec_table();
+      return true;
+    }
+    else {
+      $page['errors'][] =
+       l10n('ec_entry_dup_nok_pre1').
+       $_POST['ec_entry_sel'].
+       l10n('ec_entry_dup_nok_end1').
+       'MySQL error '.mysql_errno().', "'.mysql_error().'"'
+      ;
+      return false;
+    }
+  }
+  else {
+    $page['errors'][] =
+     l10n('ec_bad_argument1').
+     '$_POST[\'ec_entry_sel\'] = '.
+     $_POST['ec_entry_sel']
+    ;
+    return false;
+  }
+  $page['errors'][] = '?!';
   return false;
 }
@@ -351 +469 @@
   $page['errors'][] = 'Y\'a pas eu une erreur ?...';
   return false;
+}
+
+/*
+ * ec_delete_entry()
+ * tries to delete an existing entry which # is given by
+ * $_POST['ec_entry_sel'].
+ *
+ * @param
+ *   no param
+ * @return
+ *   no return value : modifies $page['errors'] or $page['infos']
+ */
+function ec_delete_entry() {
+  global $page, $ec_lists;
+  if (array_key_exists($_POST['ec_entry_sel'], $ec_lists['ec_table'])) {
+    if (!pwg_query('
+      DELETE FROM `'.EVNTCATS_TABLE.'`
+      WHERE `id` = '.$_POST['ec_entry_sel']
+    )) {
+      $page['errors'][] =
+        l10n('ec_entry_del_nok_pre').
+        $_POST['ec_entry_sel'].
+        l10n('ec_entry_del_nok_end').
+        'MySQL error '.mysql_errno().', "'.mysql_error().'"'
+      ;
+    }
+    else {
+      $page['infos'][] =
+        l10n('ec_entry_del_ok_pre').
+        $_POST['ec_entry_sel'].
+        l10n('ec_entry_del_ok_end');
+      build_ec_table();
+    }
+  }
+  else {
+    $page['errors'][] =
+     l10n('ec_bad_argument1').
+     '$_POST[\'ec_entry_sel\'] = '.
+     $_POST['ec_entry_sel']
+    ;
+  }
+}
+
+/*
+ * ec_image_exists($cat, $img)
+ * returns true or false whether the image is associated with the category.
+ *
+ * @param
+ *   $cat : the category
+ *   $img : the image
+ * @return
+ *   treu or false whether the image is associated with the category.
+ */
+function ec_image_exists($cat, $img) {
+  return (mysql_fetch_row(pwg_query('
+   SELECT *
+   FROM `'.IMAGE_CATEGORY_TABLE.'` 
+   WHERE `category_id` = '.$cat.'
+    AND `image_id` = '.$img
+  )) !== false);
 }