If both users have been registered but have no activity then I would expect it would be a fairly straight-forward swap of User ID.
The difficulty will be if user 3 has previous activity recorded in other tables - it would then be a man-hunt for the records associated with either/both UID's and might not be worth the effort (or guarantee a "clean" finish).
Yeah that's what I assumed, however how many different locations is this at? So far I've found it in the xf_user and xf_user_authenticate tables, anywhere else that I should look for it?
Yeah that's what I assumed, however how many different locations is this at? So far I've found it in the xf_user and xf_user_authenticate tables, anywhere else that I should look for it?
TBH I think xf_user is the only one you'll need - presumably (I don't know for sure) the auth table will be for users who've registered but not yet confirmed their account.