| 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/common/Class/ |
Upload File : |
<?
// common/Class/EvalInfo.phpinc
// Get eval info from f_classId and f_evaluationTitle.
debugTrackBegin();
if (false && dc()) { $EvalInfoDEBUG = true; } else { $EvalInfoDEBUG = false; }
if ( isset($_SESSION['userId']) &&$_SESSION['userId'] == -1 ) {
$EvalInfoDEBUG = true;
}
#d_Var('$evaluationNumber',$evaluationNumber,'d');
$f_evaluationTitle = $evaluationType.' '.$evaluationNumber;
$query = "
SELECT evaluationId,
classId,
evaluationOrder,
evaluationSubOrder,
evaluationType,
evaluationTitle,
evaluationDescription,
evaluationPoints,
evaluationWeight,
evaluationCritical,
evaluationExtraCredit,
evaluationDueDate,
evaluationIsHidden,
evaluationRevealDate,
evaluationInactive,
lastModified,
modifiedBy
FROM `evaluation`
WHERE classId = ".$f_classId."
AND evaluationTitle = '".query_safe($f_evaluationTitle)."'
";
$__evaluationResult = query_do($query);
$__evaluationResultCount = $_SESSION['qry']['count'];
if ( !$__evaluationResultCount) {
$f_evaluationTitle = $evaluationType.' '.twoDigit($evaluationNumber);
$query = "
SELECT evaluationId,
classId,
evaluationOrder,
evaluationSubOrder,
evaluationType,
evaluationTitle,
evaluationDescription,
evaluationPoints,
evaluationWeight,
evaluationCritical,
evaluationExtraCredit,
evaluationDueDate,
evaluationIsHidden,
evaluationRevealDate,
evaluationInactive,
lastModified,
modifiedBy
FROM `evaluation`
WHERE classId = ".$f_classId."
AND evaluationTitle = '".query_safe($f_evaluationTitle)."'
";
$__evaluationResult = query_do($query);
$__evaluationResultCount = $_SESSION['qry']['count'];
if ( !$__evaluationResultCount) {
$f_evaluationTitle = $evaluationType.twoDigit($evaluationNumber);
$query = "
SELECT evaluationId,
classId,
evaluationOrder,
evaluationSubOrder,
evaluationType,
evaluationTitle,
evaluationDescription,
evaluationPoints,
evaluationWeight,
evaluationCritical,
evaluationExtraCredit,
evaluationDueDate,
evaluationIsHidden,
evaluationRevealDate,
evaluationInactive,
lastModified,
modifiedBy
FROM `evaluation`
WHERE classId = ".$f_classId."
AND evaluationTitle = '".query_safe($f_evaluationTitle)."'
";
$__evaluationResult = query_do($query);
$__evaluationResultCount = $_SESSION['qry']['count'];
}
}
/**/
if ( $EvalInfoDEBUG ) {
printVar('$query',$query,'q');
printVar('$__evaluationResult',$__evaluationResult);
}
/* */
if ( $__evaluationResultCount != 1 ) {
$f_messageError = $courseNumber.': '.$__evaluationResultCount.' evaluations found for f_evaluationTitle='.$f_evaluationTitle.', classId='.$f_classId.'.';
require('common/programmingError.phpinc');
}
mysqli_data_seek($__evaluationResult, 0);
$v_evaluationRow = mysqli_fetch_assoc($__evaluationResult);
$f_evaluationId = $v_evaluationRow['evaluationId'];
#$f_evaluationTitle = $v_evaluationRow['f_evaluationTitle'];
$f_evaluationDescription = $v_evaluationRow['evaluationDescription'];
$f_evaluationPoints = $v_evaluationRow['evaluationPoints'];
$f_evaluationWeight = $v_evaluationRow['evaluationWeight'];
if ($EvalInfoDEBUG) {
printVar('$courseNumber',$courseNumber);
printVar('$courseTitle',$courseTitle);
printVar('$f_courseId',$f_courseId);
printVar('$f_classId',$f_classId);
printVar('$f_classSection',$f_classSection);
printVar('$f_ClassInstructor',$f_ClassInstructor);
printVar('$f_evaluationId',$f_evaluationId);
printVar('$f_evaluationTitle',$f_evaluationTitle);
printVar('$f_evaluationDescription',$f_evaluationDescription);
printVar('$f_evaluationPoints',$f_evaluationPoints);
printVar('$f_evaluationWeight',$f_evaluationWeight);
}
#Cleanup.
unset($__evaluationResult);
unset($__evaluationResultCount);
debugTrackEnd();
?>