+ });
+ my $call = $dbh->selectrow_hashref($st,undef,$callnr);
+ unless (defined $call->{status}){
+ $c->reply("No call with id: $callnr");
+ return;
+ }
+ $callinfo = "(Anti $call->{shiptype} ETA: $call->{eta})";
+ if($call->{status} eq 'Covered'){
+ $c->reply("Call <b>$callnr</b> $callinfo is covered.");
+ return;
+ }
+ }
+ $c->message(notice => $c->disp->targets->{members}, "DEFENSE REQUIRED!! WAKE UP!!");
+ $c->message(privmsg => $c->disp->targets->{members}, "DEFENSE REQUIRED "
+ ."$mess $callinfo MSG ".$c->nick." TO RESPOND");
+ }
+};
+
+command settype => {
+ help => q(Usage: .settype incId type | or: .settyp callId X:Y:Z type | or: .settypeall callId type),
+ type => q(def),
+ acl => q(irc_settype),
+ alias => q(settypeall),
+}, class extends NDIRC::Command {
+ use CGI;
+ method execute($c,$msg) {
+ my $dbh = $c->model;
+
+ my $query = q{
+SELECT inc,call,shiptype, coords(x,y,z),c.landing_tick - tick() AS eta
+FROM incomings i
+ JOIN current_planet_stats p USING (pid)
+ JOIN calls c USING (call)
+ };
+ my $fleets;
+ my $type;
+ my $call;
+
+ if ($self->name eq 'settypeall'){
+ ($call,$type) = $msg =~ /^(\d+) (.*)$/ or die 'ARGS';
+
+ $fleets = $dbh->prepare($query . q{
+WHERE call = ?
+ });
+ $fleets->execute($call);
+ }else{
+ my ($id,$x,$y,$z,$t) = $msg =~ /^(\d+) (\d+):(\d+):(\d+) (.*)$/;
+ if (defined $id){
+ $fleets = $dbh->prepare($query . q{
+WHERE call = ? AND pid = planetid(?,?,?,tick())
+ });
+ $fleets->execute($id,$x,$y,$z);
+ }else{
+ ($id,$t) = $msg =~ /^(\d+) (.*)$/ or die 'ARGS';
+ $fleets = $dbh->prepare($query . q{
+WHERE inc = ?
+ });
+ $fleets->execute($id);
+ }
+ $type = $t;
+ }
+
+ $type = CGI::escapeHTML($type);
+ $dbh->begin_work;
+ my $deflog = '';
+ my $settype = $dbh->prepare(q{UPDATE incomings SET shiptype = ? WHERE inc = ?});
+ while (my $inc = $fleets->fetchrow_hashref){
+ $call //= $inc->{call};
+ if ($inc->{eta} < 0){
+ $c->reply("This call is old. Did you use the call id instead of inc id by"
+ ." accident? You can use .settypeall callid to set the type on all incs"
+ ." in a call. Or use webbie if you really want to update this old call.");
+ $dbh->rollback;
+ return;
+ }
+ $settype->execute($type,$inc->{inc});
+ $deflog .= "Set fleet: [B]$inc->{inc} [/B] to: [B]$type [/B]\n";
+ $c->reply("Set fleet $inc->{inc} from $inc->{coords} on call $call to $type (previously $inc->{shiptype})");
+ }
+ if ($fleets->rows == 0){
+ $c->reply("No matching fleets");
+ $dbh->rollback;
+ }else{
+ $c->def_log($call,$deflog);
+ $dbh->commit;
+ }
+ }
+};
+
+command calltake => {
+ help => q(Usage: .calltake callid | sets the dc. also markes as covered/ignored with .callcov and .callignore),
+ type => q(def),
+ acl => q(irc_calltake),
+ alias => [qw/callcov callignore/],
+}, class extends NDIRC::Command {
+ method execute($c,$msg) {
+ my ($id) = $msg =~ /^(\d+)$/ or die 'ARGS';
+ my $dbh = $c->model;
+
+ my $status = 'Open';
+
+ given ($self->{name}){
+ when('callignore'){
+ $status = 'Ignored';
+ }
+ when('callcov'){
+ $status = 'Covered';
+ }
+ }
+
+ $dbh->begin_work;
+ my $rows = $dbh->do(q{
+UPDATE calls SET dc = $1
+ ,status = $3
+WHERE call = $2
+ },undef,$c->uid,$id,$status);
+ if ($rows == 1){
+ $c->reply("Setting status on call $id to $status");
+ $c->def_log($id , "Changed status: [B]$status [/B]");
+ $dbh->commit;
+ }else{
+ $c->reply("$id is not a valid call");
+ $dbh->rollback;
+ }
+ }
+};
+
+command setcalc => {
+ help => q(Usage: .setcalc callId calc | sets the calc for the given call.),
+ type => q(def),
+ acl => q(irc_setcalc),
+}, class extends NDIRC::Command {
+ use CGI;
+ method execute($c,$msg) {
+ my ($id,$calc) = $msg =~ /^(\d+) (.+)$/ or die 'ARGS';
+ my $dbh = $c->model;
+
+ $dbh->begin_work;
+ my $rows = $dbh->do(q{UPDATE calls SET calc = $2 WHERE call = $1}
+ ,undef,$id, $calc);
+ if ($rows == 1){
+ $c->reply("Updated calc call <b>$id</b>");
+ $calc = CGI::escapeHTML($calc);
+ $c->def_log($id , 'Updated calc to: [URL]'.$calc.'[/URL]');
+ $dbh->commit;
+ }else{
+ $c->reply("$id is not a valid call");
+ $dbh->rollback;
+ }
+ }
+};
+
+command getcalc => {
+ help => q(Usage: .getcalc callId | receives the calc for the given call),
+ type => q(def),
+ acl => q(irc_getcalc),
+}, class extends NDIRC::Command {
+ method execute($c,$msg) {
+ my ($id) = $msg =~ /^(\d+)$/ or die 'ARGS';
+ my $dbh = $c->model;
+
+ my $calc = $dbh->selectrow_array(q{
+SELECT calc FROM calls WHERE call = $1}
+ ,undef,$id);
+ $calc //= "Bad call id, there is no such call.";
+ $c->reply("Calc for call <b>$id</b>: $calc");
+ }
+};
+
+command report_incs => {
+ help => q(Used to report incs, same as pasting in pm. Use ~ prefix to send output to channel),
+ type => q(def),
+}, class extends NDIRC::Command {
+ use Try::Tiny;
+ method execute($c,$msg) {
+
+ $msg =~ /(\d+):(\d+):(\d+)\*?\s+(\d+):(\d+):(\d+)\s+([^:]*\S+)\s+(?:Ter|Cat|Xan|Zik|Etd)\s+([\d,]+)\s+(?:Attack\s+)?(\d+)/
+ || $msg =~ /(\d+):(\d+):(\d+)\s+(\d+):(\d+):(\d+)\s+\((?:Ter|Cat|Xan|Zik|Etd)\)\s+([^,]*\S+)\s+([\d,]+)\s+(\d+)\s+\(\d+\)/
+ or return;
+ my $dbh = $c->model;
+ my $amount = $8;
+ {
+ $amount =~ s/,//g;