Timeout and who is online

  •  03-29-2007, 9:01 AM

    Timeout and who is online

    Adam,

    I'm still evaluating the chatroom and have a few questions:

    -I'd like to set the timeout in the admin page. Can you confirm it has to be entered in seconds?

    -How do I know how many people are in a given chatroom programmatically ? It looks like I could query the CuteChatUser table and check the ContactSyncTime field but that would only give me the list of people who are online (not the list of people who are online in a given chatroom). Also is it possible to do this in .Net (using the CuteChat dll) or do I have to write my own SQL query?

    -I've integrated CuteChat with my own website so that the users don't have to login again when they enter the chat room. The login names are stored in the CuteChatUser table. To keep the size of this table minimal, is it ok to delete the login names directly in that table (eg to delete the login names of people who have not accessed the chatroom recently: delete from CuteChatUser where ContactSyncTime<'My Date'). If I do this, will it affect anything else? Is there a better way to do this?

    -I'd like to delete the messages without using the Admin page (so that it can be done automatically). Is it ok if I do something like this or will it affect anything else:
    delete from CutechatMessage where MessageTime < 'MyDate'

    -How do I know in which ChatRoom a message stored in CutechatMessage was said? It looks like I need to join the ChannelId field of the CuteChatMessage table to the LobbyId field of the CuteChatLobby table. Is this correct? If so, why did you call the 2 fields differently?

    Thanks,

    Anthony.

View Complete Thread