X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Commands%2FUsermgm.pm;h=eb7560c7a626a9d7c1813a991d947886f2de6ebc;hb=18f4d0759b08b0192c42d641a28336bc5980dc75;hp=02ff82df133a1b9c56a4ddab662d503545586479;hpb=a2b0f6f238d2150f3150c2bd1ffdec3edbdfa5d3;p=NDIRC.git diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm index 02ff82d..eb7560c 100644 --- a/Commands/Usermgm.pm +++ b/Commands/Usermgm.pm @@ -423,10 +423,10 @@ my $points = class extends NDIRC::Command { method execute ($c,$msg) { my ($nick,$points) = $msg =~ /^(\S+)(?: (-?(:?\d+|\d*\.\d+)))?$/ or die 'ARGS'; - return unless $self->check($c,$nick); - $points //= 1; + return unless $self->check($c,$nick,$points); + my $dbh = $c->model; if ($points*$points > 400){ @@ -449,7 +449,7 @@ my $points = class extends NDIRC::Command { } $f->finish; } - method check ($c,$nick) { + method check ($c,$nick,$points) { return 1; } }; @@ -460,7 +460,7 @@ command a => { acl => q(irc_a) }, class { extends $points->name; - method check ($c,$nick) { + method check ($c,$nick,$points) { my ($fleets) = $c->model->selectrow_array(q{ SELECT count(*) FROM raids r JOIN raid_targets rt ON r.id = rt.raid @@ -496,4 +496,54 @@ command h => { acl => q(irc_h), }, $points; +command getanti => { + help => q(Usage: .getanti class [eta] | class is the target class, like fi or bs, eta is optional max eta for the ships.), + acl => q(irc_getships), +}, class extends NDIRC::Command { + method execute ($c,$msg) { + my ($class,$eta) = $msg =~ /^(\S+)(?: (\d+))?$/ or die 'ARGS'; + my $dbh = $c->model; + + $eta //= 9; + + my @classes = qw/Fi Co Fr De Cr Bs/; + for (@classes){ + if (lc $class eq lc $_){ + $class = $_; + last; + } + } + + while ($eta < 9){ + pop @classes; + pop @classes; + $eta++; + } + + my $f = $dbh->prepare(q{ +SELECT username, ship, amount, CASE WHEN $1 = t1 THEN 't1' ELSE 't2' END AS t +FROM available_ships a + JOIN ship_stats s USING (ship) +WHERE uid IN (SELECT uid FROM groupmembers WHERE gid = 'M') + AND class = ANY($2) + AND $1 IN (t1,t2) +ORDER BY amount*(metal+crystal+eonium)*CASE WHEN $1 = t1 THEN 1.0 ELSE 0.6 END DESC + }); + $f->execute($class,\@classes); + my $text; + my $i = 0; + my $total = 0; + while (my $user = $f->fetchrow_hashref){ + $text .= "($user->{username}: $user->{ship} $user->{amount} $user->{t}) "; + $i++; + $total += $user->{amount}; + } + if ($text){ + $c->reply("$i fleets with anti-$class: $text"); + }else{ + $c->reply("Couldn't find any user with anti-$class"); + } + } +}; + 1;