How to List Private Posts as Well as Published Ones

Well, I solved it, but it would have been nice to do it in a less “hacky” fashion:

function lp_get_posts()
{
	global $wpdb;
	$today = current_time('mysql', 1);

	return $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_type = 'post' AND " . get_private_posts_cap_sql('post') . " AND post_date_gmt < '$today' ORDER BY post_date DESC LIMIT 5");
}

function listposts ( $in_content )
{
	if ( preg_match ( "/<!-- LIST_POSTS -->/", $in_content ) )
		{
		$posts = lp_get_posts();

so how did you use this code in your template ?

Here’s the whole kit n’ kaboodle. Open wide…

<?php
/*
Plugin Name: ListPosts
Version: 1.0
Plugin URI: https://www.example.com
Description: Lists new posts like the front page.. Add <!- - LIST_POSTS - -> to a page or a post to generate the form.
Author: Example
Author URI: https://www.exa,ple.com
*/
function lp_get_the_password_form($id) {
	$id = "password_$id";
	$output = '<form action="' . get_option('siteurl') . '/wp-pass.php" method="post">
	<p>' . __("This post is password protected. To view it please enter your password below:") . '</p>
	<p><label for="'.__($id).'">' . __("Password:") . '</label> <input name="post_password" id="'.__($id).'" type="password" size="20" /> <input type="submit" name="Submit" value="' . __("Submit") . '" /></p>
	</form>
	';
	return $output;
}
function lp_get_posts()
{
	global $wpdb;
	$today = current_time('mysql', 1);

	return $wpdb->get_results("SELECT * FROM $wpdb->posts WHERE post_type = 'post' AND " . get_private_posts_cap_sql('post') . " AND post_date_gmt < '$today' ORDER BY post_date DESC LIMIT 5");
}

function listposts ( $in_content )
{
	if ( preg_match ( "/<!-- LIST_POSTS -->/", $in_content ) )
		{
		$posts = lp_get_posts();
		ob_start();
			?><div class="listposts_new_posts">
			<div class="listposts_header">Latest Information</div><?php
				ec3_filter_the_posts ( $posts );
				$mypost = current ( $posts );
				while ( $mypost )
					{
					if ( !$mypost->ec3_schedule )
						{
						$url = get_permalink( $mypost->ID );
						$title = htmlspecialchars( $mypost->post_title );
						$meta = '';
						$cats = wp_get_post_categories ( $mypost->ID );
						foreach ( $cats as $cat )
							{
							if ( $meta )
								{
								$meta .= ", ";
								}
							$meta .= '<a href="' . get_category_link($cat) . '" title="' . sprintf(__("View all posts in %s"), get_the_category_by_ID($cat)) . '">'.get_the_category_by_ID($cat).'</a>';
							}
						ec3_filter_the_content ( $mypost->post_content );
						$content = $mypost->post_content;
						if ( !empty($mypost->post_password) )
							{ // if there's a password
							if ( stripslashes($_COOKIE['wp-postpass_'.COOKIEHASH]) != $mypost->post_password )
								{	// and it doesn't match the cookie
								$content = lp_get_the_password_form($mypost->ID);
								}
							}
						$content = apply_filters ( 'the_content', $content );
						$content = str_replace(']]>', ']]>', $content);
						$content = get_extended ( $content );
						echo '<div class="listposts_post">';
							echo '<div class="listposts_post_title"><a href="'.$url.'">';
							echo $title;
							echo '</a></div>';
							if ( $meta )
								{
								echo '<div class="listposts_category_meta">Posted in '.$meta.'</div>';
								}
							echo '<div class="listposts_post_teaser">'.$content['main'];
							if ( $content['extended'] )
								{
								echo '<div class="listposts_post_more"><a href="'.$url.'">Read More...</a></div>';
								}

							$mypost = next ( $posts );

							if ( $mypost )
								{
								echo '<div class="post_separator"></div>';
								}
							echo '</div>';
						}
					else
						{
						$mypost = next ( $posts );
						}
					echo '</div>';
					}
			$display = ob_get_contents();
		ob_end_clean();
		$in_content = preg_replace ( "/(<p[^>]*>)*?<!-- LIST_POSTS -->(<\/p[^>]*>)/", $display, $in_content );
		}

	return $in_content;
}
add_filter ( 'the_content', 'listposts' );
?>

Just FYI. I just fixed an error:

else
						{
						$mypost = next ( $posts );
						}
					echo '</div>';
					}
/* THIS IS THE FIX */		echo '</div> <!-- listposts_new_posts -->';
			$display = ob_get_contents();

You can delete the calendar stuff. I added a filter to remove eventcalendar3 entries.

I’ve tried to install this plugin/code, but it didn’t work as intended.

Has anyone figured out a better way to display private postings?