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 4 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.101 seconds

Latest Tweets

More Tweets from resmods

Latest News

Weebly Sitebuilder Provisioning Module now available!

We are happy to announce the launch for our brand new Provisioning Module to sell and manage the newly incorporated ResellerClub Service: Weebly Sitebuilder Hosting!


RCM Special Birthday Bundle Promos !

2017 is our 6th Business Year and we are very happy to be your 1# WHMCS Integration provider for ResellerClub, NetEarthOne, and many other LogicBoxes Registrars!


About Us

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