Skip to:
Content

BuddyPress.org

Ticket #5272: bp-blogs-classes.php

File bp-blogs-classes.php, 25.0 KB (added by lenasterg, 10 years ago)

bp-blogs-classes.php file with suggested changes

Line 
1<?php
2//Includes also  fix based on https://buddypress.trac.wordpress.org/ticket/5303
3/**
4 * BuddyPress Blogs Classes.
5 *
6 * @package BuddyPress
7 * @subpackage BlogsClasses
8 */
9// Exit if accessed directly
10if (!defined('ABSPATH'))
11    exit;
12
13/**
14 * The main BuddyPress blog class.
15 *
16 * A BP_Blogs_Object represents a link between a specific WordPress blog on a
17 * network and a specific user on that blog.
18 *
19 * @since BuddyPress (1.0.0)
20
21 */
22class BP_Blogs_Blog {
23
24    public $id;
25    public $user_id;
26    public $blog_id;
27
28    /**
29     * Constructor method.
30     *
31     * @param int $id Optional. The ID of the blog.
32     */
33    public function __construct($id = null) {
34        if (!empty($id)) {
35            $this->id = $id;
36            $this->populate();
37        }
38    }
39
40    /**
41     * Populate the object with data about the specific activity item.
42     */
43    public function populate() {
44        global $wpdb, $bp;
45
46        $blog = $wpdb->get_row($wpdb->prepare("SELECT * FROM {$bp->blogs->table_name} WHERE id = %d", $this->id));
47
48        $this->user_id = $blog->user_id;
49        $this->blog_id = $blog->blog_id;
50    }
51
52    /**
53     * Save the BP blog data to the database.
54     *
55     * @return bool True on success, false on failure.
56     */
57    public function save() {
58        global $wpdb, $bp;
59
60        $this->user_id = apply_filters('bp_blogs_blog_user_id_before_save', $this->user_id, $this->id);
61        $this->blog_id = apply_filters('bp_blogs_blog_id_before_save', $this->blog_id, $this->id);
62
63        do_action_ref_array('bp_blogs_blog_before_save', array(&$this));
64
65        // Don't try and save if there is no user ID or blog ID set.
66        if (!$this->user_id || !$this->blog_id)
67            return false;
68
69        // Don't save if this blog has already been recorded for the user.
70        if (!$this->id && $this->exists())
71            return false;
72
73        if ($this->id) {
74            // Update
75            $sql = $wpdb->prepare("UPDATE {$bp->blogs->table_name} SET user_id = %d, blog_id = %d WHERE id = %d", $this->user_id, $this->blog_id, $this->id);
76        } else {
77            // Save
78            $sql = $wpdb->prepare("INSERT INTO {$bp->blogs->table_name} ( user_id, blog_id ) VALUES ( %d, %d )", $this->user_id, $this->blog_id);
79        }
80
81        if (!$wpdb->query($sql))
82            return false;
83
84        do_action_ref_array('bp_blogs_blog_after_save', array(&$this));
85
86        if ($this->id)
87            return $this->id;
88        else
89            return $wpdb->insert_id;
90    }
91
92    /**
93     * Check whether an association between this user and this blog exists.
94     *
95     * @return int The number of associations between the user and blog
96     *         saved in the blog component tables.
97     */
98    public function exists() {
99        global $bp, $wpdb;
100
101        return $wpdb->get_var($wpdb->prepare("SELECT COUNT(id) FROM {$bp->blogs->table_name} WHERE user_id = %d AND blog_id = %d", $this->user_id, $this->blog_id));
102    }
103
104    /** Static Methods ************************************************** */
105
106    /**
107     * Retrieve a set of blog-user associations.
108     * @param array $args {
109     *     An array of arguments. All items are optional.
110     * @param string $type The order in which results should be returned.
111     *        'active', 'alphabetical', 'newest', or 'random'.
112     * @param int|bool $limit Optional. The maximum records to return.
113     *        Default: false.
114     * @param int|bool $page Optional. The page of records to return.
115     *        Default: false (unlimited results).
116     * @param int $user_id Optional. ID of the user whose blogs are being
117     *        retrieved. Default: 0.
118     * @param string|bool $search_terms Optional. Search by text stored in
119     *        blogmeta (such as the blog name). Default: false.
120     * @param bool $show_hidden. Whether to include private blogs of user
121     * }
122     * @return array Multidimensional results array, structured as follows:
123     *           'blogs' - Array of located blog objects
124     *           'total' - A count of the total blogs matching the filter params
125     *
126     * @version 2, stergatu merged all func arguments into an array and added show hidden
127     *
128     */
129    public static function get($args = array()) {
130        global $bp, $wpdb;
131        // Backward compatibility with old method of passing arguments
132        if (!is_array($args) || func_num_args() > 1) {
133            _deprecated_argument(__METHOD__, '2', sprintf(__('Arguments passed to %1$s should be in an associative array. See the inline documentation at %2$s for more details.', 'buddypress'), __METHOD__, __FILE__));
134
135            $old_args_keys = array(
136                0 => 'type',
137                1 => 'per_page',
138                2 => 'page',
139                3 => 'user_id',
140                4 => 'search_terms',
141                5 => 'show_hidden',
142            );
143
144            $func_args = func_get_args();
145            $args = bp_core_parse_args_array($old_args_keys, $func_args);
146        }
147
148        $defaults = array(
149            'type' => 'active',
150            'per_page' => false,
151            'page' => false,
152            'user_id' => 0,
153            'search_terms' => false, // Terms to search by
154            'show_hidden' => false, // Show blogs marked hidden
155        );
156        $r = wp_parse_args($args, $defaults);
157        extract($r);
158
159
160        $hidden_sql = '';
161        if (!bp_is_my_profile() && !$show_hidden && !bp_current_user_can('bp_moderate'))
162            $hidden_sql = " AND wb.public = 1";
163
164        $pag_sql = ( $per_page && $page ) ? $wpdb->prepare(" LIMIT %d, %d", intval(( $page - 1 ) * $per_page), intval($per_page)) : '';
165
166        $user_sql = !empty($user_id) ? $wpdb->prepare(" AND b.user_id = %d", $user_id) : '';
167
168        switch ($type) {
169            case 'active': default:
170                $order_sql = "ORDER BY bm.meta_value DESC";
171                break;
172            case 'alphabetical':
173                $order_sql = "ORDER BY bm2.meta_value ASC";
174                break;
175            case 'newest':
176                $order_sql = "ORDER BY wb.registered DESC";
177                break;
178            case 'random':
179                $order_sql = "ORDER BY RAND()";
180                break;
181        }
182
183        if (!empty($search_terms)) {
184            $filter = esc_sql(like_escape($search_terms));
185            $paged_blogs = $wpdb->get_results("SELECT b.blog_id, b.user_id as admin_user_id, u.user_email as admin_user_email, wb.domain, wb.path, bm.meta_value as last_activity, bm2.meta_value as name FROM {$bp->blogs->table_name} b, {$bp->blogs->table_name_blogmeta} bm, {$bp->blogs->table_name_blogmeta} bm2, {$wpdb->base_prefix}blogs wb, {$wpdb->users} u WHERE b.blog_id = wb.blog_id AND b.user_id = u.ID AND b.blog_id = bm.blog_id AND b.blog_id = bm2.blog_id AND wb.archived = '0' AND wb.spam = 0 AND wb.mature = 0 AND wb.deleted = 0 {$hidden_sql} AND bm.meta_key = 'last_activity' AND bm2.meta_key = 'name' AND bm2.meta_value LIKE '%%$filter%%' {$user_sql} GROUP BY b.blog_id {$order_sql} {$pag_sql}");
186            $total_blogs = $wpdb->get_var("SELECT COUNT(DISTINCT b.blog_id) FROM {$bp->blogs->table_name} b, {$wpdb->base_prefix}blogs wb, {$bp->blogs->table_name_blogmeta} bm, {$bp->blogs->table_name_blogmeta} bm2 WHERE b.blog_id = wb.blog_id AND bm.blog_id = b.blog_id AND bm2.blog_id = b.blog_id AND wb.archived = '0' AND wb.spam = 0 AND wb.mature = 0 AND wb.deleted = 0 {$hidden_sql} AND bm.meta_key = 'name' AND bm2.meta_key = 'description' AND ( bm.meta_value LIKE '%%$filter%%' || bm2.meta_value LIKE '%%$filter%%' ) {$user_sql}");
187        } else {
188            $paged_blogs = $wpdb->get_results("SELECT b.blog_id, b.user_id as admin_user_id, u.user_email as admin_user_email, wb.domain, wb.path, bm.meta_value as last_activity, bm2.meta_value as name FROM {$bp->blogs->table_name} b, {$bp->blogs->table_name_blogmeta} bm, {$bp->blogs->table_name_blogmeta} bm2, {$wpdb->base_prefix}blogs wb, {$wpdb->users} u WHERE b.blog_id = wb.blog_id AND b.user_id = u.ID AND b.blog_id = bm.blog_id AND b.blog_id = bm2.blog_id {$user_sql} AND wb.archived = '0' AND wb.spam = 0 AND wb.mature = 0 AND wb.deleted = 0 {$hidden_sql} AND bm.meta_key = 'last_activity' AND bm2.meta_key = 'name' GROUP BY b.blog_id {$order_sql} {$pag_sql}");
189            $total_blogs = $wpdb->get_var("SELECT COUNT(DISTINCT b.blog_id) FROM {$bp->blogs->table_name} b, {$wpdb->base_prefix}blogs wb WHERE b.blog_id = wb.blog_id {$user_sql} AND wb.archived = '0' AND wb.spam = 0 AND wb.mature = 0 AND wb.deleted = 0 {$hidden_sql}");
190        }
191
192        $blog_ids = array();
193        foreach ((array) $paged_blogs as $blog) {
194            $blog_ids[] = (int) $blog->blog_id;
195        }
196
197        $paged_blogs = BP_Blogs_Blog::get_blog_extras($paged_blogs, $blog_ids, $type);
198
199        return array('blogs' => $paged_blogs, 'total' => $total_blogs);
200    }
201
202    /**
203     * Delete the record of a given blog for all users.
204     *
205     * @param int $blog_id The blog being removed from all users.
206     * @return int|bool Number of rows deleted on success, false on failure.
207     */
208    public static function delete_blog_for_all($blog_id) {
209        global $wpdb, $bp;
210
211        bp_blogs_delete_blogmeta($blog_id);
212        return $wpdb->query($wpdb->prepare("DELETE FROM {$bp->blogs->table_name} WHERE blog_id = %d", $blog_id));
213    }
214
215    /**
216     * Delete the record of a given blog for a specific user.
217     *
218     * @param int $blog_id The blog being removed.
219     * @param int $user_id Optional. The ID of the user from whom the blog
220     *        is being removed. If absent, defaults to the logged-in user ID.
221     * @return int|bool Number of rows deleted on success, false on failure.
222     */
223    public static function delete_blog_for_user($blog_id, $user_id = null) {
224        global $wpdb, $bp;
225
226        if (!$user_id)
227            $user_id = bp_loggedin_user_id();
228
229        return $wpdb->query($wpdb->prepare("DELETE FROM {$bp->blogs->table_name} WHERE user_id = %d AND blog_id = %d", $user_id, $blog_id));
230    }
231
232    /**
233     * Delete all of a user's blog associations in the BP tables.
234     *
235     * @param int $user_id Optional. The ID of the user whose blog
236     *        associations are being deleted. If absent, defaults to
237     *        logged-in user ID.
238     * @return int|bool Number of rows deleted on success, false on failure.
239     */
240    public static function delete_blogs_for_user($user_id = null) {
241        global $wpdb, $bp;
242
243        if (!$user_id)
244            $user_id = bp_loggedin_user_id();
245
246        return $wpdb->query($wpdb->prepare("DELETE FROM {$bp->blogs->table_name} WHERE user_id = %d", $user_id));
247    }
248
249    /**
250     * Get all of a user's blogs, as tracked by BuddyPress.
251     *
252     * Note that this is different from the WordPress function
253     * {@link get_blogs_of_user()}; the current method returns only those
254     * blogs that have been recorded by BuddyPress, while the WP function
255     * does a true query of a user's blog capabilities.
256     *
257     * @param int $user_id Optional. ID of the user whose blogs are being
258     *        queried. Defaults to logged-in user.
259     * @param bool $show_hidden Optional. Whether to include blogs that are
260     *        not marked public. Defaults to true when viewing one's own
261     *        profile.
262     * @return array Multidimensional results array, structured as follows:
263     *           'blogs' - Array of located blog objects
264     *           'total' - A count of the total blogs for the user.
265
266      @version 2 stergatu
267     */
268    public static function get_blogs_for_user($user_id = 0, $show_hidden = false) {
269        global $bp, $wpdb;
270
271        if (!$user_id)
272            $user_id = bp_displayed_user_id();
273
274// Show logged in users their hidden blogs or user can moderate
275        if (!bp_is_my_profile() && !$show_hidden && !bp_current_user_can('bp_moderate'))
276            $blogs = $wpdb->get_results($wpdb->prepare("SELECT DISTINCT b.blog_id, b.id, bm1.meta_value as name, wb.domain, wb.path FROM {$bp->blogs->table_name} b, {$wpdb->base_prefix}blogs wb, {$bp->blogs->table_name_blogmeta} bm1 WHERE b.blog_id = wb.blog_id AND b.blog_id = bm1.blog_id AND bm1.meta_key = 'name' AND wb.public = 1 AND wb.deleted = 0 AND wb.spam = 0 AND wb.mature = 0 AND wb.archived = '0' AND b.user_id = %d ORDER BY b.blog_id", $user_id));
277        else
278            $blogs = $wpdb->get_results($wpdb->prepare("SELECT DISTINCT b.blog_id, b.id, bm1.meta_value as name, wb.domain, wb.path FROM {$bp->blogs->table_name} b, {$wpdb->base_prefix}blogs wb, {$bp->blogs->table_name_blogmeta} bm1 WHERE b.blog_id = wb.blog_id AND b.blog_id = bm1.blog_id AND bm1.meta_key = 'name' AND wb.deleted = 0 AND wb.spam = 0 AND wb.mature = 0 AND wb.archived = '0' AND b.user_id = %d ORDER BY b.blog_id", $user_id));
279
280        $total_blog_count = BP_Blogs_Blog::total_blog_count_for_user($user_id, $show_hidden);
281
282        $user_blogs = array();
283
284        foreach ((array) $blogs as $blog) {
285            $user_blogs[$blog->blog_id] = new stdClass;
286            $user_blogs[$blog->blog_id]->id = $blog->id;
287            $user_blogs[$blog->blog_id]->blog_id = $blog->blog_id;
288            $user_blogs[$blog->blog_id]->siteurl = ( is_ssl() ) ? 'https://' . $blog->domain . $blog->path : 'http://' . $blog->domain . $blog->path;
289            $user_blogs[$blog->blog_id]->name = $blog->name;
290        }
291
292        return array('blogs' => $user_blogs, 'count' => $total_blog_count);
293    }
294
295    /**
296     * Get IDs of all of a user's blogs, as tracked by BuddyPress.
297     *
298     * This method always includes hidden blogs.
299     *
300     * @param int $user_id Optional. ID of the user whose blogs are being
301     *        queried. Defaults to logged-in user.
302     * @return int The number of blogs associated with the user.
303     */
304    public static function get_blog_ids_for_user($user_id = 0) {
305        global $bp, $wpdb;
306
307        if (!$user_id)
308            $user_id = bp_displayed_user_id();
309
310        return $wpdb->get_col($wpdb->prepare("SELECT blog_id FROM {$bp->blogs->table_name} WHERE user_id = %d", $user_id));
311    }
312
313    /**
314     * Check whether a blog has been recorded by BuddyPress.
315     *
316     * @param int $blog_id ID of the blog being queried.
317     * @return int|null The ID of the first located entry in the BP table
318     *         on success, otherwise null.
319     */
320    public static function is_recorded($blog_id) {
321        global $bp, $wpdb;
322
323        return $wpdb->get_var($wpdb->prepare("SELECT id FROM {$bp->blogs->table_name} WHERE blog_id = %d", $blog_id));
324    }
325
326    /**
327     * Return a count of associated blogs for a given user.
328     *
329     * Includes hidden blogs when the logged-in user is the same as the
330     * $user_id parameter, or when the logged-in user has the bp_moderate
331     * cap.
332     *
333     * @param int $user_id Optional. ID of the user whose blogs are being
334     *        queried. Defaults to logged-in user.
335     * @param type $show_hidden
336     * @return int Blog count for the user.
337     * @version 2.0, stergatu on 22/11/2013
338     */
339    public static function total_blog_count_for_user($user_id = null, $show_hidden = false) {
340        global $bp, $wpdb;
341
342        if (!$user_id)
343            $user_id = bp_displayed_user_id();
344
345
346        // Show logged in users their hidden blogs or show also hidden user's blog.
347        if (!bp_is_my_profile() && !$show_hidden && !bp_current_user_can('bp_moderate'))
348            return $wpdb->get_var($wpdb->prepare("SELECT COUNT(DISTINCT b.blog_id) FROM {$bp->blogs->table_name} b LEFT JOIN {$wpdb->base_prefix}blogs wb ON b.blog_id = wb.blog_id WHERE wb.public = 1 AND wb.deleted = 0 AND wb.spam = 0 AND wb.mature = 0 AND wb.archived = '0' AND user_id = %d", $user_id));
349        else
350            return $wpdb->get_var($wpdb->prepare("SELECT COUNT(DISTINCT b.blog_id) FROM {$bp->blogs->table_name} b LEFT JOIN {$wpdb->base_prefix}blogs wb ON b.blog_id = wb.blog_id WHERE wb.deleted = 0 AND wb.spam = 0 AND wb.mature = 0 AND wb.archived = '0' AND user_id = %d", $user_id));
351    }
352
353    /**
354     * Return a list of blogs matching a search term.
355     *
356     * Matches against blog names and descriptions, as stored in the BP
357     * blogmeta table.
358     *
359     * @param string $filter The search term.
360     * @param int $limit Optional. The maximum number of items to return.
361     *        Default: null (no limit).
362     * @param int $page Optional. The page of results to return. Default:
363     *        null (no limit).
364     * @return array Multidimensional results array, structured as follows:
365     *           'blogs' - Array of located blog objects
366     *           'total' - A count of the total blogs matching the query.
367     * @version 2 stergatu
368     */
369    public static function search_blogs($filter, $per_page = null, $page = null, $show_hidden = FALSE) {
370        global $wpdb, $bp;
371
372        $filter = esc_sql(like_escape($filter));
373
374        $hidden_sql = '';
375
376
377        if (!bp_is_my_profile() && !$show_hidden && !bp_current_user_can('bp_moderate'))
378            $hidden_sql = "AND wb.public = 1";
379
380        if ($per_page && $page) {
381            $pag_sql = $wpdb->prepare(" LIMIT %d, %d", intval(( $page - 1 ) * $per_page), intval($per_page));
382        }
383
384        $paged_blogs = $wpdb->get_results("SELECT DISTINCT bm.blog_id FROM {$bp->blogs->table_name_blogmeta} bm LEFT JOIN {$wpdb->base_prefix}blogs wb ON bm.blog_id = wb.blog_id WHERE ( ( bm.meta_key = 'name' OR bm.meta_key = 'description' ) AND bm.meta_value LIKE '%%$filter%%' ) {$hidden_sql} AND wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 ORDER BY meta_value ASC{$pag_sql}");
385        $total_blogs = $wpdb->get_var("SELECT COUNT(DISTINCT bm.blog_id) FROM {$bp->blogs->table_name_blogmeta} bm LEFT JOIN {$wpdb->base_prefix}blogs wb ON bm.blog_id = wb.blog_id WHERE ( ( bm.meta_key = 'name' OR bm.meta_key = 'description' ) AND bm.meta_value LIKE '%%$filter%%' ) {$hidden_sql} AND wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 ORDER BY meta_value ASC");
386
387        return array('blogs' => $paged_blogs, 'total' => $total_blogs);
388    }
389
390    /**
391     * Retrieve a list of all blogs.
392     *
393     * Query will include hidden blogs if the logged-in user has the
394     * 'bp_moderate' cap.
395     *
396     * @param int $limit Optional. The maximum number of items to return.
397     *        Default: null (no limit).
398     * @param int $page Optional. The page of results to return. Default:
399     *        null (no limit).
400     * @return array Multidimensional results array, structured as follows:
401     *           'blogs' - Array of located blog objects
402     *           'total' - A count of the total blogs.
403     * @version 2 stergatu
404     */
405    public static function get_all($per_page = null, $page = null, $show_hidden = false) {
406        global $bp, $wpdb;
407        $hidden_sql = '';
408        if (!bp_is_my_profile() && !$show_hidden && !bp_current_user_can('bp_moderate'))
409            $hidden_sql = "AND wb.public = 1";
410
411
412        $pag_sql = ( $per_page && $page ) ? $wpdb->prepare(" LIMIT %d, %d", intval(( $page - 1 ) * $per_page), intval($per_page)) : '';
413
414        $paged_blogs = $wpdb->get_results("SELECT DISTINCT b.blog_id FROM {$bp->blogs->table_name} b LEFT JOIN {$wpdb->base_prefix}blogs wb ON b.blog_id = wb.blog_id WHERE wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 {$hidden_sql} {$pag_sql}");
415        $total_blogs = $wpdb->get_var("SELECT COUNT(DISTINCT b.blog_id) FROM {$bp->blogs->table_name} b LEFT JOIN {$wpdb->base_prefix}blogs wb ON b.blog_id = wb.blog_id WHERE wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 {$hidden_sql}");
416
417        return array('blogs' => $paged_blogs, 'total' => $total_blogs);
418    }
419
420    /**
421     * Retrieve a list of blogs whose names start with a given letter.
422     *
423     * Query will include hidden blogs if the logged-in user has the
424     * 'bp_moderate' cap.
425     *
426     * @param string $letter. The letter you're looking for.
427     * @param int $per_page Optional. The maximum number of items to return.
428     *        Default: null (no limit).
429     * @param int $page Optional. The page of results to return. Default:
430     *        null (no limit).
431     * @return array Multidimensional results array, structured as follows:
432     *           'blogs' - Array of located blog objects.
433     *           'total' - A count of the total blogs matching the query.
434     * @version 2, stergatu changed show_hidden and $limit to $per_page
435     */
436    public static function get_by_letter($letter, $per_page = null, $page = null, $show_hidden = false) {
437        global $bp, $wpdb;
438
439        $letter = esc_sql(like_escape($letter));
440
441        $hidden_sql = '';
442
443        if (!bp_is_my_profile() && !$show_hidden && !bp_current_user_can('bp_moderate'))
444            $hidden_sql = "AND wb.public = 1";
445
446
447
448
449        if ($per_page && $page)
450            $pag_sql = $wpdb->prepare(" LIMIT %d, %d", intval(( $page - 1 ) * $per_page), intval($per_page));
451
452        $paged_blogs = $wpdb->get_results("SELECT DISTINCT bm.blog_id FROM {$bp->blogs->table_name_blogmeta} bm LEFT JOIN {$wpdb->base_prefix}blogs wb ON bm.blog_id = wb.blog_id WHERE bm.meta_key = 'name' AND bm.meta_value LIKE '$letter%%' {$hidden_sql} AND wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 ORDER BY bm.meta_value ASC{$pag_sql}");
453        $total_blogs = $wpdb->get_var("SELECT COUNT(DISTINCT bm.blog_id) FROM {$bp->blogs->table_name_blogmeta} bm LEFT JOIN {$wpdb->base_prefix}blogs wb ON bm.blog_id = wb.blog_id WHERE bm.meta_key = 'name' AND bm.meta_value LIKE '$letter%%' {$hidden_sql} AND wb.mature = 0 AND wb.spam = 0 AND wb.archived = '0' AND wb.deleted = 0 ORDER BY bm.meta_value ASC");
454
455        return array('blogs' => $paged_blogs, 'total' => $total_blogs);
456    }
457
458    /**
459     * Fetch blog data not caught in the main query and append it to results array.
460     *
461     * Gets the following information, which is either unavailable at the
462     * time of the original query, or is more efficient to look up in one
463     * fell swoop:
464     *   - The latest post for each blog, include Featured Image data
465     *   - The blog description
466     *
467     * @param array $paged_blogs Array of results from the original query.
468     * @param array $blog_ids Array of IDs returned from the original query.
469     * @param string|bool $type Not currently used. Default: false.
470     * @return array $paged_blogs The located blogs array, with the extras added.
471     */
472    public static function get_blog_extras(&$paged_blogs, &$blog_ids, $type = false) {
473        global $bp, $wpdb;
474
475        if (empty($blog_ids))
476            return $paged_blogs;
477
478        $blog_ids = implode(',', wp_parse_id_list($blog_ids));
479
480        for ($i = 0, $count = count($paged_blogs); $i < $count; ++$i) {
481            $blog_prefix = $wpdb->get_blog_prefix($paged_blogs[$i]->blog_id);
482            $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");
483            $images = array();
484
485            // Add URLs to any Featured Image this post might have
486            if (!empty($paged_blogs[$i]->latest_post) && has_post_thumbnail($paged_blogs[$i]->latest_post->ID)) {
487
488                // Grab 4 sizes of the image. Thumbnail.
489                $image = wp_get_attachment_image_src(get_post_thumbnail_id($paged_blogs[$i]->latest_post->ID), 'thumbnail', false);
490                if (!empty($image))
491                    $images['thumbnail'] = $image[0];
492
493                // Medium
494                $image = wp_get_attachment_image_src(get_post_thumbnail_id($paged_blogs[$i]->latest_post->ID), 'medium', false);
495                if (!empty($image))
496                    $images['medium'] = $image[0];
497
498                // Large
499                $image = wp_get_attachment_image_src(get_post_thumbnail_id($paged_blogs[$i]->latest_post->ID), 'large', false);
500                if (!empty($image))
501                    $images['large'] = $image[0];
502
503                // Post thumbnail
504                $image = wp_get_attachment_image_src(get_post_thumbnail_id($paged_blogs[$i]->latest_post->ID), 'post-thumbnail', false);
505                if (!empty($image))
506                    $images['post-thumbnail'] = $image[0];
507
508                // Add the images to the latest_post object
509                $paged_blogs[$i]->latest_post->images = $images;
510            }
511        }
512
513        /* Fetch the blog description for each blog (as it may be empty we can't fetch it in the main query). */
514        $blog_descs = $wpdb->get_results("SELECT blog_id, meta_value as description FROM {$bp->blogs->table_name_blogmeta} WHERE meta_key = 'description' AND blog_id IN ( {$blog_ids} )");
515
516        for ($i = 0, $count = count($paged_blogs); $i < $count; ++$i) {
517            foreach ((array) $blog_descs as $desc) {
518                if ($desc->blog_id == $paged_blogs[$i]->blog_id)
519                    $paged_blogs[$i]->description = $desc->description;
520            }
521        }
522
523        return $paged_blogs;
524    }
525
526    /**
527     * Check whether a given blog is hidden.
528     *
529     * Checks the 'public' column in the wp_blogs table.
530     *
531     * @param int $blog_id The ID of the blog being checked.
532     * @return bool True if hidden (public = 0), false otherwise.
533     */
534    public static function is_hidden($blog_id) {
535        global $wpdb;
536
537        if (!(int) $wpdb->get_var($wpdb->prepare("SELECT DISTINCT public FROM {$wpdb->base_prefix}blogs WHERE blog_id = %d", $blog_id)))
538            return true;
539
540        return false;
541    }
542
543}