update_posts_count( string $deprecated = '' )

Update a blog’s post count.

Description

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

Expand Source Code View on GitHub

Uses

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

Used By

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

Changelog
Version	Description
WP-MU	Introduced. (3.0.0)