Restore deleted post via query

[|Norman|]

Hello, I would like to ask if I can restore a user's deleted posts (c.a 700) via SQL query, using the AdminCp. They are't physical deleted. I would like to avoid the manual process of restoring them all one by one.

[Colin F]

You can do that, but it's not ideal. A number of counters will not be updated, including the users post count and the post counts in threads.

To simply restore the posts, run this query:
UPDATE post SET visible = 1 WHERE userid = X;

Replace X with the user in questions userid number.

[|Norman|]

Then to update the counters I can run the script via the Maintenance page, right?

[Colin F]

Yes, though I'm not sure if all the necessary counters will be updated.