Close large number of accounts

[tmiller]

How can I CLOSE a large number of customer accounts for whmcs at once. I'm not referring to server accounts im referring to their client area accounts.

 

Purchased a hosting company and only took part of their customers. So they will retain a part of their whmcs. But I need to close all of my accounts so invoices and payments aren't made to them.

 

MySQL command?

[sentq]

if you need to close all existed accounts here is the SQL query, you can run it through PHPMyAdmin or console..

 

UPDATE `tblclients` SET `status`='Closed';