function _quiz_get_random_questions in Quiz 7.6

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 quiz.module \_quiz_get_random_questions()
9. 7.4 quiz.module \_quiz_get_random_questions()
10. 7.5 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 2902

quiz.module Main file for the Quiz module.

Code

function _quiz_get_random_questions($quiz) {
  $num_random = $quiz->number_of_random_questions;
  $tid = $quiz->tid;
  $questions = array();
  if ($num_random > 0) {
    if ($tid > 0) {
      $questions = _quiz_get_random_taxonomy_question_ids($tid, $num_random);
    }
    else {

      // 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;
}