How to soft delete all threads in someone forum?

[Stemis]

Is there are possible with phpMyAdmin?

 

[Jake Bunce]

These queries will soft delete posts for the specified user_id:

http://xenforo.com/community/thread...orum-now-it-doesnt-work-ok.33337/#post-380918

 

[Stemis]

UPDATE xf_thread
SET discussion_state = 'deleted'
WHERE discussion_state = 'visible'
AND user_id = 2;
 
INSERT INTO xf_deletion_log (content_type, content_id, delete_date, delete_user_id, delete_username, delete_reason)
    SELECT 'thread', thread_id, UNIX_TIMESTAMP(), 1, 'admin', 'manually deleted via query'
    FROM xf_thread
    WHERE discussion_state = 'deleted'
    AND user_id = 2
ON DUPLICATE KEY UPDATE
    content_id = VALUES(content_id);

Do I have replace user_id =2 with node_id IN (3)?

 

[Jake Bunce]

To match the node_id instead of the user_id, yes.