WordPress.org

Ready to get started?Download WordPress

Forums

Recent Comments - Side Bar - Extension? (4 posts)

  1. Honhaar
    Member
    Posted 6 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?

  2. Ryan Hellyer
    Member
    Posted 6 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

  3. Honhaar
    Member
    Posted 6 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.

  4. A Niraj Kumar
    Member
    Posted 5 years ago #

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

    [sig moderated]

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.