YuuXin

免插件实现WordPress侧边栏Recent Comments（最新评论）代码

秉承能少用插件，就不用插件的原则，完善Wordpress。如今可以无插件实现wordpress博客中侧边栏最新评论列表（Recent Comments），仅仅在sidebar.php中加以下代码即可。

<?php

global $wpdb;

$sql = “SELECT DISTINCT ID, post_title, post_password, comment_ID,

comment_post_ID, comment_author, comment_date_gmt, comment_approved,

comment_type,comment_author_url,

SUBSTRING(comment_content,1,30) AS com_excerpt

FROM $wpdb->comments

LEFT OUTER JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID =

$wpdb->posts.ID)

WHERE comment_approved = ‘1’ AND comment_type = ” AND

post_password = ”

ORDER BY comment_date_gmt DESC

LIMIT 10″;

$comments = $wpdb->get_results($sql);

$output = $pre_HTML;

foreach ($comments as $comment) {

$output .= “\n<li>”.strip_tags($comment->comment_author)

.”:” . ” <a href=\”” . get_permalink($comment->ID) .

“#comment-” . $comment->comment_ID . “\” title=\”on ” .

$comment->post_title . “\”>” . strip_tags($comment->com_excerpt)

.”</a></li>”;

}

$output .= $post_HTML;

echo $output;?>

SUBSTRING(comment_content,1,30)

LIMIT 10″;

$sql = “SELECT DISTINCT ID, post_title, post_password, comment_ID,

comment_post_ID, comment_author, comment_date_gmt, comment_approved,

comment_type,comment_author_url,comment_author_email

foreach ($comments as $comment) {

$output .= “\n<li>”.get_avatar(get_comment_author_email(‘comment_author_email’), 32).strip_tags($comment->comment_author)

.”:” . ” <a href=\”” . get_permalink($comment->ID) .

“#comment-” . $comment->comment_ID . “\” title=\”on ” .

$comment->post_title . “\”>” . strip_tags($comment->com_excerpt)

.”</a></li>”;

}

WHERE comment_approved = ‘1’ AND comment_type = ” AND

post_password = ‘

WHERE comment_approved = ‘1’ AND comment_type = ” AND

post_password = ” AND user_id=”0″