X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;ds=inline;f=Commands%2FUsermgm.pm;h=eb7560c7a626a9d7c1813a991d947886f2de6ebc;hb=effc5281e94e0fa16f1fd08bf848f607a306d0c0;hp=eed0d19718b2774bfab1f951d054e928a3dd4eeb;hpb=17aabe51d5b62ae4bcae5ec3b02757ab5aa65b77;p=NDIRC.git
diff --git a/Commands/Usermgm.pm b/Commands/Usermgm.pm
index eed0d19..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);
-
$points //= 1;
+ return unless $self->check($c,$nick,$points);
+
my $dbh = $c->model;
if ($points*$points > 400){
@@ -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;