Menu Adam R Brown

WP hooks navigation: Home/browseActions indexFilters index

Source View: getarchives_where

To save our bandwidth, we show only a snippet of code around each occurence of the hook. View complete file in SVN (without highlighting).

Understanding Source Code

The best way to understand what a hook does is to look at where it occurs in the source code.

Remember, this hook may occur in more than one file. Moreover, the hook's context may change from version to version.

Source View

Line Code
387      $archive_week_end_date_format     = 'Y/m/d';
388
389      if ( !$archive_date_format_over_ride ) {
390           $archive_day_date_format = get_option('date_format');
391           $archive_week_start_date_format = get_option('date_format');
392           $archive_week_end_date_format = get_option('date_format');
393      }
394
395      //filters
396      $where = apply_filters('getarchives_where', "WHERE post_type = 'post' AND post_status = 'publish'", $r );
397      $join = apply_filters('getarchives_join', "", $r);
398
399      if ( 'monthly' == $type ) {
400           $query = "SELECT DISTINCT YEAR(post_date) AS `year`, MONTH(post_date) AS `month`, count(ID) as posts FROM $wpdb->posts $join $where GROUP BY YEAR(post_date), MONTH(post_date) ORDER BY post_date DESC $limit";
401           $key = md5($query);
402           $cache = wp_cache_get( 'wp_get_archives' , 'general');
403           if ( !isset( $cache[ $key ] ) ) {
404                $arcresults = $wpdb->get_results($query);
405                $cache[ $key ] = $arcresults;