get_blog_list() │ WP 3.0.0

Deprecated functionality to retrieve a list of all sites.

No Hooks.

Returns

null. Nothing (null).

Usage

get_blog_list( $start, $num, $deprecated );

$start(int)

Offset for retrieving the blog list.

$num(int)

Number of blogs to list.
Default: 10

$deprecated(string)

Unused.
Default: ''

Notes

• See: wp_get_sites()
• Global. wpdb. $wpdb WordPress database abstraction object.

Changelog

get_blog_list() get blog list code ^{WP 6.9.1}

function get_blog_list( $start = 0, $num = 10, $deprecated = '' ) {
	_deprecated_function( __FUNCTION__, '3.0.0', 'wp_get_sites()' );

	global $wpdb;
	$blogs = $wpdb->get_results( $wpdb->prepare( "SELECT blog_id, domain, path FROM $wpdb->blogs WHERE site_id = %d AND public = '1' AND archived = '0' AND mature = '0' AND spam = '0' AND deleted = '0' ORDER BY registered DESC", get_current_network_id() ), ARRAY_A );

	$blog_list = array();
	foreach ( (array) $blogs as $details ) {
		$blog_list[ $details['blog_id'] ] = $details;
		$blog_list[ $details['blog_id'] ]['postcount'] = $wpdb->get_var( "SELECT COUNT(ID) FROM " . $wpdb->get_blog_prefix( $details['blog_id'] ). "posts WHERE post_status='publish' AND post_type='post'" );
	}

	if ( ! $blog_list ) {
		return array();
	}

	if ( 'all' === $num ) {
		return array_slice( $blog_list, $start, count( $blog_list ) );
	} else {
		return array_slice( $blog_list, $start, $num );
	}
}