2 include_once 'includes/init.php';
3 load_user_categories();
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") . ".";
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'" );
18 if ( $row = dbi_fetch_row ( $res ) ) {
19 if ( $row[1] == "D" ) // User deleted themself
20 $error = translate("You are not authorized") . ".";
23 // not a participant for this event
24 $error = translate("You are not authorized") . ".";
26 dbi_free_result ( $res );
28 $error = translate("Database error") . ": " . dbi_error ();
31 // Get event name and make sure event exists
33 $res = dbi_query ( "SELECT cal_name FROM webcal_entry " .
34 "WHERE cal_id = $id" );
36 if ( $row = dbi_fetch_row ( $res ) ) {
37 $event_name = $row[0];
40 $error = translate("Invalid entry id") . ".";
43 $error = translate("Database error") . ": " . dbi_error ();
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 ();
53 $url = "view_entry.php?id=$id";
54 if ( ! empty ( $date ) )
55 $url .= "&date=$date";
63 <?php if ( ! empty ( $error ) ) { ?>
64 <h2><?php etranslate("Error")?></h2>
70 <h2><?php etranslate("Set Category")?></h2>
72 <form action="set_entry_cat.php" method="post" name="SelectCategory">
74 <input type="hidden" name="date" value="<?php echo $date?>" />
75 <input type="hidden" name="id" value="<?php echo $id?>" />
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; ?>
82 <tr style="vertical-align:top;"><td style="font-weight:bold;">
83 <?php etranslate("Category")?>: </td><td>
84 <select name="cat_id">
85 <option value="NULL"><?php etranslate("None")?></option>
87 foreach ( $categories as $K => $V ) {
89 echo "<option value=\"$K\" selected=\"selected\">$V</option>\n";
91 echo "<option value=\"$K\">$V</option>\n";
96 <tr style="vertical-align:top;"><td colspan="2">
97 <input type="submit" value="<?php etranslate("Save");?>" />
103 <?php print_trailer(); ?>