XF 2.0 Query to make a specific User Group watch specific forum

[Mr Lucky]

Is it possible to run a query to make one specific User Group watch a specific forum or a set of forums?

Thanks

 

[Chris D]

This will probably do it (usual rules about running on a test install, backups etc. apply):

INSERT INTO xf_forum_watch
(user_id, node_id, notify_on, send_alert, send_email)
SELECT user_id, 123, 'thread', 1, 0
FROM xf_user
WHERE FIND_IN_SET(4, secondary_group_ids)

You'd need to run it for each node_id and user group ID. 123 represents the node_id and 4 represents the user group. This will only check the usergroup against the secondary_group_ids field.

 

[Mr Lucky]

Thanks first test didn't work though.

using forum id 33 and secondary user group id 18

INSERT INTO xf_forum_watch
(user_id, node_id, notify_on, send_alert, send_email)
SELECT user_id, 33, 'thread', 1, 0
FROM xf_user
WHERE FIND_IN_SET(18, secondary_group_ids)

Error

MySQL said: Documentation
#1062 - Duplicate entry '4650-33' for key 'PRIMARY'

 

[Chris D]

Just means that one user is already watching that forum. Try changing INSERT INTO to INSERT IGNORE INTO.

 

[Mr Lucky]

Thanks, on first testing that appears to work!

 

[Mr Lucky]

Thanks again Chris

I've asked something similar here, many thanks if anyone can answer that one also:

https://xenforo.com/community/threads/query-to-force-users-watch-your-own-content.152993/

 

[Case]

@Mr Lucky, does this mean any new users added to this usergroup in future will be watching the forum?

 

[Brogan]

No.

The query would have to be run each time a member is added to the user group.