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+)/
FROM current_planet_stats WHERE x = ? AND y = ? AND z = ?
});
if (my @attacker = $dbh->selectrow_array($st,undef,$4,$5,$6)){
- $dbh->begin_work;
- my $landing_tick = $dbh->selectrow_array(q{SELECT tick() + ?},undef,$9);
- my @call = $dbh->selectrow_array(q{
+ try {
+ $dbh->begin_work;
+ my $landing_tick = $dbh->selectrow_array(q{SELECT tick() + ?},undef,$9);
+ my @call = $dbh->selectrow_array(q{
SELECT call,status,calc
FROM calls WHERE uid = ? AND landing_tick = ?
- },undef,$user->{uid},$landing_tick);
- my $threefleeter = $dbh->selectrow_array(q{
+ },undef,$user->{uid},$landing_tick);
+ my $threefleeter = $dbh->selectrow_array(q{
SELECT COALESCE(gid = 'X',false)
FROM groupmembers WHERE uid = ? AND gid = 'X'
- },undef,$user->{uid});
- unless (@call){ #call doesn't exists, create a new one
- @call = $dbh->selectrow_array(q{
+ },undef,$user->{uid});
+ unless (@call){ #call doesn't exists, create a new one
+ @call = $dbh->selectrow_array(q{
INSERT INTO calls (uid,landing_tick,info) VALUES(?,?,'') RETURNING call,status,calc
- },undef,$user->{uid},$landing_tick);
- if ($threefleeter){
- $dbh->do(q{UPDATE calls SET status = 'Ignored' WHERE call = $1},undef,$call[0]);
- $c->def_log($call[0], 'This member has been marked as [B]NoDef[/B], do [B]not cover[/B] unless you have a good reaon.');
- $call[1] = 'Ignored';
+ },undef,$user->{uid},$landing_tick);
+ if ($threefleeter){
+ $dbh->do(q{UPDATE calls SET status = 'Ignored' WHERE call = $1},undef,$call[0]);
+ $c->def_log($call[0], 'This member has been marked as [B]NoDef[/B], do [B]not cover[/B] unless you have a good reaon.');
+ $call[1] = 'Ignored';
+ }
}
- }
- if (@call){
my $pointlimits = $dbh->prepare(q{SELECT value :: float FROM misc WHERE id = ?});
my ($minpoints) = $dbh->selectrow_array($pointlimits,undef,'DEFMINPRIO');
my ($maxpoints) = $dbh->selectrow_array($pointlimits,undef,'DEFMAXPRIO');
if ($fleetcatch > 0){
$c->reply("<c04>THIS IS A POSSIBLE FLEETCATCH!</c>");
}
- }
- $dbh->commit;
+ $dbh->commit;
+ } catch {
+ $dbh->rollback;
+ die $_;
+ };
}else{
$c->reply("<c04>Didn't find any planet with coordinates $4:$5:$6 at this tick</c>");
}