Article ID: 3121, created on Nov 30, 2007, last review on Apr 17, 2012

  • Applies to:
  • H-Sphere

Resolution

This is possible if you don't encrypt credit card numbers in H-Sphere database.
In this case run the following query:

select cc.cc_number, cc.name, cc.exp_year, cc.exp_month, cc.type from accounts as acc join credit_card as cc on (cc.id=acc.bi_id) where acc.reseller_id=RESELLER_ACCOUNT_ID;

If a reseller is requesting his clients' credit card numbers, run:

select cc.cc_number, cc.name, cc.exp_year, cc.exp_month, cc.type from accounts as acc join credit_card as cc on (cc.id=acc.bi_id) where acc.reseller_id=RESELLER_ACCOUNT_ID;

 
Make sure to replace RESELLER_ACCOUNT_ID with the this reseller's account ID.

f213b9fa8759d57bee5d547445806fe7 6311ae17c1ee52b36e68aaf4ad066387

Email subscription for changes to this article
Save as PDF