Deleting / Removing Credit Card Number

[syscon]

Is there a way to delete or remove credit card number after transaction is completed!?

 

Joseph :?

[syscon]

Since the information is stored in database is there a way to access credit card information in the database via phpMyAdmin and remove it from database directly!?

 

Joseph

[Nancy]

I'm using 2.1 so don't know of any 2.2 options.

Since the cc number is not written to the database until payment_confirmation.php is submitted, and no other action is required after payment_confirmation.php, there is no trigger to automatically remove the cc number. You could really hack things up and have the cc number emailed (using PGP I'd hope), and never actually write it to the database using payment_confirmation.php as the trigger. It would be a bit of a task, but it could be done.

 

Another option is some sort of time based (chron type) process that querys the mySQL database every couple of minutes to purge any cc #'s (still need to make sure you recorded them for the purchase).

 

Syscon's phpMyAdmin is the easiest solution, but has to be done manually. Good Luck!

-nan

[syscon]

So in what section of the database is this information located.

I was looking for it but couldn't find it any credit card numbers in the database.

 

Thanks,

Joseph :?:

[Nancy]

In 2.1 it is in the 'Orders' table.

cc_type, cc_owner, cc_number, cc_expires.

-nan

[syscon]

Thanks Nancy,

 

It worked like a charm. :P

 

Regards,

Joseph