If you have deleted a user in XenForo and their posts or private messages are still visible, you can reassign that content to a new user with a simple SQL script. This article will show you how to do that for public posts and private conversations.
Scripts for public posts and topics
Run this...