Changeset 14499 for trunk/wp-includes/general-template.php

Timestamp:

05/07/2010 05:01:29 AM (16 years ago)

Author:

nacin

Message:

Fix start of week and SQL WEEK handling. props mdawaffe, fixes #10397.

File:

• trunk/wp-includes/general-template.php (modified) (1 diff)

trunk/wp-includes/general-template.php

@@ -966 +966 @@
         }
     } elseif ( 'weekly' == $type ) {
-        $start_of_week = get_option('start_of_week');
-        $query = "SELECT DISTINCT WEEK(post_date, $start_of_week) AS `week`, YEAR(post_date) AS yr, DATE_FORMAT(post_date, '%Y-%m-%d') AS yyyymmdd, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY WEEK(post_date, $start_of_week), YEAR(post_date) ORDER BY post_date DESC $limit";
+        $week = _wp_mysql_week( '`post_date`' );
+        $query = "SELECT DISTINCT $week AS `week`, YEAR( `post_date` ) AS `yr`, DATE_FORMAT( `post_date`, '%Y-%m-%d' ) AS `yyyymmdd`, count( `ID` ) AS `posts` FROM `$wpdb->posts` $join $where GROUP BY $week, YEAR( `post_date` ) ORDER BY `post_date` DESC $limit";
         $key = md5($query);
         $cache = wp_cache_get( 'wp_get_archives' , 'general');