<?php
/*
Plugin Name: BFA Popular in Cat
Plugin URI: http://wordpress.bytesforall.com/
Description: Configurable WordPress widget that displays the most popular posts in a given category based on the number of comments 
Version: 1.0
Author: BFA Webdesign
Author URI: http://www.bytesforall.com/
*/
/*
Based on Plugin "Most Commented" by Nick Momrik http://mtdewvirus.com/ Version 1.5
and the modification Last X days by DJ Chuang www.djchuang.com 
*/







	// This is the function that outputs our little widget
	function widget_mdv_most_commented_per_cat($args) {
	  extract($args);

	if (is_category() ) { 
		
		$cat_id = get_query_var('cat');

	  // Fetch our parameters
	  $bfa_pic_options = get_option('widget_mdv_most_commented_per_cat');
	  $bfa_pic_title = $bfa_pic_options['bfa_pic_title'];
	  $bfa_pic_no_posts = $bfa_pic_options['bfa_pic_no_posts'];
	  $bfa_pic_duration = $bfa_pic_options['bfa_pic_duration'];
	  $bfa_pic_min_amount_comments = $bfa_pic_options['bfa_pic_min_amount_comments'];
	  $bfa_pic_prepend_cat_title = $bfa_pic_options['bfa_pic_prepend_cat_title'];  
	  $bfa_pic_append_cat_title = $bfa_pic_options['bfa_pic_append_cat_title'];
	  
	  $current_cat_title = htmlentities(single_cat_title('', false),ENT_QUOTES);
	  if ($bfa_pic_prepend_cat_title == "on" ) { $bfa_pic_title = $current_cat_title . " " . $bfa_pic_title; }
	  if ($bfa_pic_append_cat_title == "on" ) { $bfa_pic_title = $bfa_pic_title . " " . $current_cat_title; }	  
	  	  
	  global $wpdb;


		$bfa_pic_request = "SELECT DISTINCT ID, post_title, comment_count FROM $wpdb->posts as p";
		$bfa_pic_request .= " INNER JOIN $wpdb->term_relationships AS tr ON";
		$bfa_pic_request .= " (p.ID = tr.object_id AND";
		$bfa_pic_request .= " tr.term_taxonomy_id = $cat_id )";
		$bfa_pic_request .= " INNER JOIN $wpdb->term_taxonomy AS tt ON";
		$bfa_pic_request .= " (tr.term_taxonomy_id = tt.term_taxonomy_id AND";
		$bfa_pic_request .= " taxonomy = 'category')";
		$bfa_pic_request .= " WHERE post_status = 'publish' AND comment_count >= $bfa_pic_min_amount_comments";
		$bfa_pic_request .= " AND post_password =''";
	
		if ($bfa_pic_duration !="") $bfa_pic_request .= " AND DATE_SUB(CURDATE(),INTERVAL ".$bfa_pic_duration." DAY) < post_date ";
	
		$bfa_pic_request .= " ORDER BY comment_count DESC LIMIT $bfa_pic_no_posts";
		$bfa_pic_posts = $wpdb->get_results($bfa_pic_request);

		if ($bfa_pic_posts) {
			$widget_mdv_most_commented_per_cat = '';
			foreach ($bfa_pic_posts as $bfa_pic_post) {
				$bfa_pic_post_title = stripslashes($bfa_pic_post->post_title);
				$bfa_pic_comment_count = $bfa_pic_post->comment_count;
				$bfa_pic_permalink = get_permalink($bfa_pic_post->ID);
				$widget_mdv_most_commented_per_cat .= '<li><a href="' . $bfa_pic_permalink . '" title="' . $bfa_pic_post_title.'">' . $bfa_pic_post_title . ' (' . $bfa_pic_comment_count . ')</a></li>';
			}
		} else {
			$widget_mdv_most_commented_per_cat = "None found";
		}
	

    if ($widget_mdv_most_commented_per_cat != "None found") {
    echo $before_widget . $before_title . $bfa_pic_title . $after_title;	
    echo "<ul>" . $widget_mdv_most_commented_per_cat . "</ul>";
    echo $after_widget;
    } else { return $widget_mdv_most_commented_per_cat; }
}
}


	// This is the function that outputs the form to let the users edit
	// the widget's parameters.
	function widget_mdv_most_commented_per_cat_control() {

	  // Fetch the options, check them and if need be, update the options array
	  $bfa_pic_options = $bfa_pic_newoptions = get_option('widget_mdv_most_commented_per_cat');
	  if ( isset($_POST["bfa_pic_src-submit"]) ) {
	    $bfa_pic_newoptions['bfa_pic_title'] = strip_tags(stripslashes($_POST["bfa_pic_src-title"]));
	    $bfa_pic_newoptions['bfa_pic_no_posts'] = (int) $_POST["bfa_pic_no_posts"];
	    $bfa_pic_newoptions['bfa_pic_duration'] = (int) $_POST["bfa_pic_duration"];
	    $bfa_pic_newoptions['bfa_pic_min_amount_comments'] = (int) $_POST["bfa_pic_min_amount_comments"];
	    $bfa_pic_newoptions['bfa_pic_append_cat_title'] = !isset($_POST["bfa_pic_append_cat_title"]) ? NULL : $_POST["bfa_pic_append_cat_title"];
	    $bfa_pic_newoptions['bfa_pic_prepend_cat_title'] = !isset($_POST["bfa_pic_prepend_cat_title"]) ? NULL : $_POST["bfa_pic_prepend_cat_title"];
	    	    	    	    
	  }
	  if ( $bfa_pic_options != $bfa_pic_newoptions ) {
	    $bfa_pic_options = $bfa_pic_newoptions;
	    update_option('widget_mdv_most_commented_per_cat', $bfa_pic_options);
	  }

	  // Default options to the parameters
	  if ( !isset($bfa_pic_options['bfa_pic_no_posts']) ) $bfa_pic_options['bfa_pic_no_posts'] = 10;
	  if ( !isset($bfa_pic_options['bfa_pic_min_amount_comments']) ) $bfa_pic_options['bfa_pic_min_amount_comments'] = 1;

	  $bfa_pic_no_posts = $bfa_pic_options['bfa_pic_no_posts'];
	  $bfa_pic_duration = $bfa_pic_options['bfa_pic_duration'];
	  $bfa_pic_min_amount_comments = $bfa_pic_options['bfa_pic_min_amount_comments'];
	  $bfa_pic_append_cat_title = $bfa_pic_options['bfa_pic_append_cat_title'];
	  $bfa_pic_prepend_cat_title = $bfa_pic_options['bfa_pic_prepend_cat_title'];
	  	  
	  // Deal with HTML in the parameters
	  $bfa_pic_title = htmlspecialchars($bfa_pic_options['bfa_pic_title'], ENT_QUOTES);

?>
	    Title: <input style="width: 450px;" id="bfa_pic_src-title" name="bfa_pic_src-title" type="text" value="<?php echo $bfa_pic_title; ?>" />
            <hr noshade size="1" style="clear:left; color: #ccc">
            <p style="text-align: left;"><input id="bfa_pic_prepend_cat_title" name="bfa_pic_prepend_cat_title" type="checkbox" <?php if($bfa_pic_prepend_cat_title == "on"){echo " CHECKED";}?> />Prepend &nbsp; 
            <p style="text-align: left;"><input id="bfa_pic_append_cat_title" name="bfa_pic_append_cat_title" type="checkbox" <?php if($bfa_pic_append_cat_title == "on"){echo " CHECKED";}?> /> Append &nbsp;&nbsp;&nbsp;Category Name to Title
            <hr noshade size="1" style="clear:left; color: #ccc">
            <p style="text-align: left;">Show <input style="width: 40px;" id="bfa_pic_no_posts" name="bfa_pic_no_posts" type="text" value="<?php echo $bfa_pic_no_posts; ?>" /> 
            posts not older than <input style="width: 60px;" id="bfa_pic_duration" name="bfa_pic_duration" type="text" value="<?php echo $bfa_pic_duration; ?>" /> days and with at least&nbsp;
   	    <input style="width: 40px;" id="bfa_pic_min_amount_comments" name="bfa_pic_min_amount_comments" type="text" value="<?php echo $bfa_pic_min_amount_comments; ?>" /> comments
   	    </p>
            <div style="clear:left"></div>
  	    <input type="hidden" id="bfa_pic_src-submit" name="bfa_pic_src-submit" value="1" />
<?php
	 }
	
	$widget_ops = array('classname' => 'widget_popular_in_cat', 'description' => __("Lists most commented posts of given category","atahualpa") );
	$control_ops = array('width' => 600, 'height' => 500);
	wp_register_sidebar_widget('popular_in_cat', __('BFA Popular in Cat','atahualpa'), 'widget_mdv_most_commented_per_cat', $widget_ops);
	wp_register_widget_control('popular_in_cat',  __('BFA Popular in Cat','atahualpa'), 'widget_mdv_most_commented_per_cat_control', $control_ops);	
?>