staylor / WordPress

		$post_ids = $wpdb->get_col( $wpdb->prepare( "SELECT ID FROM $wpdb->posts WHERE post_author = %d", $user_id ) );

		$link_ids = $wpdb->get_col( $wpdb->prepare( "SELECT link_id FROM $wpdb->links WHERE link_owner = %d", $user_id ) );

		if ( ! empty( $post_ids ) ) {

			$wpdb->query( $wpdb->prepare( "UPDATE $wpdb->posts SET post_author = %d WHERE post_author = %d", $reassign, $user_id ) );

			array_walk( $post_ids, 'clean_post_cache' );

		}

		if ( ! empty( $link_ids ) ) {

			$wpdb->query( $wpdb->prepare( "UPDATE $wpdb->links SET link_owner = %d WHERE link_owner = %d", $reassign, $user_id ) );

			array_walk( $post_ids, 'clean_post_cache' );

		}

		if ( ! empty( $link_ids ) ) {

			$wpdb->query( $wpdb->prepare( "UPDATE $wpdb->links SET link_owner = %d WHERE link_owner = %d", $reassign, $user_id ) );

			array_walk( $link_ids, 'clean_bookmark_cache' );

		}

	}

	restore_current_blog();