2 include_once $gfplugins.'webcalendar/www/includes/init.php';
4 // does the category belong to the user?
7 $is_my_event = true; // new event
9 $res = dbi_query ( "SELECT cat_id, cat_owner FROM webcal_categories " .
10 "WHERE cat_id = $id" );
12 $row = dbi_fetch_row ( $res );
13 if ( $row[0] == $id && $row[1] == $login )
15 else if ( $row[0] == $id && empty ( $row[1] ) && $is_admin )
16 $is_my_event = true; // global category
17 dbi_free_result ( $res );
19 $error = translate("Database error") . ": " . dbi_error ();
24 $error = translate ( "You are not authorized" ) . ".";
27 if ( empty ( $error ) &&
28 ( $action == "Delete" || $action == translate ("Delete") ) ) {
29 // delete this category
31 if ( ! dbi_query ( "DELETE FROM webcal_categories " .
32 "WHERE cat_id = $id AND " .
33 "( cat_owner = '$login' OR cat_owner IS NULL )" ) )
34 $error = translate ("Database error") . ": " . dbi_error();
36 if ( ! dbi_query ( "DELETE FROM webcal_categories " .
37 "WHERE cat_id = $id AND cat_owner = '$login'" ) )
38 $error = translate ("Database error") . ": " . dbi_error();
41 // Set any events in this category to NULL
42 if ( ! dbi_query ( "UPDATE webcal_entry_user SET cal_category = NULL " .
43 "WHERE cal_category = $id" ) )
44 $error = translate ("Database error") . ": " . dbi_error();
45 } else if ( empty ( $error ) ) {
46 if ( ! empty ( $id ) ) {
47 # update (don't let them change global status)
48 $sql = "UPDATE webcal_categories SET cat_name = '$catname' " .
50 if ( ! dbi_query ( $sql ) ) {
51 $error = translate ("Database error") . ": " . dbi_error();
56 $res = dbi_query ( "SELECT MAX(cat_id) FROM webcal_categories" );
58 $row = dbi_fetch_row ( $res );
60 dbi_free_result ( $res );
62 if ( $isglobal == "Y" )
65 $catowner = "'$login'";
67 $catowner = "'$login'";
68 $sql = "INSERT INTO webcal_categories " .
69 "( cat_id, cat_owner, cat_name ) " .
70 "VALUES ( $id, $catowner, '$catname' )";
71 if ( ! dbi_query ( $sql ) ) {
72 $error = translate ("Database error") . ": " . dbi_error();
75 $error = translate ("Database error") . ": " . dbi_error();
79 if ( empty ( $error ) )
80 do_redirect ( "category.php" );
84 <h2><?php etranslate("Error")?></h2>
90 <?php print_trailer(); ?>