Performing necessary upgrade queries...
"; flush(); if($db->field_exists('subscriptionkey', 'threadsubscriptions')) { $db->drop_column("threadsubscriptions", "subscriptionkey"); } if($db->type != 'pgsql') { $db->modify_column('adminsessions', 'useragent', "varchar(200) NOT NULL default ''"); $db->modify_column('sessions', 'useragent', "varchar(200) NOT NULL default ''"); } else { $db->modify_column('adminsessions', 'useragent', "varchar(200)", "set", "''"); $db->modify_column('sessions', 'useragent', "varchar(200)", "set", "''"); } // Remove "Are You a Human" captcha $db->update_query('settings', array('value' => '1'), "name='captchaimage' AND value='3'"); $db->delete_query('settings', "name IN ('ayahpublisherkey', 'ayahscoringkey')"); $db->delete_query('templates', "title IN ('member_register_regimage_ayah', 'post_captcha_ayah')"); global $footer_extra; $footer_extra = ""; $output->print_contents("Click next to continue with the upgrade process.
"); $output->print_footer("35_dbchanges2"); } function upgrade35_dbchanges2() { global $db, $output; $output->print_header("Updating Database"); echo "Performing necessary optimization queries...
"; flush(); switch($db->type) { // PostgreSQL and SQLite do not support unsigned ints case "pgsql": $db->modify_column("buddyrequests", "uid", "int", "set", "'0'"); $db->modify_column("buddyrequests", "touid", "int", "set", "'0'"); $db->modify_column("buddyrequests", "date", "int", "set", "'0'"); break; case "sqlite": $db->modify_column("threadratings", "rating", "tinyint(1) NOT NULL default '0'"); $db->modify_column("buddyrequests", "uid", "int NOT NULL default '0'"); $db->modify_column("buddyrequests", "touid", "int NOT NULL default '0'"); $db->modify_column("buddyrequests", "date", "int NOT NULL default '0'"); break; default: $db->modify_column("adminviews", "perpage", "smallint(4) unsigned NOT NULL default '0'"); $db->modify_column("attachments", "filesize", "int(10) unsigned NOT NULL default '0'"); $db->modify_column("attachtypes", "maxsize", "int(15) unsigned NOT NULL default '0'"); $db->modify_column("banned", "olddisplaygroup", "int unsigned NOT NULL default '0'"); $db->modify_column("buddyrequests", "uid", "int unsigned NOT NULL default '0'"); $db->modify_column("buddyrequests", "touid", "int unsigned NOT NULL default '0'"); $db->modify_column("buddyrequests", "date", "int unsigned NOT NULL default '0'"); $db->modify_column("calendars", "eventlimit", "smallint(3) unsigned NOT NULL default '0'"); $db->modify_column("massemails", "perpage", "smallint(4) unsigned NOT NULL default '50'"); $db->modify_column("promotions", "posts", "int unsigned NOT NULL default '0'"); $db->modify_column("promotions", "threads", "int unsigned NOT NULL default '0'"); $db->modify_column("promotions", "registered", "int unsigned NOT NULL default '0'"); $db->modify_column("promotions", "online", "int unsigned NOT NULL default '0'"); $db->modify_column("promotions", "referrals", "int unsigned NOT NULL default '0'"); $db->modify_column("promotions", "warnings", "int unsigned NOT NULL default '0'"); $db->modify_column("sessions", "location1", "int(10) unsigned NOT NULL default '0'"); $db->modify_column("sessions", "location2", "int(10) unsigned NOT NULL default '0'"); $db->modify_column("threadratings", "rating", "tinyint(1) unsigned NOT NULL default '0'"); $db->modify_column("threads", "views", "int(100) unsigned NOT NULL default '0'"); $db->modify_column("threads", "replies", "int(100) unsigned NOT NULL default '0'"); break; } global $footer_extra; $footer_extra = ""; $output->print_contents("Click next to continue with the upgrade process.
"); $output->print_footer("35_dbchanges3"); } function upgrade35_dbchanges3() { global $db, $output; $output->print_header("Updating Database"); echo "Performing necessary optimization queries...
"; flush(); switch($db->type) { // PostgreSQL and SQLite do not support unsigned ints case "sqlite": $db->modify_column("usergroups", "type", "tinyint(1) NOT NULL default '2'"); $db->modify_column("users", "loginattempts", "smallint(2) NOT NULL default '1'"); break; case "mysql": case "mysqli": $db->modify_column("usergroups", "type", "tinyint(1) unsigned NOT NULL default '2'"); $db->modify_column("usergroups", "stars", "smallint(4) unsigned NOT NULL default '0'"); $db->modify_column("usergroups", "pmquota", "int(3) unsigned NOT NULL default '0'"); $db->modify_column("usergroups", "maxpmrecipients", "int(4) unsigned NOT NULL default '5'"); $db->modify_column("usergroups", "maxemails", "int(3) unsigned NOT NULL default '5'"); $db->modify_column("usergroups", "emailfloodtime", "int(3) unsigned NOT NULL default '5'"); $db->modify_column("usergroups", "maxwarningsday", "int(3) unsigned NOT NULL default '3'"); $db->modify_column("usergroups", "edittimelimit", "int(4) unsigned NOT NULL default '0'"); $db->modify_column("usergroups", "maxposts", "int(4) unsigned NOT NULL default '0'"); $db->modify_column("users", "postnum", "int(10) unsigned NOT NULL default '0'"); $db->modify_column("users", "threadnum", "int(10) unsigned NOT NULL default '0'"); $db->modify_column("users", "ppp", "smallint(6) unsigned NOT NULL default '0'"); $db->modify_column("users", "tpp", "smallint(6) unsigned NOT NULL default '0'"); $db->modify_column("users", "daysprune", "smallint(6) unsigned NOT NULL default '0'"); $db->modify_column("users", "totalpms", "int(10) unsigned NOT NULL default '0'"); $db->modify_column("users", "unreadpms", "int(10) unsigned NOT NULL default '0'"); $db->modify_column("users", "warningpoints", "int(3) unsigned NOT NULL default '0'"); $db->modify_column("users", "loginattempts", "smallint(2) unsigned NOT NULL default '1'"); $db->modify_column("usertitles", "stars", "smallint(4) unsigned NOT NULL default '0'"); $db->modify_column("warninglevels", "percentage", "smallint(3) unsigned NOT NULL default '0'"); break; } global $footer_extra; $footer_extra = ""; $output->print_contents("Click next to continue with the upgrade process.
"); $output->print_footer("35_dbchanges4"); } function upgrade35_dbchanges4() { global $mybb, $output; $output->print_header("Adding index files"); echo "Adding index files to attachment directories...
"; flush(); $uploadspath_abs = mk_path_abs($mybb->settings['uploadspath']); $dir = @opendir($uploadspath_abs); if($dir) { while(($file = @readdir($dir)) !== false) { $filename = "{$uploadspath_abs}/{$file}"; $indexfile = "{$filename}/index.html"; if(preg_match('#^[0-9]{6}$#', $file) && @is_dir($filename) && @is_writable($filename) && !file_exists($indexfile)) { $index = @fopen($indexfile, 'w'); @fwrite($index, "\n\nClick next to continue with the upgrade process.
"); $output->print_footer("35_done"); }