XF 1.1 Set user to watch all thread they have started

Nudaii

Well-known member
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?
 
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.
 
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).
 
Is there a XF 2.x version of this mysql query? I'd like to watch all the threads I started, because RSS Imported Feeds aren't watched by default even if I'm set as thread starter.
 
Top Bottom