X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FInclude.pm;h=81f5a8db8fcbe73a84aa222fefca7f15fcd5991b;hb=86fb846b1b46198bd134e83b5c0488b5b8731ec2;hp=9bfb05ed39ad6b5e860ccec1390b917e147dea4b;hpb=2d7464077ae805a1923bb4e2024afeb769f30e02;p=ndwebbie.git diff --git a/ND/Include.pm b/ND/Include.pm index 9bfb05e..81f5a8d 100644 --- a/ND/Include.pm +++ b/ND/Include.pm @@ -19,7 +19,7 @@ package ND::Include; use strict; -use warnings FATAL => 'all'; +use warnings; use CGI qw{:standard}; require Exporter; @@ -53,7 +53,7 @@ sub intel_log { sub unread_query { return $ND::DBH->prepare_cached(q{ - SELECT count(*) AS unread, max(ftv.time) AS last_vist + SELECT count(*) AS unread FROM forum_boards fb NATURAL JOIN 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