Welcome, visitor! Log in
 

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.

  • Action hooks look like this: do_action( "hook_name" )
  • Filter hooks look like this: apply_filters( "hook_name", "what_to_filter" ).

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
350           $archive_week_start_date_format = get_option('date_format');
351           $archive_week_end_date_format = get_option('date_format');
352      }
353
354      $add_hours = intval(get_option('gmt_offset'));
355      $add_minutes = intval(60 * (get_option('gmt_offset') - $add_hours));
356
357      //filters
358      $where = apply_filters('getarchives_where', "WHERE post_type = 'post' AND post_status = 'publish'", $r );
359      $join = apply_filters('getarchives_join', "", $r);
360
361      if ( 'monthly' == $type ) {
362           $arcresults = $wpdb->get_results("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);
363           if ( $arcresults ) {
364                $afterafter = $after;
365                foreach ( $arcresults as $arcresult ) {
366                     $url     = get_month_link($arcresult->year,     $arcresult->month);
367                     $text = sprintf(__('%1$s %2$d'), $wp_locale->get_month($arcresult->month), $arcresult->year);
368                     if ( $show_post_count )