Get the latest comments for a custom post type in WordPress

 
/* Get recent comments */
global $wpdb;
 
$sql = "SELECT * 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 = '' AND post_type='your_custom_post_type' ORDER BY comment_date_gmt DESC LIMIT 5";
 
$comments = $wpdb->get_results($sql);
 
foreach ($comments as $comment) {
  // we need the comment comment user_id in case it's a logged in user so we can echo the display name and not username
  if ($comment->user_id != 0) {
    $curent_userdata = get_userdata($comment->user_id);
    echo $curent_userdata->display_name;
  } else {
    echo strip_tags($comment->comment_author);
  }
 
  // the permalink for the comment
  echo get_permalink($comment->ID) . '#comment-' . $comment->comment_ID;
 
  // the post title where that comment was posted
  echo $comment->post_title; 
 
  // display the comment content
  echo strip_tags($comment->comment_content);
}

post_type='your_custom_post_type'

 
<?php
/*
Plugin Name: Latest CPT Comments Plugin
Plugin URI: http://www.cozmoslabs.com/
Description: Display the latest comments on a custom post type
Version: 0.1
Author: Cristian Antohe
Author URI: http://cozmoslabs.com
License: GPL2
 
== Copyright ==
Copyright 2011 Reflection Media (wwww.reflectionmedia.ro)
 
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
*/
 
add_action( 'widgets_init', 'cl_cpt_comments_load_widgets' );
 
function cl_cpt_comments_load_widgets() {
	register_widget( 'cl_cpt_comments_Widget' );
}
 
class cl_cpt_comments_Widget extends WP_Widget {
 
	/**
	 * Widget setup.
	 */
	function cl_cpt_comments_Widget() {
		/* Widget settings. */
		$widget_ops = array( 'classname' => 'cl_cpt_comments_widget', 'description' => __('A widget that displays your latest custom post type comments', 'cl_cpt_comments_widget') );
 
		/* Widget control settings. */
		$control_ops = array( 'width' => 250, 'height' => 350, 'id_base' => 'cl_cpt_comments_widget' );
 
		/* Create the widget. */
		$this->WP_Widget( 'cl_cpt_comments_widget', __('Latest custom post type comments', 'cl_cpt_comments_widget'), $widget_ops, $control_ops );
	}
 
	/**
	 * How to display the widget on the screen.
	 */
	function widget( $args, $instance ) {
		extract( $args );
 
		/* Our variables from the widget settings. */
		$title = apply_filters('widget_title', $instance['title'] );
		$number = $instance['number'];
 
		/* Before widget (defined by themes). */
		echo $before_widget;
 
		/* Display the widget title if one was input (before and after defined by themes). */
		if ( $title )
			echo '<h3 class="widget-title">' . $title . '</h4>';
 
		/* Get recent comments */
		global $wpdb;
		$sql = "SELECT * 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 = '' AND post_type='your_custom_post_type' ORDER BY comment_date_gmt DESC LIMIT $number";
		$comments = $wpdb->get_results($sql);
		echo '<ul class="cpt-comments">';
		foreach ($comments as $comment) {
			if ($comment->user_id != 0) {
				$curent_userdata = get_userdata($comment->user_id);
				$current_comment_display_name = $curent_userdata->display_name;
			} else {
				$current_comment_display_name = strip_tags($comment->comment_author);
			}						
		?>
			<li class="cpt-comment">
				<p class="comment-cpt-title"><a href="<?php echo get_permalink($comment->ID); ?>#comment-<?php echo $comment->comment_ID; ?>" rel="bookmark"><?php echo get_the_title($comment->comment_post_ID); ?></a></p>
				<p class="comment-author"><?php echo $current_comment_display_name  ?> says:</p><a class="comment-text-side" href="<?php echo get_permalink($comment->ID); ?>#comment-<?php echo $comment->comment_ID; ?>" title="<?php echo strip_tags($comment->comment_author); ?> on <?php echo $comment->post_title; ?>"><?php echo strip_tags($comment->comment_content); ?></a>
			</li>
		<?php 
		}
		echo '</ul>';
 
		/* After widget (defined by themes). */
		echo $after_widget;
	}
 
	/**
	 * Update the widget settings.
	 */
	function update( $new_instance, $old_instance ) {
		$instance = $old_instance;
 
		/* Strip tags for title and name to remove HTML (important for text inputs). */
		$instance['title'] = strip_tags( $new_instance['title'] );
		$instance['number'] = strip_tags( $new_instance['number'] );
 
		return $instance;
	}
 
 
	function form( $instance ) {
 
		/* Set up some default widget settings. */
		$defaults = array( 'title' => __('Latest CPT Comments'), 'number' => __('5'));
		$instance = wp_parse_args( (array) $instance, $defaults ); ?>
 
		<!-- Widget Title: Text Input -->
		<p>
			<label for="<?php echo $this->get_field_id( 'title' ); ?>"><?php _e('Title:', 'hybrid'); ?></label>
			<input id="<?php echo $this->get_field_id( 'title' ); ?>" name="<?php echo $this->get_field_name( 'title' ); ?>" value="<?php echo $instance['title']; ?>" style="width:90%;" />
		</p>
 
		<!-- Number of posts -->
		<p>
			<label for="<?php echo $this->get_field_id( 'number' ); ?>"><?php _e('Number of posts to show:'); ?></label>
			<input id="<?php echo $this->get_field_id( 'number' ); ?>" name="<?php echo $this->get_field_name( 'number' ); ?>" value="<?php echo $instance['number']; ?>" size="3" />
		</p>
 
 
 
 
	<?php
	}
}
 
?>