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 5 years 3 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.050 seconds

Latest Tweets

More Tweets from resmods

Latest News

We are ready for the next round ...

... and very proud to announce the immediate availability of all our modules for WHMCS 7.5.0 - RC 1 and backwards compatible till WHMCS 6.0.0!

About Us

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