get_request(); $field_name = $request['_jfb_validation_path'][0]; $form_id = $request['_jet_engine_booking_form_id']; global $wpdb; $record_ids = $wpdb->get_col( $wpdb->prepare( 'SELECT id FROM ' . $wpdb->prefix . 'jet_fb_records WHERE form_id = %d AND status = %s', $form_id, 'success' ) ); if ( ! empty( $record_ids ) ) { $placeholders = array_fill( 0, count( $record_ids ), '%d' ); $sql = sprintf( 'SELECT COUNT(*) FROM ' . $wpdb->prefix . 'jet_fb_records_fields WHERE record_id IN (%s) AND field_name = %%s AND field_value = %%s', implode( ', ', $placeholders ) ); $params = array_merge( $record_ids, array( $field_name, $value ) ); $exists = $wpdb->get_var( $wpdb->prepare( $sql, $params ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared if ( $exists ) { return false; } } return true; } }