upgrade_210

Source code

function upgrade_210() {

	global $wpdb, $wp_current_db_version;



	if ( $wp_current_db_version < 3506 ) {

		// Update status and type.

		$posts = $wpdb->get_results("SELECT ID, post_status FROM $wpdb->posts");



		if ( ! empty($posts) ) foreach ($posts as $post) {

			$status = $post->post_status;

			$type = 'post';



			if ( 'static' == $status ) {

				$status = 'publish';

				$type = 'page';

			} else if ( 'attachment' == $status ) {

				$status = 'inherit';

				$type = 'attachment';

			}



			$wpdb->query( $wpdb->prepare("UPDATE $wpdb->posts SET post_status = %s, post_type = %s WHERE ID = %d", $status, $type, $post->ID) );

		}

	}



	if ( $wp_current_db_version < 3845 ) {

		populate_roles_210();

	}



	if ( $wp_current_db_version < 3531 ) {

		// Give future posts a post_status of future.

		$now = gmdate('Y-m-d H:i:59');

		$wpdb->query ("UPDATE $wpdb->posts SET post_status = 'future' WHERE post_status = 'publish' AND post_date_gmt > '$now'");



		$posts = $wpdb->get_results("SELECT ID, post_date FROM $wpdb->posts WHERE post_status ='future'");

		if ( !empty($posts) )

			foreach ( $posts as $post )

				wp_schedule_single_event(mysql2date('U', $post->post_date, false), 'publish_future_post', array($post->ID));

	}

}