function _quiz_get_random_questions in Quiz 7.5

Same name and namespace in other branches

1. 8.4 quiz.module \_quiz_get_random_questions()
2. 5.2 quiz.module \_quiz_get_random_questions()
3. 6.6 quiz.module \_quiz_get_random_questions()
4. 6.2 quiz.module \_quiz_get_random_questions()
5. 6.3 quiz.module \_quiz_get_random_questions()
6. 6.4 quiz.module \_quiz_get_random_questions()
7. 6.5 quiz.module \_quiz_get_random_questions()
8. 7.6 quiz.module \_quiz_get_random_questions()
9. 7 quiz.module \_quiz_get_random_questions()
10. 7.4 quiz.module \_quiz_get_random_questions()

Get an array list of random questions for a quiz.

Parameters

$quiz: The quiz node.

Return value

Array of nid/vid combos for quiz questions.

1 call to _quiz_get_random_questions()

quiz_build_question_list in ./quiz.module

Retrieves a list of questions (to be taken) for a given quiz.

File

./quiz.module, line 2774

quiz.module Main file for the Quiz module.

Code

function _quiz_get_random_questions($quiz) {
  $num_random = $quiz->number_of_random_questions;
  $questions = array();
  if ($num_random > 0) {

    // Select random question from assigned pool.
    $result = db_query_range("SELECT child_nid as nid, child_vid as vid, n.type\n      FROM {quiz_node_relationship} qnr\n      JOIN {node} n on qnr.child_nid = n.nid\n      WHERE qnr.parent_vid = :parent_vid\n      AND qnr.parent_nid = :parent_nid\n      AND qnr.question_status = :question_status\n      AND n.status = 1\n      ORDER BY RAND()", 0, $quiz->number_of_random_questions, array(
      ':parent_vid' => $quiz->vid,
      ':parent_nid' => $quiz->nid,
      ':question_status' => QUIZ_QUESTION_RANDOM,
    ));
    while ($question_node = $result
      ->fetchAssoc()) {
      $question_node['random'] = TRUE;
      $question_node['relative_max_score'] = $quiz->max_score_for_random;
      $questions[] = $question_node;
    }
  }
  return $questions;
}