Since Video chat works directly through Media Server, chat history is not stored in the database automatically. To record chat logs, plug-in "history to db" was developed. Special handler, that can be found in folder flashcoms/videochat/plugins/history2Db/, gets the history from Media Server and sends it to the database every 30 seconds.

To install plug-in "chat history 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/history2db.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. Logs will be automatically added to the table "flashcoms_chat_history" 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/history2db.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. Logs will be automatically added to the table "flashcoms_chat_history" in your database.


The plug-in's main function is to update database table with new messages that were posted within 30 seconds . Plug-in's logic can be modified to the needs of any specific web-site (for instance to store logs in .txt file or send them to e-mail), with the help of the handler, stored in flashcoms/videochat/plugins/history2Db/