[Sommaire] [Imprimer]

   1  <?php
   2  include_once  'includes/init.php';
   3  load_user_categories();
   4  
   5  $error = "";
   6  
   7  if ( empty ( $id ) )
   8    $error = translate("Invalid entry id") . ".";
   9  else if ( $categories_enabled != "Y" )
  10    $error = translate("You are not authorized") . ".";
  11  else if ( empty ( $categories ) )
  12    $error = translate("You have not added any categories") . ".";
  13  
  14  // make sure user is a participant
  15  $res = dbi_query ( "SELECT cal_category, cal_status FROM webcal_entry_user " .
  16    "WHERE cal_id = $id AND cal_login = '$login'" );
  17  if ( $res ) {
  18    if ( $row = dbi_fetch_row ( $res ) ) {
  19      if ( $row[1] == "D" ) // User deleted themself
  20        $error = translate("You are not authorized") . ".";
  21      $cur_cat = $row[0];
  22    } else {
  23      // not a participant for this event
  24      $error = translate("You are not authorized") . ".";
  25    }
  26    dbi_free_result ( $res );
  27  } else {
  28    $error = translate("Database error") . ": " . dbi_error ();
  29  }
  30  
  31  // Get event name and make sure event exists
  32  $event_name = "";
  33  $res = dbi_query ( "SELECT cal_name FROM webcal_entry " .
  34    "WHERE cal_id = $id" );
  35  if ( $res ) {
  36    if ( $row = dbi_fetch_row ( $res ) ) {
  37      $event_name = $row[0];
  38    } else {
  39      // No such event
  40      $error = translate("Invalid entry id") . ".";
  41    }
  42  } else {
  43    $error = translate("Database error") . ": " . dbi_error ();
  44  }
  45  
  46  // If this is the form handler, then save now
  47  if ( ! empty ( $cat_id ) && empty ( $error ) ) {
  48    $sql = "UPDATE webcal_entry_user SET cal_category = $cat_id " .
  49      "WHERE cal_id = $id and cal_login = '$login'";
  50    if ( ! dbi_query ( $sql ) ) {
  51      $error = translate ( "Database error" ) . ": " . dbi_error ();
  52    } else {
  53      $url = "view_entry.php?id=$id";
  54      if ( ! empty ( $date ) )
  55        $url .= "&amp;date=$date";
  56      do_redirect ( $url );
  57    }
  58  }
  59  
  60  print_header();
  61  ?>
  62  
  63  <?php if ( ! empty ( $error ) ) { ?>
  64  <h2><?php etranslate("Error")?></h2>
  65  <blockquote>
  66  <?php echo $error; ?>
  67  </blockquote>
  68  
  69  <?php } else { ?>
  70  <h2><?php etranslate("Set Category")?></h2>
  71  
  72  <form action="set_entry_cat.php" method="post" name="SelectCategory">
  73  
  74  <input type="hidden" name="date" value="<?php echo $date?>" />
  75  <input type="hidden" name="id" value="<?php echo $id?>" />
  76  
  77  <table style="border-width:0px;" cellpadding="5">
  78  <tr style="vertical-align:top;"><td style="font-weight:bold;">
  79      <?php etranslate("Brief Description")?>:</td><td>
  80      <?php echo $event_name; ?>
  81  </td></tr>
  82  <tr style="vertical-align:top;"><td style="font-weight:bold;">
  83      <?php etranslate("Category")?>:&nbsp;</td><td>
  84      <select name="cat_id">
  85          <option value="NULL"><?php etranslate("None")?></option>
  86    <?php
  87      foreach ( $categories as $K => $V ) {
  88        if ( $K == $cur_cat )
  89          echo "<option value=\"$K\" selected=\"selected\">$V</option>\n";
  90        else
  91          echo "<option value=\"$K\">$V</option>\n";
  92      }
  93    ?>
  94      </select>
  95  </td></tr>
  96  <tr style="vertical-align:top;"><td colspan="2">
  97      <input type="submit" value="<?php etranslate("Save");?>" />
  98  </td></tr>
  99  </table>
 100  </form>
 101  <?php } ?>
 102  
 103  <?php print_trailer(); ?>
 104  </body>
 105  </html>