php getdbused,wordpress函数get_blog_list()用法示例

Warning: This function has been deprecated. Use wp_get_sites() instead.

get_blog_list( int $start, int $num = 10, string $deprecated = '' )

Deprecated functionality to retrieve a list of all sites.

描述

参数

$start

(int)

(Optional)

Offset for retrieving the blog list. Default 0.

$num

(int)

(Optional)

Number of blogs to list.

Default value: 10

$deprecated

(string)

(Optional)

Unused.

Default value: ”

源代码

File: wp-includes/ms-deprecated.php

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", $wpdb->siteid), 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 ( $num == 'all' ) {

return array_slice( $blog_list, $start, count( $blog_list ) );

} else {

return array_slice( $blog_list, $start, $num );

}

}

更新日志

Version

描述

3.0.0

Use wp_get_sites()

MU

Introduced.

相关函数

Uses

wp-includes/functions.php:

_deprecated_function()

wp-includes/wp-db.php:

wpdb::get_results()

wp-includes/wp-db.php:

wpdb::get_var()

wp-includes/wp-db.php:

wpdb::prepare()

wp-includes/wp-db.php:

wpdb::get_blog_prefix()

Used By

wp-includes/ms-deprecated.php:

get_most_active_blogs()