TSN RANKSYSTEM

A PHP Bot that assigns time-based server groups
on your TeamSpeak server.

Download

The TSN Ranksystem is an open source project,
it is free to use under the GNU GPLv3 license.

Download the latest version:
DOWNLOAD (Version:1.3.20)
 

MD5: d9df64f1bd8ae098315caf2f158f900f

Do you like this tool?

Then you might want to sponsor a beer for the developer.

This enables them to develop new features more smoothly! ;-)
Donate (via PayPal)

Features

The TSN Ranksystem brings two components:

1) A TeamSpeak Bot &
2) A Website with:
- a statistics page (demo) &
- a web interface (demo)


TeamSpeak Bot
The TeamSpeak bot connects to the TeamSpeak server over the official TS3 Query interface. The bot does all back-end (background) jobs. It collects the online & active time of the TS3 user, calculates all statistics and collects several other data. It is also available for chat commands. And sure, it gives the server groups to the clients (e.g. military ranks, level, prestiges).

Statistics Page
On the public statistics page are several data available. There are displayed statistics about clients and the server.
It is much as powerful to describe all. To name only a few things:
- You'll find a ranking list, to get the most active users.
- It has also a server usage graph, which shows the online clients and channel per time.
- Client statistics about: online & active time, versions, nationalities, platforms, used slots, and much more...

Web Interface
With the web interface, you can easily administrate the bot. It is an access secured site for the administrators of the Ranksystem. They can manage the bot, like start and stop them. All parameters are defined in this place to individually configure the Ranksystem for the needed of your TS3 server. Sure, it is well documented directly inside the web interface.

Installation on Linux

1) Requirements

Before you can start running the TSN Ranksystem Bot on your TeamSpeak server, we need to check the requirements of your environment.

 

For the statistics page and to be able to run the Bot in a PHP process, we need a webspace (webserver).

 PHP 5.5.0 or higher (PHP 8.1 ready!)
 PHP with privileges for the command "exec"
 PHP with unlimited script execution time; especially you should check this on a webhosting
 required PHP extensions:
- PHP PDO extension
- PHP PDO MySQL driver
- PHP cURL extension
- PHP Zip extension
- PHP OpenSSL extension
- PHP SSH2 extension
- PHP mbstring extension

 network connection to the TS3 ServerQuery of your TS3 server on TCP; default port 10011
 network connection to ts-ranksystem.com (IP: 193.70.102.252 + 145.239.130.173) on TCP port 443
 optional: job scheduler (for automatically restart the Bot) like a cronjob

The database will storage all information. This is necessary to get a real time statistic page.

 MySQL (or derivative like MariaDB)
 requires its own database
 required privileges:
- Data:
SELECT, INSERT, UPDATE, DELETE
- Structure:
CREATE, ALTER, INDEX, DROP

To connect with the TeamSpeak 3 server, we need access to the TS3 ServerQuery interface.

 Network connection between the webspace and the TS3 ServerQuery
 TS3 ServerQuery User with following permissions:
- b_virtualserver_info_view
- b_virtualserver_client_list
- b_virtualserver_client_dblist
- b_virtualserver_client_dbsearch
- b_virtualserver_client_dbinfo
- b_virtualserver_notify_register
- b_virtualserver_servergroup_list
- b_virtualserver_servergroup_client_list
- i_group_member_add_power
- i_group_member_remove_power
- b_icon_manage
- b_client_remoteaddress_view
- i_client_private_textmessage_power
- i_ft_file_browse_power
- i_ft_file_download_power

 

2) Download & Unzip

Download and unzip the file ranksystem_latest.zip.

 

3) Upload to webspace

Upload the whole unzipped folder to a directory on your webspace and grant permissions to the user of your webserver.

 

4) Run install process

Open the "install.php" on your browser and follow the instructions https://your.url/ranksystem-folder/install.php.

 

5) Configure webinterface

Configure the TSN Ranksystem about the webinterface https://your.url/ranksystem-folder/webinterface/.
For each parameter you'll find a documentation by mouse click on it.

 

6) Start Bot

Start the TSN Ranksystem Bot via the webinterface.

 

7) Add cronjob (optional)

Optional: Create a cronjob to be sure, the Bot is running 24/7. This will restart the Bot automatically, e.g. on a database restart.

Open a SSH session to the host machine of your webserver.

Enter the command crontab -e, go to editing mode (in VIM you need to press i).

Paste the following in a new line:

*/10 * * * * sudo -u www-data php /path_to_your_webspace/path_to_the_ranksystem/worker.php check >/dev/null 2>&1

Configure the path, where your TSN Ranksystem is located and replace www-data with the user of your webserver.

Save and quit the crontab (in VIM :wq).

Installation on Windows

1) Requirements

Before you can start running the TSN Ranksystem Bot on your TeamSpeak server, we need to check the requirements of your environment.

 

For the statistics page and to be able to run the Bot in a PHP process, we need a webspace (webserver).

 PHP 5.5.0 or higher (PHP 8.1 ready!)
 PHP with privileges for the command "exec"
 PHP with unlimited script execution time; especially you should check this on a webhosting
 required PHP extensions:
- PHP PDO extension
- PHP PDO MySQL driver
- PHP COM extension
- PHP cURL extension
- PHP OpenSSL extension
- PHP SSH2 extension
- PHP mbstring extension

 network connection to the TS3 ServerQuery of your TS3 server on TCP; default port 10011
 network connection to ts-ranksystem.com (IP: 193.70.102.252 + 145.239.130.173) on TCP port 443
 optional: job scheduler (for automatically restart the Bot) like a task scheduler

The database will storage all information. This is necessary to get a real time statistic page.

 MySQL (or derivative like MariaDB)
 requires its own database
 required privileges:
- Data:
SELECT, INSERT, UPDATE, DELETE
- Structure:
CREATE, ALTER, INDEX, DROP

To connect with the TeamSpeak 3 server, we need access to the TS3 ServerQuery interface.

 Network connection between the webspace and the TS3 ServerQuery
 TS3 ServerQuery User with following permissions:
- b_virtualserver_info_view
- b_virtualserver_client_list
- b_virtualserver_client_dblist
- b_virtualserver_client_dbsearch
- b_virtualserver_client_dbinfo
- b_virtualserver_notify_register
- b_virtualserver_servergroup_list
- b_virtualserver_servergroup_client_list
- i_group_member_add_power
- i_group_member_remove_power
- b_icon_manage
- b_client_remoteaddress_view
- i_client_private_textmessage_power
- i_ft_file_browse_power
- i_ft_file_download_power

 

2) Download & Unzip

Download and unzip the file ranksystem_latest.zip.

 

3) Upload to webspace

Upload the whole unzipped folder to a directory on your webspace and grant permissions to the user of your webserver.

 

4) Run install process

Open the "install.php" on your browser and follow the instructions https://your.url/ranksystem-folder/install.php.

 

5) Set PHP Path

Set the path to the php.exe (PHP installation) inside the other\phpcommand.php. Examples you'll find inside this file.

 

6) Configure webinterface

Configure the TSN Ranksystem about the webinterface https://your.url/ranksystem-folder/webinterface/.
For each parameter you'll find a documentation by mouse click on it.

 

7) Start Bot

Start the TSN Ranksystem Bot via the webinterface.

 

8) Add new Task (optional)

Optional: Create a task inside the task scheduler to be sure, the Bot is running 24/7. This will restart the Bot automatically, e.g. on a database restart.

Windows help how to create a new task.

Add the following options:

C:\path\to\php.exe -f C:\path\to\Ranksystem\worker.php check

Configure the path, where you find your PHP installation and also the path where your TSN Ranksystem is located.

Get a hosting

When you are not able to host the TSN Ranksystem yourself, you can ask here for a hosting.

The hosting is absolutely free. If you want to support this service, donations are welcome. ;-)

If we accept your request, the hosting will remain as long as the Ranksystem Bot is running and able to connect to your TS server. Bots, which are offline for two weeks (=inactive), will be deleted. The hosting ends at this point. Before you will receive additional warnings; starting with an offline time of three days.


Request a hosting

With the hosting we take the part of the requirements of the webspace and the database.
You still need:
- ServerQuery credentials   (Required is an access to the TS3 server via ServerQuery; ServerQuery credentials (username and password) are necessary!
- Opened Firewall      (Be sure your TS3 server and all between (host machine, firewall, ...) allows a connection from our IP address 193.70.102.252 + 145.239.130.173).
- TeamSpeak whitelist    (You should whitelist these IP also inside the query_ip_whitelist.txt, which you'll find inside the TS3 server installation directory.)

 
 
 

After submitting your request, you will automatically receive an email for confirmation. Please check your spam folder if you can't find it. By confirming your email address, we will send you an additional email with all necessary information (hosting credentials & guide).

Bot Commands

CommandParameterBot-AdminDescription
!help
!info
!cmd
!commands		- none -- / -Get a list of valid bot commands
Since version 1.3.0 it will sends you here.
!version- none -- / -Returns the current version under which the Ranksystem runs.
!update
!checkupdate		- none -requiredPerforms a check for new available updates.
Since the Ranksystem updates itself automatically, the update
process will be started as soon as a new version detected.
!next
!nextup		- none -- / -This checks the user-related required time to reach the
next higher rank. The investigated time will be sent as a private
chat message to the user.
!restart
!reboot		- none -requiredInitiates a reboot of the Ranksystem bot.
!shutdown
!quit
!stop		- none -requiredInitiates a shutdown of the Ranksystem bot.
!log
!logs		Parameter 1
number of log entries
expect number between 1 and 999

Example:
!log 5
This will give you the last 5 log lines.		requiredGet the last few log entries of the Ranksystem-Log
via private chat message.
!runtime
!runtimes		- none -- / -Get the last 10 runtimes of the Ranksystem bot.
Each value represents the needed duration for one round
of the bot, measured in seconds.
!uptime
!online		- none -- / -The bot sends the time of the last (re)start and
also calculates the online time.
!memory- none -- / -Get the needed memory the Ranksystem bot is using inside the PHP process.
PHP brings a overhead, so the PHP process on the system needs more memory.
!clean- none -requiredStarts the process of cleaning the user database.
It only takes effect when the function 'clean clients' is activated.
!reloadgroups
!reloadicons		- none -requiredCleans the group cache.
All server groups will be reloaded from the TS3 server and associated with this the group icons will be re-downloaded.
Also the server icon will be re-downloaded.
 

Changelog

Explanation

!   Note          (bigger) change you should notice of; in some cases there are things to do
*   Information   for your information, but there is nothing you need to do; changed something works in background
+   Feature       added a new feature or enhanced a feature
-   Bugfix        fixed a bug or corrected something
 
 

1.3.21 - NOT YET RELEASED

*beta-2 * little improvements to be ready for PHP 8.2
beta-1 - fixed wrong rank positioning on MariaDB 10.6 or higher
*beta-2 - fixed wrong entity of special HTML characters under PHP 8.1 inside the Ranksystem log by displaying it on the webinterface (webinterface/bot.php)
 

1.3.20 (2022-06-17)

* added delay for adding / removing servergroup, when it runs into an TS3 server error (i.e. needed permissions are missed); to prevent spamming the Ranksystem log and the TS3 server
* added clean job for table 'user_iphash'; removes offline user from this table, which stucked in some special cases
* improved site load performance on 'Webinterface' -> 'TeamSpeak' settings on bigger databases; only load users, which were online between the last 30 days (for Bot-Admin)
* minor code optimizations, especially for PHP 8.1
* updated PHP smarty lib to version 4.1.0
- fixed wrongly shown the ServerIcon, when an user hasn't a rank group yet; concerned the 'Channelinfo Toplist' add-on
- fixed SQL error "Unknown column 'uuid' in 'where clause'" on exception mode 'reset time'
 

1.3.19 (2021-12-21)

- fixed SQL error during the update process (table: addons_config, column: value), which occurs in some environments
 

1.3.18 (2021-12-21)

! new TS3 permission 'b_virtualserver_channel_list' needed for channel tree
* updated hungarian language; thx to ExXeL
* removed installation path of the Ranksystem from udpate server check
+ added new add-on 'Channelinfo Toplist'; writes the Top 10 user to a channel description; TS3 permission 'b_channel_modify_description' needed for this add-on
+ added PHP smarty lib, which is used for the 'Channelinfo Toplist' add-on
+ added the possibility to disable the security check that the bot getting started from command line; in some environments (e.g. CPanel) this is needed
+ added a cancel option to the database export function; could be needed in case of running into trouble
+ added the timestamp of last seen in the confirmation request on admin function 'delete user'
+ added channel tree as a drop-down box in the webinterface on associated fields
- fixed SQL syntax error on add-on 'Assign Servergroups'
- fixed wrong operator comparision on change password function
- fixed SQL on webinterface saving an API key
- fixed possible XSS attack in log view & install.php
 

1.3.17 (2021-01-24)

- fixed database error on assign servergroups functions on statistics page, when changing the server groups
 

1.3.16 (2021-01-03)

! We will relocate our servers to a new host in the middle of January 2021; Be sure to allow a network connection to our new IP addresses 193.70.102.252 + 145.239.130.173 (TCP port 443) to be able to receive future Ranksystem updates; the old IP address (164.132.201.2) will be reachable until the end of January 2021
* we added a connection test to the update server of the Ranksystem (on the startup of the Ranksystem) to warn if a connection fails
* changed MySQL connection to a none persistent connection, when it is not the Ranksystem Bot
* changed update check for the Ranksystem database; when the version is below 1.3.0 it now stops the Ranksystem with a critical error
+ added to API to the functions 'user' & 'userstats' the possibility to ask for multiple servergroup database IDs in a single request; example: 'groupid=6,9,48'
+ added new check for clients deleted from the TeamSpeak server, which are reconnecting with the same unique-client-ID and are still known by the Ranksystem; this clients will now get undo the "removed-flag"
+ added function to delete manually a user (or multiple) out of the Ranksystem database
- fixed on the List Rankup (statistics page) the buttons for the first / last page on the pagination
 

1.3.15 (2020-12-20)

* changed HTTPS check; the warning message that HTTP is used now appears only on the login page of the webinterface
* added check on database export, ZIP version is >= 1.2.0, which is needed to encrypt the ZIP file
- fixed problem on PHP 8.0 on new installations (Uncaught TypeError server_usage.php:8)
 

1.3.14 (2020-12-13)

! We added a new Wiki page for the Ranksystem API to Github
* updated jQuery library to version 3.5.1
* updated Font Awesome library to version 5.15.1
* updated bootstrap-select library to version 1.13.14
* updated flag-icon-css library to version 3.5.0
* updated Bootstrap Switch library to version 3.3.4
* updated hungarian language; thx to ExXeL
* changed the language dropdown symbol to the conutry icon
* minor code optimizations
+ added the possibility to define multiple groups to the add-on 'Assign Servergroups'
+ added a second sort level for the List Rankup (statistics page)
+ made the filesize on the new database export function dynamic
- fixed little CSS problem on the List Rankup (statistics page)
- fixed automatic reconnection, when the TS3 server connection was lost
- fixed switch button for 'Permanent Group' was not working after adding a new line on 'Rank Definition' site
 

1.3.13 (2020-11-22)

! PHP 8.0 is now supported (older versions like PHP 7.x and also PHP 5.6 are still supported)
! changed API user list by 'status'; old request was '&user&online' -> now use '&user&status=online' instead
* on database connection lost, we now try to restore the connection; a reconnect of the Ranksystem TS bot in this situation is no longer necessary
* reworked code for "fast hashing" mode for "hash IP addresses", since PHP 8.0 dropped the custom salt on passwort_hash function
* some code optimizations, also to get a better support for PHP 8.0
* users whose 'last seen' was more than 30 days ago will not be calculated any more (statistics like online last week/ month)
* moved PHP functions to its own file others/_functions.php
* optimized error log handling
* updated hungarian language; thx to ExXeL
* updated czech language; thx to Stetinac
* changed ZIP-handling in Ranksystem automatic update process to support PHP 8.0
* added also a message to the log, when the process of the Ranksystem bot was kill during stop / restart command
* optimized Ranksystem log view on the webinterface; especially on array dumps
+ added a database export function to the webinterface; this generates an SQL export file, which is zipped
+ added the possibility to sort the columns nation, version + platform on the statistics page (stats/list_rankup.php)
+ added parameter to the webinterface to set the 'SameSite' session attribute
+ added parameter to the webinterface to set the 'Access-Control-Allow-Origin', 'X-Content-Type-Options', 'X-Frame-Options' & 'X-XSS-Protection' header
+ added to API to the functions 'user' & 'userstats' the 'status' parameter; now you can get 'online' & 'offline' users
+ added to API to the functions 'user' & 'userstats' the 'groupid' parameter to get user by a defined servergroup database ID
- fixed problem, where user were shown in top users list (week, month & all) on statistics page, although they were excluded by server group exception; thx to Arci224 for reporting
- fixed lost filter (options) on the statistics page (stats/list_rankup.php)
- fixed add / remove time for offline users; problem with caching since version 1.3.9
 

1.3.12 (2020-09-21)

* changed the handling of text messages, which are sent from the Ranksystem Bot; now they will be sent to the same location as it is received (server chat, channel chat or private chat) without some sensitive things like !log or !next, which will be always send as private message
* changed also the handling of text messages, which are sent from the Ranksystem Bot; now we are trying to send the message to the connection ID of the user, if it is known; otherwise we still use the unique client-ID to send the message; this solves the problem, a user didn't receive a message, when the Ranksystem bot has the same unique client-ID like the sending user
* updated hungarian language; thx to ExXeL
* updated czech language; thx to Arci224
* updated polish language; thx to toster234
+ added function to add an imprint and privacy policy site to the stats page; thx to Nick Slowinski
+ added new option "permanent group" to the rank definition; this allows to set a flag for a server group that shouldn't be removed at the next rank increase; this could be nice for groups such as "member", which should stay as a permanent group
- fixed problem "SQL Unknown column 'count_week' in 'field list'" which comes with the client-database-ID check since the last release
 

1.3.11 (2020-09-07)

* on changing a TeamSpeak client-database-ID a user losts his "Top users" stats for week & month; this could especially happen, when a relocation to a new TeamSpeak server happened; now we try to update the old stats and replace its client-database-ID with the new one; if this is not possible, the weekly & monthly stats of the old client-database-ID will be reset to show a correct "Top users" list
* updated hungarian language; thx to ExXeL
+ added new columns nation, version & platform (/stats/list_rankup.php) as option to the default sorting
+ added excepted group list to the addon assign servergroups
+ added info to bot status inside the webinterface, when the autostart is deactivated
+ added the possibility to hide also the channel stats inside the server usage graph
- fixed problem "SQL unknown column 'rank' in 'field list'" on resetting user stats; field was being removed with version 1.3.8 in database, but not on this position
 

1.3.10 (2020-08-08)

* changed avatar download; download only 10 avatars a loop; continue within the next loop
+ added time of the last calculation to the my statistics page (/stats/my_stats.php)
+ added columns nation, version & platform as selectable option to the statistics page (/stats/list_rankup.php)
- fixed problem "1281: sql empty result set; Error due command clientdbinfo for client-database-ID XXX (permission: b_virtualserver_client_dbinfo needed)" occurs repeated in the log; now it will be tried to get the new database-ID and store this
- fixed problem "SQL commands failed: Data too long for column 'nation' with value 'UNKNOWN'"
- fixed problem "SQL commands failed: Out of range value for column 'server_ping' at row XXX"
- fixed problem "SQL commands failed: Out of range value for column 'total_connections' at row XXX"
- fixed missed download of groups when using command !reloadgroups; groups will be cached and the cache were not deleted on using the bot command
 

1.3.9 (2020-08-02)

* reworked core component of the bot; store/cache most values instead of reloading it from the database with every loop; this brings especially on bigger Ranksystem databases with a couple thousand of users a really big performance boost (reduces CPU load & load on the database)
* updated russian language; thx to bykidi
* updated hungarian language; thx to ExXeL
+ added to API the function 'userstats' to get more statistics about user and be able to sort for example for top user of the week
+ added 'sort', 'order' and 'limit' function to API
 

1.3.8 (2020-06-20)

! disabled update support for Ranksystem versions below 1.3.0
* added delay (5s) on syncing TS3 ServerGroups with the Ranksystem
* changed log output with log-level "6 - debug"; now also the concerned SQL statements are given out beside the error
* changed icon download as TS-iconid instead of servergroup-database-ID (needed for upcoming things)
* changed icon download with file extension (determined with MIME-Type) to be able to support all official supported extensions by TeamSpeak (bmp, gif, jpg, pbm, pgm, png, ppm, svg, xbm, xpm)
* optimized traffic & memory usage on query command "clientlist" (ts3phpframework)
* updated russian language; thx to bykidi
* updated czech language; thx to Stetinac
* updated polish language; thx to toster234
* updated hungarian language; thx to froland20
* updated portuguese language; thx to Pasha
* little database optimizations; especially on table user_snapshot (reduced storage size to ~half)
* added new check for duplicate client database IDs; this is important for the database optimization for table user_snapshot
+ added support for SVG icons (servergroup and servericon)
+ added to API an identification via API key; keys can be managed about the Ranskystem webinterface; usage /api/?apikey=XXXXX
+ added to API a function to get the online user
+ added check of multiple PHP versions also to the install process; to help to install the needed PHP extensions to the right PHP installation
+ added check for negative values of online time or idle time of a user (could happened about the administration function, when to much time was manually removed); this user will be set to zero, once with this update
+ several minor optimizations on the install process
- fixed problem, when boost group was removed manually from a user; in this case the Ranksystem did remove the boost-group instantly on giving a boost-group on a new situation (to the concerned user) instead of taking care of the (new) boost-duration
 

1.3.7 (2020-02-14)

! resorted webinterface, since we try to get a better structur, some things were also meaningful by adding the "expert mode"; 
! redesigned a few form fields inside the webinterface; for a better usability we replaced some fields with a drop-down field, where we have the selection (values) from the TeamSpeak server (e.g. client exceptions, servergroup exceptions); this is possible since we added the "easy mode" to the installation routine
* updated FontAwesome library to version 5.12.1
+ added an easy mode for fresh installations; it will display only the "TeamSpeak" site and the "Start / Stop bot" function inside the webinterface, until the bot is started for the first time; this is needed, since some (dropdown) fields will get its data from the TS server
+ added API for third party applications to get information as JSON string; the API is documentated by itself; simple open the URL and follow the instructions; available data are user (+stats), servergroups, serverstats & rank config; (we are curious what kind of ideas you have and what cool shit you will do with it :-P  on questions and also when you have notices, let it know us!)
+ added user friendly option to customize the "boost definition"
+ added "expert mode" inside the webinterface to toggle between a clearly / simply view (default) and the expert view with all functions / parameters
+ added check to prevent negative values on removing time (about the administrate function inside the webinterface); this could happen before, if a too large value was entered
+ added sorting for the servergroup selection inside the webinterface; the sort is now the same as in TeamSpeak; query and template groups are disabled
+ added function to "Select All" or "Deselect All" on multiple choice drop-down fields
- fixed empty error message due installation, when PHP-MySQL isn't installed / enabled
- fixed mistake on administrate function "remove time", when multiple users were selected; each second user got the time added instead of removed
- fixed problem with lost time (donwgrade some user), when the connection to the TeamSpeak server was lost
- fixed continuous download of "new ServerIcon"; happened in the rare case of changing the icon-date without changing the icon itself
- fixed lost check-icon on multiple drop-down boxes, with one of the last bootstrap updates
 

1.3.6 (2020-01-13)

! Hotfix
- fixed wrong check on reset password function (security issue)
 

1.3.5 (2019-12-23)

! Hotfix
- fixed problem loosing the rankup definition on saving options inside the webinteface core-site
 

1.3.4 (2019-12-23)

* optimized check for Bot name; added min-length of 3 characters to avoid errors due connecting virtual server
* updated hungarian language; thx to ExXeL
* little code optimization on reset password function for the webinterface
* updated Bootstrap-select library to version 1.13.9
+ added user friendly option to customize the "rank up definition"
+ added check PHP extension mbstring is loaded
+ added azerbaijan language; thx to G. FARZALIYEV
+ added new configuration parameter for the max. clients (red) line on the server usage graph on the statistics page
- fixed spelling error in russian language; thx to Alexander
- fixed "Undefined offset" on list_rankup.php, when stored servergroup of user (which is longer time offline) isn't existing anymore
 

1.3.3 (2019-07-26)

! new PHP extension mbstring is needed
* optimized SQL statement of building user_snapshots
+ added hungarian language; thx to ExXeL
- fixed handling user nicknames with multibyte characters and a length longer 30
- fixed PHP warning on stats/top sites, when servergroup exception is empty
 

1.3.2 (2019-07-01)

- fixed looping systems, when user nicknames are longer than 28 characters
 

1.3.1 (2019-06-30)

! new TS3 permission 'b_virtualserver_servergroup_client_list' needed for reset function
! new TS3 permission 'b_virtualserver_client_dbsearch' needed for special case cldbid has changed
* performance optimization with optimizing the SQL handling; a few statistic values will be cached inside PHP and only saved to DB, when changes have taken place
* updated jQuery library to version 3.4.1
* updated Bootstrap library to version 3.4.1
* changed Ranksystem log; added few more things to log during startup (loglevel, query-slowmode, update-channel); changed some things to be forced to log during startup, also when bot level is very low
* optimized downloading of servergrous & icons on TS3 errors (e.g. connection lost)
* minor code optimizations
* changed core rankup assigning; now check wrong server groups and remove them; if the current level is missed, correct it and add the server group
* changed navbar inside the webinterface to be more clearly and structured
+ added automatically language support; when you add a file inside the languages folder and it fullfill the name conventions, it will be added automatically; more information you will find inside the /languages/add_new_language.php
+ added check for changed client-database-ID (e.g. happens on restoring a server snapshot) for offline user; This check was still here, but only for online user; cldbid will be updated or the time of the user reset depending on specification of 'Client-database-ID reset'
+ added new function to reset the Ranksystem
+ added bot command !memory
+ added an average looptime to the !runtime command
- fixed "DateTime::__construct()" error on /stats/my_stats.php when boost function is defined with decimal numbers
- fixed "TS3 Error: 0: only available in non-blocking mode" on secured (SSH) TS Query connection
- fixed XSS vulnerability on /stats/ top users via client_nickname
- fixed online status of users; when the last user left the TS server, it stayed online on 'List Rankup' page
- fixed rarely constellation on update servergroups in bot core, when none of this groups have an icon and also no servericon is set
- fixed rarely constellation in bot core, when only user(s) without any country flag (pre-4: or without any platform or without any version) are online
- fixed wrong response on command !clean, that you wouldn't be allowed to use the command despite admin privileges
 
Show older entries

Support

Please report bugs and also feature requests preferred on GitHub.

You can also get support on our public TeamSpeak server ts-n.net.
Contact an admin there (server group: Ranksystem Staff Ranksystem - Staff). Please stay patient, when we don't react immediately. Please give us at least 10-15 minutes to response.

You want to ask for a free hosting? Have a look above to request a hosting.