PluginProbe
Formidable Forms – WordPress Form Builder for Contact Forms, Calculators, Quizzes & More / 3.06.06
Formidable Forms – WordPress Form Builder for Contact Forms, Calculators, Quizzes & More v3.06.06
6.35 6.34 6.33.1 6.33 6.32.1 6.32 6.31 6.25 6.25.1 6.26 6.26.1 6.27 6.28 6.29 6.3 6.3.1 6.3.2 6.30 6.4 6.4.1 6.4.2 6.5 6.5.1 6.5.2 6.5.3 All 141 releases
← All changes | classes/models/FrmForm.php +380 -879 6.343.06.06 View file →
@@ -1,119 +1,85 @@
1 1 <?php
2 2 if ( ! defined( 'ABSPATH' ) ) {
3 - die( 'You are not allowed to call this page directly.' );
3 + die( 'You are not allowed to call this page directly.' );
4 4 }
5 5
6 6 class FrmForm {
7 7
8 - /**
9 - * @param array $values
10 - *
11 - * @return bool|int id on success or false on failure.
12 - */
13 - public static function create( $values ) {
14 - global $wpdb;
8 + /**
9 + * @return int|boolean id on success or false on failure
10 + */
11 + public static function create( $values ) {
12 + global $wpdb;
15 13
16 - $values = FrmAppHelper::maybe_filter_array( $values, array( 'name', 'description' ) );
17 -
18 14 $new_values = array(
19 - 'form_key' => FrmAppHelper::get_unique_key( $values['form_key'], $wpdb->prefix . 'frm_forms', 'form_key' ),
20 - 'name' => FrmAppHelper::truncate( $values['name'], 255, 1, '', true ),
21 - 'description' => $values['description'],
22 - 'status' => $values['status'] ?? 'published',
23 - 'logged_in' => $values['logged_in'] ?? 0,
24 - 'is_template' => isset( $values['is_template'] ) ? (int) $values['is_template'] : 0,
15 + 'form_key' => FrmAppHelper::get_unique_key( $values['form_key'], $wpdb->prefix . 'frm_forms', 'form_key' ),
16 + 'name' => $values['name'],
17 + 'description' => $values['description'],
18 + 'status' => isset( $values['status'] ) ? $values['status'] : 'draft',
19 + 'logged_in' => isset( $values['logged_in'] ) ? $values['logged_in'] : 0,
20 + 'is_template' => isset( $values['is_template'] ) ? (int) $values['is_template'] : 0,
25 21 'parent_form_id' => isset( $values['parent_form_id'] ) ? absint( $values['parent_form_id'] ) : 0,
26 - 'editable' => isset( $values['editable'] ) ? (int) $values['editable'] : 0,
27 - 'created_at' => $values['created_at'] ?? current_time( 'mysql', 1 ),
22 + 'editable' => isset( $values['editable'] ) ? (int) $values['editable'] : 0,
23 + 'created_at' => isset( $values['created_at'] ) ? $values['created_at'] : current_time( 'mysql', 1 ),
28 24 );
29 25
30 26 $options = isset( $values['options'] ) ? (array) $values['options'] : array();
31 27 FrmFormsHelper::fill_form_options( $options, $values );
32 28
33 - $options['before_html'] = $values['options']['before_html'] ?? FrmFormsHelper::get_default_html( 'before' );
34 - $options['after_html'] = $values['options']['after_html'] ?? FrmFormsHelper::get_default_html( 'after' );
35 - $options['submit_html'] = $values['options']['submit_html'] ?? FrmFormsHelper::get_default_html( 'submit' );
29 + $options['before_html'] = isset( $values['options']['before_html'] ) ? $values['options']['before_html'] : FrmFormsHelper::get_default_html( 'before' );
30 + $options['after_html'] = isset( $values['options']['after_html'] ) ? $values['options']['after_html'] : FrmFormsHelper::get_default_html( 'after' );
31 + $options['submit_html'] = isset( $values['options']['submit_html'] ) ? $values['options']['submit_html'] : FrmFormsHelper::get_default_html( 'submit' );
36 32
37 - /**
38 - * Allows modifying form options before updating or creating.
39 - *
40 - * @since 5.4 Add the third param.
41 - *
42 - * @param array $options Form options.
43 - * @param array $values Form data.
44 - * @param bool $update Is form updating or creating. It's `true` if is updating.
45 - */
46 - $options = apply_filters( 'frm_form_options_before_update', $options, $values, false );
47 - $options = self::maybe_filter_form_options( $options );
33 + $options = apply_filters( 'frm_form_options_before_update', $options, $values );
48 34 $new_values['options'] = serialize( $options );
49 35
36 + //if(isset($values['id']) && is_numeric($values['id']))
37 + // $new_values['id'] = $values['id'];
38 +
50 39 $wpdb->insert( $wpdb->prefix . 'frm_forms', $new_values );
51 40
52 - $id = $wpdb->insert_id;
41 + $id = $wpdb->insert_id;
53 42
54 43 // Clear form caching
55 44 self::clear_form_cache();
56 45
57 - return $id;
58 - }
46 + return $id;
47 + }
59 48
60 - /**
61 - * @since 5.0.08
62 - *
63 - * @param array $options
64 - *
65 - * @return array
66 - */
67 - private static function maybe_filter_form_options( $options ) {
68 - if ( ! FrmAppHelper::allow_unfiltered_html() && ! empty( $options['submit_html'] ) ) {
69 - $options['submit_html'] = FrmAppHelper::kses_submit_button( $options['submit_html'] );
70 - }
71 - return FrmAppHelper::maybe_filter_array( $options, array( 'submit_value', 'success_msg', 'before_html', 'after_html' ) );
72 - }
49 + /**
50 + * @return int|boolean ID on success or false on failure
51 + */
52 + public static function duplicate( $id, $template = false, $copy_keys = false, $blog_id = false ) {
53 + global $wpdb;
73 54
74 - /**
75 - * Duplicate a form.
76 - *
77 - * @param int $id Form ID to duplicate.
78 - * @param bool $template Whether the duplicated form is a template.
79 - * @param bool $copy_keys Whether to copy the original form key.
80 - * @param false|int $blog_id Blog ID when duplicating across sites, or false for current site.
81 - *
82 - * @return bool|int ID on success or false on failure
83 - */
84 - public static function duplicate( $id, $template = false, $copy_keys = false, $blog_id = false ) {
85 - global $wpdb;
55 + $values = self::getOne( $id, $blog_id );
56 + if ( ! $values ) {
57 + return false;
58 + }
86 59
87 - $values = self::getOne( $id, $blog_id );
60 + $new_key = $copy_keys ? $values->form_key : '';
88 61
89 - if ( ! $values ) {
90 - return false;
91 - }
62 + $new_values = array(
63 + 'form_key' => FrmAppHelper::get_unique_key( $new_key, $wpdb->prefix . 'frm_forms', 'form_key' ),
64 + 'name' => $values->name,
65 + 'description' => $values->description,
66 + 'status' => $template ? 'published' : 'draft',
67 + 'logged_in' => $values->logged_in ? $values->logged_in : 0,
68 + 'editable' => $values->editable ? $values->editable : 0,
69 + 'created_at' => current_time( 'mysql', 1 ),
70 + 'is_template' => $template ? 1 : 0,
71 + );
92 72
93 - $new_key = $copy_keys ? $values->form_key : '';
94 -
95 - $new_values = array(
96 - 'form_key' => FrmAppHelper::get_unique_key( $new_key, $wpdb->prefix . 'frm_forms', 'form_key' ),
97 - 'name' => $values->name,
98 - 'description' => $values->description,
99 - 'status' => $values->status ? $values->status : 'published',
100 - 'logged_in' => $values->logged_in ? $values->logged_in : 0,
101 - 'editable' => $values->editable ? $values->editable : 0,
102 - 'created_at' => current_time( 'mysql', 1 ),
103 - 'is_template' => $template ? 1 : 0,
104 - );
105 -
106 - if ( $blog_id ) {
107 - $new_values['status'] = 'published';
108 - $new_options = $values->options;
109 - FrmAppHelper::unserialize_or_decode( $new_options );
73 + if ( $blog_id ) {
74 + $new_values['status'] = 'published';
75 + $new_options = maybe_unserialize( $values->options );
110 76 $new_options['email_to'] = get_option( 'admin_email' );
111 - $new_options['copy'] = false;
112 - $new_values['options'] = $new_options;
113 - } else {
114 - $new_values['options'] = $values->options;
115 - }
77 + $new_options['copy'] = false;
78 + $new_values['options'] = $new_options;
79 + } else {
80 + $new_values['options'] = $values->options;
81 + }
116 82
117 83 if ( is_array( $new_values['options'] ) ) {
118 84 $new_values['options'] = serialize( $new_values['options'] );
119 85 }
@@ -119,33 +85,25 @@
119 85 }
120 86
121 87 $query_results = $wpdb->insert( $wpdb->prefix . 'frm_forms', $new_values );
122 88
123 - if ( $query_results ) {
89 + if ( $query_results ) {
124 90 // Clear form caching
125 91 self::clear_form_cache();
126 92
127 - $form_id = $wpdb->insert_id;
93 + $form_id = $wpdb->insert_id;
128 94 FrmField::duplicate( $id, $form_id, $copy_keys, $blog_id );
129 95
130 - // Update form settings after fields are created
96 + // update form settings after fields are created
131 97 do_action( 'frm_after_duplicate_form', $form_id, $new_values, array( 'old_id' => $id ) );
98 + return $form_id;
99 + }
132 100
133 - return $form_id;
134 - }
101 + return false;
102 + }
135 103
136 - return false;
137 - }
138 -
139 - /**
140 - * @param int $form_id
141 - * @param array $values
142 - *
143 - * @return void
144 - */
145 104 public static function after_duplicate( $form_id, $values ) {
146 - $new_opts = $values['options'];
147 - FrmAppHelper::unserialize_or_decode( $new_opts );
105 + $new_opts = maybe_unserialize( $values['options'] );
148 106 $values['options'] = $new_opts;
149 107
150 108 if ( isset( $new_opts['success_msg'] ) ) {
151 109 $new_opts['success_msg'] = FrmFieldsHelper::switch_field_ids( $new_opts['success_msg'] );
@@ -152,140 +110,50 @@
152 110 }
153 111
154 112 $new_opts = apply_filters( 'frm_after_duplicate_form_values', $new_opts, $form_id );
155 113
156 - // phpcs:ignore Universal.Operators.StrictComparisons
157 - if ( $new_opts != $values['options'] ) {
158 - global $wpdb;
114 + if ( $new_opts != $values['options'] ) {
115 + global $wpdb;
159 116 $wpdb->update( $wpdb->prefix . 'frm_forms', array( 'options' => maybe_serialize( $new_opts ) ), array( 'id' => $form_id ) );
160 - }
117 + }
118 + }
161 119
162 - self::switch_field_ids_in_fields( $form_id );
163 - }
120 + /**
121 + * @return int|boolean
122 + */
123 + public static function update( $id, $values, $create_link = false ) {
124 + global $wpdb;
164 125
165 - /**
166 - * Switches field ID in fields.
167 - *
168 - * @since 5.3
169 - *
170 - * @param int $form_id Form ID.
171 - *
172 - * @return void
173 - */
174 - private static function switch_field_ids_in_fields( $form_id ) {
175 - global $wpdb;
126 + if ( ! isset( $values['status'] ) && ( $create_link || isset( $values['options'] ) || isset( $values['item_meta'] ) || isset( $values['field_options'] ) ) ) {
127 + $values['status'] = 'published';
128 + }
176 129
177 - // Keys of fields that you want to check to replace field ID.
178 - $keys = array( 'default_value', 'field_options' );
179 - $sql_cols = 'fi.id';
180 -
181 - foreach ( $keys as $key ) {
182 - $sql_cols .= ',fi.' . $key;
183 - }
184 -
185 - $fields = FrmDb::get_results(
186 - "{$wpdb->prefix}frm_fields AS fi LEFT OUTER JOIN {$wpdb->prefix}frm_forms AS fr ON fi.form_id = fr.id",
187 - array(
188 - 'or' => 1,
189 - 'fi.form_id' => $form_id,
190 - 'fr.parent_form_id' => $form_id,
191 - ),
192 - $sql_cols
193 - );
194 -
195 - if ( ! $fields || ! is_array( $fields ) ) {
196 - return;
197 - }
198 -
199 - foreach ( $fields as $field ) {
200 - self::switch_field_ids_in_field( (array) $field );
201 - }
202 - }
203 -
204 - /**
205 - * Switches field ID in a field.
206 - *
207 - * @since 5.3
208 - *
209 - * @param array $field Field array.
210 - *
211 - * @return void
212 - */
213 - private static function switch_field_ids_in_field( $field ) {
214 - $new_values = array();
215 -
216 - foreach ( $field as $key => $value ) {
217 - if ( 'id' === $key || ! $value ) {
218 - continue;
219 - }
220 -
221 - if ( ! is_string( $value ) && ! is_array( $value ) ) {
222 - continue;
223 - }
224 -
225 - if ( 'field_options' === $key ) {
226 - // Need to loop through field_options to prevent breaking serialized string when length changed.
227 - FrmAppHelper::unserialize_or_decode( $value );
228 - $new_val = FrmFieldsHelper::switch_field_ids( $value );
229 - $new_val = serialize( $new_val );
230 - } else {
231 - $new_val = FrmFieldsHelper::switch_field_ids( $value );
232 - }
233 -
234 - if ( $new_val !== $value ) {
235 - $new_values[ $key ] = $new_val;
236 - }
237 - }//end foreach
238 -
239 - if ( $new_values ) {
240 - FrmField::update( $field['id'], $new_values );
241 - }
242 - }
243 -
244 - /**
245 - * Update a form.
246 - *
247 - * @param int $id Form ID.
248 - * @param array $values Form values to update.
249 - * @param bool $create_link Whether this is being called from link creation.
250 - *
251 - * @return bool|int
252 - */
253 - public static function update( $id, $values, $create_link = false ) {
254 - global $wpdb;
255 -
256 - $values = FrmAppHelper::maybe_filter_array( $values, array( 'name', 'description' ) );
257 -
258 - if ( ! isset( $values['status'] ) && ( $create_link || isset( $values['options'] ) || isset( $values['item_meta'] ) || isset( $values['field_options'] ) ) ) {
259 - $values['status'] = 'published';
260 - }
261 -
262 130 if ( isset( $values['form_key'] ) ) {
263 131 $values['form_key'] = FrmAppHelper::get_unique_key( $values['form_key'], $wpdb->prefix . 'frm_forms', 'form_key', $id );
264 - }
132 + }
265 133
266 134 $form_fields = array( 'form_key', 'name', 'description', 'status', 'parent_form_id' );
267 - $new_values = self::set_update_options( array(), $values, array( 'form_id' => $id ) );
268 135
269 - foreach ( $values as $value_key => $value ) {
270 - if ( $value_key && in_array( $value_key, $form_fields, true ) ) {
271 - $new_values[ $value_key ] = 'name' === $value_key ? FrmAppHelper::truncate( $value, 255, 1, '', true ) : $value;
272 - }
273 - }
136 + $new_values = self::set_update_options( array(), $values );
274 137
275 - if ( ! empty( $values['new_status'] ) ) {
276 - $new_values['status'] = $values['new_status'];
277 - }
138 + foreach ( $values as $value_key => $value ) {
139 + if ( $value_key && in_array( $value_key, $form_fields ) ) {
140 + $new_values[ $value_key ] = $value;
141 + }
142 + }
278 143
279 - if ( $new_values ) {
144 + if ( isset( $values['new_status'] ) && ! empty( $values['new_status'] ) ) {
145 + $new_values['status'] = $values['new_status'];
146 + }
147 +
148 + if ( ! empty( $new_values ) ) {
280 149 $query_results = $wpdb->update( $wpdb->prefix . 'frm_forms', $new_values, array( 'id' => $id ) );
281 -
282 - if ( $query_results ) {
150 + if ( $query_results ) {
283 151 self::clear_form_cache();
284 - }
285 - } else {
286 - $query_results = true;
287 - }
152 + }
153 + } else {
154 + $query_results = true;
155 + }
288 156 unset( $new_values );
289 157
290 158 $values = self::update_fields( $id, $values );
291 159
@@ -291,62 +159,45 @@
291 159
292 160 do_action( 'frm_update_form', $id, $values );
293 161 do_action( 'frm_update_form_' . $id, $values );
294 162
295 - return $query_results;
296 - }
163 + return $query_results;
164 + }
297 165
298 - /**
299 - * @param array $new_values
300 - * @param array $values
301 - * @param array $args
302 - *
303 - * @return array
304 - */
305 - public static function set_update_options( $new_values, $values, $args = array() ) {
166 + /**
167 + * @return array
168 + */
169 + public static function set_update_options( $new_values, $values ) {
306 170 if ( ! isset( $values['options'] ) ) {
307 - return $new_values;
308 - }
171 + return $new_values;
172 + }
309 173
310 - $options = ! empty( $values['options'] ) ? (array) $values['options'] : array();
174 + $options = isset( $values['options'] ) ? (array) $values['options'] : array();
311 175 FrmFormsHelper::fill_form_options( $options, $values );
312 176
313 - $options['custom_style'] = $values['options']['custom_style'] ?? 0;
314 - $options['before_html'] = $values['options']['before_html'] ?? FrmFormsHelper::get_default_html( 'before' );
315 - $options['after_html'] = $values['options']['after_html'] ?? FrmFormsHelper::get_default_html( 'after' );
316 - $options['submit_html'] = isset( $values['options']['submit_html'] ) && '' !== $values['options']['submit_html'] ? $values['options']['submit_html'] : FrmFormsHelper::get_default_html( 'submit' ); // phpcs:ignore SlevomatCodingStandard.Files.LineLength.LineTooLong
177 + $options['custom_style'] = isset( $values['options']['custom_style'] ) ? $values['options']['custom_style'] : 0;
178 + $options['before_html'] = isset( $values['options']['before_html'] ) ? $values['options']['before_html'] : FrmFormsHelper::get_default_html( 'before' );
179 + $options['after_html'] = isset( $values['options']['after_html'] ) ? $values['options']['after_html'] : FrmFormsHelper::get_default_html( 'after' );
180 + $options['submit_html'] = ( isset( $values['options']['submit_html'] ) && '' !== $values['options']['submit_html'] ) ? $values['options']['submit_html'] : FrmFormsHelper::get_default_html( 'submit' );
317 181
318 - /**
319 - * Allows modifying form options before updating or creating.
320 - *
321 - * @since 5.4 Added the third param.
322 - *
323 - * @param array $options Form options.
324 - * @param array $values Form data.
325 - * @param bool $update Is form updating or creating. It's `true` if is updating.
326 - */
327 - $options = apply_filters( 'frm_form_options_before_update', $options, $values, true );
328 - $options = self::maybe_filter_form_options( $options );
182 + $options = apply_filters( 'frm_form_options_before_update', $options, $values );
329 183 $new_values['options'] = serialize( $options );
330 184
331 185 return $new_values;
332 - }
186 + }
333 187
334 - /**
335 - * @param int $id Form ID.
336 - * @param array $values Form values array.
337 - *
338 - * @return array
339 - */
340 - public static function update_fields( $id, $values ) { // phpcs:ignore SlevomatCodingStandard.Complexity.Cognitive.ComplexityTooHigh
341 188
189 + /**
190 + * @return array
191 + */
192 + public static function update_fields( $id, $values ) {
193 +
342 194 if ( ! isset( $values['item_meta'] ) && ! isset( $values['field_options'] ) ) {
343 - return $values;
344 - }
195 + return $values;
196 + }
345 197
346 198 $all_fields = FrmField::get_all_for_form( $id );
347 -
348 - if ( ! $all_fields ) {
199 + if ( empty( $all_fields ) ) {
349 200 return $values;
350 201 }
351 202
352 203 if ( ! isset( $values['item_meta'] ) ) {
@@ -352,30 +203,30 @@
352 203 if ( ! isset( $values['item_meta'] ) ) {
353 204 $values['item_meta'] = array();
354 205 }
355 206
356 - $field_array = array();
357 - $existing_keys = array_keys( $values['item_meta'] );
358 -
359 - foreach ( $all_fields as $fid ) {
360 - // phpcs:ignore WordPress.PHP.StrictInArray.MissingTrueStrict, SlevomatCodingStandard.Files.LineLength.LineTooLong
207 + $field_array = array();
208 + $existing_keys = array_keys( $values['item_meta'] );
209 + foreach ( $all_fields as $fid ) {
361 210 if ( ! in_array( $fid->id, $existing_keys ) && ( isset( $values['frm_fields_submitted'] ) && in_array( $fid->id, $values['frm_fields_submitted'] ) ) || isset( $values['options'] ) ) {
362 211 $values['item_meta'][ $fid->id ] = '';
363 - }
364 -
212 + }
365 213 $field_array[ $fid->id ] = $fid;
366 - }
214 + }
367 215 unset( $all_fields );
368 216
369 - foreach ( $values['item_meta'] as $field_id => $default_value ) {
370 - $field = $field_array[ $field_id ] ?? FrmField::getOne( $field_id );
217 + foreach ( $values['item_meta'] as $field_id => $default_value ) {
218 + if ( isset( $field_array[ $field_id ] ) ) {
219 + $field = $field_array[ $field_id ];
220 + } else {
221 + $field = FrmField::getOne( $field_id );
222 + }
371 223
372 - if ( ! $field ) {
373 - continue;
374 - }
224 + if ( ! $field ) {
225 + continue;
226 + }
375 227
376 - $is_settings_page = isset( $values['options'] ) || isset( $values['field_options'][ 'custom_html_' . $field_id ] );
377 -
228 + $is_settings_page = ( isset( $values['options'] ) || isset( $values['field_options'][ 'custom_html_' . $field_id ] ) );
378 229 if ( $is_settings_page ) {
379 230 self::get_settings_page_html( $values, $field );
380 231
381 232 if ( ! defined( 'WP_IMPORTING' ) ) {
@@ -382,186 +233,70 @@
382 233 continue;
383 234 }
384 235 }
385 236
386 - // Updating the form.
237 + //updating the form
387 238 $update_options = FrmFieldsHelper::get_default_field_options_from_field( $field );
388 - // Don't check for POST html.
389 - unset( $update_options['custom_html'] );
239 + unset( $update_options['custom_html'] ); // don't check for POST html
390 240 $update_options = apply_filters( 'frm_field_options_to_update', $update_options );
391 241
392 - if ( ! is_array( $field->field_options ) ) {
393 - $field->field_options = array();
394 - }
395 -
396 242 foreach ( $update_options as $opt => $default ) {
397 - $field->field_options[ $opt ] = $values['field_options'][ $opt . '_' . $field_id ] ?? $default;
243 + $field->field_options[ $opt ] = isset( $values['field_options'][ $opt . '_' . $field_id ] ) ? $values['field_options'][ $opt . '_' . $field_id ] : $default;
398 244 self::sanitize_field_opt( $opt, $field->field_options[ $opt ] );
399 - }
245 + }
400 246
401 247 $field->field_options = apply_filters( 'frm_update_field_options', $field->field_options, $field, $values );
248 + $default_value = maybe_serialize( $values['item_meta'][ $field_id ] );
402 249
403 250 $new_field = array(
404 251 'field_options' => $field->field_options,
405 - 'default_value' => isset( $values[ 'default_value_' . $field_id ] ) ? FrmAppHelper::maybe_json_encode( $values[ 'default_value_' . $field_id ] ) : '',
252 + 'default_value' => $default_value,
406 253 );
407 254
408 - if ( ! FrmAppHelper::allow_unfiltered_html() && isset( $values['field_options'][ 'options_' . $field_id ] ) && is_array( $values['field_options'][ 'options_' . $field_id ] ) ) { // phpcs:ignore SlevomatCodingStandard.Files.LineLength.LineTooLong
409 - foreach ( $values['field_options'][ 'options_' . $field_id ] as $option_key => $option ) {
410 - if ( ! is_array( $option ) ) {
411 - continue;
412 - }
413 -
414 - foreach ( $option as $key => $item ) {
415 - $values['field_options'][ 'options_' . $field_id ][ $option_key ][ $key ] = FrmAppHelper::kses( $item, 'all' );
416 - }
417 - }
418 - }
419 -
420 255 self::prepare_field_update_values( $field, $values, $new_field );
421 - self::maybe_update_max_option( $field, $values, $new_field );
422 256
423 257 FrmField::update( $field_id, $new_field );
424 258
425 259 FrmField::delete_form_transient( $field->form_id );
426 - }//end foreach
260 + }
427 261 self::clear_form_cache();
428 262
429 - return $values;
430 - }
263 + return $values;
264 + }
431 265
432 - /**
433 - * Resets the 'max' option of a field when changing paragraph field type to other field types like text, email etc.
434 - *
435 - * @since 6.7
436 - *
437 - * @param object $field
438 - * @param array $values
439 - * @param array $new_field
440 - *
441 - * @return void
442 - */
443 - private static function maybe_update_max_option( $field, $values, &$new_field ) {
444 - if ( $field->type !== 'textarea' ||
445 - empty( $values['field_options'][ 'type_' . $field->id ] ) ||
446 - ! in_array( $values['field_options'][ 'type_' . $field->id ], array( 'text', 'email', 'url', 'password', 'phone' ), true ) ) {
447 - return;
448 - }
449 -
450 - $new_field['field_options']['max'] = '';
451 -
452 - /**
453 - * Update posted field setting so that new 'max' option is displayed after form is saved and page reloads.
454 - * FrmFieldsHelper::fill_default_field_opts populates field options by calling self::get_posted_field_setting.
455 - */
456 - $_POST['field_options'][ 'max_' . $field->id ] = '';
457 - }
458 -
459 - /**
460 - * @param string $opt
461 - * @param mixed $value
462 - *
463 - * @return void
464 - */
465 266 private static function sanitize_field_opt( $opt, &$value ) {
466 - if ( ! is_string( $value ) ) {
467 - return;
267 + if ( is_string( $value ) ) {
268 + if ( $opt === 'calc' ) {
269 + $value = strip_tags( $value );
270 + } else {
271 + $value = FrmAppHelper::kses( $value, 'all' );
272 + }
273 + $value = trim( $value );
468 274 }
469 -
470 - /**
471 - * Allow the option to turn off sanitization for a field. This way a custom rule can be used instead.
472 - * Make sure to add custom sanitization using the frm_update_field_options filter as the data will no longer be sanitized.
473 - *
474 - * @since 6.0
475 - *
476 - * @param bool $should_sanitize
477 - * @param string $opt
478 - */
479 - $should_sanitize = apply_filters( 'frm_should_sanitize_field_opt_string', true, $opt );
480 -
481 - if ( ! $should_sanitize ) {
482 - return;
483 - }
484 -
485 - $value = $opt === 'calc' ? self::sanitize_calc( $value ) : FrmAppHelper::kses( $value, 'all' );
486 - $value = trim( $value );
487 275 }
488 276
489 277 /**
490 - * @param string $value
491 - *
492 - * @return string
493 - */
494 - private static function sanitize_calc( $value ) {
495 - if ( str_contains( $value, '<' ) ) {
496 - $value = self::normalize_calc_spaces( $value );
497 - }
498 - // Allow <= and >=.
499 - $allow = array( '<= ', ' >=' );
500 - $temp = array( '< = ', ' > =' );
501 - $value = str_replace( $allow, $temp, $value );
502 - $value = strip_tags( $value );
503 - return str_replace( $temp, $allow, $value );
504 - }
505 -
506 - /**
507 - * Format a comparison like 5<10 to 5 < 10. Also works on 5< 10, 5 <10, 5<=10 variations.
508 - * This is to avoid an issue with unspaced calculations being recognized as HTML that gets removed when strip_tags is called.
509 - *
510 - * @param string $calc
511 - *
512 - * @return string
513 - */
514 - private static function normalize_calc_spaces( $calc ) {
515 - // Check for a pattern with 5 parts
516 - // $1 \d|\] the first comparison digit or the end of a comparison shortcode.
517 - // $2 a space (optional).
518 - // $3 an equals sign (optional) that follows the < operator for <= comparisons.
519 - // $4 another space (optional).
520 - // $5 \d|\[ the second comparison digit or the start of a comparison shortcode.
521 - return preg_replace( '/(\d|\])( ){0,1}<(=){0,1}( ){0,1}(\d|\[)/', '$1 <$3 $5', $calc );
522 - }
523 -
524 - /**
525 278 * Updating the settings page
526 - *
527 - * @param array $values Form values array.
528 - * @param object $field Field object, passed by reference.
529 - *
530 - * @return void
531 279 */
532 280 private static function get_settings_page_html( $values, &$field ) {
533 281 if ( isset( $values['field_options'][ 'custom_html_' . $field->id ] ) ) {
534 - $prev_opts = array();
535 - $fallback_html = $field->field_options['custom_html'] ?? FrmFieldsHelper::get_default_html( $field->type );
536 -
537 - $field->field_options['custom_html'] = $values['field_options'][ 'custom_html_' . $field->id ] ?? $fallback_html;
538 - } elseif ( $field->type === 'hidden' || $field->type === 'user_id' ) {
282 + $prev_opts = array();
283 + $fallback_html = isset( $field->field_options['custom_html'] ) ? $field->field_options['custom_html'] : FrmFieldsHelper::get_default_html( $field->type );
284 + $field->field_options['custom_html'] = isset( $values['field_options'][ 'custom_html_' . $field->id ] ) ? $values['field_options'][ 'custom_html_' . $field->id ] : $fallback_html;
285 + } elseif ( $field->type == 'hidden' || $field->type == 'user_id' ) {
539 286 $prev_opts = $field->field_options;
540 287 }
541 288
542 - if ( ! isset( $prev_opts ) ) {
543 - return;
289 + if ( isset( $prev_opts ) ) {
290 + $field->field_options = apply_filters( 'frm_update_form_field_options', $field->field_options, $field, $values );
291 + if ( $prev_opts != $field->field_options ) {
292 + FrmField::update( $field->id, array( 'field_options' => $field->field_options ) );
293 + }
544 294 }
545 -
546 - $field->field_options = apply_filters( 'frm_update_form_field_options', $field->field_options, $field, $values );
547 -
548 - // phpcs:ignore Universal.Operators.StrictComparisons
549 - if ( $prev_opts != $field->field_options ) {
550 - FrmField::update( $field->id, array( 'field_options' => $field->field_options ) );
551 - }
552 295 }
553 296
554 - /**
555 - * @param object $field
556 - * @param array $values
557 - * @param array $new_field
558 - *
559 - * @return void
560 - */
561 297 private static function prepare_field_update_values( $field, $values, &$new_field ) {
562 298 $field_cols = array(
563 - 'field_order' => 0,
564 299 'field_key' => '',
565 300 'required' => false,
566 301 'type' => '',
567 302 'description' => '',
@@ -567,22 +302,12 @@
567 302 'description' => '',
568 303 'options' => '',
569 304 'name' => '',
570 305 );
571 -
572 306 foreach ( $field_cols as $col => $default ) {
573 - $default = $default === '' ? $field->{$col} : $default;
574 - $new_field[ $col ] = $values['field_options'][ $col . '_' . $field->id ] ?? $default;
307 + $default = ( $default === '' ) ? $field->{$col} : $default;
308 + $new_field[ $col ] = isset( $values['field_options'][ $col . '_' . $field->id ] ) ? $values['field_options'][ $col . '_' . $field->id ] : $default;
575 309 }
576 -
577 - if ( $field->type === 'submit' && isset( $new_field['field_order'] ) && (int) $new_field['field_order'] === FrmSubmitHelper::DEFAULT_ORDER ) {
578 - $new_field['field_order'] = $field->field_order;
579 - }
580 -
581 - // Don't save the template option.
582 - if ( is_array( $new_field['options'] ) && isset( $new_field['options']['000'] ) ) {
583 - unset( $new_field['options']['000'] );
584 - }
585 310 }
586 311
587 312 /**
588 313 * Get a list of all form settings that should be translated
@@ -588,12 +313,9 @@
588 313 * Get a list of all form settings that should be translated
589 314 * on a multilingual site.
590 315 *
591 316 * @since 3.06.01
592 - *
593 - * @param object $form The form object.
594 - *
595 - * @return array
317 + * @param object $form - The form object
596 318 */
597 319 public static function translatable_strings( $form ) {
598 320 $strings = array(
599 321 'name',
@@ -600,81 +322,67 @@
600 322 'description',
601 323 'submit_value',
602 324 'submit_msg',
603 325 'success_msg',
604 - 'invalid_msg',
605 - 'failed_msg',
606 - 'login_msg',
607 - 'admin_permission',
608 326 );
609 327
610 328 return apply_filters( 'frm_form_strings', $strings, $form );
611 329 }
612 330
613 - /**
614 - * @param array|int $id
615 - * @param string $status
616 - *
617 - * @return bool|int
618 - */
331 + /**
332 + * @param string $status
333 + * @return int|boolean
334 + */
619 335 public static function set_status( $id, $status ) {
620 - if ( 'trash' === $status ) {
336 + if ( 'trash' == $status ) {
621 337 return self::trash( $id );
622 - }
338 + }
623 339
624 - $statuses = array( 'published', 'draft', 'trash' );
340 + $statuses = array( 'published', 'draft', 'trash' );
341 + if ( ! in_array( $status, $statuses ) ) {
342 + return false;
343 + }
625 344
626 - if ( ! in_array( $status, $statuses, true ) ) {
627 - return false;
628 - }
345 + global $wpdb;
629 346
630 - global $wpdb;
631 -
632 347 if ( is_array( $id ) ) {
633 348 $where = array(
634 - 'id' => $id,
349 + 'id' => $id,
635 350 'parent_form_id' => $id,
636 - 'or' => 1,
351 + 'or' => 1,
637 352 );
638 353 FrmDb::get_where_clause_and_values( $where );
639 354 array_unshift( $where['values'], $status );
640 355
641 - $query_results = $wpdb->query( $wpdb->prepare( 'UPDATE ' . $wpdb->prefix . 'frm_forms SET status = %s ' . $where['where'], $where['values'] ) ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared, SlevomatCodingStandard.Files.LineLength.LineTooLong
642 - } else {
356 + $query_results = $wpdb->query( $wpdb->prepare( 'UPDATE ' . $wpdb->prefix . 'frm_forms SET status = %s ' . $where['where'], $where['values'] ) ); // WPCS: unprepared SQL ok.
357 + } else {
643 358 $query_results = $wpdb->update( $wpdb->prefix . 'frm_forms', array( 'status' => $status ), array( 'id' => $id ) );
644 359 $wpdb->update( $wpdb->prefix . 'frm_forms', array( 'status' => $status ), array( 'parent_form_id' => $id ) );
645 - }
360 + }
646 361
647 - if ( $query_results ) {
362 + if ( $query_results ) {
648 363 self::clear_form_cache();
649 - }
364 + }
650 365
651 - return $query_results;
652 - }
366 + return $query_results;
367 + }
653 368
654 - /**
655 - * @param int|string $id Form ID.
656 - *
657 - * @return bool|int
658 - */
369 + /**
370 + * @return int|boolean
371 + */
659 372 public static function trash( $id ) {
660 - if ( ! EMPTY_TRASH_DAYS ) {
661 - return self::destroy( $id );
662 - }
373 + if ( ! EMPTY_TRASH_DAYS ) {
374 + return self::destroy( $id );
375 + }
663 376
664 377 $form = self::getOne( $id );
378 + if ( ! $form ) {
379 + return false;
380 + }
665 381
666 - if ( ! $form ) {
667 - return false;
668 - }
382 + $options = $form->options;
383 + $options['trash_time'] = time();
669 384
670 - if ( $form->status === 'trash' ) {
671 - return false;
672 - }
673 -
674 - $options = $form->options;
675 - $options['trash_time'] = time();
676 -
677 385 global $wpdb;
678 386 $query_results = $wpdb->update(
679 387 $wpdb->prefix . 'frm_forms',
680 388 array(
@@ -696,239 +404,184 @@
696 404 'parent_form_id' => $id,
697 405 )
698 406 );
699 407
700 - if ( $query_results ) {
408 + if ( $query_results ) {
701 409 self::clear_form_cache();
702 - }
410 + }
703 411
704 - return $query_results;
705 - }
412 + return $query_results;
413 + }
706 414
707 - /**
708 - * @param int|string $id Form ID.
709 - *
710 - * @return bool|int
711 - */
415 + /**
416 + * @return int|boolean
417 + */
712 418 public static function destroy( $id ) {
713 - global $wpdb;
419 + global $wpdb;
714 420
715 421 $form = self::getOne( $id );
716 -
717 - if ( ! $form ) {
718 - return false;
719 - }
720 -
422 + if ( ! $form ) {
423 + return false;
424 + }
721 425 $id = $form->id;
722 426
723 - // Disconnect the entries from this form
724 - $entries = FrmDb::get_col( 'frm_items', array( 'form_id' => $id ) );
725 -
427 + // Disconnect the entries from this form
428 + $entries = FrmDb::get_col( $wpdb->prefix . 'frm_items', array( 'form_id' => $id ) );
726 429 foreach ( $entries as $entry_id ) {
727 430 FrmEntry::destroy( $entry_id );
728 431 unset( $entry_id );
729 432 }
730 433
731 - // Disconnect the fields from this form
732 - $wpdb->query( $wpdb->prepare( 'DELETE fi FROM ' . $wpdb->prefix . 'frm_fields AS fi LEFT JOIN ' . $wpdb->prefix . 'frm_forms fr ON (fi.form_id = fr.id) WHERE fi.form_id=%d OR parent_form_id=%d', $id, $id ) ); // phpcs:ignore SlevomatCodingStandard.Files.LineLength.LineTooLong
434 + // Disconnect the fields from this form
435 + $wpdb->query( $wpdb->prepare( 'DELETE fi FROM ' . $wpdb->prefix . 'frm_fields AS fi LEFT JOIN ' . $wpdb->prefix . 'frm_forms fr ON (fi.form_id = fr.id) WHERE fi.form_id=%d OR parent_form_id=%d', $id, $id ) );
733 436
734 437 $query_results = $wpdb->query( $wpdb->prepare( 'DELETE FROM ' . $wpdb->prefix . 'frm_forms WHERE id=%d OR parent_form_id=%d', $id, $id ) );
438 + if ( $query_results ) {
439 + // Delete all form actions linked to this form
440 + $action_control = FrmFormActionsController::get_form_actions( 'email' );
441 + $action_control->destroy( $id, 'all' );
735 442
736 - if ( ! $query_results ) {
737 - return $query_results;
738 - }
443 + // Clear form caching
444 + self::clear_form_cache();
739 445
740 - // Delete all form actions linked to this form
741 - /**
742 - * @var FrmFormAction
743 - */
744 - $action_control = FrmFormActionsController::get_form_actions( 'email' );
745 - $action_control->destroy( $id, 'all' );
446 + do_action( 'frm_destroy_form', $id );
447 + do_action( 'frm_destroy_form_' . $id );
448 + }
746 449
747 - // Clear form caching
748 - self::clear_form_cache();
450 + return $query_results;
451 + }
749 452
750 - do_action( 'frm_destroy_form', $id );
751 - do_action( 'frm_destroy_form_' . $id );
752 -
753 - return $query_results;
754 - }
755 -
756 453 /**
757 454 * Delete trashed forms based on how long they have been trashed
758 455 *
759 - * @param int|string $delete_timestamp Timestamp cutoff for deletion.
760 - *
761 456 * @return int The number of forms deleted
762 457 */
763 458 public static function scheduled_delete( $delete_timestamp = '' ) {
764 - $trash_forms = FrmDb::get_results( 'frm_forms', array( 'status' => 'trash' ), 'id, parent_form_id, options' );
459 + global $wpdb;
765 460
461 + $trash_forms = FrmDb::get_results( $wpdb->prefix . 'frm_forms', array( 'status' => 'trash' ), 'id, options' );
462 +
766 463 if ( ! $trash_forms ) {
767 - return 0;
464 + return;
768 465 }
769 466
770 - if ( ! $delete_timestamp ) {
467 + if ( empty( $delete_timestamp ) ) {
771 468 $delete_timestamp = time() - ( DAY_IN_SECONDS * EMPTY_TRASH_DAYS );
772 469 }
773 470
774 471 $count = 0;
775 -
776 472 foreach ( $trash_forms as $form ) {
777 - FrmAppHelper::unserialize_or_decode( $form->options );
778 -
473 + $form->options = maybe_unserialize( $form->options );
779 474 if ( ! isset( $form->options['trash_time'] ) || $form->options['trash_time'] < $delete_timestamp ) {
780 475 self::destroy( $form->id );
781 -
782 - if ( empty( $form->parent_form_id ) ) {
783 - ++$count;
784 - }
476 + $count++;
785 477 }
786 478
787 479 unset( $form );
788 480 }
789 -
790 481 return $count;
791 482 }
792 483
793 - /**
794 - * @param int|string $id Form ID or key.
795 - *
796 - * @return string form name
797 - */
798 - public static function getName( $id ) {
484 + /**
485 + * @return string form name
486 + */
487 + public static function getName( $id ) {
799 488 $form = FrmDb::check_cache( $id, 'frm_form' );
489 + if ( $form ) {
490 + $r = stripslashes( $form->name );
491 + return $r;
492 + }
800 493
801 - if ( $form ) {
802 - return stripslashes( $form->name );
803 - }
494 + $query_key = is_numeric( $id ) ? 'id' : 'form_key';
495 + $r = FrmDb::get_var( 'frm_forms', array( $query_key => $id ), 'name' );
496 + $r = stripslashes( $r );
804 497
805 - $query_key = is_numeric( $id ) ? 'id' : 'form_key';
806 - $r = FrmDb::get_var( 'frm_forms', array( $query_key => $id ), 'name' );
498 + return $r;
499 + }
807 500
808 - // An empty form name can result in a null value.
809 - return is_null( $r ) ? '' : stripslashes( $r );
810 - }
811 -
812 - /**
501 + /**
813 502 * @since 3.0
814 - *
815 - * @param string $key
816 - *
817 - * @return int form id
818 - */
503 + * @param string $key
504 + * @return int form id
505 + */
819 506 public static function get_id_by_key( $key ) {
820 507 return (int) FrmDb::get_var( 'frm_forms', array( 'form_key' => sanitize_title( $key ) ) );
821 - }
508 + }
822 509
823 - /**
510 + /**
824 511 * @since 3.0
825 - *
826 - * @param int|string $id
827 - *
828 - * @return string form key
829 - */
512 + * @param int $id
513 + * @return string form key
514 + */
830 515 public static function get_key_by_id( $id ) {
831 - $id = (int) $id;
516 + $id = (int) $id;
832 517 $cache = FrmDb::check_cache( $id, 'frm_form' );
518 + if ( $cache ) {
519 + return $cache->form_key;
520 + }
833 521
834 - if ( $cache ) {
835 - return $cache->form_key;
836 - }
522 + $key = FrmDb::get_var( 'frm_forms', array( 'id' => $id ), 'form_key' );
837 523
838 - return FrmDb::get_var( 'frm_forms', array( 'id' => $id ), 'form_key' );
839 - }
524 + return $key;
525 + }
840 526
841 527 /**
842 528 * If $form is numeric, get the form object
843 529 *
530 + * @param object|int $form
844 531 * @since 2.0.9
845 - *
846 - * @param array|int|object $form
847 - *
848 - * @return void
849 532 */
850 533 public static function maybe_get_form( &$form ) {
851 - if ( ! is_object( $form ) && ! is_array( $form ) && $form ) {
534 + if ( ! is_object( $form ) && ! is_array( $form ) && ! empty( $form ) ) {
852 535 $form = self::getOne( $form );
853 536 }
854 537 }
855 538
856 - /**
857 - * @param int|string $id
858 - * @param false|int $blog_id
859 - *
860 - * @return stdClass|null
861 - */
862 - public static function getOne( $id, $blog_id = false ) {
863 - global $wpdb;
539 + /**
540 + * @return object form
541 + */
542 + public static function getOne( $id, $blog_id = false ) {
543 + global $wpdb;
864 544
865 - if ( $blog_id && is_multisite() ) {
866 - $prefix = $wpdb->get_blog_prefix( $blog_id );
545 + if ( $blog_id && is_multisite() ) {
546 + global $wpmuBaseTablePrefix;
547 + $prefix = $wpmuBaseTablePrefix ? $wpmuBaseTablePrefix . $blog_id . '_' : $wpdb->get_blog_prefix( $blog_id );
548 +
867 549 $table_name = $prefix . 'frm_forms';
868 - } else {
550 + } else {
869 551 $table_name = $wpdb->prefix . 'frm_forms';
870 - $cache = wp_cache_get( $id, 'frm_form' );
552 + $cache = wp_cache_get( $id, 'frm_form' );
553 + if ( $cache ) {
554 + if ( isset( $cache->options ) ) {
555 + $cache->options = maybe_unserialize( $cache->options );
556 + }
871 557
872 - if ( $cache ) {
873 - if ( isset( $cache->options ) ) {
874 - FrmAppHelper::unserialize_or_decode( $cache->options );
875 - }
558 + return stripslashes_deep( $cache );
559 + }
560 + }
876 561
877 - return self::prepare_form_row_data( $cache );
878 - }
879 - }
562 + if ( is_numeric( $id ) ) {
563 + $where = array( 'id' => $id );
564 + } else {
565 + $where = array( 'form_key' => $id );
566 + }
880 567
881 - $where = is_numeric( $id ) ? array( 'id' => $id ) : array( 'form_key' => $id );
882 - $results = FrmDb::get_row( $table_name, $where );
568 + $results = FrmDb::get_row( $table_name, $where );
883 569
884 570 if ( isset( $results->options ) ) {
885 571 FrmDb::set_cache( $results->id, $results, 'frm_form' );
886 - FrmAppHelper::unserialize_or_decode( $results->options );
887 - }
572 + $results->options = maybe_unserialize( $results->options );
573 + }
574 + return stripslashes_deep( $results );
575 + }
888 576
889 - return self::prepare_form_row_data( $results );
890 - }
891 -
892 - /**
893 - * Make sure that if $row is an object, that $row->options is an array and not a string.
894 - *
895 - * @since 6.8.3
896 - *
897 - * @param stdClass|null $row The database row for a target form.
898 - *
899 - * @return stdClass|null
900 - */
901 - private static function prepare_form_row_data( $row ) {
902 - $row = wp_unslash( $row );
903 -
904 - if ( ! is_object( $row ) ) {
905 - return $row;
906 - }
907 -
908 - if ( ! is_array( $row->options ) ) {
909 - $row->options = FrmFormsHelper::get_default_opts();
910 - }
911 -
912 - /**
913 - * @since 4.03.02
914 - *
915 - * @param stdClass $row
916 - */
917 - return apply_filters( 'frm_form_object', $row );
918 - }
919 -
920 - /**
921 - * @param array|string $where Where conditions array or raw WHERE string.
922 - * @param string $order_by Order by clause.
923 - * @param int|string $limit Limit clause or number.
924 - *
925 - * @return array|object Array of objects. If $limit is 1, a single object is returned.
926 - */
577 + /**
578 + * @return object|array of objects
579 + */
927 580 public static function getAll( $where = array(), $order_by = '', $limit = '' ) {
928 - if ( is_array( $where ) && $where ) {
929 - if ( ! empty( $where['is_template'] ) && ! isset( $where['status'] ) && ! isset( $where['status !'] ) ) {
930 - // Don't get trashed templates
581 + if ( is_array( $where ) && ! empty( $where ) ) {
582 + if ( isset( $where['is_template'] ) && $where['is_template'] && ! isset( $where['status'] ) ) {
583 + // don't get trashed templates
931 584 $where['status'] = array( null, '', 'published' );
932 585 }
933 586
934 587 $results = FrmDb::get_results( 'frm_forms', $where, '*', compact( 'order_by', 'limit' ) );
@@ -934,62 +587,59 @@
934 587 $results = FrmDb::get_results( 'frm_forms', $where, '*', compact( 'order_by', 'limit' ) );
935 588 } else {
936 589 global $wpdb;
937 590
938 - // The query has already been prepared if this is not an array.
939 - $query = 'SELECT * FROM ' . $wpdb->prefix . 'frm_forms' . FrmDb::prepend_and_or_where( ' WHERE ', $where ) . FrmDb::esc_order( $order_by ) . FrmDb::esc_limit( $limit ); // phpcs:ignore SlevomatCodingStandard.Files.LineLength.LineTooLong
940 - $results = $wpdb->get_results( $query ); // phpcs:ignore WordPress.DB.PreparedSQL.NotPrepared
591 + // the query has already been prepared if this is not an array
592 + $query = 'SELECT * FROM ' . $wpdb->prefix . 'frm_forms' . FrmDb::prepend_and_or_where( ' WHERE ', $where ) . FrmDb::esc_order( $order_by ) . FrmDb::esc_limit( $limit );
593 + $results = $wpdb->get_results( $query ); // WPCS: unprepared SQL ok.
941 594 }
942 595
943 596 if ( $results ) {
944 597 foreach ( $results as $result ) {
945 598 FrmDb::set_cache( $result->id, $result, 'frm_form' );
946 - FrmAppHelper::unserialize_or_decode( $result->options );
599 + $result->options = maybe_unserialize( $result->options );
947 600 }
948 601 }
949 602
950 - if ( $limit === ' LIMIT 1' || (int) $limit === 1 ) {
951 - // Return the first form object if we are only getting one form
603 + if ( $limit == ' LIMIT 1' || $limit == 1 ) {
604 + // return the first form object if we are only getting one form
952 605 $results = reset( $results );
953 606 }
954 607
955 - return wp_unslash( $results );
956 - }
608 + return stripslashes_deep( $results );
609 + }
957 610
958 611 /**
959 612 * Get all published forms
960 613 *
961 614 * @since 2.0
962 - *
963 - * @param array $query
964 - * @param int $limit
965 - * @param string $inc_children
966 - *
967 - * @return array|object Array of forms. A single form object is returned if $limit is set to 1.
615 + * @return array of forms
968 616 */
969 617 public static function get_published_forms( $query = array(), $limit = 999, $inc_children = 'exclude' ) {
970 618 $query['is_template'] = 0;
971 - $query['status'] = array( null, '', 'published' );
972 -
973 - if ( $inc_children === 'exclude' ) {
619 + $query['status'] = array( null, '', 'published' );
620 + if ( $inc_children == 'exclude' ) {
974 621 $query['parent_form_id'] = array( null, 0 );
975 622 }
976 623
977 - return self::getAll( $query, 'name', $limit );
624 + $forms = self::getAll( $query, 'name', $limit );
625 + return $forms;
978 626 }
979 627
980 - /**
981 - * @return object count of forms
982 - */
983 - public static function get_count() {
984 - $cache_key = 'frm_form_counts';
985 - $counts = wp_cache_get( $cache_key, 'frm_form' );
628 + /**
629 + * @return object count of forms
630 + */
631 + public static function get_count() {
632 + global $wpdb;
986 633
987 - if ( false !== $counts ) {
988 - return $counts;
989 - }
634 + $cache_key = 'frm_form_counts';
990 635
991 - $results = FrmDb::get_results(
636 + $counts = wp_cache_get( $cache_key, 'frm_form' );
637 + if ( false !== $counts ) {
638 + return $counts;
639 + }
640 +
641 + $results = (array) FrmDb::get_results(
992 642 'frm_forms',
993 643 array(
994 644 'or' => 1,
995 645 'parent_form_id' => null,
@@ -998,31 +648,33 @@
998 648 'status, is_template'
999 649 );
1000 650
1001 651 $statuses = array( 'published', 'draft', 'template', 'trash' );
1002 - $counts = array_fill_keys( $statuses, 0 );
652 + $counts = array_fill_keys( $statuses, 0 );
1003 653
1004 - foreach ( $results as $row ) {
1005 - if ( 'trash' === $row->status ) {
1006 - ++$counts['trash'];
1007 - } elseif ( $row->is_template ) {
1008 - ++$counts['template'];
1009 - } else {
1010 - ++$counts['published'];
1011 - }
654 + foreach ( $results as $row ) {
655 + if ( 'trash' != $row->status ) {
656 + if ( $row->is_template ) {
657 + $counts['template']++;
658 + } else {
659 + $counts['published']++;
660 + }
661 + } else {
662 + $counts['trash']++;
663 + }
1012 664
1013 - if ( 'draft' === $row->status ) {
1014 - ++$counts['draft'];
1015 - }
665 + if ( 'draft' == $row->status ) {
666 + $counts['draft']++;
667 + }
1016 668
1017 669 unset( $row );
1018 - }
670 + }
1019 671
1020 - $counts = (object) $counts;
672 + $counts = (object) $counts;
1021 673 FrmDb::set_cache( $cache_key, $counts, 'frm_form' );
1022 674
1023 - return $counts;
1024 - }
675 + return $counts;
676 + }
1025 677
1026 678 /**
1027 679 * Clear form caching
1028 680 * Called when a form is created, updated, duplicated, or deleted
@@ -1028,37 +680,29 @@
1028 680 * Called when a form is created, updated, duplicated, or deleted
1029 681 * or when the form status is changed
1030 682 *
1031 683 * @since 2.0.4
1032 - *
1033 - * @return void
1034 684 */
1035 685 public static function clear_form_cache() {
1036 686 FrmDb::cache_delete_group( 'frm_form' );
1037 687 }
1038 688
1039 - /**
1040 - * @param array $values Form values to validate.
1041 - *
1042 - * @return array of errors
1043 - */
689 + /**
690 + * @return array of errors
691 + */
1044 692 public static function validate( $values ) {
1045 - $errors = array();
693 + $errors = array();
694 +
1046 695 return apply_filters( 'frm_validate_form', $errors, $values );
1047 - }
696 + }
1048 697
1049 - /**
1050 - * @param object|null $form
1051 - *
1052 - * @return array
1053 - */
1054 698 public static function get_params( $form = null ) {
1055 699 global $frm_vars;
1056 700
1057 - if ( $form ) {
701 + if ( ! $form ) {
702 + $form = self::getAll( array(), 'name', 1 );
703 + } else {
1058 704 self::maybe_get_form( $form );
1059 - } else {
1060 - $form = self::getAll( array(), 'name', 1 );
1061 705 }
1062 706
1063 707 if ( isset( $frm_vars['form_params'] ) && is_array( $frm_vars['form_params'] ) && isset( $frm_vars['form_params'][ $form->id ] ) ) {
1064 708 return $frm_vars['form_params'][ $form->id ];
@@ -1063,10 +707,10 @@
1063 707 if ( isset( $frm_vars['form_params'] ) && is_array( $frm_vars['form_params'] ) && isset( $frm_vars['form_params'][ $form->id ] ) ) {
1064 708 return $frm_vars['form_params'][ $form->id ];
1065 709 }
1066 710
1067 - $action_var = isset( $_REQUEST['frm_action'] ) ? 'frm_action' : 'action'; // phpcs:ignore WordPress.Security.NonceVerification.Missing
1068 - $action = apply_filters( 'frm_show_new_entry_page', FrmAppHelper::get_param( $action_var, 'new', 'get', 'sanitize_title' ), $form );
711 + $action_var = isset( $_REQUEST['frm_action'] ) ? 'frm_action' : 'action'; // WPCS: CSRF ok.
712 + $action = apply_filters( 'frm_show_new_entry_page', FrmAppHelper::get_param( $action_var, 'new', 'get', 'sanitize_title' ), $form );
1069 713
1070 714 $default_values = array(
1071 715 'id' => '',
1072 716 'form_name' => '',
@@ -1079,20 +723,18 @@
1079 723 'sdir' => '',
1080 724 'action' => $action,
1081 725 );
1082 726
1083 - $values = array();
727 + $values = array();
1084 728 $values['posted_form_id'] = FrmAppHelper::get_param( 'form_id', '', 'get', 'absint' );
1085 -
1086 729 if ( ! $values['posted_form_id'] ) {
1087 730 $values['posted_form_id'] = FrmAppHelper::get_param( 'form', '', 'get', 'absint' );
1088 731 }
1089 732
1090 - // phpcs:ignore Universal.Operators.StrictComparisons
1091 733 if ( $form->id == $values['posted_form_id'] ) {
1092 - // If there are two forms on the same page, make sure not to submit both.
734 + //if there are two forms on the same page, make sure not to submit both
1093 735 foreach ( $default_values as $var => $default ) {
1094 - if ( $var === 'action' ) {
736 + if ( $var == 'action' ) {
1095 737 $values[ $var ] = FrmAppHelper::get_param( $action_var, $default, 'get', 'sanitize_title' );
1096 738 } else {
1097 739 $values[ $var ] = FrmAppHelper::get_param( $var, $default, 'get', 'sanitize_text_field' );
1098 740 }
@@ -1104,11 +746,9 @@
1104 746 unset( $var, $default );
1105 747 }
1106 748 }
1107 749
1108 - if ( in_array( $values['action'], array( 'create', 'update' ), true ) &&
1109 - ( ! $_POST || ( ! isset( $_POST['action'] ) && ! isset( $_POST['frm_action'] ) ) ) // phpcs:ignore WordPress.Security.NonceVerification.Missing
1110 - ) {
750 + if ( in_array( $values['action'], array( 'create', 'update' ) ) && ( ! $_POST || ( ! isset( $_POST['action'] ) && ! isset( $_POST['frm_action'] ) ) ) ) { // WPCS: CSRF ok.
1111 751 $values['action'] = 'new';
1112 752 }
1113 753
1114 754 return $values;
@@ -1113,23 +753,19 @@
1113 753
1114 754 return $values;
1115 755 }
1116 756
1117 - /**
1118 - * @return array
1119 - */
1120 757 public static function list_page_params() {
1121 - $values = array();
758 + $values = array();
1122 759 $defaults = array(
1123 760 'template' => 0,
1124 - 'id' => '',
1125 - 'paged' => 1,
1126 - 'form' => '',
1127 - 'search' => '',
1128 - 'sort' => '',
1129 - 'sdir' => '',
761 + 'id' => '',
762 + 'paged' => 1,
763 + 'form' => '',
764 + 'search' => '',
765 + 'sort' => '',
766 + 'sdir' => '',
1130 767 );
1131 -
1132 768 foreach ( $defaults as $var => $default ) {
1133 769 $values[ $var ] = FrmAppHelper::get_param( $var, $default, 'get', 'sanitize_text_field' );
1134 770 }
1135 771
@@ -1135,23 +771,17 @@
1135 771
1136 772 return $values;
1137 773 }
1138 774
1139 - /**
1140 - * @param int|object|string|null $form
1141 - *
1142 - * @return array
1143 - */
1144 775 public static function get_admin_params( $form = null ) {
1145 776 $form_id = $form;
1146 -
1147 777 if ( $form === null ) {
1148 778 $form_id = self::get_current_form_id();
1149 - } elseif ( $form && is_object( $form ) ) {
779 + } else if ( $form && is_object( $form ) ) {
1150 780 $form_id = $form->id;
1151 781 }
1152 782
1153 - $values = array();
783 + $values = array();
1154 784 $defaults = array(
1155 785 'id' => '',
1156 786 'form_name' => '',
1157 787 'paged' => 1,
@@ -1162,9 +792,8 @@
1162 792 'sdir' => '',
1163 793 'fid' => '',
1164 794 'keep_post' => '',
1165 795 );
1166 -
1167 796 foreach ( $defaults as $var => $default ) {
1168 797 $values[ $var ] = FrmAppHelper::get_param( $var, $default, 'get', 'sanitize_text_field' );
1169 798 }
1170 799
@@ -1170,55 +799,45 @@
1170 799
1171 800 return $values;
1172 801 }
1173 802
1174 - /**
1175 - * @param string $default_form
1176 - *
1177 - * @return int|string
1178 - */
1179 803 public static function get_current_form_id( $default_form = 'none' ) {
1180 - $form = 'first' === $default_form ? self::get_current_form() : self::maybe_get_current_form();
1181 - return $form ? $form->id : 0;
804 + if ( 'first' == $default_form ) {
805 + $form = self::get_current_form();
806 + } else {
807 + $form = self::maybe_get_current_form();
808 + }
809 + $form_id = $form ? $form->id : 0;
810 +
811 + return $form_id;
1182 812 }
1183 813
1184 - /**
1185 - * @param int|string $form_id
1186 - *
1187 - * @return false|int|object|string
1188 - */
1189 814 public static function maybe_get_current_form( $form_id = 0 ) {
1190 815 global $frm_vars;
1191 816
1192 - if ( ! empty( $frm_vars['current_form'] ) && ( ! $form_id || (int) $form_id === (int) $frm_vars['current_form']->id ) ) {
817 + if ( isset( $frm_vars['current_form'] ) && $frm_vars['current_form'] && ( ! $form_id || $form_id == $frm_vars['current_form']->id ) ) {
1193 818 return $frm_vars['current_form'];
1194 819 }
1195 820
1196 821 $form_id = FrmAppHelper::get_param( 'form', $form_id, 'get', 'absint' );
1197 -
1198 - return $form_id ? self::set_current_form( $form_id ) : $form_id;
822 + if ( $form_id ) {
823 + $form_id = self::set_current_form( $form_id );
824 + }
825 + return $form_id;
1199 826 }
1200 827
1201 - /**
1202 - * @param int $form_id
1203 - *
1204 - * @return false|object
1205 - */
1206 828 public static function get_current_form( $form_id = 0 ) {
1207 829 $form = self::maybe_get_current_form( $form_id );
1208 - return is_numeric( $form ) ? self::set_current_form( $form ) : $form;
830 + if ( is_numeric( $form ) ) {
831 + $form = self::set_current_form( $form );
832 + }
833 + return $form;
1209 834 }
1210 835
1211 - /**
1212 - * @param int $form_id
1213 - *
1214 - * @return false|object
1215 - */
1216 836 public static function set_current_form( $form_id ) {
1217 837 global $frm_vars;
1218 838
1219 839 $query = array();
1220 -
1221 840 if ( $form_id ) {
1222 841 $query['id'] = $form_id;
1223 842 }
1224 843
@@ -1226,19 +845,11 @@
1226 845
1227 846 return $frm_vars['current_form'];
1228 847 }
1229 848
1230 - /**
1231 - * @param object $form
1232 - * @param int|string $this_load
1233 - * @param bool $global_load
1234 - *
1235 - * @return bool
1236 - */
1237 849 public static function is_form_loaded( $form, $this_load, $global_load ) {
1238 850 global $frm_vars;
1239 851 $small_form = new stdClass();
1240 -
1241 852 foreach ( array( 'id', 'form_key', 'name' ) as $var ) {
1242 853 $small_form->{$var} = $form->{$var};
1243 854 unset( $var );
1244 855 }
@@ -1244,155 +855,45 @@
1244 855 }
1245 856
1246 857 $frm_vars['forms_loaded'][] = $small_form;
1247 858
1248 - if ( $this_load && ! $global_load ) {
1249 - $global_load = true;
859 + if ( $this_load && empty( $global_load ) ) {
860 + $global_load = true;
1250 861 $frm_vars['load_css'] = true;
1251 862 }
1252 863
1253 - return empty( $frm_vars['css_loaded'] ) && $global_load;
864 + return ( ( ! isset( $frm_vars['css_loaded'] ) || ! $frm_vars['css_loaded'] ) && $global_load );
1254 865 }
1255 866
1256 - /**
1257 - * @since 4.06.03
1258 - *
1259 - * @param object $form
1260 - *
1261 - * @return bool
1262 - */
1263 - public static function is_visible_to_user( $form ) {
1264 - if ( $form->logged_in && isset( $form->options['logged_in_role'] ) ) {
1265 - $visible = FrmAppHelper::user_has_permission( $form->options['logged_in_role'] );
1266 - } else {
1267 - $visible = true;
1268 - }
1269 -
1270 - /**
1271 - * @since 6.25
1272 - *
1273 - * @param bool $visible
1274 - * @param object $form
1275 - */
1276 - return (bool) apply_filters( 'frm_form_is_visible', $visible, $form );
1277 - }
1278 -
1279 - /**
1280 - * @param object $form
1281 - *
1282 - * @return bool
1283 - */
1284 867 public static function show_submit( $form ) {
1285 - $show = ! $form->is_template && $form->status === 'published' && ! FrmAppHelper::is_admin();
1286 - return apply_filters( 'frm_show_submit_button', $show, $form );
868 + $show = ( ! $form->is_template && $form->status == 'published' && ! FrmAppHelper::is_admin() );
869 + $show = apply_filters( 'frm_show_submit_button', $show, $form );
870 + return $show;
1287 871 }
1288 872
1289 873 /**
1290 874 * @since 2.3
1291 - *
1292 - * @param array $atts Attributes including form, option, and default.
1293 - *
1294 - * @return mixed
1295 875 */
1296 876 public static function get_option( $atts ) {
1297 - $form = $atts['form'];
1298 - $default = $atts['default'] ?? '';
1299 -
1300 - return $form->options[ $atts['option'] ] ?? $default;
877 + $form = $atts['form'];
878 + return isset( $form->options[ $atts['option'] ] ) ? $form->options[ $atts['option'] ] : $atts['default'];
1301 879 }
1302 880
1303 881 /**
1304 - * Get the link to edit this form.
1305 - *
1306 - * @since 4.0
1307 - *
1308 - * @param int $form_id The id of the form.
1309 - *
1310 - * @return string
1311 - */
1312 - public static function get_edit_link( $form_id ) {
1313 - return admin_url( 'admin.php?page=formidable&frm_action=edit&id=' . $form_id );
1314 - }
1315 -
1316 - /**
1317 - * Check if the "Submit this form with AJAX" setting is toggled on.
1318 - *
1319 - * @since 6.2
1320 - *
1321 - * @param stdClass $form
1322 - *
1323 - * @return bool
1324 - */
1325 - public static function is_ajax_on( $form ) {
1326 - return ! empty( $form->options['ajax_submit'] );
1327 - }
1328 -
1329 - /**
1330 - * Get the latest form available.
1331 - *
1332 - * @since 6.8
1333 - *
1334 - * @return object
1335 - */
1336 - public static function get_latest_form() {
1337 - $args = array(
1338 - array(
1339 - 'or' => 1,
1340 - 'parent_form_id' => null,
1341 - 'parent_form_id <' => 1,
1342 - ),
1343 - 'is_template' => 0,
1344 - 'status !' => 'trash',
1345 - );
1346 -
1347 - return self::getAll( $args, 'created_at desc', 1 );
1348 - }
1349 -
1350 - /**
1351 - * Count and return total forms.
1352 - *
1353 - * @since 6.8
1354 - *
1355 - * @return int
1356 - */
1357 - public static function get_forms_count() {
1358 - $args = array(
1359 - array(
1360 - 'or' => 1,
1361 - 'parent_form_id' => null,
1362 - 'parent_form_id <' => 1,
1363 - ),
1364 - 'is_template' => 0,
1365 - 'status !' => 'trash',
1366 - );
1367 -
1368 - return FrmDb::get_count( 'frm_forms', $args );
1369 - }
1370 -
1371 - /**
1372 - * @deprecated 2.03.05 This is still referenced in a few add ons (API, locations).
1373 - *
882 + * @deprecated 3.0
1374 883 * @codeCoverageIgnore
1375 884 *
1376 885 * @param string $key
1377 - *
1378 886 * @return int form id
1379 887 */
1380 888 public static function getIdByKey( $key ) {
1381 - _deprecated_function( __FUNCTION__, '2.03.05', 'FrmForm::get_id_by_key' );
1382 - return self::get_id_by_key( $key );
889 + return FrmFormDeprecated::getIdByKey( $key );
1383 890 }
1384 891
1385 892 /**
1386 - * @deprecated 2.03.05 This is still referenced in the API add on as of v1.13.
1387 - *
893 + * @deprecated 3.0
1388 894 * @codeCoverageIgnore
1389 - *
1390 - * @param int|string $id
1391 - *
1392 - * @return string
1393 895 */
1394 896 public static function getKeyById( $id ) {
1395 - _deprecated_function( __FUNCTION__, '2.03.05', 'FrmForm::get_key_by_id' );
1396 - return self::get_key_by_id( $id );
897 + return FrmFormDeprecated::getKeyById( $id );
1397 898 }
1398 899 }