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