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
910
911      if ( !$archive_date_format_over_ride ) {
912           $archive_day_date_format = get_option('date_format');
913           $archive_week_start_date_format = get_option('date_format');
914           $archive_week_end_date_format = get_option('date_format');
915      }
916
917      //filters
918      $where = apply_filters( 'getarchives_where', "WHERE post_type = 'post' AND post_status = 'publish'", $r );
919      $join = apply_filters( 'getarchives_join', '', $r );
920
921      $output = '';
922
923      if ( 'monthly' == $type ) {
924           $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";
925           $key = md5($query);
926           $cache = wp_cache_get( 'wp_get_archives' , 'general');
927           if ( !isset( $cache[ $key ] ) ) {
928                $arcresults = $wpdb->get_results($query);