From: Steinar H. Gunderson <sesse@debian.org>
Date: Mon, 8 Oct 2007 11:15:31 +0000 (+0200)
Subject: Fixed insertion of new results again.
X-Git-Url: https://git.sesse.net/?p=foosball;a=commitdiff_plain;h=1e96dde4a48649a43a3a436990347c7bc0440943

Fixed insertion of new results again.
---

diff --git a/www/add-double-result.pl b/www/add-double-result.pl
index 0f269ab..89b133c 100755
--- a/www/add-double-result.pl
+++ b/www/add-double-result.pl
@@ -67,13 +67,13 @@ 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,?,?,?)',
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd,rating_diff) 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,?,?,?)',
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd,rating_diff) 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,?,?,?)',
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd,rating_diff) 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,?,?,?)',
+$dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd,rating_diff) VALUES (?,CURRENT_TIMESTAMP,?,?,?,?)',
 	undef, $team2_username2, $newr2_2, $newrd2_2, $newr2_2-$rating2_2);
 
 $dbh->commit;
diff --git a/www/add-single-result.pl b/www/add-single-result.pl
index 76edbd0..ae2b3f0 100755
--- a/www/add-single-result.pl
+++ b/www/add-single-result.pl
@@ -42,9 +42,9 @@ my ($newr2, $newrd2) = foosball::calc_rating($rating2, $rd2, $rating1, $rd1, $sc
 
 $dbh->do('INSERT INTO single_results (gametime,username1,username2,score1,score2) VALUES (CURRENT_TIMESTAMP,?,?,?,?)',
 	undef, $username1, $username2, $score1, $score2);
-$dbh->do('INSERT INTO single_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
+$dbh->do('INSERT INTO single_rating (username,ratetime,rating,rd,rating_diff) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
 	undef, $username1, $newr1, $newrd1, $newr1-$rating1);
-$dbh->do('INSERT INTO single_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
+$dbh->do('INSERT INTO single_rating (username,ratetime,rating,rd,rating_diff) VALUES (?,CURRENT_TIMESTAMP,?,?,?)',
 	undef, $username2, $newr2, $newrd2, $newr2-$rating2);
 
 $dbh->commit;