ja geht, ich hab es allerding nicht mit WP 2.5 getestet ;-)
<h3>Letzte Kommentare</h3>
<ul>
<?php $comments = $wpdb->get_results("SELECT comment_post_ID, comment_author, comment_author_email, comment_content, comment_date, DATE_FORMAT(comment_date,'%d.%m.%Y - %H:%i') AS new_comment_date
FROM $wpdb->comments
WHERE comment_type IN ( '', 'trackback', 'pingback' )
&& comment_approved = '1'
ORDER BY comment_date
DESC LIMIT 7"); ?>
<?php foreach($comments as $comment) {
$post = get_postdata($comment->comment_post_ID); ?>
<li>
<strong><?php echo $comment->comment_author; ?></strong> am<br />
<?php echo $comment->new_comment_date; ?> zu<br />
<a href="<?php echo get_permalink($post['ID']); ?>" title="<?php echo $post['Title']; ?>">
<?php echo $post['Title']; ?></a></li>
<?php } ?>
</ul>
Alles anzeigen