You could request an extension, or
I'm not sure copying a subset of the group of (newly) registered users to another group defined by subforum membership would be a satisfactory solution, for I'd still need my spreadsheet to identify the legacy members of that subforum in the first place. Since the User logs (under ACP | Maintenance) don't show a record of subscriptions, I wouldn't even know to which subforums new users have (self-) subscribed.
The problem here is of identifying all the members of a group (those subscribed to a specific subforum) that the phpBB system must be knowing and keeping track of (e.g., the link to toggle between Subscribe and Unsubscribe) and is yet not exposing to the site admin, neither through corresponding inbuilt groups (i.e., without my having to create a group) nor in User logs. Even before permissions, etc., come into the picture.
When a registered user clicks on Subscribe at the bottom of a subforum he joins the group of its members, until he clicks the same link which now shows Unsubscribe instead. Typically, those who join the board decide for themselves which subforums to (un-) subscribe.
I would suggest that you either post that requirement in the Extension Requests forum or if you are willing to pay then post in the Wanted forum.
Subforums, like forums and categories don't have members.svAbhinava wrote: ↑Tue Jan 05, 2021 3:39 amWhen a registered user clicks on Subscribe at the bottom of a subforum he joins the group of its members, until he clicks the same link which now shows Unsubscribe instead. Typically, those who join the board decide for themselves which subforums to (un-) subscribe.
Code: Select all
SELECT username FROM phpbb_users WHERE user_id IN(SELECT user_id FROM phpbb_forums_watch WHERE forum_id = N)
phpbb_change accordingly. N is the id of the forum or subforum, which is displayed in the browser status bar when you hover over the forum name in the breadcrumbs.
Yes, I'd request an extension to display a link in each subforum that, when clicked, lists in real time all its subscribers (rather than 'members') in alphabetical order or by date of subscription. This I suppose would be done by running the SQL query that Steve has formulated above.david63 wrote: ↑Tue Jan 05, 2021 8:20 amI would suggest that you either post that requirement in the Extension Requests forum or if you are willing to pay then post in the Wanted forum.
Creating that as an extension is, I would guess, not too difficult.
Thanks for this clarification that has helped me better understand how phpBB works beneath the hood.
That again would not be too difficult to make into an extension but the main problem with it would be from a maintenance point of view if, say, you had 100 or more fora.
Just thinking out loud on what you are trying to do. I understand the Yahoo! Groups shutdown and that you are trying to consolidate several groups.svAbhinava wrote: ↑Wed Dec 23, 2020 12:39 amI'm a newbie who has just created his first phpBB (3.3.2) forum 2 weeks ago to consolidate multiple Yahoo! Groups that were shut down this Dec. 15. I'm delighted at my then still uncertain choice, and am now thoroughly enjoying the rapid learning experience of this powerful fine-grained platform.
The previous Yahoo! Group showed all the subscribers, when they joined, username, etc., in a single listing with a total. Where can I find similar functionality within the ACP, i.e., to list members specific to a subforum (that corresponds to the old Yahoo! Group)? This will help me better focus my energies, e.g., which subforums to prioritize for posting, which to grow, etc., to name but a couple of reasons.