Posted 5 years ago #
We have Recent Comments Side Bar, which shows 20 latest comments. But I would like to extend that by giving readers an option to view more than 20 latest comments - have Recent Comments open in a new window and will show all the comments. Like, the comment section in the admin area. But readers would not get edit option. External Comment.Php.
Is that possible? Is there any plugin for that?
Posted 5 years ago #
There is no need for a plugin for that. You easily add that directly to your theme.
The following script will display 384 recent comments. Just chuck it into your sidebar and they will appear :)
<?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,28) 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 384";
$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=\"" . get_permalink($comment->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;
?>... obviously you can change the 384 to whatever you want :P
Posted 5 years ago #
Thanks. Just to clarify, I want an option, "View More Comments" - which will open up in a new window. Will the above code do that? I don't want to show more than 20 comments in the sidebar, but want to give the reader an option to view more comments.
Posted 4 years ago #
Thanks Hellyer,
It helped me a lot. It works!!!!
[sig moderated]
This topic has been closed to new replies.
