Some time ago I came up with a solution to this problem, which was subsequently improved upon by several additional contributors:
https://www.ads-software.com/support/topic/69776?replies=17
That code doesn’t work anymore in 2.13, but today I have got it working again, and here is what you need to do:
1) In wp_get_archives, add:
,'mcat' => false
after the currently last element in the “defaults” array (thanks to youngmicroserf).
2) Add this elseif code to the list of potential types:
<br />
elseif ( 'catmonthly' == $type ) {<br />
$arcresults = $wpdb->get_results("SELECT DISTINCT YEAR(post_date) AS <code></code>year<code>, MONTH(post_date) AS</code>month
, count(ID) as posts FROM $wpdb->posts, $wpdb->post2cat WHERE $wpdb->posts.ID = $wpdb->post2cat.post_id AND $wpdb->post2cat.category_id = ‘$mcat’ AND $wpdb->posts.post_type = ‘post’ AND $wpdb->posts.post_status = ‘publish’ GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC” . $limit);
if ( $arcresults ) {
$afterafter = $after;
foreach ( $arcresults as $arcresult ) {
$url = get_month_link($arcresult->year, $arcresult->month) .”?cat=” .$mcat;
$text = sprintf(__(‘%1$s %2$d’), $wp_locale->get_month($arcresult->month), $arcresult->year);
if ( $show_post_count )
$after = ‘?(‘.$arcresult->posts.’)’ . $afterafter;
echo get_archives_link($url, $text, $format, $before, $after);
}
}
}
(Sorry for the long code — pastebin doesn’t seem to be working at the moment)
The query above will work with version 2.13, but pay attention to the $url construction which uses ‘?cat=’. That assumes that the category filter will be the first argument, which will work if your permalinks are set to “Date and name based”. If you change your permalinks to “Default” you will want to replace ?cat= with &cat= here.
3) In sidebar.php, replace the existing Archive section with this:
<br />
<?php /* Whether this is a category archive */ if (is_category()) { ?></p>
li><h2>Archives for <?php single_cat_title(''); ?></h2>
<ul>
<?php $catmonthquery = ("type=catmonthly&mcat=" .($cat)); wp_get_archives($catmonthquery); ?>
</ul>
/li>
<p> <?php </p>
<p> } else { ?></p>
li><h2>Archives</h2>
<ul>
<?php wp_get_archives('type=monthly'); ?>
</ul>
/li>
<p> <?php } ?><br />
That all should work correctly — when you are looking at a single category, the archive navigation will only list months with entries for that category and the links will show archives that are filtered for that category.
BONUS: It also occurred to me that when looking at a single post, one might want to modify the archive navigation so that it shoes a separate archive for each category of which that post is a member. To do that, just insert this in the middle of the sidebar code above:
<br />
<?php } elseif (is_single()) {<br />
foreach((get_the_category()) as $cat) { ?></p>
li><h2>Archives for <?php echo $cat->cat_name . ' '; ?></h2>
<ul>
<?php $catmonthquery = ("type=catmonthly&mcat=" .($cat->cat_ID)); wp_get_archives($catmonthquery); ?>
</ul>
/li>
<p>
It goes right after the first li.
Hope that all is helpful and that people who need it can find this thread.
