| 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/QuestionsPerform.phpinc
// Purpose_of_include_file_goes_here.
#$DEBUG_QuestionsPerform = true;
if ( !isset($DEBUG_QuestionsPerform) ) $DEBUG_QuestionsPerform = false;
debugTrackBegin(); // Begin TRACKing included file.
if ( $_SESSION['uuid'] != $f_uuid ) {
if ( $f_task == 'QuestionDn' || $f_task == 'QuestionUp' ) {
$swapNumber = $question[$f_subtask]['Number'] + $direction;
if ( $DEBUG_QuestionsPerform ) printVar('$f_subtask',$f_subtask);
if ( $DEBUG_QuestionsPerform ) printVar('$swapNumber',$swapNumber);
$query = "
SELECT recognitionlabquestionId,
recognitionlabId,
recognitionlabquestionNumber,
recognitionlabquestionName,
recognitionlabquestionData
FROM `recognitionlabquestion`
WHERE recognitionlabId = ".$f_recognitionlabId."
AND recognitionlabquestionNumber = ".$swapNumber."
ORDER BY recognitionlabquestionNumber
";
if ( $DEBUG_QuestionsPerform ) printVar('$query',$query,'q');
/**/
$questionSwapResult = query_do($query);
$questionSwapResultCount = $_SESSION['qry']['count'];
mysqli_data_seek($questionSwapResult, 0);
$questionSwapRow = mysqli_fetch_assoc($questionSwapResult);
$swapId = $questionSwapRow['recognitionlabquestionId'];
if ( $DEBUG_QuestionsPerform ) printVar('$swapId',$swapId);
if ( $DEBUG_QuestionsPerform ) printVar("\$question[$f_subtask]",$question[$f_subtask]);
if ( $DEBUG_QuestionsPerform ) printVar("\$question[$swapNumber]",$question[$swapId]);
$question[$swapId]['Number'] = $question[$f_subtask]['Number'];
$question[$f_subtask]['Number'] = $questionSwapRow['recognitionlabquestionNumber'];
$question[$swapId]['Changed'] = true;
$question[$f_subtask]['Changed'] = true;
if ( $DEBUG_QuestionsPerform ) printVar("\$question[$f_subtask]",$question[$f_subtask]);
if ( $DEBUG_QuestionsPerform ) printVar("\$question[$swapNumber]",$question[$swapId]);
/**/
}
if ( $f_task == 'QuestionRemove' ) {
$query = "
DELETE
FROM `recognitionlabquestion`
WHERE recognitionlabquestionId = ".$f_subtask."
";
$recognitionlabquestionDelete = query_do($query);
if ( $DEBUG_QuestionsPerform ) printVar('$f_subtask',$f_subtask);
$swapNumber = false;
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'];
}
}
foreach ( $questionIds as $questionId ) {
if ( $question[$questionId]['Changed'] ) {
$f_modifiedOn = currentDateTime();
$query = "
UPDATE `recognitionlabquestion`
SET recognitionlabquestionNumber = ".$question[$questionId]['Number'].",
recognitionlabquestionName = '".query_safe($question[$questionId]['Name'])."',
modifiedBy = ".$_SESSION['trueuserId'].",
modifiedOn = '".query_safe($f_modifiedOn)."'
WHERE recognitionlabquestionId = ".$questionId."
";
if ( $DEBUG_QuestionsPerform ) printVar('$query',$query,'q');
$questionUpdate = query_do($query);
}
}
if ( $DEBUG_QuestionsPerform ) printVar("\$question[0]",$question[0]);
if ( $question['0']['Changed'] ) {
$question[0]['Number'] = $questionResultCount + 1;
$f_addedOn = currentDateTime();
$query = "
INSERT
INTO `recognitionlabquestion` (
recognitionlabId,
recognitionlabquestionNumber,
recognitionlabquestionName,
addedBy,
addedOn
) VALUES (
".$f_recognitionlabId.",
".$question[0]['Number'].",
'".query_safe($question[0]['Name'])."',
".$_SESSION['trueuserId'].",
'".query_safe($f_addedOn)."'
)
";
if ( $DEBUG_QuestionsPerform ) printVar('$query',$query,'q');
$recognitionlabquestionInsert = query_do($query);
// Get the recognitionlabquestionId.
$recognitionlabquestionId = $_SESSION['qry']['insertId'];
// Set form variables.
$questionResultCount++;
$questionIds[] = $recognitionlabquestionId;
$question[$recognitionlabquestionId]['Number'] = $question[0]['Number'];
$question[$recognitionlabquestionId]['Name'] = $question[0]['Name'];
}
$_SESSION['uuid'] = $f_uuid;
}
debugTrackEnd(); // End TRACKing included file.
?>