c0n
|
That is why I was saying AIM needs a chat index page for the website. :) If we had a list of what chatrooms were "chatty" perhaps more people would join those rooms.
SELECT CR.RoomName, count(CR.RoomName) MemberCount
FROM ChatRoom CR
JOIN RoomMembers RM on RM.roomname = CR.roomname
GROUP BY CR.RoomName
The only down-side is that there is no way to specify the difference between private and public rooms, but that would kinda make it more fun. Just make them all public like IRC. It's our AIM now. lol
BOOM!
|