Menu Adam R Brown

WP hooks navigation: Home/browseActions indexFilters index

Source View: getarchives_join

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
405
406      if ( !$archive_date_format_over_ride ) {
407           $archive_day_date_format = get_option('date_format');
408           $archive_week_start_date_format = get_option('date_format');
409           $archive_week_end_date_format = get_option('date_format');
410      }
411
412      //filters
413      $where = apply_filters('getarchives_where', "WHERE post_type = 'post' AND post_status = 'publish'", $r );
414      $join = apply_filters('getarchives_join', "", $r);
415
416      if ( 'monthly' == $type ) {
417           $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";
418           $key = md5($query);
419           $cache = wp_cache_get( 'wp_get_archives' , 'general');
420           if ( !isset( $cache[ $key ] ) ) {
421                $arcresults = $wpdb->get_results($query);
422                $cache[ $key ] = $arcresults;
423                wp_cache_add( 'wp_get_archives', $cache, 'general' );