X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=check.pl;h=9acf9bf0d89d957189b3028a9c2dc7ba19db089b;hb=d2b25d79058863d3604489e7a36d1c0d1a491b5c;hp=788e93887fd25dee5b3ad2e12bca38a1004f9604;hpb=2786d1732fb6a4f729db332b49766e0f86e574be;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;