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 11 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.090 seconds

Latest Tweets

More Tweets from resmods

Latest News

Black Friday and Important News!

Black Friday is coming and will start tonight! Don't miss it and get the best possible discount on our complete Portfolio!
Read more...

About Us

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