Changeset 3139

Timestamp:

07/21/2010 06:48:57 PM (16 years ago)

Author:

johnjamesjacoby

Message:

Fixes #2543 props paulgibbs

File:

• branches/1.2/bp-blogs/bp-blogs-classes.php (modified) (1 diff)

branches/1.2/bp-blogs/bp-blogs-classes.php

@@ -280 +280 @@
             return $paged_blogs;
 
-        for ( $i = 0; $i < count( $paged_blogs ); $i++ )
-            $paged_blogs[$i]->latest_post = $wpdb->get_row( "SELECT post_title, guid FROM {$wpdb->base_prefix}" . $paged_blogs[$i]->blog_id . "_posts WHERE post_status = 'publish' AND post_type = 'post' AND id != 1 ORDER BY id DESC LIMIT 1" );
+        for ( $i = 0; $i < count( $paged_blogs ); $i++ ) {
+            $blog_prefix = $wpdb->get_blog_prefix( $paged_blogs[$i]->blog_id );
+            $paged_blogs[$i]->latest_post = $wpdb->get_row( "SELECT post_title, guid FROM {$blog_prefix}posts WHERE post_status = 'publish' AND post_type = 'post' AND id != 1 ORDER BY id DESC LIMIT 1" );
+        }
 
         /* Fetch the blog description for each blog (as it may be empty we can't fetch it in the main query). */