quiz.install in Quiz 5.2

File

quiz.install

<?php

/**
 * Implementation of hook_install()
 */
function quiz_install() {
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':

      /**
       * Connect all the quiz specific properties to the correct version of a quiz.
       */

      // Create the quiz node properties table
      db_query("CREATE TABLE {quiz_node_properties} (\n          property_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n          vid INTEGER UNSIGNED NOT NULL,\n          nid INTEGER UNSIGNED NOT NULL,\n          number_of_random_questions TINYINT UNSIGNED DEFAULT 0 NOT NULL,\n          pass_rate TINYINT UNSIGNED NOT NULL,\n          summary_pass LONGTEXT,\n          summary_default LONGTEXT,\n          shuffle TINYINT UNSIGNED NOT NULL,\n          backwards_navigation TINYINT UNSIGNED NOT NULL,\n          feedback_time TINYINT UNSIGNED NOT NULL,\n          quiz_open INTEGER UNSIGNED DEFAULT 0,\n          quiz_close INTEGER UNSIGNED DEFAULT 0,\n          takes TINYINT UNSIGNED NOT NULL,\n          time_limit INTEGER UNSIGNED DEFAULT 0 NOT NULL,\n          quiz_always TINYINT NOT NULL DEFAULT 0,\n          tid INTEGER UNSIGNED NOT NULL DEFAULT 0,\n          PRIMARY KEY(property_id),\n          KEY vid (vid, nid)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Both a quiz and a quiz question are nodes with versions.  A quiz is a parent node of a quiz question,
       * making the quiz question the child.
       *
       * The quiz_node_relationship table stores this relationship in a way that allows a quiz question to be
       * the child of multiple quizzes without losing version history.
       *
       * Future functionality will allow a quiz question to be a parent of another quiz question with the same
       * data model.  This will make adaptive quiz functionality possible without redesign.
       */

      // Create the quiz node relationship table
      db_query("CREATE TABLE {quiz_node_relationship} (\n          parent_nid INTEGER UNSIGNED NOT NULL,\n          parent_vid INTEGER UNSIGNED NOT NULL,\n          child_nid INTEGER UNSIGNED NOT NULL,\n          child_vid INTEGER UNSIGNED NOT NULL,\n          question_status TINYINT UNSIGNED DEFAULT 1 NOT NULL,\n          PRIMARY KEY(parent_nid, parent_vid, child_nid, child_vid)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * This connects all the quiz question specific properties to the correct version of a quiz question.
       */

      // Create the quiz node question properties table
      db_query("CREATE TABLE {quiz_node_question_properties} (\n          nid INTEGER UNSIGNED NOT NULL,\n          vid INTEGER UNSIGNED NOT NULL,\n          number_of_answers TINYINT UNSIGNED DEFAULT 1 NOT NULL\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Quiz specific options concerning  availability and access to scores.
       */

      // Create the quiz node results table
      db_query("CREATE TABLE {quiz_node_results} (\n          result_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n          nid INTEGER UNSIGNED NOT NULL,\n          vid INTEGER UNSIGNED NOT NULL,\n          uid INTEGER UNSIGNED NOT NULL,\n          time_start INTEGER UNSIGNED DEFAULT 0,\n          time_end INTEGER UNSIGNED DEFAULT 0,\n          released INTEGER UNSIGNED DEFAULT 0,\n          score TINYINT NOT NULL DEFAULT 0,\n          PRIMARY KEY(result_id)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Information about a particular question in a result
       */
      db_query("CREATE TABLE {quiz_node_results_answers} (\n          result_id INT UNSIGNED NOT NULL ,\n          question_nid INT UNSIGNED NOT NULL ,\n          question_vid INT UNSIGNED NOT NULL ,\n          is_correct TINYINT UNSIGNED NOT NULL DEFAULT '0',\n          points_awarded TINYINT NOT NULL DEFAULT '0',\n          answer_timestamp INT UNSIGNED NOT NULL,\n          PRIMARY KEY(result_id, question_nid, question_vid)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Allows custom feedback based on the results of a user completing a quiz.
       */

      // Create the quiz node result options table
      db_query("CREATE TABLE {quiz_node_result_options} (\n          option_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n          nid INTEGER UNSIGNED NOT NULL,\n          vid INTEGER UNSIGNED NOT NULL,\n          option_name VARCHAR(255) NOT NULL,\n          option_summary LONGTEXT,\n          option_start INTEGER UNSIGNED DEFAULT 0,\n          option_end INTEGER UNSIGNED DEFAULT 0,\n          PRIMARY KEY(option_id)\n        ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      break;
    case 'pgsql':

      /**
       * Connect all the quiz specific properties to the correct version of a quiz.
       */

      // Create the quiz node properties table
      db_query("CREATE TABLE {quiz_node_properties} (\n          property_id SERIAL,\n          vid int_unsigned NOT NULL,\n          nid int_unsigned NOT NULL,\n          number_of_random_questions smallint_unsigned DEFAULT 0 NOT NULL,\n          pass_rate smallint_unsigned NOT NULL,\n          summary_pass TEXT,\n          summary_default TEXT,\n          shuffle smallint_unsigned NOT NULL,\n          backwards_navigation smallint_unsigned NOT NULL,\n          feedback_time smallint_unsigned NOT NULL,\n          quiz_open int_unsigned DEFAULT 0,\n          quiz_close int_unsigned DEFAULT 0,\n          takes smallint_unsigned NOT NULL,\n          time_limit int_unsigned DEFAULT 0 NOT NULL,\n          quiz_always smallint NOT NULL DEFAULT 0,\n          tid int_unsigned NOT NULL DEFAULT 0,\n          PRIMARY KEY(property_id)\n        );");
      db_query("CREATE INDEX idx_{quiz_node_properties}_vidnid ON {quiz_node_properties}(vid, nid);");

      /**
       * Both a quiz and a quiz question are nodes with versions.  A quiz is a parent node of a quiz question,
       * making the quiz question the child.
       *
       * The quiz_node_relationship table stores this relationship in a way that allows a quiz question to be
       * the child of multiple quizzes without losing version history.
       *
       * Future functionality will allow a quiz question to be a parent of another quiz question with the same
       * data model.  This will make adaptive quiz functionality possible without redesign.
       */

      // Create the quiz node relationship table
      db_query("CREATE TABLE {quiz_node_relationship} (\n          parent_nid int_unsigned NOT NULL,\n          parent_vid int_unsigned NOT NULL,\n          child_nid int_unsigned NOT NULL,\n          child_vid int_unsigned NOT NULL,\n          question_status smallint_unsigned DEFAULT 1 NOT NULL,\n          PRIMARY KEY(parent_nid, parent_vid, child_nid, child_vid)\n        );");

      /**
       * This connects all the quiz question specific properties to the correct version of a quiz question.
       */

      // Create the quiz node question properties table
      db_query("CREATE TABLE {quiz_node_question_properties} (\n          nid int_unsigned NOT NULL,\n          vid int_unsigned NOT NULL,\n          number_of_answers smallint_unsigned DEFAULT 1 NOT NULL\n        );");

      /**
       * Quiz specific options concerning  availability and access to scores.
       */

      // Create the quiz node results table
      db_query("CREATE TABLE {quiz_node_results} (\n          result_id SERIAL,\n          nid int_unsigned NOT NULL,\n          vid int_unsigned NOT NULL,\n          uid int_unsigned NOT NULL,\n          time_start int_unsigned DEFAULT 0,\n          time_end int_unsigned DEFAULT 0,\n          released int_unsigned DEFAULT 0,\n          score smallint NOT NULL DEFAULT 0,\n          PRIMARY KEY(result_id)\n        );");

      /**
       * Information about a particular question in a result
       */
      db_query("CREATE TABLE {quiz_node_results_answers} (\n          result_id int_unsigned NOT NULL ,\n          question_nid int_unsigned NOT NULL ,\n          question_vid int_unsigned NOT NULL ,\n          is_correct smallint_unsigned NOT NULL DEFAULT '0',\n          points_awarded smallint NOT NULL DEFAULT '0',\n          answer_timestamp int_unsigned NOT NULL,\n          PRIMARY KEY(result_id, question_nid, question_vid)\n        );");

      /**
       * Allows custom feedback based on the results of a user completing a quiz.
       */

      // Create the quiz node result options table
      db_query("CREATE TABLE {quiz_node_result_options} (\n          option_id SERIAL,\n          nid int_unsigned NOT NULL,\n          vid int_unsigned NOT NULL,\n          option_name VARCHAR(255) NOT NULL,\n          option_summary TEXT,\n          option_start int_unsigned DEFAULT 0,\n          option_end int_unsigned DEFAULT 0,\n          PRIMARY KEY(option_id)\n        );");
      db_query("CREATE FUNCTION plus_bigint_smallint_unsigned(bigint,smallint_unsigned)\n          RETURNS bigint AS 'select \$1 + \$2::bigint'\n          LANGUAGE 'sql';");
      db_query("CREATE OPERATOR + ( \n          PROCEDURE = plus_bigint_smallint_unsigned, \n          LEFTARG = bigint, \n          RIGHTARG = smallint_unsigned );");
      break;
  }

  // Default the "Show Author and Date" for quiz nodes to OFF.
  $temp_array = variable_get('theme_settings', $default);
  $temp_array['toggle_node_info_quiz'] = 0;
  variable_set('theme_settings', $temp_array);
}

/**
 * Implementation of hook_uninstall()
 */
function quiz_uninstall() {
  db_query('DROP TABLE {quiz_node_relationship}');
  db_query('DROP TABLE {quiz_node_properties}');
  db_query('DROP TABLE {quiz_node_question_properties}');
  db_query('DROP TABLE {quiz_node_results}');
  db_query('DROP TABLE {quiz_node_result_options}');
  db_query('DROP TABLE {quiz_node_results_answers}');
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':

      // delete from nodes and node_revisions
      db_query('DELETE FROM {node}, {node_revisions} USING {node} LEFT JOIN {node_revisions} USING (nid) WHERE type IN ("quiz")');
      break;
    case 'pgsql':

      // delete from nodes and node_revisions
      db_query("DELETE FROM {node_revisions} WHERE nid IN (SELECT nid FROM {node} WHERE type IN ('quiz'))");
      db_query("DELETE FROM {node} WHERE type IN ('quiz')");
      db_query("DROP OPERATOR + ( bigint, smallint_unsigned );");
      db_query("DROP FUNCTION plus_bigint_smallint_unsigned(bigint,smallint_unsigned);");
      break;
  }
  variable_del('quiz_name');
  variable_del('quiz_default_close');
  variable_del('quiz_use_passfail');
  variable_del('quiz_default_pass_rate');
}

/**
 * Implementation of hook_update_N().
 *
 */
function quiz_update_2() {
  $ret = array();

  //Use db_update to display which queries were run
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':

      /**
       * Stores correct answers for multichoice quiz.
       */

      // Creates the quiz node user answers multichoice table.
      $ret[] = update_sql("CREATE TABLE {quiz_multichoice_user_answers} (\n        question_nid INTEGER UNSIGNED NOT NULL,\n        question_vid INTEGER UNSIGNED NOT NULL,\n        result_id INTEGER UNSIGNED NOT NULL,\n        answer_id INTEGER UNSIGNED NOT NULL,\n        PRIMARY KEY(result_id, question_nid, question_vid, answer_id)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Stores user answers for multichoice quiz.
       */

      // Creates the quiz node answers multichoice table.
      $ret[] = update_sql("CREATE TABLE {quiz_multichoice_answers} (\n        answer_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n        nid INTEGER UNSIGNED NOT NULL,\n        vid INTEGER UNSIGNED NOT NULL,\n        answer varchar(255) NOT NULL,\n        feedback LONGTEXT,\n        result_option INTEGER UNSIGNED DEFAULT 0,\n        is_correct TINYINT UNSIGNED DEFAULT 0,\n        PRIMARY KEY(answer_id)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * This connects all the quiz specific properties to the correct version of a quiz.
       */

      // Creates the quiz node properties table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_properties} (\n        property_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n        vid INTEGER UNSIGNED NOT NULL,\n        nid INTEGER UNSIGNED NOT NULL,\n        number_of_random_questions TINYINT UNSIGNED DEFAULT 0 NOT NULL,\n        pass_rate TINYINT UNSIGNED NOT NULL,\n        summary_pass LONGTEXT,\n        summary_default LONGTEXT,\n        shuffle TINYINT UNSIGNED NOT NULL,\n        backwards_navigation TINYINT UNSIGNED NOT NULL,\n        feedback_time TINYINT UNSIGNED NOT NULL,\n        quiz_open INTEGER UNSIGNED DEFAULT 0,\n        quiz_close INTEGER UNSIGNED DEFAULT 0,\n        takes TINYINT UNSIGNED NOT NULL,\n        time_limit INTEGER UNSIGNED DEFAULT 0 NOT NULL,\n        quiz_always TINYINT NOT NULL default 0,\n        tid INTEGER UNSIGNED NOT NULL DEFAULT 0,\n        PRIMARY KEY(property_id),\n        KEY vid (vid, nid)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Both a quiz and a quiz question are nodes with versions.  A quiz is a parent node of a quiz question,
       * making the quiz question the child.
       *
       * The quiz_node_relationship table stores this relationship in a way that allows a quiz question to be
       * the child of multiple quizzes without losing version history.
       *
       * Future functionality will allow a quiz question to be a parent of another quiz question with the same
       * data model.  This will make adaptive quiz functionality possible without redesign.
       */

      // Creates the quiz node relationship table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_relationship} (\n        parent_nid INTEGER UNSIGNED NOT NULL,\n        parent_vid INTEGER UNSIGNED NOT NULL,\n        child_nid INTEGER UNSIGNED NOT NULL,\n        child_vid INTEGER UNSIGNED NOT NULL,\n        question_status TINYINT UNSIGNED DEFAULT 1 NOT NULL,\n        PRIMARY KEY(parent_nid, parent_vid, child_nid, child_vid)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * This connects all the quiz question specific properties to the correct version of a quiz question.
       */

      // Creates the quiz node question properties table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_question_properties} (\n        nid INTEGER UNSIGNED NOT NULL,\n        vid INTEGER UNSIGNED NOT NULL,\n        number_of_answers TINYINT UNSIGNED DEFAULT 1 NOT NULL\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Quiz specific options concerning  availability and access to scores.
       */

      // Creates the quiz node results table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_results} (\n        result_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n        nid INTEGER UNSIGNED NOT NULL,\n        vid INTEGER UNSIGNED NOT NULL,\n        uid INTEGER UNSIGNED NOT NULL,\n        time_start INTEGER UNSIGNED DEFAULT 0,\n        time_end INTEGER UNSIGNED DEFAULT 0,\n        released INTEGER UNSIGNED DEFAULT 0,\n        score TINYINT NOT NULL DEFAULT 0,\n        PRIMARY KEY(result_id)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Information about a particular question in a result
       */
      $ret[] = update_sql("CREATE TABLE {quiz_node_results_answers} (\n        result_id INT UNSIGNED NOT NULL ,\n        question_nid INT UNSIGNED NOT NULL ,\n        question_vid INT UNSIGNED NOT NULL ,\n        is_correct TINYINT UNSIGNED NOT NULL DEFAULT '0',\n        points_awarded TINYINT NOT NULL DEFAULT '0',\n        answer_timestamp INT UNSIGNED NOT NULL,\n        PRIMARY KEY(result_id, question_nid, question_vid)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");

      /**
       * Allows custom feedback based on the results of a user completing a quiz.
       */

      // Creates the quiz node result options table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_result_options} (\n        option_id INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,\n        nid INTEGER UNSIGNED NOT NULL,\n        vid INTEGER UNSIGNED NOT NULL,\n        option_name VARCHAR(255) NOT NULL,\n        option_summary LONGTEXT,\n        option_start INTEGER UNSIGNED DEFAULT 0,\n        option_end INTEGER UNSIGNED DEFAULT 0,\n        PRIMARY KEY(option_id)\n      ) /*!40100 DEFAULT CHARACTER SET utf8 */;");
      quiz_data_update_2();
      break;
    case 'pgsql':

      /**
       * Stores correct answers for multichoice quiz.
       */

      // Creates the quiz node user answers multichoice table.
      $ret[] = update_sql("CREATE TABLE {quiz_multichoice_user_answers} (\n        question_nid int_unsigned NOT NULL,\n        question_vid int_unsigned NOT NULL,\n        result_id int_unsigned NOT NULL,\n        answer_id int_unsigned NOT NULL,\n        PRIMARY KEY(result_id, question_nid, question_vid, answer_id)\n      );");

      /**
       * Stores user answers for multichoice quiz.
       */

      // Creates the quiz node answers multichoice table.
      $ret[] = update_sql("CREATE TABLE {quiz_multichoice_answers} (\n        answer_id SERIAL,\n        nid int_unsigned NOT NULL,\n        vid int_unsigned NOT NULL,\n        answer varchar(255) NOT NULL,\n        feedback text,\n        result_option int_unsigned DEFAULT 0,\n        is_correct smallint_unsigned DEFAULT 0,\n        PRIMARY KEY(answer_id)\n      );");

      /**
       * This connects all the quiz specific properties to the correct version of a quiz.
       */

      // Creates the quiz node properties table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_properties} (\n        property_id SERIAL,\n        vid int_unsigned NOT NULL,\n        nid int_unsigned NOT NULL,\n        number_of_random_questions smallint_unsigned DEFAULT 0 NOT NULL,\n        pass_rate smallint_unsigned NOT NULL,\n        summary_pass text,\n        summary_default text,\n        shuffle smallint_unsigned NOT NULL,\n        backwards_navigation smallint_unsigned NOT NULL,\n        feedback_time smallint_unsigned NOT NULL,\n        quiz_open int_unsigned DEFAULT 0,\n        quiz_close int_unsigned DEFAULT 0,\n        takes smallint_unsigned NOT NULL,\n        time_limit int_unsigned DEFAULT 0 NOT NULL,\n        quiz_always smallint NOT NULL default 0,\n        tid int_unsigned NOT NULL DEFAULT 0,\n        PRIMARY KEY(property_id)\n      );");
      $ret[] = update_sql("CREATE INDEX idx_{quiz_node_properties}_vidnid ON {quiz_node_properties}(vid, nid);");

      /**
       * Both a quiz and a quiz question are nodes with versions.  A quiz is a parent node of a quiz question,
       * making the quiz question the child.
       *
       * The quiz_node_relationship table stores this relationship in a way that allows a quiz question to be
       * the child of multiple quizzes without losing version history.
       *
       * Future functionality will allow a quiz question to be a parent of another quiz question with the same
       * data model.  This will make adaptive quiz functionality possible without redesign.
       */

      // Creates the quiz node relationship table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_relationship} (\n        parent_nid int_unsigned NOT NULL,\n        parent_vid int_unsigned NOT NULL,\n        child_nid int_unsigned NOT NULL,\n        child_vid int_unsigned NOT NULL,\n        question_status smallint_unsigned DEFAULT 1 NOT NULL,\n        PRIMARY KEY(parent_nid, parent_vid, child_nid, child_vid)\n      );");

      /**
       * This connects all the quiz question specific properties to the correct version of a quiz question.
       */

      // Creates the quiz node question properties table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_question_properties} (\n        nid int_unsigned NOT NULL,\n        vid int_unsigned NOT NULL,\n        number_of_answers smallint_unsigned DEFAULT 1 NOT NULL\n      );");

      /**
       * Quiz specific options concerning  availability and access to scores.
       */

      // Creates the quiz node results table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_results} (\n        result_id SERIAL,\n        nid int_unsigned NOT NULL,\n        vid int_unsigned NOT NULL,\n        uid int_unsigned NOT NULL,\n        time_start int_unsigned DEFAULT 0,\n        time_end int_unsigned DEFAULT 0,\n        released int_unsigned DEFAULT 0,\n        score smallint NOT NULL DEFAULT 0,\n        PRIMARY KEY(result_id)\n      );");

      /**
       * Information about a particular question in a result
       */
      $ret[] = update_sql("CREATE TABLE {quiz_node_results_answers} (\n        result_id int_unsigned NOT NULL ,\n        question_nid int_unsigned NOT NULL ,\n        question_vid int_unsigned NOT NULL ,\n        is_correct smallint_unsigned NOT NULL DEFAULT '0',\n        points_awarded smallint NOT NULL DEFAULT '0',\n        answer_timestamp int_unsigned NOT NULL,\n        PRIMARY KEY(result_id, question_nid, question_vid)\n      );");

      /**
       * Allows custom feedback based on the results of a user completing a quiz.
       */

      // Creates the quiz node result options table.
      $ret[] = update_sql("CREATE TABLE {quiz_node_result_options} (\n        option_id SERIAL,\n        nid int_unsigned NOT NULL,\n        vid int_unsigned NOT NULL,\n        option_name VARCHAR(255) NOT NULL,\n        option_summary text,\n        option_start int_unsigned DEFAULT 0,\n        option_end int_unsigned DEFAULT 0,\n        PRIMARY KEY(option_id)\n      );");
      quiz_data_update_2();
      break;
  }
  return $ret;
}

/**
 * Updates data from quiz 1.1.
 *
 */
function quiz_data_update_2() {
  $results = db_query("SELECT * FROM {quiz}");
  while ($row = db_fetch_object($results)) {
    $nid = $row->nid;
    $number_of_random_questions = 0;
    $pass_rate = $row->pass_rate;
    $summary_pass = $row->summary_pass;
    $summary_default = $row->summary_default;
    $shuffle = $row->shuffle;
    $backwards_navigation = $row->backwards_navigation;
    $feedback_time = $row->feedback_time;
    $quiz_open = $row->quiz_open;
    $quiz_close = $row->quiz_close;
    $takes = $row->takes;
    $time_limit = $row->time_limit;
    $quiz_always = $row->quiz_always;
    $node = node_load($nid);
    $vid = $node->vid;
    $tid = $node->tid;
    $sql = "INSERT INTO {quiz_node_properties} " . "(vid, nid, number_of_random_questions, shuffle, quiz_open, quiz_close, takes, pass_rate, " . "summary_pass, summary_default, quiz_always, feedback_time, tid) " . "VALUES(%d, %d, %d, %d, %d, %d, %d, %d, '%s', '%s', %d, %d, %d)";
    db_query($sql, $vid, $nid, $number_of_random_questions, $shuffle, $quiz_open, $quiz_close, $takes, $pass_rate, $summary_pass, $summary_default, $quiz_always, $feedback_time, $tid);
  }
  $results = db_query("SELECT * FROM {quiz_question_answer}");
  while ($row = db_fetch_object($results)) {
    $question_nid = $row->question_nid;
    $answer = $row->answer;
    $feedback = $row->feedback;
    $points = $row->points;
    $result_option = $row->result_option;
    $node = node_load($question_nid);
    $vid = $node->vid;
    $is_correct = $points;
    db_query("INSERT INTO {quiz_multichoice_answers} (nid, vid, answer, feedback, result_option, is_correct) " . "VALUES(%d, %d, '%s', '%s', %d, %d)", $question_nid, $vid, $answer, $feedback, $result_option, $is_correct);
  }
  $results = db_query("SELECT * FROM {quiz_questions}");
  while ($row = db_fetch_object($results)) {
    $parent_nid = $row->quiz_nid;
    $child_nid = $row->question_nid;
    $parent = node_load($parent_nid);
    $parent_vid = $parent->vid;
    $child = node_load($child_nid);
    $child_vid = $child->vid;
    $question_status = $row->question_status;
    db_query("INSERT INTO {quiz_node_relationship} (parent_nid, parent_vid, child_nid, child_vid, question_status) " . "VALUES (%d, %d, %d, %d, %d)", $parent_nid, $parent_vid, $child_nid, $child_vid, $question_status);
  }
  $results = db_query("SELECT nid, properties FROM {quiz_question}");
  while ($row = db_fetch_object($results)) {
    $count = 0;
    $nid = $row->nid;
    $count = db_result(db_query("SELECT COUNT(aid) FROM {quiz_question_answer} WHERE question_nid = %d AND points = 1 ", $nid));
    db_query("INSERT INTO {quiz_node_question_properties} (nid, vid, number_of_answers) " . "VALUES (%d, %d, %d)", $nid, $vid, $count);
  }
  $results = db_query("SELECT * FROM {quiz_result}");
  while ($row = db_fetch_object($results)) {
    $rid = $row->rid;
    $quiz_nid = $row->quiz_nid;
    $quiz = node_load($quiz_nid);
    $quiz_vid = $quiz->vid;
    $uid = $row->uid;
    $time_start = $row->time_start;
    $time_end = $row->time_end;
    $released = $row->released;
    $score = $row->score;
    db_query("INSERT INTO {quiz_node_results} (nid, vid, uid, time_start, time_end, released, score) " . "VALUES (%d, %d, %d, %d, %d, %d, %d)", $nid, $vid, $uid, $time_start, $time_end, $released, $score);
    $results2 = db_query("SELECT * FROM {quiz_question_results} WHERE result_rid=%d", $rid);
    while ($row2 = db_fetch_object($results2)) {
      $result_rid = $row2->result_rid;
      $question_nid = $row2->question_nid;
      $answer = $row2->answer;
      $temp_answers = unserialize($answer);
      $tried = $temp_answers['tried'][0];
      foreach ($temp_answers['answers'] as $line) {
        $aid = $line['aid'];
        if ($aid == $tried) {
          $question_nid = $line['question_nid'];
          $question = node_load($question_nid);
          $question_vid = $question->vid;
          $is_correct = $line['points'];
          $points_awarded = $line['points'];
          $answer_timestamp = time();
          db_query("INSERT INTO {quiz_multichoice_user_answers} (question_nid, question_vid, result_id, answer_id) " . "VALUES (%d, %d, %d, %d)", $question_nid, $question_vid, $rid, $aid);
          db_query("INSERT INTO {quiz_node_results_answers} " . "(result_id, question_nid, question_vid, is_correct, points_awarded, answer_timestamp) " . "VALUES (%d, %d, %d, %d, %d, %d)", $rid, $question_nid, $question_vid, $is_correct, $points_awarded, $answer_timestamp);
        }

        /* endif */
      }

      /* end foreach */
    }

    /* end while */
  }

  /* end while */
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $select_questionanswer = db_query("SELECT name,id FROM {sequences} WHERE name='%s'", '({quiz_multichoice_answers}_answer_id');
      $results = db_fetch_object($select_questionanswer);
      if ($results->id > 0) {
        $old_value = db_fetch_object(db_query("SELECT name,id FROM {sequences} WHERE name='%s'", '{quiz_question_answer}_aid'));
        $value = $results->id + $old_value->id;
        db_query("UPDATE {sequences} SET id = %d, WHERE name = '%d'", $value, '{quiz_multichoice_answers}_answer_id');
      }
      else {
        $old_value = db_fetch_object(db_query("SELECT name,id FROM {sequences} WHERE name='%s'", '{quiz_question_answer}_aid'));
        $value = $old_value->id;
        db_query("INSERT INTO {sequences} (name,id) VALUES('%s',%d)", '{quiz_multichoice_answers}_answer_id', $value);
      }
      $select_questionanswer = db_query("SELECT name,id FROM {sequences} WHERE name='%s'", '{quiz_node_results}_result_id');
      $results = db_fetch_object($select_questionanswer);
      if ($results->id > 0) {
        $old_value = db_fetch_object(db_query("SELECT name,id FROM {sequences} WHERE name='%s'", '{quiz_results}_rid'));
        $value = $results->id + $old_value->id;
        db_query("UPDATE {sequences} SET id = %d, WHERE name = '%d'", $value, '{quiz_node_results}_result_id');
      }
      else {
        $old_value = db_fetch_object(db_query("SELECT name,id FROM {sequences} WHERE name='%s'", '{quiz_results}_rid'));
        $value = $old_value->id;
        db_query("INSERT INTO {sequences} (name,id) VALUES('%s',%d)", '{quiz_node_results}_result_id', $value);
      }
      break;
    case 'pgsql':

      // {quiz_multichoice_answers}_answer_id_seq
      $select = db_query("SELECT max(answer_id) AS id FROM {quiz_multichoice_answers}");
      $results = db_fetch_object($select);
      if ($results->id > 0) {
        db_query("SELECT setval('%s',%d)", '{quiz_multichoice_answers}_answer_id_seq', $results->id);
      }

      // {quiz_node_properties}_property_id_seq
      $select = db_query("SELECT max(property_id) AS id FROM {quiz_node_properties}");
      $results = db_fetch_object($select);
      if ($results->id > 0) {
        db_query("SELECT setval('%s',%d)", '{quiz_node_properties}_property_id_seq', $results->id);
      }

      // {quiz_node_result_options}_option_id_seq
      $select = db_query("SELECT max(option_id) AS id FROM {quiz_node_result_options}");
      $results = db_fetch_object($select);
      if ($results->id > 0) {
        db_query("SELECT setval('%s',%d)", '{quiz_node_result_options}_option_id_seq', $results->id);
      }

      // {quiz_node_results}_result_id_seq
      $select = db_query("SELECT max(result_id) AS id FROM {quiz_node_results}");
      $results = db_fetch_object($select);
      if ($results->id > 0) {
        db_query("SELECT setval('%s',%d)", '{quiz_node_results}_result_id_seq', $results->id);
      }
      break;
  }

  /* end switch */
}

Functions

Name	Description
quiz_data_update_2	Updates data from quiz 1.1.
quiz_install	Implementation of hook_install()
quiz_uninstall	Implementation of hook_uninstall()
quiz_update_2	Implementation of hook_update_N().