get_var($wpdb->prepare("SELECT 1 as test FROM $wpdb->posts WHERE post_type = %s AND post_status = 'publish' LIMIT 1", $taxonomy)); if ( !$gotsome ) { $cache[ $key ] = ''; wp_cache_set( 'get_comic_calendar', $cache, 'calendar' ); return; } } if ( isset($_GET['w']) && is_scalar($_GET['w']) ) $w = ''.intval(wp_unslash($_GET['w'])); // week_begins = 0 stands for Sunday $week_begins = intval(get_option('start_of_week')); // Let's figure out when we are if ( !empty($monthnum) && !empty($year) ) { $thismonth = ''.zeroise(intval($monthnum), 2); $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($wpdb->prepare("SELECT DATE_FORMAT((DATE_ADD(%s, INTERVAL %d DAY) ), '%%m')", $thisyear . '0101', $d)); } elseif ( !empty($m) ) { $thisyear = ''.intval(substr($m, 0, 4)); if ( strlen($m) < 6 ) $thismonth = '01'; else $thismonth = ''.zeroise(intval(substr($m, 4, 2)), 2); } else { $thisyear = gmdate('Y', current_time('timestamp')); $thismonth = gmdate('m', current_time('timestamp')); } $unixmonth = mktime(0, 0 , 0, $thismonth, 1, $thisyear); $calendar_month_start = sprintf('%04d-%02d-01', $thisyear, $thismonth); // Get the next and previous month and year with at least one post $previous = $wpdb->get_row($wpdb->prepare("SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM $wpdb->posts WHERE post_date < %s AND post_type = %s AND post_status = 'publish' ORDER BY post_date DESC LIMIT 1", $calendar_month_start, $taxonomy)); $next = $wpdb->get_row($wpdb->prepare("SELECT DISTINCT MONTH(post_date) AS month, YEAR(post_date) AS year FROM $wpdb->posts WHERE post_date > %s AND MONTH( post_date ) != MONTH( %s ) AND post_type = %s AND post_status = 'publish' ORDER BY post_date ASC LIMIT 1", $calendar_month_start, $calendar_month_start, $taxonomy)); /* translators: Calendar caption: 1: month name, 2: 4-digit year */ $calendar_caption = _x('%1$s %2$s', 'calendar caption', 'comic-easel'); $calendar_output = ''; $myweek = array(); for ( $wdcount=0; $wdcount<=6; $wdcount++ ) { $myweek[] = $wp_locale->get_weekday(($wdcount+$week_begins)%7); } foreach ( $myweek as $wd ) { $day_name = (true == $initial) ? $wp_locale->get_weekday_initial($wd) : $wp_locale->get_weekday_abbrev($wd); $wd = esc_attr($wd); $calendar_output .= "\n\t\t"; } $calendar_output .= ' '; if ( $previous ) { $calendar_output .= "\n\t\t".''; } else { $calendar_output .= "\n\t\t".''; } $calendar_output .= "\n\t\t".''; if ( $next ) { $calendar_output .= "\n\t\t".''; } else { $calendar_output .= "\n\t\t".''; } $calendar_output .= ' '; // Get days with posts $dayswithposts = $wpdb->get_results($wpdb->prepare("SELECT DISTINCT DAYOFMONTH(post_date) FROM $wpdb->posts WHERE MONTH(post_date) = %d AND YEAR(post_date) = %d AND post_type = %s AND post_status = 'publish' AND post_date < %s", $thismonth, $thisyear, $taxonomy, current_time('mysql')), ARRAY_N); if ( $dayswithposts ) { foreach ( (array) $dayswithposts as $daywith ) { $daywithpost[] = $daywith[0]; } } else { $daywithpost = array(); } $user_agent = isset($_SERVER['HTTP_USER_AGENT']) && is_scalar($_SERVER['HTTP_USER_AGENT']) ? sanitize_text_field(wp_unslash($_SERVER['HTTP_USER_AGENT'])) : ''; if (strpos($user_agent, 'MSIE') !== false || stripos($user_agent, 'camino') !== false || stripos($user_agent, 'safari') !== false) $ak_title_separator = "\n"; else $ak_title_separator = ', '; $ak_titles_for_day = array(); $ak_post_titles = $wpdb->get_results($wpdb->prepare("SELECT ID, post_title, DAYOFMONTH(post_date) as dom " ."FROM $wpdb->posts " ."WHERE YEAR(post_date) = %d " ."AND MONTH(post_date) = %d " ."AND post_date < %s " ."AND post_type = 'post' AND post_status = 'publish'" , $thisyear, $thismonth, current_time('mysql'))); if ( $ak_post_titles ) { foreach ( (array) $ak_post_titles as $ak_post_title ) { $post_title = esc_attr( apply_filters( 'the_title', $ak_post_title->post_title, $ak_post_title->ID ) ); if ( empty($ak_titles_for_day['day_'.$ak_post_title->dom]) ) $ak_titles_for_day['day_'.$ak_post_title->dom] = ''; if ( empty($ak_titles_for_day["$ak_post_title->dom"]) ) // first one $ak_titles_for_day["$ak_post_title->dom"] = $post_title; else $ak_titles_for_day["$ak_post_title->dom"] .= $ak_title_separator . $post_title; } } // See how much we should pad in the beginning $pad = calendar_week_mod(date('w', $unixmonth)-$week_begins); if ( 0 != $pad ) $calendar_output .= "\n\t\t".''; $daysinmonth = intval(date('t', $unixmonth)); for ( $day = 1; $day <= $daysinmonth; ++$day ) { if ( isset($newrow) && $newrow ) $calendar_output .= "\n\t\n\t\n\t\t"; $newrow = false; if ( $day == gmdate('j', current_time('timestamp')) && $thismonth == gmdate('m', current_time('timestamp')) && $thisyear == gmdate('Y', current_time('timestamp')) ) $calendar_output .= ''; if ( 6 == calendar_week_mod(date('w', mktime(0, 0 , 0, $thismonth, $day, $thisyear))-$week_begins) ) $newrow = true; } $pad = 7 - calendar_week_mod(date('w', mktime(0, 0 , 0, $thismonth, $day, $thisyear))-$week_begins); if ( $pad != 0 && $pad != 7 ) $calendar_output .= "\n\t\t".''; $calendar_output .= "\n\t\n\t\n\t

"; $cache[ $key ] = $calendar_output; wp_cache_set( 'get_comic_calendar', $cache, 'calendar' ); if ( $echo ) echo apply_filters( 'get_comic_calendar', $calendar_output ); else return apply_filters( 'get_comic_calendar', $calendar_output ); } /** * Purge the cached results of get_calendar. * * @see get_calendar * @since 2.1.0 */ function ceo_delete_get_calendar_cache() { wp_cache_delete( 'get_comic_calendar', 'calendar' ); } add_action( 'save_post', 'ceo_delete_get_calendar_cache' ); add_action( 'delete_post', 'ceo_delete_get_calendar_cache' ); add_action( 'update_option_start_of_week', 'ceo_delete_get_calendar_cache' ); add_action( 'update_option_gmt_offset', 'ceo_delete_get_calendar_cache' ); class ceo_calendar_widget extends WP_Widget { /** * Register widget with WordPress. */ function __construct() { parent::__construct( __CLASS__, // Base ID __( 'Comic Easel - Calendar', 'comic-easel' ), // Name array( 'classname' => __CLASS__, 'description' => __( 'Display a calendar showing this months posts. (this calendar does not drop lines if there is no title given.', 'comic-easel' ), ) // Args ); } function widget($args, $instance) { global $post, $wp_query; extract($args, EXTR_SKIP); echo $before_widget; ceo_protect(); if (!empty($instance)) { extract($instance); } ?> '', 'small' => '', 'medium' => '', 'large' => '', 'link' => '') ); $thumbnail = wp_strip_all_tags($instance['thumbnail']); $small = wp_strip_all_tags($instance['small']); $medium = wp_strip_all_tags($instance['medium']); $large = wp_strip_all_tags($instance['large']); $link = $instance['link']; foreach (array( 'thumbnail' => __('Thumbnail URL (178px by 130px):','comic-easel'), 'link' => array('label' => __('Add link on thumbnails:','comic-easel'), 'after' => '

'), 'small' => __('Wallpaper URL (Small):','comic-easel'), 'medium' => __('Wallpaper URL (Medium):','comic-easel'), 'large' => __('Wallpaper URL (Large):','comic-easel'), ) as $field => $label) { unset($after); if (is_array($label)) { extract($label); } ?>

$day_name
« ' . $wp_locale->get_month_abbrev($wp_locale->get_month($previous->month)) . '		' . $wp_locale->get_month_abbrev($wp_locale->get_month($next->month)) . ' »

'; else $calendar_output .= '	'; if ( in_array($day, $daywithpost) ) // any posts today? $calendar_output .= ''.$day.''; else $calendar_output .= $day; $calendar_output .= '