How would I get a list of who’s watching/tracking/etc a category? Or even just a number of users per notification level? Thanks.
1 Like
I believe this will work:
SELECT * FROM category_users WHERE category_id = '10'
Just change the category ID appropriately.
It displays all possible notification levels, though I’m not sure what the numbers listed mean exactly. They seem to run from 2-4. Presumably tracking, watching, and watching first post, in that order.
2 Likes
Exactly. This is the complete list of notification levels.
| notification_level | description |
|---|---|
| 0 | muted |
| 1 | regular |
| 2 | tracking |
| 3 | watching |
| 4 | watching first post |
1 Like
Thanks. I modified that slightly to get what I needed:
SELECT notification_level, COUNT(notification_level)
FROM category_users
WHERE category_id = '5'
GROUP BY notification_level
1 Like
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.