Create You Own Get Recent Comments Widget

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 :

<?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;
$output .= "\n
<ul>";
foreach ($comments as $comment) {

$output .= "\n
<li>".strip_tags($comment->comment_author)
.":" . " <a href="\">ID) .
"#comment-" . $comment->comment_ID . "\" title=\"on " .
$comment->post_title . "\">" . strip_tags($comment->com_excerpt)
."</a></li>
";

}
$output .= "\n</ul>
";
$output .= $post_HTML;

echo $output;

?>

You can configure how many character that you want to display by changing this line :

SUBSTRING(comment_content,1,30) AS com_excerpt

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.

Related articles by Zemanta

• Who Else Has Upgraded to WordPress 2.5?