Recently modified posts

  • Resolved deckster0

    (@deckster0)


    14 years, 12 months ago

    I found this om wp-recipes, could someone modify this code so that it only lists a new post if pressed “update post” and not publish.”

    <?php
$today = current_time('mysql', 1);
$howMany = 5; //Number of posts you want to display
if ( $recentposts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND post_modified_gmt < '$today' ORDER BY post_modified_gmt DESC LIMIT $howMany")):
?>

<h2><?php _e("Recent Updates"); ?></h2>
<ul>
<?php
	foreach ($recentposts as $post) {
		if ($post->post_title == '') $post->post_title = sprintf(__('Post #%s'), $post->ID);
		echo "<li><a href='".get_permalink($post->ID)."'>";
		the_title();
		echo '</a></li>';
	}
?>
</ul>
<?php endif; ?>
Viewing 1 replies (of 1 total)

  • This will return posts where the post date and the post modified date do NOT match

    Change:

    if ( $recentposts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND post_modified_gmt < '$today' ORDER BY post_modified_gmt DESC LIMIT $howMany")):

    to:

    if ( $recentposts = $wpdb->get_results("SELECT ID, post_title FROM $wpdb->posts WHERE post_status = 'publish' AND post_modified_gmt != post_date_gmt ORDER BY post_modified_gmt DESC LIMIT $howMany")):

Viewing 1 replies (of 1 total)
  • The topic ‘Recently modified posts’ is closed to new replies.