X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=www%2Fadd-double-result.pl;h=0f269ab42e0b162a0fe050e909ecf567a8a8adf6;hb=da3fa6c4de949158716dd130551cf6494f3766da;hp=07cefa8bd2b1f6084639330158ae1b18816ae5b4;hpb=69ada6cdd711047aca553a5242f8b878041737e9;p=foosball

diff --git a/www/add-double-result.pl b/www/add-double-result.pl
index 07cefa8..0f269ab 100755
--- a/www/add-double-result.pl
+++ b/www/add-double-result.pl
@@ -67,14 +67,14 @@ my (undef, $newrd2_2) = foosball::calc_rating($rating2_2, $rd2_2, $rating_team1,
 
 $dbh->do('INSERT INTO double_results (gametime,team1_username1,team1_username2,team2_username1,team2_username2,score1,score2) VALUES (CURRENT_TIMESTAMP,?,?,?,?,?,?)',
 	undef, $team1_username1, $team1_username2, $team2_username1, $team2_username2, $score1, $score2);
-$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?)',
-	undef, $team1_username1, $newr1_1, $newrd1_1);
-$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?)',
-	undef, $team1_username2, $newr1_2, $newrd1_2);
-$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?)',
-	undef, $team2_username1, $newr2_1, $newrd2_1);
-$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?)',
-	undef, $team2_username2, $newr2_2, $newrd2_2);
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
+	undef, $team1_username1, $newr1_1, $newrd1_1, $newr1_1-$rating1_1);
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
+	undef, $team1_username2, $newr1_2, $newrd1_2, $newr1_2-$rating1_2);
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
+	undef, $team2_username1, $newr2_1, $newrd2_1, $newr2_1-$rating2_1);
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
+	undef, $team2_username2, $newr2_2, $newrd2_2, $newr2_2-$rating2_2);
 
 $dbh->commit;