2 /************************************************************************/
4 /************************************************************************/
5 /* Copyright (c) 2010 */
6 /* Inclusive Design Institute */
8 /* This program is free software. You can redistribute it and/or */
9 /* modify it under the terms of the GNU General Public License */
10 /* as published by the Free Software Foundation. */
11 /************************************************************************/
13 define('TR_INCLUDE_PATH', '../include/');
14 require_once(TR_INCLUDE_PATH.'vitals.inc.php');
15 require_once(TR_INCLUDE_PATH.'lib/test_question_queries.inc.php');
16 require_once(TR_INCLUDE_PATH.'classes/DAO/TestsQuestionsDAO.class.php');
17 require_once(TR_INCLUDE_PATH.'classes/Utility.class.php');
21 Utility::authenticate(TR_PRIV_ISAUTHOR_OF_CURRENT_COURSE);
22 $testsQuestionsDAO = new TestsQuestionsDAO();
24 if (isset($_POST['cancel'])) {
25 $msg->addFeedback('CANCELLED');
26 header('Location: question_db.php?_course_id='.$_course_id);
28 } else if ($_POST['submit']) {
29 $_POST['feedback'] = trim($_POST['feedback']);
30 $_POST['instructions'] = trim($_POST['instructions']);
31 $_POST['category_id'] = intval($_POST['category_id']);
33 for ($i = 0 ; $i < 10; $i++) {
34 $_POST['question'][$i] = $addslashes(trim($_POST['question'][$i]));
35 $_POST['question_answer'][$i] = (int) $_POST['question_answer'][$i];
36 $_POST['answer'][$i] = $addslashes(trim($_POST['answer'][$i]));
39 if (!$_POST['question'][0]
40 || !$_POST['question'][1]
41 || !$_POST['answer'][0]
42 || !$_POST['answer'][1]) {
44 $msg->addError('QUESTION_EMPTY');
48 if (!$msg->containsErrors()) {
49 $_POST['feedback'] = $addslashes($_POST['feedback']);
50 $_POST['instructions'] = $addslashes($_POST['instructions']);
52 $sql_params = array( $_POST['category_id'],
55 $_POST['instructions'],
56 $_POST['question'][0],
57 $_POST['question'][1],
58 $_POST['question'][2],
59 $_POST['question'][3],
60 $_POST['question'][4],
61 $_POST['question'][5],
62 $_POST['question'][6],
63 $_POST['question'][7],
64 $_POST['question'][8],
65 $_POST['question'][9],
66 $_POST['question_answer'][0],
67 $_POST['question_answer'][1],
68 $_POST['question_answer'][2],
69 $_POST['question_answer'][3],
70 $_POST['question_answer'][4],
71 $_POST['question_answer'][5],
72 $_POST['question_answer'][6],
73 $_POST['question_answer'][7],
74 $_POST['question_answer'][8],
75 $_POST['question_answer'][9],
87 $sql = vsprintf(TR_SQL_QUESTION_MATCHINGDD, $sql_params);
89 if ($testsQuestionsDAO->execute($sql)) {
90 $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
91 header('Location: question_db.php?_course_id='.$_course_id);
97 // for matching test questions
98 $_letters = array(_AT('a'), _AT('b'), _AT('c'), _AT('d'), _AT('e'), _AT('f'), _AT('g'), _AT('h'), _AT('i'), _AT('j'));
100 $onload = 'document.form.category_id.focus();';
102 require_once(TR_INCLUDE_PATH.'header.inc.php');
104 $savant->assign('letters', $_letters);
105 $savant->assign('course_id', $_course_id);
106 $savant->display('tests/create_edit_question_matchingdd.tmpl.php');
108 require (TR_INCLUDE_PATH.'footer.inc.php'); ?>