56 : void
57 {
58 $set = $this->db->query(
59 "SELECT glossary.id AS glossary_id, glossary.virtual, glossary_term.id AS term_id, glossary_term.glo_id " .
60 " FROM glossary LEFT JOIN glossary_term ON glossary.id = glossary_term.glo_id " .
61 " WHERE glossary.virtual = 'level' OR glossary.virtual = 'subtree' " .
62 " ORDER BY glossary.id"
63 );
64 $tmp_id = 0;
65 while ($rec = $this->db->fetchAssoc($set)) {
66 $glo_id = (
int) $rec[
"glossary_id"];
67 $term_id = (
int) $rec[
"term_id"];
68 if ($glo_id === $tmp_id) {
69 continue;
70 }
71 if ($term_id > 0) {
72 $this->db->manipulate(
73 "UPDATE glossary SET " .
74 " glossary.virtual = " . $this->db->quote("none", "text") .
75 " WHERE glossary.id = " . $this->db->quote($glo_id, "integer")
76 );
77 $this->
log(
"Convert glossary with id " . $glo_id .
" into Standard Glossary.");
78 } else {
79 $this->db->manipulate(
80 "UPDATE glossary SET " .
81 " glossary.virtual = " . $this->db->quote("coll", "text") .
82 " WHERE glossary.id = " . $this->db->quote($glo_id, "integer")
83 );
84 $this->
log(
"Convert glossary with id " . $glo_id .
" into Collection Glossary.");
85 }
86
87 $tmp_id = $glo_id;
88 }
89 }