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.4 -r1.5
--- openacs-4/packages/forums/www/index-oracle.xql	30 Nov 2002 17:35:39 -0000	1.4
+++ openacs-4/packages/forums/www/index-oracle.xql	16 Jan 2003 13:49:30 -0000	1.5
@@ -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, 'YYYY-MM-DD HH24:MI:SS') as last_post_ansi,
                    case when last_post > (sysdate - 1) then 't' else 'f' end as new_p
             from forums_forums_enabled