Index: openacs-4/packages/forums/lib/forums/forums-chunk-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/forums/Attic/forums-chunk-oracle.xql,v diff -u -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 (