silentkiller Posted February 16, 2007 Share Posted February 16, 2007 Details like 'Registration Date' and 'Expiry Date'. It's a pain to fill these fields up manually (not sure whether there's a simple and more efficient way to do it) as I'm migrating accounts from Clientexec. 0 Quote Link to comment Share on other sites More sharing options...
joe123 Posted February 16, 2007 Share Posted February 16, 2007 I believethat the domain registration date was imported correctly if this is so then you just have to run the following queries on the database to update them all. 1. UPDATE tbldomains SET expirydate=registrationdate 2. UPDATE tbldomains SET nextduedate=registrationdate backup your database before you do anything !!!! hope this helps 0 Quote Link to comment Share on other sites More sharing options...
WHMCS CEO Matt Posted February 16, 2007 WHMCS CEO Share Posted February 16, 2007 UPDATE tbldomains SET expirydate=registrationdate I wouldn't recommend running this query. This would set the expiry date to the registration date which would be in the past and cause all domains to appear in WHMCS as being due for renewal. Matt 0 Quote Link to comment Share on other sites More sharing options...
silentkiller Posted February 17, 2007 Author Share Posted February 17, 2007 I believethat the domain registration date was imported correctly if this is so then you just have to run the following queries on the database to update them all. 1. UPDATE tbldomains SET expirydate=registrationdate 2. UPDATE tbldomains SET nextduedate=registrationdate backup your database before you do anything !!!! hope this helps What I meant was.. User click 'Sync' in WHMCS -> Retrieve Registration & Expiry Date -> DirectI API -> Update database values in WHMCS and maybe having the Due Date before each domain's expiry. That would be nice.. billing for the actual domain expiry instead of tagging the domain along with the hosting account's expiry. I know the due date can be customized - but some customers just don't want to pay for a renewal when their domain is registered till 2009 (Example) 0 Quote Link to comment Share on other sites More sharing options...
joe123 Posted February 17, 2007 Share Posted February 17, 2007 UPDATE tbldomains SET expirydate=registrationdate I wouldn't recommend running this query. This would set the expiry date to the registration date which would be in the past and cause all domains to appear in WHMCS as being due for renewal. Matt you absolutely right , i forgot about the year , this is only good to update the expirydate and nextduedate if one of them available like i had in my case . how stupid of me 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.