Performing necessary upgrade queries...
"; flush(); if($mybb->settings['captchaimage'] == 2) { $db->update_query('settings', array('value' => 1), "name='captchaimage'"); // Reset CAPTCHA to MyBB Default $db->update_query('settings', array('value' => ''), 'name IN (\'captchapublickey\', \'captchaprivatekey\')'); // Clean out stored credential keys } if($db->field_exists('aim', 'users')) { $db->drop_column('users', 'aim'); } $db->delete_query("settings", "name='allowaimfield'"); if($db->field_exists('regex', 'badwords')) { $db->drop_column('badwords', 'regex'); } switch($db->type) { case "pgsql": $db->add_column("badwords", "regex", "smallint NOT NULL default '0'"); break; default: $db->add_column("badwords", "regex", "tinyint(1) NOT NULL default '0'"); break; } $cache->delete("mybb_credits"); // Add lockout column if(!$db->field_exists("loginlockoutexpiry", "users")) { $db->add_column("users", "loginlockoutexpiry", "int NOT NULL default '0'"); } // Unescape last 1000 admin logs $query = $db->simple_select('adminlog', 'uid, ipaddress, dateline, data', "", array( "order_by" => 'dateline', "order_dir" => 'DESC', "limit" => 1000 )); while($row = $db->fetch_array($query)) { $original = $row['data']; $unescaped = htmlspecialchars_decode($original); $uid = (int) $row['uid']; $ip_address = $db->escape_binary($row['ip_address']); $dateline = (int) $row['dateline']; if ($unescaped !== $original) { $db->update_query('adminlog', array( 'data' => $db->escape_string($unescaped), ), "uid = '".$uid."' AND dateline = '".$dateline."' AND ipaddress = ".$ip_address); } } $output->print_contents("Click next to continue with the upgrade process.
"); $output->print_footer("43_done"); }