MyBB Community Forums

Full Version: Change All User's UID's?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
I have a problem: A couple weeks after I first started my forum I merged it with another, larger forum (about 600 users). Then, I decided to remove traces of the merge forums, so I have a User ID Gap,

it goes 1-30 and then 630-2100.

Is there a way to put all the user ID's back in order by registration date? as in, 1-1500?
You shouldn't change UIDs to your users, because UIDs are referenced in many ways in the database, and changing them will certainly lead into some troubles (links won't work/will redirect to wrong users, subscriptions, bans, private messages, all will be messed up). I wouldn't say it's impossible (I've written down a function which does what you've requested) but it's way too dangerous for your board, so I won't post it publicly.