Hi guys,
I have got your chat application running well in my app, and I am making use of the open "Integration" column in the chat_lobby table of the database to match chat rooms to sections of my site.
I do however still have the main chat page which lists all of the chat lobbies available. I see that the Lobbies are populated to the datalist via a call to
<code>
return ChatWebUtility.Api.GetLobbies();
</code>
What I was wondering if there is anyway to change the SQL query string called by this function to only select the lobbies where the Integration field is NULL, cause I can't seem to find it in the editable code. I would imagine that the query would look something like this:
<code>
SELECT name, description, announcement, password FROM chat_lobby WHERE integration IS NULL
</code>
Any ideas as to how I would achive this?
Thanks
Grisbi