prefix . 'pbb_log_browsers', $wpdb->prefix . 'pbb_log_countries', $wpdb->prefix . 'pbb_log_referrers', $wpdb->prefix . 'pbb_logs', $wpdb->prefix . 'pbb_subscribers', $wpdb->prefix . 'pbb_browsers', $wpdb->prefix . 'pbb_countries', $wpdb->prefix . 'pbb_referrers', ]; // Define the usermeta keys to delete $usermeta_keys_to_delete = [ // some usermeta keys ]; // Define the postmeta keys to delete $postmeta_keys_to_delete = [ 'popup_builder_block_settings', ]; // Define the transients to delete $transients_to_delete = [ // some transients ]; /** DELETE OPTIONS */ foreach ($options_to_delete as $option) { delete_option($option); delete_site_option($option); // For multisite compatibility } /** DELETE CUSTOM TABLES */ foreach ($tables_to_delete as $table) { $wpdb->query( sprintf( 'DROP TABLE IF EXISTS `%s`', esc_sql( $table ) ) ); } /** DELETE TRANSIENTS */ foreach ($transients_to_delete as $transient) { delete_transient($transient); delete_site_transient($transient); // For multisite } /** DELETE USERMETA */ foreach ($usermeta_keys_to_delete as $meta_key) { $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->usermeta} WHERE meta_key = %s", $meta_key)); } /** DELETE POSTMETA */ foreach ($postmeta_keys_to_delete as $meta_key) { $wpdb->query($wpdb->prepare("DELETE FROM {$wpdb->postmeta} WHERE meta_key = %s", $meta_key)); } }