use ND::Include;
use CGI qw/:standard/;
-our @ISA = qw/ND::Web::XMLPage/;
+use base qw/ND::Web::XMLPage/;
$ND::Web::Page::PAGES{intel} = __PACKAGE__;
if ($planet){
$BODY->param(Coords => $planet->{coords});
$BODY->param(Planet => $planet->{id});
- $BODY->param(Nick => $planet->{nick});
+ $BODY->param(Nick => escapeHTML($planet->{nick}));
$BODY->param(Channel => $planet->{channel});
my @status;
for my $status (" ","Friendly", "NAP", "Hostile"){
push @intellists,{Message => q{Intel where alliances doesn't match}, Intel => \@intel, Origin => 1, Target => 1};
$BODY->param(IntelLIsts => \@intellists);
}
- my $query = $DBH->prepare(q{SELECT i.id, u.username, i.message, report_date FROM intel_messages i
- JOIN users u ON u.uid = i.uid
- WHERE NOT handled ORDER BY report_date});
- $query->execute;
- my @messages;
- while (my $message = $query->fetchrow_hashref){
- $message->{message} = parseMarkup($message->{message});
- push @messages,$message;
- }
- #$BODY->param(IntelMessages => \@messages);
$BODY->param(Error => $error);
return $BODY;
}