Index: openacs.org-dev/packages/forums/www/forum-view-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/forum-view-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs.org-dev/packages/forums/www/forum-view-postgresql.xql	2 Nov 2002 13:57:03 -0000	1.5
+++ openacs.org-dev/packages/forums/www/forum-view-postgresql.xql	11 Dec 2002 16:37:18 -0000	1.6
@@ -14,13 +14,11 @@
                     from $forums_table 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 FMHH24:MI') as last_modified,
-                   case when acs_objects.last_modified > (now() - 1) then 't' else 'f' end as new_p                   
-            from forums_messages_approved fm,
-                 acs_objects
+		    to_char(fm.last_child_post, 'Mon DD YYYY HH24:MI:SS') as last_child_post,
+                    case when fm.last_child_post > (now() - 1) then 't' else 'f' end as new_p
+            from forums_messages_approved fm
             where fm.forum_id = :forum_id
             and fm.parent_id is null
-            and fm.message_id = acs_objects.object_id
             order by fm.posting_date desc
         </querytext>
     </fullquery>
@@ -37,13 +35,11 @@
                     from $forums_table 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,
-                   case when acs_objects.last_modified > (now() - 1) then 't' else 'f' end as new_p                   
-            from forums_messages fm,
-                 acs_objects
+	            to_char(fm.last_child_post, 'Mon DD YYYY HH24:MI:SS') as last_child_post,
+                    case when fm.last_child_post > (now() - 1) then 't' else 'f' end as new_p
+            from forums_messages fm
             where fm.forum_id = :forum_id
             and fm.parent_id is null
-            and fm.message_id = acs_objects.object_id
 	    and fm.message_id IN (CURRENT_PAGE_SET)
             order by fm.posting_date desc
         </querytext>
Index: openacs.org-dev/packages/forums/www/forum-view.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/forum-view.adp,v
diff -u -r1.12 -r1.13
--- openacs.org-dev/packages/forums/www/forum-view.adp	18 Nov 2002 17:00:21 -0000	1.12
+++ openacs.org-dev/packages/forums/www/forum-view.adp	11 Dec 2002 16:37:18 -0000	1.13
@@ -116,7 +116,7 @@
           </td>
           <td style="padding: 4px;"><a href="user-history?user_id=@messages.user_id@">@messages.user_name@</a></td>
           <td align="center" style="padding: 4px;">@messages.n_messages@</td>
-          <td align="center" style="padding: 4px;">@messages.last_modified@</td>
+          <td align="center" style="padding: 4px;">@messages.last_child_post@</td>
           
             </tr>
         </multiple>
Index: openacs.org-dev/packages/forums/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/index-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs.org-dev/packages/forums/www/index-postgresql.xql	28 Oct 2002 20:45:29 -0000	1.2
+++ openacs.org-dev/packages/forums/www/index-postgresql.xql	11 Dec 2002 16:37:18 -0000	1.3
@@ -10,17 +10,15 @@
                     from forums_messages
                     where forums_messages.forum_id = forums_forums_enabled.forum_id
                     and 1 = tree_level(forums_messages.tree_sortkey)) as n_threads,
-                   to_char(acs_objects.last_modified, 'Mon DD YYYY HH24:MI:SS') as last_modified,
-                   case when last_modified > (now() - 1) then 't' else 'f' end as new_p
-            from forums_forums_enabled,
-                 acs_objects
+                    to_char(last_post, 'Mon DD YYYY HH24:MI:SS') as last_post,
+ 		    case when last_post > (now() - 1) then 't' else 'f' end as new_p
+            from forums_forums_enabled
             where forums_forums_enabled.package_id = :package_id
             and (
                     forums_forums_enabled.posting_policy = 'open'
                  or forums_forums_enabled.posting_policy = 'moderated'
                  or 't' = acs_permission__permission_p(:user_id, forums_forums_enabled.forum_id, 'forum_read')
                 )
-            and forums_forums_enabled.forum_id = acs_objects.object_id
             order by forums_forums_enabled.forum_id
         </querytext>
     </fullquery>
Index: openacs.org-dev/packages/forums/www/index.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/index.adp,v
diff -u -r1.4 -r1.5
--- openacs.org-dev/packages/forums/www/index.adp	18 Nov 2002 17:00:21 -0000	1.4
+++ openacs.org-dev/packages/forums/www/index.adp	11 Dec 2002 16:37:18 -0000	1.5
@@ -56,7 +56,7 @@
         </td>
         <td align="center">
           <if @forums.n_threads@ gt 0>
-            @forums.last_modified@
+            @forums.last_post@
           </if>
         </td>
           </tr>
Index: openacs.org-dev/packages/forums/www/admin/forum-new.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs.org-dev/packages/forums/www/admin/forum-new.tcl,v
diff -u -r1.2 -r1.3
--- openacs.org-dev/packages/forums/www/admin/forum-new.tcl	5 Sep 2002 17:27:49 -0000	1.2
+++ openacs.org-dev/packages/forums/www/admin/forum-new.tcl	11 Dec 2002 16:37:30 -0000	1.3
@@ -73,7 +73,7 @@
     ad_script_abort
 }
 
-set context_bar [list "Create New Forum"]
+set context [list "Create New Forum"]
 
 if { [form is_request forum] } {
     # Pre-fetch the forum_id