X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FWeb%2FPages%2FIntel.pm;h=c129d907c2109a465a28833533b54a6f0047ca8d;hb=f6cfe40e6a8da61229131a2d38a2535ae66da359;hp=79cc0ce2d6ae8563f573ee16032f621fbaf29d12;hpb=571b019af4b9e3e051447f82135bb630a4fb4db8;p=ndwebbie.git

diff --git a/ND/Web/Pages/Intel.pm b/ND/Web/Pages/Intel.pm
index 79cc0ce..c129d90 100644
--- 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;
 }