← All changes | includes/class-metasync-oxygen-compat.php +3 -4 2.6.21 → 2.7.1 View file →

		@@ -65,9 +65,8 @@
65	65
66	66	$updated = self::resign_templates();
67	67
68	68	if ($updated > 0) {
69		- error_log("MetaSync Oxygen Compat: Re-signed shortcodes in {$updated} template(s).");
70	69	$full_fp = self::build_full_fingerprint(); // Recompute after DB writes
71	70	}
72	71
73	72	update_option(self::OPTION_KEY, $light_fp . '|' . $full_fp, true);
		@@ -118,9 +117,9 @@
118	117	global $wpdb;
119	118
120	119	$key = get_option('oxygen_private_key', '');
121	120
122		- $row = $wpdb->get_row(
	121	+ $row = $wpdb->get_row( // phpcs:ignore WordPress.DB.DirectDatabaseQuery -- reads Oxygen builder template storage — the third-party builder has no WordPress API
123	122	"SELECT COUNT(*) AS cnt, MAX(p.post_modified_gmt) AS latest
124	123	FROM {$wpdb->posts} p
125	124	INNER JOIN {$wpdb->postmeta} pm ON pm.post_id = p.ID AND pm.meta_key = '_ct_builder_json'
126	125	WHERE p.post_type = 'ct_template'
		@@ -142,9 +141,9 @@
142	141	global $wpdb;
143	142
144	143	$key = get_option('oxygen_private_key', '');
145	144
146		- $json_rows = $wpdb->get_col(
	145	+ $json_rows = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery -- reads Oxygen builder template storage — the third-party builder has no WordPress API
147	146	"SELECT pm.meta_value
148	147	FROM {$wpdb->postmeta} pm
149	148	INNER JOIN {$wpdb->posts} p ON p.ID = pm.post_id
150	149	WHERE p.post_type = 'ct_template'
		@@ -168,9 +167,9 @@
168	167	if (!$signer) {
169	168	return 0;
170	169	}
171	170
172		- $template_ids = $wpdb->get_col(
	171	+ $template_ids = $wpdb->get_col( // phpcs:ignore WordPress.DB.DirectDatabaseQuery -- reads Oxygen builder template storage — the third-party builder has no WordPress API
173	172	"SELECT p.ID
174	173	FROM {$wpdb->posts} p
175	174	WHERE p.post_type = 'ct_template'
176	175	AND p.post_status = 'publish'