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 1 month 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.102 seconds

Latest Tweets

More Tweets from resmods

Latest News

2018! A new challenge with a lot of changes coming up ...

We just released for all v3 and v4 Modules updates to be in compliance with the new upcoming WHMCS 7.5 system requirements for PHP 7.1. All modules have been reviewed and updated where necessary to work with PHP 7.1 and also to address some bugfixes.

About Us

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