Question Who are my Global Moderators?

Sort-by-moderator will show me ALL moderators - category AND global.

Yes, I had written "Sort by Moderator" will listed all moderators".
Also database search won't help. You can only see, user is moderator "Yes = 1" or "No = 0".
You must to manually search the global moderators, sorry.

Hunh. If it's not in the database, where is that setting stored?

First of all I have to thank my colleague Rich for reminding me that the Kunena User Manager under J! 2.5 allows you to filter those accounts that are moderators (even though you cannot differentiate between global moderators and category moderators). And, yes, there are several reports in GitHub about the Kunena User Manager under J! 3.x that do not work.

Secondly, how people categorise their users can be very complex. Indeed, at this website here there are several categories of user accounts; these categories are managed with Joomla ACLs. Just like you, we periodically review the accounts in those categories and, if the accounts have been "inactive" for an extended time, the accounts are purged from those categories and, similarly, any added privileges they had are also revoked.

jimrowland wrote:

I have a very large population (10,000+ users). We maintain a fairly large staff of moderators (20 or so) ...

Lucky you! :lol: At this site we have a nominal user population of 30,000 accounts and half the number of moderator staff that you have; we could certainly use more help. As you know, there is no company behind Kunena; everyone who contributes to Kunena is a hobbyist, enthusiast or professional web developer who gives their time freely to this project - volunteers every one of us. Our hope is to make Kunena the most reliable, scalable, durable and robust forum component for Joomla that we can make it and to give people the best solution to meeting their forum needs. The forum is a self-help community-driven resource for users to help one another. Our job, in moderating the forum, is not necessarily to answer every question but, rather, to point people in the right direction where they can find the answers.

Having written that, one might think that other members of the community having an interest in this topic would be willing to engage in this topic and share their experiences instead of leaving it to the moderator team members to attempt to answer this question to the degree of detail that you require.

Let me make two points:

(1) As far as I know, there is no feature built into Kunena that allows you to create a list of global moderators separate from category moderators.

(2) I do not know anything about CB GroupJive or how this product is used to give [Kunena forum] category moderation privileges to Joomla user accounts.

jimrowland wrote: Hunh. If it's not in the database, where is that setting stored?

It depends on what you are referring to. If you are referring to "where, in the database, is the setting stored that classifies a Kunena account as a global moderator", the setting is not quite so intuitive.

In the table _kunena_users, the column moderator has two possible values (0 or 1). This setting applies whether the account is a global moderator or a category moderator; both kinds of moderators have moderator = 1. The table that defines which categories can be accessed or moderated by other accounts is the table _kunena_user_categories. Now this is the part where it gets tricky!

Look at the columns in the table _kunena_user_categories:

• user_id relates to the similarly named key in the table _kunena_users


• category_id relates to the similarly named key in the table _kunena_categories, except that it may also have the value 0 (meaning "all categories")


• role has two possible values (0 = no moderation privileges, 1 = moderation privileges).

Therefore, you can find out who are your global moderators by constructing an SQL query that searches _kunena_user_categories "WHERE category_id = 0 AND role = 1" and that should give you a list of user_ids. If you wanted to be clever, you could inner join the table _kunena_users to list the usernames instead of the user_ids.

This took me about 45 minutes to dig this information out for you; I hope it helps and that it is of some value to you (and possibly to others who may be in your "lucky" situation).

Thanks, sozzled! I thought I might have been onto something when I saw the "role" field in the categories table, but I hadn't yet sussed out what the values represented. I was getting there, though. Play with a value, see what happens. Change the value, repeat. (quasi-reverse engineering, I guess) :^)

Based on what I had almost discovered, and your confirmations, here is an SQL query for anyone else who might stumble upon this thread who might be looking for the same info:

(your joomla table names might be different)