X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;ds=sidebyside;f=ND%2FInclude.pm;fp=ND%2FInclude.pm;h=81f5a8db8fcbe73a84aa222fefca7f15fcd5991b;hb=86fb846b1b46198bd134e83b5c0488b5b8731ec2;hp=447c4f9bc9a8e7ac84b2d937afed3c74081c6217;hpb=1d23afde010bb3e998d2f2c2f2c60168b138aed5;p=ndwebbie.git diff --git a/ND/Include.pm b/ND/Include.pm index 447c4f9..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_visit + 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