| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/Schedule/ |
Upload File : |
<?
// Schedule/Schedule.phpinc
// Set SchoolYRTR.
if ( isset($_SESSION['YRTR']['User']) && $_SESSION['YRTR']['User'] != '' ) {
$SchoolYRTR = $_SESSION['YRTR']['User'];
} else {
$SchoolYRTR = $_SESSION['YRTR']['CURRENT'];
}
// Get SchoolCalendar.
$query = "
SELECT schoolId,
schoolYRTR,
schoolDate,
schoolStatus,
schoolNote
FROM `calendarschool`
WHERE schoolYRTR = '".query_safe($_SESSION['YRTR']['User'])."'
ORDER BY schoolDate
";
d_Var('calendarschoolResult',$query,'q');
$calendarschoolResult = query_do($query);
$calendarschoolResultCount = $_SESSION['qry']['count'];
d_Var('$calendarschoolResult',$calendarschoolResult);
if ($calendarschoolResultCount) {
$SchoolCalendar = array();
mysqli_data_seek($calendarschoolResult, 0);
while ($calendarschoolRow = mysqli_fetch_assoc($calendarschoolResult)) {
$SchoolCalendar[$calendarschoolRow['schoolDate']] = array();
$SchoolCalendar[$calendarschoolRow['schoolDate']]['Status'] = $calendarschoolRow['schoolStatus'];
$SchoolCalendar[$calendarschoolRow['schoolDate']]['Note'] = $calendarschoolRow['schoolNote'];
#$SchoolCalendar[$calendarschoolRow['schoolDate']] = $calendarschoolRow['schoolStatus'].' | '.$calendarschoolRow['schoolNote'];
}
} else {
$SchoolCalendar = array();
}
// Get calendarUserId.
if ( !isset($calendarUserId) ) {
#d_Var("\$_SERVER['SCRIPT_NAME']",$_SERVER['SCRIPT_NAME'],'',false,true);
$userDirectory = explode('/',$_SERVER['SCRIPT_NAME']); $userDirectory = $userDirectory[1];
$query = "
SELECT userId
FROM `user`
WHERE CONCAT(userFirstName,userLastName) = '".query_safe($userDirectory)."'
OR CONCAT(userNickname,userLastName) = '".query_safe($userDirectory)."'
";
#d_Var('userResult',$query,'q',false,true);
$userResult = query_do($query);
$userResultCount = $_SESSION['qry']['count'];
#d_Var('$userResult',$userResult,'',false,true);
if ($userResultCount == 1) {
mysqli_data_seek($userResult, 0);
$userRow = mysqli_fetch_assoc($userResult);
$calendarUserId = $userRow['userId'];
} else {
$calendarUserId = 0;
}
}
// Get InstructorCalendar.
$query = "
SELECT calendaruserId,
userId,
userYRTR,
userDate,
userLocation,
userNote
FROM `calendaruser`
WHERE userId = ".$calendarUserId."
AND userYRTR = '".query_safe($_SESSION['YRTR']['User'])."'
ORDER BY userId, userDate
";
#d_Var('calendaruserResult',$query,'dq');
$calendaruserResult = query_do($query);
$calendaruserResultCount = $_SESSION['qry']['count'];
#d_Var('$calendaruserResult',$calendaruserResult,'d');
if ($calendaruserResultCount) {
$InstructorCalendar = array();
mysqli_data_seek($calendaruserResult, 0);
while ($calendaruserRow = mysqli_fetch_assoc($calendaruserResult)) {
$InstructorCalendar[$calendaruserRow['userDate']] = array();
$InstructorCalendar[$calendaruserRow['userDate']]['Location'] = $calendaruserRow['userLocation'];
$InstructorCalendar[$calendaruserRow['userDate']]['Note'] = $calendaruserRow['userNote'];
#$InstructorCalendar[$calendaruserRow['userDate']] = $calendaruserRow['userLocation'].' | '.$calendaruserRow['userNote'];
}
} else {
$InstructorCalendar = array();
}
#d_Var('$InstructorCalendar',$InstructorCalendar,'',false,true);
?>