translate ( "Tomorrow" ),
"1" => translate ( "Today" ),
"2" => translate ( "Yesterday" ),
"3" => translate ( "Day before yesterday" ),
"10" => translate ( "Next week" ),
"11" => translate ( "This week" ),
"12" => translate ( "Last week" ),
"13" => translate ( "Week before last" ),
"20" => translate ( "Next week and week after" ),
"21" => translate ( "This week and next week" ),
"22" => translate ( "Last week and this week" ),
"23" => translate ( "Last two weeks" ),
"30" => translate ( "Next month" ),
"31" => translate ( "This month" ),
"32" => translate ( "Last month" ),
"33" => translate ( "Month before last" ),
"40" => translate ( "Next year" ),
"41" => translate ( "This year" ),
"42" => translate ( "Last year" ),
"43" => translate ( "Year before last" ),
"50" => translate ( "Next 14 days" ),
"51" => translate ( "Next 30 days" ),
"52" => translate ( "Next 60 days" ),
"53" => translate ( "Next 90 days" ),
"54" => translate ( "Next 180 days" ),
"55" => translate ( "Next 365 days" ),
);
// Get list of users that the current user can see
if ( empty ( $error ) && $show_participants ) {
$userlist = get_my_users ();
if ($nonuser_enabled == "Y" ) {
$nonusers = get_nonuser_cals ();
$userlist = ($nonuser_at_top == "Y") ? array_merge($nonusers, $userlist) :
array_merge($userlist, $nonusers);
}
}
// Default values
$page_template = "
\${days}
";
$day_template = "\${date}\n\${events}
";
$event_template = "\${name}\n" .
"" . translate ( "Date" ) . ": \${date}
\n" .
"" . translate ( "Time" ) . ": \${time}
\n" .
"\${description}\n";
if ( empty ( $error ) && $report_id >= 0 ) {
$sql = "SELECT cal_login, cal_report_id, cal_is_global, " .
"cal_report_type, cal_include_header, cal_report_name, " .
"cal_time_range, cal_user, cal_allow_nav, cal_cat_id, " .
"cal_include_empty, cal_show_in_trailer, cal_update_date " .
"FROM webcal_report " .
"WHERE cal_report_id = $report_id";
//echo "SQL: $sql
";
$res = dbi_query ( $sql );
if ( $res ) {
if ( $row = dbi_fetch_row ( $res ) ) {
$i = 0;
$report_login = $row[$i++];
$report_id = $row[$i++];
$report_is_global = $row[$i++];
$report_type = $row[$i++];
$report_include_header = $row[$i++];
$report_name = $row[$i++];
$report_time_range = $row[$i++];
$report_user = $row[$i++];
$report_allow_nav = $row[$i++];
$report_cat_id = $row[$i++];
$report_include_empty = $row[$i++];
$report_show_in_trailer = $row[$i++];
$report_update_date = $row[$i++];
// Check permissions.
if ( $show_participants && ! empty ( $report_user ) ) {
$user_is_in_list = false;
for ( $i = 0; $i < count ( $userlist ); $i++ ) {
if ( $report_user == $userlist[$i]['cal_login'] ) {
$user_is_in_list = true;
}
}
if ( ! $user_is_in_list && $report_login != $login && ! $is_admin ) {
$error = translate ( "You are not authorized" );
}
}
if ( ! $is_admin && $login != $report_login ) {
// If not admin, only creator can edit/delete the event
$error = translate ( "You are not authorized" );
}
// If we are editing a public user report we need to set $updating_public
if ( $is_admin && $report_login == "__public__" ) {
$updating_public = true;
}
} else {
$error = translate ( "Invalid report id" ) . ": $report_id";
}
dbi_free_result ( $res );
} else {
$error = translate("Database error") . ": " . dbi_error ();
}
$res = dbi_query ( "SELECT cal_template_type, cal_template_text " .
"FROM webcal_report_template " .
"WHERE cal_report_id = $report_id" );
if ( $res ) {
while ( $row = dbi_fetch_row ( $res ) ) {
if ( $row[0] == 'P' ) {
$page_template = $row[1];
} else if ( $row[0] == 'D' ) {
$day_template = $row[1];
} else if ( $row[0] == 'E' ) {
$event_template = $row[1];
}
}
dbi_free_result ( $res );
}
} else {
// default values for new report
$report_login = $login;
$report_id = -1;
$report_is_global = 'N';
$report_type = 'html';
$report_include_header = 'Y';
$report_name = translate("Unnamed Report");
$report_time_range = 11; // current week
//$report_user already set
$report_allow_nav = 'Y';
$report_cat_id = '';
$report_include_empty = 'N';
$report_show_in_trailer = 'N';
$report_update_date = '';
}
print_header();
//echo "report_id: $report_id
\n";
//echo "report_name: $report_name
\n";
//echo "report_user: $report_user
\n";
?>