# Moving EndUserName from OldReseller to NewReseller
# Used SolidCP interface to set up NewReseller and package (space)

# EndUserName: User 167, Space 290
#    Belonged to OldReseller: User 50, Space 50
#    Moved to NewReseller: User 396, Space 422

# Moved domain content from F:\Webs\OldReseller\EndUserName to F:\Webs\NewReseller\EndUserName
# and made the corresponding updates to C:\Windows\System32\inetsrv\config\applicationHost.config

update [SCP5].[dbo].[ServiceItemProperties] set PropertyValue='F:\Webs\NewReseller\EndUserName\enduserdomain.com\data' WHERE PropertyValue='F:\Webs\OldReseller\EndUserName\enduserdomain.com\data';
update [SCP5].[dbo].[ServiceItemProperties] set PropertyValue='F:\Webs\NewReseller\EndUserName\enduserdomain.com\logs' WHERE PropertyValue='F:\Webs\OldReseller\EndUserName\enduserdomain.com\logs';

update [SCP5].[dbo].[ServiceItems] set ItemName='F:\Webs\NewReseller\EndUserName' WHERE ItemName='F:\Webs\OldReseller\EndUserName';

update [SCP5].[dbo].[Users] set OwnerID=396 where UserID=167
update [SCP5].[dbo].[Packages] set ParentPackageID=422 where UserID=167


# Used SolidCP interface to make copies of existing hosting plans, then assigned them to NewReseller: 
Update [SCP5].[dbo].[HostingPlans] SET UserId=396, PackageId=422 WHERE  PlanName like 'Copy%'

# Used SolidCP interface to assign Space 290 to the new copy of the hosting plan

# Observed that PackageSettings table had no entry for the new package 422, so I added one
insert into  [SCP5].[dbo].[PackageSettings] (PackageID, SettingsName, PropertyName, PropertyValue) values (422, 'ChildSpacesFolder', 'ChildSpacesFolder', '\')

# Used SolidCP interface to create an FTP account for the new reseller.