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);
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);
my ($rating1, $rd1, $rating2, $rd2, $score1, $score2) = @_;
my $result = `/srv/foosball.sesse.net/foosrank $rating1 $rd1 $rating2 $rd2 $score1 $score2`;
chomp $result;
- my ($newr1, $newrd1) = split / /, $result;
+ my ($newr1, $newrd1, $likelihood) = split / /, $result;
$newrd1 = 30.0 if ($newrd1 < 30.0);
- return ($newr1, $newrd1);
+ return ($newr1, $newrd1, $likelihood);
}
sub calc_rating_double {