Quote Originally Posted by rlexyd View Post
Hi JT,

Just wondering, do you eat a lot of brain food?

You are a Genius

Again, your solution fixed these problems with ease, I still can't believe it!

Your solutions should be included in the CEON CC Module, for other who might want the same thing!
Hiding those details enhanced my website safety :)

I cannot thank you a enough JT .

Please PM me your PayPal email!!

Since you are a genius, would you know which part of the database I need to drop to remove the remaining credit card details, I would only do that every month or so to make sure they don't stay on there if it's possible :)

Best Regards,

Ahh, no I'm no genius, I just have some ability to follow logic. No Payment is required or asked for.

If you want to blank out the cc #'s and CVV (CVV's are in BLOB format, so you don't actually see the numbers, you just see BLOB) enter this in your admin screen under Tools - Install SQL Patches. If you DROP the table, you will lose ALL order info and you do not want to do that!

Code:
UPDATE orders SET cc_number = NULL, cc_cvv = NULL WHERE cc_number > ' ';
This will blank both fields (CVV will still show BLOB because it's in binary format).

I'll see if I can add this as a utility in the Admin Tools Section under STORE Manager, but in the meantime, you now have a way to do what you want.

Remember, Always BACKUP your files and DB before any modifications.