• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

How to soft delete all threads in someone forum?

Stemis

Formerly Sasa
#3
Code:
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)?