XF 1.1 Query To Close All Threads Created By A Member

[Brent W]

I need a query that will close all threads created by a member.

Thanks

 

[Jake Bunce]

UPDATE xf_thread
SET discussion_open = 0
WHERE user_id = 1;