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
--- openacs-4/packages/forums/www/index-oracle.xql	16 Jan 2003 13:49:30 -0000	1.5
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,26 +0,0 @@
-<?xml version="1.0"?>
-
-<queryset>
-    <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
-
-    <fullquery name="select_forums">
-        <querytext>
-            select forums_forums_enabled.*,
-                   (select count(*)
-                    from forums_messages
-                    where forums_messages.forum_id = forums_forums_enabled.forum_id
-                    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
-            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(forums_forums_enabled.forum_id, :user_id, 'forum_read')
-                )
-            order by forums_forums_enabled.name
-        </querytext>
-    </fullquery>
-
-</queryset>