| 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/Class/ |
Upload File : |
<?
// Admin/Class/ClassEvaluationImport.phpinc
// Import evaluations from another class.
$ClassEvaluationImport_DEBUG = false;
$f_classId = formValue('classId');
if ( $ClassEvaluationImport_DEBUG ) printVar(',$f_classId',$f_classId);
$f_import_classId = formValue('import_classId');
if ( $ClassEvaluationImport_DEBUG ) printVar(',$f_import_classId',$f_import_classId);
if ( $_SESSION['uuid'] != $f_uuid ) {
// Get Student and Class profile points for import.
$query = "
SELECT
studentProfilePoints,
classProfilePoints
FROM class
WHERE classId = ".$f_import_classId."
";
$classImportResult = query_do($query);
$classImportCount = $_SESSION['qry']['count'];
$classImportRow = mysqli_fetch_assoc($classImportResult);
$f_studentProfilePoints = $classImportRow['studentProfilePoints'];
$f_classProfilePoints = $classImportRow['classProfilePoints'];
$f_lastModified = currentDateTime();
$query = "
UPDATE `class`
SET studentProfilePoints = ".$f_studentProfilePoints.",
classProfilePoints = ".$f_classProfilePoints.",
lastModified = '".query_safe($f_lastModified)."',
modifiedBy = ".$_SESSION['trueuserId']."
WHERE classId = ".$f_classId."
";
$classUpdate = query_do($query);
// Get evaluation info for import.
$query = "
SELECT evaluationId,
evaluationOrder,
evaluationSubOrder,
evaluationType,
evaluationTitle,
evaluationDescription,
evaluationPoints,
evaluationWeight,
evaluationCritical,
evaluationExtraCredit,
evaluationDueDate,
evaluationIsHidden,
evaluationRevealDate,
evaluationInactive,
lastModified,
modifiedBy
FROM `evaluation`
WHERE classId = ".$f_import_classId."
";
if ( $ClassEvaluationImport_DEBUG ) printVar(',$query',$query,'q');
$evaluationResult = query_do($query);
$evaluationResultCount = $_SESSION['qry']['count'];
if ( $ClassEvaluationImport_DEBUG ) printVar(',$evaluationResultCount',$evaluationResultCount);
if ($evaluationResultCount) {
mysqli_data_seek($evaluationResult, 0);
// Loop through all evaluations.
while ($evaluationRow = mysqli_fetch_assoc($evaluationResult)) {
// INSERT evaluation data.
$f_lastModified = currentDateTime();
$query = "
INSERT
INTO `evaluation` (
classId,
evaluationOrder,
evaluationSubOrder,
evaluationType,
evaluationTitle,
evaluationDescription,
evaluationPoints,
evaluationWeight,
evaluationCritical,
evaluationExtraCredit,
";
if ( $evaluationRow['evaluationDueDate'] != '') {
$query .= "
evaluationDueDate,
";
}
$query .= "
evaluationIsHidden,
";
if ( $evaluationRow['evaluationRevealDate'] != '') {
$query .= "
evaluationRevealDate,
";
}
$query .= "
evaluationInactive,
lastModified,
modifiedBy
) VALUES (
".$f_classId.",
".$evaluationRow['evaluationOrder'].",
".$evaluationRow['evaluationSubOrder'].",
'".query_safe($evaluationRow['evaluationType'])."',
'".query_safe($evaluationRow['evaluationTitle'])."',
'".query_safe($evaluationRow['evaluationDescription'])."',
".$evaluationRow['evaluationPoints'].",
".$evaluationRow['evaluationWeight'].",
".$evaluationRow['evaluationCritical'].",
".$evaluationRow['evaluationExtraCredit'].",
";
if ( $evaluationRow['evaluationDueDate'] != '') {
$query .= "
'".query_safe($evaluationRow['evaluationDueDate'])."',
";
}
$query .= "
".$evaluationRow['evaluationIsHidden'].",
";
if ( $evaluationRow['evaluationRevealDate'] != '') {
$query .= "
'".query_safe($evaluationRow['evaluationRevealDate'])."',
";
}
$query .= "
".$evaluationRow['evaluationInactive'].",
'".query_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $ClassEvaluationImport_DEBUG ) {
printVar('evaluationInsert',$query,'q');
$f_evaluationId = 0;
} else {
$evaluationInsert = query_do($query);
$f_evaluationId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
}
// Get question info for this evaluation for import.
$query = "
SELECT questionId,
questionType,
questionGroup,
questionOrder,
questionText,
questionModifier,
questionNote,
questionNoteDisplay,
questionInactive,
lastModified,
modifiedBy
FROM `question`
WHERE evaluationId = ".$evaluationRow['evaluationId']."
";
if ( $ClassEvaluationImport_DEBUG ) printVar(',$query',$query,'q');
$questionResult = query_do($query);
$questionResultCount = $_SESSION['qry']['count'];
if ( $ClassEvaluationImport_DEBUG ) printVar(',$questionResultCount',$questionResultCount);
if ($questionResultCount) {
mysqli_data_seek($questionResult, 0);
// Loop through all questions.
while ($questionRow = mysqli_fetch_assoc($questionResult)) {
// INSERT question data.
$query = "
INSERT
INTO `question` (
evaluationId,
questionType,
questionGroup,
questionOrder,
questionText,
questionModifier,
questionNote,
questionNoteDisplay,
questionInactive,
lastModified,
modifiedBy
) VALUES (
".$f_evaluationId.",
'".query_safe($questionRow['questionType'])."',
".$questionRow['questionGroup'].",
".$questionRow['questionOrder'].",
'".query_safe($questionRow['questionText'])."',
".$questionRow['questionModifier'].",
'".query_safe($questionRow['questionNote'])."',
".$questionRow['questionNoteDisplay'].",
".$questionRow['questionInactive'].",
'".query_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $ClassEvaluationImport_DEBUG ) {
printVar('questionInsert',$query,'q');
$f_questionId = 0;
} else {
$questionInsert = query_do($query);
$f_questionId = mysqli_insert_id($_SESSION['DATABASE_LINK']);
}
// Get answer info for this question.
$query = "
SELECT questionId,
answerOrder,
answerText,
answerFile,
answerValue,
answerCorrect,
answerNote,
lastModified,
modifiedBy
FROM `answer`
WHERE questionId = ".$questionRow['questionId']."
";
if ( $ClassEvaluationImport_DEBUG ) printVar(',$query',$query,'q');
$answerResult = query_do($query);
$answerResultCount = $_SESSION['qry']['count'];
if ( $ClassEvaluationImport_DEBUG ) printVar(',$answerResultCount',$answerResultCount);
if ($answerResultCount) {
mysqli_data_seek($answerResult, 0);
// Loop through all answers.
while ($answerRow = mysqli_fetch_assoc($answerResult)) {
// INSERT answer data.
$query = "
INSERT
INTO `answer` (
questionId,
answerOrder,
answerText,
answerFile,
answerValue,
answerCorrect,
answerNote,
lastModified,
modifiedBy
) VALUES (
".$f_questionId.",
".$answerRow['answerOrder'].",
'".query_safe($answerRow['answerText'])."',
'".query_safe($answerRow['answerFile'])."',
".$answerRow['answerValue'].",
".$answerRow['answerCorrect'].",
'".query_safe($answerRow['answerNote'])."',
'".query_safe($f_lastModified)."',
".$_SESSION['trueuserId']."
)
";
if ( $ClassEvaluationImport_DEBUG ) {
printVar('answerInsert',$query,'q');
} else {
$answerInsert = query_do($query);
}
}
}
}
}
}
}
#$_SESSION['uuid'] = $f_uuid;
}
?>