Get muc users from sql database

Hi,

I am connecting directly to the wildfire mysql database and want to get a list of the users joined in a muc (or at least the number of joined user). I have looked through the table definitions and I cant seem to find anywhere to get theese details.

Are theese details stored internaly somehow or is there a way to get this from mysql?

Hi,

as far as I know only persistant data is stored in the database. Storing #5000 users in #100 MUC’'s which join and leave in the database may slow down the server and the database a lot. So using SQL is not really an option.

LG