Changeset 19748

Timestamp:

01/25/2012 12:09:30 AM (14 years ago)

Author:

nacin

Message:

Use get_blog_prefix() in get_most_recent_post_of_user(). see #19891.

File:

• trunk/wp-includes/ms-functions.php (modified) (1 diff)

trunk/wp-includes/ms-functions.php

@@ -1369 +1369 @@
     // published by $user_id
     foreach ( (array) $user_blogs as $blog ) {
-        $recent_post = $wpdb->get_row( $wpdb->prepare("SELECT ID, post_date_gmt FROM {$wpdb->base_prefix}{$blog->userblog_id}_posts WHERE post_author = %d AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1", $user_id ), ARRAY_A);
+        $prefix = $wpdb->get_blog_prefix( $blog->userblog_id );
+        $recent_post = $wpdb->get_row( $wpdb->prepare("SELECT ID, post_date_gmt FROM {$prefix}posts WHERE post_author = %d AND post_type = 'post' AND post_status = 'publish' ORDER BY post_date_gmt DESC LIMIT 1", $user_id ), ARRAY_A);
 
         // Make sure we found a post