让作者在wordpress中发帖，并安装合著者+ - Get authors post in wordpress with co-author plus installed

Get authors post in wordpress with co-author plus installed

本文关键字：安装合著者 wordpress | 更新日期: 2023-12-02

我想列出所有帖子，一个用户被指定为作者。我们使用的插件是co-authors plus，它允许将多个作者分配给一个帖子。函数<?php $user_post_count = count_user_posts( $userid ); ?>返回分配给用户的正确帖子数。但是，当尝试列出所有帖子时，使用the循环，只显示该用户最初创建的帖子。

query_posts( $args );
if (count_user_posts($user->ID) == 0) {
    echo "No posts";
}
// The Loop
while ( have_posts() ) : the_post();
    echo '<li>';
    the_title();
    echo '</li>';
endwhile;

是否有其他可能从用户那里获得所有帖子，或者我们可以修改现有的代码？

编辑

$args = array(
    'post_type' => 'post',
    'tax_query' => array(
        array(
            'taxonomy' => 'author',
            'field' => 'slug',
            'terms' => $user_login
        )
    ),
);
$author_query = new WP_Query( $args );
if ( $author_query->have_posts() ) :
    while ( $author_query->have_posts() ) : $author_query->the_post();
    // Do your presentation
    endwhile;
endif;

/**
 * @param $user_id
 * @param int $paged (if $paged = null return all posts)
 * @return array|bool
 */
function get_coauthor_posts_by_author_id($id, $paged = 1)
{
    global $wpdb;
    $slug = 'cap-' . strtolower(get_userdata($id)->user_nicename);

    $max_post = get_option('posts_per_page');
    $post_lower_limit = 0;

    if ($paged > 1) {
        $post_upper_limit = $max_post * $paged;
        $post_lower_limit = $post_upper_limit - $max_post;
    }

    $term_id = $wpdb->get_results($wpdb->prepare("SELECT term_id FROM $wpdb->terms WHERE slug = %s ", $slug))[0]->term_id;

    $sql = "SELECT SQL_CALC_FOUND_ROWS  $wpdb->posts.id FROM $wpdb->posts  LEFT JOIN $wpdb->term_relationships AS tr1 ON ($wpdb->posts.id = tr1.object_id) LEFT JOIN $wpdb->term_taxonomy ON ( tr1.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id ) WHERE 1=1  AND (($wpdb->posts.post_author = %d OR ($wpdb->term_taxonomy.taxonomy = 'author' AND $wpdb->term_taxonomy.term_id = %d))) AND $wpdb->posts.post_type = 'post' AND ($wpdb->posts.post_status = 'publish' OR $wpdb->posts.post_status = 'private') GROUP BY $wpdb->posts.id  ORDER BY $wpdb->posts.post_date DESC";
    $sql_limit = " LIMIT %d, %d";
    if ($paged !== null) {
        $sql = $sql . $sql_limit;
    }

        $result = $wpdb->get_results($wpdb->prepare($sql, $id, $term_id, $post_lower_limit, $max_post), ARRAY_A);
        return array_column($result, 'id');

}