Chat Room SDK

New free Chat Room SDK for Foo Basic Web Studio (ASP.NET)

This SDK is supported in Foo Basic Web Studio (version 4.3.75 and later)






New! Ajax Chat Room SDK  - Try Live Demo

Download Demo's Source Code  




Foo Basic Chat Room SDK is a free quick, easy, scalable, and reliable chat room solution that allows Foo Basic Web Studio users to add real-time online chat rooms to their Foo Basic Web Studio web applications. The Chat Room SDK eliminates the need to use or host a chat server. no chat server required. It allows you to seamless offer your authenticated (signed in) website users to have access to multiple real-time online chat rooms without the user having to sign on to a chat server. Chat Room SDK is the best and most comprehensive solution so far to have your users communicate in real-time cross-browser and cross platform.


The SDK is automatically supported built into the new soon to be released Foo Basic Web Studio (version 4.3.75). A free Chat Room SDK Foo Basic sample web project will be posted in this Facebook group's file section. Foo Basic Web Studio version 4.3.75 is also scheduled for release later today in this Facebook group's file section. This SDK will only function on your local or live server after you request the required WebChat.lic file from Foo Basic technical support. This license file is totally free to registered Foo Basic Web Studio users. 





Chat Room SDK Functions

  • Public Shared Function ChatFunct_ChatScrTextGet(ByRef DataControlChatRooms As WebDataControl, ByVal strChatRoomID As String, Optional ByRef plngRecordsAffected As Long = 0, Optional ByRef strSQLError As String = "") As String
FooBasicWebChat.FooBasicWebChat.ChatFunct_ChatScrTextGet

  • Public Shared Function ChatFunct_GetPeoplInRoomList(ByRef DataControlPeopleInRoomList As WebDataControl, ByVal strChatRoomID As String, ByRef lstInRoomList As ListBox) As Boolean
FooBasicWebChat.FooBasicWebChat.ChatFunct_GetPeoplInRoomList

  • Public Shared Sub ChatFunct_RefreshChatRoomList(ByRef DataControlChatRooms As WebDataControl, ByRef lstChatRooms As ListBox, ByVal gintChatResponseLevel As Long)
FooBasicWebChat.FooBasicWebChat.ChatFunct_RefreshChatRoomList







Chat Room SDK Methods

  • Public Shared Function ChatFunct_ChatInRoomListAdd(ByRef datacontrolchatrooms As WebDataControl, ByVal strUserID As String, ByVal strChatRoomID As String, Optional ByVal plngRecordsAffected As System.Int32 = 0) As Boolean
FooBasicWebChat.FooBasicWebChat.ChatFunct_ChatInRoomListAdd

  • Public Shared Sub ChatFunct_ChatInRoomListRemove(ByRef DataControlChatRooms As WebDataControl, ByVal strUserID As String, Optional ByVal plngRecordsAffected As System.Int32 = 0)
FooBasicWebChat.FooBasicWebChat.ChatFunct_ChatInRoomListRemove

  • Public Shared Sub ChatFunct_ChatInRoomListRemove(ByRef DataControlChatRooms As WebDataControl, ByVal strUserID As String, Optional ByVal plngRecordsAffected As System.Int32 = 0)
FooBasicWebChat.FooBasicWebChat.ChatFunct_ChatInRoomListRemove

  • Public Shared Sub ChatFunct_PurgeOldChatScreenRecs(ByRef DataControlChatRooms As WebDataControl, Optional ByVal intMinsToAllMsgOnMainChatScr As Integer = 3, Optional ByVal plngRecordsAffected As System.Int32 = 0)
FooBasicWebChat.FooBasicWebChat.ChatFunct_PurgeOldChatScreenRecs

  • Public Shared Sub ChatFunct_PurgeOldImInRoomRecs(ByRef DataControlChatRooms As WebDataControl, ByVal intChatResponseLevel As Integer, Optional ByVal plngRecordsAffected As System.Int32 = 0)
FooBasicWebChat.FooBasicWebChat.ChatFunct_PurgeOldImInRoomRecs

  • Public Shared Function ChatFunct_RefreshInRoomList(ByRef DataControlPeopleInRoomList As WebDataControl, ByVal strChatRoomID As String, ByRef lstInRoomList As ListBox) As Boolean
FooBasicWebChat.FooBasicWebChat.ChatFunct_RefreshInRoomList

  • Public Shared Function ChatFunct_RoomAddToDatabase(ByRef datacontrolchatrooms As WebDataControl, ByVal strChatRoomName As String, Optional ByVal plngRecordsAffected As System.Int32 = 0, Optional ByVal strError As String = "") As Boolean
FooBasicWebChat.FooBasicWebChat.ChatFunct_RoomAddToDatabase

  • Public Shared Sub ChatFunct_RoomExit(ByRef DataControlChatRooms As WebDataControl, ByRef tmrRefreshImInARoomRec As Timer, ByRef tmrRefreshInRoomList As Timer, ByVal intChatResponseLevel As Integer, ByVal strUserID As String)
FooBasicWebChat.FooBasicWebChat.ChatFunct_RoomExit

  • Public Shared Function ChatFunct_RoomRemoveFromDatabase(ByRef datacontrolchatrooms As WebDataControl, ByVal strChatRoomName As String, Optional ByVal plngRecordsAffected As System.Int32 = 0, Optional ByVal strError As String = "") As Boolean
FooBasicWebChat.FooBasicWebChat.ChatFunct_RoomRemoveFromDatabase

  • Public Shared Function ChatFunct_ChatScrTextSend(ByRef DataControlChatRooms As WebDataControl, ByVal strChatRoomID As String, ByVal strUserID As String, ByVal strTextSent As String) As System.Int32
FooBasicWebChat.FooBasicWebChat.ChatFunct_ChatScrTextSend







3 Required Microsoft SQL Server Database Tables
  • tblChatRooms - This table stores the list of chatrooms displayed by the ChatFunct_RefreshChatRoomList function.
  • tblChatRoomText This table stores the text thats displayed on the main chatroom screen by the ChatFunct_ChatScrTextGet function.
  • tblChatRoomUsersInRoom This table stores the list of chatroom users in each chatroom displayed by the ChatFunct_GetPeoplInRoomList function.





Microsoft SQL Server Database Tables Scripts


Below is a Microsoft SQL Server script to assist you in recreating the required tblChatRooms database table. 

CREATE TABLE [dbo].[tblChatRooms](
[ChatRoomID] [int] IDENTITY(1,1) NOT NULL,
[ChatRoomName] [varchar](25) NOT NULL,
 CONSTRAINT [PK_tblChatRooms] PRIMARY KEY CLUSTERED 
(
[ChatRoomID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO




Below is a Microsoft SQL Server script to assist you in recreating the required tblChatRoomText database table. 

CREATE TABLE [dbo].[tblChatRoomText](
[ChatRoomID] [int] NOT NULL,
[ChatroomUserID] [varchar](50) NOT NULL,
[TextSent] [varchar](50) NULL,
[DateTimeSent] [datetime] NOT NULL
) ON [PRIMARY]

GO




Below is a Microsoft SQL Server script to assist you in recreating the required tblChatRoomUsersInRoom database table. 

CREATE TABLE [dbo].[tblChatRoomUsersInRoom](
[ChatRoomID] [int] NOT NULL,
[ChatroomUserID] [varchar](50) NOT NULL,
[LastPing] [datetime] NULL
) ON [PRIMARY]

GO