X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=Commands%2FScans.pm;h=acfe9a90cbecb27f1b5012c24a7376be2093f6d5;hb=4c40fd39668614135ae9370092b5d17355bad15c;hp=70420e9a33d100492b24f029bafe1cb71bf37052;hpb=b87b6e87c3959096739e54bdf95c23d9e8212145;p=NDIRC.git
diff --git a/Commands/Scans.pm b/Commands/Scans.pm
index 70420e9..acfe9a9 100644
--- a/Commands/Scans.pm
+++ b/Commands/Scans.pm
@@ -54,10 +54,14 @@ sub gs
my $planet = $c->model->selectrow_array(q{SELECT planetid($1,$2,$3,tick())}
,undef,$x,$y,$z);
+ unless ($planet){
+ $c->reply("There is no planet with coords $x:$y:$z, try again after the tick.");
+ return;
+ }
my $query = $c->model->prepare(q{SELECT scan_id
FROM scans
- WHERE planet = $1 AND type = $2 AND tick >= tick()});
+ WHERE pid = $1 AND type = $2 AND tick >= tick()});
$query->execute($planet,$type);
if (my $scan = $query->fetchrow_hashref){
@@ -67,7 +71,7 @@ sub gs
my $req = $c->model->prepare(q{
SELECT * FROM scan_requests
WHERE uid = (SELECT uid FROM users WHERE hostmask ILIKE $1)
- AND planet = $2 AND type = $3 AND NOT sent
+ AND pid = $2 AND type = $3 AND NOT sent
});
$req->execute($c->host,$planet,$type);
@@ -81,7 +85,7 @@ WHERE id = $2
$id = $scan->{id};
}else{
$req = $c->model->prepare(q{
-INSERT INTO scan_requests (uid,nick,planet,type)
+INSERT INTO scan_requests (uid,nick,pid,type)
VALUES((SELECT uid FROM users WHERE hostmask ILIKE $1),$2,$3,$4) RETURNING (id)
});
$req->execute($c->host,$c->nick,$planet,$type);
@@ -89,7 +93,7 @@ VALUES((SELECT uid FROM users WHERE hostmask ILIKE $1),$2,$3,$4) RETURNING (id)
}
if ($id){
- $c->message("msg $ND::scanchan"
+ $c->message(privmsg => $ND::scanchan
,"$id http://game.planetarion.com/waves.pl?id=$typeid&x=$x&y=$y&z=$z"
. " ($x:$y:$z $type) | <".$c->nick."> $msg"
);
@@ -124,10 +128,10 @@ sub scanreqs
my $reqs = $c->model->prepare(q{
SELECT min(sr.id) AS id, x,y,z,type
FROM scan_requests sr
- JOIN current_planet_stats p ON p.id = sr.planet
+ JOIN current_planet_stats p USING (pid)
WHERE sr.time > NOW() - '30 min'::INTERVAL
AND NOT EXISTS (SELECT scan_id FROM scans
- WHERE planet = sr.planet
+ WHERE pid = sr.pid
AND type = sr.type
AND tick >= sr.tick
)
@@ -157,7 +161,7 @@ sub scan
my $scan = $c->model->selectrow_hashref(q{
SELECT id, scan_id, tick FROM scans
-WHERE type = $1 AND planet = planetid($2,$3,$4,0) AND COALESCE(tick < $5,TRUE)
+WHERE type = $1 AND pid = planetid($2,$3,$4,0) AND COALESCE(tick < $5,TRUE)
ORDER BY tick DESC LIMIT 1
},undef,$type,$x,$y,$z,$tick);
unless ($scan->{id}){
@@ -194,9 +198,11 @@ sub anon
my ($self, $c, $msg) = @_;
my ($target,$mess) = $msg =~ /^(\S+) (.*)$/ or die 'ARGS';
- $c->message("msg $target", "$mess (reply with /msg $ND::scanchan)");
- $c->message("msg $ND::scanchan", "$target << $mess");
+ $c->message(privmsg => $target, "$mess (reply with /msg "
+ .$c->channel.")");
+ $c->message(privmsg => $c->channel, "$target << $mess");
}
+
sub addscan
: Help(syntax: .addscan list of scans)
{