function multichoice_list_questions in Quiz 6.6

Same name and namespace in other branches

1. 5.2 multichoice.module \multichoice_list_questions()
2. 5 multichoice.module \multichoice_list_questions()
3. 6.2 multichoice.module \multichoice_list_questions()
4. 6.3 question_types/multichoice/multichoice.module \multichoice_list_questions()
5. 6.5 question_types/multichoice/multichoice.module \multichoice_list_questions()

List all multiple choice questions.

Return value

Array of questions.

File

question_types/multichoice/multichoice.module, line 1088

Multiple choice question type for the Quiz module.

Code

function multichoice_list_questions() {
  $sql = "SELECT n.nid, n.vid, r.body, r.format\n    FROM {node} AS n\n    INNER JOIN {node_revisions} AS r USING(vid)\n    WHERE n.type = '%s' ORDER BY n.changed";

  // Old query: "SELECT nid, body, format FROM {node} WHERE type = '%s'"
  $result = db_query($sql, 'multichoice');
  $questions = array();
  while ($node = db_fetch_object($result)) {
    $question = new stdClass();
    $question->question = check_markup($node->body, $node->format, FALSE);
    $question->nid = $node->nid;
    $questions[] = $question;
  }
  return $questions;
}