Latest post from blogs duplicates record after delete
-
After delete post in blog i got strange duplicate on my front page in widget ‘Latest posts from blogs’ -> http://tf2.lv
I’ve allready used this function to add DISTINCT for unique record in this widget.. so now i just dunno what to do.. please help (
function get_latest_posts( $blog_id = null, $limit = 5 ) {
global $wpdb, $bp;
if ( $blog_id )
$blog_sql = $wpdb->prepare( " AND p.blog_id = %d", $blog_id );
$post_ids = $wpdb->get_results( $wpdb->prepare( "SELECT DISTINCT p.post_id, p.blog_id FROM " . $bp['blogs']['table_name_blog_posts'] . " p LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = b.blog_id WHERE b.public = 1 AND b.deleted = 0 AND b.archived = '0' AND b.spam = 0 AND b.mature = 0 $blog_sql ORDER BY p.date_created DESC LIMIT $limit" ) );
for ( $i = 0; $i < count($post_ids); $i++ ) {
$posts[$i] = BP_Blogs_Post::fetch_post_content($post_ids[$i]);
}
return $posts;
}
Viewing 5 replies - 1 through 5 (of 5 total)
Viewing 5 replies - 1 through 5 (of 5 total)
- The topic ‘Latest post from blogs duplicates record after delete’ is closed to new replies.