Mysql query expired domains

[erwin123]

Can someone help us with the syntax for a Mysql query that changes the status from all 'Expired' domains to 'Active'?

 

There's a discrepancy between the number of domains that our ristrar holds and the active domains in our system.

This can be caused by transfers being set to 'Expired' by WHMCS before the domain actaully transferred.

After it is set to Expired the system won't try to sync the domain with the registrar anymore and a invoice won't be generated for the renewal of the domain.

So clients risk loosing a domain this way.

 

If we can set all 'Expired' domains to 'Active' the sync process will automaticly set all domains that are no longer active back to Expired and leave the domains that are now labelled 'Expired' set as active (because they are).

 

Hope this makes sense

[brian!]

UPDATE tbldomains
SET status='Active'
WHERE status='Expired'