/mods/_standard/tests/take_test_q.php
PHP | 282 lines | 187 code | 51 blank | 44 comment | 58 complexity | 2a9db9520d4a865e4a3d33490b3aa495 MD5 | raw file
- <?php
- /****************************************************************/
- /* ATutor */
- /****************************************************************/
- /* Copyright (c) 2002-2010 */
- /* Inclusive Design Institute */
- /* http://atutor.ca */
- /* */
- /* This program is free software. You can redistribute it and/or*/
- /* modify it under the terms of the GNU General Public License */
- /* as published by the Free Software Foundation. */
- /****************************************************************/
- // $Id$
- define('AT_INCLUDE_PATH', '../../../include/');
- require(AT_INCLUDE_PATH.'vitals.inc.php');
- require(AT_INCLUDE_PATH.'../mods/_standard/tests/lib/test_result_functions.inc.php');
- require(AT_INCLUDE_PATH.'../mods/_standard/tests/classes/testQuestions.class.php');
- $tid = intval($_REQUEST['tid']);
- if (isset($_REQUEST['cid']))
- {
- $cid = intval($_REQUEST['cid']);
- $cid_url = SEP.'cid='.$cid;
- }
- if (isset($_REQUEST['gid']))
- $mid = $addslashes($_REQUEST['gid']);
- else
- $mid = $_SESSION['member_id'];
- //make sure max attempts not reached, and still on going
- $sql = "SELECT *, UNIX_TIMESTAMP(start_date) AS start_date, UNIX_TIMESTAMP(end_date) AS end_date FROM ".TABLE_PREFIX."tests WHERE test_id=".$tid." AND course_id=".$_SESSION['course_id'];
- $result= mysql_query($sql, $db);
- $test_row = mysql_fetch_assoc($result);
- /* check to make sure we can access this test: */
- if (!$test_row['guests'] && ($_SESSION['enroll'] == AT_ENROLL_NO || $_SESSION['enroll'] == AT_ENROLL_ALUMNUS)) {
- require(AT_INCLUDE_PATH.'header.inc.php');
- $msg->printInfos('NOT_ENROLLED');
- require(AT_INCLUDE_PATH.'footer.inc.php');
- exit;
- }
- if (!$test_row['guests'] && !authenticate_test($tid)) {
- header('Location: '.url_rewrite('mods/_standard/tests/my_tests.php', AT_PRETTY_URL_IS_HEADER));
- exit;
- }
- // checks one/all questions per page, and forward user to the correct one
- if (!$test_row['display']) {
- header('Location: '.url_rewrite('mods/_standard/tests/take_test.php?tid='.$tid.$cid_url, AT_PRETTY_URL_IS_HEADER));
- }
- $out_of = $test_row['out_of'];
- $sql = "SELECT COUNT(*) AS num_questions FROM ".TABLE_PREFIX."tests_questions_assoc WHERE test_id=$tid";
- $result = mysql_query($sql, $db);
- $row = mysql_fetch_assoc($result);
- if (!$test_row['random'] || $test_row['num_questions'] > $row['num_questions']) {
- $test_row['num_questions'] = $row['num_questions'];
- }
- $sql = "SELECT COUNT(*) AS cnt FROM ".TABLE_PREFIX."tests_results WHERE status=1 AND test_id=".$tid." AND member_id='".$mid."'";
- $takes_result= mysql_query($sql, $db) or die(mysql_error());
- $takes = mysql_fetch_assoc($takes_result);
- if ( (($test_row['start_date'] > time()) || ($test_row['end_date'] < time())) ||
- ( ($test_row['num_takes'] != AT_TESTS_TAKE_UNLIMITED) && ($takes['cnt'] >= $test_row['num_takes']) ) ) {
- require(AT_INCLUDE_PATH.'header.inc.php');
- $msg->printInfos('MAX_ATTEMPTS');
- require(AT_INCLUDE_PATH.'footer.inc.php');
- exit;
- }
- if (!isset($_GET['pos'])) {
- $pos = 0; // first question
- } else {
- $pos = abs($_GET['pos']);
- }
- $max_pos = 0;
- // get and check for a valid result_id. if there is none then get all the questions and insert them as in progress.
- // note: for guests without guest information, the result_id is stored in session, but no need to really know that here;
- // for guests with guest information, always start a new test.
- if (isset($_REQUEST['gid']))
- $result_id = 0;
- else
- $result_id = get_test_result_id($tid, $max_pos);
-
- // set position to allow users to return to a test they have partially completed, and continue from where they left of.
- if (!isset($_GET['pos']) && $result_id > 0)
- {
- $sql = "SELECT COUNT(*) total_questions FROM ".TABLE_PREFIX."tests_answers WHERE result_id = ". $result_id;
- $total_result = mysql_query($sql, $db) or die(mysql_error());
- $total = mysql_fetch_assoc($total_result);
-
- $sql = "SELECT COUNT(*) pos FROM ".TABLE_PREFIX."tests_answers WHERE result_id = ". $result_id ." AND answer <> ''";
- $answer_result = mysql_query($sql, $db) or die(mysql_error());
- $answer = mysql_fetch_assoc($answer_result);
- // if user answered all the questions without cliking last "next" button, resume test at the last question
- $pos = ($total['total_questions'] == $answer['pos']) ? (--$answer['pos']) : $answer['pos'];
- }
- if ($result_id == 0) {
- // there is no test in progress, yet.
- // init this test.
- // simple safety op to make sure nothing is being posted (as it shouldn't!)
- // $_POST = array(); // don't need this because of the else-if
- // basically, shouldn't be able to post to this page if there isn't a valid result_id first (how can someone post an answer
- // to a question they haven't viewed? [unless they're trying to 'hack' something])
- $result_id = init_test_result_questions($tid, (bool) $test_row['random'], $test_row['num_questions'], $mid);
- if (!$_SESSION['member_id']) {
- // this is a guest, so we store the result_id in SESSION
- $_SESSION['test_result_id'] = $result_id;
- }
- $pos = 0; // force to always start at the first question
-
- } else if (isset($_POST['next']) || isset($_POST['previous'])) {
- // if the test isn't time limited, then what happens when only a few questions are answered? the test result
- // will be inconsistant.
- // need to keep track of the max(pos) answered, so that we know if a question is being re-answered.
- // store 'max_pos' in session or db or form?
- // assuming only one question is displayed
- $question_id = intval(key($_POST['answers']));
- // get the old score (incase this question is being re-answered)
- $sql = "SELECT score FROM ".TABLE_PREFIX."tests_answers WHERE result_id=$result_id AND question_id=$question_id";
- $result = mysql_query($sql, $db);
- $row = mysql_fetch_assoc($result);
- $old_score = $row['score'];
- $score = 0;
- $sql = "SELECT TQA.weight, TQA.question_id, TQ.type, TQ.answer_0, TQ.answer_1, TQ.answer_2, TQ.answer_3, TQ.answer_4, TQ.answer_5, TQ.answer_6, TQ.answer_7, TQ.answer_8, TQ.answer_9 FROM ".TABLE_PREFIX."tests_questions_assoc TQA INNER JOIN ".TABLE_PREFIX."tests_questions TQ USING (question_id) WHERE TQA.test_id=$tid AND TQA.question_id=$question_id";
- $result = mysql_query($sql, $db);
- if ($row = mysql_fetch_assoc($result)) {
- if (isset($_POST['answers'][$row['question_id']])) {
- $obj = TestQuestions::getQuestion($row['type']);
- $score = $obj->mark($row);
- $sql = "UPDATE ".TABLE_PREFIX."tests_answers SET answer='{$_POST[answers][$row[question_id]]}', score='$score' WHERE result_id=$result_id AND question_id=$row[question_id]";
- mysql_query($sql, $db);
-
- if (is_null($score) && $test_row['result_release']==AT_RELEASE_MARKED)
- $_REQUEST['efs'] = 1; // set final score to empty if there's any unmarked question and release option is "once quiz submitted and all questions are marked"
- }
- }
- $pos++;
- if ($_REQUEST['efs']) // set final score to empty if there's any unmarked question and release option is "once quiz submitted and all questions are marked"
- {
- $sql = "UPDATE ".TABLE_PREFIX."tests_results SET final_score=null, date_taken=date_taken, end_time=NOW(), max_pos=$pos WHERE result_id=$result_id";
- $result = mysql_query($sql, $db);
- }
- // update the final score
- // update status to complate to fix refresh test issue.
- else if ($pos > $max_pos) {
- $sql = "UPDATE ".TABLE_PREFIX."tests_results SET final_score=final_score + $score, date_taken=date_taken, end_time=NOW(), max_pos=$pos WHERE result_id=$result_id";
- $result = mysql_query($sql, $db);
- } else {
- // this question has already been answered, so we have to re-mark it, which means finding the OLD score for this question and adjusting
- // $score with the positive or negative difference.
- // no need to update max_pos b/c we're only updating a previously answered question.
- $score = $old_score - $score;
- $sql = "UPDATE ".TABLE_PREFIX."tests_results SET final_score=final_score - $score, date_taken=date_taken, end_time=NOW() WHERE result_id=$result_id";
- $result = mysql_query($sql, $db);
- }
- if (isset($_POST['previous'])) {
- $pos-=2;
- if ($pos < 0) {
- $pos = 0;
- }
- }
- if ($pos >= $test_row['num_questions']) {
- // end of the test.
- $sql = "UPDATE ".TABLE_PREFIX."tests_results SET status=1, date_taken=date_taken, end_time=NOW() WHERE result_id=$result_id";
- $result = mysql_query($sql, $db);
- $msg->addFeedback('ACTION_COMPLETED_SUCCESSFULLY');
- if ((!$_SESSION['enroll'] && !isset($cid)) || $test_row['result_release']==AT_RELEASE_IMMEDIATE) {
- header('Location: '.url_rewrite('mods/_standard/tests/view_results.php?tid='.$tid.SEP.'rid='.$result_id.$cid_url, AT_PRETTY_URL_IS_HEADER));
- exit;
- }
-
- if (isset($cid)) header('Location: '.url_rewrite('content.php?cid='.$cid, AT_PRETTY_URL_IS_HEADER));
- else header('Location: '.url_rewrite('mods/_standard/tests/my_tests.php', AT_PRETTY_URL_IS_HEADER));
- exit;
- } // else:
-
- header('Location: '.url_rewrite('mods/_standard/tests/take_test_q.php?tid='.$tid.SEP.'pos='.$pos.SEP.'efs='.$_REQUEST['efs'].$cid_url, AT_PRETTY_URL_IS_HEADER));
- exit;
- }
- if (defined('AT_FORCE_GET_FILE') && AT_FORCE_GET_FILE) {
- $content_base_href = 'get.php/';
- } else {
- $course_base_href = 'content/' . $_SESSION['course_id'] . '/';
- }
- require(AT_INCLUDE_PATH.'header.inc.php');
- /* Retrieve the content_id of this test */
- $num_questions = $test_row['num_questions'];
- $content_id = $test_row['content_id'];
- $anonymous = $test_row['anonymous'];
- $instructions = $test_row['instructions'];
- $title = $test_row['title'];
- $_letters = array(_AT('A'), _AT('B'), _AT('C'), _AT('D'), _AT('E'), _AT('F'), _AT('G'), _AT('H'), _AT('I'), _AT('J'));
- // this is a kludge to get the question number incremented.
- // a diff approach could be to pass the position to the display() method.
- for ($i = 0; $i < $pos; $i++) {
- TestQuestionCounter(true);
- }
- // retrieve the test questions that were saved to `tests_answers`
- if ($test_row['random']) {
- $sql = "SELECT R.*, A.*, Q.* FROM ".TABLE_PREFIX."tests_answers R INNER JOIN ".TABLE_PREFIX."tests_questions_assoc A USING (question_id) INNER JOIN ".TABLE_PREFIX."tests_questions Q USING (question_id) WHERE R.result_id=$result_id AND A.test_id=$tid ORDER BY Q.question_id LIMIT $pos, 1";
- } else {
- $sql = "SELECT R.*, A.*, Q.* FROM ".TABLE_PREFIX."tests_answers R INNER JOIN ".TABLE_PREFIX."tests_questions_assoc A USING (question_id) INNER JOIN ".TABLE_PREFIX."tests_questions Q USING (question_id) WHERE R.result_id=$result_id AND A.test_id=$tid ORDER BY A.ordering, Q.question_id LIMIT $pos, 1";
- }
- $result = mysql_query($sql, $db);
- $question_row = mysql_fetch_assoc($result);
- if (!$result || !$question_row) {
- echo '<p>'._AT('no_questions').'</p>';
- require(AT_INCLUDE_PATH.'footer.inc.php');
- exit;
- }
- ?>
- <form method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>?pos=<?php echo $pos; ?>">
- <input type="hidden" name="tid" value="<?php echo $tid; ?>" />
- <?php if (isset($_REQUEST['cid'])) {?> <input type="hidden" name="cid" value="<?php echo $cid; ?>" /> <?php }?>
- <div class="input-form" style="width:95%">
- <fieldset class="group_form"><legend class="group_form"><?php echo $title ?> (<?php echo _AT('question').' '. ($pos+1).'/'.$test_row['num_questions']; ?>)</legend>
- <?php if ($_REQUEST['efs']){?>
- <input type="hidden" name="efs" value=<?php echo $_REQUEST['efs']; ?> />
- <?php }?>
-
- <?php
- // retrieve the answer to re-populate the form (so we can edit our answer)
- $sql = "SELECT answer FROM ".TABLE_PREFIX."tests_answers WHERE result_id=$result_id AND question_id=$question_row[question_id]";
- $result = mysql_query($sql, $db);
- $row = mysql_fetch_assoc($result);
-
- $obj = TestQuestions::getQuestion($question_row['type']);
- $obj->display($question_row, $row['answer']);
- ?>
- <div class="row buttons">
- <div style="display:none"><input type="submit" value="<?php echo _AT('next'); ?>" name="next"/></div>
- <?php if ($pos > 0): ?>
- <input type="submit" name="previous" value="<?php echo _AT('previous'); ?>" />
- <?php endif; ?>
- <?php if (($pos+1) == $test_row['num_questions']): ?>
- <input type="submit" name="next" value="<?php echo _AT('submit'); ?>" accesskey="s" onclick="confirmSubmit(this, '<?php echo $addslashes(_AT("test_confirm_submit")); ?>'); return false;"/>
- <?php else: ?>
- <input type="submit" name="next" value="<?php echo _AT('next'); ?>" accesskey="s" />
- <?php endif; ?>
- </div>
- </fieldset>
- </div>
- </form>
- <script type="text/javascript" src="<?php echo $_base_href;?>/mods/_standard/tests/lib/take_test.js">
- <?php require(AT_INCLUDE_PATH.'footer.inc.php'); ?>