'AcerRecentComments', 'description' => 'The most recent posts on your site.' ); $this->WP_Widget('AcerRecentComments', 'Acer - Recent Comments', $widget_ops); } function form($instance) { $instance = wp_parse_args( (array) $instance, array( 'title' => '' ) ); $title = $instance['title']; $order = $instance['order']; $avatar = $instance['avatar']; $num = $instance['num']; $limit = $instance['limit']; ?>

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 $num"; $comments = $wpdb->get_results($sql); ?>