From ed9a83a68355a5f7ff3a71e6d9a463c058422fc6 Mon Sep 17 00:00:00 2001
From: Michael Andreen <harv@ruin.nu>
Date: Fri, 26 Jan 2007 16:42:25 +0000
Subject: [PATCH] removed intel_messages table all together

---
 ND/Web/Pages/Intel.pm | 10 ----------
 templates/intel.tmpl  | 17 -----------------
 2 files changed, 27 deletions(-)

diff --git a/ND/Web/Pages/Intel.pm b/ND/Web/Pages/Intel.pm
index 79cc0ce..44fbba3 100644
--- a/ND/Web/Pages/Intel.pm
+++ b/ND/Web/Pages/Intel.pm
@@ -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;
 }
diff --git a/templates/intel.tmpl b/templates/intel.tmpl
index 2a3f12a..b872faf 100644
--- a/templates/intel.tmpl
+++ b/templates/intel.tmpl
@@ -122,23 +122,6 @@
 </table>
 </TMPL_LOOP>
 
-<table border="1">
-	<tr>
-	<th>Reported by</th>
-	<th>Report time</th>
-	<th>Message</th>
-	<th></th>
-	</tr>
-	<TMPL_LOOP IntelMessages>
-	<tr>
-		<td><TMPL_VAR NAME=Username></td>
-		<td><TMPL_VAR NAME=Report_date></td>
-		<td><TMPL_VAR NAME=Message></td>
-		<td><a href="/<TMPL_VAR NAME=PAGE>?handle=<TMPL_VAR NAME=Id>">remove</a></td>
-	</tr>
-	</TMPL_LOOP>
-</table>
-
 	<form action="<TMPL_VAR NAME=PAGE>" method="post"><fieldset> <legend>Coords</legend>
 	<p>Paste a list of coords here</p>
 	<textarea rows="25" cols="80" name="coords"></textarea>
-- 
2.39.2