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

XF 1.1 Set user to watch all thread they have started

Nudaii

Well-known member
#1
I have just moved from MyBB to Xenforo and i need to set it so my account watches every thread it had started (to get alerts from them)

is there a query to do this?
 

Jake Bunce

XenForo moderator
Staff member
#2
Code:
UPDATE xf_user_option
SET default_watch_state = 'watch_email';
Or:

Code:
UPDATE xf_user_option
SET default_watch_state = 'watch_no_email';
Depending on if you want emails too.

edit - note that this preference is not retroactive to existing threads.
 

Jake Bunce

XenForo moderator
Staff member
#4
TBH Jake, I think that's what he's really asking for - is there a query to "watch" all threads started/posted in - for a specific user account, or would that be too complex/intensive?

Cheers,
Shaun :D
Code:
INSERT INTO xf_thread_watch (user_id, thread_id, email_subscribe)
	SELECT user_id, thread_id, 0
        FROM xf_thread
ON DUPLICATE KEY UPDATE
	email_subscribe = VALUES(email_subscribe);
That will add a watch record for the author of every existing thread (no emails).