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