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);
}
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=?',