2 include_once $gfplugins.'webcalendar/www/includes/init.php';
6 echo "<h2>" . translate("Error") .
7 "</h2>" . translate("You are not authorized") . ".\n";
9 echo "</body></html>\n";
14 if ( $action == "Delete" || $action == translate ("Delete") ) {
15 // delete this nonuser calendar
18 // Get event ids for all events this user is a participant
20 $res = dbi_query ( "SELECT webcal_entry.cal_id " .
21 "FROM webcal_entry, webcal_entry_user " .
22 "WHERE webcal_entry.cal_id = webcal_entry_user.cal_id " .
23 "AND webcal_entry_user.cal_login = '$user'" );
25 while ( $row = dbi_fetch_row ( $res ) ) {
30 // Now count number of participants in each event...
31 // If just 1, then save id to be deleted
32 $delete_em = array ();
33 for ( $i = 0; $i < count ( $events ); $i++ ) {
34 $res = dbi_query ( "SELECT COUNT(*) FROM webcal_entry_user " .
35 "WHERE cal_id = " . $events[$i] );
37 if ( $row = dbi_fetch_row ( $res ) ) {
39 $delete_em[] = $events[$i];
41 dbi_free_result ( $res );
44 // Now delete events that were just for this user
45 for ( $i = 0; $i < count ( $delete_em ); $i++ ) {
46 dbi_query ( "DELETE FROM webcal_entry WHERE cal_id = " . $delete_em[$i] );
49 // Delete user participation from events
50 dbi_query ( "DELETE FROM webcal_entry_user WHERE cal_login = '$user'" );
52 // Delete any layers other users may have that point to this user.
53 dbi_query ( "DELETE FROM webcal_user_layers WHERE cal_layeruser = '$user'" );
56 if ( ! dbi_query ( "DELETE FROM webcal_nonuser_cals WHERE cal_login = '$user'" ) )
57 $error = translate ("Database error") . ": " . dbi_error();
60 if ( $action == "Save" || $action == translate ("Save") ) {
62 $sql = "UPDATE webcal_nonuser_cals SET ";
63 if ($nlastname) $sql .= " cal_lastname = '$nlastname', ";
64 if ($nfirstname) $sql .= " cal_firstname = '$nfirstname', ";
65 $sql .= "cal_admin = '$nadmin' WHERE cal_login = '$nid'";
66 if ( ! dbi_query ( $sql ) ) {
67 $error = translate ("Database error") . ": " . dbi_error();
71 if (preg_match( "/^[\w]+$/", $nid )) {
72 $nid = $NONUSER_PREFIX.$nid;
73 $sql = "INSERT INTO webcal_nonuser_cals " .
74 "( cal_login, cal_firstname, cal_lastname, cal_admin ) " .
75 "VALUES ( '$nid', '$nfirstname', '$nlastname', '$nadmin' )";
76 if ( ! dbi_query ( $sql ) ) {
77 $error = translate ("Database error") . ": " . dbi_error();
80 $error = translate ("Calendar ID")." ".translate ("word characters only").".";
84 if ( empty ( $error ) ) do_redirect ( "nonusers.php" );
89 <h2><?php etranslate("Error")?></h2>
96 // echo "<br /><br /><b>SQL:</b> $sql";
100 <?php print_trailer(); ?>