addFeedback('CANCELLED'); if ($_POST['tid']) { header('Location: questions.php?tid='.$_POST['tid'].'&_course_id='.$_course_id); } else { header('Location: question_db.php?_course_id='.$_course_id); } exit; } else if (isset($_POST['submit'])) { $_POST['tid'] = intval($_POST['tid']); $_POST['qid'] = intval($_POST['qid']); $_POST['feedback'] = trim($_POST['feedback']); $_POST['instructions'] = trim($_POST['instructions']); $_POST['category_id'] = intval($_POST['category_id']); for ($i = 0 ; $i < 10; $i++) { $_POST['question'][$i] = $addslashes(trim($_POST['question'][$i])); $_POST['question_answer'][$i] = (int) $_POST['question_answer'][$i]; $_POST['answer'][$i] = $addslashes(trim($_POST['answer'][$i])); } if (!$_POST['question'][0] || !$_POST['question'][1] || !$_POST['answer'][0] || !$_POST['answer'][1]) { $msg->addError('QUESTION_EMPTY'); } if (!$msg->containsErrors()) { $_POST['feedback'] = $addslashes($_POST['feedback']); $_POST['instructions'] = $addslashes($_POST['instructions']); $sql = "UPDATE ".TABLE_PREFIX."tests_questions SET category_id=$_POST[category_id], feedback='$_POST[feedback]', question='$_POST[instructions]', choice_0='{$_POST[question][0]}', choice_1='{$_POST[question][1]}', choice_2='{$_POST[question][2]}', choice_3='{$_POST[question][3]}', choice_4='{$_POST[question][4]}', choice_5='{$_POST[question][5]}', choice_6='{$_POST[question][6]}', choice_7='{$_POST[question][7]}', choice_8='{$_POST[question][8]}', choice_9='{$_POST[question][9]}', answer_0={$_POST[question_answer][0]}, answer_1={$_POST[question_answer][1]}, answer_2={$_POST[question_answer][2]}, answer_3={$_POST[question_answer][3]}, answer_4={$_POST[question_answer][4]}, answer_5={$_POST[question_answer][5]}, answer_6={$_POST[question_answer][6]}, answer_7={$_POST[question_answer][7]}, answer_8={$_POST[question_answer][8]}, answer_9={$_POST[question_answer][9]}, option_0='{$_POST[answer][0]}', option_1='{$_POST[answer][1]}', option_2='{$_POST[answer][2]}', option_3='{$_POST[answer][3]}', option_4='{$_POST[answer][4]}', option_5='{$_POST[answer][5]}', option_6='{$_POST[answer][6]}', option_7='{$_POST[answer][7]}', option_8='{$_POST[answer][8]}', option_9='{$_POST[answer][9]}' WHERE question_id=$_POST[qid]"; if ($testsQuestionsDAO->execute($sql)) { $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY'); if ($_POST['tid']) { header('Location: questions.php?tid='.$_POST['tid'].'&_course_id='.$_course_id); } else { header('Location: question_db.php?_course_id='.$_course_id); } exit; } } } else { if (!($row = $testsQuestionsDAO->get($qid))){ require_once(TR_INCLUDE_PATH.'header.inc.php'); $msg->printErrors('ITEM_NOT_FOUND'); require (TR_INCLUDE_PATH.'footer.inc.php'); exit; } $_POST['feedback'] = $row['feedback']; $_POST['instructions'] = $row['question']; $_POST['category_id'] = $row['category_id']; for ($i=0; $i<10; $i++) { $_POST['question'][$i] = $row['choice_'.$i]; $_POST['question_answer'][$i] = $row['answer_'.$i]; $_POST['answer'][$i] = $row['option_'.$i]; } } $onload = 'document.form.category_id.focus();'; require_once(TR_INCLUDE_PATH.'header.inc.php'); $savant->assign('qid', $qid); $savant->assign('tid', $_REQUEST['tid']); $savant->assign('letters', $_letters); $savant->assign('course_id', $_course_id); $savant->display('tests/create_edit_question_matchingdd.tmpl.php'); require (TR_INCLUDE_PATH.'footer.inc.php'); ?>