| 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/RecognitionLab/ |
Upload File : |
<?
// Class/Question_Perform.phpinc
// Update question text and question answers.
#$DEBUG_Question_Perform = true;
if ( !isset($DEBUG_Question_Perform) ) $DEBUG_Question_Perform = false;
debugTrackBegin(); // Begin TRACKing included file.
if ( $DEBUG_Question_Perform ) printVar('$f_uuid',$f_uuid);
if ( $DEBUG_Question_Perform ) printVar("\$_SESSION['uuid']",$_SESSION['uuid']);
if ( $_SESSION['uuid'] != $f_uuid ) {
if ( $f_task == 'QuestionRemove' ) {
// DELETE question answers.
$recognitionlabquestionId = $f_subtask;
if ( $DEBUG_Question_Perform ) printVar('$recognitionlabquestionId',$recognitionlabquestionId);
$query = "
DELETE
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionId = ".$recognitionlabquestionId."
";
if ( $DEBUG_Question_Perform ) printVar('$query',$query,'q');
$recognitionlabquestionDelete = query_do($query);
// DELETE question.
$recognitionlabquestionId = $f_subtask;
if ( $DEBUG_Question_Perform ) printVar('$recognitionlabquestionId',$recognitionlabquestionId);
$query = "
DELETE
FROM `recognitionlabquestion`
WHERE recognitionlabquestionId = ".$recognitionlabquestionId."
";
if ( $DEBUG_Question_Perform ) printVar('$query',$query,'q');
$recognitionlabquestionDelete = query_do($query);
// Reorder questions.
$query = "
SELECT recognitionlabquestionId,
recognitionlabquestionNumber
FROM `recognitionlabquestion`
WHERE recognitionlabId = ".$f_recognitionlabId."
ORDER BY recognitionlabquestionNumber
";
$recognitionlabquestionOrderResult = query_do($query);
$recognitionlabquestionOrderResultCount = $_SESSION['qry']['count'];
if ($recognitionlabquestionOrderResultCount) {
$recognitionlabquestionNumber = 0;
mysqli_data_seek($recognitionlabquestionOrderResult, 0);
while ($recognitionlabquestionOrderRow = mysqli_fetch_assoc($recognitionlabquestionOrderResult)) {
$recognitionlabquestionNumber++;
if ( $recognitionlabquestionNumber != $recognitionlabquestionOrderRow['recognitionlabquestionNumber'] ) {
$query = "
UPDATE `recognitionlabquestion`
SET recognitionlabquestionNumber = ".$recognitionlabquestionNumber."
WHERE recognitionlabquestionId = ".$recognitionlabquestionOrderRow['recognitionlabquestionId']."
";
if ( $DEBUG_Question_Perform ) printVar('$query',$query,'q');
$questionUpdate = query_do($query);
}
}
}
/** /
foreach ( $question as $questionId => $thispart ) {
if ( $swapNumber && $questionId != 0 ) {
$question[$questionId]['Number'] = $swapNumber;
$question[$questionId]['Changed'] = true;
$swapNumber++;
}
if ( $questionId == $f_subtask ) $swapNumber = $thispart['Number'];
}
/**/
}
if ( $f_task == 'QuestionUpdate' ) {
// UPDATE question name.
if ( $DEBUG_Question_Perform ) printVar('$question',$question);
if ( $question['Changed'] ) {
$f_modifiedOn = currentDateTime();
$query = "
UPDATE `recognitionlabquestion`
SET recognitionlabquestionName = '".query_safe($question['Name'])."',
recognitionlabquestionData = '".query_safe($question['Data'])."',
modifiedBy = ".$_SESSION['trueuserId'].",
modifiedOn = '".query_safe($f_modifiedOn)."'
WHERE recognitionlabquestionId = ".$questionId."
";
if ( $DEBUG_Question_Perform ) printVar('$query',$query,'q');
$questionUpdate = query_do($query);
}
foreach ( $questionpartIds as $questionpartId ) {
if ( $questionpartanswer[$questionpartId]['Changed'] === 'Insert' && $questionpartanswer[$questionpartId]['Text'] !== '' ) {
$f_addedOn = currentDateTime();
$query = "
INSERT
INTO `recognitionlabquestionpartanswer` (
recognitionlabquestionId,
recognitionlabquestionpartId,
recognitionlabquestionpartanswerText,
addedBy,
addedOn
) VALUES (
".$questionId.",
".$questionpartId.",
'".query_safe($questionpartanswer[$questionpartId]['Text'])."',
".$_SESSION['trueuserId'].",
'".query_safe($f_addedOn)."'
)
";
if ( $DEBUG_Question_Perform ) printVar('$query',$query,'q');
$recognitionlabquestionpartanswerInsert = query_do($query);
}
if ( $questionpartanswer[$questionpartId]['Changed'] === 'Update' ) {
if ( $questionpartanswer[$questionpartId]['Text'] !== '' ) {
// UPDATE recognitionlabquestionpartanswer.
$f_modifiedOn = currentDateTime();
$query = "
UPDATE `recognitionlabquestionpartanswer`
SET recognitionlabquestionpartanswerText = '".query_safe($questionpartanswer[$questionpartId]['Text'])."',
modifiedBy = ".$_SESSION['trueuserId'].",
modifiedOn = '".query_safe($f_modifiedOn)."'
WHERE recognitionlabquestionId = ".$questionId."
AND recognitionlabquestionpartId = ".$questionpartId."
";
if ( $DEBUG_Question_Perform ) printVar('$query',$query,'q');
$recognitionlabquestionpartanswerUpdate = query_do($query);
} else {
// DELETE recognitionlabquestionpartanswer.
$query = "
DELETE
FROM `recognitionlabquestionpartanswer`
WHERE recognitionlabquestionId = ".$questionId."
AND recognitionlabquestionpartId = ".$questionpartId."
";
if ( $DEBUG_Question_Perform ) printVar('$query',$query,'q');
$recognitionlabquestionpartanswerDelete = query_do($query);
}
}
}
}
$_SESSION['uuid'] = $f_uuid;
}
debugTrackEnd(); // End TRACKing included file.
?>