Couple of week ago, i upgrade my wordpress to new version, WordPress 2.5. All my plugin didn’t problem, but Get Recent Comment Plugin showing error message. I try to update it but still getting error. I install similiar plugin also showing same error. Luckily i found this piece of code in tutorialtheme that can display god list of recent comment.
Here is the code to display recent comment :
[code lang=”php”]
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;
$output .= “\n
- “;
- “.strip_tags($comment->comment_author)
.”:” . ” ID) .
“#comment-” . $comment->comment_ID . “\” title=\”on ” .
$comment->post_title . “\”>” . strip_tags($comment->com_excerpt)
.”
foreach ($comments as $comment) {
$output .= “\n
“;
}
$output .= “\n
“;
$output .= $post_HTML;
echo $output;
?>
[/code]
You can configure how many character that you want to display by changing this line :
[code lang=”php”]
SUBSTRING(comment_content,1,30) AS com_excerpt
[/code]
value 30 mean only fist 30 charactar will display.
You see the demo on side bar in this blog.
Copy this code to your PHP widget.
