[Plugin: WordPress Popular Posts] Filter by Custom Post Types

Hi Ikki,

It actually wasn’t too difficult to update the plug-in to support custom post types. Here’s what I did – if you’d like, I can send you the file.

General steps:

1. Remove the current post/page options.
2. Query the public custom post types and generate a select list.
3. Add in support for the option.
4. Change $nopages to the new SQL query variable based on the value of the post type select field.

Actual code:

Comment out this line:

//$instance['pages'] = $new_instance['pages'];

Add this line around line 172:

$instance['posttype'] = $new_instance['posttype'];

Comment out this line in the form function:

//'pages' => true,

Add in this line in the form function around line 219:

'posttype' => 'all',

Delete the checkbox section for ‘pages’ on the form.

Add this code to the form for the widget above the thumbnail section:

<fieldset class="widefat">
			<legend><?php _e('Select Post Types', 'wordpress-popular-posts'); ?></legend>
			<select id="<?php echo $this->get_field_id( 'posttype' ); ?>" name="<?php echo $this->get_field_name( 'posttype' ); ?>">
			<option value="all"<?php if ( $instance['posttype'] == "all" ) : ?> selected="selected"<?php endif; ?>><?php _e('All', 'wordpress-popular-posts'); ?></option>
			<option value="pagesposts"<?php if ( $instance['posttype'] == "pagesposts" ) : ?> selected="selected"<?php endif; ?>><?php _e('Posts and Pages', 'wordpress-popular-posts'); ?></option>
			   	<?php
				// Thank you to John James Jacoby for this code from post-type-switcher
				$safe_filter = array( 'public' => true, 'show_ui' => true );
	            $post_types = get_post_types( (array)$safe_filter );

	foreach ( $post_types as $post_type ) {
			$pt = get_post_type_object( $post_type );
?>
			<option value="<?php echo $pt->name; ?>"<?php if ( $instance['posttype'] == $pt->name ) : ?> selected="selected"<?php endif; ?>><?php echo $pt->label; ?></option>
<?php
		} ?>
			</select>
			</fieldset>
			<br />

Near the top of the get_popular_posts function, add this code and comment out the old code:

// Support custom post types
			if ( $instance['posttype'] == 'all' ) {
                 $nopages = '';
            } else {
              if ( $instance['posttype'] == 'pagesposts' ) {
                 $nopages = "AND ($wpdb->posts.post_type = 'post' OR $wpdb->posts.post_type = 'pages')";
              } else {
                 $nopages = "AND $wpdb->posts.post_type = '" .$instance['posttype'] . "'";
              }
            }			  

            // Deprecated with post-type support above
			//if ( $instance['pages'] ) {
			//	$nopages = '';
			//} else {
			//	$nopages = "AND $wpdb->posts.post_type = 'post'";
			//}

If you see anything I did wrong, please let me know, but it seems to work fine. Thanks for creating such a great, easy to use plug in.

Jeremy

One caveat that I didn’t think of: the exclude categories portion of the widget likely won’t work with custom post types in their current form. Custom post types have the ability to create custom taxonomies, but I’m sure querying based on those taxonomies use slightly different code. This may be something I need in the future and I’ll address it at some point.

I believe, you would have to provide an additional option and change this line:

WHERE x.taxonomy = 'category'

to dynamic based on the taxonomy selected.