update_posts_count( string $deprecated = '' )

Update 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

$deprecated

(string) (Optional) Not used.

Default value: ''

Source

File: wp-includes/ms-functions.php

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'" ) );
}

Uses

Uses	Description
wp-includes/option.php: update_option()	Updates the value of an option that was already added.
wp-includes/wp-db.php: wpdb::get_var()	Retrieves one variable from the database.

Used By

Used By	Description
wp-includes/ms-blogs.php: _update_posts_count_on_delete()	Handler for updating the current site’s posts count when a post is deleted.
wp-includes/ms-blogs.php: _update_posts_count_on_transition_post_status()	Handler for updating the current site’s posts count when a post status changes.

Changelog

Version	Description
MU (3.0.0)	Introduced.

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