WordPress.org
Get WordPress

Make WordPress Core

Changeset 6359


Ignore:
Timestamp:
12/05/2007 09:25:45 AM (17 years ago)
Author:
ryan
Message:

Refactor next_post_link, previous_post_link. props xknown. fixes #5411

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/wp-includes/link-template.php

    r6352 r6359  
    361361
    362362function get_previous_post($in_same_cat = false, $excluded_categories = '') {
     363    return get_adjacent_post($in_same_cat, $excluded_categories);
     364}
     365
     366function get_next_post($in_same_cat = false, $excluded_categories = '') {
     367    return get_adjacent_post($in_same_cat, $excluded_categories, false);
     368}
     369
     370function get_adjacent_post($in_same_cat = false, $excluded_categories = '', $previous = true) {
    363371    global $post, $wpdb;
    364372
    … …  
    369377
    370378    $join = '';
    371     if ( $in_same_cat ) {
    372         $join = " INNER JOIN $wpdb->term_relationships AS tr ON p.ID = tr.object_id ";
    373         $cat_array = wp_get_object_terms($post->ID, 'category', 'fields=tt_ids');
    374         $join .= $wpdb->prepare(' AND (tr.term_taxonomy_id = %d', $cat_array[0]);
    375         for ( $i = 1; $i < (count($cat_array)); $i++ ) {
    376             $join .= $wpdb->prepare(' OR tr.term_taxonomy_id = %d', $cat_array[$i]);
    377         }
    378         $join .= ')';
    379     }
    380 
    381     $sql_exclude_cats = '';
    382     if ( !empty($excluded_categories) ) {
    383         $blah = explode(' and ', $excluded_categories);
    384         $posts_in_ex_cats = get_objects_in_term($blah, 'category');
    385         $posts_in_ex_cats_sql = 'AND p.ID NOT IN (' . implode($posts_in_ex_cats, ',') . ')';
    386     }
    387 
    388     $join  = apply_filters( 'get_previous_post_join', $join, $in_same_cat, $excluded_categories );
    389     $where = apply_filters( 'get_previous_post_where', $wpdb->prepare("WHERE p.post_date < %s AND p.post_type = 'post' AND p.post_status = 'publish' $posts_in_ex_cats_sql", $current_post_date), $in_same_cat, $excluded_categories );
    390     $sort  = apply_filters( 'get_previous_post_sort', 'ORDER BY p.post_date DESC LIMIT 1' );
    391 
    392     return @$wpdb->get_row("SELECT p.ID, p.post_title FROM $wpdb->posts AS p $join $where $sort");
    393 }
    394 
    395 function get_next_post($in_same_cat = false, $excluded_categories = '') {
    396     global $post, $wpdb;
    397 
    398     if( empty($post) || !is_single() || is_attachment() )
    399         return null;
    400 
    401     $current_post_date = $post->post_date;
    402 
    403     $join = '';
    404     if ( $in_same_cat ) {
    405         $join = " INNER JOIN $wpdb->term_relationships AS tr ON p.ID = tr.object_id ";
    406         $cat_array = wp_get_object_terms($post->ID, 'category', 'fields=tt_ids');
    407         $join .= $wpdb->prepare(' AND (tr.term_taxonomy_id = %d', $cat_array[0]);
    408         for ( $i = 1; $i < (count($cat_array)); $i++ ) {
    409             $join .= $wpdb->prepare(' OR tr.term_taxonomy_id = $d', $cat_array[$i]);
    410         }
    411         $join .= ')';
    412     }
    413 
    414     $sql_exclude_cats = '';
    415     if ( !empty($excluded_categories) ) {
    416         $blah = explode(' and ', $excluded_categories);
    417         $posts_in_ex_cats = get_objects_in_term($blah, 'category');
    418         $posts_in_ex_cats_sql = 'AND p.ID NOT IN (' . implode($posts_in_ex_cats, ',') . ')';
    419     }
    420 
    421     $join  = apply_filters( 'get_next_post_join', $join, $in_same_cat, $excluded_categories );
    422     $where = apply_filters( 'get_next_post_where', $wpdb->prepare("WHERE p.post_date > %s AND p.post_type = 'post' AND p.post_status = 'publish' $posts_in_ex_cats_sql AND p.ID != %d", $current_post_date, $post->ID), $in_same_cat, $excluded_categories );
    423     $sort  = apply_filters( 'get_next_post_sort', 'ORDER BY p.post_date ASC LIMIT 1' );
    424 
    425     return @$wpdb->get_row("SELECT p.ID, p.post_title FROM $wpdb->posts AS p $join $where $sort");
    426 }
    427 
     379    if ( $in_same_cat || !empty($excluded_categories) ) {
     380        $join = " INNER JOIN $wpdb->term_relationships AS tr ON p.ID = tr.object_id INNER JOIN $wpdb->term_taxonomy tt ON tr.term_taxonomy_id = tt.term_taxonomy_id";
     381
     382        if ( $in_same_cat ) {
     383            $cat_array = wp_get_object_terms($post->ID, 'category', 'fields=ids');
     384            $join .= " AND tt.taxonomy = 'category' AND tt.term_id IN (" . implode($cat_array, ',') . ')';
     385        }
     386
     387        $posts_in_ex_cats_sql = "AND tt.taxonomy = 'category'";
     388        if ( !empty($excluded_categories) ) {
     389            $excluded_categories = array_map('intval', explode(' and ', $excluded_categories));
     390            if ( !empty($cat_array) ) {
     391                $excluded_categories = array_diff($excluded_categories, $cat_array);
     392                $posts_in_ex_cats_sql = '';
     393            }
     394
     395            if ( !empty($excluded_categories) ) {
     396                $posts_in_ex_cats_sql = " AND tt.term_id NOT IN (" . implode($excluded_categories, ',') . ')';
     397            }
     398        }
     399    }
     400
     401    $adjacent = $previous ? 'previous' : 'next';
     402    $op = $previous ? '<' : '>';
     403    $order = $previous ? 'DESC' : 'ASC';
     404
     405    $join  = apply_filters( "get_{$adjacent}_post_join", $join, $in_same_cat, $excluded_categories );
     406    $where = apply_filters( "get_{$adjacent}_post_where", $wpdb->prepare("WHERE p.post_date $op %s AND p.post_type = 'post' AND p.post_status = 'publish' $posts_in_ex_cats_sql", $current_post_date), $in_same_cat, $excluded_categories );
     407    $sort  = apply_filters( "get_{$adjacent}_post_sort", "ORDER BY p.post_date $order LIMIT 1" );
     408
     409    return $wpdb->get_row("SELECT p.* FROM $wpdb->posts AS p $join $where $sort");
     410}
    428411
    429412function previous_post_link($format='&laquo; %link', $link='%title', $in_same_cat = false, $excluded_categories = '') {
    430 
    431     if ( is_attachment() )
     413    adjacent_post_link($format, $link, $in_same_cat, $excluded_categories, true);
     414}
     415
     416function next_post_link($format='%link &raquo;', $link='%title', $in_same_cat = false, $excluded_categories = '') {
     417    adjacent_post_link($format, $link, $in_same_cat, $excluded_categories, false);
     418}
     419
     420function adjacent_post_link($format, $link, $in_same_cat = false, $excluded_categories = '', $previous = true) {
     421    if ( $previous && is_attachment() )
    432422        $post = & get_post($GLOBALS['post']->post_parent);
    433423    else
    434         $post = get_previous_post($in_same_cat, $excluded_categories);
     424        $post = get_adjacent_post($in_same_cat, $excluded_categories, $previous);
    435425
    436426    if ( !$post )
    … …  
    440430
    441431    if ( empty($post->post_title) )
    442         $title = __('Previous Post');
     432        $title = $previous ? __('Previous Post') : __('Next Post');
    443433
    444434    $title = apply_filters('the_title', $title, $post);
    445     $string = '<a href="'.get_permalink($post->ID).'">';
    446     $link = str_replace('%title', $title, $link);
    447     $link = $pre . $string . $link . '</a>';
    448 
    449     $format = str_replace('%link', $link, $format);
    450 
    451     echo $format;
    452 }
    453 
    454 function next_post_link($format='%link &raquo;', $link='%title', $in_same_cat = false, $excluded_categories = '') {
    455     $post = get_next_post($in_same_cat, $excluded_categories);
    456 
    457     if ( !$post )
    458         return;
    459 
    460     $title = $post->post_title;
    461 
    462     if ( empty($post->post_title) )
    463         $title = __('Next Post');
    464 
    465     $title = apply_filters('the_title', $title, $post);
    466     $string = '<a href="'.get_permalink($post->ID).'">';
     435    $string = '<a href="'.get_permalink($post).'">';
    467436    $link = str_replace('%title', $title, $link);
    468437    $link = $string . $link . '</a>';
     438
    469439    $format = str_replace('%link', $link, $format);
    470440
Note: See TracChangeset for help on using the changeset viewer.