Release notes V 4.8
New Feature
If you are upgrading, then run the below command on mysql on css bans database where panel tables exists
CREATE TABLE `server_player_stats` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`server_id` bigint(20) unsigned NOT NULL,
`player_count` int(11) NOT NULL,
`map` varchar(50) NOT NULL,
`recorded_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=110 DEFAULT CHARSET=utf8mb4
How to setup cron?
Setup a cron to run this url every 5 minutes which is supported on VPS/shared hosting already
https://yoursite.com/stats/player_count?token=replacehere with token(can be found in .env _token)
Example:
*/5 * * * * `https://yoursite.com/stats/player_count?token=123r48