";
$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 ) {
$error = translate ( "You are not authorized" );
}
}
if ( ! $is_admin && $login != $report_login ) {
$error = translate ( "You are not authorized" );
}
} 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";
?>