Startseite Erkunden Hilfe
Registrieren Anmelden
subDesTagesMitExtraKaese
/
sinusbot-channel-statistics
1
0
Fork 0
Dateien Issues 0 Pull-Requests 0 Wiki

log number of clients per channel to mysql

Struktur: e9c874494d
Branches Tags
sinusbot-channe...
ZIP TAR.GZ
subDesTagesMitExtraKaese e9c874494d added layout for mobile vor 3 Jahren
ts3-viewer e9c874494d added layout for mobile vor 3 Jahren
.gitignore 3566d3443c fixed floating checkboxes vor 3 Jahren
README.md 63cde7404a updated readme vor 3 Jahren
channel-statistics.js 1ab2f5536c fixed duplicate channel bug vor 3 Jahren
createTables.sql 1ab2f5536c fixed duplicate channel bug vor 3 Jahren
ts3-stats.png 5f6e645d14 updated screenshot vor 3 Jahren

README.md

Sinusbot Channel Statistics

Log number of clients per channel to mysql

With the help of the sinusbot script channel-statistics.js the number of connected clients for each channel will be logged to a mysql database.

PHP graphical frontend

A php viewer script is located in ts3-viewer/. It is an interactive flot graph implementation combined with a channel navigator.

demo

Installation

Backend

tested on: mysql-server8, sinusbot scripting v8

  1. Create a MySQL database and import the table definitions.
  2. Copy the channel statistics plugin to your sinusbot scripts folder.
  3. Restart the sinusbot client and enable the plugin.
  4. Configure the MySQL connection in the admin panel of sinusbot.

Frontend

tested on: mysql-server8, apache2, php7.4

  1. Copy the ts3-viewer/ folder into your php webroot.
  2. Insert your database credentials into connection.php.
  3. Done!