Still looking for help on this. Anyone?
840204
Hello, I’m using the plugin “Compact Archives” and I need to make a modification to filter the wordpress Archivem and that it only shows a certain category (ID4).
What do I need to modify in this mySQL script?
*******************************************
if ($below21) {
$now = current_time(‘mysql’);
$results = $wpdb->get_results(“SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month FROM ” . $wpdb->posts . ” WHERE post_date <‘” . $now . “‘ AND post_status=’publish’ AND post_password=” ORDER BY year DESC, month DESC”);
} else {
$results = $wpdb->get_results(“SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month FROM ” . $wpdb->posts . ” WHERE post_type=’post’ AND post_status=’publish’ AND post_password=” ORDER BY year DESC, month DESC”);
}
******************************
Thanks in advance!
Just don’t double post – duplicate posts get deleted quickly.
aurielito,
Are you insane? You already posted this in ten different topics. STOP it!
