← All changes | classes/views/xml/forms_xml.php +41 -48 6.30 → 1.07.11 View file →

		@@ -1,60 +1,53 @@
1		-<?php
2		-if ( ! defined( 'ABSPATH' ) ) {
3		- die( 'You are not allowed to call this page directly.' );
4		-}
	1	+<?php
5	2
6		-/**
7		- * Generate the XML for export for forms and fields.
8		- *
9		- * @phpcs:disable Generic.WhiteSpace.ScopeIndent.Incorrect
10		- */
	3	+if ( !$item_ids )
	4	+ return;
11	5
12		-if ( ! $item_ids ) {
13		- return;
14		-}
	6	+$frm_form = new FrmForm();
15	7
16		-// Fetch 20 posts at a time rather than loading the entire table into memory
	8	+// fetch 20 posts at a time rather than loading the entire table into memory
17	9	while ( $next_set = array_splice( $item_ids, 0, 20 ) ) {
18		- $forms = FrmDb::get_results( 'frm_forms', array( 'id' => $next_set ) );
	10	+$where = 'WHERE id IN (' . join( ',', $next_set ) . ')';
	11	+$forms = $wpdb->get_results("SELECT * FROM {$wpdb->prefix}frm_forms $where");
	12	+unset($where);
19	13
20		- // Begin Loop
21		- foreach ( $forms as $form ) {
22		- ?>
	14	+// Begin Loop
	15	+foreach ( $forms as $form ) {
	16	+?>
23	17	<form>
24		- <id><?php echo absint( $form->id ); ?></id>
25		- <form_key><?php echo FrmXMLHelper::cdata( $form->form_key ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></form_key>
26		- <name><?php echo FrmXMLHelper::cdata( $form->name ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></name>
27		- <description><?php echo FrmXMLHelper::cdata( $form->description ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></description>
28		- <created_at><?php echo esc_html( $form->created_at ); ?></created_at>
29		- <logged_in><?php echo esc_html( $form->logged_in ); ?></logged_in>
30		- <is_template><?php echo esc_html( $form->is_template ); ?></is_template>
31		- <editable><?php echo esc_html( $form->editable ); ?></editable>
32		- <options><?php echo FrmXMLHelper::prepare_form_options_for_export( $form->options ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></options>
33		- <status><?php echo FrmXMLHelper::cdata( $form->status ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></status>
34		- <parent_form_id><?php echo esc_html( $form->parent_form_id ); ?></parent_form_id>
	18	+ <id><?php echo $form->id ?></id>
	19	+ <form_key><?php echo FrmXMLHelper::cdata($form->form_key) ?></form_key>
	20	+ <name><?php echo FrmXMLHelper::cdata($form->name) ?></name>
	21	+ <description><?php echo FrmXMLHelper::cdata($form->description) ?></description>
	22	+ <created_at><?php echo $form->created_at ?></created_at>
	23	+ <logged_in><?php echo $form->logged_in ?></logged_in>
	24	+ <is_template><?php echo $form->is_template ?></is_template>
	25	+ <default_template><?php echo $form->default_template ?></default_template>
	26	+ <editable><?php echo $form->editable ?></editable>
	27	+ <options><?php echo FrmXMLHelper::cdata($form->options) ?></options>
	28	+ <status><?php echo FrmXMLHelper::cdata($form->status) ?></status>
35	29	<?php
36		-
37		- $fields = FrmDb::get_results( 'frm_fields', array( 'form_id' => $form->id ), '*', array( 'order_by' => 'field_order' ) );
38		-
39		- foreach ( $fields as $field ) {
40		- FrmXMLHelper::prepare_field_for_export( $field );
41		- ?>
	30	+
	31	+ $fields = $wpdb->get_results($wpdb->prepare("SELECT * FROM {$wpdb->prefix}frm_fields WHERE form_id=%d ORDER BY field_order", $form->id));
	32	+
	33	+ foreach ( $fields as $field ){ ?>
42	34	<field>
43		- <id><?php echo absint( $field->id ); ?></id>
44		- <field_key><?php echo FrmXMLHelper::cdata( $field->field_key ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></field_key>
45		- <name><?php echo FrmXMLHelper::cdata( $field->name ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></name>
46		- <description><?php echo FrmXMLHelper::cdata( $field->description ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></description>
47		- <type><?php echo FrmXMLHelper::cdata( $field->type ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></type>
48		- <default_value><?php echo FrmXMLHelper::cdata( $field->default_value ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></default_value>
49		- <field_order><?php echo absint( $field->field_order ); ?></field_order>
50		- <form_id><?php echo absint( $field->form_id ); ?></form_id>
51		- <required><?php echo absint( $field->required ); ?></required>
52		- <options><?php echo FrmXMLHelper::cdata( $field->options ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></options>
53		- <field_options><?php echo FrmXMLHelper::cdata( $field->field_options ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?></field_options>
	35	+ <id><?php echo $field->id ?></id>
	36	+ <field_key><?php echo FrmXMLHelper::cdata($field->field_key) ?></field_key>
	37	+ <name><?php echo FrmXMLHelper::cdata($field->name) ?></name>
	38	+ <description><?php echo FrmXMLHelper::cdata($field->description) ?></description>
	39	+ <type><?php echo FrmXMLHelper::cdata($field->type) ?></type>
	40	+ <default_value><?php echo FrmXMLHelper::cdata($field->default_value) ?></default_value>
	41	+ <field_order><?php echo $field->field_order ?></field_order>
	42	+ <form_id><?php echo $field->form_id ?></form_id>
	43	+ <required><?php echo (bool)$field->required ?></required>
	44	+ <options><?php echo FrmXMLHelper::cdata($field->options) ?></options>
	45	+ <field_options><?php echo FrmXMLHelper::cdata($field->field_options) ?></field_options>
54	46	</field>
55	47	<?php } ?>
56	48	</form>
57	49	<?php
58		- unset( $fields );
59		- }//end foreach
60		-}//end while
	50	+ unset($fields);
	51	+}
	52	+}
	53	+?>