Besides the options inherited from standard edition of History to DB plugin , Pro version provides comprehensive analysis of chat activity by storing following information: message content, time, user's IP, public / personal token, ban/ kick history, enable / disable cam action.Simple web interface with built-in search and calendar modules facilitates ease in use and convenient navigation. Special handler, that can be found in folder flashcoms/videochat/plugins/history2DbPro/, gets the data from Media Server and sends it to the database.

To install plug-in "chat history to db PRO", 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/history2dbPro.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>

 

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/history2dbPro.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_");


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/history2DbPro/