#### WIDGET ####

function add_widget_most_liked_posts() {
    function widget_most_liked_posts($args) {
        extract($args);
        $options = get_option("most_liked_posts");
        if (!is_array( $options )) {
            $options = array(
            'title' => 'Most liked posts',
            'number' => '5'
            );
        }
        $title = $options['title'];
        $numberOf = $options['number'];
        
        global $wpdb;
    
        $output = '';
        $request = "SELECT ID, post_title FROM $wpdb->posts, $wpdb->postmeta";
        $request .= " WHERE $wpdb->posts.ID=$wpdb->postmeta.post_id";
        $request .= " AND post_status='publish' AND post_type='post' AND meta_key='_liked'";
        $request .= " GROUP BY $wpdb->postmeta.post_id ORDER BY meta_value DESC LIMIT $numberOf";
        $posts = $wpdb->get_results($request);
    
        if ($posts) {
            echo $before_widget;
            echo $before_title . $title . $after_title;
            echo '<ul>';

            foreach ($posts as $post) {
                $post_title = stripslashes($post->post_title);
                $permalink = get_permalink($post->ID);
                
                echo '<li><a href="' . $permalink . '" title="' . $post_title.'" rel="nofollow">' . $post_title . '</a></li>';
            }

            echo '</ul>';
            echo $after_widget;
        }
    }    
    register_sidebar_widget('Most liked posts', 'widget_most_liked_posts');
    
    function options_widget_most_liked_posts() {
        $options = get_option("most_liked_posts");
        
        if (!is_array( $options )) {
            $options = array(
            'title' => 'Most liked posts',
            'number' => '5'
            );
        }
        
        if ($_POST['mlp-submit']) {
            $options['title'] = htmlspecialchars($_POST['mlp-title']);
            $options['number'] = htmlspecialchars($_POST['mlp-number']);
            if ( $options['number'] > 15) { $options['number'] = 15; }
            
            update_option("most_liked_posts", $options);
        }
        ?>
        <p><label for="mlp-title"><?php _e('Title:', 'i-like-this'); ?></label><br />
        <input class="widefat" type="text" id="mlp-title" name="mlp-title" value="<?php echo $options['title'];?>" /></p>
        
        <p><label for="mlp-number"><?php _e('Number of posts to show:', 'i-like-this'); ?></label><br />
        <input type="text" id="mlp-number" name="mlp-number" style="width: 25px;" value="<?php echo $options['number'];?>" /> <small>(max. 15)</small></p>
        
        <input type="hidden" id="mlp-submit" name="mlp-submit" value="1" />
        <?php
    }
    register_widget_control('Most liked posts', 'options_widget_most_liked_posts');
}

add_action('init', 'add_widget_most_liked_posts');

####