public static function date_range_has_posts($start_date, $end_date)
{
global $wpdb;
$start_date .= ' 00:00:00';
$end_date .= ' 23:59:59';
$post_types_in = self::get_supported_post_types_in();
return $wpdb->get_var($wpdb->prepare("SELECT ID FROM {$wpdb->posts} WHERE post_status = 'publish' AND post_date >= %s AND post_date <= %s AND post_type IN ( {$post_types_in} ) LIMIT 1", $start_date, $end_date));
}
function vipgo_generate_sitemap_for_year_month_day($args) { $year = $args['year']; $month = $args['month']; $day = $args['day']; $date_stamp = Metro_Sitemap::get_date_stamp($year, $month, $day); if (Metro_Sitemap::date_range_has_posts($date_stamp, $date_stamp)) { Metro_Sitemap::generate_sitemap_for_date($date_stamp); } else { Metro_Sitemap::delete_sitemap_for_date($date_stamp); } }