chat room number

[trattore]

I would take the number of users in the chat room and place it in an html page built from me you can do it? thx

[fortrefuge]

id like that number too, if possible. number AND the list of usernames would be even better. i think i can get it through php sessions, but of course it would be easier to just get it from chat, if it were available.

[NWattenberger]

This is an older thread, but I was about to post much the same. In VBulletin, I would like to obtain the number of users in the chat rooms so I can put it at the top of the forum so that members know it is active. Possibly also a list of the members in a sidebar.

[jvdend]

I have use this:

Code: Select all

$chatcafe_online=0;

$sql = "SELECT COUNT(user_id) FROM arrowchat_chatroom_users WHERE (chatroom_id='1' AND session_time > (" . time() . " - 70))";

$result = mysql_query($sql);
$row = mysql_fetch_array($result);
$chatcafe_online = $row[0];