Read the rest of this page »

'); ?> ', '

'); ?>

Archives by Date:

get_results("SELECT DISTINCT YEAR(post_date) AS year, MONTH(post_date) AS month, count(ID) as posts FROM " . $wpdb->posts . " WHERE post_date <'" . $now . "' AND post_status='publish' AND post_password='' GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC"); if ($arcresults) { foreach ($arcresults as $arcresult) { $url = get_month_link($arcresult->year, $arcresult->month); $text = sprintf('%s %d', $month[zeroise($arcresult->month,2)], $arcresult->year); echo get_archives_link($url, $text, '','',''); $thismonth = zeroise($arcresult->month,2); $thisyear = $arcresult->year; $arcresults2 = $wpdb->get_results("SELECT ID, post_date, post_title, comment_status FROM " . $wpdb->posts . " WHERE post_date LIKE '$thisyear-$thismonth-%' AND post_date <'" . $now . "' AND post_status='publish' AND post_password='' ORDER BY post_date DESC"); if ($arcresults2) { echo "

\n"; foreach ($arcresults2 as $arcresult2) { if ($arcresult2->post_date != '0000-00-00 00:00:00') { $url = get_permalink($arcresult2->ID); $arc_title = $arcresult2->post_title; if ($arc_title) $text = strip_tags($arc_title); else $text = $arcresult2->ID; $title_text = wp_specialchars($text, 1); echo '
• ' . mysql2date('d', $arcresult2->post_date). ': ' . "$text"; $comments_count = $wpdb->get_var("SELECT COUNT(comment_id) FROM " . $wpdb->comments . " WHERE comment_post_ID=" . $arcresult2->ID . " AND comment_approved='1'"); if ($arcresult2->comment_status == "open" OR $comments_count > 0) echo ' (' . $comments_count . ')'; echo '
'; } } echo '

'; } } } ?>

Archives by Category:

Archives by Tag: