Awbs -> whmcs

[sohouk]

I used the supplied script to import our AWBS installation into WHMCS and it mostly worked.

 

We use multiple registrars and it imported all of them OK except for OpenSRS.

 

If the AWBS table had the registrar set to OpenSRS, then although the domain and details were imported to WHMCS, the registrar name (OpenSRS) wasn’t.

 

So, now I need to go through all the entries where the registrar is empty and insert OpenSRS

 

Can someone let me know of a SQL statement that would do that?

 

The WHMCS database table is : tbldomains and the field is registrar

 

Thanks.

[jeremyhaber]

Well, it sounds like you need a simple update command. Pretty basic.

 

You can try:

UPDATE `tbldomains` SET `registrar`='OpenSRS' WHERE `registrar`=''

 

That should update all the fields that have registrar set to nothing to OpenSRS

[sohouk]

Well, it sounds like you need a simple update command. Pretty basic.

 

You can try:

UPDATE `tbldomains` SET `registrar`='OpenSRS' WHERE `registrar`=''

 

That should update all the fields that have registrar set to nothing to OpenSRS

 

Thanks , I'll try that tomorrow and see how it works. I am just a little baffled that all other stuff was imported easily enough.