Changeset 42836 for trunk/src/wp-admin/includes/ms.php

Timestamp:

03/16/2018 02:14:04 AM (7 years ago)

Author:

flixos90

Message:

Multisite: Introduce metadata for sites.

A new global multisite table wp_blogmeta is added to the database schema, and a set of *_site_meta() API functions are introduced.

The implementation fails gracefully when the new table is not yet available, which may happen especially shortly after the core update, before the network has been upgraded to the new database schema. The presence of the table is detected once and stored as a global setting on the main network.

Core does not yet use site metadata, but there are several use-cases to be implemented or explored in the near future, and it allows plugins to extend sites with arbitrary data, which will come in particularly handy with the upcoming REST API endpoint for sites.

Props spacedmonkey, johnjamesjacoby, jeremyfelt, flixos90.
Fixes #37923.

File:

• trunk/src/wp-admin/includes/ms.php (modified) (1 diff)

trunk/src/wp-admin/includes/ms.php

@@ -134 +134 @@
         foreach ( (array) $drop_tables as $table ) {
             $wpdb->query( "DROP TABLE IF EXISTS `$table`" );
+        }
+
+        if ( is_site_meta_supported() ) {
+            $blog_meta_ids = $wpdb->get_col( $wpdb->prepare( "SELECT meta_id FROM $wpdb->blogmeta WHERE blog_id = %d ", $blog_id ) );
+            foreach ( $blog_meta_ids as $mid ) {
+                delete_metadata_by_mid( 'blog', $mid );
+            }
         }