get_others_unpublished_posts

Source code

function get_others_unpublished_posts($user_id, $type='any') {

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

}