= '$Date' and TO_DAYS(Date) <= TO_DAYS('$LastDay') and DAYOFWEEK(date)=DAYOFWEEK('$Date') and RoomNo = '$Room' and (Status='1' or Status='2')";
}
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
while ($row = mysql_fetch_row($result))
{
list ($starthour, $startminute, $startsec) = split (':', $row[0]);
list ($endhour, $endminute, $endsec) = split (':', $row[1]);
if ($starthour*60+$startminute >= $EndHour*60+$EndMinute or $endhour*60+$endminute <= $StartHour*60+$StartMinute)
{continue;}
else
{
print "Sorry, your selected time $StartHour:$StartMinute - $EndHour:$EndMinute on $row[2] is no longer avaliable. Please go back and change your time selection.
";
exit();
}
}
$today = date("F j, Y, g:i a"); // March 10, 2001, 5:16 pm
$query = "insert into SR_reservation set RoomNo= '$Room', Date= '$Date', StartTime='$StartTime', EndTime='$EndTime', InstructorID='$ID', ClassID = '$Course', StudentNum='$Student', Tasks='$Tasks', SpecialNeeds='$Needs1'";
if ($manage==1){$query .= ", Memo='$today - Reserved by LLC $user', Status='2'";}
else {$query .= ", Memo='$today - Reserved by instructor $ID'";}
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
if ($Weekly == '1')
{
list ($LYear, $LMonth, $LDay) = split ('-', $LastDay);
$TimeLastDay = mktime(0,0,0, $LMonth, $LDay, $LYear);
$Weekday = date("l", mktime (0,0,0,$Month,$Day,$Year));
$NextDay = $Day+7;
$TimeNextDay = mktime(0,0,0, $Month, $NextDay, $Year);
$NextDate = date("Y-m-d", $TimeNextDay);
while ($TimeNextDay <= $TimeLastDay )
{
$query = "select CloseDate from SR_closedate where CloseDate='$NextDate'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$num_rows = mysql_num_rows($result);
if ($num_rows == 0)
{
$query = "insert into SR_reservation set RoomNo= '$Room', Date= '$NextDate', StartTime='$StartTime', EndTime='$EndTime', InstructorID='$ID', ClassID = '$Course', StudentNum='$Student', Tasks='$Tasks', SpecialNeeds='$Needs'";
if ($manage==1){$query .= ", Memo='$today - Reserved by LLC $user', Status='2'";}
else {$query .= ", Memo='$today - Reserved by instructor $ID'";}
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
}
$NextDay = $NextDay+7;
$TimeNextDay = mktime(0,0,0, $Month, $NextDay, $Year);
$NextDate = date("Y-m-d", $TimeNextDay);
}
}
$query = "SELECT FirstName, LastName, Email, Extension, Home, Cell from SR_instructor WHERE InstructorID = '$ID'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$FirstName = $row[0];
$LastName = $row[1];
$Email = $row[2];
$Extension = $row[3];
$Home = $row[4];
$Cell = $row[5];
$query = "SELECT CourseID, Days, BeginTime, EndTime from SR_course WHERE ClassID = '$Course' and Year = '$syear' and Semester='$semester'";
$result = mysql_query($query, $connection) or die ("Error in query: $query. " . mysql_error());
$row = mysql_fetch_row($result);
$Course .= ' '.$row[0].' - '.$row[1].' - From '.$row[2].' to '.$row[3];
include("../SendMail.php");
$TEXT="Dear Prof. $FirstName $LastName\n\n";
$TEXT=$TEXT."We have received your reservation request for:\n\n";
if ($Weekly == '1'){ $TEXT=$TEXT."Weekly Reservation\n";}
$TEXT=$TEXT."$Title - $Room\n";
$TEXT=$TEXT."On $Month/$Day/$Year\n";
if ($Weekly == '1'){ $TEXT=$TEXT."EVERY $Weekday\n";}
$TEXT=$TEXT."From $StartTime to $EndTime\n";
$TEXT=$TEXT."For class: $Course\n";
$TEXT=$TEXT."Number of students: $Student\n";
$TEXT=$TEXT."You will use:\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."If you have any question, please call us at 909-274-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
"Confirms 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
"Confirms your LLC reservation ".$Date." ".$LastName, //subject
$TEXT,$HTML,$ATTM); //body and attachment(s)
}
header("Location: completion.php?semester=$Semester&id=$ID&rm=$Room&tag=$Tag&dpt=$Department");
exit();
?>