]> git.sesse.net Git - foosball/commitdiff
Fix syntax error on new double results.
authorSteinar H. Gunderson <sesse@debian.org>
Wed, 10 Oct 2007 21:46:28 +0000 (23:46 +0200)
committerSteinar H. Gunderson <sesse@debian.org>
Wed, 10 Oct 2007 21:46:28 +0000 (23:46 +0200)
www/add-double-result.pl

index 89b133ca49dbc282b65249132d937816a8988568..9b65aff120b5f34738d64e61a4dd23cd954362f3 100755 (executable)
@@ -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,rating_diff) 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,rating_diff) 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,rating_diff) 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,rating_diff) 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;