Index: openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-memberships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-memberships-create.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-memberships-create.sql	6 Jul 2005 04:58:13 -0000	1.2
+++ openacs-4/packages/dotlrn-ecommerce/sql/oracle/dotlrn-ecommerce-memberships-create.sql	20 Jul 2005 03:22:35 -0000	1.3
@@ -137,8 +137,7 @@
 -- dc_instructor__new
  function new (
         rel_id in membership_rels.rel_id%TYPE default null,
-        rel_type in acs_rels.rel_type%TYPE default 'membership_rel',
-	portal_id in portals.portal_id%TYPE,
+        rel_type in acs_rels.rel_type%TYPE default 'dc_instructor_rel',
         community_id in dotlrn_communities.community_id%TYPE,	
 	user_id in users.user_id%TYPE,
         member_state in membership_rels.member_state%TYPE,
@@ -161,8 +160,7 @@
 -- dc_instructor_rel__new
  function new (
         rel_id in membership_rels.rel_id%TYPE default null,
-        rel_type in acs_rels.rel_type%TYPE default 'membership_rel',
-	portal_id in portals.portal_id%TYPE,
+        rel_type in acs_rels.rel_type%TYPE default 'dc_instructor_rel',
         community_id in dotlrn_communities.community_id%TYPE,
 	user_id in users.user_id%TYPE,
         member_state in membership_rels.member_state%TYPE,
Fisheye: Tag 1.3 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn-ecommerce/www/admin/setup.tcl'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/dotlrn-ecommerce/www/ecommerce/checkout-one-form-2-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/www/ecommerce/checkout-one-form-2-oracle.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn-ecommerce/www/ecommerce/checkout-one-form-2-oracle.xql	23 Jun 2005 12:28:22 -0000	1.1
+++ openacs-4/packages/dotlrn-ecommerce/www/ecommerce/checkout-one-form-2-oracle.xql	20 Jul 2005 03:22:35 -0000	1.2
@@ -1,6 +1,26 @@
+
+
+
+<?xml version="1.0"?>
+
+<queryset>
+  <rdbms>
+    <type>oracle</type>
+    <version>8.1.6</version>
+  </rdbms>
+
+  <fullquery name="insert_error_failed_gc_claim">      
+    <querytext>
+      insert into ec_problems_log (problem_id, problem_date, problem_details) values (ec_problem_id_sequence.nextval, current_timestamp,:prob_details )
     </querytext>
   </fullquery>
 
+  <fullquery name="update_ec_cert_set_user">      
+    <querytext>
+      update ec_gift_certificates set user_id=:user_id, claimed_date=current_timestamp where gift_certificate_id=:gift_certificate_id
+    </querytext>
+  </fullquery>
+
   <fullquery name="insert_other_claim_prob">      
     <querytext>
       insert into ec_problems_log
Index: openacs-4/packages/dotlrn-ecommerce/www/register/index.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn-ecommerce/www/register/index.tcl,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/dotlrn-ecommerce/www/register/index.tcl	7 Jul 2005 00:35:33 -0000	1.1
+++ openacs-4/packages/dotlrn-ecommerce/www/register/index.tcl	20 Jul 2005 03:22:36 -0000	1.2
@@ -35,7 +35,10 @@
 	ad_script_abort
 } else {
 	if { [exists_and_not_null community_id] } {
-		# register the user
+		# FIXME : put some error handling here
+		# make sure user is an approved dotlrn user
+		dotlrn::user_add -user_id $user_id
+		# register the user		
 		dotlrn_community::add_user $community_id $user_id
 		set reg_message "Thank you for registering.... <br /> <i>Placeholder for complete message</i>"
 	} else {