X-Git-Url: https://git.sesse.net/?p=ccbs;a=blobdiff_plain;f=html%2Fdo-edit-scores.pl;h=be93df0536c9ef0871822406f37b1dd92bb1195a;hp=fe29c168abe76ddc895101fa02f0e67aaec502bc;hb=a5bef5a751fddcaa09f7d4281e2452ea778436ca;hpb=9e9977d8d73f4f28e6f8f3d6d1a007a859bc3955 diff --git a/html/do-edit-scores.pl b/html/do-edit-scores.pl index fe29c16..be93df0 100755 --- a/html/do-edit-scores.pl +++ b/html/do-edit-scores.pl @@ -20,9 +20,25 @@ for my $p ($cgi->param()) { next unless (defined($cgi->param('old-' . $p))); next if ($cgi->param($p) eq $cgi->param('old-' . $p)); + my $val = $cgi->param($p); + undef $val if ($val =~ /^\s*$/); + if ($p =~ /^score(\d+)-(\d+)/) { + if (defined($val) && ($val < 0 || $val > 10000)) { + ccbs::user_error("Alle poengsummer må være mellom 0 og 10000 (inklusive)."); + } + $dbh->do('UPDATE scores SET score=? WHERE tournament=? AND round=? AND parallel=? AND player=? AND songnumber=?', undef, - $cgi->param($p), $tournament, $round, $group, $1, $2); + $val, $tournament, $round, $group, $1, $2); + } elsif ($p =~ /^playmode(\d+)-(\d+)/) { + $dbh->do('UPDATE scores SET playmode=? WHERE tournament=? AND round=? AND parallel=? AND player=? AND songnumber=?', undef, + $val, $tournament, $round, $group, $1, $2); + } elsif ($p =~ /^difficulty(\d+)-(\d+)/) { + $dbh->do('UPDATE scores SET difficulty=? WHERE tournament=? AND round=? AND parallel=? AND player=? AND songnumber=?', undef, + $val, $tournament, $round, $group, $1, $2); + } elsif ($p =~ /^song(\d+)-(\d+)/) { + $dbh->do('UPDATE scores SET song=? WHERE tournament=? AND round=? AND parallel=? AND player=? AND songnumber=? AND chosen=\'t\'', undef, + $val, $tournament, $round, $group, $1, $2); } }