XF 1.1 Set user to watch all thread they have started

[Nudaii]

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]

UPDATE xf_user_option
SET default_watch_state = 'watch_email';

Or:

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.

 

[CTXMedia]

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

 

[Jake Bunce]

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

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).

 

[V3NTUS]

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.

 

[djbaxter]

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.

That's default behavior for all threads you start or reply to.

 

[V3NTUS]

That's default behavior for all threads you start or reply to.

It looks it doesn't apply to RSS Imported Feeds though, that's why I'm wondering if there's a query to execute to overcome this.

 

[djbaxter]

Oh. I wasn't aware of that but I don't use RSS posting. I don't expect it would take @AndyB or @Ozzy47 long to whip up an addon for that if there's a demand.