Swapping USERID

[CK]

I was advised via support to post for help here, I'll preface by saying that I'll be doing this on a backup as proof before trying anything on the board.

So I'm running vBulletin 4.1.5 and I would like to swap two existing USERID's. If anyone could advise of a step by step that I could try out I would be eternally grateful.

[vbresults]

I misunderstood what you were trying to do; never mind.

[CK]

Bugger, thank you anyway.

[Videx]

You can't swap IDs, but you can change names. Swap names, swap IDs.

Agree you really need to tell us what you're trying to accomplish if you want a more meaningful answer.

[CK]

Originally Posted by Videx

You can't swap IDs, but you can change names. Swap names, swap IDs.

Agree you really need to tell us what you're trying to accomplish if you want a more meaningful answer.

Basically I'm not USERID 1.

I would like my username to be associated with USERID 1, so I need to swap everything I've ever posted to show up as USERID 1 and the member that had populated as USERID 1 I would like to swap to my current USERID.

I hope that makes sense I'm not very good at explaining.

[Zachery]

Don't, its not worth the trouble.

[CK]

Originally Posted by Zachery

Don't, its not worth the trouble.

I understand that's the general feeling but if it's all the same I would really appreciate it if someone would explain the steps I would take and I'll try it out on a backup of the DB.

[DivisionByZero]

Do you have any idea what an undertaking that is?

First, you'll have to shut down the board (if it's a busy one), then wipe the caches and manually edit all sorts of fields in dozens of tables.

What's so important about being #1 anyway? What I do with my boards, when I install them, is.... just before the installation step where you enter the first user details (usually admin), I set the auto_increment to 1000001. Kinda like the facebook way.

Optionally, get vbseo and then nobody will see the parameters in the browser anyway.

[CK]

Well I'm converting away from vBulletin in the next 2 weeks.

I have ran into problems with mods being hardcoded to have the admin set as 1, I'm just trying to cover all future bases.

I perhaps had the misguided idea that I would be able to run various SQL queries that would do the changing like black magic.

My database is backed up every 4/5 hours and it's never down for that so I don't perceive that to be an issue. This topic always seems to get smacked down, I've seen people post that they've done it but I've ever seen any step by step instructions.

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

Have you considered merging your account into userid1 and then taking over the account?