Synchronize all domains's due date to expiration date

[hkhost]

Hello

Is there any option or database query command to synchronize a domains' due date to its expiration date?

Thanks!

[brian!]

3 hours ago, hkhost said:

Is there any option or database query command to synchronize a domains' due date to its expiration date?

other than using the domain sync option - which is only valid if the registrar supports the functionality.

if you just wanted to run a query to make ALL of the next due dates the same as the expiry dates...

UPDATE tbldomains
SET nextduedate = expirydate

if it was for a specific domain or status, then you would add a where statement...

UPDATE tbldomains
SET nextduedate = expirydate
WHERE domain = 'whmcs.com'

though if it were a specific domain, i'd just manually edit the values in the database rather than run a query. 🙂

as ever with these queries, always remember to take a database backup before running them - because there is no undo option after it has been ran! ⚠️

[twhiting9275]

Also , keep in mind that this is really not that advisable. Keep the domain due date earlier than expiration date, in order to ensure that there are no issues with renewing domains (ie: client pays late).