Bug fixes.

diff --git a/foosball.pm b/foosball.pm
index f87f7637d2039dd407db7aa6eca2d12af1f53cdc..8e1e931d2d573d527424bb8f5d229e6fbdce0bba 100644 (file)
--- a/foosball.pm
+++ b/foosball.pm
@@ -15,6 +15,12 @@ sub find_single_rating {
        my ($age, $rating, $rd) = $dbh->selectrow_array('SELECT EXTRACT(EPOCH FROM (CURRENT_TIMESTAMP-ratetime)), rating, rd FROM single_rating WHERE username=? '.$limit.' ORDER BY ratetime DESC LIMIT 1',
                undef, $username);
        $rd = apply_aging($rd, $age / 86400.0);
+
+       if (!defined($rating)) {
+               $rating = 1500;
+               $rd = 350;
+       }
+
        return ($rating, $rd);
 }
 
@@ -23,9 +29,23 @@ sub find_double_rating {
        my ($age, $rating, $rd) = $dbh->selectrow_array('SELECT EXTRACT(EPOCH FROM (CURRENT_TIMESTAMP-ratetime)), rating, rd FROM double_rating WHERE username=? '.$limit.'ORDER BY ratetime DESC LIMIT 1',
                undef, $username);
        $rd = apply_aging($rd, $age / 86400.0);
+       
+       if (!defined($rating)) {
+               $rating = 1500;
+               $rd = 350;
+       }
+
        return ($rating, $rd);
 }
 
+sub combine_ratings {
+       my ($rating1, $rd1, $rating2, $rd2) = @_;
+
+       my $rating_team = 0.5 * ($rating1 + $rating2);
+       my $rd_team = sqrt($rd1 * $rd1 + $rd2 * $rd2) / sqrt(2.0);
+       return ($rating_team, $rd_team);
+}
+
 sub create_user_if_not_exists {
        my ($dbh, $username) = @_;
        my $count = $dbh->selectrow_array('SELECT count(*) FROM users WHERE username=?',