Index: openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql 28 Feb 2008 06:51:49 -0000 1.3 +++ openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql 9 Nov 2008 23:29:27 -0000 1.4 @@ -12,7 +12,7 @@ where site_nodes.object_id = forums_forums.package_id) as url, forums_forums.forum_id, forums_forums.name, - case when last_post > (sysdate - 1) then 't' else 'f' end as new_p + $unread_or_new_query from forums_forums_enabled forums_forums, acs_objects where acs_objects.object_id = forums_forums.forum_id and @@ -23,4 +23,4 @@ - \ No newline at end of file +