Hello again - another question:
I need to edit who's subscribed to a specific topic on our forum. Can this be done
Michael TobischDNN★MVP
Hi Rich. Are you using the Community Forums module? If so, I understand what you're looking for, and we do (kinda) have it on the roadmap. We added subscriber counts for forums and topics in 7.0.10 (https://github.com/DNNCom...yForums/issues/185), and part of that feature request is to allow a moderator to view (and potentially update) the subscriber list. I added a new issue for that (https://github.com/DNNCom...tyForums/issues/597)
Thanks for your response, Gents. however I can't see which forum we have on our site. It seems pretty standard, however.
A bit of background - we're a UK nationwide single species angling club. the chap who developed the site has recently left the club (sadly) and I've picked up the maintenance. I think it's the same forum software as the one I'm currently typing into. Where below there a tick box to check, and subscribe. In the longer term we want to hire a developer to enhance the site - a gallery and a read-only document archive. I'm a sql dev by trade but don't have the time to delve into DNN as a development tool.
In terms of querying the site directly (logged in as host) I have no idea which tables hold the data I need. Is there a schema available?
Is there a URL we can look at?
[...] I think it's the same forum software as the one I'm currently typing into. Where below there a tick box to check, and subscribe. [...]
Then it is propably Active Forums. A look in the Extensions list could make you sure.
[...] I'm a sql dev by trade [...]
There are some tables in the database named activeforums_*. The users are in a table called Users, mind the UserPortals table as well, when you have more than one portal installed using the same database. As an SQL dev it should be easy for you to check the tables and create a query for your purpose.
If you change (insert/update/delete) data in the database be sure to make a backup before, or to setup a testing environment to be sure that everything will work fine after your changes. To take the changes into effect on the website restart the application pool or clear the cache.
Happy DNNing! Michael
There is, however, forum access is only for users. Sorry
Thanks Michael - that's very helpful
Some suggestions:
Do you have a Host or Admin login?
In that case you can see in the settings of the module what Forums module is used. If not, inspect the Forum page's HTML and look for the "DnnModule-ActiveForums" class
In that case the module project page can be found here: https://github.com/DNNCom.../Dnn.CommunityForums
And there's a database model in the Wiki
https://github.com/DNNCom.../wiki/Database-model
You might be running an older verison of the module but at least it's a pointer to the tables :-)
These Forums are dedicated to the discussion of DNN Platform.
For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:
Awesome! Simply post in the forums using the link below and we'll get you started.