From 103c3c2ed9ccd4f5ef95a1f8ea7f700a7a38e2cd Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Tue, 5 Jun 2007 14:09:06 +0000 Subject: [PATCH] no need to use nbsp, and better to just sit it to null --- ND/Web/Pages/Alliances.pm | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/ND/Web/Pages/Alliances.pm b/ND/Web/Pages/Alliances.pm index 48975c1..706d3fc 100644 --- a/ND/Web/Pages/Alliances.pm +++ b/ND/Web/Pages/Alliances.pm @@ -46,7 +46,7 @@ sub render_body { $DBH->begin_work; if (param('crelationship')){ my $value = escapeHTML(param('relationship')); - if ($DBH->do(q{UPDATE alliances SET relationship = ? WHERE id =?} + if ($DBH->do(q{UPDATE alliances SET relationship = NULLIF(?,'') WHERE id =?} ,undef,$value,$alliance->{id})){ $alliance->{relationship} = $value; log_message $ND::UID,"HC set alliance: $alliance->{id} relationship: $value"; @@ -78,7 +78,7 @@ sub render_body { $BODY->param(Alliance => $alliance->{name}); $BODY->param(Id => $alliance->{id}); my @relationships; - for my $relationship (" ","Friendly", "NAP", "Hostile"){ + for my $relationship ("","Friendly", "NAP", "Hostile"){ push @relationships,{Rel => $relationship, Selected => defined $alliance->{relationship} && $relationship eq $alliance->{relationship}} } $BODY->param(Relationships => \@relationships); -- 2.39.2