X-Git-Url: https://git.sesse.net/?a=blobdiff_plain;f=foosball.pm;h=9c3821834525e665d2b1fddeb6e13adbd18fb015;hb=1f8489da48b9721d9c44b97749078a94b935a7b2;hp=a2b0d55b041ab4d8f6084f523dc8d680a31c4ecc;hpb=1b1cf9d60369578fecd0cad0c2fed7b91d08f073;p=foosball diff --git a/foosball.pm b/foosball.pm index a2b0d55..9c38218 100644 --- a/foosball.pm +++ b/foosball.pm @@ -1,6 +1,7 @@ use strict; use warnings; use DBI; +use POSIX; package foosball; @@ -10,6 +11,12 @@ sub db_connect { return $dbh; } +sub round { + my $x = shift; + return -round(-$x) if ($x < 0.0); + return POSIX::floor($x + 0.5); +} + sub find_single_rating { my ($dbh, $username, $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',