Changeset 373 for trunk/bp-blogs/bp-blogs-classes.php

Timestamp:

10/07/2008 07:16:51 AM (18 years ago)

Author:

apeatling

Message:

Bug fixes:

• Fixed group avatar upload issues
• Fixed validation on group name/desc/news
• Fixed support for ​https://
• Base support for upcoming home theme and widgets
• Re-factored JS and CSS inclusion with wp_enqueue_script/styles

File:

• trunk/bp-blogs/bp-blogs-classes.php (modified) (2 diffs)

trunk/bp-blogs/bp-blogs-classes.php

@@ -84 +84 @@
                 $blog_ids = $wpdb->get_col( $wpdb->prepare( "SELECT blog_id FROM " . $bp['blogs']['table_name'] . " WHERE user_id = %d", $user_id) );
                 $total_blog_count = $wpdb->get_var( $wpdb->prepare( "SELECT count(blog_id) FROM " . $bp['blogs']['table_name'] . " WHERE user_id = %d", $user_id) );
-        
+                
                 for ( $i = 0; $i < count($blog_ids); $i++ ) {
                         $blogs[] = array(
@@ -183 +183 @@
         }
         
+        function get_latest_posts( $blog_id = null, $limit = 5 ) {
+                global $wpdb, $bp;
+                
+                if ( $blog_id )
+                        $blog_sql = $wpdb->prepare( " WHERE blog_id = %d", $blog_id );
+                
+                $post_ids = $wpdb->get_results( $wpdb->prepare( "SELECT post_id, blog_id FROM " . $bp['blogs']['table_name_blog_posts'] . "$blog_sql ORDER BY 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;
+        }
+        
         function get_posts_for_user( $user_id = null ) {
                 global $bp, $wpdb;