get_col( $wpdb->prepare( "SELECT option_name FROM {$wpdb->options} WHERE option_name LIKE %s", $wpdb->esc_like( 'gstlayer_' ) . '%' ) ); foreach ( (array) $gstlayer_options as $gstlayer_option ) { delete_option( $gstlayer_option ); } // Product, variation and legacy order meta. $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->postmeta} WHERE meta_key LIKE %s OR meta_key LIKE %s", $wpdb->esc_like( '_gstlayer_' ) . '%', $wpdb->esc_like( '_billing_gstlayer_' ) . '%' ) ); // HPOS order meta. if ( $wpdb->get_var( $wpdb->prepare( 'SHOW TABLES LIKE %s', $wpdb->prefix . 'wc_orders_meta' ) ) === $wpdb->prefix . 'wc_orders_meta' ) { $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->prefix}wc_orders_meta WHERE meta_key LIKE %s OR meta_key LIKE %s", $wpdb->esc_like( '_gstlayer_' ) . '%', $wpdb->esc_like( '_billing_gstlayer_' ) . '%' ) ); } // Category term meta and customer profile meta. $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->termmeta} WHERE meta_key = %s", 'gstlayer_hsn' ) ); $wpdb->query( $wpdb->prepare( "DELETE FROM {$wpdb->usermeta} WHERE meta_key LIKE %s", $wpdb->esc_like( 'billing_gstlayer_' ) . '%' ) ); // Invoice register. // phpcs:ignore WordPress.DB.DirectDatabaseQuery.SchemaChange -- Intentional on opt-in uninstall. $wpdb->query( "DROP TABLE IF EXISTS {$wpdb->prefix}gstlayer_documents" ); wp_cache_flush();