Changeset 43629 for trunk/src/wp-admin/includes/schema.php

Timestamp:

09/05/2018 11:01:36 AM (6 years ago)

Author:

flixos90

Message:

Upgrade/Install: Introduce populate_site_meta().

Fixes #44896. See #41333.

File:

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

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

@@ -1293 +1293 @@
     $wpdb->query( "INSERT INTO $wpdb->sitemeta ( site_id, meta_key, meta_value ) VALUES " . $insert ); // phpcs:ignore WordPress.WP.PreparedSQL.NotPrepared
 }
+
+/**
+ * Creates WordPress site meta and sets the default values.
+ *
+ * @since 5.0.0
+ *
+ * @global wpdb $wpdb WordPress database abstraction object.
+ *
+ * @param int   $site_id Site ID to populate meta for.
+ * @param array $meta    Optional. Custom meta $key => $value pairs to use. Default empty array.
+ */
+function populate_site_meta( $site_id, array $meta = array() ) {
+    global $wpdb;
+
+    $site_id = (int) $site_id;
+
+    if ( ! is_site_meta_supported() ) {
+        return;
+    }
+
+    if ( empty( $meta ) ) {
+        return;
+    }
+
+    $insert = '';
+    foreach ( $meta as $meta_key => $meta_value ) {
+        if ( is_array( $meta_value ) ) {
+            $meta_value = serialize( $meta_value );
+        }
+        if ( ! empty( $insert ) ) {
+            $insert .= ', ';
+        }
+        $insert .= $wpdb->prepare( '( %d, %s, %s)', $site_id, $meta_key, $meta_value );
+    }
+
+    $wpdb->query( "INSERT INTO $wpdb->blogmeta ( blog_id, meta_key, meta_value ) VALUES " . $insert ); // phpcs:ignore WordPress.WP.PreparedSQL.NotPrepared
+
+    wp_cache_set( 'last_changed', microtime(), 'sites' );
+}