Auto-Close Account

[bforte@itsolutionsnow.com]

I am looking for a script/cron job to auto-close the account after the customer has either no products or they are all cancelled/terminated?

[wsa]

can you email me at whmcs (at) hostthebest.com

[wsa]

To let you know i have done one already

[EasyWHMCS]

There is a free one on the forums somewhere i think, As i used to use it on one of my businesses

[Troy]

Here's a sql query we run daily, which will set a customer to inactive if they have no services, domains, open invoices, and are not affiliates. You can change 'Inactive' to 'Closed'.

 

update  tblclients c
set     status = 'Inactive'
where	status = 'Active'
and     not exists (select 1 from tblhosting where userid = c.id and domainstatus in ('Active', 'Pending', 'Suspended'))
and     not exists (select 1 from tbldomains where userid = c.id and status in ('Active', 'Pending', 'Pending Transfer'))
and     not exists (select 1 from tblinvoices where userid = c.id and status = 'Unpaid')
and     not exists (select 1 from tblaffiliates where clientid = c.id);

[wsa]

I am looking for a script/cron job to auto-close the account after the customer has either no products or they are all cancelled/terminated?

 

here what you looking of http://www.hostthebest.com/close_account.php

[Dedigeeks-Sean]

Here's a sql query we run daily, which will set a customer to inactive if they have no services, domains, open invoices, and are not affiliates. You can change 'Inactive' to 'Closed'.

 

update  tblclients c
set     status = 'Inactive'
where    status = 'Active'
and     not exists (select 1 from tblhosting where userid = c.id and domainstatus in ('Active', 'Pending', 'Suspended'))
and     not exists (select 1 from tbldomains where userid = c.id and status in ('Active', 'Pending', 'Pending Transfer'))
and     not exists (select 1 from tblinvoices where userid = c.id and status = 'Unpaid')
and     not exists (select 1 from tblaffiliates where clientid = c.id);

 

This is exactly what I am after, works perfectly for me and did what I wanted it to do. Is there a way this can be implemented in to a script, or can we simply just run this as a daily task...?

[wsa]

new update be up in hrs that now you can disable closed account

[Dedigeeks-Sean]

new update be up in hrs that now you can disable closed account

 

Actually didn't work very well after paying for it, I set it to "CLOSE" accounts after 365 days and set them inactive from periods before that date after they no longer had active services with us, surprisingly it closed random accounts and left accounts inactive way back from 2009

[wsa]

Did you try the new version 1.3? if not pls email me at support (at) hosttthebest.com

[Dave96]

@Troy, thanks for query!