Index: openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql,v
diff -u -N -r1.2 -r1.3
--- openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	13 Jan 2005 13:58:14 -0000	1.2
+++ openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql	4 Jun 2007 12:24:32 -0000	1.3
@@ -8,7 +8,7 @@
             select forums_forums_enabled.*,
                    approved_thread_count as n_threads,
                    to_char(last_post, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
-                   case when last_post > (sysdate - 1) then 't' else 'f' end as new_p
+		   $unread_or_new_query
             from forums_forums_enabled
             where forums_forums_enabled.package_id = :package_id
             and (