Index: openacs-4/packages/ecommerce/www/register/awaiting-approval.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/awaiting-approval.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/awaiting-approval.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,20 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="register_member_state_information">      
+      <querytext>
+      select member_state, email, email_verified_p, rel_id
+from cc_users where user_id = :user_id 
+and  (member_state is null or member_state = 'rejected')
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="register_member_state_authorized_set">      
+      <querytext>
+      update membership_rels set member_state = 'approved' where rel_id = :rel_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/awaiting-email-verification-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/awaiting-email-verification-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/awaiting-email-verification-oracle.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="register_user_state_properties">      
+      <querytext>
+      
+    select member_state, email, rowid 
+    from cc_users
+    where user_id = :user_id and
+    email_verified_p = 'f' 
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/awaiting-email-verification-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/awaiting-email-verification-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/awaiting-email-verification-postgresql.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,17 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="register_user_state_properties">      
+      <querytext>
+      
+    select member_state, email, oid as oid as rowid 
+    from cc_users
+    where user_id = :user_id and
+    email_verified_p = 'f' 
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/awaiting-email-verification.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/awaiting-email-verification.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/awaiting-email-verification.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="register_member_state_authorized_set">      
+      <querytext>
+      update users set 
+email_verified_p = 't'
+where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/banned-user.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/banned-user.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/banned-user.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="register_banned_member_state">      
+      <querytext>
+      
+    select member_state from cc_users 
+    where user_id = :user_id 
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/deleted-user.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/deleted-user.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/deleted-user.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="register_deleted_member_state">      
+      <querytext>
+      
+    select member_state from cc_users where user_id = :user_id
+
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/email-confirm.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/email-confirm.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/email-confirm.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,22 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="register_email_user_update">      
+      <querytext>
+      update users 
+                        set email_verified_p = 't'
+                        where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="register_email_confirm_update3">      
+      <querytext>
+      update users
+                        set email_verified_p = 't'
+                        where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/email-password-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/email-password-2.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/email-password-2.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,27 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="users_state_authorized_or_deleted">      
+      <querytext>
+      select 
+email from cc_users where user_id=:user_id
+-- and user_state in ('authorized','deleted')
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="password_answer">      
+      <querytext>
+      select password_answer from users where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="first_last_name">      
+      <querytext>
+      select first_names db_first_names, last_name db_last_name from cc_users where user_id = $user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/email-password-3.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/email-password-3.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/email-password-3.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,18 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="first_last_names">      
+      <querytext>
+      select first_names db_first_names, last_name db_last_name, password_question from cc_users where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="update_question">      
+      <querytext>
+      update users set password_question = :question, password_answer = :answer where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/email-password.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/email-password.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/email-password.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,11 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="question">      
+      <querytext>
+      select password_question from users where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/restore-user.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/restore-user.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/restore-user.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,24 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="user_state_info">      
+      <querytext>
+      
+    select member_state, email, rel_id from cc_users where user_id = :user_id
+
+      </querytext>
+</fullquery>
+
+ 
+<fullquery name="member_state_authorized_transistion">      
+      <querytext>
+      
+	update membership_rels
+	set member_state = 'approved'  
+	where rel_id = :rel_id
+    
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/user-login.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/user-login.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/user-login.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,14 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="user_login_user_id_from_email">      
+      <querytext>
+      
+    select user_id, member_state, email_verified_p
+    from cc_users
+    where email = :email
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/user-new-2-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/user-new-2-oracle.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/user-new-2-oracle.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
+
+<fullquery name="user_new_2_rowid_for_email">      
+      <querytext>
+      select rowid from users where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/user-new-2-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/user-new-2-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/user-new-2-postgresql.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,13 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="user_new_2_rowid_for_email">      
+      <querytext>
+      select oid as rowid from users where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>
Index: openacs-4/packages/ecommerce/www/register/user-new-2.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/register/Attic/user-new-2.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/ecommerce/www/register/user-new-2.xql	10 Jul 2001 20:37:46 -0000	1.1
@@ -0,0 +1,11 @@
+<?xml version="1.0"?>
+<queryset>
+
+<fullquery name="user_exists">      
+      <querytext>
+      select count(*) from registered_users where user_id = :user_id
+      </querytext>
+</fullquery>
+
+ 
+</queryset>