W3cubDocs

/WordPress

update_posts_count( string $deprecated = )

Updates a blog’s post count.

Description

WordPress MS stores a blog’s post count as an option so as to avoid extraneous COUNTs when a blog’s details are fetched with get_site() . This function is called when posts are published or unpublished to make sure the count stays current.

Parameters

$deprecatedstringoptional
Not used.

Default:''

Source

function update_posts_count( $deprecated = '' ) {
	global $wpdb;
	update_option( 'post_count', (int) $wpdb->get_var( "SELECT COUNT(ID) FROM {$wpdb->posts} WHERE post_status = 'publish' and post_type = 'post'" ), true );
}

Changelog

Version Description
MU (3.0.0) Introduced.

© 2003–2024 WordPress Foundation
Licensed under the GNU GPLv2+ License.
https://developer.wordpress.org/reference/functions/update_posts_count