Discuz! How to clear the recycle bin themes and replies in batches in the forum

Many webmasters have tens of thousands of posts in the recycle bin. Need to be cleared. There is no one click clearing function in the background. Clearing it out is very troublesome. You can clear the database with just one click.It is worth noting that a backup of the database must be done before performing any operations to avoid irreparable errors.

Execute in php myadmin:

DELETE  FROM `pre_forum_thread`  WHERE `displayorder` = -1

Clear the theme post of the recycle bin

DELETE  FROM `pre_forum_post`  WHERE `invisible` = -5

Clear Recycle Bin Reply

DELETE  FROM `pre_home_blog`  WHERE `status` = -1