Since Video chat works directly through Media Server, names of chat users are not stored anywhere. To record on-line users, plug-in "users to db" was developed. Special handler, that can be found in folder flashcoms/videochat/plugins/users2Db/, gets the list of users from Media Server and sends them to the database.

To install plug-in "users to db", please follow these instructions:

Edition

1. Use sql dump to create necessary tables in your database. The dump can be found in your package in the following folder:

flashcoms/_install/sql/users2Db.ms.sql

2. Indicate database connection string in file web.config:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=database_server;Initial Catalog=database_name;Integrated Security=false;User ID=database_user;Password=database_password" providerName="System.Data.SqlClient"/>
</connectionStrings>

3. On-line users will be automatically added to the table "flashcoms_chat_users" in your database.

 

Edition

1. Use sql dump to create necessary tables in your database. The dump can be found in your package in the following folder:

flashcoms/_install/sql/users2Db.my.sql

2. Indicate database connection string in file flashcoms/common/server/php/settings.php:

// DB connection
define("DB_HOST", "localhost");
define("DB_USER", "");
define("DB_PASSWORD", "");
define("DB_NAME", "");
define("DB_PREFIX", "flashcoms_");

3. On-line users will be automatically added to the table "flashcoms_chat_users" in your database.


The plug-in's main function is to update database table, when user enters/leaves the chat. Plug-in's logic can be modified to the needs of any specific web-site, with the help of the handler, stored in flashcoms/videochat/plugins/users2Db/