Widget

<?php
/**
 * Makes a custom Widget for displaying Aside, Link, Status, and Quote Posts available with Twenty Eleven
 *
 *
 * @package WordPress
 * @subpackage Tauno
 * @since Tauno 1.0
 */
class Popular_Comments extends WP_Widget {
    /**
     * Constructor
     *
     * @return void
     **/
    function Popular_Comments() {
        $widget_ops = array( 'classname' => 'tabs', 'description' => __( 'Show popular Posts and recent Comments', 'tauno' ) );
        $this->WP_Widget( 'tabs_populra_comments', __( 'Show Posts and Comments', 'tauno' ), $widget_ops );
        $this->alt_option_name = 'tabs_populra_comments';
    }
    /**
     * Outputs the HTML for this widget.
     *
     * @param array An array of standard parameters for widgets in this theme
     * @param array An array of settings for this widget instance
     * @return void Echoes it's output
     **/
    function widget( $args, $instance ) {
        extract( $args );
        $title = apply_filters( 'widget_title', $instance['title'] );

        echo $before_widget;
        if ( ! empty( $title ) )
            //echo $before_title . $title . $after_title;

        $comment_title = $instance['comment'];
        $post_title  = $instance['posts'];
        $comment_size = $instance['comment_size'];
        $post_size = $instance['posts_size'];

        ?>
        <div class="tabs_titles">
            <a href="#recent_comments" class="active"><?php echo $instance['comment'];?></a>
            <a href="#popular_posts"><?php echo $instance['posts'];?></a>
        </div>

        <div class="clear"></div>

        <div class="tab_content">
            <!-- Recent Comments Tab -->
            <?php $defaults = array(
                    'number' => $comment_size ,
                    'status' => 'approve'
                    ); ?>

            <?php $comments = get_comments( $defaults ); ?>
            <?php if($comments) { ?>
            <div id="recent_comments">
                <ul class="recent_comments">
                    <?php foreach($comments as $comment) : ?>
                    <li>
                        <div class="author_thumb">
                            <?php echo get_avatar( $comment, 54 ); ?>
                        </div>

                        <div class="author_info">
                            <a href="<?php echo($comment->comment_author_url); ?>" class="author_name"><?php echo($comment->comment_author); ?></a>                             <span class="timespan"><?php echo($comment->comment_date ); ?></span>
                            <p>
                               <?php echo($comment->comment_content); ?>
                            </p>
                        </div>

                        <div class="clear"></div>
                    </li>
                    <?php endforeach;?>
                </ul>
            </div>
            <!-- End of: Recent Comments Tab -->
            <?php
            wp_reset_postdata();
            wp_reset_query();
            ?>
            <?php global $wpdb;//".$wpdb->prefix."
            $query = "SELECT wpp.post_title, wpp.ID as post_id_com , count(comment_ID) com_id, comment_post_ID, user_id FROM ".$wpdb->prefix."comments wc inner join ".$wpdb->prefix."posts wpp where post_type='post' && wc.comment_post_id = wpp.ID group by comment_post_ID order by com_id desc limit ".$post_size;
            $query_posts = $wpdb->get_results($query,OBJECT);
            ?>
            <?php if($query_posts){ ?>
            <div id="popular_posts">
                <ul class="recent_posts small_plus">
                    <!-- Post Entry -->
                    <?php
                    foreach($query_posts as $post)
                    {
                        $post_new = get_post($post->post_id_com);
                        ?>
                        <li>
                            <div class="post_thumb">
                                <a href="<?php echo $post_new->guid; ?>" >
                                    <?php echo get_the_post_thumbnail($post->post_id_com, 'image-10') ?>
                                </a>
                            </div>
                            <div class="post_info">
                                <a href="<?php echo $post_new->guid; ?>" class="title">
                                    <?php echo $post_new->post_title ?>
                                </a>
                                <div class="author_date">
                                Por <a href="<?php echo get_the_author_meta( 'user_url', $post_new->post_author); ?>">
                                <?php echo get_the_author_meta( 'user_nicename', $post_new->post_author); ?>
                                </a> em <a href="#"><?php echo $post_new->post_date  ?></a>
                                </div>
                            </div>
                            <div class="clear"></div>
                        </li>
                    <?php
                    }
                    wp_reset_postdata();
                    wp_reset_query();
                    ?>
                    <!-- End of: Post Entry -->
                </ul>
            </div>
            <?php } ?>
        </div>
        <?php
        echo $after_widget;
    }
    /**
     * Deals with the settings when they are saved by the admin. Here is
     * where any validation should be dealt with.
     **/
    function update( $new_instance, $old_instance ) {
        $instance = array();
        $instance['comment'] = strip_tags( $new_instance['comment'] );
        $instance['posts'] = strip_tags( $new_instance['posts'] );
        $instance['comment_size'] = strip_tags( $new_instance['comment_size'] );
        $instance['posts_size'] = strip_tags( $new_instance['posts_size'] );
        return $instance;
    }
    /**
     * Displays the form for this widget on the Widgets page of the WP Admin area.
     **/
    function form( $instance ) {

        $comment =  $instance[ 'comment' ];
        $posts =  $instance[ 'posts' ];
        $comment_size =  $instance[ 'comment_size' ];
        $posts_size =  $instance[ 'posts_size' ];
        ?>
        <p>
        <label for="<?php echo $this->get_field_id( 'comment' ); ?>"><?php _e( 'Comment Title:' , 'tauno'); ?></label>
        <input class="widefat" id="<?php echo $this->get_field_id( 'comment' ); ?>" name="<?php echo $this->get_field_name( 'comment' ); ?>" type="text" value="<?php echo esc_attr( $comment ); ?>" />
        </p>
        <p>
        <label for="<?php echo $this->get_field_id( 'comment_size' ); ?>"><?php _e( 'Items Show :' , 'tauno'); ?></label>
        <input class="widefat" id="<?php echo $this->get_field_id( 'comment_size' ); ?>" name="<?php echo $this->get_field_name( 'comment_size' ); ?>" type="text" value="<?php echo esc_attr( $comment_size ); ?>" />
        </p>
        <p>
        <label for="<?php echo $this->get_field_id( 'posts' ); ?>"><?php _e( 'Post Title:' , 'tauno'); ?></label>
        <input class="widefat" id="<?php echo $this->get_field_id( 'posts' ); ?>" name="<?php echo $this->get_field_name( 'posts' ); ?>" type="text" value="<?php echo esc_attr( $posts ); ?>" />
        </p>
        <p>
        <label for="<?php echo $this->get_field_id( 'posts_size' ); ?>"><?php _e( 'Items Show :', 'tauno' ); ?></label>
        <input class="widefat" id="<?php echo $this->get_field_id( 'posts_size' ); ?>" name="<?php echo $this->get_field_name( 'posts_size' ); ?>" type="text" value="<?php echo esc_attr( $posts_size ); ?>" />
        </p>
        <?php
    }
}
function myplugin_register_widgets_ppcm() {
    register_widget( 'Popular_Comments' );
}
add_action( 'widgets_init', 'myplugin_register_widgets_ppcm' );
?>