How To Exclude Categories in WordPress Archives Drop-down

This is a follow-up post to my Excluding Categories from Different Parts of WordPress post a while back. The problem I was having is that the posts in my Testing and Daily Tweets categories where being counted and shown in the Archives drop-down widget. For example, it showed 4 posts in April 2011. When selecting April 2011 in the drop-down, you would get the “404 Not Found” page since all 4 posts belonged in the Daily Tweets category which is excluded from showing in the main blog, except when being accessed via the Category drop-down.

After some searching, I found the following thread: wp_get_archives and Conditional Tags and adapted the code as follows in my theme’s functions.php file:

add_filter( 'getarchives_where', 'customarchives_where' );
add_filter( 'getarchives_join', 'customarchives_join' );
function customarchives_join( $x ) {
	global $wpdb;
	return $x . " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id)";
function customarchives_where( $x ) {
	global $wpdb;
   // 61 = Daily Tweets, 74 = Testing
	$exclude = '61,74'; // category id to exclude
	return $x . " AND $wpdb->term_taxonomy.taxonomy = 'category' AND $wpdb->term_taxonomy.term_id NOT IN ($exclude)";

Now, it does not count those posts in the Archives drop-down. Yay! :)

Blog Updated to WordPress v4.2

A couple days after WordPress 4.1.2 came out, WordPress 4.2 did. I have thus upgraded my blog to it. They also updated most of the default themes including the one I use, TwentyTwelve. I did a file comparison and noticed that the header.php file was the only one I needed to update for my child theme.As always, I did a complete database and file structure back-up before doing anything.

One thing I’ve noticed while making this post is the highlighted text is automatically placed into the “Link text” field of the Insert/edit Link button. Anyway, I’ll let you read the WordPress 4.2 stuff for all the changes and fixes. :) 

Website Changes for April 2015

Main Website

I updated my NASCAR page to get its news feed from Yahoo instead of ESPN after it started to bug out. I also added a new speed test to my Latest Speed Test Results page. It’s DSLReports‘ new Speed Test which is still a work in progress.

Finally, I’ve started to test out using HTML5 with Flash fallback video players on my site. I am using my Inception Blu-ray page for these tests. Currently I am testing out Mediaelement.js player. I have also tried out the JW Player and Video JS players. I suppose I should make one test page for each player to see which works best.  I’d use the JWPlayer if it didn’t have the logo always on the player (the free one anyway). I’m still playing with them to see which I like better.


The main thing with my blog is that I have disabled the Really Simple Share plugin because of what they’ve started doing with it and am now using the Jetpack Sharedaddy module to place Twitter, Facebook, and Google+ buttons on my posts. Using it for now anyway.

That’s all for now. If I think of anything else I’ll update this post. :)