Originally Posted by bio
I am looking to do the same thing.
I noticed that the previous reply was some time ago... is there an easier way yet?
I am quite comfortable in the database making modifications, but want to make sure I get everything correct (as I have 50 domains on my box and I'd hate to hose it all up).
Its nearly impossible to change an owner for a larger site or it takes at least some time and its error prone.
Here are some general informations but that does not mean that i recommend it
1) Get the userid and groupid of the customer. The easiest way is, create a new website for the customer and check which user and groupid it has.
The user and groupid are in the table isp_nodes. you can join isp_nodes and isp_isp_web by their doc and doctype id's.
2) To change the owner, you must set the userid and groupid in isp_nodes for the website to the new owner.
Then you must do the smae things for all users from isp_isp_user and isp_isp_domain. The user and groupid for these tables are also in isp_dep.
3) Get the corresponding records in the table isp_dep, where the parent_doc_id is the doc_id of the web and the parent_doctype_id is the doctype_id of the web. Change userid and groupid in isp_dep too.
As you can see, changing userid's in 2 - 3 depending tables for each record is a pain
On a alternative note: if I delete the domain to recreate it, will it also delete the user's email and web files? If not, that will work too.
No, all users and co.domains of a website where deleted recursively.