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.

I have to say I totally agree with this statement. Any coder that hard-codes any mod to use userid 1 only, is doing something that is so far off the track, who knows what else they have done that will cause problems on down the line. I would avoid any mods like that as well as any coders that code something to that degree.

Thank you khpp, I'm going over your steps again and again in my head an I missing were do we keep the information of the user that currently resides as USERID1? :)

--------------- Added [DATE]1313478906[/DATE] at [TIME]1313478906[/TIME] ---------------

Remember foromail?

Nope, sorry, can't say as I remember that. Was that a mod on here?

The first merge will move all "Posts, threads, calendar events, private messages, post count, reputation, contacts, friends and ignore list" of the current USERID1 to the first new user you create. To keep the profile information you would have to reproduce it yourself. Maybe have two windows open and so you could look at the USERID1 info while creating the new user.

I think you could probably do this more completely and automatically by writing a script because then you could copy all the profile information (but of course that means doing some php programming).

I shall give this a go now that I understand the process a bit better, bit of lateral thinking on your part, hats off to you everyone else has posted how complicated the whole process would be.

I'm going to give this a go tonight and will post back the results.

Thanks, I just thought you should have some kind of answer to the original question if I could think of one. But in defense of everyone else, this probably will not turn out to be a perfect solution (i.e. one that the current USERID1 wouldn't notice).

All sorted now BTW look :D

http://www.the-sps.org/members/chemicalkicks.1/

YAY

Banned from vBulletin?

I show his avatar and sig as an ad for Xenforo. I'd ban him too if he came on my forum advertising a competitor.

Not to mention it seems way off topic.