get_most_recent_post_of_user( int $user_id ): array

1940function get_most_recent_post_of_user( $user_id ) {1941	global $wpdb;1942 1943	$user_blogs       = get_blogs_of_user( (int) $user_id );1944	$most_recent_post = array();1945 1946	/*1947	 * Walk through each blog and get the most recent post1948	 * published by $user_id.1949	 */1950	foreach ( (array) $user_blogs as $blog ) {1951		$prefix      = $wpdb->get_blog_prefix( $blog->userblog_id );1952		$recent_post = $wpdb->get_row( $wpdb->prepare( "SELECT ID, post_date_gmt FROM {$prefix}posts WHERE post_author = %d AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1", $user_id ), ARRAY_A );1953 1954		// Make sure we found a post.1955		if ( isset( $recent_post['ID'] ) ) {1956			$post_gmt_ts = strtotime( $recent_post['post_date_gmt'] );1957 1958			/*1959			 * If this is the first post checked1960			 * or if this post is newer than the current recent post,1961			 * make it the new most recent post.1962			 */1963			if ( ! isset( $most_recent_post['post_gmt_ts'] ) || ( $post_gmt_ts > $most_recent_post['post_gmt_ts'] ) ) {1964				$most_recent_post = array(1965					'blog_id'       => $blog->userblog_id,1966					'post_id'       => $recent_post['ID'],1967					'post_date_gmt' => $recent_post['post_date_gmt'],1968					'post_gmt_ts'   => $post_gmt_ts,1969				);1970			}1971		}1972	}1973 1974	return $most_recent_post;1975}