class="posts" to the cell of any date containing posts, and class values of first or last to the first or last cells in a given table row. Finally, the calendar does not generate a tfoot at all if there are no previous or next months (unlikely, but it happens).
Version: 1.1
Date: 1 February 2005
Author: Eric A. Meyer
Author URI: http://meyerweb.com/
*/
function mw_get_calendar($daylength = 1, $nextSymbol='', $prevSymbol='', $currentSymbol='') {
global $wpdb, $HTTP_GET_VARS, $m, $monthnum, $year, $timedifference, $month, $weekday, $tableposts, $posts;
// Quick check. If we have no posts at all, abort!
if (!$posts) {
$gotsome = $wpdb->get_var("SELECT ID from $tableposts WHERE post_status = 'publish' ORDER BY post_date DESC LIMIT 1");
if (!$gotsome)
return;
}
if (isset($HTTP_GET_VARS['w'])) {
$w = ''.intval($HTTP_GET_VARS['w']);
}
$time_difference = get_settings('time_difference');
// Let's figure out when we are
if (!empty($monthnum) && !empty($year)) {
$thismonth = ''.intval($monthnum);
$thisyear = ''.intval($year);
} elseif (!empty($w)) {
// We need to get the month from MySQL
$thisyear = ''.intval(substr($m, 0, 4));
$d = (($w - 1) * 7) + 6; //it seems MySQL's weeks disagree with PHP's
$thismonth = $wpdb->get_var("SELECT DATE_FORMAT((DATE_ADD('${thisyear}0101', INTERVAL $d DAY) ), '%m')");
} elseif (!empty($m)) {
$calendar = substr($m, 0, 6);
$thisyear = ''.intval(substr($m, 0, 4));
if (strlen($m) < 6) {
$thismonth = '01';
} else {
$thismonth = ''.intval(substr($m, 4, 2));
}
} else {
$thisyear = intval(date('Y', time()+($time_difference * 3600)));
$thismonth = intval(date('m', time()+($time_difference * 3600)));
}
$unixmonth = mktime(0, 0 , 0, $thismonth, 1, $thisyear);
// Get the next and previous month and year with at least one post
$previous = $wpdb->get_row("SELECT DISTINCT MONTH( post_date ) AS month, YEAR( post_date ) AS year
FROM $tableposts
WHERE post_date < '$thisyear-$thismonth-01'
AND post_status = 'publish'
ORDER BY post_date DESC
LIMIT 1");
$next = $wpdb->get_row("SELECT DISTINCT MONTH( post_date ) AS month, YEAR( post_date ) AS year
FROM $tableposts
WHERE post_date > '$thisyear-$thismonth-01'
AND MONTH( post_date ) != MONTH( '$thisyear-$thismonth-01' )
AND post_status = 'publish'
ORDER BY post_date ASC
LIMIT 1");
echo '| ' . substr($wd, 0, $daylength) . ' | '; $i += 1; } echo '||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| '.$prevSymbol.' ' . $month[zeroise($previous->month, 2)] . ' | '; } else { echo "\n\t\t".''; } echo "\n\t\t".' | '.$currentSymbol.' | '; if ($next) { echo "\n\t\t".'' . $month[zeroise($next->month, 2)] . ' '.$nextSymbol.' | '; } else { echo "\n\t\t".''; } echo ' | ||||||||
| "; $daysinmonth = intval(date('t', $unixmonth)); for ($day = 1; $day <= $daysinmonth; ++$day) { $cl = ''; if (isset($newrow) && $newrow) echo "\n\t | ||||||||||||
| $day"; } else { if ($cl != '') { echo 'class="' . $cl . '">' . $day; } else { echo '>' . $day; } } echo ' | '; } $pad = 7 - date('w', mktime(0, 0 , 0, $thismonth, $day, $thisyear)); if ($pad != 0 && $pad != 7) echo "\n\t\t"; echo "\n\t | |||||||||||