BooBooBear
Member
Posted 3 years ago #
Everytime someone posts a comment it goes into the January 2008 archive (the month and year I started with WordPress).
I'd like the posts to go in their respective Month/Year archive folder. Obviously if someone posts today I'd like it in the July 2008 archive.
Can someone shed light on this for me?
BooBooBear
Member
Posted 3 years ago #
Still looking for help on this. Anyone?
Anonymous
Unregistered
Posted 3 years ago #
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!