1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
|
<?php // $Id: postgres7.php,v 1.11.2.2 2004/11/18 19:11:58 moodler Exp $
function glossary_upgrade($oldversion) {
/// This function does anything necessary to upgrade
/// older versions to match current functionality
global $CFG;
if ($oldversion < 2004022200) {
if (!empty($CFG->textfilters)) {
$CFG->textfilters = str_replace("dynalink.php", "filter.php", $CFG->textfilters);
set_config("textfilters", $CFG->textfilters);
}
}
if ($oldversion < 2004050900) {
table_column("glossary","","rsstype","integer","2", "unsigned", "0", "", "entbypage");
table_column("glossary","","rssarticles","integer","2", "unsigned", "0", "", "rsstype");
set_config("glossary_enablerssfeeds",0);
}
if ( $oldversion < 2004051400 ) {
print_simple_box("This update might take several seconds.<p>The more glossaries, entries and aliases you have created, the more it will take so please be patient.","center", "50%", "$THEME->cellheading", "20", "noticebox");
if ( $entries = get_records("glossary_entries", '', '', '', 'id,concept')) {
foreach($entries as $entry) {
set_field("glossary_entries","concept",addslashes(trim($entry->concept)),"id",$entry->id);
}
}
if ( $aliases = get_records("glossary_alias")) {
foreach($aliases as $alias) {
set_field("glossary_alias","alias",addslashes(trim($alias->alias)),"id",$alias->id);
}
}
}
if ( $oldversion < 2004072300) {
table_column("glossary_alias", "alias", "alias", "VARCHAR", "255", "", "", "NOT NULL");
}
if ( $oldversion < 2004072400) {
//Create new table glossary_formats to store format info
execute_sql("CREATE TABLE {$CFG->prefix}glossary_formats (
id SERIAL8 PRIMARY KEY,
name VARCHAR(50) NOT NULL,
popupformatname VARCHAR(50) NOT NULL,
visible int2 NOT NULL default '1',
showgroup int2 NOT NULL default '1',
defaultmode VARCHAR(50) NOT NULL default '',
defaulthook VARCHAR(50) NOT NULL default '',
sortkey VARCHAR(50) NOT NULL default '',
sortorder VARCHAR(50) NOT NULL default ''
) ");
//Define current 0-6 format names
$formatnames = array('dictionary','continuous','fullwithauthor','encyclopedia',
'faq','fullwithoutauthor','entrylist');
//Fill the new table from the old one (only 'valid', 0-6, formats)
if ($formats = get_records('glossary_displayformats')) {
foreach ($formats as $format) {
//Format names
if ($format->fid >= 0 && $format->fid <= 6) {
$format->name = $formatnames[$format->fid];
}
//Format popupformatname
$format->popupformatname = 'dictionary'; //Default format
if ($format->relatedview >= 0 && $format->relatedview <= 6) {
$format->popupformatname = $formatnames[$format->relatedview];
}
//Insert the new record
//Only if $format->name is set (ie. formats 0-6)
if ($format->name) {
insert_record('glossary_formats',$format);
}
}
}
//Drop the old formats table
execute_sql("DROP TABLE {$CFG->prefix}glossary_displayformats");
//Modify the glossary->displayformat field
table_column('glossary', 'displayformat', 'displayformat', 'VARCHAR', '50', '', 'dictionary', 'NOT NULL');
//Update glossary->displayformat field
if ($glossaries = get_records('glossary')) {
foreach($glossaries as $glossary) {
$displayformat = 'dictionary'; //Default format
if ($glossary->displayformat >= 0 && $glossary->displayformat <= 6) {
$displayformat = $formatnames[$glossary->displayformat];
}
set_field('glossary','displayformat',$displayformat,'id',$glossary->id);
}
}
}
if ( $oldversion < 2004080800) {
table_column("glossary","","editalways","integer","2", "unsigned", "0", "", "entbypage");
}
//Activate editalways in old secondary glossaries (old behaviour)
if ( $oldversion < 2004080900) {
set_field('glossary','editalways','1','mainglossary','0');
}
if ($oldversion < 2004080932) {
modify_database('','CREATE INDEX prefix_glossary_course_idx ON prefix_glossary (course);');
modify_database('','CREATE INDEX prefix_glossary_alias_entryid_idx ON prefix_glossary_alias (entryid);');
modify_database('','CREATE INDEX prefix_glossary_categories_glossaryid_idx ON prefix_glossary_categories (glossaryid);');
modify_database('','CREATE INDEX prefix_glossary_comments_entryid_idx ON prefix_glossary_comments (entryid);');
modify_database('','CREATE INDEX prefix_glossary_comments_userid_idx ON prefix_glossary_comments (userid);');
modify_database('','CREATE INDEX prefix_glossary_entries_glossaryid_idx ON prefix_glossary_entries (glossaryid);');
modify_database('','CREATE INDEX prefix_glossary_entries_userid_idx ON prefix_glossary_entries (userid);');
modify_database('','CREATE INDEX prefix_glossary_entries_concept_idx ON prefix_glossary_entries (concept);');
modify_database('','CREATE INDEX prefix_glossary_entries_categories_category_idx ON prefix_glossary_entries_categories (categoryid);');
modify_database('','CREATE INDEX prefix_glossary_entries_categories_entryid_idx ON prefix_glossary_entries_categories (entryid);');
modify_database('','CREATE INDEX prefix_glossary_ratings_userid_idx ON prefix_glossary_ratings (userid);');
modify_database('','CREATE INDEX prefix_glossary_ratings_entryid_idx ON prefix_glossary_ratings (entryid);');
}
return true;
}
?>
|
