• \">All
  • ');"; $query2 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_LISTITEM', '
  • \"><%catname%>
  • ');"; $query3 = 'INSERT INTO '.sql_table('template')." VALUES ($tid, 'CATLIST_FOOTER', '');"; upgrade_query("Adding categorylist header to template $tid",$query); upgrade_query("Adding categorylist item to template $tid",$query2); upgrade_query("Adding categorylist footer to template $tid",$query3); } } // 6. add content type field to skins if(!upgrade_checkIfColumnExists('skin_desc', 'sdtype')){ $query = 'ALTER TABLE '.sql_table('skin_desc')." ADD sdtype VARCHAR(40) NOT NULL DEFAULT 'text/html'"; upgrade_query("Adding content type field to skins (text/html)", $query); } // 7. try to set content type for xml-rss skin to text/xml $query = 'UPDATE '.sql_table('skin_desc')." SET sdtype='text/xml' WHERE sdname='xmlrss'"; upgrade_query("Setting content type for xmlrss skin to text/xml", $query); // 8. add bnotifytype column to blog tables if(0==$upgrade_failures && !upgrade_checkIfColumnExists('blog', 'bnotifytype')){ upgrade_query("Adding Notify Type Setting", 'ALTER TABLE '.sql_table('blog')." ADD bnotifytype INT(11) NOT NULL default '15';"); }else{ echo "
  • Adding Notify Type Setting ... NOT EXECUTED\n
    Errors occurred during upgrade process.
    "; } } ?>