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.
 

CTXMedia

Formerly CyclingTribe
#3
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
 

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