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.
Thanks, I’ll try it soon. Usually upgrading to a new version of wordpress will have plugins problem.
Halim-Belajar SEOs last blog post..Belajar SEO got a grade B+
Wow that’s amazing! thank you very much!