How do i delete all! "tempory deleted posts" in forum? in thread?

[recrut]

How do i delete all(one click)! "tempory deleted posts" in forum? in thread?

thanks
ver 3.6.1

[Colin F]

There's no one click function to do this.
All you can do is prune soft-deleted threads in a forum. This is possible in your
AdminCP -> Threads & Posts -> Prune

[recrut]

ok. threads it's ok, but posts in thread?
For example: in 1 thread ~500 tempory deleted posts.
Ho do i delete this posts?

[vengefuldeath87]

you could use inline mod to select all deleted posts, then hard delete them, but you would have to do this page by page. I dont know of any other way to do that tho.

[recrut]

and more:
i have ~ 1000000 posts on my forum
and 100000 - tempory deleted posts
I must kill this by "hands"?

[Pathor]

Maybe -> http://www.vbulletin.com/forum/showp...7&postcount=19

[recrut]

ok thanks
but it's correct? threds after this, not broken?

DELETE FROM deletionlog
WHERE type = 'post'

DELETE FROM post
WHERE visible = 2