Recent Comments – Side Bar – Extension?

  • 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?

Viewing 3 replies - 1 through 3 (of 3 total)

  • 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 ??

    Thread Starter honhaar

    (@honhaar)

    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.

    Thanks Hellyer,
    It helped me a lot. It works!!!!

    [sig moderated]

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Recent Comments – Side Bar – Extension?’ is closed to new replies.