Collection of SQL commands for batch content deletion by DiscuzX

1: delete replies in batches. the pre_forum_post table stores forum posts and replies. Each time a post or reply is added, if the pid value + 1. first value is 1, it indicates the topic. If the first value is 0, it indicates a reply. Deletefrompre_forum_postwherepid3andpid16284255andfirst0; 2: batch delete user signatures update 1: batch delete replies pre_forum_post tables store forum posts and replies. Each time a post or reply is added, the pid value is + 1.
If the first value is 1, it indicates the topic. If the first value is 0, it indicates a reply.
Delete from pre_forum_post where pid> 3 and pid <16288245and first = 0;

2: batch delete user signatures
Update pre_common_member_field_forum set sightml = '';

3: batch delete User short messages N days ago
Delete from pre_ucenter_pm_messages_0 WHERE dateline <1353327620;
Timestamp can be converted from here to http://tool.chinaz.com/Tools/unixtime.aspx

4: adjust the number of clicks of a post
UPDATE cdb_threads SET views = clicks WHERE tid = topic number;
UPDATE 'cdb _ forums' SET 'allowmediacode' = '1'

5: One-time closure of board fid20 posts
UPDATE 'cdb _ threads' SET 'closed '= '1' WHERE 'fid' = 20;