MyBB Community Forums

Full Version: Is it bad if I Change User UID?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I'm wondering if it's bad if I change the UID of a user through the DB. I have UID 2 and 3 open and want to change for ex a UID 7 to UID 2, etc. Wondering if it'd "break" the forum or if what it "breaks" is fixable easily.

Consider all the posts etc, they all have their original UID's with them. Meaning if you change the user's ID then all the posts by them would break. (IIRC, I think I tried this once.)
Yes, it would break a lot. You'd need to change every column in the database which contains the uid.
So it's possible but would require lots of work, more than just changing one value. Would it be possible to create a script/plugin or have a user created/registered onto a UID 2?
You could do it with SQL queries, but I'd honestly just leave it alone.