Subscription of Center members

[Ivan Denisov]

Because of the Josef question about notifications problems, I had looked into the database of subscriptions and saw that few of the center members are subscribed to forums updates. I think, that it is because they did not find this function of forgot to do this. Do you think I can subscribe all Center members manually?

[DGDanforth]

Because of the Josef question about notifications problems, I had looked into the database of subscriptions and saw that few of the center members are subscribed to forums updates. I think, that it is because they did not find this function of forgot to do this. Do you think I can subscribe all Center members manually?

I think they all 'should' be subscribed.

[Ivan Denisov]

I had executed next SQL commands for subscribe Center members to all forums.

Code: Select all

INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,54,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,56,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,60,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,65,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,66,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,69,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,72,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,73,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,75,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (4,76,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,54,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,56,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,60,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,65,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,66,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,69,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,72,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,73,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,75,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (33,76,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,54,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,56,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,60,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,65,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,66,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,69,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,72,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,73,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,75,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (31,76,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,54,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,56,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,60,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,65,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,66,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,69,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,72,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,73,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,75,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (40,76,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,54,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,56,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,60,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,65,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,66,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,69,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,72,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,73,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,75,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (41,76,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,54,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,56,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,60,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,65,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,66,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,69,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,72,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,73,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,75,0);
INSERT INTO `phpbb_forums_watch`(`forum_id`, `user_id`, `notify_status`) VALUES (42,76,0);

[ReneK]

Could this be done by a daily routine for my account? There's a new thread created after you, Ivan, did the update, and I didn't receive a mail notification.