rlexyd:
Hi JT,
Just wondering, do you eat a lot of brain food?
You are a Genius :smartalec:
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 :clap:.
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!
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.