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

Latest Tweets

More Tweets from resmods

Latest News

Wordpress Hosting 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: Wordpress Hosting!


Releasing the v4 Modules Series!

The v4 has arrived! We are very proud to announce finally the release of our brand new v4 Provisioning Module for the Single Domain Hosting Service.


About Us

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