From accb7993672db2b43ee7a6feb1a0dcde4fe39e9b Mon Sep 17 00:00:00 2001
From: Michael Andreen <harv@ruin.nu>
Date: Tue, 2 Jan 2007 14:01:39 +0000
Subject: [PATCH] number of unread posts in in menu

---
 ND.pm               | 6 ++++++
 templates/skel.tmpl | 2 +-
 2 files changed, 7 insertions(+), 1 deletion(-)

diff --git a/ND.pm b/ND.pm
index c54bb77..25a798a 100755
--- a/ND.pm
+++ b/ND.pm
@@ -113,6 +113,12 @@ sub page {
 
 		$fleetupdate = 0 unless defined $fleetupdate;
 
+		my ($unread) = $DBH->selectrow_array(q{SELECT count(NULLIF(COALESCE(fp.time > ftv.time,TRUE),FALSE)) AS unread
+FROM forum_threads ft JOIN forum_posts fp USING (ftid) LEFT OUTER JOIN 
+	(SELECT * FROM forum_thread_visits WHERE uid = $1) ftv ON ftv.ftid = ft.ftid
+			},undef,$UID) or $ERROR .= p($DBH->errstr);
+
+		$TEMPLATE->param(UnreadPosts => $unread);
 		$TEMPLATE->param(Tick => $TICK);
 		$TEMPLATE->param(isMember => (($TICK - $fleetupdate < 24) || isScanner()) && $PLANET && isMember());
 		$TEMPLATE->param(isHC => isHC());
diff --git a/templates/skel.tmpl b/templates/skel.tmpl
index b42a860..3cd0fb4 100644
--- a/templates/skel.tmpl
+++ b/templates/skel.tmpl
@@ -14,7 +14,7 @@
 		<ul class="linkbar">
 			<li><a href="main">Main page</a></li>
 			<li><a href="forum">Forum</a></li>
-			<li><a href="forum?allUnread=1">New posts</a></li>
+			<li><a href="forum?allUnread=1">New posts (<TMPL_VAR NAME=UnreadPosts>)</a></li>
 		</ul>	<p>Tick: <TMPL_VAR NAME=TICK></p>
 		<TMPL_IF isMEMBER>
 		<p>Member menu</p>
-- 
2.39.2