script = "upgrade.php"; $db=new databaseEngine; // Connect to Database define("TABLE_PREFIX", $config['table_prefix']); $db->connect($config['hostname'], $config['username'], $config['password']); $db->select_db($config['database']); if(file_exists("lock")) { $output->print_error("The installer is currently locked, please remove 'lock' from the install directory to continue"); } else { $output->steps = array("Upgrade Process"); if(!$mybb->input['action'] || $mybb->input['action'] == "intro") { $output->print_header("MyBB Upgrade Script"); $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."upgrade_data"); $db->query("CREATE TABLE ".TABLE_PREFIX."upgrade_data ( title varchar(30) NOT NULL, contents text NOT NULL, PRIMARY KEY(title) );"); $dh = opendir("./resources"); while(($file = readdir($dh)) !== false) { if(preg_match("#upgrade([0-9]+).php$#i", $file, $match)) { $upgradescripts[$match[1]] = $file; } } closedir($dh); foreach($upgradescripts as $key => $file) { $upgradescript = file_get_contents("./resources/$file"); preg_match("#Upgrade Script:(.*)#i", $upgradescript, $verinfo); preg_match("#upgrade([0-9]+).php$#i", $file, $keynum); if(trim($verinfo[1])) { if(!$upgradescripts[$key+1]) { $vers .= "\n"; } else { $vers .= "\n"; } } } unset($upgradescripts); unset($upgradescript); $output->print_contents("

Welcome to the upgrade wizard for MyBB $myver.

Before you continue, please make sure you know which version of MyBB you were previously running as you will need to select it below.

We recommend that you also do a complete backup of your database before attempting to upgrade so if something goes wrong you can easily revert back to the previous version.

Once you're ready, please select your old version below and click next to continue.

"); $output->print_footer("doupgrade"); } elseif($mybb->input['action'] == "doupgrade") { add_upgrade_store("startscript", $mybb->input['from']); $runfunction = next_function($mybb->input['from']); } $currentscript = get_upgrade_store("currentscript"); $system_upgrade_detail = get_upgrade_store("upgradedetail"); if($mybb->input['action'] == "templates") { $runfunction = "upgradethemes"; } elseif($mybb->input['action'] == "rebuildsettings") { $runfunction = "rebuildsettings"; } elseif($mybb->input['action'] == "buildcaches") { $runfunction = "buildcaches"; } elseif($mybb->input['action'] == "finished") { $runfunction = "upgradedone"; } else // Busy running modules, come back later { $bits = explode("_", $mybb->input['action'], 2); if($bits[1]) // We're still running a module { $from = $bits[0]; $runfunction = next_function($bits[0], $bits[1]); } } // Fetch current script we're in if(function_exists($runfunction)) { $runfunction(); } } function upgradethemes() { global $output, $db, $system_upgrade_detail; $output->print_header("Templates Reverted"); if($system_upgrade_detail['revert_all_templates'] > 0) { $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."templates;"); $db->query("CREATE TABLE ".TABLE_PREFIX."templates ( tid int unsigned NOT NULL auto_increment, title varchar(120) NOT NULL default '', template text NOT NULL, sid int(10) NOT NULL default '0', version varchar(20) NOT NULL default '0', status varchar(10) NOT NULL default '', dateline int(10) NOT NULL default '0', PRIMARY KEY (tid) ) TYPE=MyISAM;"); } if($system_upgrade_detail['revert_all_themes'] > 0) { $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."themes"); $db->query("CREATE TABLE ".TABLE_PREFIX."themes ( tid smallint unsigned NOT NULL auto_increment, name varchar(100) NOT NULL default '', pid smallint unsigned NOT NULL default '0', def smallint(1) NOT NULL default '0', css text NOT NULL, cssbits text NOT NULL, themebits text NOT NULL, extracss text NOT NULL, PRIMARY KEY (tid) ) TYPE=MyISAM;"); $db->query("INSERT INTO ".TABLE_PREFIX."themes (name,pid) VALUES ('MyBB Master Style','0')"); $db->query("INSERT INTO ".TABLE_PREFIX."themes (name,pid,def) VALUES ('MyBB Default','1','1')"); $sid = $db->insert_id(); $db->query("UPDATE ".TABLE_PREFIX."users SET style='$sid'"); $db->query("DROP TABLE IF EXISTS ".TABLE_PREFIX."templatesets;"); $db->query("CREATE TABLE ".TABLE_PREFIX."templatesets ( sid smallint unsigned NOT NULL auto_increment, title varchar(120) NOT NULL default '', PRIMARY KEY (sid) ) TYPE=MyISAM;"); $db->query("INSERT INTO ".TABLE_PREFIX."templatesets (title) VALUES ('Default Templates')"); } $sid = -2; $arr = @file("./resources/mybb_theme.xml"); $contents = @implode("", $arr); $parser = new XMLParser($contents); $tree = $parser->getTree(); $theme = $tree['theme']; $css = killtags($theme['cssbits']); $themebits = killtags($theme['themebits']); $templates = $theme['templates']['template']; $themebits['templateset'] = $templateset; $newcount = 0; foreach($templates as $template) { $templatename = $template['attributes']['name']; $templateversion = $template['attributes']['version']; $templatevalue = addslashes($template['value']); $time = time(); $query = $db->query("SELECT tid FROM ".TABLE_PREFIX."templates WHERE sid='-2' AND title='$templatename'"); $oldtemp = $db->fetch_array($query); if($oldtemp['tid']) { $db->query("UPDATE ".TABLE_PREFIX."templates SET template='$templatevalue', version='$templateversion', dateline='$time' WHERE title='$templatename' AND sid='-2'"); } else { $db->query("INSERT INTO ".TABLE_PREFIX."templates (title,template,sid,version,status,dateline) VALUES ('$templatename','$templatevalue','$sid','$templateversion','','$time')"); $newcount++; } } update_theme(1, 0, $themebits, $css, 0); $output->print_contents("

All of the templates have successfully been reverted to the new ones contained in this release. Please press next to continue with the upgrade process.

"); $output->print_footer("rebuildsettings"); } function rebuildsettings() { global $db, $output, $system_upgrade_detail; $synccount = sync_settings($system_upgrade_detail['revert_all_settings']); $output->print_header("Settings Synchronisation"); $output->print_contents("

The board settings have been synchronised with the latest in MyBB.

".$synccount[1]." new settings inserted along with ".$synccount[0]." new setting groups.

To finalise the upgrade, please click next below to continue.

"); $output->print_footer("buildcaches"); } function buildcaches() { global $db, $output, $myver, $cache; $output->print_header("Data Cache Building"); $contents .= "

Building cache's..."; require "../inc/class_datacache.php"; $cache = new datacache; $cache->updateversion(); $cache->updateattachtypes(); $cache->updatesmilies(); $cache->updatebadwords(); $cache->updateusergroups(); $cache->updateforumpermissions(); $cache->updatestats(); $cache->updatemoderators(); $cache->updateforums(); $cache->updateusertitles(); $cache->updatereportedposts(); $contents .= "done

"; $output->print_contents("$contents

Please press next to continue

"); $output->print_footer("finished"); } function upgradedone() { global $db, $output, $myver; $output->print_header("Upgrade Complete"); if(is_writable("./")) { $lock = @fopen("./lock", "w"); $written = @fwrite($lock, "1"); @fclose($lock); if($written) { $lock_note = "

Your installer has been locked. To unlock the installer please delete the 'lock' file in this directory.

You may now proceed to your upgraded copy of MyBB or its Admin Control Panel.

"; } } if(!$written) { $lock_note = "

Please remove this directory before exploring your upgraded MyBB.

"; } $output->print_contents("

Congratulations, your copy of MyBB has successfully been updated to $myver.

$lock_note

What's Next?

"); $output->print_footer(); } function whatsnext() { global $output, $db, $system_upgrade_detail; if($system_upgrade_detail['revert_all_templates'] > 0) { $output->print_header("Template Reversion Warning"); $output->print_contents("

All necessary database modifications have successfully been made to upgrade your board.

This upgrade requires all templates to be reverted to the new ones contained in the package so please back up any custom templates you have made before clicking next."); $output->print_footer("templates"); } else { upgradethemes(); } } function next_function($from, $func="dbchanges") { global $oldvers, $system_upgrade_detail, $currentscript; load_module("upgrade".$from.".php"); if(function_exists("upgrade".$from."_".$func)) { $function = "upgrade".$from."_".$func; } else { $from = $from+1; if(file_exists("./resources/upgrade".$from.".php")) { $function = next_function($from); } } if(!$function) { $function = "whatsnext"; } return $function; } function load_module($module) { global $system_upgrade_detail, $currentscript; require_once "./resources/".$module; if($currentscript != $module) { foreach($upgrade_detail as $key => $val) { if(!$system_upgrade_detail[$key] || $val > $system_upgrade_detail[$key]) { $system_upgrade_detail[$key] = $val; } } add_upgrade_store("upgradedetail", $system_upgrade_detail); add_upgrade_store("currentscript", $module); } } function get_upgrade_store($title) { global $db; $query = $db->query("SELECT * FROM ".TABLE_PREFIX."upgrade_data WHERE title='".addslashes($title)."'"); $data = $db->fetch_array($query); return unserialize($data['contents']); } function add_upgrade_store($title, $contents) { global $db; $db->query("REPLACE INTO ".TABLE_PREFIX."upgrade_data (title,contents) VALUES ('".addslashes($title)."', '".addslashes(serialize($contents))."')"); } function sync_settings($redo=0) { global $db; $settingcount = $groupcount = 0; if($redo == 2) { $db->query("DROP TABLE ".TABLE_PREFIX."settings"); $db->query("CREATE TABLE ".TABLE_PREFIX."settings ( sid smallint(6) NOT NULL auto_increment, name varchar(120) NOT NULL default '', title varchar(120) NOT NULL default '', description text NOT NULL, optionscode text NOT NULL, value text NOT NULL, disporder smallint(6) NOT NULL default '0', gid smallint(6) NOT NULL default '0', PRIMARY KEY (sid) ) TYPE=MyISAM;"); } else { $query = $db->query("SELECT name FROM ".TABLE_PREFIX."settings"); while($setting = $db->fetch_array($query)) { $settings[$setting['name']] = 1; } $query = $db->query("SELECT name,gid FROM ".TABLE_PREFIX."settinggroups"); while($group = $db->fetch_array($query)) { $settinggroups[$group['name']] = $group['gid']; } } $settings_xml = file_get_contents("./resources/settings.xml"); $parser = new XMLParser($settings_xml); $parser->collapse_dups = 0; $tree = $parser->getTree(); foreach($tree['settings'][0]['settinggroup'] as $settinggroup) { if(!$settinggroups[$settinggroup['attributes']['name']] || $redo == 2) { $groupdata = array( "name" => addslashes($settinggroup['attributes']['name']), "description" => addslashes($settinggroup['attributes']['description']), "disporder" => intval($settinggroup['attributes']['disporder']), "isdefault" => $settinggroup['attributes']['isdefault'] ); $db->insert_query(TABLE_PREFIX."settinggroups", $groupdata); $gid = $db->insert_id(); $groupcount++; } else { $gid = $settinggroups[$settinggroup['attributes']['name']]; } if(!$gid) { continue; } foreach($settinggroup['setting'] as $setting) { if(!$settings[$setting['attributes']['name']] || $redo == 2) { $settingdata = array( "name" => addslashes($setting['attributes']['name']), "title" => addslashes($setting['title'][0]['value']), "description" => addslashes($setting['description'][0]['value']), "optionscode" => addslashes($setting['optionscode'][0]['value']), "value" => addslashes($setting['settingvalue'][0]['value']), "disporder" => intval($setting['disporder'][0]['value']), "gid" => $gid ); $db->insert_query(TABLE_PREFIX."settings", $settingdata); $settingcount++; } } } if($redo == 1) { require "../inc/settings.php"; while(list($key, $val) = each($settings)) { $db->query("UPDATE ".TABLE_PREFIX."settings SET value='$val' WHERE name='$key'"); } } unset($settings); $query = $db->query("SELECT * FROM ".TABLE_PREFIX."settings ORDER BY title ASC"); while($setting = $db->fetch_array($query)) { $setting[value] = addslashes($setting[value]); $settings .= "\$settings[".$setting['name']."] = \"".$setting['value']."\";\n"; } $settings = ""; $file = fopen("../inc/settings.php", "w"); fwrite($file, $settings); fclose($file); return array($groupcount, $settingcount); } ?>