add_action( 'gform_after_submission', 'nifty_gform_remove_entries ), 10, 2 ); function nifty_gform_remove_entries( $entry, $form ) { if($form["id"] == 5){ return; } global $wpdb; $lead_id = $entry['id']; $lead_table = RGFormsModel::get_lead_table_name(); $lead_notes_table = RGFormsModel::get_lead_notes_table_name(); $lead_detail_table = RGFormsModel::get_lead_details_table_name(); $lead_detail_long_table = RGFormsModel::get_lead_details_long_table_name(); // Delete from detail long $sql = $wpdb->prepare( " DELETE FROM $lead_detail_long_table WHERE lead_detail_id IN( SELECT id FROM $lead_detail_table WHERE lead_id=%d )", $lead_id ); $wpdb->query( $sql ); // Remove file uploads $sql = $wpdb->prepare("SELECT value FROM $lead_detail_table WHERE lead_id=%d", $lead_id ); $results = $wpdb->get_results($sql, ARRAY_A ) or die(mysql_error()); foreach ($results as $check_value_for_file) { $file_url = parse_url($check_value_for_file['value']); $file_path = $file_url['path']; $upload_dir = wp_upload_dir(); $file_location = realpath($upload_dir['basedir']. "/../../").$file_path; if (file_exists($file_location)) { unlink($file_location); } } // Delete from lead details $sql = $wpdb->prepare( "DELETE FROM $lead_detail_table WHERE lead_id=%d", $lead_id ); $wpdb->query( $sql ); // Delete from lead notes $sql = $wpdb->prepare( "DELETE FROM $lead_notes_table WHERE lead_id=%d", $lead_id ); $wpdb->query( $sql ); // Delete from lead $sql = $wpdb->prepare( "DELETE FROM $lead_table WHERE id=%d", $lead_id ); $wpdb->query( $sql ); }