rexxy 0 Posted March 20, 2011 I'd like to remove the old cc details from the database. It no longer accepts cc details but it has some old ones stored. Is there a sql statement I could run to remove them all? I have installed a contribution but it only does them one at a time. I'd like to remove all of them except for any cc details of orders made in the last couple of days. Once they are processed future orders are paid via paypal. Is that possible, could someone please provide me with a sql statement I could run to remove all cc details except the ones entered in the last couple of days? Share this post Link to post Share on other sites
♥geoffreywalton 139 Posted March 20, 2011 You need something along the lines of UPDATE [LOW_PRIORITY] [iGNORE] table_reference SET col_name1={expr1|DEFAULT} [, col_name2={expr2|DEFAULT}] ... [WHERE where_condition] update orders set cc_no ="" As I don't know the table of field names you have you will have to adapt this to suit your situation. Unless your server/site adheres to the PCI rules you shouldn't store/process this data for even a fraction of a second so I have not shown the where clause to keep the last 2 days worth of data. HTH H Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. Share this post Link to post Share on other sites
♥toyicebear 206 Posted March 21, 2011 I'd like to remove the old cc details from the database. It no longer accepts cc details but it has some old ones stored. Is there a sql statement I could run to remove them all? I have installed a contribution but it only does them one at a time. I'd like to remove all of them except for any cc details of orders made in the last couple of days. Once they are processed future orders are paid via paypal. Is that possible, could someone please provide me with a sql statement I could run to remove all cc details except the ones entered in the last couple of days? You can actually use this one... Database optimizer , among other things it can be set to delete old cc numbers.... Basics for osC 2.2 Design - Basics for Design V2.3+ - Seo & Sef Url's - Meta Tags for Your osC Shop - Steps to prevent Fraud... - MS3 and Team News... - SEO, Meta Tags, SEF Urls and osCommerce - Commercial Support Inquiries - OSC 2.3+ How To To see what more i can do for you check out my profile [click here] Share this post Link to post Share on other sites
rexxy 0 Posted March 22, 2011 Thanks! No more evil old cc numbers lurking about in the system. Share this post Link to post Share on other sites