X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=foosball.pm;h=58e468c6669ea3ac0c5dfbfbfcc1fd9a39578885;hb=6de5990c86e41173169db2dd974ff0332b9d0ee6;hp=9c3821834525e665d2b1fddeb6e13adbd18fb015;hpb=1f8489da48b9721d9c44b97749078a94b935a7b2;p=foosball

diff --git a/foosball.pm b/foosball.pm
index 9c38218..58e468c 100644
--- a/foosball.pm
+++ b/foosball.pm
@@ -19,6 +19,7 @@ sub round {
 
 sub find_single_rating {
 	my ($dbh, $username, $limit) = @_;
+	$limit = "" if (!defined($limit));
 	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);
@@ -33,6 +34,7 @@ sub find_single_rating {
 
 sub find_double_rating {
 	my ($dbh, $username, $limit) = @_;
+	$limit = "" if (!defined($limit));
 	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);
@@ -45,14 +47,6 @@ sub find_double_rating {
 	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=?',