X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=foosball.pm;h=38722422caea742ec265373305a913c3e342b451;hb=cb401f528d8725c91d844e98449984414a7eda5a;hp=bf32eedf785eb481f1f395f4039267f35032e099;hpb=a4650e013b1689022a8dad1e2fe4101beded6e74;p=foosball diff --git a/foosball.pm b/foosball.pm index bf32eed..3872242 100644 --- a/foosball.pm +++ b/foosball.pm @@ -5,6 +5,10 @@ use POSIX; package foosball; +our $initial_rating = 1500.0; +our $initial_rd = 400.0; +our $c = 22.5; + sub db_connect { my $dbh = DBI->connect("dbi:Pg:dbname=foosball;host=127.0.0.1", "foosball", "cleanrun", {AutoCommit => 0}); $dbh->{RaiseError} = 1; @@ -19,13 +23,14 @@ 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); if (!defined($rating)) { - $rating = 1500; - $rd = 350; + $rating = $initial_rating; + $rd = $initial_rd; } return ($rating, $rd); @@ -33,13 +38,14 @@ 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); if (!defined($rating)) { - $rating = 1500; - $rd = 350; + $rating = $initial_rating; + $rd = $initial_rd; } return ($rating, $rd); @@ -52,20 +58,18 @@ sub create_user_if_not_exists { return if ($count > 0); $dbh->do('INSERT INTO users (username) VALUES (?)', undef, $username); - $dbh->do('INSERT INTO single_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,1500.0,350.0)', - undef, $username); - $dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,1500.0,350.0)', - undef, $username); + $dbh->do('INSERT INTO single_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?)', + undef, $username, $initial_rating, $initial_rd); + $dbh->do('INSERT INTO double_rating (username,ratetime,rating,rd) VALUES (?,CURRENT_TIMESTAMP,?,?)', + undef, $username, $initial_rating, $initial_rd); return $dbh; } -# c=8 => RD=50 moves to RD=350 over approx. five years -our $c = 8; - +# $age is in days sub apply_aging { my ($rd, $age) = @_; - $rd = sqrt($rd*$rd + $c * $c * ($age / 86400.0)); - $rd = 350.0 if ($rd > 350.0); + $rd = sqrt($rd*$rd + $c * $c * $age); + $rd = $initial_rd if ($rd > $initial_rd); return $rd; } @@ -73,11 +77,11 @@ sub calc_rating { 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 {