Upgrade Multiply Blogs
Multiply plugin for WordPress.', 'Multiply'); ?>
hide_errors();
if (! $wpdb->query("SHOW COLUMNS FROM `$wpdb->multiply` LIKE 'press_type'") ) {
$wpdb->query("ALTER TABLE `$wpdb->multiply` ADD `press_type` VARCHAR( 20 ) DEFAULT 'alt' NOT NULL;");
}
$first = $wpdb->get_row("SELECT * FROM $wpdb->multiply WHERE `press_id`='1'");
if ('main' != $first->press_type) {
// Dodgy: old Multiply numbered the new blogs starting from mb_id #1;
// new WordPress ships with a blog_id of #1 for the main blog itself.
// To make them compatible, we change an Multiply blog with id #1 to
// something else, and insert a placeholder for the default.
$first->press_name = $wpdb->escape($first->press_name);
$wpdb->query("INSERT INTO $wpdb->multiply ( `press_name` ) VALUES ( '$first->press_name' )");
$new_id = $wpdb->insert_id;
foreach ($multiply_tables as $table)
$change[] = $table_prefix . '1_' . $table . ' TO ' . $table_prefix . $new_id . '_' . $table;
$sql = implode(', ', $change);
$wpdb->query("RENAME TABLE $sql");
// default press
$wpdb->query("DELETE FROM `$wpdb->multiply` WHERE `press_id` = '1'");
$wpdb->query("
INSERT INTO $wpdb->multiply ( `press_id`, `press_name`, `press_type` )
VALUES ( '1', '".__('Default/Main', 'Multiply')."', 'main')"
);
}
// If there were custom user levels before, convert the levels
// to the new cap system.
if ( $users = $wpdb->get_results("SELECT * FROM $wpdb->muser") ) {
foreach ($users as $user) {
if ($user->press_id == 1) $user->press_id = $new_id;
$role = translate_level_to_role($user->level);
update_usermeta( $user->user_id, $table_prefix . $user->press_id . '_capabilities', array($role => true) );
}
$wpdb->query("DROP TABLE `$wpdb->muser`");
}
// We'll need these.
$roles = Multiply::get_settings($multiply_real_prefix . 'user_roles', $press_id);
$real_wp_queries = $wp_queries;
$presses = Multiply::press_list();
foreach ($presses as $press_id => $press_name) {
if ($press_id == 1)
continue;
if ( defined('MULTIPLY_UPGRADE') && $press_id != MULTIPLY_UPGRADE )
continue;
Multiply::set_prefix($press_id);
$wp_queries = multiply_query_mod($real_wp_queries);
echo "$press_id - $press_name
";
wp_cache_flush();
wp_cache_init();
echo make_db_current();
upgrade_all();
// user #1 gets an administrator role everywhere
update_option($table_prefix . 'user_roles', $roles);
update_usermeta( 1, $table_prefix . 'capabilities', array('administrator' => true, 'manage_blogs' => true) );
update_usermeta( 1, $table_prefix . 'user_level', 10 );
}
Multiply::set_prefix(1);
wp_cache_init();
?>
Have fun!"), '../'); ?>