Greetings,

 

Currently I'm trying to make a Stored Procedure that will get a list of chatrooms that a user has permissions to.  I have that much thus far, but I also need to get the number of users within each chatroom.  I'm not using the API due that what I need to do would take about 3-4 calls and thought it might be easier to just compress it into one straight shot.  My question is, what table and fields determines a user is online in a chatroom?  I'm guessing it's possibly the Users table, but not sure.  Anyways, I'm just trying to figure out how to detect those numbers.  Any help would be appreciated.  Thanks.

 

~Chad Johnson