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.

[Boofo]

Originally Posted by BirdOPrey5

I can't think of 1 mod hard coded to use userid 1 for anything, and if there was you shouldn't be using such a mod to begin with- god knows what other stupid things the coder may have done.

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.

[CK]

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] ---------------

Originally Posted by Boofo

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.

Remember foromail?

[Boofo]

Originally Posted by CK

Remember foromail?

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

[kh99]

Originally Posted by CK

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?

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).

[CK]

Originally Posted by kh99

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.

[kh99]

Originally Posted by CK

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.

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).

[CK]

Originally Posted by kh99

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

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

YAY

[BirdOPrey5]

Originally Posted by CK

All sorted now BTW look

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

YAY

Banned from vBulletin?

[Videx]

Originally Posted by BirdOPrey5

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.