X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Def.pm;h=512d637a52ee7fbd10d9cafa4a10f5a29386a920;hb=5e02deb33fbdb994d72da23e8de85e633ec6654c;hp=7dbec8b1f761906ddc9b83ab80622d596b76524e;hpb=565ece6e27fa54253934518cc8c69ecfac9487e4;p=NDIRC.git diff --git a/Def.pm b/Def.pm index 7dbec8b..512d637 100644 --- a/Def.pm +++ b/Def.pm @@ -28,8 +28,8 @@ require Exporter; our @ISA = qw/Exporter/; -our @EXPORT = qw/showCall setType takeCall covCall ignoreCall - defcall setDefPrio setCalc getCalc/; +our @EXPORT = qw/showCall takeCall covCall ignoreCall + setDefPrio setCalc getCalc/; sub showCall { my ($msg,$command) = @_; @@ -58,157 +58,6 @@ SQL } } -sub setType { - my ($msg,$command) = @_; - my ($type,$id,$x,$y,$z) = @_; - if ($command eq 'settypeall'){ - if (defined $msg && $msg =~ /^(\d+) (.*)$/){ - $type = $2; - $id = $1 - }else{ - $ND::server->command("notice $ND::nick Usage: $command callId type"); - return; - } - }else{ - if (defined $msg && $msg =~ /^(\d+) (\d+):(\d+):(\d+) (.*)$/){ - $type = $5; - $id = $1; - $x = $2; - $y = $3; - $z = $4; - }elsif (defined $msg && $msg =~ /^(\d+) (.*)$/){ - $id = $1; - $type = $2; - }else{ - $ND::server->command("notice $ND::nick Usage: $command incId type | or: $command callId X:Y:Z type"); - return; - } - } - if (my $user = dc()){ - my $fleet; - my $query = qq{ - SELECT i.id,call,shiptype, coords(x,y,z),c.landing_tick - tick() FROM incomings i - JOIN current_planet_stats p ON i.sender = p.id - JOIN calls c ON i.call = c.id - }; - if ($command eq 'settypeall'){ - $fleet = $ND::DBH->prepare(qq{ - $query - WHERE i.call = ? - }); - $fleet->execute($id); - }elsif (defined $x){ - $fleet = $ND::DBH->prepare(qq{ - $query - WHERE i.call = ? AND p.id = planetid(?,?,?,tick()) - }); - $fleet->execute($id,$x,$y,$z); - }else{ - $fleet = $ND::DBH->prepare(qq{ - $query - WHERE i.id = ? - }); - $fleet->execute($id); - } - $type = escapeHTML($type); - while (my ($id,$call,$oldtype,$coords,$tick) = $fleet->fetchrow()){ - if($ND::DBH->do(q{UPDATE incomings SET shiptype = ? WHERE id = ?},undef,$type,$id) == 1){ - def_log $user->{uid}, $call , "Set fleet: [B] $id [/B] to: [B] $type [/B]"; - $ND::server->command("msg $ND::target Set fleet from $coords on call $call to $type (previously $oldtype)"); - if ($tick < 0 && not (defined $x && $x eq 'call')){ - $ND::server->command("msg $ND::target 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."); - } - } - } - } -} -sub takeCall { - my ($msg,$command) = @_; - my ($id); - if (defined $msg && $msg =~ /^(\d+)$/){ - $id = $1; - }else{ - $ND::server->command("notice $ND::nick Usage: $command callid"); - return; - } - if (my $user = dc()){ - if ($ND::DBH->do(q{UPDATE calls SET dc = (SELECT uid FROM users WHERE hostmask ILIKE ?) WHERE id = ?} - ,undef,$ND::address,$id) == 1){ - $ND::server->command("msg $ND::target Updated the DC for call $id"); - def_log $user->{uid}, $id , "Used: [B] $command [/B]"; - } - } -} - -sub covCall { - my ($msg,$command) = @_; - my ($id); - if (defined $msg && $msg =~ /^(\d+)$/){ - $id = $1; - }else{ - $ND::server->command("notice $ND::nick Usage: $command callid"); - return; - } - if (my $user = dc()){ - if($ND::DBH->do(q{UPDATE calls SET dc = (SELECT uid FROM users WHERE hostmask ILIKE ?), covered = TRUE, open = FALSE WHERE id = ?} - ,undef,$ND::address,$id) == 1){ - $ND::server->command("msg $ND::target Marked call $id as covered"); - def_log $user->{uid}, $id , "Used: [B] $command [/B]"; - } - } -} - -sub ignoreCall { - my ($msg,$command) = @_; - my ($id); - if (defined $msg && $msg =~ /^(\d+)$/){ - $id = $1; - }else{ - $ND::server->command("notice $ND::nick Usage: $command callid"); - return; - } - if (my $user = dc()){ - if($ND::DBH->do(q{UPDATE calls SET dc = (SELECT uid FROM users WHERE hostmask ILIKE ?), covered = FALSE, open = FALSE WHERE id = ?} - ,undef,$ND::address,$id) == 1){ - $ND::server->command("msg $ND::target Marked call $id as ignored"); - def_log $user->{uid}, $id , "Used: [B] $command [/B]"; - } - } -} - -sub defcall { - my ($msg,$command) = @_; - my ($mess,$nick,$callnr) = @_; - if (defined $msg && $msg =~ /^(\d+)?(.*)$/){ - $callnr = $1; - $mess = $2; - }else{ - $ND::server->command("notice $ND::nick Usage: $command [callid] message | if a call id is given, then shiptypes and eta will be fetched from the database and added to the message"); - return; - } - if (dc()){ - my $call = ""; - if ($callnr){ - my $st = $ND::DBH->prepare(q{ - SELECT c.landing_tick - (SELECT value::integer FROM misc WHERE id = 'TICK'), concat(i.shiptype||'/') AS shiptype - FROM calls c - JOIN incomings i ON i.call = c.id - LEFT OUTER JOIN users dc ON dc.uid = c.dc - JOIN users u ON u.uid = c.member - WHERE not covered AND c.id = ? - GROUP BY c.id,c.landing_tick - ORDER BY c.landing_tick; - }); - if (my @row = $ND::DBH->selectrow_array($st,undef,$callnr)){ - chop($row[1]); - $call = "(Anti $row[1] ETA: $row[0])" - } - } - $ND::server->command("notice $ND::memchan DEFENSE REQUIRED!! WAKE UP!!"); - $ND::server->command("msg $ND::memchan DEFENSE REQUIRED $mess $call MSG $ND::nick TO RESPOND"); - } -} - sub setCalc { my ($msg,$command) = @_; my ($id, $calc);