function quiz_question_list_questions in Quiz 7

Same name and namespace in other branches

1. 8.4 question_types/quiz_question/quiz_question.module \quiz_question_list_questions()
2. 6.6 question_types/quiz_question/quiz_question.module \quiz_question_list_questions()
3. 6.3 question_types/quiz_question/quiz_question.module \quiz_question_list_questions()
4. 6.4 question_types/quiz_question/quiz_question.module \quiz_question_list_questions()
5. 6.5 question_types/quiz_question/quiz_question.module \quiz_question_list_questions()
6. 7.4 question_types/quiz_question/quiz_question.module \quiz_question_list_questions()

Implements hook_list_questions().

File

question_types/quiz_question/quiz_question.module, line 266

Quiz Question module. This module provides the basic facilities for adding quiz question types to a quiz.

Code

function quiz_question_list_questions($count = 0, $offset = 0) {
  $query = db_select('node', 'n')
    ->fields('n', array(
    'nid',
    'vid',
  ))
    ->innerjoin('node_revision', 'nr')
    ->condition('type', array_keys(_quiz_question_get_implementations()), 'IN')
    ->execute();

  /*
  $sql = "SELECT n.nid, n.vid, r.body, r.format FROM {node} AS n
    INNER JOIN {node_revision} AS r USING(vid)
    WHERE n.type IN (%s) ORDER BY n.type, n.changed";
  $types = array();
  foreach (array_keys(_quiz_question_get_implementations()) as $key) {
    $types[] = "'" . $key . "'";
  }
  $type = implode(',', $types);

  if ($count == 0) {
    // Return all results
    // TODO Please convert this statement to the D7 database API syntax.
    $result = db_query(db_rewrite_sql($sql), $type);
  }
  else {
    // return only $count results
    // TODO Please convert this statement to the D7 database API syntax.
    $result = db_query_range(db_rewrite_sql($sql), $type);
  }
  */
  $questions = array();
  while ($question = $query
    ->fetch()) {
    $question->question = check_markup($question->body, $question->format, $langcode = '', FALSE);
    $questions[] = $question;
  }
  return $questions;
}