show some more galaxy information

[ndwebbie.git] / ND / Web / Pages / Intel.pm

diff --git a/ND/Web/Pages/Intel.pm b/ND/Web/Pages/Intel.pm
index 79cc0ce2d6ae8563f573ee16032f621fbaf29d12..c129d907c2109a465a28833533b54a6f0047ca8d 100644 (file)
--- a/ND/Web/Pages/Intel.pm
+++ b/ND/Web/Pages/Intel.pm
@@ -155,7 +155,7 @@ sub render_body {
        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"){
@@ -226,16 +226,6 @@ sub render_body {
                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;
 }