function QuestionsImportTestCase::getQuizQuestionList in Quiz 6.6

Parameters

$quiz_nid_id:

Return value

array of question fields: nid, vid, body, type

1 call to QuestionsImportTestCase::getQuizQuestionList()

QuestionsImportTestCase::quizHelper in includes/questions_import/questions_import.test

Loads a quiz and checks that it is behaving properly

File

includes/questions_import/questions_import.test, line 57

Class

QuestionsImportTestCase

Code

function getQuizQuestionList($quiz_nid) {
  $db_questions = array();

  // question nid, question prompt (body), type
  $sql = "SELECT nr.nid, nr.vid, nr.body, n.type FROM {node_revisions} nr\nJOIN {quiz_node_relationship} qnr ON qnr.child_nid = nr.nid\nJOIN {node} n ON n.nid = nr.nid\nWHERE parent_nid = %d\nORDER BY n.nid";

  // FIXME shouldn't this be by qnr.weight?  how are questions ordered in a quiz?
  $result = db_query($sql, $quiz_nid);
  while ($question_node = db_fetch_array($result)) {
    $db_questions[] = $question_node;
  }
  return $db_questions;
}