I'm looking for 3 different solutions all relating to user ids, I'm needing a solution to safely make changes without destroying the site.
- I am wanting to change the userID of a user from UserID 507 to userID 10.
- I am wanting to manually user a deleted UserID, basically the user 5 was deleted by accident and was only noticed two months later and we want to register a user to this userID.
We have a plugin that generates a "temporary account" if someone registers through certain channels and then when they finalize their registration it merges this into a new account so all of our user ID's are separated by 1 user.
User 2 = temp/deleted, user 3 = real user, user 4 = temp/deleted, user 5 = real user... etc
We want all these blank/non existent user ids to be filled with actual users.
The solution for 1 or 3 could be a solution for 2, either will work. For 1 and 2 I am perfectly fine having as a SQL query.
Any pointers or suggestions on ways to achieve these?