| Administrator's Handbook |
| Edutizer manuals | Administrator handbook | A2 Manage | Various database scripts | Moving user from user virtual server to another |
Moving user from user virtual server to another
Task: move user from one virtual server to another.
Needed information: user_id of the user, and site_id of the server you will be moving user to.
Solution:
1. Find the user_id of the user. Using administrator application, search for the user, click on the user name. The location of the page reads something like admin2/server/edituser.asp?userid=663, where 663 is the seeked user_id.
Or, if you know user login, just do
SELECT user_id, login FROM Users WHERE login = 'user_login', etc.2. Find out the site_id of the target server. Using administrator application, click on the Settings link under the target server. You page location read something like admin2/server/settings.asp?server_id=3, where 3 is the seeked site_id.
Or, just do
SELECT * FROM Sites and look up the site_id.3. Do the magic.
UPDATE
Users
SET
site_id = <site_id>
WHERE
user_id = <user_id>
|
||||||
| ||||||
|
||||||
