How to Recover Posts/Threads/Messages from a Deleted User in XenForo

[Zechariah]

thanks to dear member @Zechariah submitted a new resource:

How to Recover Posts/Threads/Messages from a Deleted User in XenForo - This article will show you how to do that for public posts and private conversations.

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 SQL command to update posts, topics, and profile posts for a deleted user:

UPDATE xf_post SET username = 'NewUsername', user_id = NEW_USER_ID WHERE username = 'OldUsername'; UPDATE...

Read more about this resource...