Mostrar post relacionados (en single.php)

[rogertm]

Yo uso este código, lo pegas en tu archivo functions.php:

Código PHP:

<?php
/* Post Relacionados **********************************************************/
function crossblock_get_related_posts() {
    global $wpdb, $post,$table_prefix;
 
    if ( $exclude != '' ) {
        $q = "SELECT tt.term_id FROM ". $table_prefix ."term_taxonomy tt, " . $table_prefix . "term_relationships tr WHERE tt.taxonomy = 'category' AND tt.term_taxonomy_id = tr.term_taxonomy_id AND tr.object_id = $post->ID";
 
        $cats = $wpdb->get_results($q);
 
        foreach(($cats) as $cat) {
            if (in_array($cat->term_id, $exclude) != false){
                return;
            }
        }
    }
 
    if(!$post->ID){return;}
    $now = current_time('mysql', 1);
    $tags = wp_get_post_tags($post->ID);
 
    $taglist = "'" . $tags[0]->term_id. "'";
 
    $tagcount = count($tags);
    if ($tagcount > 1) {
        for ($i = 1; $i <= $tagcount; $i++) {
            $taglist = $taglist . ", '" . $tags[$i]->term_id . "'";
        }
    }
 
    if ($limit) {
        $limitclause = "LIMIT $limit";
    }    else {
        $limitclause = "LIMIT 9"; // Éste valor es la cantidad de post a mostrar
    }
 
    $q = "SELECT p.ID, p.post_title, p.post_date, p.comment_count, count(t_r.object_id) as cnt FROM $wpdb->term_taxonomy t_t, $wpdb->term_relationships t_r, $wpdb->posts p WHERE t_t.taxonomy ='post_tag' AND t_t.term_taxonomy_id = t_r.term_taxonomy_id AND t_r.object_id  = p.ID AND (t_t.term_id IN ($taglist)) AND p.ID != $post->ID AND p.post_status = 'publish' AND p.post_date_gmt < '$now' GROUP BY t_r.object_id ORDER BY cnt DESC, p.post_date_gmt DESC $limitclause;";
 
    $related_posts = $wpdb->get_results($q);
    $output = "";
 
    if (!$related_posts){
        return;
    }
 
    foreach ($related_posts as $related_post ){
        $output .= '<li><h3>';
 
        /*
        $show_date = true;
        if ($show_date){
            $dateformat = get_option('date_format');
            $output .= '<span class="date">'.mysql2date($dateformat, $related_post->post_date) . "</span> &nbsp;-&nbsp; ";
        }
        */
 
        $output .=  '<a href="'.get_permalink($related_post->ID).'" title="'.wptexturize($related_post->post_title).'">'.wptexturize($related_post->post_title).'';
 
        if ($show_comments_count){
            $output .=  " (" . $related_post->comment_count . ")";
        }
 
        $output .=  '</h3></a></li>';
    }
    $output = '<ul>'.$output.'</ul>';
    $output = '<h3>Posts relacionados:</h3>'.$output;
 // end $crossblock_postthumbnail_disable
 
    return $output;
}
?>
 

Y en single.php solo tienes que llamar la función donde quieras que se muestren esos post relacionados.

Código PHP:

<div id="related-post">
    <?php echo crossblock_get_related_posts(); ?>
</div>
 

Saludos...