1 files changed, 112 insertions, 0 deletions
diff --git a/plugins/jetpack/jetpack_vendor/automattic/jetpack-sync/src/modules/class-meta.php b/plugins/jetpack/jetpack_vendor/automattic/jetpack-sync/src/modules/class-meta.php
new file mode 100644
index 00000000..de293a9b
--- /dev/null
+++ b/plugins/jetpack/jetpack_vendor/automattic/jetpack-sync/src/modules/class-meta.php
@@ -0,0 +1,112 @@
+<?php
+/**
+ * Meta sync module.
+ *
+ * @package automattic/jetpack-sync
+ */
+
+namespace Automattic\Jetpack\Sync\Modules;
+
+/**
+ * Class to handle sync for meta.
+ */
+class Meta extends Module {
+	/**
+	 * Sync module name.
+	 *
+	 * @access public
+	 *
+	 * @return string
+	 */
+	public function name() {
+		return 'meta';
+	}
+
+	/**
+	 * This implementation of get_objects_by_id() is a bit hacky since we're not passing in an array of meta IDs,
+	 * but instead an array of post or comment IDs for which to retrieve meta for. On top of that,
+	 * we also pass in an associative array where we expect there to be 'meta_key' and 'ids' keys present.
+	 *
+	 * This seemed to be required since if we have missing meta on WP.com and need to fetch it, we don't know what
+	 * the meta key is, but we do know that we have missing meta for a given post or comment.
+	 *
+	 * @todo Refactor the $wpdb->prepare call to use placeholders.
+	 *
+	 * @param string $object_type The type of object for which we retrieve meta. Either 'post' or 'comment'.
+	 * @param array  $config      Must include 'meta_key' and 'ids' keys.
+	 *
+	 * @return array
+	 */
+	public function get_objects_by_id( $object_type, $config ) {
+		$table = _get_meta_table( $object_type );
+
+		if ( ! $table ) {
+			return array();
+		}
+
+		if ( ! is_array( $config ) ) {
+			return array();
+		}
+
+		$meta_objects = array();
+		foreach ( $config as $item ) {
+			$meta = null;
+			if ( isset( $item['id'] ) && isset( $item['meta_key'] ) ) {
+				$meta = $this->get_object_by_id( $object_type, (int) $item['id'], (string) $item['meta_key'] );
+			}
+			$meta_objects[ $item['id'] . '-' . $item['meta_key'] ] = $meta;
+		}
+
+		return $meta_objects;
+	}
+
+	/**
+	 * Get a single Meta Result.
+	 *
+	 * @param string $object_type  post, comment, term, user.
+	 * @param null   $id           Object ID.
+	 * @param null   $meta_key     Meta Key.
+	 *
+	 * @return mixed|null
+	 */
+	public function get_object_by_id( $object_type, $id = null, $meta_key = null ) {
+		global $wpdb;
+
+		if ( ! is_int( $id ) || ! is_string( $meta_key ) ) {
+			return null;
+		}
+
+		$table            = _get_meta_table( $object_type );
+		$object_id_column = $object_type . '_id';
+
+		// Sanitize so that the array only has integer values.
+		$meta = $wpdb->get_results(
+			$wpdb->prepare(
+			// phpcs:ignore WordPress.DB.PreparedSQL.InterpolatedNotPrepared
+				"SELECT * FROM {$table} WHERE {$object_id_column} = %d AND meta_key = %s",
+				$id,
+				$meta_key
+			),
+			ARRAY_A
+		);
+
+		$meta_objects = null;
+
+		if ( ! is_wp_error( $meta ) && ! empty( $meta ) ) {
+			foreach ( $meta as $meta_entry ) {
+				if ( 'post' === $object_type && strlen( $meta_entry['meta_value'] ) >= Posts::MAX_POST_META_LENGTH ) {
+					$meta_entry['meta_value'] = '';
+				}
+				$meta_objects[] = array(
+					'meta_type'  => $object_type,
+					'meta_id'    => $meta_entry['meta_id'],
+					'meta_key'   => $meta_key,
+					'meta_value' => $meta_entry['meta_value'],
+					'object_id'  => $meta_entry[ $object_id_column ],
+				);
+			}
+		}
+
+		return $meta_objects;
+	}
+}