MyBB 1.4 represents a huge leap forward for the MyBB project.
Due to this, lots of information in the database needs to be converted to a new format.
"; } echo "MyBB is now currently converting a section of data to the new format, this may take a while.
"; $remaining = $perpage; $final_table = array_keys($to_int); $final_table = $final_table[count($final_table)-1]; $next_act = "12_dbchanges"; $start = $mybb->get_input('start', MyBB::INPUT_INT); $count = $mybb->input['count']; foreach($to_int as $table => $columns) { if($table == $current_table) { $form_fields['last_table'] = $current_table; if($remaining <= 0) { break; } $columns_sql = implode(",", $columns); $primary_key = $columns[0]; if(!$mybb->input['count']) { $query = $db->simple_select($table, "COUNT({$primary_key}) AS count"); $count = $form_fields['count'] = $db->fetch_field($query, "count"); } if($start <= $count) { $end = $start+$perpage; if($end > $count) $end = $count; echo "{$table}: Converting {$start} to {$end} of {$count}
"; flush(); $form_fields['start'] = $perpage+$start; $query = $db->simple_select($table, $columns_sql, "", array('order_by' => $primary_key, 'limit_start' => $start, 'limit' => $remaining)); while($row = $db->fetch_array($query)) { $updated_row = array(); foreach($columns as $column) { if($column == $primary_key || is_int($row[$column])) continue; if($row[$column] == "yes" || $row[$column] == "on") { $updated_row[$column] = 1; } else if($row[$column] == "off" || $row[$column] == "no" || $row[$column] == 'new' || $row[$column] == "") { $updated_row[$column] = 0; } } if(count($updated_row) > 0) { $db->update_query($table, $updated_row, "{$primary_key}={$row[$primary_key]}"); } --$remaining; } } else { echo "{$table}: Converting column type
"; flush(); $change_column = array(); foreach($columns as $column) { // Closed does not get converted to an int if($column == $primary_key || ($table == "threads" && $column == "closed")) { continue; } $change_column[] = "MODIFY {$column} int(1) NOT NULL default '0'"; } $db->write_query("ALTER TABLE ".TABLE_PREFIX."{$table} ".implode(", ", $change_column)); if($table == $final_table) { // Finished, after all this! $next_act = "12_dbchanges1"; } else { $tbl_keys = array_keys($to_int); $current = array_search($current_table, $tbl_keys); $form_fields['last_table'] = $current_table = $tbl_keys[$current+1]; $form_fields['start'] = $start = 0; $form_fields['count'] = $count = $mybb->input['count'] = 0; } } } } // Still converting if($next_act == "12_dbchanges") { echo "Done
"; echo "Click next to continue with the integer conversion process.
"; foreach($form_fields as $key => $val) { echo ""; } global $footer_extra; $footer_extra = ""; $output->print_footer($next_act); } else { // Convert settings table $query = $db->write_query("UPDATE ".TABLE_PREFIX."settings SET value=1 WHERE value='yes' OR value='on'"); $query = $db->write_query("UPDATE ".TABLE_PREFIX."settings SET value=0 WHERE value='no' OR value='off'"); echo "Done
"; echo "The integrer conversion process is now complete.
"; echo "Click next to continue with the upgrade process.
"; global $footer_extra; $footer_extra = ""; $output->print_footer($next_act); } } function upgrade12_dbchanges1() { global $db, $output, $mybb; $output->print_header("Performing Queries"); echo "Performing necessary upgrade queries..
"; echo "Adding index to private messages table ... "; flush(); $db->write_query("ALTER TABLE ".TABLE_PREFIX."privatemessages ADD INDEX ( `uid` )"); echo "done.
"; $contents = "Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges_post1"); } function upgrade12_dbchanges_post1() { global $db, $output, $mybb; $output->print_header("Performing Queries"); echo "Performing necessary upgrade queries..
"; echo "Adding index to posts table ... "; flush(); // This will take a LONG time on huge post databases, so we only run it isolted from most of the other queries $db->write_query("ALTER TABLE ".TABLE_PREFIX."posts ADD INDEX ( `visible` )"); echo "done.
"; flush(); $contents = "Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges_post2"); } function upgrade12_dbchanges_post2() { global $db, $output, $mybb; $output->print_header("Performing Queries"); echo "Performing necessary upgrade queries..
"; if($db->field_exists('longipaddress', "posts")) { echo "Dropping longipaddress column in posts table ... "; flush(); $db->write_query("ALTER TABLE ".TABLE_PREFIX."posts DROP longipaddress;"); echo "done.
"; flush(); } echo "Adding longipaddress column to posts table ... "; flush(); $db->write_query("ALTER TABLE ".TABLE_PREFIX."posts ADD longipaddress int(11) NOT NULL default '0' AFTER ipaddress"); echo "done.
"; flush(); $contents = "Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges_user"); } function upgrade12_dbchanges_user() { global $db, $output, $mybb; $output->print_header("Performing Queries"); echo "Performing necessary upgrade queries..
"; echo "Adding index to users table ... "; flush(); // This will take a LONG time on huge user databases, so we only run it isolted from most of the other queries $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD INDEX ( `lastvisit` )"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD INDEX ( `regdate` )"); echo "done.
"; flush(); $contents = "Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges2"); } function upgrade12_dbchanges2() { global $db, $output, $mybb; $output->print_header("Performing Queries"); echo "Performing necessary upgrade queries..
"; flush(); if($db->field_exists('recipients', "privatemessages")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."privatemessages DROP recipients;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."privatemessages ADD recipients text NOT NULL AFTER fromid"); if($db->field_exists('deletetime', "privatemessages")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."privatemessages DROP deletetime;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."privatemessages ADD deletetime bigint(30) NOT NULL default '0' AFTER dateline"); if($db->field_exists('maxpmrecipients', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP maxpmrecipients;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD maxpmrecipients int(4) NOT NULL default '5' AFTER pmquota"); if($db->field_exists('canwarnusers', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP canwarnusers;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD canwarnusers int(1) NOT NULL default '0' AFTER cancustomtitle"); if($db->field_exists('lastip', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP lastip;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD lastip varchar(50) NOT NULL default '' AFTER regip"); if($db->field_exists('coppauser', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP coppauser;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD coppauser int(1) NOT NULL default '0'"); if($db->field_exists('classicpostbit', 'users')) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP classicpostbit;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD classicpostbit int(1) NOT NULL default '0'"); if($db->field_exists('canreceivewarnings', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP canreceivewarnings;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD canreceivewarnings int(1) NOT NULL default '0' AFTER canwarnusers"); if($db->field_exists('maxwarningsday', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP maxwarningsday;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD maxwarningsday int(3) NOT NULL default '3' AFTER canreceivewarnings"); $db->update_query("usergroups", array('canreceivewarnings' => 1), "cancp != 1"); $db->update_query("usergroups", array('maxwarningsday' => 3, 'canwarnusers' => 1), "cancp=1 OR issupermod=1 OR gid=6"); // Admins, Super Mods and Mods if($db->field_exists('canmodcp', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP canmodcp;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD canmodcp int(1) NOT NULL default '0' AFTER maxwarningsday"); $db->update_query("usergroups", array('canmodcp' => 1), "cancp=1 OR issupermod=1 OR gid='6'"); // Admins, Super Mods and Mods if($db->field_exists('newpms', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP newpms;"); } if($db->field_exists('keywords', "searchlog")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."searchlog DROP keywords;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."searchlog ADD keywords text NOT NULL AFTER querycache"); if($db->field_exists('canaddpublicevents', "usergroups") && !$db->field_exists('canaddevents', "usergroups")) { $db->update_query("usergroups", array('canaddpublicevents' => 0), "canaddpublicevents='no'"); $db->update_query("usergroups", array('canaddpublicevents' => 1), "canaddpublicevents='yes'"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups CHANGE canaddpublicevents canaddevents int(1) NOT NULL default '0';"); } if($db->field_exists('canaddprivateevents', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP canaddprivateevents;"); } if($db->field_exists('canbypasseventmod', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP canbypasseventmod;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD canbypasseventmod int(1) NOT NULL default '0' AFTER canaddevents;"); if($db->field_exists('canmoderateevents', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP canmoderateevents;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD canmoderateevents int(1) NOT NULL default '0' AFTER canbypasseventmod;"); $db->update_query("usergroups", array('canbypasseventmod' => 1, 'canmoderateevents' => 1), "cancp=1 OR issupermod=1"); $db->update_query("usergroups", array('canbypasseventmod' => 0, 'canmoderateevents' => 0), "cancp=0 AND issupermod=0"); $db->update_query("usergroups", array('canaddevents' => 0), "gid='1'"); $db->drop_table("maillogs"); $db->drop_table("mailerrors"); $db->drop_table("promotions"); $db->drop_table("promotionlogs"); $db->drop_table("massemails"); $collation = $db->build_create_table_collation(); $db->write_query("CREATE TABLE ".TABLE_PREFIX."massemails ( mid int unsigned NOT NULL auto_increment, uid int unsigned NOT NULL default '0', subject varchar(200) NOT NULL default '', message text NOT NULL, htmlmessage text NOT NULL, type tinyint(1) NOT NULL default '0', format tinyint(1) NOT NULL default '0', dateline bigint(30) NOT NULL default '0', senddate bigint(30) NOT NULL default '0', status tinyint(1) NOT NULL default '0', sentcount int unsigned NOT NULL default '0', totalcount int unsigned NOT NULL default '0', conditions text NOT NULL, perpage smallint(4) NOT NULL default '50', PRIMARY KEY(mid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."maillogs ( mid int unsigned NOT NULL auto_increment, subject varchar(200) not null default '', message TEXT NOT NULL, dateline bigint(30) NOT NULL default '0', fromuid int unsigned NOT NULL default '0', fromemail varchar(200) not null default '', touid bigint(30) NOT NULL default '0', toemail varchar(200) NOT NULL default '', tid int unsigned NOT NULL default '0', ipaddress varchar(20) NOT NULL default '', PRIMARY KEY(mid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."mailerrors( eid int unsigned NOT NULL auto_increment, subject varchar(200) NOT NULL default '', message TEXT NOT NULL, toaddress varchar(150) NOT NULL default '', fromaddress varchar(150) NOT NULL default '', dateline bigint(30) NOT NULL default '0', error text NOT NULL, smtperror varchar(200) NOT NULL default '', smtpcode int(5) NOT NULL default '0', PRIMARY KEY(eid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."promotions ( pid int unsigned NOT NULL auto_increment, title varchar(120) NOT NULL default '', description text NOT NULL, enabled tinyint(1) NOT NULL default '1', logging tinyint(1) NOT NULL default '0', posts int NOT NULL default '0', posttype char(2) NOT NULL default '', registered int NOT NULL default '0', registeredtype varchar(20) NOT NULL default '', reputations int NOT NULL default '0', reputationtype char(2) NOT NULL default '', requirements varchar(200) NOT NULL default '', originalusergroup varchar(120) NOT NULL default '0', newusergroup smallint unsigned NOT NULL default '0', usergrouptype varchar(120) NOT NULL default '0', PRIMARY KEY (pid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."promotionlogs( plid int unsigned NOT NULL auto_increment, pid int unsigned NOT NULL default '0', uid int unsigned NOT NULL default '0', oldusergroup varchar(200) NOT NULL default '0', newusergroup smallint unsigned NOT NULL default '0', dateline bigint(30) NOT NULL default '0', type varchar(9) NOT NULL default 'primary', PRIMARY KEY(plid) ) ENGINE=MyISAM{$collation};"); if($db->field_exists('maxemails', "usergroups")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups DROP maxemails;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."usergroups ADD maxemails int(3) NOT NULL default '5' AFTER cansendemail"); if($db->field_exists('parseorder', "mycode")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."mycode DROP parseorder;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."mycode ADD parseorder smallint unsigned NOT NULL default '0' AFTER active"); if($db->field_exists('mod_edit_posts', "forums")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums DROP mod_edit_posts;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."forums ADD mod_edit_posts int(1) NOT NULL default '0' AFTER modthreads"); if($db->field_exists('pmpopup', "users") && !$db->field_exists('pmnotice', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users CHANGE pmpopup pmnotice int(1) NOT NULL default '0'"); } $db->drop_table("tasks"); $db->drop_table("tasklog"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."tasks ( tid int unsigned NOT NULL auto_increment, title varchar(120) NOT NULL default '', description text NOT NULL, file varchar(30) NOT NULL default '', minute varchar(200) NOT NULL default '', hour varchar(200) NOT NULL default '', day varchar(100) NOT NULL default '', month varchar(30) NOT NULL default '', weekday varchar(15) NOT NULL default '', nextrun bigint(30) NOT NULL default '0', lastrun bigint(30) NOT NULL default '0', enabled int(1) NOT NULL default '1', logging int(1) NOT NULL default '0', locked bigint(30) NOT NULL default '0', PRIMARY KEY(tid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."tasklog ( lid int unsigned NOT NULL auto_increment, tid int unsigned NOT NULL default '0', dateline bigint(30) NOT NULL default '0', data text NOT NULL, PRIMARY KEY(lid) ) ENGINE=MyISAM{$collation};"); include_once MYBB_ROOT."inc/functions_task.php"; $tasks = file_get_contents(INSTALL_ROOT.'resources/tasks.xml'); $parser = create_xml_parser($tasks); $parser->collapse_dups = 0; $tree = $parser->get_tree(); // Insert scheduled tasks foreach($tree['tasks'][0]['task'] as $task) { $new_task = array( 'title' => $db->escape_string($task['title'][0]['value']), 'description' => $db->escape_string($task['description'][0]['value']), 'file' => $db->escape_string($task['file'][0]['value']), 'minute' => $db->escape_string($task['minute'][0]['value']), 'hour' => $db->escape_string($task['hour'][0]['value']), 'day' => $db->escape_string($task['day'][0]['value']), 'weekday' => $db->escape_string($task['weekday'][0]['value']), 'month' => $db->escape_string($task['month'][0]['value']), 'enabled' => $db->escape_string($task['enabled'][0]['value']), 'logging' => $db->escape_string($task['logging'][0]['value']) ); $new_task['nextrun'] = fetch_next_run($new_task); $db->insert_query("tasks", $new_task); $taskcount++; } if($db->table_exists("favorites") && !$db->table_exists("threadsubscriptions")) { $db->write_query("RENAME TABLE ".TABLE_PREFIX."favorites TO ".TABLE_PREFIX."threadsubscriptions"); } if($db->field_exists('fid', "threadsubscriptions")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."threadsubscriptions CHANGE fid sid int unsigned NOT NULL auto_increment"); } if($db->field_exists('type', "threadsubscriptions")) { $db->update_query("threadsubscriptions", array('type' => 0), "type='f'"); $db->update_query("threadsubscriptions", array('type' => 1), "type='s'"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."threadsubscriptions CHANGE type notification int(1) NOT NULL default '0'"); } if($db->field_exists('dateline', "threadsubscriptions")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."threadsubscriptions DROP dateline;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."threadsubscriptions ADD dateline bigint(30) NOT NULL default '0'"); if($db->field_exists('subscriptionkey', "threadsubscriptions")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."threadsubscriptions DROP subscriptionkey;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."threadsubscriptions ADD subscriptionkey varchar(32) NOT NULL default ''"); if($db->field_exists('emailnotify', "users")) { $db->update_query("users", array('emailnotify' => 0), "emailnotify='no' OR emailnotify='0'"); $db->update_query("users", array('emailnotify' => 2), "emailnotify='yes' OR emailnotify='1'"); $db->update_query("users", array('emailnotify' => 0), "emailnotify != 1 AND emailnotify != 2"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."users CHANGE emailnotify subscriptionmethod int(1) NOT NULL default '0'"); } $db->drop_table("warninglevels"); $db->drop_table("warningtypes"); $db->drop_table("warnings"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."warninglevels ( lid int unsigned NOT NULL auto_increment, percentage int(3) NOT NULL default '0', action text NOT NULL, PRIMARY KEY(lid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."warningtypes ( tid int unsigned NOT NULL auto_increment, title varchar(120) NOT NULL default '', points int unsigned NOT NULL default '0', expirationtime bigint(30) NOT NULL default '0', PRIMARY KEY(tid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."warnings ( wid int unsigned NOT NULL auto_increment, uid int unsigned NOT NULL default '0', tid int unsigned NOT NULL default '0', pid int unsigned NOT NULL default '0', title varchar(120) NOT NULL default '', points int unsigned NOT NULL default '0', dateline bigint(30) NOT NULL default '0', issuedby int unsigned NOT NULL default '0', expires bigint(30) NOT NULL default '0', expired int(1) NOT NULL default '0', daterevoked bigint(30) NOT NULL default '0', revokedby int unsigned NOT NULL default '0', revokereason text NOT NULL, notes text NOT NULL, PRIMARY KEY(wid) ) ENGINE=MyISAM{$collation};"); if($db->field_exists('warningpoints', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP warningpoints;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD warningpoints int(3) NOT NULL default '0' AFTER unreadpms"); if($db->field_exists('moderateposts', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP moderateposts;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD moderateposts int(1) NOT NULL default '0' AFTER warningpoints"); if($db->field_exists('moderationtime', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP moderationtime;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD moderationtime bigint(30) NOT NULL default '0' AFTER moderateposts"); if($db->field_exists('suspendposting', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP suspendposting;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD suspendposting int(1) NOT NULL default '0' AFTER moderationtime"); if($db->field_exists('suspensiontime', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP suspensiontime;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD suspensiontime bigint(30) NOT NULL default '0' AFTER suspendposting"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."banned CHANGE oldadditionalgroups oldadditionalgroups TEXT NOT NULL"); if($db->field_exists('birthdayprivacy', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP birthdayprivacy;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD birthdayprivacy varchar(4) NOT NULL default 'all' AFTER birthday"); if($db->field_exists('birthdayprivacy', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP birthdayprivacy;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD birthdayprivacy varchar(4) NOT NULL default 'all' AFTER birthday"); if($db->field_exists('longregip', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP longregip;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD longregip int(11) NOT NULL default '0' AFTER lastip"); if($db->field_exists('longlastip', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP longlastip;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD longlastip int(11) NOT NULL default '0' AFTER lastip"); // Unused column if($db->field_exists('titles', "searchlog")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."searchlog DROP titles;"); } $db->drop_table("adminlog"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."adminlog ( uid int unsigned NOT NULL default '0', ipaddress varchar(50) NOT NULL default '', dateline bigint(30) NOT NULL default '0', module varchar(50) NOT NULL default '', action varchar(50) NOT NULL default '', data text NOT NULL, KEY module (module, action) ) ENGINE=MyISAM{$collation};"); if($db->field_exists('data', "adminsessions")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."adminsessions DROP data;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."adminsessions ADD data TEXT NOT NULL AFTER lastactive;"); if($db->field_exists('isdefault', "settings")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."settings DROP isdefault;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."settings ADD isdefault int(1) NOT NULL default '0' AFTER gid;"); $setting_group_cache = array(); $query = $db->simple_select("settinggroups", "gid, isdefault"); while($settinggroup = $db->fetch_array($query)) { $setting_group_cache[$settinggroup['gid']] = $settinggroup['isdefault']; } $query = $db->simple_select("settings", "gid, sid"); while($setting = $db->fetch_array($query)) { if($setting_group_cache[$setting['gid']] == 1) { $db->update_query("settings", array('isdefault' => 1), "sid = '{$setting['sid']}'", 1); } } $db->update_query("settings", array('value' => 'classic'), "name='postlayout' AND value != 'horizontal'"); $db->update_query("settings", array('optionscode' => $db->escape_string('php ')), "name='searchtype'", 1); $contents = "Done"; $contents .= "Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges3"); } function upgrade12_dbchanges3() { global $db, $output, $mybb; $output->print_header("Converting Ban Filters"); echo "Converting existing banned IP addresses, email addresses and usernames..
"; flush(); $db->drop_table("banfilters"); $collation = $db->build_create_table_collation(); $db->write_query("CREATE TABLE ".TABLE_PREFIX."banfilters ( fid int unsigned NOT NULL auto_increment, filter varchar(200) NOT NULL default '', type int(1) NOT NULL default '0', lastuse bigint(30) NOT NULL default '0', dateline bigint(30) NOT NULL default '0', PRIMARY KEY (fid) ) ENGINE=MyISAM{$collation};"); // Now we convert all of the old bans in to the new system! $ban_types = array('bannedips', 'bannedemails', 'bannedusernames'); foreach($ban_types as $type) { // Some people put spaces or breaks (\r\n) instead, so we should take that into account. $mybb->settings[$type] = str_replace(array("\n", "\r\n", "\r"), ",", $mybb->settings[$type]); // Usernames can have spaces so don't replace those with commas. if($type != 'bannedusernames') { $mybb->settings[$type] = str_replace(" ", ",", $mybb->settings[$type]); } $bans = explode(",", $mybb->settings[$type]); $bans = array_unique($bans); $bans = array_map("trim", $bans); foreach($bans as $ban) { if(!$ban) { continue; } if($type == "bannedips") { $ban_type = 1; } else if($type == "bannedusernames") { $ban_type = 2; } else if($type == "bannedemails") { $ban_type = 3; } $new_ban = array( "filter" => $db->escape_string($ban), "type" => $ban_type, "dateline" => TIME_NOW ); $db->insert_query("banfilters", $new_ban); } } $contents = "Done"; $contents .= "Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges4"); } function upgrade12_dbchanges4() { global $db, $output, $mybb; $output->print_header("Performing Queries"); echo "Performing necessary upgrade queries..
"; flush(); $db->drop_table("spiders"); $db->drop_table("stats"); $collation = $db->build_create_table_collation(); $db->write_query("CREATE TABLE ".TABLE_PREFIX."spiders ( sid int unsigned NOT NULL auto_increment, name varchar(100) NOT NULL default '', theme int unsigned NOT NULL default '0', language varchar(20) NOT NULL default '', usergroup int unsigned NOT NULL default '0', useragent varchar(200) NOT NULL default '', lastvisit bigint(30) NOT NULL default '0', PRIMARY KEY(sid) ) ENGINE=MyISAM{$collation};"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."stats ( dateline bigint(30) NOT NULL default '0', numusers int unsigned NOT NULL default '0', numthreads int unsigned NOT NULL default '0', numposts int unsigned NOT NULL default '0', PRIMARY KEY(dateline) ) ENGINE=MyISAM{$collation};"); $db->insert_query("spiders", array('name' => 'GoogleBot', 'useragent' => 'google')); $db->insert_query("spiders", array('name' => 'Lycos', 'useragent' => 'lycos')); $db->insert_query("spiders", array('name' => 'Ask Jeeves', 'useragent' => 'ask jeeves')); $db->insert_query("spiders", array('name' => 'Hot Bot', 'useragent' => 'slurp@inktomi')); $db->insert_query("spiders", array('name' => 'What You Seek', 'useragent' => 'whatuseek')); $db->insert_query("spiders", array('name' => 'Archive.org', 'useragent' => 'is_archiver')); $db->insert_query("spiders", array('name' => 'Altavista', 'useragent' => 'scooter')); $db->insert_query("spiders", array('name' => 'Alexa', 'useragent' => 'ia_archiver')); $db->insert_query("spiders", array('name' => 'MSN Search', 'useragent' => 'msnbot')); $db->insert_query("spiders", array('name' => 'Yahoo!', 'useragent' => 'yahoo! slurp')); // DST correction changes $db->update_query("users", array('dst' => 1), "dst=1"); $db->update_query("users", array('dst' => 0), "dst=0"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."users CHANGE dst dst INT(1) NOT NULL default '0'"); if($db->field_exists('dstcorrection', "users")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."users DROP dstcorrection;"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."users ADD dstcorrection INT(1) NOT NULL default '0' AFTER dst"); $db->update_query("users", array('dstcorrection' => 2)); $db->update_query("adminoptions", array('cpstyle' => '')); if($db->field_exists('permsset', "adminoptions") && !$db->field_exists('permissions', "adminoptions")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."adminoptions CHANGE permsset permissions TEXT NOT NULL "); } $adminoptions = file_get_contents(INSTALL_ROOT.'resources/adminoptions.xml'); $parser = create_xml_parser($adminoptions); $parser->collapse_dups = 0; $tree = $parser->get_tree(); // Fetch default permissions list $default_permissions = array(); foreach($tree['adminoptions'][0]['user'] as $users) { $uid = $users['attributes']['uid']; if($uid == -4) { foreach($users['permissions'][0]['module'] as $module) { foreach($module['permission'] as $permission) { $default_permissions[$module['attributes']['name']][$permission['attributes']['name']] = $permission['value']; } } break; } } $convert_permissions = array( "caneditsettings" => array( "module" => "config", "permission" => "settings" ), "caneditann" => array( "module" => "forum", "permission" => "announcements", ), "caneditforums" => array( "module" => "forum", "permission" => "management", ), "canmodposts" => array( "module" => "forum", "permission" => "moderation_queue", ), "caneditsmilies" => array( "module" => "config", "permission" => "smilies", ), "caneditpicons" => array( "module" => "config", "permission" => "post_icons", ), "caneditthemes" => array( "module" => "style", "permission" => "themes", ), "canedittemps" => array( "module" => "style", "permission" => "templates", ), "caneditusers" => array( "module" => "user", "permission" => "view", ), "caneditpfields" => array( "module" => "config", "permission" => "profile_fields", ), "caneditmodactions" => array( "module" => "config", "permission" => "mod_tools", ), "caneditugroups" => array( "module" => "user", "permission" => "groups", ), "caneditaperms" => array( "module" => "user", "permission" => "admin_permissions", ), "caneditutitles" => array( "module" => "user", "permission" => "titles", ), "caneditattach" => array( "module" => "forum", "permission" => "attachments", ), "canedithelp" => array( "module" => "config", "permission" => "help_documents", ), "caneditlangs" => array( "module" => "config", "permission" => "languages", ), "canrunmaint" => array( "module" => "tools", "permission" => "recount_rebuild", ), "canrundbtools" => array( "module" => "tools", "permission" => "backupdb", ), ); $new_permissions = $default_permissions; $query = $db->simple_select("adminoptions"); while($adminoption = $db->fetch_array($query)) { foreach($adminoption as $field => $value) { if(strtolower(substr($field, 0, 3)) != "can") { continue; } if(array_key_exists($field, $convert_permissions)) { // Note: old adminoptions table is still yes/no - do not change me if($value == "yes") { $value = 1; } else { $value = $default_permissions[$convert_permissions[$field]['module']][$convert_permissions[$field]['permission']]; } $new_permissions[$convert_permissions[$field]['module']][$convert_permissions[$field]['permission']] = $value; } } $db->update_query("adminoptions", array('permissions' => my_serialize($new_permissions)), "uid = '{$adminoption['uid']}'"); $new_permissions = $default_permissions; } foreach($convert_permissions as $field => $value) { if($db->field_exists($field, "adminoptions")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."adminoptions DROP {$field}"); } } // Set default views if($db->field_exists('defaultviews', "adminoptions")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."adminoptions DROP defaultviews"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."adminoptions ADD defaultviews TEXT NOT NULL"); $db->update_query("adminoptions", array('defaultviews' => my_serialize(array('user' => 1)))); $query = $db->simple_select("forums", "SUM(threads) AS numthreads, SUM(posts) AS numposts, SUM(unapprovedthreads) AS numunapprovedthreads, SUM(unapprovedposts) AS numunapprovedposts"); $stats = $db->fetch_array($query); $query = $db->simple_select("users", "COUNT(uid) AS users"); $stats['numusers'] = $db->fetch_field($query, 'users'); update_stats($stats, true); $contents = "Done"; $contents .= "Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges5"); } function upgrade12_dbchanges5() { global $db, $output, $mybb; $output->print_header("Performing Queries"); echo "Performing necessary upgrade queries..
"; flush(); $db->drop_table("templategroups"); $db->write_query("CREATE TABLE ".TABLE_PREFIX."templategroups ( gid int unsigned NOT NULL auto_increment, prefix varchar(50) NOT NULL default '', title varchar(100) NOT NULL default '', PRIMARY KEY (gid) ) ENGINE=MyISAM{$collation};"); $db->write_query("INSERT INTO ".TABLE_PREFIX."templategroups (gid,prefix,title) VALUES ('1','calendar','Click next to continue with the upgrade process.
"; $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer("12_redoconfig"); } function upgrade12_redoconfig() { global $db, $output, $orig_config, $mybb; $config = $orig_config; $output->print_header("Rewriting config.php"); if(!is_array($config['database'])) { // Backup our old Config file @copy(MYBB_ROOT."inc/config.php", MYBB_ROOT."inc/config.backup.php"); $fh = @fopen(MYBB_ROOT."inc/config.php", "w"); if(!$fh) { echo "Unable to open inc/config.php
Before the upgrade process can continue, you need to changes the permissions of inc/config.php so it is writable.
The configuration file has successfully been rewritten.
"; echo "Click next to continue with the upgrade process.
"; global $footer_extra; $footer_extra = ""; $output->print_footer("12_dbchanges6"); } function upgrade12_dbchanges6() { global $db, $output; $output->print_header("Post IP Conversion"); if(!$_POST['ipspage']) { $ipp = 5000; } else { $ipp = (int)$_POST['ipspage']; } if($_POST['ipstart']) { $startat = (int)$_POST['ipstart']; $upper = $startat+$ipp; $lower = $startat; } else { $startat = 0; $upper = $ipp; $lower = 1; } $query = $db->simple_select("posts", "COUNT(pid) AS ipcount"); $cnt = $db->fetch_array($query); if($upper > $cnt['ipcount']) { $upper = $cnt['ipcount']; } echo "Converting ip {$lower} to {$upper} ({$cnt['ipcount']} Total)
"; flush(); $ipaddress = false; $query = $db->simple_select("posts", "ipaddress, longipaddress, pid", "", array('limit_start' => $lower, 'limit' => $ipp)); while($post = $db->fetch_array($query)) { // Have we already converted this ip? if(!$post['longipaddress']) { $db->update_query("posts", array('longipaddress' => my_ip2long($post['ipaddress'])), "pid = '{$post['pid']}'"); } $ipaddress = true; } $remaining = $upper-$cnt['ipcount']; if($remaining && $ipaddress) { $nextact = "12_dbchanges6"; $startat = $startat+$ipp; $contents = "Done. Click Next to move on to the next set of post ips.
"; } else { $nextact = "12_dbchanges7"; $contents = "Done
All post ips have been converted to the new ip format. Click next to continue.
"; } $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer($nextact); } function upgrade12_dbchanges7() { global $db, $output; $output->print_header("User IP Conversion"); if(!$_POST['ipspage']) { $ipp = 5000; } else { $ipp = (int)$_POST['ipspage']; } if($_POST['ipstart']) { $startat = (int)$_POST['ipstart']; $upper = $startat+$ipp; $lower = $startat; } else { $startat = 0; $upper = $ipp; $lower = 1; } $query = $db->simple_select("users", "COUNT(uid) AS ipcount"); $cnt = $db->fetch_array($query); if($upper > $cnt['ipcount']) { $upper = $cnt['ipcount']; } $contents .= "Converting ip {$lower} to {$upper} ({$cnt['ipcount']} Total)
"; $ipaddress = false; $update_array = array(); $query = $db->simple_select("users", "regip, lastip, longlastip, longregip, uid", "", array('limit_start' => $lower, 'limit' => $ipp)); while($user = $db->fetch_array($query)) { // Have we already converted this ip? if(!$user['longregip']) { $update_array['longregip'] = (int)my_ip2long($user['regip']); } if(!$user['longlastip']) { $update_array['longlastip'] = (int)my_ip2long($user['lastip']); } if(!empty($update_array)) { $db->update_query("users", $update_array, "uid = '{$user['uid']}'"); } $update_array = array(); $ipaddress = true; } $remaining = $upper-$cnt['ipcount']; if($remaining && $ipaddress) { $nextact = "12_dbchanges7"; $startat = $startat+$ipp; $contents .= "Done. Click Next to move on to the next set of user ips.
"; } else { $nextact = "12_dbchanges8"; $contents .= "Done
All user ips have been converted to the new ip format. Click next to continue.
"; } $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer($nextact); } function upgrade12_dbchanges8() { global $db, $output; $output->print_header("Event Conversion"); if(!$_POST['eventspage']) { $epp = 50; } else { $epp = (int)$_POST['eventspage']; } if($_POST['eventstart']) { $startat = (int)$_POST['eventstart']; $upper = $startat+$epp; $lower = $startat; } else { $startat = 0; $upper = $epp; $lower = 1; } $query = $db->simple_select("events", "COUNT(eid) AS eventcount"); $cnt = $db->fetch_array($query); if($upper > $cnt['eventcount']) { $upper = $cnt['eventcount']; } $contents .= "Converting events {$lower} to {$upper} ({$cnt['eventcount']} Total)
"; // Just started - add fields if(!$db->field_exists("donecon", "events")) { // Add temporary column $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD donecon smallint(1) NOT NULL;"); if($db->field_exists('cid', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP cid;"); } if($db->field_exists('visible', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP visible;"); } if($db->field_exists('dateline', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP dateline;"); } if($db->field_exists('starttime', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP starttime;"); } if($db->field_exists('endtime', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP endtime;"); } if($db->field_exists('timezone', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP timezone;"); } if($db->field_exists('ignoretimezone', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP ignoretimezone;"); } if($db->field_exists('usingtime', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP usingtime;"); } if($db->field_exists('repeats', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP repeats;"); } // Got structural changes? $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD cid int unsigned NOT NULL default '0' AFTER eid"); if($db->field_exists('author', "events") && !$db->field_exists('uid', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events CHANGE author uid int unsigned NOT NULL default '0'"); } if($db->field_exists('subject', "events") && !$db->field_exists('name', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events CHANGE subject name varchar(120) NOT NULL default ''"); } $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD visible int(1) NOT NULL default '0' AFTER description"); $db->update_query("events", array('private' => 1), "private='yes' OR private='1'"); $db->update_query("events", array('private' => 0), "private='no' OR private='0'"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events CHANGE private private int(1) NOT NULL default '0'"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD dateline int(10) unsigned NOT NULL default '0' AFTER private"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD starttime int(10) unsigned NOT NULL default '0' AFTER dateline"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD endtime int(10) unsigned NOT NULL default '0' AFTER starttime"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD timezone int(3) NOT NULL default '0' AFTER endtime"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD ignoretimezone int(1) NOT NULL default '0' AFTER timezone"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD usingtime int(1) NOT NULL default '0' AFTER ignoretimezone"); $db->write_query("ALTER TABLE ".TABLE_PREFIX."events ADD repeats text NOT NULL AFTER usingtime"); } if($db->field_exists('date', "events")) { $query = $db->simple_select("events", "*", "donecon!=1", array("order_by" => "eid", "limit" => $epp)); while($event = $db->fetch_array($query)) { $e_date = explode("-", $event['date']); if(!$e_date[2]) $e_date[2] = 2005; $starttime = gmmktime(0, 0, 0, $e_date[1], $e_date[0], $e_date[2]); $updated_event = array( "cid" => 1, "visible" => 1, "donecon" => 1, "starttime" => $starttime, "dateline" => $starttime ); $db->update_query("events", $updated_event, "eid='{$event['eid']}'", 1); } $date = true; } else { $date = false; } $query = $db->simple_select("events", "COUNT(eid) AS remaining", "donecon!=1"); $remaining = $db->fetch_field($query, "remaining"); if($remaining && $date) { $nextact = "12_dbchanges8"; $startat = $startat+$epp; $contents .= "Done. Click Next to move on to the next set of events.
"; } else { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP donecon"); if($db->field_exists('date', "events")) { $db->write_query("ALTER TABLE ".TABLE_PREFIX."events DROP date"); } $nextact = "12_redothemes"; $contents .= "Done
All events have been converted to the new calendar system. Click next to continue.
"; } $output->print_contents($contents); global $footer_extra; $footer_extra = ""; $output->print_footer($nextact); } function upgrade12_redothemes() { global $db, $output, $config, $mybb; $output->print_header("Converting themes"); if(!@is_dir(MYBB_ROOT.'cache/')) { @mkdir(MYBB_ROOT.'cache/', 077); // Add in empty index.html! $fp = @fopen(MYBB_ROOT."cache/index.html", "w"); @fwrite($fp, ""); @fclose($fp); } $cachewritable = @fopen(MYBB_ROOT.'cache/test.write', 'w'); if(!$cachewritable) { $not_writable = true; } else { @fclose($cachewritable); @my_chmod(MYBB_ROOT.'cache', '0777'); @my_chmod(MYBB_ROOT.'cache/test.write', '0777'); @unlink(MYBB_ROOT.'cache/test.write'); } if($not_writable) { echo "Unable to write to the cache/ directory.
Before the upgrade process can continue you need to make sure this directory exists and is writable (chmod 777)
Unable to write to the cache/themes/ directory.
Before the upgrade process can continue you need to make sure this directory exists and is writable (chmod 777)
Your themes have successfully been converted to the new theme system.
"; echo "Click next to continue with the upgrade process.
"; global $footer_extra; //$footer_extra = ""; $output->print_footer("12_done"); }