Index: openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql	27 Feb 2005 17:07:19 -0000	1.5
+++ openacs-4/packages/ecommerce/www/admin/orders/one-postgresql.xql	5 Dec 2008 23:32:30 -0000	1.6
@@ -8,7 +8,7 @@
       select o.order_state, o.creditcard_id, o.confirmed_date, o.cs_comments,
          o.shipping_method, o.shipping_address, o.in_basket_date,
          o.authorized_date, o.shipping_charged, o.voided_by, o.voided_date,
-         o.reason_for_void, u.user_id, u.first_names, u.last_name, c.billing_address
+         o.reason_for_void, u.user_id, u.first_names, u.last_name, u.creation_ip, u.email, c.billing_address
       from ec_orders o
       left join cc_users u using (user_id)
       left join ec_creditcards c using (creditcard_id)