From dc81321bd4e70412bceec703610129ee7cecc4ee Mon Sep 17 00:00:00 2001 From: Michael Andreen Date: Fri, 19 Jan 2007 12:20:18 +0000 Subject: [PATCH] planet naps class --- ND/Web/Pages/PlanetNaps.pm | 21 ++++++++------------- startup.pl | 2 +- 2 files changed, 9 insertions(+), 14 deletions(-) diff --git a/ND/Web/Pages/PlanetNaps.pm b/ND/Web/Pages/PlanetNaps.pm index 13aafb5..5e0f850 100644 --- a/ND/Web/Pages/PlanetNaps.pm +++ b/ND/Web/Pages/PlanetNaps.pm @@ -23,24 +23,19 @@ use warnings FATAL => 'all'; use CGI qw/:standard/; use ND::Web::Include; -$ND::PAGES{planetNaps} = {parse => \&parse, process => \&process, render=> \&render}; +our @ISA = qw/ND::Web::XMLPage/; -sub parse { - my ($uri) = @_; -} - -sub process { +$ND::Web::Page::PAGES{planetNaps} = __PACKAGE__; -} +sub render_body { + my $self = shift; + my ($BODY) = @_; + $self->{TITLE} = 'List planet naps'; + my $DBH = $self->{DBH}; -sub render { - my ($DBH,$BODY) = @_; + return $self->noAccess unless $self->isHC; my $error; - $ND::TEMPLATE->param(TITLE => 'List planet naps'); - - return $ND::NOACCESS unless isHC(); - my $query = $DBH->prepare(qq{Select coords(x,y,z), ((ruler || ' OF ') || p.planet) as planet,race, size, score, value, xp, sizerank, scorerank, valuerank, xprank, p.value - p.size*200 - coalesce(c.metal+c.crystal+c.eonium,0)/150 - coalesce(c.structures,(SELECT avg(structures) FROM covop_targets)::int)*1500 AS fleetvalue,(c.metal+c.crystal+c.eonium)/100 AS resvalue, planet_status,hit_us, alliance,relationship,nick from current_planet_stats p LEFT OUTER JOIN covop_targets c ON p.id = c.planet WHERE planet_status IN ('Friendly','NAP') order by x,y,z asc}); $query->execute or $error .= p($DBH->errstr); diff --git a/startup.pl b/startup.pl index f0074e0..dc3ab6c 100644 --- a/startup.pl +++ b/startup.pl @@ -43,7 +43,7 @@ use ND::Web::Pages::Intel; use ND::Web::Pages::Alliances; use ND::Web::Pages::MemberIntel; use ND::Web::Pages::Resources; -#use ND::Web::Pages::PlanetNaps; +use ND::Web::Pages::PlanetNaps; #use ND::Web::Pages::Motd; #use ND::Web::Pages::Forum; #use ND::Web::Pages::Settings; -- 2.39.2