Index: openacs-4/contrib/packages/events/www/admin/event-edit-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/event-edit-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/events/www/admin/event-edit-oracle.xql	9 Mar 2003 12:08:22 -0000	1.1
+++ openacs-4/contrib/packages/events/www/admin/event-edit-oracle.xql	18 Mar 2003 01:47:48 -0000	1.2
@@ -15,6 +15,25 @@
 	</querytext>
 </fullquery>
 
+<fullquery name="product_update">
+	<querytext>
+	update ec_products
+	set product_name='$activity_info(name) $date_time',
+	sku='event_$event_id',
+	one_line_description='$activity_info(name); $date_time; $pretty_location',
+	detailed_description='$activity_info(description)',
+	email_on_purchase_list=:email,
+	search_keywords='$activity_info(name), $venue_info(venue_name), $pretty_location',
+	url='$activity_info(detail_url)',
+	price=:event_price,
+	no_shipping_avail_p='t',
+	present_p='$event_info(available_p)',
+	available_date=sysdate,
+	$audit_update
+	where product_id=:product_id
+	</querytext>
+</fullquery>
+
 <fullquery name="audit_update_sql">
 	<querytext>
 	last_modified=sysdate, last_modifying_user=:user_id, modified_ip_address=:peeraddr
@@ -61,4 +80,4 @@
       </querytext>
 </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>
Index: openacs-4/contrib/packages/events/www/admin/event-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/event-edit-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/events/www/admin/event-edit-postgresql.xql	18 Mar 2003 00:22:58 -0000	1.2
+++ openacs-4/contrib/packages/events/www/admin/event-edit-postgresql.xql	18 Mar 2003 01:47:48 -0000	1.3
@@ -15,6 +15,26 @@
 	</querytext>
 </fullquery>
 
+<fullquery name="product_update">
+	<querytext>
+	update ec_products
+	set product_name='$activity_info(name) $date_time',
+	sku='event_$event_id',
+	one_line_description='$activity_info(name); $date_time; $pretty_location',
+	detailed_description='$activity_info(description)',
+	email_on_purchase_list=:email,
+	search_keywords='$activity_info(name), $venue_info(venue_name), $pretty_location',
+	url='$activity_info(detail_url)',
+	price=:event_price,
+	no_shipping_avail_p='t',
+	present_p='$event_info(available_p)',
+	available_date=now(),
+	$audit_update
+	where product_id=:product_id
+	</querytext>
+</fullquery>
+
+
 <fullquery name="audit_update_sql">
 	<querytext>
 	last_modified=current_timestamp, last_modifying_user=:user_id, modified_ip_address=:peeraddr
Index: openacs-4/contrib/packages/events/www/admin/event-edit.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/events/www/admin/Attic/event-edit.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/events/www/admin/event-edit.xql	9 Mar 2003 12:08:22 -0000	1.1
+++ openacs-4/contrib/packages/events/www/admin/event-edit.xql	18 Mar 2003 01:47:48 -0000	1.2
@@ -33,25 +33,6 @@
 	</querytext>
     </fullquery>
 
-    <fullquery name="product_update">
-	<querytext>
-	update ec_products
-	set product_name='$activity_info(name) $date_time',
-	sku='event_$event_id',
-	one_line_description='$activity_info(name); $date_time; $pretty_location',
-	detailed_description='$activity_info(description)',
-	email_on_purchase_list=:email,
-	search_keywords='$activity_info(name), $venue_info(venue_name), $pretty_location',
-	url='$activity_info(detail_url)',
-	price=:event_price,
-	no_shipping_avail_p='t',
-	present_p='$event_info(available_p)',
-	available_date=sysdate,
-	$audit_update
-	where product_id=:product_id
-	</querytext>
-    </fullquery>
-
     <fullquery name="delete_connecting">
 	<querytext>
 	delete from events_venues_conn_used_map where event_id=:event_id and package_id=[ad_conn package_id]
@@ -76,4 +57,4 @@
 	</querytext>
     </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>