2 function upgrade_do11() {
\r
4 if (upgrade_checkinstall(11))
\r
5 return "already installed";
\r
7 // 1. add some options to nucleus_config
\r
8 $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookiePath', '/');";
\r
9 upgrade_query('CookiePath setting',$query);
\r
10 $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookieDomain', '');";
\r
11 upgrade_query('CookieDomain setting',$query);
\r
12 $query = 'INSERT INTO '.sql_table('config')." VALUES ('CookieSecure', '0');";
\r
13 upgrade_query('CookieSecure setting',$query);
\r
14 $query = 'INSERT INTO '.sql_table('config')." VALUES ('MediaPrefix', '1');";
\r
15 upgrade_query('MediaPrefix setting',$query);
\r
18 // 2. add language field to member table
\r
19 upgrade_query("Language setting (member)",
\r
20 'ALTER TABLE '.sql_table('member')." ADD deflang varchar(20) NOT NULL default '';");
\r
22 // 3. create category table and update other tables (nucleus_item and nucleus_blog)
\r
23 $query = 'CREATE TABLE '.sql_table('category').' ('
\r
24 ." catid int(11) NOT NULL auto_increment,"
\r
25 ." cblog int(11) NOT NULL, "
\r
26 ." cname varchar(40),"
\r
27 ." cdesc varchar(200),"
\r
28 ." PRIMARY KEY (catid)"
\r
30 upgrade_query('New table '.sql_table('category'), $query);
\r
32 upgrade_query("Adding category attribute to item-table",
\r
33 'ALTER TABLE '.sql_table('item').' ADD icat int(11)');
\r
34 upgrade_query("Adding defcat attribute to blog-table",
\r
35 'ALTER TABLE '.sql_table('blog').' ADD bdefcat int(11)');
\r
37 // 4. add 'general' categories for all blogs, and update nucleus_item
\r
38 $catid = 1; // generate catids ourself
\r
39 $query = 'SELECT bnumber FROM '.sql_table('blog');
\r
40 $res = mysql_query($query);
\r
41 while ($current = mysql_fetch_object($res)) {
\r
42 $blogid = $current->bnumber;
\r
44 $query = 'INSERT INTO '.sql_table('category')." (catid, cblog, cname, cdesc) VALUES ($catid, $blogid, 'General', 'Items that do not fit in other categories')";
\r
45 $r = upgrade_query("Adding category 'general' for blog " . $blogid, $query);
\r
47 // only perform next actions when insert went ok
\r
49 $query = 'UPDATE '.sql_table('blog')." SET bdefcat=$catid WHERE bnumber=$blogid";
\r
50 upgrade_query("Setting the default category for blog $blogid to the 'General' category", $query);
\r
52 $query = 'UPDATE '.sql_table('item')." SET icat=$catid WHERE iblog=$blogid";
\r
53 upgrade_query("Assigning all existing items of blog $blogid to the 'General' category",$query);
\r
59 // 5. add content type field to skins
\r
60 $query = 'ALTER TABLE '.sql_table('skin_desc')." ADD sdtype VARCHAR(40) NOT NULL DEFAULT 'text/html'";
\r
61 upgrade_query("Adding content type field to skins (text/html)", $query);
\r
63 // 6. try to set content type for xml-rss skin to text/xml
\r
64 $query = 'UPDATE '.sql_table('skin_desc')." SET sdtype='text/xml' WHERE sdname='xmlrss'";
\r
65 upgrade_query("Setting content type for xmlrss skin to text/xml", $query);
\r
67 // 7. add template parts for category lists to all templates
\r
68 $query = 'SELECT tdnumber FROM '.sql_table('template_desc');
\r
69 $res = sql_query($query); // get all template ids
\r
70 while ($obj = mysql_fetch_object($res)) {
\r
71 $tid = $obj->tdnumber; // template id
\r
73 $query = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_HEADER', '<ul><li><a href=\"<%blogurl%>\">All</a></li>');";
\r
74 $query2 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_LISTITEM', '<li><a href=\"<%catlink%>\"><%catname%></a></li>');";
\r
75 $query3 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_FOOTER', '</ul>');";
\r
76 upgrade_query("Adding categorylist header to template $tid",$query);
\r
77 upgrade_query("Adding categorylist item to template $tid",$query2);
\r
78 upgrade_query("Adding categorylist footer to template $tid",$query3);
\r
82 // 8. add bnotifytype column to blog tables
\r
83 upgrade_query("Notify Type Setting",
\r
84 'ALTER TABLE '.sql_table('blog')." ADD bnotifytype INT(11) NOT NULL default '15';");
\r