Kevin Well-known member Jan 8, 2013 #1 Is there a query I could run to close all threads that were started by a specified user ID?
B borbole Well-known member Jan 8, 2013 #2 Kevin said: Is there a query I could run to close all threads that were started by a specified user ID? Click to expand... Try something like this: Code: UPDATE xf_thread SET discussion_open = 0 WHERE user_id =x; And replace x with the id of the user whose threads you want to close. Upvote 0 Downvote
Kevin said: Is there a query I could run to close all threads that were started by a specified user ID? Click to expand... Try something like this: Code: UPDATE xf_thread SET discussion_open = 0 WHERE user_id =x; And replace x with the id of the user whose threads you want to close.
Kevin Well-known member Jan 8, 2013 #3 borbole said: Try something like this: Code: UPDATE xf_thread SET discussion_open = 0 WHERE user_id =x; And replace x with the id of the user whose threads you want to close. Click to expand... That took care of it, thanks! Upvote 0 Downvote
borbole said: Try something like this: Code: UPDATE xf_thread SET discussion_open = 0 WHERE user_id =x; And replace x with the id of the user whose threads you want to close. Click to expand... That took care of it, thanks!
B borbole Well-known member Jan 9, 2013 #4 Kevin said: That took care of it, thanks! Click to expand... No problem Upvote 0 Downvote