Index: openacs-4/contrib/packages/events/www/admin/activity-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/activity-oracle.xql,v
diff -u -N
--- openacs-4/contrib/packages/events/www/admin/activity-oracle.xql	9 Mar 2003 12:08:22 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,50 +0,0 @@
-<?xml version="1.0"?>
-<queryset>
-
-    <fullquery name="select_org_roles">
-        <querytext>
-	select role, eor.role_id, 
-	       decode(public_role_p, 't', ' (public role)', '') as public_role_p
-	  from events_organizer_roles eor, events_org_role_activity_map eoram
-	 where eoram.activity_id = :activity_id
-	   and eoram.role_id = eor.role_id
-	 order by role 
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_activity_events">
-        <querytext>
-	select CASE WHEN to_char(t.start_date, 'YYYY-MM-DD') = to_char(t.end_date, 'YYYY-MM-DD') 
-	            THEN to_char(t.start_date, :date_format) || ' (' || to_char(t.start_date, :time_format) || ' - ' || to_char(t.end_date, :time_format) || ')'
-	            ELSE to_char(t.start_date, :date_format) || ' ' || to_char(t.start_date, :time_format) || ' - ' || to_char(t.end_date, :date_format) || ' ' || to_char(t.end_date, :time_format)
-	       END as timespan,
-               nvl(e.name, a.name) as name,	 
-               e.event_id,
-               v.city,
-	       v.usps_abbrev
-	  from acs_activities a,
-	       acs_events e,
-	       events_activities ea,
-	       events_events ee,
-	       timespans s,
-	       time_intervals t,
-	       events_venues v
-	 where e.timespan_id = s.timespan_id
-	   and s.interval_id = t.interval_id
-	   and e.activity_id = a.activity_id
-	   and a.activity_id = ea.activity_id
-	   and e.activity_id = :activity_id
-	   and e.event_id = ee.event_id
-	   and v.venue_id = ee.venue_id
-	   and ee.available_p = 't'
-	   and ea.package_id = :package_id
-	 order by t.start_date
-        </querytext>
-    </fullquery>
-
-</queryset>
-
-
-
-
-