From a046de4c8ad5879008a11ad1b9807d6a2e5cc9c0 Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Sun, 4 Oct 2009 10:32:59 +0200 Subject: [PATCH] Update retal raid script for the new infrastructure --- scripts/createretal.pl | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/scripts/createretal.pl b/scripts/createretal.pl index e2f8688..6ee3ef4 100755 --- a/scripts/createretal.pl +++ b/scripts/createretal.pl @@ -43,17 +43,17 @@ $query->finish; print "$raid\n"; -$dbh->do(q{INSERT INTO raid_access (raid,gid) VALUES(?,2)} +$dbh->do(q{INSERT INTO raid_access (raid,gid) VALUES(?,'M')} ,undef,$raid); -my $addtarget = $dbh->prepare(q{INSERT INTO raid_targets(raid,planet,comment) +my $addtarget = $dbh->prepare(q{INSERT INTO raid_targets(raid,pid,comment) VALUES($1,$2,$3)}); my $incs = $dbh->prepare(q{SELECT pid,array_agg(i.eta) AS eta,array_agg(amount) AS amount ,array_agg(shiptype) AS type,array_agg(fleet) AS name,array_agg(c.landing_tick) AS landing FROM calls c - JOIN incomings i ON i.call = c.id - WHERe NOT c.covered AND c.landing_tick BETWEEN tick() AND tick() + 6 + JOIN incomings i USING (call) + WHERE c.status <> 'Covered' AND c.landing_tick BETWEEN tick() AND tick() + 6 AND c.landing_tick + GREATEST(i.eta,7) > tick() + 10 GROUP BY pid }); -- 2.39.2