X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=recalc-single-result.pl;h=c67be84b36e84a68e3fba5bd596e57b2e4b460a1;hb=da3fa6c4de949158716dd130551cf6494f3766da;hp=02f421b899b5bef903db0074abe8ba3a2d13d5e2;hpb=69ada6cdd711047aca553a5242f8b878041737e9;p=foosball diff --git a/recalc-single-result.pl b/recalc-single-result.pl index 02f421b..c67be84 100755 --- a/recalc-single-result.pl +++ b/recalc-single-result.pl @@ -42,10 +42,10 @@ while (my $ref = $q->fetchrow_hashref) { printf("%-10s - %-10s: %u - %u, new ratings %u/%u %u/%u\n", $ref->{'username1'}, $ref->{'username2'}, $ref->{'score1'}, $ref->{'score2'}, $newr1, $newrd1, $newr2, $newrd2); - $dbh->do('insert into single_rating values (?,?,?,?)', undef, - $ref->{'username1'}, $ref->{'gametime'}, $newr1, $newrd1); - $dbh->do('insert into single_rating values (?,?,?,?)', undef, - $ref->{'username2'}, $ref->{'gametime'}, $newr2, $newrd2); + $dbh->do('insert into single_rating values (?,?,?,?,?)', undef, + $ref->{'username1'}, $ref->{'gametime'}, $newr1, $newrd1, $newr1-$rating1); + $dbh->do('insert into single_rating values (?,?,?,?,?)', undef, + $ref->{'username2'}, $ref->{'gametime'}, $newr2, $newrd2, $newr2-$rating2); $ratings{$ref->{'username1'}} = [ $newr1, $newrd1, $ref->{'eptime'} ]; $ratings{$ref->{'username2'}} = [ $newr2, $newrd2, $ref->{'eptime'} ];