| 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/Class/OnlineLab/ |
Upload File : |
<?
// Class/OnlineLab/QuestionSave.phpinc
// Save the question answers.
if (da()) debugTrackBegin();
if ( isset($_SESSION['userId']) && $_SESSION['userId'] == -1 ) $DEBUG_QuestionSave = true;
if ( !isset($DEBUG_QuestionSave) ) $DEBUG_QuestionSave = false;
if ( $DEBUG_QuestionSave ) printVar('$f_questionNum',$f_questionNum,'/');
if ( !$f_gradeId ) {
// Save a null grade and the get the gradeId.
$f_lastModified = currentDateTime();
$query = "
INSERT
INTO `grade` (
userId,
evaluationId,
lastModified,
modifiedBy
) VALUES (
".$f_userId.",
".$f_evaluationId.",
'".query_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $DEBUG_QuestionSave ) printVar('$query',$query,'qf');
$gradeInsert = query_do($query);
if ( $DEBUG_QuestionSave ) printVar('$gradeInsert',$gradeInsert,'f');
$f_gradeId = $_SESSION['qry']['insertId'];
if ( $DEBUG_QuestionSave ) printVar('$f_gradeId',$f_gradeId,'f');
}
// Get the question answers.
$answerParts = array();
for ($questionPartNum=1; $questionPartNum<=$QuestionPart['Count']['Total']; $questionPartNum++) {
$answerParts[] = formValue('answerPart_'.$questionPartNum);
}
$f_gradeanswerAnswer = implode(',',$answerParts);
if ( $DEBUG_QuestionSave ) {
printVar('$answerParts',$answerParts,'f');
printVar('$f_gradeanswerAnswer',$f_gradeanswerAnswer,'f');
}
// Check for a gradeanswer.
#include('Gradebook/GetGradeanswer_by_userId_gradeId_questionNum.phpinc');
include('QuestionStatus.phpinc');
if ( $DEBUG_QuestionSave ) printVar("\$gradeanswerInfo[$f_questionNum]['gradeId']",$gradeanswerInfo[$f_questionNum]['gradeId']);
if ( !$gradeanswerInfo[$f_questionNum]['gradeId'] ) {
// INSERT gradeanswer
$f_lastModified = currentDateTime();
$f_gradeanswerGradedOn = currentDateTime();
$query = "
INSERT
INTO `gradeanswer` (
userId,
gradeId,
gradeanswerQuestionNum,
gradeanswerAnswer,
lastModified,
modifiedBy
) VALUES (
".$f_userId.",
".$f_gradeId.",
".$f_questionNum.",
'".query_safe($f_gradeanswerAnswer)."',
'".query_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $DEBUG_QuestionSave ) printVar('$query',$query,'q');
$gradeanswerInsert = query_do($query);
if ( $DEBUG_QuestionSave ) printVar('$gradeanswerInsert',$gradeanswerInsert,'f');
} else {
// UPDATE gradeanswer
$f_lastModified = currentDateTime();
$query = "
UPDATE `gradeanswer`
SET gradeanswerAnswer = '".query_safe($f_gradeanswerAnswer)."',
lastModified = '".query_safe($f_lastModified)."',
modifiedBy = ".$_SESSION['trueuserId']."
WHERE userId = ".$f_userId."
AND gradeId = ".$f_gradeId."
AND gradeanswerQuestionNum = ".$f_questionNum."
";
if ( $DEBUG_QuestionSave ) printVar('$query',$query,'q');
$gradeanswerUpdate = query_do($query);
if ( $DEBUG_QuestionSave ) printVar('$gradeanswerUpdate',$gradeanswerUpdate,'f');
}
if (da()) debugTrackEnd();
?>