MDL-14679
[moodle.git] / mod / quiz / db / upgrade.php
CommitLineData
1061756d 1<?php // $Id$
b8a342d7 2
271e6dec 3// This file keeps track of upgrades to
b8a342d7 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
20function xmldb_quiz_upgrade($oldversion=0) {
21
ec3fa1d8 22 global $CFG, $THEME, $db;
b8a342d7 23
24 $result = true;
25
271e6dec 26/// And upgrade begins here. For each one, you'll need one
27/// block of code similar to the next one. Please, delete
b8a342d7 28/// this comment lines once this file start handling proper
29/// upgrade code.
30
b9ea2b7a 31 if ($result && $oldversion < 2007022800) {
32 /// Ensure that there are not existing duplicate entries in the database.
31f6834e 33 $duplicateunits = get_records_select('question_numerical_units', "id > (SELECT MIN(iqnu.id)
b9ea2b7a 34 FROM {$CFG->prefix}question_numerical_units iqnu
35 WHERE iqnu.question = {$CFG->prefix}question_numerical_units.question AND
31f6834e 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 }
b9ea2b7a 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
bb4598fc 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
42ff9ce6 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
00719c02 69 // Separate control for when overall feedback is displayed, independant of the question feedback settings.
70 if ($result && $oldversion < 2007072600) {
271e6dec 71
00719c02 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 }
271e6dec 85
b8a342d7 86 return $result;
87}
88
89?>