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
792
793      if ( !$archive_date_format_over_ride ) {
794           $archive_day_date_format = get_option('date_format');
795           $archive_week_start_date_format = get_option('date_format');
796           $archive_week_end_date_format = get_option('date_format');
797      }
798
799      //filters
800      $where = apply_filters('getarchives_where', "WHERE post_type = 'post' AND post_status = 'publish'", $r );
801      $join = apply_filters('getarchives_join', "", $r);
802
803      $output = '';
804
805      if ( 'monthly' == $type ) {
806           $query = "SELECT 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";
807           $key = md5($query);
808           $cache = wp_cache_get( 'wp_get_archives' , 'general');
809           if ( !isset( $cache[ $key ] ) ) {
810                $arcresults = $wpdb->get_results($query);