| 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/Course/ |
Upload File : |
<?
// Course/courseMenu.phpinc
debugTrackBegin();
$courseMenu_DEBUG = false;
#if ( isset($_SESSION['userId']) && $_SESSION['userId'] == 1 ) $courseMenu_DEBUG = true;
d_Off();
if ( $courseMenu_DEBUG ) d_On();
// isCurrentPage($pageBase)
function isCurrentPage($pageBase) {
$isCurrentPageDebug = false;
#if ( isset($_SESSION['userId']) && $_SESSION['userId'] == 1 ) $isCurrentPageDebug = true;
if ($isCurrentPageDebug) { echo "<table><tr><td>\$pageBase=".$pageBase."<br>\n"; }
if (!strstr($pageBase, '?')) {
// This is a directory or page URL.
if ($isCurrentPageDebug) { echo "This is a directory or page URL.<br>\n"; }
if (!strstr($pageBase, '.')) {
// This is a directory URL.
if ($isCurrentPageDebug) { echo "This is a directory URL.<br>\n"; }
if ( basename($_SERVER['PHP_SELF']) == basename($pageBase)
|| stripos($_SERVER['PHP_SELF'],'/'.$pageBase) !== false
|| $_SERVER['PHP_SELF'] == $pageBase
|| $_SERVER['PHP_SELF'] == $pageBase."index.cfm"
|| $_SERVER['PHP_SELF'] == $pageBase."index.cfml"
|| $_SERVER['PHP_SELF'] == $pageBase."index.htm"
|| $_SERVER['PHP_SELF'] == $pageBase."index.html"
|| $_SERVER['PHP_SELF'] == $pageBase."index.php"
|| $_SERVER['PHP_SELF'] == $pageBase."/index.cfm"
|| $_SERVER['PHP_SELF'] == $pageBase."/index.cfml"
|| $_SERVER['PHP_SELF'] == $pageBase."/index.htm"
|| $_SERVER['PHP_SELF'] == $pageBase."/index.html"
|| $_SERVER['PHP_SELF'] == $pageBase."/index.php"
) {
return true;
} else {
return false;
}
} else {
// This is a page URL.
if ($isCurrentPageDebug) { echo "This is a page URL.<br>\n"; }
if (basename($_SERVER['PHP_SELF']) == $pageBase) {
return true;
} else {
return false;
}
}
} else {
// This is a QUERY_STRING URL.
if ($isCurrentPageDebug) { echo "This is a QUERY_STRING URL. \$_SERVER['QUERY_STRING']",$_SERVER['QUERY_STRING'],"<br>\n"; }
if ( strstr("?".$_SERVER['QUERY_STRING'],$pageBase) ) {
return true;
} else {
return false;
}
}
if ($isCurrentPageDebug) { echo "</td></tr></table>\n"; }
}
if (isset($CDN)) {
$f_courseNumber = $CDN[0].$CDN[1];
} else {
$f_courseNumber = '';
}
// Get the course information.
$query = "
SELECT
course.courseId,
course.userId,
course.courseNumber,
course.courseWebsite,
course.courseBase,
course.courseAssignments,
course.courseInstructionalGuide,
course.courseSchedule,
course.courseSyllabus,
course.courseInactive,
user.userFirstName,
user.userLastName,
user.userNickname,
course.courseResources,
CASE user.userNickname WHEN '' THEN user.userNickname ELSE user.userFirstName END AS preferredName
FROM course
LEFT JOIN user ON course.userId = user.userId";
if ( isset($f_courseId) && $f_courseId != '' ) {
if ( strpos($f_courseId,',') !== false ) {
$query .= "
WHERE courseId IN ( ".$f_courseId." )";
} else {
$query .= "
WHERE courseId = ".$f_courseId;
}
} else {
if ( strpos($f_courseNumber,'CST') !== false ) { $courseNumberOther = str_replace('CST','CST',$f_courseNumber); } else { $courseNumberOther = str_replace('MMDT','CST',$f_courseNumber); }
$query .= "
WHERE ( courseNumber = '".$f_courseNumber."' OR courseNumber = '".$courseNumberOther."' )";
}
$query .= "
AND course.courseInactive = 0";
/** /
if ( isset($_SESSION['userId']) ) {
$query .= "
AND course.userId = ".$_SESSION['userId'];
}
/**/
$query .= "
ORDER BY courseNumber DESC, preferredName, user.userLastName
";
#d_Var('courseMenuResult',$query,'dq');
$courseMenuResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
#d_Var('$courseMenuResult',$courseMenuResult,'d');
#d_Var('$courseCount',$courseCount);
#d_Var('$courseMenuResult',$courseMenuResult);
if ($courseCount) {
if ( !isset($f_courseId) ) {
$f_courseId = '';
mysqli_data_seek($courseMenuResult, 0);
while ($courseMenuRow = mysqli_fetch_assoc($courseMenuResult)) {
$f_courseId = listAppend($f_courseId,$courseMenuRow['courseId']);
}
}
#d_Var('$f_courseId',$f_courseId);
?>
<table class="center">
<?
$moreThanOneInstructor = false;
if ($courseCount > 1) {
$thisInstructor = '';
mysqli_data_seek($courseMenuResult, 0);
while ($courseMenuRow = mysqli_fetch_assoc($courseMenuResult)) {
if ( $thisInstructor == '' ) $thisInstructor = $courseMenuRow['preferredName'].$courseMenuRow['userLastName'];
if ( $courseMenuRow['preferredName'].$courseMenuRow['userLastName'] != $thisInstructor ) $moreThanOneInstructor = true;
}
}
mysqli_data_seek($courseMenuResult, 0);
$courseMenuRow = mysqli_fetch_assoc($courseMenuResult);
if ( $courseMenuRow['courseBase'] ) { $v_courseBase = $courseMenuRow['courseWebsite']; } else { $v_courseBase = ''; }
if ($courseMenuRow['courseInactive'] == 0 && ($courseMenuRow['courseWebsite'] != '' || $courseMenuRow['courseInstructionalGuide'] != '' || $courseMenuRow['courseSchedule'] != '' || $courseMenuRow['courseSyllabus'] != '')) {
?>
<tr>
<?
if ($moreThanOneInstructor) {
?>
<td class="right"><?=$courseMenuRow['preferredName']?> <?=$courseMenuRow['userLastName']?>: </td>
<?
}
?>
<td>
<?
}
$prefix = '';
// Website
// Only show the Website link if course is active and link is set.
$f_Website_Link = '';
$f_Website_URL = '';
if ($courseMenuRow['courseInactive'] == 0 && $courseMenuRow['courseWebsite'] != '') {
$f_Website_URL = str_replace('//','/',$courseMenuRow['courseWebsite']);
if ( !isset($courseNumberTitle) || $courseNumberTitle == '' ) $courseNumberTitle = $courseMenuRow['courseNumber'];
$courseNumberTitleHome = str_replace(array(',',' and '),'/',$courseNumberTitle);
if (isCurrentPage($courseMenuRow['courseWebsite']) && $f_task == '') {
$f_Website_Link .= '<span class="menuCurrent" title="'.$courseNumberTitleHome.' class homepage.">'.$courseNumberTitleHome.' Home</span>';
} else {
$f_Website_Link .= '<a href="'.$f_Website_URL.'" title="'.$courseNumberTitleHome.' class homepage.">'.$courseNumberTitleHome.' Home</a>';
}
?>
<?=$prefix?><?=$f_Website_Link?>
<?
$prefix = ' | ';
}
#$f_Website_Link = str_replace('//','/',$f_Website_Link);
/* */
// Assignments
// Only show the Assignments link if course is active and link is set.
$f_Assignments_Link = '';
$f_Assignments_URL = '';
if ($courseMenuRow['courseInactive'] == 0 && $courseMenuRow['courseAssignments'] != '') {
$f_Assignments_URL = str_replace('//','/',$v_courseBase.$courseMenuRow['courseAssignments']);
if (isCurrentPage($courseMenuRow['courseAssignments'])) {
$f_Assignments_Link .= '<span class="menuCurrent">Assignments</span>';
} else {
$f_Assignments_Link .= '<a href="'.$f_Assignments_URL.'">Assignments</a>';
}
?>
<?=$prefix?><?=$f_Assignments_Link?>
<?
$prefix = ' | ';
}
#$f_Assignments_Link = str_replace('//','/',$f_Assignments_Link);
/* */
// Instructional Guide
// Only show the Instructional Guide link if course is active and link is set.
$f_InstructionalGuide_Link = '';
$f_InstructionalGuide_URL = '';
if ($courseMenuRow['courseInactive'] == 0 && $courseMenuRow['courseInstructionalGuide'] != '') {
$f_InstructionalGuide_URL = str_replace('//','/',$v_courseBase.$courseMenuRow['courseInstructionalGuide']);
if (isCurrentPage($courseMenuRow['courseInstructionalGuide']) && $f_task == '') {
$f_InstructionalGuide_Link .= '<span class="menuCurrent" title="'.$courseMenuRow['courseNumber'].' Instructional Guide.">Instructional Guide</span>';
} else {
$f_InstructionalGuide_Link .= '<a href="'.$f_InstructionalGuide_URL.'" title="'.$courseMenuRow['courseNumber'].' Instructional Guide.">Instructional Guide</a>';
}
?>
<?=$prefix?><?=$f_InstructionalGuide_Link?>
<?
$prefix = ' | ';
}
#$f_InstructionalGuide_Link = str_replace('//','/',$f_InstructionalGuide_Link);
// Resources
// Only show the Resources link if course is active and link is set.
$f_Resources_Link = '';
$f_Resources_URL = '';
if ($courseMenuRow['courseInactive'] == 0 && $courseMenuRow['courseResources'] != '') {
$f_Resources_URL = str_replace('//','/',$v_courseBase.$courseMenuRow['courseResources']);
if (isCurrentPage($courseMenuRow['courseResources']) && $f_task == '') {
$f_Resources_Link .= '<span class="menuCurrent" title="'.$courseMenuRow['courseNumber'].' Resources.">Resources</span>';
} else {
$f_Resources_Link .= '<a href="'.$f_Resources_URL.'" title="'.$courseMenuRow['courseNumber'].' Resources.">Resources</a>';
}
?>
<?=$prefix?><?=$f_Resources_Link?>
<?
$prefix = ' | ';
}
#$f_Resources_Link = str_replace('//','/',$f_Resources_Link);
// Schedule
// Only show the Schedule link if course is active and link is set.
$Schedule_Path = str_replace('//','/',$v_courseBase.$courseMenuRow['courseSchedule']);
$f_Schedule_Link = '';
$f_Schedule_URL = array();
if ($courseMenuRow['courseInactive'] == 0 && $courseMenuRow['courseSchedule'] != '') {
$f_Schedule_URL[] = str_replace('//','/',$v_courseBase.$courseMenuRow['courseSchedule']);
// Check if the $courseMenuRow['courseSchedule'] is local and we know the courseId.
if ( substr($courseMenuRow['courseSchedule'],0,5) == 'http:' && isset($f_courseId) ) {
// The Schedule link is on another server.
$f_Schedule_Link .= '<a href="'.$Schedule_Path.'" title="'.$courseMenuRow['courseNumber'].' Schedule.'.'">Schedule</a>';
#d_Var('f_Schedule_Link',$f_Schedule_Link,'d');
} else {
// The file is on this server.
// Get a list of class section numbers.
$query = "
SELECT class.classId,
class.courseId,
class.YRTR,
class.RCclassId,
class.classSection,
class.modifiedBy,
courseNumber
FROM `class`
JOIN `course` ON course.courseId = class.courseId";
if ( strpos($f_courseId,',') !== false ) {
$query .= "
WHERE class.courseId IN ( ".$f_courseId." )";
} else {
$query .= "
WHERE class.courseId = ".$f_courseId;
}
$query .= "
AND class.YRTR = ".$_SESSION['YRTR']['User']."
ORDER BY courseNumber, classSection
";
#d_Var('classSectionResult',$query,'dq');
$classSectionResult = query_do($query);
$classSectionResultCount = $_SESSION['qry']['count'];
#d_Var('$classSectionResult',$classSectionResult,'d');
if ($classSectionResultCount) {
// Search for files with -## section number extension.
// Explode the Schedule file name into dirname, basename, extension, and filename parts.
$pathinfo = pathinfo($courseMenuRow['courseSchedule']);
if ( $pathinfo['dirname'] == '.' ) { $pathinfo['dirname'] = ''; } else { $pathinfo['dirname'] .= '/'; }
if ( !isset($pathinfo['extension']) ) {
$pathinfo['extension'] = '';
} else {
$pathinfo['extension'] = '.'.$pathinfo['extension'];
}
#printVar('$pathinfo',$pathinfo);
// Determine where to find the schedule file.
#printVar('$courseMenuRow',$courseMenuRow);
if ( substr($courseMenuRow['courseSchedule'],0,1) != '/' ) {
if ( $courseMenuRow['courseBase'] ) {
// Use $_SESSION['DIRECTORY_ROOT'].$courseMenuRow['courseWebsite']
$dir = $_SESSION['DIRECTORY_ROOT'].$courseMenuRow['courseWebsite'];
#printVar('courseWebsite',$dir);
} else {
// Use dirname($_SERVER['SCRIPT_FILENAME'])
$dir = dirname($_SERVER['SCRIPT_FILENAME']).'/';
#printVar('SCRIPT_FILENAME',$dir);
}
} else {
// Use $_SESSION['DIRECTORY_ROOT']
$dir = $_SESSION['DIRECTORY_ROOT'];
}
#printVar('$dir',$dir);
// Initialize fileArray
$scheduleDayTimeArray = array();
$scheduleLinkArray = array();
$scheduleSectionArray = array();
$schedulecourseNumberArray = array();
$classSectionPrevious = 0;
require('Course/studentInClass.phpinc');
mysqli_data_seek($classSectionResult, 0);
// Loop through class sections.
while ($classRow = mysqli_fetch_assoc($classSectionResult)) {
#d_Var('$classRow',$classRow,'d');
#d_Var('$classId',$classId,'d');
if ( $classId == 0 ) $classId = $classRow['classId'];
if ( $classRow['classSection'] != $classSectionPrevious ) {
#printVar('$classRow',$classRow);
$fileToFind = $dir.$pathinfo['filename'].'-'.$classRow['classSection'].$pathinfo['extension'];
#printVar('$fileToFind',$fileToFind);
if ( file_exists($fileToFind) ) {
$scheduleDayTimeArray[] = classDayTime($classRow['classId']);
$scheduleLinkArray[] = $pathinfo['dirname'].$pathinfo['filename'].'-'.$classRow['classSection'].$pathinfo['extension'];
$scheduleSectionArray[] = $classRow['classSection'];
$schedulecourseNumberArray[] = $classRow['courseNumber'];
}
#$classSectionPrevious = $classRow['classSection'];
}
}
#d_Var('$scheduleLinkArray',$scheduleLinkArray,'d');
}
}
if ( !isset($scheduleLinkArray) || !count($scheduleLinkArray) ) {
// No Schedules found for different sections.
#d_Var("\$courseMenuRow['courseSchedule']",$courseMenuRow['courseSchedule'],'d');
if (isCurrentPage($courseMenuRow['courseSchedule']) && $f_task == '') {
$f_Schedule_Link .= '<span class="menuCurrent" title="'.$courseMenuRow['courseNumber'].' Schedule.">Schedule</span>';
} else {
$f_Schedule_Link .= '<a href="'.str_replace('//','/',$v_courseBase.$courseMenuRow['courseSchedule']).'" title="'.$courseMenuRow['courseNumber'].' Schedule.">Schedule</a>';
}
} else {
$f_Schedule_Link .= 'Schedule';
// Show links to the different sections.
#printVar('$scheduleSectionArray',$scheduleSectionArray);
$f_Schedule_URL = array();
for ($index=0; $index<count($scheduleLinkArray); $index++) {
#foreach ($scheduleLinkArray as $scheduleLink) {
$scheduleLink = str_replace('//','/',$scheduleLinkArray[$index]);
$thisTitle = "Schedule for ".$schedulecourseNumberArray[$index]." section ".$scheduleSectionArray[$index]." (".$scheduleDayTimeArray[$index].").";
$f_Schedule_URL[$scheduleSectionArray[$index]] = str_replace('//','/',$v_courseBase.$scheduleLink);
d_Var('$scheduleLink',$scheduleLink,'d');
if (isCurrentPage($scheduleLink) && $f_task == '') {
$f_Schedule_Link .= ' <span class="menuCurrent" title="'.$thisTitle.'">-'.$scheduleSectionArray[$index].'</span>';
} else {
$f_Schedule_Link .= ' <a href="'.str_replace('//','/',$v_courseBase.$scheduleLinkArray[$index]).'" title="'.$thisTitle.'">-'.$scheduleSectionArray[$index].'</a>';
}
}
}
?>
<?=$prefix?><?=$f_Schedule_Link?>
<?
$prefix = ' | ';
}
#$f_Schedule_Link = str_replace('//','/',$f_Schedule_Link);
// Syllabus
// Only show the Syllabus link if course is active and link is set.
$f_Syllabus_Link = '';
$f_Syllabus_URL = '';
if ($courseMenuRow['courseInactive'] == 0 && $courseMenuRow['courseSyllabus'] != '') {
$f_Syllabus_URL = str_replace('//','/',$v_courseBase.$courseMenuRow['courseSyllabus']);
if ( isCurrentPage($courseMenuRow['courseSyllabus']) && $f_task == '' ) {
$f_Syllabus_Link .= '<span class="menuCurrent" title="'.$courseMenuRow['courseNumber'].' Syllabus.">Syllabus</span>';
} else {
$f_Syllabus_Link .= '<a href="'.$f_Syllabus_URL.'" title="'.$courseMenuRow['courseNumber'].' Syllabus.">Syllabus</a>';
}
?>
<?=$prefix?><?=$f_Syllabus_Link?>
<?
$prefix = ' | ';
}
if ($courseMenuRow['courseWebsite'] != '' || $courseMenuRow['courseInstructionalGuide'] != '' || $courseMenuRow['courseSchedule'] != '' || $courseMenuRow['courseSyllabus'] != '') {
?>
</td>
</tr>
<?
}
}
?>
</table>
<?
if ( isset($_SESSION['userId']) && isset($studentInClass) && isset($f_ClassInstructor) && $_SESSION['userId'] && !$studentInClass && !$f_ClassInstructor && $f_task != 'Student Profile' ) {
?>
<b class="error">You do not seem to be in this class.</b><br>
If you feel this is an error, please contact your Instructor.
<?
}
#printVar("\$_SESSION['userPermissions']",$_SESSION['userPermissions']);
if (in_array("ADMIN",$_SESSION['userPermissions'])) {
?>
<table class="center"><tr><td>
<?
$prefix = '';
#if ($labOnline) printVar("\$v_courseBase",$v_courseBase);
if ( isset($v_courseBase) ) {
// ClassRoster.
if (isCurrentPage('?ClassRoster')) {
?>
<?=$prefix?><span class="menuCurrent" title="<?=$courseMenuRow['courseNumber']?> Class Roster.">Class Roster</span>
<?
} else {
?>
<?=$prefix?><a href="<?=$v_courseBase?>?ClassRoster" title="<?=$courseMenuRow['courseNumber']?> Class Roster.">Class Roster</a>
<?
}
$prefix = ' | ';
}
// Gradebook.
if ( isset($v_courseBase) ) {
if (isCurrentPage('?Gradebook')) {
?>
<?=$prefix?><span class="menuCurrent" title="<?=$courseMenuRow['courseNumber']?> Gradebook.">Gradebook</span>
<?
} else {
?>
<?=$prefix?><a href="<?=$v_courseBase?>?Gradebook" title="<?=$courseMenuRow['courseNumber']?> Gradebook.">Gradebook</a>
<?
}
}
?>
</td></tr></table>
<?
}
if ( $courseMenu_DEBUG ) d_Off();
debugTrackEnd();
?>