M mrb1972 Active member Licensed customer Jul 5, 2011 #1 Is it possible for an Admin to bulk clear users "watch thread" and "and receive email notifications" settings?
Is it possible for an Admin to bulk clear users "watch thread" and "and receive email notifications" settings?
P Paul B XenForo moderator Staff member Licensed customer Jul 5, 2011 #2 You can do it with SQL queries if you're comfortable doing that and have access to e.g. phpMyAdmin. Upvote 0 Downvote
M mrb1972 Active member Licensed customer Jul 5, 2011 #3 Brogan said: You can do it with SQL queries if you're comfortable doing that and have access to e.g. phpMyAdmin. Click to expand... Yes thats no problem, its a test site so not critical if it goes wrong, if you could let me know the queries that would be helpful.. thanks Upvote 0 Downvote
Brogan said: You can do it with SQL queries if you're comfortable doing that and have access to e.g. phpMyAdmin. Click to expand... Yes thats no problem, its a test site so not critical if it goes wrong, if you could let me know the queries that would be helpful.. thanks
P Paul B XenForo moderator Staff member Licensed customer Jul 5, 2011 #4 Code: UPDATE xf_user_option SET email_on_conversation = 0; UPDATE xf_user_option SET default_watch_state = ''; truncate table xf_thread_watch; That should do it. Upvote 0 Downvote
Code: UPDATE xf_user_option SET email_on_conversation = 0; UPDATE xf_user_option SET default_watch_state = ''; truncate table xf_thread_watch; That should do it.
M mrb1972 Active member Licensed customer Jul 5, 2011 #5 thanks, I will give it a try Upvote 0 Downvote
