Hallo,
ich liebe das "Previous Posts Plugin" von http://wpthemes.info/posts/2004/12/07/previous-n-posts/ (Sadish Balasubramanian) wohlgemerkt aus dem Jahr "2004".
Leider scheinen sich in der WP3 einige Tabellen oder Hooks verändert zu haben, so das der MYSQL Query immer zurück gibt das es keine weiteren Einträge gibt.
Hat hier jemand den Überblick?
PHP
<?php
/*
Plugin Name: Previous Posts
Plugin URI: http://wpthemes.info/posts/2004/12/07/previous-n-posts/
Description: Returns a list of the previous 'n' posts.
Version: 1.1
Author: Sadish Balasubramanian
Author URI: http://wpthemes.info/
*/
function get_previous_posts($no_posts = 5, $before = '<li>', $after = '</li>', $show_pass_post = false, $current_post_date='', $show_excerpts = false) {
global $wpdb, $tableposts;
$request = "SELECT ID, post_title, post_excerpt,post_date FROM $tableposts WHERE post_status = 'publish' and post_type='post' ";
if(!$show_pass_post) $request .= "AND post_password ='' ";
$request .= "AND post_date < '".$current_post_date."' ORDER BY post_date DESC LIMIT $no_posts";
$posts = $wpdb->get_results($request);
$output = '';
if($posts) {
foreach ($posts as $post) {
$post_title = stripslashes($post->post_title);
$permalink = get_permalink($post->ID);
$output .= $before . '<a href="' . $permalink . '" rel="bookmark" title="' . date('M d Y',strtotime($post->post_date)). ' | '. $post_title . '">' . $post_title . '</a>';
if($show_excerpts) {
$post_excerpt = stripslashes($post->post_excerpt);
$output.= '<br />' . $post_excerpt;
}
$output .= $after;
}
}
else
{
$output = "No More Previous Posts";
}
echo $output;
}
?>
Alles anzeigen