Index: openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/lib/message/Attic/threads-chunk-postgresql.xql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	15 Mar 2005 20:06:45 -0000	1.3
+++ openacs-4/packages/forums/lib/message/threads-chunk-postgresql.xql	20 Nov 2006 20:00:25 -0000	1.3.2.1
@@ -26,9 +26,12 @@
                    fm.state,
                    $replies as n_messages,
                    to_char(fm.last_child_post, 'YYYY-MM-DD HH24:MI:SS') as last_child_post_ansi,
-                   case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p                   
-            from forums_messages_approved fm
+                   case when fm.last_child_post > (now() - interval '1 day') then 't' else 'f' end as new_p,
+	           u.screen_name                   
+            from   forums_messages_approved fm,
+		   users u
             where fm.forum_id = :forum_id
+	    and fm.user_id = u.user_id
             and fm.parent_id is null
             [template::list::page_where_clause -and -name messages -key fm.message_id]
             [template::list::orderby_clause -orderby -name messages]