X-Git-Url: https://ruin.nu/git/?a=blobdiff_plain;f=ND%2FInclude.pm;fp=ND%2FInclude.pm;h=447c4f9bc9a8e7ac84b2d937afed3c74081c6217;hb=c40e4fc03a03ea18f7fd51fbacffec9e9a8755d2;hp=9bfb05ed39ad6b5e860ccec1390b917e147dea4b;hpb=2d7464077ae805a1923bb4e2024afeb769f30e02;p=ndwebbie.git diff --git a/ND/Include.pm b/ND/Include.pm index 9bfb05e..447c4f9 100644 --- a/ND/Include.pm +++ b/ND/Include.pm @@ -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, max(ftv.time) AS last_visit 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