BuddyPress.org

In times of desperation, the brutal way trumps anything else

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 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;

}

That’s the function. What would need adjustment here?

That actually doesn’t work for me – does this do the job for you?

Ah – that does limit the output to blog_id=1 but lists posts multiple times, as in:

Blog_ID=1:

Post 2

Post 2

Post 2

Post 1

Post 1

By the way, reason for this modification is that I am running an aggregator, which records post headlines to a dedicated blog. Without limiting the output in the recent blog posts widget, the widget is overrun with RSS headlines. A similar need would exist for people that want to give individuals blogs, but want to control that only ‘self-owned” or moderated blogs push content directly to the front page. Someone else stated that requirement in another thread.

Argh – haven’t had my coffee yet. This works like a champ. One last question while I’m on this topic:

What if I would want to list posts from two blogs (ie blog_id=1 and blog_id=2) – how would the code below look?

LEFT JOIN {$wpdb->base_prefix}blogs b ON p.blog_id = 1 WHERE..

gerbilo, I owe you one. Perfect!

In summary – objective was to limit the output in the Recent Blog Posts widget to only a few selected (in my case self-owned) blogs.

Edit bp-blogs-classes.php:

Replace:

$post_ids = $wpdb->get_results( $wpdb->prepare( "SELECT 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" ) );

With

$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 IN (1,2) 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" ) );

In my example, I use blog_id 1 and blog_id 2.

I don’t like hacking the code, so if there’s anyone who knows to get this done by putting it in the mu-plugins directory and leave the BP code untouched, I’d be interested in learning about it.

Thanks again, gerbilo!