get_others_unpublished_posts()WP 2.3.0

Deprecated from version 3.1.0. It is no longer supported and can be removed in future releases. Use get_posts() instead.

Retrieves editable posts from other users.

Hooks from the function

Return

Array. List of posts from others.

Usage

get_others_unpublished_posts( $user_id, $type );
$user_id(int) (required)
User ID to not retrieve posts from.
$type(string)
Post type to retrieve. Accepts 'draft', 'pending' or 'any' (all).
Default: 'any'

Notes

  • See: get_posts()
  • Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

Since 2.3.0 Introduced.
Deprecated since 3.1.0 Use get_posts()

get_others_unpublished_posts() code WP 6.5.2

function get_others_unpublished_posts( $user_id, $type = 'any' ) {
	_deprecated_function( __FUNCTION__, '3.1.0' );

	global $wpdb;

	$editable = get_editable_user_ids( $user_id );

	if ( in_array($type, array('draft', 'pending')) )
		$type_sql = " post_status = '$type' ";
	else
		$type_sql = " ( post_status = 'draft' OR post_status = 'pending' ) ";

	$dir = ( 'pending' == $type ) ? 'ASC' : 'DESC';

	if ( !$editable ) {
		$other_unpubs = '';
	} else {
		$editable = join(',', $editable);
		$other_unpubs = $wpdb->get_results( $wpdb->prepare("SELECT ID, post_title, post_author FROM $wpdb->posts WHERE post_type = 'post' AND $type_sql AND post_author IN ($editable) AND post_author != %d ORDER BY post_modified $dir", $user_id) );
	}

	return apply_filters('get_others_drafts', $other_unpubs);
}