Elementary, my dear Watson warmweer
Yes, I had considered that idea, though a main reason that I use phpBB as a teaching platform is to build a knowledge base around my courses. If I could easily duplicate/copy forums and sub forums this could be a possibility. Though, the idea is that all my students are contributing to a community that will support current and future students. Though I recognize as I mentioned that once the course in complete students may not want to keep receiving emails.EA117 wrote: ↑Wed Jan 06, 2021 4:51 pmIt probably already came to mind for you, or you already have reasons not to use the approach. But what came to mind for me was making each new semester its own forum, so that anyone who is still subscribed to a previous semester's forum simply never sees any activity. Presumably, based on the current concern you have, I assume you're "emptying out and re-using the same forum" each semester.
So instead of "one forum for ENGL-1202 that gets re-used every semester", you instead have "ENGL-1202 Spring 2021", "ENGL-1202 Fall 2021", etc. You're still free to delete them as soon as you want, or keep them as archive for as long as you want. The key was just that the forum ID for the new incoming class isn't the same forum ID as the outgoing class.
Code: Select all
DELETE FROM phpbb_topics_watch WHERE topic_id IN(SELECT topic_id FROM phpbb_topics WHERE (forum_id = X OR forum_id = Y OR forum_id = Z)) AND user_id IN(SELECT user_id FROM phpbb_user_group WHERE (group_id = A OR group_id = B OR group_id = C)); DELETE FROM phpbb_forums_watch WHERE (forum_id = X OR forum_id = Y OR forum_id = Z) AND user_id IN(SELECT user_id FROM phpbb_user_group WHERE (group_id = A OR group_id = B OR group_id = C))
You would need to specify the forum_id of each of the subforums.
It looks better. Personally, I don't like to have more than one "OR" in something like this. I would probably change
(forum_id = x or forum_id = y or forum_id = z)to
forum_id in (x, y, z)
I have in fact found this very useful. I installed it a few weeks ago though I installed an older version for 3.2.7 if I recall correctly. And it is the extension that spawned my request to be able to better manage subscriptions for groups. If I can track students' subscriptions I can better track their engagement my course. Can your extension for 3.3 be developed to allow admins to manage forum/topic subscriptions for groups as well as individual users?