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.
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.
Exactly. This is the complete list of notification levels.
|4||watching first post|
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
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.