X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Foe_ar_ap_delivery_orders_edit_notes_as_html.pl;fp=sql%2FPg-upgrade2%2Foe_ar_ap_delivery_orders_edit_notes_as_html.pl;h=a5575f6d2eda27a9cec640161907b65747a183f6;hb=53593baa211863fbf66540cf1bcc36c8fb37257f;hp=2be82f172d35e3936f8511653cfe45e285ff126f;hpb=deb4d2dbb676d7d6f69dfe7815d6e0cb09bd4a44;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/oe_ar_ap_delivery_orders_edit_notes_as_html.pl b/sql/Pg-upgrade2/oe_ar_ap_delivery_orders_edit_notes_as_html.pl index 2be82f172..a5575f6d2 100644 --- a/sql/Pg-upgrade2/oe_ar_ap_delivery_orders_edit_notes_as_html.pl +++ b/sql/Pg-upgrade2/oe_ar_ap_delivery_orders_edit_notes_as_html.pl @@ -7,6 +7,7 @@ use strict; use utf8; use SL::DBUtils; +use SL::Presenter::EscapedText qw(escape); use parent qw(SL::DBUpgrade2::Base); @@ -18,7 +19,7 @@ sub convert_column { foreach my $row (selectall_hashref_query($::form, $self->dbh, qq|SELECT id, $column FROM $table WHERE $column IS NOT NULL|)) { next if !$row->{$column} || (($row->{$column} =~ m{^<[a-z]+>}) && ($row->{$column} =~ m{$})); - my $new_content = "" . $::request->presenter->escape($row->{$column}); + my $new_content = "" . escape($row->{$column}); $new_content =~ s{\r}{}g; $new_content =~ s{\n\n+}{

}g; $new_content =~ s{\n}{
}g;