If you do want to renumber a user, there is an easier path to this without a complete database dive by creating a dummy new user without any posts with the member# you want, and using UBB's merge user functionality to move all the posts and PM's over to that dummy account. Rename it, and done.

Still don't recommend it though.


[Linked Image from siemons.org]