Index: openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql 22 Jul 2001 06:13:37 -0000 1.3 +++ openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-oracle.xql 31 Jan 2002 06:50:10 -0000 1.4 @@ -1,102 +1,71 @@ - oracle8.1.6 + oracle8.1.6 - - - - select u.email, - to_char(confirmed_date,'MM/DD/YY') as confirmed_date, - shipping_address, u.user_id - from ec_orders, cc_users u - where ec_orders.user_id = u.user_id - and order_id = :order_id - - - + + + select u.email, + to_char(confirmed_date,'MM/DD/YY') as confirmed_date, + shipping_address, u.user_id + from ec_orders, cc_users u + where ec_orders.user_id = u.user_id + and order_id = :order_id + + + + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, order_id, date_sent) + values + (:user_identification_id, 1, :order_id, sysdate) + + - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, order_id, date_sent) - values - (:user_identification_id, 1, :order_id, sysdate) - - - + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, order_id, shipment_id, date_sent) + values + (:user_identification_id, 2, :order_id, :shipment_id, sysdate) + + + + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, order_id, date_sent) + values + (:user_identification_id, 3, :order_id, sysdate) + + + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, gift_certificate_id, date_sent) + values + (:user_identification_id, 4, :gift_certificate_id, sysdate) + + - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, order_id, shipment_id, date_sent) - values - (:user_identification_id, 2, :order_id, :shipment_id, sysdate) + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, gift_certificate_id, date_sent) + values + (:user_identification_id, 5, :gift_certificate_id, sysdate) + + - - + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, gift_certificate_id, date_sent) + values + (:user_identification_id, 6, :gift_certificate_id, sysdate) + + - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, order_id, date_sent) - values - (:user_identification_id, 3, :order_id, sysdate) - - - - - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, gift_certificate_id, date_sent) - values - (:user_identification_id, 4, :gift_certificate_id, sysdate) - - - - - - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, gift_certificate_id, date_sent) - values - (:user_identification_id, 5, :gift_certificate_id, sysdate) - - - - - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, gift_certificate_id, date_sent) - values - (:user_identification_id, 6, :gift_certificate_id, sysdate) - - - - - - - - - select ec_user_ident_id_sequence.nextval from dual - - - - - Index: openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql 22 Jul 2001 06:13:37 -0000 1.3 +++ openacs-4/packages/ecommerce/tcl/ecommerce-email-procs-postgresql.xql 31 Jan 2002 06:50:10 -0000 1.4 @@ -1,101 +1,75 @@ - postgresql7.1 + postgresql7.1 - - - - select u.email, - to_char(confirmed_date,'MM/DD/YY') as confirmed_date, - shipping_address, u.user_id - from ec_orders, cc_users u - where ec_orders.user_id = u.user_id - and order_id = :order_id - - - + + + select u.email, + to_char(confirmed_date,'MM/DD/YY') as confirmed_date, + shipping_address, u.user_id + from ec_orders, cc_users u + where ec_orders.user_id = u.user_id + and order_id = :order_id + + - - - + + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, order_id, date_sent) + values + (:user_identification_id, 1, :order_id, current_timestamp) + + - insert into ec_automatic_email_log - (user_identification_id, email_template_id, order_id, date_sent) - values - (:user_identification_id, 1, :order_id, current_timestamp) - - + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, order_id, shipment_id, date_sent) + values + (:user_identification_id, 2, :order_id, :shipment_id, current_timestamp) + + - - + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, order_id, date_sent) + values + (:user_identification_id, 3, :order_id, current_timestamp) + + - insert into ec_automatic_email_log - (user_identification_id, email_template_id, order_id, shipment_id, date_sent) - values - (:user_identification_id, 2, :order_id, :shipment_id, current_timestamp) - - + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, gift_certificate_id, date_sent) + values + (:user_identification_id, 4, :gift_certificate_id, current_timestamp) + + + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, gift_certificate_id, date_sent) + values + (:user_identification_id, 5, :gift_certificate_id, current_timestamp) + + - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, order_id, date_sent) - values - (:user_identification_id, 3, :order_id, current_timestamp) - - - - - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, gift_certificate_id, date_sent) - values - (:user_identification_id, 4, :gift_certificate_id, current_timestamp) - - - - - - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, gift_certificate_id, date_sent) - values - (:user_identification_id, 5, :gift_certificate_id, current_timestamp) - - - - - - - - - insert into ec_automatic_email_log - (user_identification_id, email_template_id, gift_certificate_id, date_sent) - values - (:user_identification_id, 6, :gift_certificate_id, current_timestamp) - - - - - - - - - select ec_user_ident_id_seq.nextval - - - - + + + insert into ec_automatic_email_log + (user_identification_id, email_template_id, gift_certificate_id, date_sent) + values + (:user_identification_id, 6, :gift_certificate_id, current_timestamp) + + + Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/cat/subcategory-add-postgresql.xql'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 1.2 refers to a dead (removed) revision in file `openacs-4/packages/ecommerce/www/admin/cat/subsubcategory-add-oracle.xql'. Fisheye: No comparison available. Pass `N' to diff?