X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FInclude.pm;h=992f978d9b28ff733bff43d06b2db0aebeafe732;hb=eafb5ef101dfc9cf22655a532073e8b71a036a67;hp=81f5a8db8fcbe73a84aa222fefca7f15fcd5991b;hpb=86fb846b1b46198bd134e83b5c0488b5b8731ec2;p=ndwebbie.git diff --git a/ND/Include.pm b/ND/Include.pm index 81f5a8d..992f978 100644 --- a/ND/Include.pm +++ b/ND/Include.pm @@ -25,7 +25,7 @@ require Exporter; our @ISA = qw/Exporter/; -our @EXPORT = qw/min max log_message intel_log unread_query/; +our @EXPORT = qw/min max parseValue prettyValue log_message intel_log unread_query pa_xp/; sub min { my ($x,$y) = @_; @@ -37,6 +37,36 @@ sub max { return ($x < $y ? $y : $x); } + +sub parseValue { + if (defined $_[0] && $_[0] =~ /^(-?\d+(?:\.\d+)?)([khMG])?$/){ + return $1 unless defined $2; + return $1*100 if $2 eq 'h'; + return $1*1000 if $2 eq 'k'; + return $1*1000000 if $2 eq 'M'; + return $1*1000000000 if $2 eq 'G'; + } + return $_[0]; +} + +sub prettyValue { + my ($value,$decimals) = @_; + my $unit = ''; + my @units = ('k','M','G','T'); + for (my $i = 0; $value >= 1000;$i++){ + $value /= 1000; + $unit = $units[$i]; + } + unless (defined $decimals){ + $decimals = '.0'; + $decimals = '.1' if $value < 100 && $unit; + $decimals = '.2' if $value < 10 && $unit; + } + + return sprintf('%'.$decimals.'f%s', $value,$unit); +} + + sub log_message { my ($uid, $message) = @_; my $log = $ND::DBH->prepare_cached(q{INSERT INTO forum_posts (ftid,uid,message) VALUES( @@ -51,9 +81,16 @@ sub intel_log { $log->execute($uid,$message,$planet) or $ND::ERROR .= p($ND::DBH->errstr); } +sub pa_xp { + my ($roids,$ascore,$avalue,$tscore,$tvalue) = @_; + my $bravery = (max(0,min(2,$tscore/$ascore)-0.6)) * (min(2,$tvalue/$avalue)-0.4); + return int(max($roids * 10 * $bravery,0)) + +} + sub unread_query { return $ND::DBH->prepare_cached(q{ - SELECT count(*) AS unread + SELECT count(*) AS unread, count(NULLIF(fp.time > $2,FALSE)) AS new FROM forum_boards fb NATURAL JOIN forum_threads ft JOIN forum_posts fp USING (ftid) LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1) ftv ON ftv.ftid = ft.ftid