XF 1.4 How to undelete a user's posts?

[DarkGizmo]

Is there a quick way to undelete all of a user's posts/content? A staff member on a forum I run got a bit power-hungry and got pissy at a fellow staff member and banned & deleted all of his posts. I can still view them as they were only a soft delete but how can I undelete them all by bulk? Is this possible?

 

[AndyB]

You can use this add-on to show the most recent soft deleted posts and threads.

https://xenforo.com/community/resources/show-deleted.2387/

This will make it easier to to go to each post or thread and undelete it.

 

[DarkGizmo]

is there no faster way such as say a SQL query?

 

[borbole]

is there no faster way such as say a SQL query?

Have a look here:

https://xenforo.com/community/resources/approve-all-moderated-posts-queries.373/

But make a backup of your db first, before you run any query.

 

[DarkGizmo]

Will this work with undeleting soft deleted posts, @Barbole?