2 function upgrade_do33() {
4 if (upgrade_checkinstall(33))
5 return 'already installed';
7 // alter nucleus_blog table
8 $query = 'ALTER TABLE ' . sql_table('blog')
9 . ' ADD breqemail TINYINT(2) DEFAULT \'0\' NOT NULL';
10 upgrade_query('Altering ' . sql_table('blog') . ' table', $query);
12 // insert breqemail default value
13 $query = 'INSERT INTO ' . sql_table('blog')
16 upgrade_query('Filling breqemail column of ' . sql_table('blog') . ' table', $query);
18 // store cname from nucleus_category
19 $query = 'SELECT catid, cname FROM ' . sql_table('category') . ' ORDER By catid ASC';
20 $res = sql_query($query);
22 while ($o = mysql_fetch_object($res)) {
29 // alter nucleus_category
30 $query = 'ALTER TABLE ' . sql_table('category')
31 . ' DROP COLUMN cname,'
32 . ' ADD cname varchar(200) default NULL AFTER cblog';
33 upgrade_query('Altering ' . sql_table('category') . ' table', $query);
35 // refill cname to nucleus_category
36 foreach ($aValues as $aInfo) {
37 $query = 'UPDATE ' . sql_table('category')
39 . " '" . addslashes($aInfo['cname']) . "'"
40 . " WHERE catid=" . $aInfo['catid'];
41 upgrade_query('Re-filling ' . sql_table('category')
42 . ' (' . $aInfo['catid'] . ')', $query);
45 // alter nucleus_comment
46 $query = 'ALTER TABLE ' . sql_table('comment')
47 . ' ADD cemail varchar(100)'
49 upgrade_query('Altering ' . sql_table('comment') . ' table', $query);