| 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/Admin/ |
Upload File : |
<?
// CourseLinksFormPerform.phpinc
debugTrackBegin();
if (dc()) {
#printVar('$f_courseId',$f_courseId);
}
if ($f_form == 'form_courseAdd') {
// This is a course add.
// We need to determine the YRTR courseTitle courseShortTitle courseCredits courseCreditsMax courseD2L courseDescription coursePrerequisite courseCorequisite
$f_YRTR = '';
$f_courseTitle = '';
$f_courseShortTitle = '';
$f_courseCredits = 0;
$f_courseCreditsMax = 0;
$f_courseD2L = 0;
$f_courseDescription = '';
$f_coursePrerequisite = '';
$f_courseCorequisite = '';
}
if ( $_SESSION['uuid'] != $f_uuid ) {
if ($f_courseId == 0) {
$f_lastModified = currentDateTime();
// Add the courses.
$query = "
INSERT
INTO `course` (
userId,
YRTR,
courseNumber,
courseTitle,
courseShortTitle,
courseCredits,
courseCreditsMax,
courseWebsite,
courseBase,
courseAssignments,
courseInstructionalGuide,
courseSchedule,
courseSyllabus,
courseInactive,
courseObsolete,
courseUnavailable,
lastModified,
modifiedBy,
courseD2L,
courseDescription,
coursePrerequisite,
courseCorequisite,
courseResources
) VALUES (
".$_SESSION['userId'].",
'".query_safe($f_YRTR)."',
'".query_safe($f_courseNumber)."',
'".query_safe($f_courseTitle)."',
'".query_safe($f_courseShortTitle)."',
".$f_courseCredits.",
".$f_courseCreditsMax.",
'".query_safe($f_courseWebsite)."',
".$f_courseBase.",
'".query_safe($f_courseAssignments)."',
'".query_safe($f_courseInstructionalGuide)."',
'".query_safe($f_courseSchedule)."',
'".query_safe($f_courseSyllabus)."',
0,
0,
0,
'".query_safe($f_lastModified)."',
".$_SESSION['trueuserId'].",
".$f_courseD2L.",
'".query_safe($f_courseDescription)."',
'".query_safe($f_coursePrerequisite)."',
'".query_safe($f_courseCorequisite)."',
'".query_safe($f_courseResources)."'
)
";
$courseInsert = query_do($query);
// Get the course info back.
$query = "
SELECT courseId
FROM course
WHERE userId = ".$_SESSION['userId']."
AND courseNumber = '".$f_courseNumber."'
";
$courseResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
$courseRow = mysqli_fetch_assoc($courseResult);
$f_courseId = $courseRow['courseId'];
$f_message = $f_courseNumber.' links added.';;
} else {
// Update the courses.
$query = "
UPDATE course SET
courseNumber = '".$f_courseNumber."',
courseWebsite = '".$f_courseWebsite."',
courseBase = ".$f_courseBase.",
courseAssignments = '".$f_courseAssignments."',
courseInstructionalGuide = '".$f_courseInstructionalGuide."',
courseSyllabus = '".$f_courseSyllabus."',
courseResources = '".$f_courseResources."',
courseSchedule = '".$f_courseSchedule."'
WHERE courseId = ".$f_courseId."
";
$courseUpdate = query_do($query);
$f_message = $f_courseNumber.' links updated.';;
}
#$_SESSION['uuid'] = $f_uuid;
$_SESSION['message'] = $f_message;
} else {
if ($f_courseId == 0) {
$query = "
SELECT courseId
FROM course
WHERE userId = ".$_SESSION['userId']."
AND courseNumber = '".$f_courseNumber."'
";
$courseResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
} else {
$query = "
SELECT *
FROM course
WHERE courseId = '".$f_courseId."'
";
$courseResult = query_do($query);
$courseCount = $_SESSION['qry']['count'];
}
$courseRow = mysqli_fetch_assoc($courseResult);
if ($_SESSION['qry']['count']) {
$f_courseNumber = $courseRow['courseNumber'];
$f_courseWebsite = $courseRow['courseWebsite'];
$f_courseBase = $courseRow['courseBase'];
$f_courseAssignments = $courseRow['courseAssignments'];
$f_courseInstructionalGuide = $courseRow['courseInstructionalGuide'];
$f_courseSchedule = $courseRow['courseSchedule'];
$f_courseSyllabus = $courseRow['courseSyllabus'];
$f_courseResources = $courseRow['courseResources'];
}
$f_message = $_SESSION['message'];
}
if (dc()) {
#printVar('$f_courseId',$f_courseId);
}
debugTrackEnd();
?>