Home Verkennen Help
Registreren Inloggen
subDesTagesMitExtraKaese
/
sinusbot-channel-statistics
1
0
Vork 0
Bestanden Issues 0 Pull-aanvragen 0 Wiki

log number of clients per channel to mysql

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

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!