mod/quiz/db/upgrade.php

   1 <?php  // $Id$
   2
   3 // This file keeps track of upgrades to
   4 // the quiz module
   5 //
   6 // Sometimes, changes between versions involve
   7 // alterations to database structures and other
   8 // major things that may break installations.
   9 //
  10 // The upgrade function in this file will attempt
  11 // to perform all the necessary actions to upgrade
  12 // your older installtion to the current version.
  13 //
  14 // If there's something it cannot do itself, it
  15 // will tell you what you need to do.
  16 //
  17 // The commands in here will all be database-neutral,
  18 // using the functions defined in lib/ddllib.php
  19
  20 function xmldb_quiz_upgrade($oldversion=0) {
  21
  22     global $CFG, $THEME, $db;
  23
  24     $result = true;
  25
  26 /// And upgrade begins here. For each one, you'll need one
  27 /// block of code similar to the next one. Please, delete
  28 /// this comment lines once this file start handling proper
  29 /// upgrade code.
  30
  31     if ($result && $oldversion < 2007022800) {
  32     /// Ensure that there are not existing duplicate entries in the database.
  33         $duplicateunits = get_records_select('question_numerical_units', "id > (SELECT MIN(iqnu.id)
  34                 FROM {$CFG->prefix}question_numerical_units iqnu
  35                 WHERE iqnu.question = {$CFG->prefix}question_numerical_units.question AND
  36                         iqnu.unit = {$CFG->prefix}question_numerical_units.unit)", '', 'id');
  37         if ($duplicateunits) {
  38             delete_records_select('question_numerical_units', 'id IN (' . implode(',', array_keys($duplicateunits)) . ')');
  39         }
  40
  41     /// Define index question-unit (unique) to be added to question_numerical_units
  42         $table = new XMLDBTable('question_numerical_units');
  43         $index = new XMLDBIndex('question-unit');
  44         $index->setAttributes(XMLDB_INDEX_UNIQUE, array('question', 'unit'));
  45
  46     /// Launch add index question-unit
  47         $result = $result && add_index($table, $index);
  48     }
  49
  50     if ($result && $oldversion < 2007070200) {
  51
  52     /// Changing precision of field timelimit on table quiz to (10)
  53         $table = new XMLDBTable('quiz');
  54         $field = new XMLDBField('timelimit');
  55         $field->setAttributes(XMLDB_TYPE_INTEGER, '10', XMLDB_UNSIGNED, XMLDB_NOTNULL, null, null, null, '0', 'timemodified');
  56
  57     /// Launch change of precision for field timelimit
  58         $result = $result && change_field_precision($table, $field);
  59     }
  60
  61     if ($result && $oldversion < 2007072200) {
  62         require_once $CFG->dirroot.'/mod/quiz/lib.php';
  63         // too much debug output
  64         $db->debug = false;
  65         quiz_update_grades();
  66         $db->debug = true;
  67     }
  68
  69     // Separate control for when overall feedback is displayed, independant of the question feedback settings.
  70     if ($result && $oldversion < 2007072600) {
  71
  72         // Adjust the quiz review options so that overall feedback is displayed whenever feedback is.
  73         $result = $result && execute_sql('UPDATE ' . $CFG->prefix . 'quiz SET review = ' .
  74                 sql_bitor(sql_bitand('review', sql_bitnot(QUIZ_REVIEW_OVERALLFEEDBACK)),
  75                 sql_bitor(sql_bitand('review', QUIZ_REVIEW_FEEDBACK & QUIZ_REVIEW_IMMEDIATELY) . ' * 65536',
  76                 sql_bitor(sql_bitand('review', QUIZ_REVIEW_FEEDBACK & QUIZ_REVIEW_OPEN) . ' * 16384',
  77                           sql_bitand('review', QUIZ_REVIEW_FEEDBACK & QUIZ_REVIEW_CLOSED) . ' * 4096'))));
  78
  79         // Same adjustment to the defaults for new quizzes.
  80         $result = $result && set_config('quiz_review', ($CFG->quiz_review & ~QUIZ_REVIEW_OVERALLFEEDBACK) |
  81                 (($CFG->quiz_review & QUIZ_REVIEW_FEEDBACK & QUIZ_REVIEW_IMMEDIATELY) << 16) |
  82                 (($CFG->quiz_review & QUIZ_REVIEW_FEEDBACK & QUIZ_REVIEW_OPEN) << 14) |
  83                 (($CFG->quiz_review & QUIZ_REVIEW_FEEDBACK & QUIZ_REVIEW_CLOSED) << 12));
  84     }
  85
  86 //===== 1.9.0 upgrade line ======//
  87
  88     return $result;
  89 }
  90
  91 ?>