| @@ -159,23 +159,14 @@ | ||
| 159 | 159 | ); |
| 160 | 160 | FrmDb::get_where_clause_and_values( $where ); |
| 161 | 161 | |
| 162 | 162 | // Delete any leftovers |
| 163 | - $wpdb->query( $wpdb->prepare( 'DELETE FROM ' . $wpdb->prefix . 'frm_item_metas ' . $where['where'], $where['values'] ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 163 | + $wpdb->query( $wpdb->prepare( 'DELETE FROM ' . $wpdb->prefix . 'frm_item_metas ' . $where['where'], $where['values'] ) ); // WPCS: unprepared SQL ok. | |
| 164 | 164 | self::clear_cache(); |
| 165 | 165 | } |
| 166 | 166 | |
| 167 | 167 | public static function duplicate_entry_metas( $old_id, $new_id ) { |
| 168 | 168 | $metas = self::get_entry_meta_info( $old_id ); |
| 169 | - | |
| 170 | - /** | |
| 171 | - * Allows changing entry duplicate values before save. | |
| 172 | - * | |
| 173 | - * @since 5.4.4 | |
| 174 | - * | |
| 175 | - * @param array $metas The list of entry meta values. | |
| 176 | - */ | |
| 177 | - $metas = apply_filters( 'frm_before_duplicate_entry_values', $metas ); | |
| 178 | 169 | foreach ( $metas as $meta ) { |
| 179 | 170 | self::add_entry_meta( $new_id, $meta->field_id, '', $meta->meta_value ); |
| 180 | 171 | unset( $meta ); |
| 181 | 172 | } |
| @@ -459,9 +450,9 @@ | ||
| 459 | 450 | break; |
| 460 | 451 | case 'day': |
| 461 | 452 | $value = '%' . $value . '%'; |
| 462 | 453 | } |
| 463 | - $where .= $wpdb->prepare( ' meta_value ' . $operator . ' %s and', $value ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 454 | + $where .= $wpdb->prepare( ' meta_value ' . $operator . ' %s and', $value ); // WPCS: unprepared SQL ok. | |
| 464 | 455 | } |
| 465 | 456 | $where .= $wpdb->prepare( ' field_id=%d', $field_id ); |
| 466 | 457 | $query = 'SELECT DISTINCT item_id FROM ' . $wpdb->prefix . 'frm_item_metas' . FrmDb::prepend_and_or_where( ' WHERE ', $where ); |
| 467 | 458 | } else { |
| @@ -467,12 +458,12 @@ | ||
| 467 | 458 | } else { |
| 468 | 459 | if ( $operator == 'LIKE' ) { |
| 469 | 460 | $search = '%' . $search . '%'; |
| 470 | 461 | } |
| 471 | - $query = $wpdb->prepare( "SELECT DISTINCT item_id FROM {$wpdb->prefix}frm_item_metas WHERE meta_value {$operator} %s and field_id = %d", $search, $field_id ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, WordPress.DB.PreparedSQL.InterpolatedNotPrepared | |
| 462 | + $query = $wpdb->prepare( "SELECT DISTINCT item_id FROM {$wpdb->prefix}frm_item_metas WHERE meta_value {$operator} %s and field_id = %d", $search, $field_id ); // WPCS: unprepared SQL ok. | |
| 472 | 463 | } |
| 473 | 464 | |
| 474 | - $results = $wpdb->get_col( $query, 0 ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared | |
| 465 | + $results = $wpdb->get_col( $query, 0 ); // WPCS: unprepared SQL ok. | |
| 475 | 466 | FrmDb::set_cache( $cache_key, $results, 'frm_entry' ); |
| 476 | 467 | |
| 477 | 468 | return $results; |
| 478 | 469 | } |