function long_answer_get_all_unscored_answers in Quiz 6.5

Same name and namespace in other branches

1. 8.4 question_types/long_answer/long_answer.module \long_answer_get_all_unscored_answers()
2. 6.6 question_types/long_answer/long_answer.module \long_answer_get_all_unscored_answers()
3. 6.3 question_types/long_answer/long_answer.module \long_answer_get_all_unscored_answers()
4. 6.4 question_types/long_answer/long_answer.module \long_answer_get_all_unscored_answers()
5. 7.6 question_types/long_answer/long_answer.module \long_answer_get_all_unscored_answers()
6. 7 question_types/long_answer/long_answer.module \long_answer_get_all_unscored_answers()
7. 7.4 question_types/long_answer/long_answer.module \long_answer_get_all_unscored_answers()

Get all quiz scores that have not yet been evaluated.

Parameters

$count: Number of items to return (default: 50).

$offset: Where in the results we should start (default: 0).

Return value

Array of objects describing unanswered questions. Each object will have result_id, question_nid, and question_vid.

3 calls to long_answer_get_all_unscored_answers()

LongAnswerUnitTest::unitTestGetUnscoredAnswers in question_types/long_answer/long_answer.test

LongAnswerUnitTest::unitTestScoreAnswer in question_types/long_answer/long_answer.test

Test modifying (scoring) an answer.

long_answer_view_unscored in question_types/long_answer/long_answer.admin.inc

Generate a view of all unscored answer questions.

File

question_types/long_answer/long_answer.module, line 252

This module defines a long answer question type for quizzes.

Code

function long_answer_get_all_unscored_answers($count = 50, $offset = 0) {
  $sql = 'SELECT a.result_id, a.question_nid, a.question_vid, r.title, n.time_end, n.time_start, n.uid
    FROM {quiz_long_answer_user_answers} AS a
    INNER JOIN {node_revisions} AS r ON a.question_vid = r.vid
    INNER JOIN {quiz_node_results} AS n ON a.result_id = n.result_id
    WHERE is_evaluated = 0';
  $results = db_query_range($sql, $offset, $count);
  $unscored = array();
  if ($results) {
    while ($row = db_fetch_object($results)) {
      $unscored[] = $row;
    }
  }
  return $unscored;
}