function quiz_update_quiz_question_relationship in Quiz 6.4

Same name and namespace in other branches

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

Copies quiz-question relation entries in the quiz_node_relationship table from an old version of a quiz to a new.

Parameters

$old_quiz_vid: The quiz vid prior to a new revision.

$new_quiz_vid: The quiz vid of the latest revision.

$quiz_nid: The quiz node id.

Related topics

1 call to quiz_update_quiz_question_relationship()

quiz_update in ./quiz.module

Implementation of hook_update().

File

./quiz.module, line 1639

Quiz Module

Code

function quiz_update_quiz_question_relationship($old_quiz_vid, $new_quiz_vid, $quiz_nid) {
  $sql = "INSERT INTO {quiz_node_relationship} (parent_nid, parent_vid, child_nid, child_vid, question_status, weight, max_score)\n          SELECT src.parent_nid, %d, src.child_nid, src.child_vid, src.question_status, src.weight, src.max_score\n          FROM {quiz_node_relationship} AS src\n          WHERE src.parent_vid = %d AND src.parent_nid = %d AND src.question_status != %d";
  db_query($sql, $new_quiz_vid, $old_quiz_vid, $quiz_nid, QUESTION_NEVER);
  $sql = "INSERT INTO {quiz_terms} (nid, vid, tid, weight, max_score, number)\n          SELECT qt.nid, %d, qt.tid, qt.weight, qt.max_score, qt.number\n          FROM {quiz_terms} qt\n          WHERE qt.vid = %d";
  db_query($sql, $new_quiz_vid, $old_quiz_vid);
}