LiveZilla Live Chat Software
RCM - Resellerclub Mods

Welcome, Guest

TOPIC: SOLVED: All domains in RC belong to a single user

SOLVED: All domains in RC belong to a single user 3 years 9 months ago #261

Since I buy the domians for my customers, they are all in RC under one single user, so when I imported them into WHMCS using the wonderfull free tool I thought that i had to go one by one moving the service to its rightful owner.

However I saved a lot of time running this query

UPDATE `tbldomains`, `tblhosting` SET `tbldomains`.`userid`=`tblhosting`.`userid` WHERE `tbldomains`.`domain`=`tblhosting`.`domain`

wich looked into the hosting domain of the WHMCS customer and matched it with the one in the domains table.

I hope this is useful for someone.
The administrator has disabled public write access.
Time to create page: 0.107 seconds

Latest Tweets

More Tweets from resmods

Latest News

Sneak Preview v4 RCM Modules!

Automation here, automation there, automation everywhere! The new v4 Modules will mark a before and after for selling, provisioning, and managing Products / Services with ResellerClub, NetEarthone and many others using the biggest reseller platform LogicBoxes / OrderBox in the domain and hosting Industry.

About Us

Who we are, what we do and everything else about Resellerclub Mods, a gIF Business Project: