Index: openacs-4/packages/forums/www/forum-view.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/forum-view.tcl,v
diff -u -N -r1.8.2.1 -r1.8.2.2
--- openacs-4/packages/forums/www/forum-view.tcl	28 Nov 2002 15:53:19 -0000	1.8.2.1
+++ openacs-4/packages/forums/www/forum-view.tcl	17 Dec 2002 10:49:38 -0000	1.8.2.2
@@ -66,7 +66,10 @@
     set query messages_select_moderator
 }
 
-db_multirow messages $query {} {set subject [ad_quotehtml $subject]}
+db_multirow messages $query {} {
+    set subject [ad_quotehtml $subject]
+    set user_name [ad_quotehtml $user_name]
+}
 
 set notification_chunk [notification::display::request_widget \
     -type forums_forum_notif \
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 -N -r1.2.2.2 -r1.2.2.3
--- openacs-4/packages/forums/www/index-oracle.xql	22 Nov 2002 18:38:32 -0000	1.2.2.2
+++ openacs-4/packages/forums/www/index-oracle.xql	17 Dec 2002 10:49:38 -0000	1.2.2.3
@@ -9,7 +9,7 @@
                    (select count(*)
                     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,
+                    and parent_id is null) as n_threads,
                    to_char(last_post, 'Mon DD YYYY HH24:MI:SS') as last_post,
                    case when last_post > (sysdate - 1) then 't' else 'f' end as new_p
             from forums_forums_enabled
Index: openacs-4/packages/forums/www/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/www/Attic/index-postgresql.xql,v
diff -u -N -r1.2.2.2 -r1.2.2.3
--- openacs-4/packages/forums/www/index-postgresql.xql	22 Nov 2002 18:38:32 -0000	1.2.2.2
+++ openacs-4/packages/forums/www/index-postgresql.xql	17 Dec 2002 10:49:38 -0000	1.2.2.3
@@ -9,7 +9,7 @@
                    (select count(*)
                     from forums_messages
                     where forums_messages.forum_id = forums_forums_enabled.forum_id
-                    and 1 = tree_level(forums_messages.tree_sortkey)) as n_threads,
+                    and parent_id is null) as n_threads,
                    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