Index: openacs-4/contrib/packages/events/www/admin/activity-edit.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/activity-edit.xql,v
diff -u -N
--- openacs-4/contrib/packages/events/www/admin/activity-edit.xql	9 Mar 2003 12:08:22 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,25 +0,0 @@
-<?xml version="1.0"?>
-<queryset>
-
-    <fullquery name="activity_exists">
-	<querytext>
-	select 1
-	  from events_activities
-	 where activity_id = :activity_id
-        </querytext>
-    </fullquery>
-
-    <fullquery name="select_activity_info">
-        <querytext>
-		select a.name, 
-		a.description, 
-		ae.available_p,
-		ae.detail_url,
-		ae.default_contact_user_id
-		from   acs_activities a, events_activities ae
-		where  a.activity_id = :activity_id
-		and a.activity_id = ae.activity_id
-        </querytext>
-    </fullquery>
-
-</queryset>
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>
-
-
-
-
-
Index: openacs-4/contrib/packages/events/www/admin/activity-orders-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/activity-orders-postgresql.xql,v
diff -u -N
--- openacs-4/contrib/packages/events/www/admin/activity-orders-postgresql.xql	9 Mar 2003 12:08:22 -0000	1.1
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,74 +0,0 @@
-<?xml version="1.0"?>
-<queryset>
-
-	<fullquery name="select_activity_members">
-		<querytext>
-                select er.reg_id,
-                       person__name(er.user_id) as name,
-                       er.user_id,
-                       pa.email,
-                       er.reg_state,
-                       to_char(ao.creation_date, :date_format) || ' ' || to_char(ao.creation_date, :time_format) as creation_date,
-                       ae.event_id,
-                       ev.venue_name,
-                       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
-                  from events_registrations er,
-                       parties pa,
-                       acs_objects ao,
-                       acs_events ae,
-                       events_venues ev,
-                       events_events ee,
- 		       timespans s,
-	 	       time_intervals t
-                 where er.user_id = pa.party_id
-                   and ae.activity_id = :activity_id
-                   and ae.event_id = er.event_id
-                   and ae.event_id = ee.event_id
-                   and ee.venue_id = ev.venue_id
-                   and er.reg_state <> 'canceled'
-                   and er.reg_id = ao.object_id
-                   and ae.timespan_id = s.timespan_id
-		   and s.interval_id = t.interval_id
-              order by creation_date
-		</querytext>
-	</fullquery>
-
-	<fullquery name="select_specific_reg_type">
-		<querytext>
-                select er.reg_id,
-                       person__name(er.user_id) as name,
-                       er.user_id,
-                       pa.email,
-                       er.reg_state,
-                       to_char(ao.creation_date, :date_format) || ' ' || to_char(ao.creation_date, :time_format) as creation_date,
-                       ae.event_id,
-                       ev.venue_name,
-                       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
-                  from events_registrations er,
-                       parties pa,
-                       acs_objects ao,
-                       acs_events ae,
-                       events_venues ev,
-                       events_events ee,
- 		       timespans s,
-	 	       time_intervals t
-                 where er.user_id = pa.party_id
-                   and ae.activity_id = :activity_id
-                   and ae.event_id = er.event_id
-                   and ae.event_id = ee.event_id
-                   and ee.venue_id = ev.venue_id
-                   and er.reg_state = :specific_reg_type
-                   and er.reg_id = ao.object_id
-                   and ae.timespan_id = s.timespan_id
-		   and s.interval_id = t.interval_id
-              order by creation_date
-		</querytext>
-	</fullquery>
-
-</queryset>
Index: openacs-4/contrib/packages/events/www/admin/activity-orders.adp
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/activity-orders.adp,v
diff -u -N
--- openacs-4/contrib/packages/events/www/admin/activity-orders.adp	22 May 2003 13:52:52 -0000	1.2
+++ /dev/null	1 Jan 1970 00:00:00 -0000
@@ -1,90 +0,0 @@
-<master>
-<property name="title">@title;noquote@</property>
-<property name="context">@context;noquote@</property>
-
-<table cellpadding=3>
-<tr>
-  <th valign=top align=right width="50%">Activity</th>
-  <td valign=top width="50%"><a href="activity?activity_id=@activity_id@">@activity_info.name@</a></td>
-</tr>
-<tr>
-  <td colspan=2 align=center>
-        <table border=1 cellpadding=3 cellspacing=0>
-            <tr>
-                <td align="center"><a href="activity-orders?activity_id=@activity_id@&specific_reg_type=approved"><font color="green">Approved</font></a></td>
-                <td align="center"><a href="activity-orders?activity_id=@activity_id@&specific_reg_type=pending"><font color="red">Pending</font></a></td>
-                <td align="center"><a href="activity-orders?activity_id=@activity_id@&specific_reg_type=waiting"><font color="blue">Waiting</font></a></td>
-                <td align="center"><a href="activity-orders?activity_id=@activity_id@&specific_reg_type=canceled"><font color="gray">Canceled</font></a></td>
-            </tr>  
-            <tr>
-                <td align="center"><font color="green">@activity_stats.approved@</a></td>
-                <td align="center"><font color="red">@activity_stats.pending@</a></td>
-                <td align="center"><font color="blue">@activity_stats.waiting@</a></td>
-                <td align="center"><font color="gray">@activity_stats.canceled@</a></td>
-            </tr>
-        </table>
-
-  </td>
-</tr>
-<tr>
-  <td colspan=2>
-
-<if @activity_members:rowcount@ eq 0>
-	<ul>
-	  <li>No registrants fit this category
-	</ul>
-</if>
-
-<else>
-
-  <table cellpadding=5>
-   <tr>
-      <th>Location</th>
-      <th>Time</th>
-      <th>Reg. ID</th>
-      <th>Name</th>
-      <th>Email</th>
-      <th>Reg. Date</th>
-      <th>Reg. State</th>
-      <th></th>
-   </tr>
-
-    <multiple name=activity_members>
-	<tr>
-           <td>@activity_members.venue_name@</td>
-           <td><a href="event?event_id=@activity_members.event_id@">@activity_members.timespan@</a></td>
-           <td><a href="reg-view?reg_id=@activity_members.reg_id@">@activity_members.reg_id@</a></td>
-	   <td><a href="order-history-person?user_id=@activity_members.user_id@">@activity_members.name@</a></td>
-	   <td><a href="mailto:@activity_members.email@">@activity_members.email@</a></td>
-	   <td>@activity_members.creation_date@</td>
-           <td>
-
-        <if @activity_members.reg_state@ eq "approved">
-        <font color="green">@activity_members.reg_state@</font></td><td>
-           <a href="reg-waitlist?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">waitlist</a>
-           - <a href="reg-cancel?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">cancel</a> 
-        </if>
-        <if @activity_members.reg_state@ eq "waiting">
-        <font color="blue">@activity_members.reg_state@</font></td><td>
-<a href="reg-approve?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">approve</a> -
-            <a href="reg-cancel?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">cancel</a> 
-        </if>
-        <if @activity_members.reg_state@ eq "pending">
-        <font color="red">@activity_members.reg_state@</font></td><td>
-<a href="reg-approve?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">approve</a> -
-            <a href="reg-waitlist?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">waitlist</a>
-            - <a href="reg-cancel?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">cancel</a>
-        </if>
-        <if @activity_members.reg_state@ eq "canceled">
-        <font color="gray">@activity_members.reg_state@</font></td><td>
-<a href="reg-approve?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">approve</a> -
-            <a href="reg-waitlist?reg_id=@activity_members.reg_id@&return_url=activity-orders?activity_id=@activity_id@">waitlist</a>
-        </if>
-
-          </td>
-	</tr>
-    </multiple>
-  </table>
-</else>
-
-</td></tr></table>