X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=check.pl;fp=check.pl;h=9acf9bf0d89d957189b3028a9c2dc7ba19db089b;hb=354c2fb813a139fb08476b6d0e7f30308091038a;hp=788e93887fd25dee5b3ad2e12bca38a1004f9604;hpb=c10765bfab69c9d2abdb96bf05a6662088cf8b3f;p=ndwebbie.git diff --git a/check.pl b/check.pl index 788e938..9acf9bf 100644 --- a/check.pl +++ b/check.pl @@ -18,6 +18,8 @@ #**************************************************************************/ use strict; +use warnings FATAL => 'all'; +no warnings qw(uninitialized); $ND::TEMPLATE->param(TITLE => 'Check planets and galaxies'); @@ -121,7 +123,7 @@ ORDER BY p.x,p.y,p.z}); $BODY->param(Missions => \@missions); my @scans; - my $query = $DBH->prepare(q{SELECT value,tick FROM planet_stats + $query = $DBH->prepare(q{SELECT value,tick FROM planet_stats WHERE id = ? AND tick > tick() - 24}); my $scan = q{

Value the last 24 ticks

@@ -138,8 +140,8 @@ ORDER BY p.x,p.y,p.z}); $scan .= q{}; push @scans, {Scan => $scan}; - my $query = $DBH->prepare(q{SELECT x,y,z,tick FROM planet_stats WHERE id = ?}); - my $scan = q{ + $query = $DBH->prepare(q{SELECT x,y,z,tick FROM planet_stats WHERE id = ?}); + $scan = q{

Previous Coords

}; $query->execute($planet_id); @@ -155,7 +157,7 @@ ORDER BY p.x,p.y,p.z}); $scan .= q{
TickValueDifference
}; push @scans, {Scan => $scan}; - my $query = $DBH->prepare(q{SELECT DISTINCT ON (type) type,scan_id, tick, scan FROM scans WHERE planet = ? + $query = $DBH->prepare(q{SELECT DISTINCT ON (type) type,scan_id, tick, scan FROM scans WHERE planet = ? GROUP BY type,scan_id, tick, scan ORDER BY type,tick DESC}); $query->execute($planet_id); my %scans;