WHMCS: change domain registar for existing domains

[postcd]

Hello,

 

how can i change domain registar (registar module) used for existing .tk domains?

 

i deactivated old domain registar WHMCS module and activated new one, but can not find way to migrate all existing .tk domains to new registar module

 

i can do it because registar is same, only has differently named module folder and .php script file + file is offcourse different. But the registar stays same. I just need to change from: dottk to freenom

 

whmcs 6.3.x

 

Can please suggest a MySQL UPDATE query please if not possible to do in WHMCS?

 

Thank you

Edited August 18, 2017 by postcd

[brian!]

how can i change domain registar (registar module) used for existing .tk domains?

you could change them individually by changing the registrar dropdown value in the client profile domains tab...

 

Can please suggest a MySQL UPDATE query please if not possible to do in WHMCS?

UPDATE tbldomains
SET registrar = 'freenom'
WHERE registrar = 'dottk';