Latest Post in Blogs Directory

[unsalkorkmaz]

Latest post for blogs directory:

$paged_blogs[$i]->latest_post = $wpdb->get_row( "SELECT ID, post_content, post_title, post_excerpt, guid FROM {$blog_prefix}posts WHERE post_status = 'publish' AND post_type = 'post' AND id != 1 ORDER BY id DESC LIMIT 1" );

Hardcoding post_type = 'post' is just wrong. Basically we cant show custom post types in there. Why not use {$blog_prefix}bp_activity table?

[unsalkorkmaz]

Or.. just remove post_type = 'post' because post_status = 'publish' is enough for eliminating attachments because their post_status is inherit.

Update: nvm this one. nav menu items are coming too.

[boonebgorges]

This is a good enhancement request. For the moment, you can filter 'bp_get_blog_latest_post' and provide whatever value you want.

[tw2113]

I think there's potential here to amend the query to take multiple post types. Perhaps make do a post_type IN ( '...' ) spot, and have default to just 'post'. The filter would pass an array that has just 'post' by default, and implode it into the SQL.

[tw2113]

Alternative idea, perhaps we could use the $type parameter to specify a post type. It's presently no used for anything.