f2vs540wgygms8vg Posted June 19, 2019 Share Posted June 19, 2019 There doesn't appear to be any simple way of mass deleting the old services inside WHMCS which have the status Cancelled, Terminated or Fraud. Is there any reason I should be keeping these? Can I just remove from the database directly with, DELETE FROM tblhosting WHERE domainstatus = Cancelled DELETE FROM tblhosting WHERE domainstatus = Fraud DELETE FROM tblhosting WHERE domainstatus = Terminated 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 20, 2019 Share Posted June 20, 2019 15 hours ago, f2vs540wgygms8vg said: There doesn't appear to be any simple way of mass deleting the old services inside WHMCS which have the status Cancelled, Terminated or Fraud. there used to be a free third-party addon, but it's been removed from Marketplace... possibly because it wasn't updated for WHMCS v7 or PHP7 ? https://whmcs.community/topic/271113-easy-whmcs-module-free 15 hours ago, f2vs540wgygms8vg said: Is there any reason I should be keeping these? is there any reason to get rid of them? 1 Quote Link to comment Share on other sites More sharing options...
f2vs540wgygms8vg Posted June 20, 2019 Author Share Posted June 20, 2019 4 minutes ago, brian! said: there used to be a free third-party addon, but it's been removed from Marketplace... possibly because it wasn't updated for WHMCS v7 or PHP7 ? https://whmcs.community/topic/271113-easy-whmcs-module-free is there any reason to get rid of them? There are around 6000 records in our database of these no longer active services so removing would clear some space. They contain hashed passwords. Makes it easier for customers to navigate to their active services. Enables us to delete products which we no longer offer. 0 Quote Link to comment Share on other sites More sharing options...
brian! Posted June 21, 2019 Share Posted June 21, 2019 On 20/06/2019 at 12:40, f2vs540wgygms8vg said: There are around 6000 records in our database of these no longer active services so removing would clear some space. personally, I wouldn't remove fraud accounts from the table. On 20/06/2019 at 12:40, f2vs540wgygms8vg said: They contain hashed passwords. to closed/terminated services. On 20/06/2019 at 12:40, f2vs540wgygms8vg said: Makes it easier for customers to navigate to their active services. you could do the same by modifying the client area. 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.