Index: openacs-4/packages/forums/www/forum-view-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/forum-view-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/forums/www/forum-view-oracle.xql	3 Jun 2002 16:39:56 -0000	1.3
+++ openacs-4/packages/forums/www/forum-view-oracle.xql	6 Jun 2002 00:46:55 -0000	1.4
@@ -14,7 +14,8 @@
                     from forums_messages_approved fm1
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree.left(fm.tree_sortkey) and tree.right(fm.tree_sortkey)) as n_messages,
-                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified
+                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
+                   case when last_modified > (sysdate - 1) then 't' else 'f' end as new_p                   
             from forums_messages_approved fm,
                  acs_objects
             where fm.forum_id = :forum_id
@@ -36,7 +37,8 @@
                     from forums_messages fm1
                     where fm1.forum_id = :forum_id
                     and fm1.tree_sortkey between tree.left(fm.tree_sortkey) and tree.right(fm.tree_sortkey)) as n_messages,
-                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified
+                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
+                   case when last_modified > (sysdate - 1) then 't' else 'f' end as new_p                   
             from forums_messages fm,
                  acs_objects
             where fm.forum_id = :forum_id
Index: openacs-4/packages/forums/www/forum-view.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/forum-view.adp,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/forums/www/forum-view.adp	5 Jun 2002 14:43:52 -0000	1.5
+++ openacs-4/packages/forums/www/forum-view.adp	6 Jun 2002 00:46:55 -0000	1.6
@@ -61,7 +61,8 @@
   </else>
 
       <td>
-        <a href="message-view?message_id=@messages.message_id@">@messages.subject@</a>
+        <a href="message-view?message_id=@messages.message_id@">@messages.subject@</a> 
+<if @messages.new_p@ eq t><b><small>(new!)</small></b></if>
 <if @moderate_p@ and @messages.state@ ne approved>
         <small>(@messages.state@)</small>
 </if>
Index: openacs-4/packages/forums/www/index-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/index-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/forums/www/index-oracle.xql	3 Jun 2002 04:39:05 -0000	1.1
+++ openacs-4/packages/forums/www/index-oracle.xql	6 Jun 2002 00:46:55 -0000	1.2
@@ -10,7 +10,8 @@
                     from forums_messages
                     where forums_messages.forum_id = forums_forums_enabled.forum_id
                     and 1 = tree.tree_level(forums_messages.tree_sortkey)) as n_threads,
-                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified
+                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
+                   case when last_modified > (sysdate - 1) then 't' else 'f' end as new_p
             from forums_forums_enabled,
                  acs_objects
             where forums_forums_enabled.package_id = :package_id
Index: openacs-4/packages/forums/www/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/index.adp,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/forums/www/index.adp	5 Jun 2002 14:43:52 -0000	1.5
+++ openacs-4/packages/forums/www/index.adp	6 Jun 2002 00:46:55 -0000	1.6
@@ -38,6 +38,7 @@
 
       <td>
         <a href="forum-view?forum_id=@forums.forum_id@">@forums.name@</a>
+<if @forums.new_p@ eq t><b><small>(new postings!)</small></b></if>
         <if @forums.charter@ not nil><br><i>@forums.charter@</i></if>
       </td>
       <td align="center">@forums.n_threads@</td>