| 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/Instructor/ |
Upload File : |
<?
// Instructor/Instructors.phpinc
debugTrackBegin();
// Get Instructors.
$query = "
SELECT user.userId
FROM `user`
JOIN `useruserpermission` ON useruserpermission.userId = user.userId
JOIN `userpermission` ON userpermission.userpermissionId = useruserpermission.userpermissionId
WHERE userpermissionName = 'ADMIN'
AND userIsInactive = 0
ORDER BY user.userFirstName, user.userLastName
";
$instructorIdsResult = query_do($query);
$instructorIdsCount = $_SESSION['qry']['count'];
if ($instructorIdsCount) {
$InstructorsND = array();
mysqli_data_seek($instructorIdsResult, 0);
while ($userIdsRow = mysqli_fetch_assoc($instructorIdsResult)) {
$InstructorsND[$userIdsRow['userId']] = array();
$InstructorsND[$userIdsRow['userId']]['name'] = userName($userIdsRow['userId']);
$InstructorsND[$userIdsRow['userId']]['dir'] = str_replace(' ','',$InstructorsND[$userIdsRow['userId']]['name']);
}
}
#ksort($InstructorsND);
#d_Var('$_SESSION',$_SESSION,'+',false,true);
if ( false || ( isset($_GET['REMOTE_ADDR']) && $_GET['REMOTE_ADDR'] == 'x10.14.16.25' ) ) {
#d_On();
// Get Waldo info.
$OutputContactInformation = false;
$OutputWheresWaldo = false;
foreach ( $InstructorsND as $userId => $data ) {
$CIpath = $_SESSION['DIRECTORY_ROOT'].$data['dir'].'/ContactInformation.phpinc';
if ( file_exists($CIpath) ) {
#d_Off();
require($CIpath);
#d_On();
}
else {
#d_line($CIpath.' not found.');
$InstructorsND[$userId]['dir'] = false;
}
}
#d_Var('$InstructorsND',$InstructorsND,'k+',false,true);
#d_Var('$_SESSION',$_SESSION,'+');
#d_Off();
}
$filepathExists = array();
#d_Var('$InstructorsND',$InstructorsND,'',false,true);
?>
<table>
<tr><th class="right">Staff:</th><?
foreach ( $InstructorsND as $userId => $data ) {
$filepath = $_SESSION['DIRECTORY_ROOT'].$data['dir'];
#d_Var('$filepath',$filepath,'',false,true);
$filepathExists[$data['dir']] = file_exists($filepath);
#d_Var("\$filepathExists[".$data['dir']."]",$filepathExists[$data['dir']],'',false,true);
if ( $filepathExists[$data['dir']] && $data['dir'] ) {
?><td><a href="/<?=$data['dir']?>"><?=$data['name']?></a></td><td> </td><?
}
}
?></tr>
<tr><th class="right">Location:</th><?
foreach ( $InstructorsND as $userId => $data ) {
if ( $filepathExists[$data['dir']] && $data['dir'] ) {
// Check calendarschool for 'No classes' or 'School closed'.
$query = "
SELECT schoolStatus
FROM `calendarschool`
WHERE ( schoolStatus = 'No classes' OR schoolStatus = 'School closed' )
AND schoolDate = '".query_safe(currentDate())."'
";
#d_Var('calendarschoolResult',$query,'d');
$calendarschoolResult = query_do($query);
$calendarschoolCount = $_SESSION['qry']['count'];
#d_Var('$calendarschoolResult',$calendarschoolResult,'d+');
#d_Var('$calendarschoolCount',$calendarschoolCount,'d');
if ( $calendarschoolCount ) {
mysqli_data_seek($calendarschoolResult, 0);
$calendarschoolRow = mysqli_fetch_assoc($calendarschoolResult);
$location = '<span class="today">'.$calendarschoolRow['schoolStatus'].'</span>';
} else {
// Get location.
$query = "
SELECT userLocation,
userNote
FROM `calendaruser`
WHERE userId = ".$userId."
AND userDate = '".query_safe(currentDate())."'
";
#d_Var('calendaruserResult',$query,'d');
$calendaruserResult = query_do($query);
$calendaruserResultCount = $_SESSION['qry']['count'];
#d_Var('$calendaruserResult',$calendaruserResult,'d');
if ($calendaruserResultCount) {
mysqli_data_seek($calendaruserResult, 0);
$calendaruserRow = mysqli_fetch_assoc($calendaruserResult);
$location = '<span class="today"';
if ( $calendaruserRow['userNote'] ) {
$location .= ' title="'.htmlView($calendaruserRow['userNote']).'"';
}
$location .= '>'.$calendaruserRow['userLocation'].'</span>';
} else {
$location = '';
}
}
?><td><?=$location?></td><td> </td><?
}
}
?></tr>
</table>
<?
debugTrackEnd();
?>