wp_update_network_site_counts

The timeline below displays how wordpress function wp_update_network_site_counts has changed across different WordPress versions. If a version is not listed, refer to the next available version below.

WordPress Version: 6.1

/**
 * Updates the network-wide site count.
 *
 * @since 3.7.0
 * @since 4.8.0 The `$network_id` parameter has been added.
 *
 * @param int|null $network_id ID of the network. Default is the current network.
 */
function wp_update_network_site_counts($network_id = null)
{
    $network_id = (int) $network_id;
    if (!$network_id) {
        $network_id = get_current_network_id();
    }
    $count = get_sites(array('network_id' => $network_id, 'spam' => 0, 'deleted' => 0, 'archived' => 0, 'count' => true, 'update_site_meta_cache' => false));
    update_network_option($network_id, 'blog_count', $count);
}

WordPress Version: .10

/**
 * Update the network-wide site count.
 *
 * @since 3.7.0
 * @since 4.8.0 The `$network_id` parameter has been added.
 *
 * @param int|null $network_id ID of the network. Default is the current network.
 */
function wp_update_network_site_counts($network_id = null)
{
    $network_id = (int) $network_id;
    if (!$network_id) {
        $network_id = get_current_network_id();
    }
    $count = get_sites(array('network_id' => $network_id, 'spam' => 0, 'deleted' => 0, 'archived' => 0, 'count' => true, 'update_site_meta_cache' => false));
    update_network_option($network_id, 'blog_count', $count);
}

WordPress Version: 5.1

/**
 * Update the network-wide site count.
 *
 * @since 3.7.0
 * @since 4.8.0 The `$network_id` parameter has been added.
 *
 * @param int|null $network_id ID of the network. Default is the current network.
 */
function wp_update_network_site_counts($network_id = null)
{
    $network_id = (int) $network_id;
    if (!$network_id) {
        $network_id = get_current_network_id();
    }
    $count = get_sites(array('network_id' => $network_id, 'spam' => 0, 'deleted' => 0, 'archived' => 0, 'count' => true));
    update_network_option($network_id, 'blog_count', $count);
}

WordPress Version: 4.8

/**
 * Update the network-wide site count.
 *
 * @since 3.7.0
 * @since 4.8.0 The $network_id parameter has been added.
 *
 * @param int|null $network_id ID of the network. Default is the current network.
 */
function wp_update_network_site_counts($network_id = null)
{
    $network_id = (int) $network_id;
    if (!$network_id) {
        $network_id = get_current_network_id();
    }
    $count = get_sites(array('network_id' => $network_id, 'spam' => 0, 'deleted' => 0, 'archived' => 0, 'count' => true));
    update_network_option($network_id, 'blog_count', $count);
}

WordPress Version: 4.6

/**
 * Update the network-wide site count.
 *
 * @since 3.7.0
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 */
function wp_update_network_site_counts()
{
    global $wpdb;
    $count = get_sites(array('network_id' => $wpdb->siteid, 'spam' => 0, 'deleted' => 0, 'archived' => 0, 'count' => true));
    update_site_option('blog_count', $count);
}

WordPress Version: 4.4

/**
 * Update the network-wide site count.
 *
 * @since 3.7.0
 *
 * @global wpdb $wpdb WordPress database abstraction object.
 */
function wp_update_network_site_counts()
{
    global $wpdb;
    $count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(blog_id) as c FROM {$wpdb->blogs} WHERE site_id = %d AND spam = '0' AND deleted = '0' and archived = '0'", $wpdb->siteid));
    update_site_option('blog_count', $count);
}

WordPress Version: 4.3

/**
 * Update the network-wide site count.
 *
 * @since 3.7.0
 *
 * @global wpdb $wpdb
 */
function wp_update_network_site_counts()
{
    global $wpdb;
    $count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(blog_id) as c FROM {$wpdb->blogs} WHERE site_id = %d AND spam = '0' AND deleted = '0' and archived = '0'", $wpdb->siteid));
    update_site_option('blog_count', $count);
}

WordPress Version: 3.7

/**
 * Update the network-wide site count.
 *
 * @since 3.7.0
 */
function wp_update_network_site_counts()
{
    global $wpdb;
    $count = $wpdb->get_var($wpdb->prepare("SELECT COUNT(blog_id) as c FROM {$wpdb->blogs} WHERE site_id = %d AND spam = '0' AND deleted = '0' and archived = '0'", $wpdb->siteid));
    update_site_option('blog_count', $count);
}