Page 1 of 1

Subscription of Center members

Posted: Thu Mar 20, 2014 6:38 am
by 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?

Re: Subscription of Center members

Posted: Thu Mar 20, 2014 9:24 am
by DGDanforth
Ivan Denisov wrote: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.

Re: Subscription of Center members

Posted: Thu Mar 20, 2014 12:02 pm
by 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);

Re: Subscription of Center members

Posted: Tue Mar 25, 2014 1:53 pm
by 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.