← All changes | admin/advanced-settings/includes/functions.php +113 -0 3.9.8 → 4.0.3 View file →

		@@ -17,4 +17,117 @@
17	17	return $settings[ $setting ];
18	18
19	19	return false;
20	20	}
	21	+
	22	+
	23	+/**
	24	+ * Clean unnecessary extra post meta from unrelated posts
	25	+ *
	26	+ * - wppb_sc_rf_epf_active
	27	+ * - wppb-content-restrict-message-purchasing_restricted
	28	+ * - wppb-ul-active-theme
	29	+ * - wppb-ul-default-single-user-template
	30	+ * - wppb-ul-default-all-users-template
	31	+ *
	32	+ */
	33	+function wppb_cleanup_postmeta() {
	34	+ check_ajax_referer( 'wppb_cleanup_postmeta', 'nonce' );
	35	+
	36	+ if ( ! current_user_can( 'manage_options' ) ) {
	37	+ wp_send_json_error();
	38	+ }
	39	+
	40	+ global $wpdb;
	41	+
	42	+ $query = '';
	43	+ $step = isset( $_POST['step'] ) ? absint( $_POST['step'] ) : 1;
	44	+ $batch_size = 500;
	45	+ $rows_affected = 0;
	46	+
	47	+ if ( $step === 1 ) {
	48	+
	49	+ // First query - Social Connect meta
	50	+ $query = $wpdb->prepare( "DELETE FROM {$wpdb->postmeta}
	51	+ WHERE post_id IN (
	52	+ SELECT ID FROM {$wpdb->posts}
	53	+ WHERE post_type NOT IN (%s, %s)
	54	+ )
	55	+ AND meta_key = %s
	56	+ LIMIT %d",
	57	+ 'wppb-rf-cpt',
	58	+ 'wppb-epf-cpt',
	59	+ 'wppb_sc_rf_epf_active',
	60	+ $batch_size );
	61	+
	62	+ $rows_affected = $wpdb->query( $query );
	63	+
	64	+ if ( $rows_affected === 0 ) {
	65	+
	66	+ // Move to next step when no more rows to delete
	67	+ wp_send_json_success( array( 'step' => 2 ) );
	68	+
	69	+ }
	70	+
	71	+ } else if ( $step === 2 ) {
	72	+
	73	+ // Second query - UserListing themes meta
	74	+ $query = $wpdb->prepare( "DELETE FROM {$wpdb->postmeta}
	75	+ WHERE post_id IN (
	76	+ SELECT ID FROM {$wpdb->posts}
	77	+ WHERE post_type != %s
	78	+ )
	79	+ AND meta_key IN (%s, %s, %s)
	80	+ LIMIT %d",
	81	+ 'wppb-ul-cpt',
	82	+ 'wppb-ul-active-theme',
	83	+ 'wppb-ul-default-single-user-template',
	84	+ 'wppb-ul-default-all-users-template',
	85	+ $batch_size );
	86	+
	87	+ $rows_affected = $wpdb->query( $query );
	88	+
	89	+ if ( $rows_affected === 0 ) {
	90	+
	91	+ // Move to next step when no more rows to delete
	92	+ wp_send_json_success( array( 'step' => 3 ) );
	93	+
	94	+ }
	95	+
	96	+ } else if ( $step === 3 ) {
	97	+
	98	+ // Third query - Placeholder Labels meta
	99	+ $query = $wpdb->prepare( "DELETE FROM {$wpdb->postmeta}
	100	+ WHERE meta_key = %s
	101	+ AND meta_value = %s
	102	+ LIMIT %d",
	103	+ 'pbpl-active',
	104	+ 'no',
	105	+ $batch_size );
	106	+
	107	+ $rows_affected = $wpdb->query( $query );
	108	+
	109	+ if ( $rows_affected === 0 ) {
	110	+
	111	+ // Save the new completion flag as non-autoloaded option
	112	+ add_option( 'wppb_postmeta_cleanup_completed_v2', true, '', 'no' );
	113	+
	114	+ // Remove the old completion flag
	115	+ delete_option( 'wppb_postmeta_cleanup_completed' );
	116	+
	117	+ // All done
	118	+ wp_send_json_success( array(
	119	+ 'step' => 'done',
	120	+ 'hide_button' => true
	121	+ ) );
	122	+
	123	+ }
	124	+
	125	+ }
	126	+
	127	+ // Continue with same step
	128	+ wp_send_json_success( array(
	129	+ 'step' => $step,
	130	+ 'rows_affected' => $rows_affected
	131	+ ) );
	132	+}
	133	+add_action( 'wp_ajax_wppb_cleanup_postmeta', 'wppb_cleanup_postmeta' );