Error! Please check your current reservation list and try again. $ID
";
exit();
}
$ID = $row[16];
$today = date("F j, Y, g:i a"); // March 10, 2001, 5:16 pm
if (isset($_POST["absent"]))
{
$query = "update SR_reservation set Status='4' ";
$Reason = "ABSENT\n".$Reason;
}
else
{
$query = "update SR_reservation set Status='3' ";
}
if ($manage==1){$query .= ", Memo=CONCAT(Memo,'\n$today - Cancelled by LLC $user\n', '$Reason')";}
else {$query .= ", Memo=CONCAT(Memo, '\n$today - Cancelled by instructor $ID\n', '$Reason')";}
$query .= " WHERE Date = '$Date' and StartTime='$StartTime' and SR_reservation.RoomNo='$Room' and (SR_reservation.Status='1' or SR_reservation.Status='2')";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
list ($Year, $Month, $Day) = split ('-', $Date);
include("../SendMail.php");
$TEXT="Dear Prof. $FirstName $LastName\n\n";
$TEXT=$TEXT."Your reservation has been CANCELLED:\n\n";
$TEXT=$TEXT."$Room\n";
$TEXT=$TEXT."On $Month/$Day/$Year\n";
$TEXT=$TEXT."From $StartTime to $EndTime\n";
$TEXT=$TEXT."For class: $Class $Course $Title\n";
$TEXT=$TEXT."Number of students: $Student\n";
$TEXT=$TEXT."Tasks:\n$Tasks\n";
$TEXT=$TEXT."Brief Lesson Plan:\n$Needs\n\n";
$TEXT=$TEXT."Email: $Email\n";
$TEXT=$TEXT."Extension: $Extension\n";
$TEXT=$TEXT."Home Phone: $Home\n";
$TEXT=$TEXT."Cell Phone: $Cell\n\n";
$TEXT=$TEXT."Reason of cancellation:\n$Reason\n\n";
$TEXT=$TEXT."If you have any question, please call our extension 4580, or simply Reply All to this email. We will get back to you as soon as we can.\n\n";
$TEXT=$TEXT."Thank you, Language Learning Center\n";
//include("../include/email.php"); //this line defines $cc2
if ($Email == '')
{
SendMail(
"langlab@mtsac.edu","Language Learning Center", //sender
"langlab@mtsac.edu", $FirstName." ".$LastName, //recipient
$cc2, // copy to
"Cancelled your LLC reservation ".$Date." ".$LastName, //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
}
else
{
SendMail(
"langlab@mtsac.edu","Language Learning Center", //sender
$Email, $FirstName." ".$LastName, //recipient
"langlab@mtsac.edu,".$cc2, // copy to
"Cancelled your LLC reservation ".$Date." ".$LastName, //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
}
print <<Reservation Cancelled