View Single Post
  #8  
Old 22nd October 2012, 00:16
pfaf pfaf is offline
Junior Member
 
Join Date: Jun 2012
Location: Nikea, Greece
Posts: 13
Thanks: 3
Thanked 3 Times in 2 Posts
Default Move a client under a different reseller

So, to summarize the steps in order for a Client to be moved under another Reseller :

1.Locate the following values for the Reseller under which you want to assign the client to.
R_userid: Search by 'username' in the 'sys_user' table and get column 'userid'
R_groupid: Search by 'name' in the 'sys_group' table and get column 'groupid'
R_client_id: Search by 'name' in the 'sys_group' table and get column 'client_id'

2. Locate the following values for the Client under which you want to assign the client to.
C_userid: Search by 'username' in the 'sys_user' table and get column 'userid'
C_groupid: Search by 'name' in the 'sys_group' table and get column 'groupid'
C_client_id: Search by 'name' in the 'sys_group' table and get column 'client_id'

3. Table 'client'
Locate the record of the client using C_client_id in column 'client_id' and modify the field 'parent_id' = R_client_id.
Also change column 'sys_userid' to R_userid and column 'sys_groupid' to R_groupid. This is done so that the reseller sees the clients under the clients page.

4. Table 'sys_user'
Locate the reseller record by using column 'username' or R_userid in column 'userid'. Modify the column 'groups' so that it contains also the C_group_id. This is done in order for the reseller to see the client websites.

I hope that the above will be of some help to others.

Kind regards to all,

Panos.
Reply With Quote