## Server Release 3.13.1 11 November 2020

### Fixed
- Database update script does not work for MySQL and PostgreSQL

## Server Release 3.13.0 9 November 2020

### Important
- Support for 32-bit builds of FreeBSD has been dropped. 64-bit FreeBSD is still supported.
- The server_quickstart.txt file is now in Markdown format as server_quickstart.md. It has also been significantly updated.

### Fixed
- Fixed slow startup after an SQLite schema migration
- Better handling of invalid base64 snapshots
- Fixed an issue with negative whisper power permission checks
- Fixed possible memory leak under certain obscure conditions
- Fixed query login groups being improperly cached in certain cases
- Invalid password attempts should respect SERVERINSTANCE_SERVERQUERY_BAN_TIME

### Added
- New support for PostgreSQL databases. Please read server_quickstart for more information.
- New support for MMDB style GeoIP databases (again, see server_quickstart!)
- Webquery supports access by server port : /byport/9987/clientinfo will send the command to the virtualserver at port 9987.
- Added warning for cases of UDP socket failure
- banclient can now accept multiple clientids
- banclient, clientmove and clientkick accept the -continueonerror parameter to ignore errors
- New optional parameter for clientlist '-location'
- Advanced users: Added a new command line argument `logquerytiminginterval` for diagnostic logging of ServerQuery timing.
- Advanced users: Added a new command line argument `querypoolsize` to allow you to specify the number of threads in the ServerQuery pool.

### Changed
- Note: query_ip_whitelist has been renamed to query_ip_allowlist, and query_ip_blacklist is now query_ip_denylist.
- Note: the old whitelist/blacklist names are still accepted.
- Webquery errors will return a HTTP 4xx series status code.
- Improved database performance for some query commands (notably serverlist)
- permget returns 'invalid perm id' error if permid is 0, or convert error if negative
- instanceedit no longer allows query groups for server template groups
- serveredit should correctly update client idle time
- Better validation of tokencustomsets when creating privilege keys
- Various permlist commands now include the relevant id (client, etc) in the output for your convenience
- MariaDB plugin should be a little more tolerant of broken connections
- We now print a warning if you specify an unknown command line option

## Server Release 3.12.1 31 March 2020

### Fixed
- Fixed bug related with new TS5 Client Permission Manager

## Server Release 3.12.0 18 March 2020

### Important
- New feature WebQuery that allows user to access to query system using http(s) and json. 

### Added
- New query commands `apikeyadd`, `apikeydel` and `apikeylist`
  for managing API keys used in WebQuery
- New permissions `b_virtualserver_apikey_add` and `b_virtualserver_apikey_manage` that restrict who can create/delete/list API keys.
- New possible value for parameter `query_protocols` named `http` and `https` that enables WebQuery
- New parameters `query_http_ip` and `query_http_port` that define where WebQuery can be reached, default is all interfaces on port `10080`
- New parameters `query_https_ip` and `query_https_port` that define where WebQuery can be reached, default is all interfaces on port `10443`

### Changed
- macOS 10.14 Mojave is required from now on
- Raised version of snapshots and added support for API keys 

### Fixed
- Whisper bug that resulted in users not being able to receive whispers
- Removed requirement of having a cpu with POPCNT for 32bit version, and added an appropriate error message for the 64bit version
- Deploying snapshots will import client and channel permissions, again