I had a dumb error on my part. Thank You So Much!!! This is the best add-on ever!
Would this resubscribe every0ne?
INSERT INTO xf_forum_watch (user_id, node_id,notify_on, notification_method)
select user_id,node_id,'message','2' from xf_forum,xf_user
where user_id not in (select userid from xf_unsubscribe)
and user_state like 'valid%' and node_id<84;
XF_UNSUBSCRIBE is a table that I created to keep track of people that don't want any email. My question is if 'message' is correct. Also is the number 2 correct for notification_method?
Should send_alert and send_email have a value of 1 or 0?
--Dan
Would this resubscribe every0ne?
INSERT INTO xf_forum_watch (user_id, node_id,notify_on, notification_method)
select user_id,node_id,'message','2' from xf_forum,xf_user
where user_id not in (select userid from xf_unsubscribe)
and user_state like 'valid%' and node_id<84;
XF_UNSUBSCRIBE is a table that I created to keep track of people that don't want any email. My question is if 'message' is correct. Also is the number 2 correct for notification_method?
Should send_alert and send_email have a value of 1 or 0?
--Dan