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 -N -r1.2 -r1.3 --- openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql 13 Jan 2005 13:58:18 -0000 1.2 +++ openacs-4/packages/forums-portlet/www/forums-portlet-oracle.xql 28 Feb 2008 06:51:49 -0000 1.3 @@ -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_modified > (sysdate - 1) then 't' else 'f' end as new_p + case when last_post > (sysdate - 1) then 't' else 'f' end as new_p from forums_forums_enabled forums_forums, acs_objects where acs_objects.object_id = forums_forums.forum_id and