get_others_unpublished_posts

Retrieves editable posts from other users.

Description

(array) get_others_unpublished_posts( (int) $user_id, (string) $type = 'any' );

Returns (array)

List of posts from others.

Parameters (2)

0. $user_id (int): User ID to not retrieve posts from.
1. $type — Optional. (string) => 'any': Post type to retrieve. Accepts draft,, pending or any. (all). Default any..

Usage

if ( !function_exists( 'get_others_unpublished_posts' ) ) { 
    require_once ABSPATH . '/wp-admin/includes/deprecated.php'; 
} 
  
// User ID to not retrieve posts from. 
$user_id = -1; 
  
// Optional. Post type to retrieve. Accepts 'draft', 'pending' or 'any' (all). 
// Default 'any'. 
$type = 'any'; 
  
// NOTICE! Understand what this does before running. 
$result = get_others_unpublished_posts($user_id, $type);

Defined (1)

The function is defined in the following location(s).

/wp-admin/includes/deprecated.php

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); 
}