log number of clients per channel to mysql
subDesTagesMitExtraKaese
e9c874494d
added layout for mobile
|
před 3 roky | |
|---|---|---|
| ts3-viewer | před 3 roky | |
| .gitignore | před 3 roky | |
| README.md | před 3 roky | |
| channel-statistics.js | před 3 roky | |
| createTables.sql | před 3 roky | |
| ts3-stats.png | před 3 roky |
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.
Installation
Backend
tested on: mysql-server8, sinusbot scripting v8
- Create a MySQL database and import the table definitions.
- Copy the channel statistics plugin to your sinusbot scripts folder.
- Restart the sinusbot client and enable the plugin.
- Configure the MySQL connection in the admin panel of sinusbot.
Frontend
tested on: mysql-server8, apache2, php7.4
- Copy the
ts3-viewer/folder into your php webroot. - Insert your database credentials into
connection.php. - Done!