X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND.pm;h=25a798a7bbfded719463af8055a53f2f0ce11667;hb=accb7993672db2b43ee7a6feb1a0dcde4fe39e9b;hp=c54bb77a085b828793d0d6391594d932e10ba951;hpb=e4882eea4b46fcfb6c2a4a71bc4b69edd78835fa;p=ndwebbie.git

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());