Ticket #37923: sitemeta1.php

<?php

function on_site_update(){
        if( is_multisite() ){
                $list = list_of_site_meta_keys();
                $site_id = get_current_blog_id();
                foreach($list as $option){
                        $value = __get_option($option);
                        add_site_meta($site_id,$option,$value);
                }
        }
}

function add_site_meta( $site_id, $meta_key, $meta_value, $unique = false ) {
        // Bail if site meta table is not installed.
        if ( get_option( 'db_version' ) < 34370 ) {
                $list = list_of_site_meta_keys();
                if( in_array( $list ) && in_array( $option, $list) ){
                        return add_blog_option ($site_id, $meta_key, $meta_value);
                }

                return false;
        }

        $added = add_metadata( 'blog', $site_id, $meta_key, $meta_value, $unique );

        // Bust site query cache.
        if ( $added ) {
                wp_cache_set( 'last_changed', microtime(), 'sites' );
        }

        return $added;
}


function delete_site_meta( $site_id, $meta_key, $meta_value = '' ) {
        // Bail if site meta table is not installed.
        if ( get_option( 'db_version' ) < 34370 ) {
                $list = list_of_site_meta_keys();
                if( is_array( $list ) && in_array( $option, $list) ){
                        return delete_blog_option ($site_id, $meta_key);
                }

                return false;
        }

        $deleted = delete_metadata( 'blog', $site_id, $meta_key, $meta_value );

        // Bust site query cache.
        if ( $deleted ) {
                wp_cache_set( 'last_changed', microtime(), 'sites' );
        }

        return $deleted;
}

function get_site_meta( $site_id, $key = '', $single = false ) {
        // Bail if site meta table is not installed.
        if ( get_option( 'db_version' ) < 34370 ) {
                $list = list_of_site_meta_keys();
                if( is_array( $list ) && in_array( $option, $list) ){
                        return get_blog_option ($site_id, $meta_key);
                }

                return false;
        }

    // backwards compat
    $pre = apply_filters( "pre_option_{$key}", false, $key );
        if ( false !== $pre ){
                return $pre;
        }
    
        $value = get_metadata( 'blog', $site_id, $key, $single );
        //backwards compat
        return apply_filters( "option_{$key}", maybe_unserialize( $value ), $key );
}

function update_site_meta( $site_id, $meta_key, $meta_value, $prev_value = '' ) {
        // Bail if site meta table is not installed.
        if ( get_option( 'db_version' ) < 34370 ) {
                $list = list_of_site_meta_keys();
                if( is_array( $list ) && in_array( $option, $list) ){
                        return update_blog_option ($site_id, $meta_key, $meta_value);
                }

                return false;
        }

        $updated = update_metadata( 'blog', $site_id, $meta_key, $meta_value, $prev_value );

        // Bust site query cache.
        if ( $updated ) {
                wp_cache_set( 'last_changed', microtime(), 'sites' );
        }

        return $updated;
}

function list_of_site_meta_keys(){
    $list = array( 'blogname','siteurl','post_count','home','allowedthemes','blog_public','WPLANG','blogdescription','db_version');
    return apply_filters('list_of_site_meta_keys', $list);
}

function sync_update_option( $option, $old_value, $value ){
        $list = list_of_site_meta_keys();
        if(is_array($list) && !in_array( $option, $list) ){
                return;
        }
        $site_id = get_current_blog_id();
        update_site_meta( $site_id, $option, $value, $old_value ); 
        return;
}
add_action( 'updated_option', 'sync_update_option', 99, 3 );

function sync_add_option( $option, $value ){
        $list = list_of_site_meta_keys();
        if(is_array($list) && !in_array( $option, $list) ){
                return;
        }
        $site_id = get_current_blog_id();
        add_site_meta( $site_id, $option, $value ); 
        return;
}
add_action( 'added_option', 'sync_add_option', 99, 2 );

function sync_delete_option( $option ){
        $list = list_of_site_meta_keys();
        if(is_array($list) && !in_array( $option, $list) ){
                return;
        }
        $site_id = get_current_blog_id();
        delete_site_meta( $site_id, $option ); 
        return;
}
add_action( 'deleted_option', 'sync_delete_option', 99, 1 );