addFeedback('CANCELLED'); header('Location: questions.php?tid='.$tid.'&_course_id='.$_course_id); exit; } else if (isset($_POST['submit_yes'])) { //get order $order = $testsQuestionsAssocDAO->getMaxOrderByTestID($tid); $sql = "REPLACE INTO ".TABLE_PREFIX."tests_questions_assoc VALUES "; foreach ($_POST['questions'] as $question) { $order++; $question = intval($question); $sql .= '('.$tid.', '.$question.', 0, '.$order.'),'; } $sql = substr($sql, 0, -1); if ($testsQuestionsAssocDAO->execute($sql)) { $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY'); header('Location: questions.php?tid='.$tid.'&_course_id='.$_course_id); exit; } else { $msg->addError('DB_NOT_UPDATED'); } } else if (isset($_POST['submit_no'])) { $msg->addFeedback('CANCELLED'); header('Location: add_test_questions.php?tid='.$tid.'&_course_id='.$_course_id); exit; } if (!is_array($_POST['questions']) || !count($_POST['questions'])) { $msg->addError('NO_QUESTIONS_SELECTED'); header('Location: add_test_questions.php?tid='.$tid.'&_course_id='.$_course_id); require_once(TR_INCLUDE_PATH.'footer.inc.php'); exit; } require_once(TR_INCLUDE_PATH.'header.inc.php'); foreach ($_POST['questions'] as $id => $cat_array) { foreach ($cat_array as $idx => $q) { $_POST['questions'][$id][$idx] = intval($q); $questions[] = intval($q); } } $rows = $testsQuestionsDAO->getByQuestionIDs($questions); $questions = ''; if (is_array($rows)) { foreach ($rows as $row) { $questions .= '

'.htmlspecialchars($row['question']).'

'; $questions_array['questions['.$row['question_id'].']'] = $row['question_id']; } } $questions_array['tid'] = $_POST['tid']; $questions_array['_course_id'] = $_course_id; $msg->addConfirm(array('ADD_TEST_QUESTIONS', $questions), $questions_array); $msg->printConfirm(); ?>