*/ class UsersWP_Form_Builder { public static function output( $tab = '' ) { global $current_tab; do_action( 'uwp_form_builder_start' ); // Get current tab/section if ( $tab ) { $current_tab = sanitize_title( $tab ); } else { $current_tab = empty( $_GET['tab'] ) ? 'account' : sanitize_title( $_GET['tab'] ); } $form = ''; if(isset($_GET['form']) && !empty($_GET['form'])){ $form = '&form='.(int) $_GET['form']; } // Get tabs for the form builder page $tabs = apply_filters( 'uwp_form_builder_tabs_array', array( 'account' => __( 'Account', 'userswp' ), 'register' => __( 'Register', 'userswp' ), ) ); ?>

> '; } elseif ( isset( $field['field_icon'] ) && $field['field_icon'] ) { echo ''; } else { echo ''; } echo ' ' . esc_attr($field['site_title']); if ( isset( $field['help_text'] ) && $field['help_text'] ) { echo uwp_help_tip( $field['help_text'] ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } ?>

$register_form ) { $form_ids[] = (int) $register_form['id']; } if ( isset( $form_ids ) && count( $form_ids ) > 0 ) { $form_ids_placeholder = array_fill( 0, count( $form_ids ), '%s' ); $form_ids_placeholder = implode( ', ', $form_ids_placeholder ); $query = "SELECT * FROM " . $table_name . " WHERE form_type = 'account' AND form_id IN (" . $form_ids_placeholder . ") ORDER BY sort_order ASC"; $custom_fields = $wpdb->get_results( $wpdb->prepare( $query, $form_ids ), $output ); } } $custom_fields = uwp_get_unique_custom_fields( $custom_fields ); return apply_filters( 'uwp_form_existing_fields', $custom_fields, $type ); } public function multiple_registration_form( $tab = '' ) { if ( empty( $tab ) || $tab == 'account' ) { $current_form = ! empty( $_GET['form'] ) ? (int) $_GET['form'] : 1; $register_tab = admin_url( 'admin.php?page=uwp_form_builder&tab=account' ); $register_forms = uwp_get_option( 'multiple_registration_forms' ); $user_roles = uwp_get_user_roles(); $current_role = get_option( 'default_role' ); $actions = uwp_get_registration_form_actions(); $current_action = uwp_get_option( 'uwp_registration_action', false ); $current_title = __( 'Form', 'userswp' ); $current_redirect_to = $current_custom_url = ''; $current_gdpr_page = $current_tos_page = - 1; if ( ! empty( $_GET['form_type'] ) && $_GET['form_type'] === 'new' ) { $new_added = ! empty( $register_forms ) ? end( $register_forms ) : array(); $current_form = ! empty( $new_added['id'] ) ? $new_added['id'] : 1; } ?>

	1 ) { ?>




	'gdpr_page', 'id' => 'multiple_registration_gdpr_page', 'sort_column' => 'menu_order', 'sort_order' => 'ASC', 'show_option_none' => ' ', 'class' => ' regular-text aui-select2 ', 'echo' => false, 'selected' => (int) $current_gdpr_page > 0 ? (int) $current_gdpr_page : - 1, ); echo str_replace( ' id=', " data-placeholder='" . esc_attr__( 'Select a page…', 'userswp' ) . "' id=", wp_dropdown_pages( $args ) ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>		'tos_page', 'id' => 'multiple_registration_tos_page', 'sort_column' => 'menu_order', 'sort_order' => 'ASC', 'show_option_none' => ' ', 'class' => ' regular-text aui-select2 ', 'echo' => false, 'selected' => (int) $current_tos_page > 0 ? (int) $current_tos_page : - 1, ); echo str_replace( ' id=', " data-placeholder='" . esc_attr__( 'Select a page…', 'userswp' ) . "' id=", wp_dropdown_pages( $args ) ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped ?>

0 ) { ?>


	`[uwp_register id="" title=""]`

custom_available_fields( 'predefined', $form_type ); break; } } public function custom_available_fields( $type, $form_type ) { ?> form_fields_predefined( $form_type ); } elseif ( $type == 'custom' ) { $fields = $this->form_fields_custom( $form_type ); } else { $fields = $this->form_fields( $form_type ); ?>

'; } elseif ( isset( $field['field_icon'] ) && $field['field_icon'] ) { echo ''; } else { echo ''; } echo ' ' . esc_attr($field['site_title']); if ( isset( $field['help_text'] ) && $field['help_text'] ) { echo uwp_help_tip( $field['help_text'] ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } ?>

'select', 'class' => 'uwp-country', 'field_icon' => 'fas fa-map-marker-alt', 'site_title' => __( 'Country', 'userswp' ), 'help_text' => __( 'Adds a input for Country field.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Country', 'site_title' => 'Country', 'htmlvar_name' => 'uwp_country', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'option_values' => '', 'required_msg' => '', 'field_icon' => 'fas fa-map-marker-alt', 'css_class' => '' ) ); // Gender $custom_fields['gender'] = array( 'field_type' => 'select', 'class' => 'uwp-gender', 'field_icon' => 'fas fa-user', 'site_title' => __( 'Gender', 'userswp' ), 'help_text' => __( 'Adds a input for Gender field.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Gender', 'site_title' => 'Gender', 'htmlvar_name' => 'gender', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'option_values' => __( 'Male,Female,Other', 'userswp' ), 'required_msg' => '', 'field_icon' => 'fas fa-user', 'css_class' => '' ) ); $custom_fields['dob'] = array( 'field_type' => 'datepicker', 'class' => 'uwp-dob', 'field_icon' => 'fas fa-birthday-cake', 'site_title' => __( 'Date of birth', 'userswp' ), 'help_text' => __( 'Adds a date input for users to enter their date of birth.', 'userswp' ), 'defaults' => array( 'data_type' => 'DATE', 'admin_title' => __( 'Date of birth', 'userswp' ), 'site_title' => __( 'Date of birth', 'userswp' ), 'form_label' => __( 'Enter your date of birth.', 'userswp' ), 'htmlvar_name' => 'dob', 'is_active' => true, 'for_admin_use' => false, 'default_value' => '', 'is_required' => false, 'validation_pattern' => '', 'validation_msg' => '', 'required_msg' => '', 'field_icon' => 'fas fa-birthday-cake', 'css_class' => '', 'extra_fields' => array( 'date_range' => 'c-100:c+0' ) ) ); // Mobile $custom_fields['mobile'] = array( 'field_type' => 'phone', 'class' => 'uwp-mobile', 'field_icon' => 'fas fa-mobile-alt', 'site_title' => __( 'Mobile', 'userswp' ), 'help_text' => __( 'Adds a input for Mobile field.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Mobile', 'site_title' => 'Mobile', 'htmlvar_name' => 'mobile', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fas fa-mobile-alt', 'css_class' => '' ) ); $custom_fields['register_gdpr'] = array( 'field_type' => 'checkbox', 'class' => 'uwp-register-gdpr', 'field_icon' => 'fas fa-file', 'site_title' => __( 'GDPR Policy Page', 'userswp' ), 'help_text' => __( 'Adds Register GDPR page.', 'userswp' ), 'defaults' => array( 'admin_title' => 'GDPR Policy', 'site_title' => 'GDPR Policy', 'form_label' => __( 'GDPR Policy', 'userswp' ), 'htmlvar_name' => 'register_gdpr', 'is_active' => 1, 'default_value' => '', 'is_required' => 1, 'required_msg' => '', 'field_icon' => 'fas fa-file', 'css_class' => 'btn-register-gdpr' ) ); $custom_fields['register_tos'] = array( 'field_type' => 'checkbox', 'class' => 'uwp-register-tos', 'field_icon' => 'fas fa-file', 'site_title' => __( 'Terms & Conditions', 'userswp' ), 'help_text' => __( 'Adds Register TOS page.', 'userswp' ), 'help_text_tip' => __( 'This will show next to the checkbox, to add a link to the TOS page, use format: %%link_start%% View TOS %%link_end%%', 'userswp' ), 'defaults' => array( 'admin_title' => 'Terms & Conditions', 'site_title' => 'Terms & Conditions', 'form_label' => __( 'Terms & Conditions', 'userswp' ), 'htmlvar_name' => 'register_tos', 'is_active' => 1, 'default_value' => '', 'is_required' => 1, 'required_msg' => '', 'field_icon' => 'fas fa-file', 'css_class' => 'btn-register-tos', ) ); // Website $custom_fields['user_url'] = array( 'field_type' => 'url', 'class' => 'uwp-website', 'field_icon' => 'fas fa-link', 'site_title' => __( 'Website', 'userswp' ), 'help_text' => __( 'Let users enter their website url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Website', 'site_title' => 'Website', 'form_label' => __( 'Website', 'userswp' ), 'htmlvar_name' => 'user_url', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fas fa-link', 'css_class' => 'btn-website' ) ); // Facebook $custom_fields['facebook'] = array( 'field_type' => 'url', 'class' => 'uwp-facebook', 'field_icon' => 'fab fa-facebook-square', 'site_title' => __( 'Facebook', 'userswp' ), 'help_text' => __( 'Let users enter their facebook url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Facebook', 'site_title' => 'Facebook', 'form_label' => __( 'Facebook url', 'userswp' ), 'htmlvar_name' => 'facebook', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-facebook-f', 'css_class' => 'btn-facebook' ) ); // Twitter $custom_fields['twitter'] = array( 'field_type' => 'url', 'class' => 'uwp-twitter', 'field_icon' => 'fab fa-twitter-square', 'site_title' => __( 'Twitter', 'userswp' ), 'help_text' => __( 'Let users enter their twitter url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Twitter', 'site_title' => 'Twitter', 'form_label' => __( 'Twitter url', 'userswp' ), 'htmlvar_name' => 'twitter', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-twitter', 'css_class' => 'btn-twitter' ) ); // Instagram $custom_fields['instagram'] = array( 'field_type' => 'url', 'class' => 'uwp-instagram', 'field_icon' => 'fab fa-instagram', 'site_title' => __( 'Instagram', 'userswp' ), 'help_text' => __( 'Let users enter their instagram url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Instagram', 'site_title' => 'Instagram', 'form_label' => __( 'Instagram url', 'userswp' ), 'htmlvar_name' => 'instagram', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-instagram', 'css_class' => 'btn-instagram' ) ); // Linkedin $custom_fields['linkedin'] = array( 'field_type' => 'url', 'class' => 'uwp-linkedin', 'field_icon' => 'fab fa-linkedin', 'site_title' => __( 'Linkedin', 'userswp' ), 'help_text' => __( 'Let users enter their linkedin url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Linkedin', 'site_title' => 'Linkedin', 'form_label' => __( 'Linkedin url', 'userswp' ), 'htmlvar_name' => 'linkedin', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-linkedin-in', 'css_class' => 'btn-linkedin' ) ); // Flickr $custom_fields['flickr'] = array( 'field_type' => 'url', 'class' => 'uwp-flickr', 'field_icon' => 'fab fa-flickr', 'site_title' => __( 'Flickr', 'userswp' ), 'help_text' => __( 'Let users enter their Flickr url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Flickr', 'site_title' => 'Flickr', 'form_label' => __( 'Flickr url', 'userswp' ), 'htmlvar_name' => 'flickr', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-flickr', 'css_class' => 'btn-flickr' ) ); // GitHub $custom_fields['github'] = array( 'field_type' => 'url', 'class' => 'uwp-github', 'field_icon' => 'fab fa-github-square', 'site_title' => __( 'GitHub', 'userswp' ), 'help_text' => __( 'Let users enter their GitHub url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'GitHub', 'site_title' => 'GitHub', 'form_label' => __( 'GitHub url', 'userswp' ), 'htmlvar_name' => 'github', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-github-alt', 'css_class' => 'btn-github' ) ); // YouTube $custom_fields['youtube'] = array( 'field_type' => 'url', 'class' => 'uwp-youtube', 'field_icon' => 'fab fa-youtube-square', 'site_title' => __( 'YouTube', 'userswp' ), 'help_text' => __( 'Let users enter their YouTube url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'YouTube', 'site_title' => 'YouTube', 'form_label' => __( 'YouTube url', 'userswp' ), 'htmlvar_name' => 'youtube', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-youtube', 'css_class' => 'btn-youtube' ) ); // WordPress $custom_fields['wordpress'] = array( 'field_type' => 'url', 'class' => 'uwp-wordpress', 'field_icon' => 'fab fa-wordpress-simple', 'site_title' => __( 'WordPress', 'userswp' ), 'help_text' => __( 'Let users enter their WordPress profile url.', 'userswp' ), 'defaults' => array( 'admin_title' => 'WordPress', 'site_title' => 'WordPress', 'form_label' => __( 'WordPress url', 'userswp' ), 'htmlvar_name' => 'wordpress', 'is_active' => 1, 'default_value' => '', 'is_required' => 0, 'required_msg' => '', 'field_icon' => 'fab fa-wordpress-simple', 'css_class' => 'btn-wordpress' ) ); // Language $custom_fields['uwp_language'] = array( 'field_type' => 'select', 'class' => 'uwp-language', 'field_icon' => 'fas fa-language', 'site_title' => __( 'Select Language', 'userswp' ), 'help_text' => __( 'Adds a input for user language selection.', 'userswp' ), 'defaults' => array( 'admin_title' => 'Select Language', 'site_title' => 'Select Language', 'form_label' => __( 'Site Language', 'userswp' ), 'htmlvar_name' => 'uwp_language', 'is_active' => 1, 'default_value' => 'site-default', 'is_required' => 0, 'option_values' => '', 'required_msg' => '', 'field_icon' => 'fas fa-language', 'css_class' => '' ) ); return apply_filters( 'uwp_form_fields_predefined', $custom_fields, $type ); } public function form_fields_custom( $type = '' ) { $custom_fields = array(); return apply_filters( 'uwp_form_fields_custom', $custom_fields, $type ); } public function form_fields( $type = '' ) { $custom_fields = array( 'text' => array( 'field_type' => 'text', 'class' => 'uwp-text', 'field_icon' => 'fas fa-minus', 'site_title' => __( 'Text', 'userswp' ), 'help_text' => __( 'Add any sort of text field, text or numbers', 'userswp' ) ), 'datepicker' => array( 'field_type' => 'datepicker', 'class' => 'uwp-datepicker', 'field_icon' => 'fas fa-calendar-alt', 'site_title' => __( 'Date', 'userswp' ), 'help_text' => __( 'Adds a date picker.', 'userswp' ) ), 'textarea' => array( 'field_type' => 'textarea', 'class' => 'uwp-textarea', 'field_icon' => 'fas fa-bars', 'site_title' => __( 'Textarea', 'userswp' ), 'help_text' => __( 'Adds a textarea', 'userswp' ) ), 'time' => array( 'field_type' => 'time', 'class' => 'uwp-time', 'field_icon' => 'far fa-clock', 'site_title' => __( 'Time', 'userswp' ), 'help_text' => __( 'Adds a time picker', 'userswp' ) ), 'checkbox' => array( 'field_type' => 'checkbox', 'class' => 'uwp-checkbox', 'field_icon' => 'far fa-check-square', 'site_title' => __( 'Checkbox', 'userswp' ), 'help_text' => __( 'Adds a checkbox', 'userswp' ) ), 'phone' => array( 'field_type' => 'phone', 'class' => 'uwp-phone', 'field_icon' => 'fas fa-phone', 'site_title' => __( 'Phone', 'userswp' ), 'help_text' => __( 'Adds a phone input', 'userswp' ) ), 'radio' => array( 'field_type' => 'radio', 'class' => 'uwp-radio', 'field_icon' => 'far fa-dot-circle', 'site_title' => __( 'Radio', 'userswp' ), 'help_text' => __( 'Adds a radio input', 'userswp' ) ), 'email' => array( 'field_type' => 'email', 'class' => 'uwp-email', 'field_icon' => 'far fa-envelope', 'site_title' => __( 'Email', 'userswp' ), 'help_text' => __( 'Adds a email input', 'userswp' ) ), 'select' => array( 'field_type' => 'select', 'field_icon' => 'far fa-caret-square-down', 'site_title' => __( 'Select', 'userswp' ), 'help_text' => __( 'Adds a select input', 'userswp' ) ), 'multiselect' => array( 'field_type' => 'multiselect', 'class' => 'uwp-multiselect', 'field_icon' => 'far fa-caret-square-down', 'site_title' => __( 'Multi Select', 'userswp' ), 'help_text' => __( 'Adds a multiselect input', 'userswp' ) ), 'url' => array( 'field_type' => 'url', 'class' => 'uwp-url', 'field_icon' => 'fas fa-link', 'site_title' => __( 'URL', 'userswp' ), 'help_text' => __( 'Adds a url input', 'userswp' ) ), 'editor' => array( 'field_type' => 'editor', 'class' => 'uwp-html', 'field_icon' => 'fas fa-code', 'site_title' => __( 'HTML', 'userswp' ), 'help_text' => __( 'Adds a wysiwyg editor input', 'userswp' ) ), 'file' => array( 'field_type' => 'file', 'class' => 'uwp-file', 'field_icon' => 'fas fa-file', 'site_title' => __( 'File Upload', 'userswp' ), 'help_text' => __( 'Adds a file input', 'userswp' ) ) ); return apply_filters( 'uwp_form_fields', $custom_fields, $type ); } public function manage_available_fields_custom( $form_type ) { switch ( $form_type ) { case 'account': $this->custom_available_fields( 'custom', $form_type ); break; } } public function manage_available_fields( $form_type ) { switch ( $form_type ) { case 'account': $this->custom_available_fields( '', $form_type ); break; case 'register': $this->register_available_fields( $form_type ); break; } } public function register_available_fields( $form_type ) { global $wpdb; $form_id = ! empty( $_GET['form'] ) ? absint($_GET['form']) : 1; $extras_table_name = uwp_get_table_prefix() . 'uwp_form_extras'; $existing_fields = $wpdb->get_results( "select site_htmlvar_name from " . $extras_table_name . " where form_type ='" . $form_type . "' AND form_id = " . $form_id ); $existing_field_ids = array(); if ( ! empty( $existing_fields ) ) { foreach ( $existing_fields as $existing_field ) { $existing_field_ids[] = $existing_field->site_htmlvar_name; } } ?>

> '; } ?>

get_results( $wpdb->prepare( "select field_type, site_title, htmlvar_name, field_icon from " . $table_name . " where form_type = %s and is_register_field = %s and form_id = %d order by sort_order asc", array( 'account', '1', $form_id ) ), ARRAY_A ); return apply_filters( 'uwp_register_fields', $fields, $form_type ); } public function manage_selected_fields( $form_type ) { switch ( $form_type ) { case 'account': $this->custom_selected_fields( $form_type ); break; case 'register': $this->register_selected_fields( $form_type ); break; } } public function custom_selected_fields( $form_type ) { global $wpdb; $table_name = uwp_get_table_prefix() . 'uwp_form_fields'; $form_id = ! empty( $_GET['form'] ) ? absint($_GET['form']) : 1; ?>

get_results( $wpdb->prepare( "SELECT * FROM " . $table_name . " WHERE form_type = %s AND form_id = %s ORDER BY sort_order ASC", array( $form_type, $form_id ) ) ); if ( ! empty( $fields ) ) { foreach ( $fields as $field ) { $result_str = $field; $field_type = $field->field_type; $field_type_key = $field->field_type_key; $field_ins_upd = 'display'; $this->form_field_adminhtml( $field_type, $result_str, $field_ins_upd, $field_type_key ); } } ?> get_form_existing_fields( $form_type ); if ( ! is_object( $cf ) ) { $field_info = $wpdb->get_row( $wpdb->prepare( "select * from " . $table_name . " where id= %d", array( $cf ) ) ); } else { $field_info = $cf; $result_str = $cf->id; } if ( ! $field_info ) { $field_info = ( isset( $cf_arr[ $field_type_key ] ) ) ? $cf_arr[ $field_type_key ] : null; } $this->admin_form_field_html( $field_info, $field_type, $field_type_key, $field_ins_upd, $result_str, $form_type ); } /** * @param $field_info * @param $field_type * @param string $field_type_key * @param string $field_ins_upd * @param $result_str * @param bool $form_type */ public function admin_form_field_html( $field_info, $field_type, $field_type_key, $field_ins_upd, $result_str, $form_type = false ) { if ( ! $form_type ) { if ( ! isset( $field_info->form_type ) ) { $form_type = sanitize_text_field( $_REQUEST['tab'] ); } else { $form_type = $field_info->form_type; } } $cf_arr1 = $this->form_fields( $form_type ); $cf_arr2 = $this->form_fields_predefined( $form_type ); $cf_arr3 = $this->form_fields_custom( $form_type ); $cf_arr = $cf_arr1 + $cf_arr2 + $cf_arr3; // this way defaults can't be overwritten $cf = ( isset( $cf_arr[ $field_type_key ] ) ) ? $cf_arr[ $field_type_key ] : ''; $field_info = stripslashes_deep( $field_info ); // strip slashes from labels $field_site_title = ''; if ( isset( $field_info->site_title ) ) { $field_site_title = $field_info->site_title; } $field_display = $field_type == 'address' && $field_info->htmlvar_name == 'post' ? 'style="display:none"' : ''; if ( isset( $cf['field_icon'] ) && strpos( $cf['field_icon'], ' fa-' ) !== false ) { $field_icon = ''; } elseif ( isset( $cf['field_icon'] ) && $cf['field_icon'] ) { $field_icon = ''; } else { $field_icon = ''; } if ( isset( $cf['site_title'] ) && $cf['site_title'] ) { $field_type_name = $cf['site_title']; } else { $field_type_name = $field_type; } $htmlvar_name = isset($field_info->htmlvar_name) ? sanitize_text_field($field_info->htmlvar_name) : ''; ?>

/>
class="uwp-setting-name">
/>
class="uwp-setting-name uwp-advanced-setting">
/>
class="uwp-setting-name uwp-advanced-setting">

/>
is_required ) && $field_info->is_required == '0' ) || ! isset( $field_info->is_required ) ) { echo "style='display:none;'"; } ?>>
', '' ) ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped esc_html_e( 'Upload icon :', 'userswp' ); ?>
css_class ) ) { $value = esc_attr( $field_info->css_class ); } elseif ( isset( $cf['defaults']['css_class'] ) && $cf['defaults']['css_class'] ) { $value = $cf['defaults']['css_class']; } $tip = __( 'Enter custom css class for field custom style.', 'userswp' ); if ( $field_type == 'multiselect' ) { $tip .= __( '(Enter class `uwp-comma-list` to show list as comma separated)', 'userswp' ); } ?>

validation_pattern ) ) { $value = esc_attr( $field_info->validation_pattern ); } elseif ( isset( $cf['defaults']['validation_pattern'] ) && $cf['defaults']['validation_pattern'] ) { $value = $cf['defaults']['validation_pattern']; } ?>

validation_msg ) ) { $value = esc_attr( $field_info->validation_msg ); } elseif ( isset( $cf['defaults']['validation_msg'] ) && $cf['defaults']['validation_msg'] ) { $value = $cf['defaults']['validation_msg']; } ?>

get_results( $wpdb->prepare( "select * from " . $extras_table_name . " where form_type = %s AND form_id = %d order by sort_order asc", array( $form_type, $form_id ) ) ); if ( ! empty( $fields ) ) { foreach ( $fields as $field ) { $result_str = $field; $field_ins_upd = 'display'; $this->register_field_adminhtml( $result_str, $field_ins_upd, false ); } } ?> get_row( $wpdb->prepare( "select * from " . $extras_table_name . " where id= %d", array( $cf ) ) ); } elseif ( is_object( $cf ) ) { $result_str = $cf->id; $field_info = $wpdb->get_row( $wpdb->prepare( "select * from " . $extras_table_name . " where id= %d", array( (int) $cf->id ) ) ); } else { $field_info = false; } if ( isset( $request['field_type'] ) && $request['field_type'] != '' ) { $field_type = esc_attr( $request['field_type'] ); } else { $field_type = $field_info->field_type; } $field_site_name = ''; if ( isset( $request['site_title'] ) ) { $field_site_name = $request['site_title']; } if ( $field_info ) { $account_field_info = uwp_get_custom_field_info( $field_info->site_htmlvar_name ); if ( isset( $account_field_info->site_title ) ) { if ( $account_field_info->field_type == 'fieldset' ) { $field_site_name = __( 'Fieldset:', 'userswp' ) . ' ' . $account_field_info->site_title; } else { $field_site_name = $account_field_info->site_title; } } $field_info = stripslashes_deep( $field_info ); // strip slashes } $field_site_name = sanitize_title( $field_site_name ); if ( isset( $request['form_type'] ) ) { $form_type = esc_attr( $request['form_type'] ); } else { $form_type = $field_info->form_type; } if ( isset( $request['htmlvar_name'] ) && $request['htmlvar_name'] != '' ) { $htmlvar_name = esc_attr( $request['htmlvar_name'] ); } else { $htmlvar_name = $field_info->site_htmlvar_name; } if ( isset( $htmlvar_name ) ) { if ( ! is_object( $field_info ) ) { $field_info = new stdClass(); } $field_info->field_icon = $wpdb->get_var( $wpdb->prepare( "SELECT field_icon FROM " . $table_name . " WHERE htmlvar_name = %s", array( $htmlvar_name ) ) ); } $icon = isset( $field_info->field_icon ) ? $field_info->field_icon : ''; if ( uwp_is_fa_icon( $icon ) ) { $field_icon = ''; } elseif ( uwp_is_icon_url( $icon ) ) { $field_icon = ''; } elseif ( isset( $field_info->field_type ) && $field_info->field_type == 'fieldset' ) { $field_icon = ''; } else { $field_icon = ''; } ?>

option_values ) ) { $value = esc_attr( $field_info->option_values ); } elseif ( isset( $cf['defaults']['option_values'] ) && $cf['defaults']['option_values'] ) { $value = esc_attr( $cf['defaults']['option_values'] ); } $field_type = isset( $field_info->field_type ) ? $field_info->field_type : $cf['field_type']; $field_type_key = isset( $field_info->field_type_key ) ? $field_info->field_type_key : ''; if ( ! $field_type_key ) { $field_type_key = isset( $_REQUEST['field_type_key'] ) ? esc_html( $_REQUEST['field_type_key'] ) : ''; } ?>

extra_fields ) && $field_info->extra_fields != '' ) { $extra = unserialize( $field_info->extra_fields ); } ?>

extra_fields ) && $field_info->extra_fields != '' ) { $extra = unserialize( $field_info->extra_fields ); } $value = isset( $extra['confirm_password'] ) ? $extra['confirm_password'] : '1'; if ( isset( $field_info->htmlvar_name ) && $field_info->htmlvar_name == 'password' ) { ?>

onclick=""/>

extra_fields ) && $field_info->extra_fields != '' ) { $extra = unserialize( $field_info->extra_fields ); } $value = isset( $extra['confirm_email'] ) ? $extra['confirm_email'] : '0'; if ( isset( $field_info->htmlvar_name ) && $field_info->htmlvar_name == 'email' ) { ?>

onclick=""/>

allowed_mime_types(); $extra_fields = isset( $field_info->extra_fields ) && $field_info->extra_fields != '' ? maybe_unserialize( $field_info->extra_fields ) : ''; $uwp_file_types = ! empty( $extra_fields ) && ! empty( $extra_fields['uwp_file_types'] ) ? $extra_fields['uwp_file_types'] : array( '*' ); ?>

data_type ) ) { $dt_value = esc_attr( $field_info->data_type ); } elseif ( isset( $cf['defaults']['data_type'] ) && $cf['defaults']['data_type'] ) { $dt_value = $cf['defaults']['data_type']; } ?>

decimal_point ) ) { $value = esc_attr( $field_info->decimal_point ); } elseif ( isset( $cf['defaults']['decimal_point'] ) && $cf['defaults']['decimal_point'] ) { $value = $cf['defaults']['decimal_point']; } ?> for_admin_use ) && $field_info->for_admin_use == '1' ) ? "style='display:none;'" : $hide_register_field; $hide_user_sort = ( isset( $cf['defaults']['user_sort'] ) && $cf['defaults']['user_sort'] === false ) ? "style='display:none;'" : ''; $value = 0; if ( isset( $field_info->is_register_field ) ) { $value = (int) $field_info->is_register_field; } else if ( isset( $cf['defaults']['is_register_field'] ) && $cf['defaults']['is_register_field'] ) { $value = ( $cf['defaults']['is_register_field'] ) ? 1 : 0; } if ( isset( $field_info->htmlvar_name ) ) { $htmlvar_name = $field_info->htmlvar_name; } else if ( isset( $cf['defaults']['htmlvar_name'] ) && $cf['defaults']['htmlvar_name'] ) { $htmlvar_name = ( $cf['defaults']['htmlvar_name'] ) ? $cf['defaults']['htmlvar_name'] : ''; } //register only field $hide_register_only_field = ( isset( $cf['defaults']['is_register_only_field'] ) && $cf['defaults']['is_register_only_field'] === false ) ? "style='display:none;'" : ''; $hide_register_only_field = ( isset( $field_info->for_admin_use ) && $field_info->for_admin_use == '1' ) ? "style='display:none;'" : $hide_register_only_field; $register_only_value = 0; if ( isset( $field_info->is_register_only_field ) ) { $register_only_value = (int) $field_info->is_register_only_field; } else if ( isset( $cf['defaults']['is_register_only_field'] ) && $cf['defaults']['is_register_only_field'] ) { $register_only_value = ( $cf['defaults']['is_register_only_field'] ) ? 1 : 0; } $user_sort_value = 0; if ( isset( $field_info->user_sort ) ) { $user_sort_value = (int) $field_info->user_sort; } else if ( isset( $cf['defaults']['user_sort'] ) && $cf['defaults']['user_sort'] ) { $user_sort_value = ( $cf['defaults']['user_sort'] ) ? 1 : 0; } ?>

class="cf-incin-reg-form uwp-setting-name">

/>

class="cf-inconlyin-reg-form uwp-setting-name uwp-advanced-setting">

/>

class="cf-incin-reg-form uwp-setting-name uwp-advanced-setting"> />

set_field_order( $field_ids, $form_id ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } /* ---- Show field form in admin ---- */ if ( $field_type != '' && $field_id != '' && $field_action == 'new' && isset( $_REQUEST['create_field'] ) && isset( $_REQUEST['manage_field_type'] ) && $_REQUEST['manage_field_type'] == 'custom_fields' ) { $this->form_field_adminhtml( $field_type, $field_id, $field_action, $field_type_key, $form_type ); } /* ---- Delete field ---- */ if ( $field_id != '' && $field_action == 'delete' && isset( $_REQUEST['_wpnonce'] ) && isset( $_REQUEST['create_field'] ) && isset( $_REQUEST['manage_field_type'] ) && $_REQUEST['manage_field_type'] == 'custom_fields' ) { if ( ! wp_verify_nonce( $_REQUEST['_wpnonce'], 'custom_fields_delete_' . $field_id ) ) { return; } echo $this->admin_form_field_delete( $field_id, true, $form_id ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } /* ---- Save field ---- */ if ( $field_id != '' && $field_action == 'submit' && isset( $_REQUEST['_wpnonce'] ) && isset( $_REQUEST['create_field'] ) && isset( $_REQUEST['manage_field_type'] ) && $_REQUEST['manage_field_type'] == 'custom_fields' ) { if ( ! wp_verify_nonce( $_REQUEST['_wpnonce'], 'custom_fields_' . $field_id ) ) { return; } foreach ( $_REQUEST as $pkey => $pval ) { if ( isset( $_REQUEST[ $pkey ] ) && is_array( $_REQUEST[ $pkey ] ) ) { $tags = 'skip_field'; } else { $tags = ''; } if ( $tags != 'skip_field' ) { $_REQUEST[ $pkey ] = strip_tags( $_REQUEST[ $pkey ], $tags ); } } $return = $this->admin_form_field_save( $_REQUEST ); if ( is_int( $return ) ) { $lastid = $return; $this->form_field_adminhtml( $field_type, $lastid, 'submit', $field_type_key, $form_type ); } else { echo $return; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } } wp_die(); } public function set_field_order( $field_ids = array(), $form_id = 1 ) { global $wpdb; $table_name = uwp_get_table_prefix() . 'uwp_form_fields'; $count = 0; if ( ! empty( $field_ids ) ): $user_meta_info = false; foreach ( $field_ids as $id ) { $cf = trim( $id, '_' ); $user_meta_info = $wpdb->query( $wpdb->prepare( "update " . $table_name . " set sort_order=%d where id= %d and form_id = %d", array( $count, $cf, $form_id ) ) ); $count ++; } return $user_meta_info; else: return false; endif; } public function admin_form_field_delete( $field_id = '', $delete_meta = true, $form_id = 1 ) { global $wpdb; $table_name = uwp_get_table_prefix() . 'uwp_form_fields'; $extras_table_name = uwp_get_table_prefix() . 'uwp_form_extras'; $meta_table = get_usermeta_table_prefix() . 'uwp_usermeta'; if ( $field_id != '' ) { $cf = trim( $field_id, '_' ); if ( $field = $wpdb->get_row( $wpdb->prepare( "select id, htmlvar_name from " . $table_name . " where id= %d AND form_id = %d", array( $cf, $form_id ) ) ) ) { $excluded_delete = array('username', 'email'); if(isset($field->htmlvar_name) && in_array($field->htmlvar_name, $excluded_delete)){ return $field_id; } $wpdb->query( $wpdb->prepare( "delete from " . $table_name . " where id= %d AND form_id = %d", array( $cf, $form_id ) ) ); // Also delete register form field $wpdb->query( $wpdb->prepare( "delete from " . $extras_table_name . " where site_htmlvar_name= %s AND form_id = %d ", array( $field->htmlvar_name, $form_id ) ) ); // delete the meta column if ( isset($field->htmlvar_name) && $delete_meta ) { $register_forms = uwp_get_option( 'multiple_registration_forms' ); $custom_fields = array(); if ( ! empty( $register_forms ) && is_array( $register_forms ) ) { foreach ( $register_forms as $key => $register_form ) { $form_ids[] = (int) $register_form['id']; } if ( isset( $form_ids ) && count( $form_ids ) > 0 ) { $form_ids_placeholder = array_fill( 0, count( $form_ids ), '%d' ); $form_ids_placeholder = implode( ', ', $form_ids_placeholder ); $query = $wpdb->prepare("SELECT id FROM " . $table_name . " WHERE form_type = 'account' AND htmlvar_name = '".$field->htmlvar_name."' AND form_id IN (" . $form_ids_placeholder . ") ORDER BY sort_order ASC", $form_ids); $custom_fields = $wpdb->get_results( $query); } } if(isset($custom_fields) && !empty($custom_fields) && count($custom_fields) > 0){ // Do not delete user meta column if field used in more than one form. } else { $col_name = sanitize_sql_orderby( $field->htmlvar_name ); $wpdb->query( "ALTER TABLE `{$meta_table}` DROP COLUMN $col_name" ); } } do_action( 'uwp_after_custom_field_deleted', $cf, $field ); return $field_id; } else { return 0; } } else { return 0; } } public function admin_form_field_save( $request_field = array() ) { global $wpdb;$wpdb->show_errors(); $table_name = uwp_get_table_prefix() . 'uwp_form_fields'; $meta_table = get_usermeta_table_prefix() . 'uwp_usermeta'; $old_html_variable = ''; $result_str = isset( $request_field['field_id'] ) ? trim( $request_field['field_id'] ) : ''; $form_id = isset( $request_field['form_id'] ) ? (int) $request_field['form_id'] : 1; $user_meta_info = null; // some servers fail if a POST value is VARCHAR so we change it. if ( isset( $request_field['data_type'] ) && $request_field['data_type'] == 'XVARCHAR' ) { $request_field['data_type'] = 'VARCHAR'; } $cf = trim( $result_str, '_' ); $cehhtmlvar_name = isset( $request_field['htmlvar_name'] ) ? $request_field['htmlvar_name'] : ''; $form_type = $request_field['form_type']; $old_html_variable_name = 'uwp_account_' . $cehhtmlvar_name; $check_old_html_variable = $wpdb->get_var( $wpdb->prepare( "select htmlvar_name from " . $table_name . " where id <> %d and htmlvar_name = %s and form_type = %s and form_id = %d", array( $cf, $old_html_variable_name, $form_type, $form_id ) ) ); $check_html_variable = $wpdb->get_var( $wpdb->prepare( "select htmlvar_name from " . $table_name . " where id <> %d and htmlvar_name = %s and form_type = %s and form_id = %d", array( $cf, $cehhtmlvar_name, $form_type, $form_id ) ) ); if ( ( ! $check_old_html_variable && ! $check_html_variable ) || $request_field['field_type'] == 'fieldset' ) { if ( $cf != '' ) { $user_meta_info = $wpdb->get_row( $wpdb->prepare( "select * from " . $table_name . " where id = %d", array( $cf ) ) ); } if ( ! empty( $user_meta_info ) ) { $old_html_variable = $user_meta_info->htmlvar_name; } $site_title = sanitize_text_field( $request_field['site_title'] ); $form_label = isset( $request_field['form_label'] ) ? sanitize_text_field( $request_field['form_label'] ) : ''; $help_text = isset( $request_field['help_text'] ) ? sanitize_text_field( $request_field['help_text'] ) : ''; $field_type = sanitize_text_field( $request_field['field_type'] ); $data_type = sanitize_text_field( $request_field['data_type'] ); $field_type_key = isset( $request_field['field_type_key'] ) ? sanitize_text_field( $request_field['field_type_key'] ) : $field_type; $htmlvar_name = isset( $request_field['htmlvar_name'] ) ? str_replace( array( '-', ' ', '"', "'" ), array( '_', '', '', '' ), sanitize_title_with_dashes( $request_field['htmlvar_name'] ) ) : null; $default_value = isset( $request_field['default_value'] ) ? sanitize_text_field( $request_field['default_value'] ) : ''; $sort_order = isset( $request_field['sort_order'] ) ? absint( $request_field['sort_order'] ) : ''; $is_active = isset( $request_field['is_active'] ) ? absint( $request_field['is_active'] ) : 1; $placeholder_value = isset( $request_field['placeholder_value'] ) ? $request_field['placeholder_value'] : ''; $for_admin_use = isset( $request_field['for_admin_use'] ) ? absint( $request_field['for_admin_use'] ) : 0; $is_required = isset( $request_field['is_required'] ) ? absint( $request_field['is_required'] ) : 0; $is_dummy = isset( $request_field['is_dummy'] ) ? absint( $request_field['is_dummy'] ) : 0; $is_public = isset( $request_field['is_public'] ) ? absint( $request_field['is_public'] ) : 0; $is_default = isset( $request_field['is_default'] ) ? absint( $request_field['is_default'] ) : 0; $is_register_field = isset( $request_field['is_register_field'] ) ? absint( $request_field['is_register_field'] ) : 0; $is_search_field = isset( $request_field['is_search_field'] ) ? absint( $request_field['is_search_field'] ) : 0; $is_register_only_field = isset( $request_field['is_register_only_field'] ) ? absint( $request_field['is_register_only_field'] ) : 0; $required_msg = isset( $request_field['required_msg'] ) ? sanitize_text_field( $request_field['required_msg'] ) : ''; $css_class = isset( $request_field['css_class'] ) ? sanitize_text_field( $request_field['css_class'] ) : ''; $field_icon = isset( $request_field['field_icon'] ) ? sanitize_text_field( $request_field['field_icon'] ) : ''; $show_in = isset( $request_field['show_in'] ) ? $request_field['show_in'] : ''; $user_roles = isset( $request_field['user_roles'] ) ? $request_field['user_roles'] : ''; $decimal_point = isset( $request_field['decimal_point'] ) ? absint( $request_field['decimal_point'] ) : ''; // decimal point for DECIMAL data type $decimal_point = $decimal_point > 0 ? ( $decimal_point > 10 ? 10 : $decimal_point ) : ''; $validation_pattern = isset( $request_field['validation_pattern'] ) ? sanitize_text_field( $request_field['validation_pattern'] ) : ''; $validation_msg = isset( $request_field['validation_msg'] ) ? sanitize_text_field( $request_field['validation_msg'] ) : ''; $user_sort = isset( $request_field['user_sort'] ) ? absint( $request_field['user_sort'] ) : 0; if ( empty( $htmlvar_name ) ) { $htmlvar_name = sanitize_key( str_replace( array( '-', ' ', '"', "'" ), array( '_', '_', '', '' ), $request_field['site_title'] ) ); if ( str_replace( '_', '', $htmlvar_name ) != '' ) { $htmlvar_name = substr( $htmlvar_name, 0, 50 ); } else { $htmlvar_name = time(); } } if ( is_array( $show_in ) ) { $show_in = implode( ",", $request_field['show_in'] ); $show_in = sanitize_text_field( $show_in ); } if ( is_array( $user_roles ) ) { $user_roles = implode( ",", $request_field['user_roles'] ); $user_roles = sanitize_text_field( $user_roles ); } $option_values = ''; if ( isset( $request_field['option_values'] ) ) { $option_values = $request_field['option_values']; } if ( isset( $request_field['extra'] ) && ! empty( $request_field['extra'] ) ) { $extra_fields = $request_field['extra']; } if ( $sort_order == '' ) { $last_order = $wpdb->get_var( "SELECT MAX(sort_order) as last_order FROM " . $table_name ); $sort_order = (int) $last_order + 1; } if ( ! empty( $user_meta_info ) ) { $excluded = uwp_get_excluded_fields(); if ( ! in_array( $htmlvar_name, $excluded ) ) { // Create custom columns switch ( $field_type ): case 'checkbox': case 'multiselect': case 'select': $op_size = '500'; // only make the field as big as it needs to be. if ( isset( $option_values ) && $option_values && $field_type == 'select' ) { $option_values_arr = explode( ',', $option_values ); if ( isset( $option_values_arr ) && is_array( $option_values_arr ) ) { $op_max = 0; foreach ( $option_values_arr as $op_val ) { if ( strlen( $op_val ) && strlen( $op_val ) > $op_max ) { $op_max = strlen( $op_val ); } } if ( $op_max ) { $op_size = $op_max; } } } elseif ( isset( $option_values ) && $option_values && $field_type == 'multiselect' ) { if ( strlen( $option_values ) ) { $op_size = strlen( $option_values ); } } $meta_field_add = "ALTER TABLE " . $meta_table . " CHANGE `" . $old_html_variable . "` `" . $htmlvar_name . "`VARCHAR( $op_size ) NULL"; if ( $default_value != '' ) { $meta_field_add .= " DEFAULT '" . $default_value . "'"; } $alter_result = $wpdb->query( $meta_field_add ); if ( $alter_result === false ) { return __( 'Column change failed, you may have too many columns.', 'userswp' ); } if ( isset( $request_field['cat_display_type'] ) ) { $extra_fields = $request_field['cat_display_type']; } if ( isset( $request_field['multi_display_type'] ) ) { $extra_fields = $request_field['multi_display_type']; } break; case 'textarea': case 'editor': case 'url': case 'file': $alter_result = $wpdb->query( "ALTER TABLE " . $meta_table . " CHANGE `" . $old_html_variable . "` `" . $htmlvar_name . "` TEXT NULL" ); if ( $alter_result === false ) { return __( 'Column change failed, you may have too many columns.', 'userswp' ); } if ( isset( $request_field['advanced_editor'] ) ) { $extra_fields = $request_field['advanced_editor']; } break; case 'fieldset': // Nothing happened for fieldset break; default: if ( $data_type != 'VARCHAR' && $data_type != '' ) { if ( $data_type == 'FLOAT' && $decimal_point > 0 ) { $default_value_add = "ALTER TABLE " . $meta_table . " CHANGE `" . $old_html_variable . "` `" . $htmlvar_name . "` DECIMAL(11, " . (int) $decimal_point . ") NULL"; } else { $default_value_add = "ALTER TABLE " . $meta_table . " CHANGE `" . $old_html_variable . "` `" . $htmlvar_name . "` " . $data_type . " NULL"; } if ( is_numeric( $default_value ) && $default_value != '' ) { $default_value_add .= " DEFAULT '" . $default_value . "'"; } } else { $default_value_add = "ALTER TABLE " . $meta_table . " CHANGE `" . $old_html_variable . "` `" . $htmlvar_name . "` VARCHAR( 254 ) NULL"; if ( $default_value != '' ) { $default_value_add .= " DEFAULT '" . $default_value . "'"; } } $alter_result = $wpdb->query( $default_value_add ); if ( $alter_result === false ) { return __( 'Column change failed, you may have too many columns.', 'userswp' ); } break; endswitch; } $extra_field_query = ''; if ( ! empty( $extra_fields ) ) { $extra_field_query = serialize( $extra_fields ); } $wpdb->query( $wpdb->prepare( "update " . $table_name . " set form_type = %s, site_title = %s, form_label = %s, help_text = %s, field_type = %s, data_type = %s, decimal_point = %s, field_type_key = %s, htmlvar_name = %s, default_value = %s, sort_order = %s, is_active = %s, placeholder_value = %s, for_admin_use = %s, is_default = %s, is_required = %s, is_dummy = %s, is_public = %s, is_register_field = %s, is_search_field = %s, is_register_only_field = %s, required_msg = %s, css_class = %s, field_icon = %s, show_in = %s, user_roles = %s, option_values = %s, extra_fields = %s, validation_pattern = %s, validation_msg = %s, form_id = %d, user_sort = %s where id = %d", array( $form_type, $site_title, $form_label, $help_text, $field_type, $data_type, $decimal_point, $field_type_key, $htmlvar_name, $default_value, $sort_order, $is_active, $placeholder_value, $for_admin_use, $is_default, $is_required, $is_dummy, $is_public, $is_register_field, $is_search_field, $is_register_only_field, $required_msg, $css_class, $field_icon, $show_in, $user_roles, $option_values, $extra_field_query, $validation_pattern, $validation_msg, $form_id, $user_sort, $cf ) ) ); $lastid = trim( $cf ); do_action( 'uwp_after_custom_fields_updated', $lastid ); } else { switch ( $field_type ): case 'checkbox': $data_type = 'TINYINT'; $meta_field_add = $data_type . "( 1 ) NOT NULL "; if ( (int) $default_value === 1 ) { $meta_field_add .= " DEFAULT '1'"; } $add_result = uwp_add_column_if_not_exist( $meta_table, $htmlvar_name, $meta_field_add ); if ( $add_result === false ) { return __( 'Column creation failed, you may have too many columns or the default value does not match with field data type.', 'userswp' ); } break; case 'multiselect': case 'select': $data_type = 'VARCHAR'; $op_size = '500'; // only make the field as big as it needs to be. if ( isset( $option_values ) && $option_values && $field_type == 'select' ) { $option_values_arr = explode( ',', $option_values ); if ( isset( $option_values_arr ) && is_array( $option_values_arr ) ) { $op_max = 0; foreach ( $option_values_arr as $op_val ) { if ( strlen( $op_val ) && strlen( $op_val ) > $op_max ) { $op_max = strlen( $op_val ); } } if ( $op_max ) { $op_size = $op_max; } } } elseif ( isset( $option_values ) && $option_values && $field_type == 'multiselect' ) { if ( strlen( $option_values ) ) { $op_size = strlen( $option_values ); } if ( isset( $request_field['multi_display_type'] ) ) { $extra_fields = $request_field['multi_display_type']; } } $meta_field_add = $data_type . "( $op_size ) NULL "; if ( $default_value != '' ) { $meta_field_add .= " DEFAULT '" . $default_value . "'"; } $add_result = uwp_add_column_if_not_exist( $meta_table, $htmlvar_name, $meta_field_add ); if ( $add_result === false ) { return __( 'Column creation failed, you may have too many columns or the default value does not match with field data type.', 'userswp' ); } break; case 'textarea': case 'editor': case 'url': case 'file': $data_type = 'TEXT'; $meta_field_add = $data_type . " NULL "; $add_result = uwp_add_column_if_not_exist( $meta_table, $htmlvar_name, $meta_field_add ); if ( $add_result === false ) { return __( 'Column creation failed, you may have too many columns or the default value does not match with field data type.', 'userswp' ); } break; case 'datepicker': $data_type = 'DATE'; $meta_field_add = $data_type . " NULL "; $add_result = uwp_add_column_if_not_exist( $meta_table, $htmlvar_name, $meta_field_add ); if ( $add_result === false ) { return __( 'Column creation failed, you may have too many columns or the default value must have in valid date format.', 'userswp' ); } break; case 'time': $data_type = 'TIME'; $meta_field_add = $data_type . " NULL "; $add_result = uwp_add_column_if_not_exist( $meta_table, $htmlvar_name, $meta_field_add ); if ( $add_result === false ) { return __( 'Column creation failed, you may have too many columns or the default value must have in valid time format.', 'userswp' ); } break; default: if ( $data_type != 'VARCHAR' && $data_type != '' ) { $meta_field_add = $data_type . " NULL "; if ( $data_type == 'FLOAT' && $decimal_point > 0 ) { $meta_field_add = "DECIMAL(11, " . (int) $decimal_point . ") NULL "; } if ( is_numeric( $default_value ) && $default_value != '' ) { $meta_field_add .= " DEFAULT '" . $default_value . "'"; } } else { $meta_field_add = " VARCHAR( 254 ) NULL "; if ( $default_value != '' ) { $meta_field_add .= " DEFAULT '" . $default_value . "'"; } } $add_result = uwp_add_column_if_not_exist( $meta_table, $htmlvar_name, $meta_field_add ); if ( $add_result === false ) { return __( 'Column creation failed, you may have too many columns or the default value does not match with field data type.', 'userswp' ); } break; endswitch; $extra_field_query = ''; if ( ! empty( $extra_fields ) ) { $extra_field_query = serialize( $extra_fields ); } $wpdb->query( $wpdb->prepare( "insert into " . $table_name . " set form_type = %s, site_title = %s, form_label = %s, help_text = %s, field_type = %s, data_type = %s, decimal_point = %s, field_type_key = %s, htmlvar_name = %s, default_value = %s, sort_order = %d, is_active = %s, placeholder_value = %s, for_admin_use = %s, is_default = %s, is_required = %s, is_dummy = %s, is_public = %s, is_register_field = %s, is_search_field = %s, is_register_only_field = %s, required_msg = %s, css_class = %s, field_icon = %s, show_in = %s, user_roles = %s, option_values = %s, extra_fields = %s, validation_pattern = %s, validation_msg = %s, form_id = %d, user_sort = %s ", array( $form_type, $site_title, $form_label, $help_text, $field_type, $data_type, $decimal_point, $field_type_key, $htmlvar_name, $default_value, $sort_order, $is_active, $placeholder_value, $for_admin_use, $is_default, $is_required, $is_dummy, $is_public, $is_register_field, $is_search_field, $is_register_only_field, $required_msg, $css_class, $field_icon, $show_in, $user_roles, $option_values, $extra_field_query, $validation_pattern, $validation_msg, $form_id, $user_sort ) ) ); $lastid = $wpdb->insert_id; $lastid = trim( $lastid ); } return (int) $lastid; } else { return 'invalid_key'; } } public function register_ajax_handler() { if ( isset( $_REQUEST['create_field'] ) ) { if ( ! current_user_can( 'manage_options' ) ) { wp_die( -1 ); } $form_id = isset( $_REQUEST['form_id'] ) ? sanitize_text_field( $_REQUEST['form_id'] ) : 1; $field_id = isset( $_REQUEST['field_id'] ) ? trim( sanitize_text_field( $_REQUEST['field_id'] ), '_' ) : ''; $field_action = isset( $_REQUEST['field_ins_upd'] ) ? sanitize_text_field( $_REQUEST['field_ins_upd'] ) : ''; /* ------- check nonce field ------- */ if ( isset( $_REQUEST['update'] ) && $_REQUEST['update'] == 'update' ) { $field_ids = array(); if ( ! empty( $_REQUEST['licontainer'] ) && is_array( $_REQUEST['licontainer'] ) ) { foreach ( $_REQUEST['licontainer'] as $lic_id ) { $field_ids[] = sanitize_text_field( $lic_id ); } } $return = uwp_form_extras_field_order( $field_ids, "register", $form_id ); if ( is_array( $return ) ) { $return = json_encode( $return ); } echo $return; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } /* ---- Show field form in admin ---- */ if ( $field_action == 'new' ) { $form_type = isset( $_REQUEST['form_type'] ) ? sanitize_text_field( $_REQUEST['form_type'] ) : ''; $fields = $this->register_fields( $form_type, $form_id ); $_REQUEST['site_field_id'] = isset( $_REQUEST['field_id'] ) ? sanitize_text_field( $_REQUEST['field_id'] ) : ''; $_REQUEST['is_default'] = '0'; if ( ! empty( $fields ) ) { foreach ( $fields as $val ) { $val = stripslashes_deep( $val ); if ( $val['htmlvar_name'] == $_REQUEST['htmlvar_name'] ) { $_REQUEST['field_type'] = $val['field_type']; $_REQUEST['site_title'] = $val['site_title']; } } } $htmlvar_name = isset( $_REQUEST['htmlvar_name'] ) ? sanitize_text_field( $_REQUEST['htmlvar_name'] ) : ''; $this->register_field_adminhtml( $htmlvar_name, $field_action, false, $_REQUEST ); } /* ---- Delete field ---- */ if ( $field_id != '' && $field_action == 'delete' && isset( $_REQUEST['_wpnonce'] ) ) { if ( ! wp_verify_nonce( $_REQUEST['_wpnonce'], 'uwp_form_extras_nonce' . $field_id ) ) { return; } echo $this->register_field_delete( $field_id ); // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } /* ---- Save field ---- */ if ( $field_id != '' && $field_action == 'submit' && isset( $_REQUEST['_wpnonce'] ) ) { if ( ! wp_verify_nonce( $_REQUEST['_wpnonce'], 'uwp_form_extras_nonce' . $field_id ) ) { return; } foreach ( $_REQUEST as $pkey => $pval ) { $tags = is_array( $_REQUEST[ $pkey ] ) ? 'skip_field' : ''; if ( $tags != 'skip_field' ) { $_REQUEST[ $pkey ] = strip_tags( sanitize_text_field( $_REQUEST[ $pkey ] ), $tags ); } } $return = $this->register_field_save( $_REQUEST ); if ( is_int( $return ) ) { $lastid = $return; $this->register_field_adminhtml( $lastid, 'submit' ); } else { echo $return; // phpcs:ignore WordPress.Security.EscapeOutput.OutputNotEscaped } } } die(); } public function register_field_delete( $field_id = '' ) { global $wpdb; $extras_table_name = uwp_get_table_prefix() . 'uwp_form_extras'; if ( $field_id != '' ) { $cf = trim( $field_id, '_' ); $wpdb->query( $wpdb->prepare( "delete from " . $extras_table_name . " where id= %d ", array( $cf ) ) ); return $field_id; } else { return 0; } } public function register_field_save( $request_field = array() ) { if ( ! current_user_can( 'manage_options' ) ) { wp_die( -1 ); } global $wpdb; $extras_table_name = uwp_get_table_prefix() . 'uwp_form_extras'; $form_id = isset( $request_field['form_id'] ) ? (int) $request_field['form_id'] : ''; $result_str = isset( $request_field['field_id'] ) ? trim( $request_field['field_id'] ) : ''; $cf = trim( $result_str, '_' ); /*-------- check duplicate validation --------*/ $site_htmlvar_name = isset( $request_field['site_htmlvar_name'] ) ? sanitize_text_field($request_field['site_htmlvar_name']) : sanitize_text_field($request_field['htmlvar_name']); $form_type = $request_field['form_type']; $field_type = $request_field['field_type']; $check_html_variable = $wpdb->get_var( $wpdb->prepare( "select site_htmlvar_name from " . $extras_table_name . " where id <> %d and site_htmlvar_name = %s and form_type = %s and form_id=%d", array( $cf, $site_htmlvar_name, $form_type, $form_id ) ) ); if ( ! $check_html_variable ) { if ( $cf != '' ) { $user_meta_info = $wpdb->get_row( $wpdb->prepare( "select * from " . $extras_table_name . " where id = %d", array( $cf ) ) ); } if ( $form_type == '' ) { $form_type = 'register'; } $site_htmlvar_name = sanitize_text_field($request_field['site_htmlvar_name']); $field_id = ( isset( $request_field['field_id'] ) && $request_field['field_id'] ) ? str_replace( 'new', '', $request_field['field_id'] ) : ''; if ( ! empty( $user_meta_info ) ) { $wpdb->query( $wpdb->prepare( "update " . $extras_table_name . " set form_type = %s, field_type = %s, site_htmlvar_name = %s, sort_order = %s, form_id = %d where id = %d", array( $form_type, $field_type, $site_htmlvar_name, $field_id, $form_id, $cf ) ) ); $lastid = trim( $cf ); } else { $wpdb->query( $wpdb->prepare( "insert into " . $extras_table_name . " set form_type = %s, field_type = %s, site_htmlvar_name = %s, sort_order = %s, form_id = %s", array( $form_type, $field_type, $site_htmlvar_name, $field_id, $form_id ) ) ); $lastid = $wpdb->insert_id; $lastid = trim( $lastid ); } return (int) $lastid; } else { return 'invalid_key'; } } }