yuParticipant
change function in bp-blogs/bp-blogs-classes.php ->
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;
}
to
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 = 1 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;
}
Note this part ON p.blog_id = 1 – this is blog ID you want to see on your front page & news.
Anonymous User 303747Inactive
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!
Anonymous User 303747Inactive
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?
I am having issues with recaptcha on signup after an upgrade.
I have all new recaptcha plugin installed, new BP, WPMU 2.6.5., new recaptcha key.
When I register with recaptcha on it loops between initial sigup page and blog title page.
Turn off recaptcha , all is good.
Need recaptcha , I get way too much spam signups.
Any ideas?
Alrighteethen, I’ve given up on a reg form on a custom login page.
Even simpler, from a code standpoint is a message on the login page that says “This is a private site. To join, please email the site administrator.” with a spam-proof mailto link. I can then manually sign them up. Pretty clunky, but it sounds like BP will be better at this kind of thing someday soon.
Nothing in spam-folder (I did this several times). Be waiting…
slaFFik, i’m working on it now.. check your spam, i will activete your account..
I highly recommend something like this, especially for signups. Spammers target MU blogs to auto-register and then auto-create/post blogs.
I’ve had a problem similar to #1. The email is actually sent but the recipient’s email server just blocks it. They never get it. It doesn’t get sent to ‘spam’ like gmail or yahoo. They just don’t get it at all.
hotmail
Right? Try complaining to Microsoft.
You don’t
EDIT: That was a bit harsh. I don’t know any way of doing that. I don’t think I want people to be allowed to do that. Spam city. I can have a 1000 junk blogs by somebody generating 1000 emails? No thanks.
One of the issues with this would be that spammers could create their own BP sites and gain access to hundreds of other sites.
