×
Blue Eagle 5 v1.6.2 has been Released for Kunena 5.2 (20 Jan 2021)

The Kunena team has announce the arrival of Kunena template Blue Eagle 5 v1.6.2 which is now available for download. This version addresses most of the issues that were discovered in development.

REQUIREMENTS
Blue Eagle 1.6.x requires Kunena 5.2.x to work with

× Topics must relate to a currently supported version of Kunena. If you are unsure what is the current supported version of Kunena, please go to the download page.

If you are having problems then, for your own benefit, it would save us all a lot of time if you would kindly post your configuration report when you ask for help from this forum. If you do not post your configuration report we will not ask you for it but you will probably not get your problem solved, either.

Question See which users are subscribed to which category

More
2 years 1 week ago #1 by jderrick
Hello,

Just did a google to see if there is a way to see which users are subscribed to which category. There didn't seem to be an answer and I couldn't reply to any of the old posts asking them same question, so I thought I'd leave an answer here to help anyone else wondering the same thing.

Run the following SQL query (replacing #__ with your own prefix) and bingo...

SELECT u.id, u.username, c.name FROM #__users as u
JOIN #__kunena_user_categories as uc
ON u.id = uc.user_id AND subscribed = 1
JOIN #__kunena_categories as c
ON uc.category_id = c.id

Please Log in or Create an account to join the conversation.

  • Not Allowed: to create new topic.
  • Not Allowed: to reply.
  • Not Allowed: to edit your message.
Time to create page: 0.075 seconds