Swapping USERID

[kh99]

I don't disagree with anything anyone said above (specifically, I agree that it shouldn't be important enough to bother attempting it), but if you really want to play around, I was thinking this:

- create a temporary admin account with permissions to do what you need to do below, and log in to that account.
- create a new user that will become the current user 1's user
- merge user 1 to the new user (this deletes the current user 1)
- create a new user that will become your user 1 - note the id of this user
- go to the database and in tables user, userfield, and usertextfield (and administrator, if you made the new user in the previous step an admin), set userid = 1 where userid = the id from above.
- merge your current account to the user 1 account.
- delete the temporary admin account

I don't know how well this will work. The instructions for merging users says the "Posts, threads, calendar events, private messages, post count, reputation, contacts, friends and ignore list" will be merged, but I guess the profile information (and maybe other things I haven't thought about) will not be, so when you create the new users you probably want to copy as much of the profile info as you can. Also you'll have to give the displaced user 1 the new password you use when creating his new user.