function short_answer_get_answer in Quiz 8.4

Same name and namespace in other branches

1. 6.6 question_types/short_answer/short_answer.module \short_answer_get_answer()
2. 6.3 question_types/short_answer/short_answer.module \short_answer_get_answer()
3. 6.4 question_types/short_answer/short_answer.module \short_answer_get_answer()
4. 6.5 question_types/short_answer/short_answer.module \short_answer_get_answer()
5. 7.6 question_types/short_answer/short_answer.module \short_answer_get_answer()
6. 7 question_types/short_answer/short_answer.module \short_answer_get_answer()
7. 7.4 question_types/short_answer/short_answer.module \short_answer_get_answer()

Get the answer for a question.

This stores a score for a short answer question and marks that question as having been evaluated.

Parameters

$question_nid: Node ID of question.

$question_vid: Version ID of question.

$result_id: Result ID for the quiz results.

Return value

Assoc array An array if successful, or FALSE if no result could be found. The array contains the following properties: <code> answer_id; // The answer ID answer; // The full text of the answer is_evaluated; // 0 if the question has not been evaluated, 1 if it has score; // The score the evaluator gave the user; this should be 0 if is_evaluated is 0. question_vid question_nid result_id </code>

1 call to short_answer_get_answer()

short_answer_edit_score in question_types/short_answer/short_answer.admin.inc

Page handler for displaying a scoring form. This function is called directly from the menu router. It generates a form for scoring a quiz.

File

question_types/short_answer/short_answer.module, line 234

The main file for short_answer.

Code

function short_answer_get_answer($question_nid, $question_vid, $result_id) {
  $results = db_query('SELECT sa.answer_id, sa.answer, sa.is_evaluated, sa.score, sa.question_vid, sa.question_nid, sa.result_id, sa.answer_feedback, rel.max_score AS rel_max_score
    FROM {quiz_short_answer_user_answers} sa
    JOIN {quiz_node_results} qnr ON (sa.result_id = qnr.result_id)
    JOIN {quiz_node_relationship} rel ON (qnr.vid = rel.parent_vid AND rel.child_vid = sa.question_vid)
    WHERE sa.question_nid = :qnid AND sa.question_vid = :qvid AND sa.result_id = :rid', array(
    ':qnid' => $question_nid,
    ':qvid' => $question_vid,
    ':rid' => $result_id,
  ))
    ->fetchAssoc();
  return $results ? $results : FALSE;
}