esc_html__( 'Invalid form submission.', '24tt-unrestricted-forms' ) ) ); } // 2. WALL 1: Cryptographic Nonce Verification $nonce_name = 'tt24_submit_nonce'; $nonce_action = 'tt24_submit_' . $form_id; if ( ! isset( $_POST[ $nonce_name ] ) || ! wp_verify_nonce( sanitize_text_field( wp_unslash( $_POST[ $nonce_name ] ) ), $nonce_action ) ) { wp_send_json_error( array( 'message' => esc_html__( 'Security check failed. Please refresh the page and try again.', '24tt-unrestricted-forms' ) ) ); } // Table names $table_forms = $wpdb->prefix . 'tt24_forms'; $table_entries = $wpdb->prefix . 'tt24_entries'; $table_entry_fields = $wpdb->prefix . 'tt24_entry_fields'; // 3. Fetch Form Settings to act as an Input Whitelist // phpcs:disable WordPress.DB.PreparedSQL.InterpolatedNotPrepared // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery // phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching $form = $wpdb->get_row( $wpdb->prepare( "SELECT form_settings FROM {$table_forms} WHERE id = %d AND status = 'publish'", $form_id ) ); // phpcs:enable if ( ! $form ) { wp_send_json_error( array( 'message' => esc_html__( 'Form not found or inactive.', '24tt-unrestricted-forms' ) ) ); } // BUG FIX v1.1.0: Safely Parse JSON to extract just the Layout for Whitelisting $parsed_data = json_decode( $form->form_settings, true ); $fields_layout = array(); $settings = array(); if ( is_array( $parsed_data ) ) { if ( isset( $parsed_data['layout'] ) ) { // v1.1.0 Format $fields_layout = is_array( $parsed_data['layout'] ) ? $parsed_data['layout'] : array(); $settings = isset( $parsed_data['settings'] ) ? $parsed_data['settings'] : array(); } else { // v1.0.0 Legacy Format $fields_layout = $parsed_data; } } $allowed_fields = array(); if ( is_array( $fields_layout ) ) { foreach ( $fields_layout as $field ) { if ( isset( $field['name'] ) ) { $allowed_fields[] = $field['name']; } } } // 4. Prepare Entry Metadata $ip_address = isset( $_SERVER['REMOTE_ADDR'] ) ? sanitize_text_field( wp_unslash( $_SERVER['REMOTE_ADDR'] ) ) : 'Unknown'; $user_agent = isset( $_SERVER['HTTP_USER_AGENT'] ) ? sanitize_textarea_field( wp_unslash( $_SERVER['HTTP_USER_AGENT'] ) ) : 'Unknown'; // 5. WALL 2: Database Insert - Parent Entry // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery // phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching $inserted = $wpdb->insert( $table_entries, array( 'form_id' => $form_id, 'ip_address' => $ip_address, 'user_agent' => $user_agent, 'status' => 'unread' ), array( '%d', '%s', '%s', '%s' ) ); // phpcs:enable if ( false === $inserted ) { wp_send_json_error( array( 'message' => esc_html__( 'Database error: Could not save entry.', '24tt-unrestricted-forms' ) ) ); } $entry_id = $wpdb->insert_id; // 6. WALL 3: Whitelisted Data Sanitization & Relational Insert $sanitized_post_data = array(); foreach ( $allowed_fields as $field_name ) { if ( isset( $_POST[ $field_name ] ) ) { // phpcs:ignore WordPress.Security.ValidatedSanitizedInput.InputNotSanitized, WordPress.Security.ValidatedSanitizedInput.MissingUnslash $raw_value = $_POST[ $field_name ]; if ( is_array( $raw_value ) ) { $clean_value = implode( ', ', array_map( 'sanitize_textarea_field', wp_unslash( $raw_value ) ) ); } else { $clean_value = sanitize_textarea_field( wp_unslash( $raw_value ) ); } $sanitized_post_data[ $field_name ] = $clean_value; // phpcs:disable WordPress.DB.DirectDatabaseQuery.DirectQuery // phpcs:disable WordPress.DB.DirectDatabaseQuery.NoCaching $wpdb->insert( $table_entry_fields, array( 'entry_id' => $entry_id, 'form_id' => $form_id, 'field_name' => sanitize_text_field( $field_name ), 'field_value' => $clean_value ), array( '%d', '%d', '%s', '%s' ) ); // phpcs:enable } } // 7. Trigger Mailer Engine if ( class_exists( 'TT24_Mailer' ) ) { TT24_Mailer::send_notifications( $form_id, $entry_id, $sanitized_post_data ); } // 8. Success Response - Upgraded to send custom settings back to Javascript! $success_message = !empty($settings['success_message']) ? $settings['success_message'] : esc_html__( 'Thank you! Your submission has been received.', '24tt-unrestricted-forms' ); wp_send_json_success( array( 'message' => $success_message, 'settings' => $settings // Pass settings to JS for custom redirects in the next step! ) ); wp_die(); } } // Instantiate and initialize the submission processor securely $tt24_submission = new TT24_Submission(); $tt24_submission->init();