5.7 DEV build 3211

This dev release includes new features and bugfixes done during a surprisingly productive weekend.

Full release still requires solving problems that arise from MariaDB 11.8.3 change where innodb_snapshot_isolation has now been turned on as default

Special thanks to Kopo, SaolGhra, TWJohnJohn20116, Shadowhackercz, Vankka, DrexHD & Jsinco for contributions to this update

Changes since DEV build 3189

Added Players online list -tooltip to Players Online graphs
Added support for nickname search in player tables
Added Time.Periodical_tasks.Extension_player_data_refresh_every setting (default 15 MINUTES) which only affects plugins that decide to support it.
Made gathered PlaceholderAPI data update periodically
Added more Query filters (Played on date, Activity group on date, Last seen between)
Added Before and After checkboxes to all between filters to allow more flexible filtering
Added theme editor to navigation item
Fixed theme.yml being recreated
Fixed night mode issues where something had no colors set
Possibly fixed ShutdownDataPreservationTransaction failing on existing join address insert
Fixed playtime queries to include playtime where session started before view window or ended after.
Fixed Query timezone inconsistency between time fields and the graph
Fixed 'View full query' button in the modal that opens when clicking Server calendar
Fixed clicking Server calendar results including players who played on other servers during selected days

Change log

Website

Theme Editor

You can now create your own themes for Plan without needing Html Customization. This is the main new feature of this version and is documented here.

theme.yml has now been deprecated and will be deleted if it only contains default values

MSPT (Milliseconds per Tick)

Milliseconds per Tick (average/95th percentile) have been added to performance metrics on all applicable platforms.

Players online -tooltip

You can now hover over Players online graph to see who was online at specific time (up to 63 players).

Query page improvements

New filters have been added
- Played on date
- Activity group on date
- Last seen between
All 'between' filters now support 'Before' and 'After' by deselecting one of the checkboxes (e.g. played between -> played before)
Multi-select components have been replaced with a mobile friendly, text searchable alternative that no longer requires pressing Shift for multi-selection
Fixed timezone inconsistency between View time input fields and the graph

Other

Kills table can now be searched/sorted/exported and gets up to 25000 entries from the database
Added Uptime data to Performance as Numbers tables
Added support for nickname search in player tables
Performance graph tabs now sync the graph range-finder so that you can view different data for same time easier
Network performance graph colors now vary between servers to be easier to read
Fixed extra Series label appearing in HTTP mode on Performance graph (This is the plugin version history series in HTTPS mode)
Fixed some night mode text invisibility issues
SaolGhra fixed error r.includes is not a function related to Litebans
Fixed 'View full query' button in the modal that opens when clicking Server calendar
Fixed clicking Server calendar results including players who played on other servers during selected days

Config

Jsinco updated 'Data_gathering.Join_addresses_.Filter_out_from_data' to support regex. Note that any existing setting values with . (dot character) will now match any character.
Display_options.Theme (default "default") now refers to theme name in the theme editor rather than "What theme.yml to copy values from"
Display_options.Night_mode (default false) added

Data

MSPT average and 95th percentile added to plan_tps table
Register date 0 (1970-01-01) is now regarded as invalid.
Ban status is now updated by an automatic task that cycles through all known players small amount at a time

Sponge

Sponge API 14 is now used, API 8 is no longer supported.

Fabric

Fabric was updated to 1.12.9 by DrexHD (Supports 1.12.11 as well)

Velocity

Velocity was updated to 3.5.0-SNAPSHOT

Database

Database move system rewrite

Rewrote the system responsible for copying data from one database to another since previous system would crash under large datasets. The goal of this was to allow copying large SQLite databases to MySQL even on larger servers. The system was tested against a 3 GB database on a server with 1 GB of allocated memory.

/plan db move, /plan db backup, /plan db restore use the new system
Added /plan db merge command (permission: plan.data.merge) which allows merging SQLite data to existing MySQL. This is useful for those merging multiple servers into a network when all servers had Plan installed on separate SQLite databases.

Other

id column added to old plan_tps tables that did not have it yet via Patch.
If MySQL runs into error code 1020 'Stale read' error, the transaction will retry instead of erroring
Fixed dyplicate key violation related to AllowListBounce
Possibly fixed ShutdownDataPreservationTransaction failing on existing join address insert
Fixed playtime queries to include playtime where session started before view window or ended after.

Locale

Dates, time amounts & country names are now translated based on the selected locale. (If specific ones aren't please report it as a bug)
HighCharts & Calendar are now translated based on the selected locale
TWJohnJohn20116 updated zh_TW locale
Shadowhackercz updated CS locale

Extensions

Fixed ArithmeticException related to LibertyBans when bans were infinite
Fixed an issue related to rendering boolean values
Updated Jobs extension to support newer version
Added Time.Periodical_tasks.Extension_player_data_refresh_every setting (default 15 MINUTES) which only affects plugins that decide to support it.
Made gathered PlaceholderAPI data update periodically

Placeholders

Fixed network_players_online always saying 0

Other

Vankka updated DependencyDownload to clean up libraries folder of old versions
Kopo updated the build system to speed up builds & IDE indexing performance

5.7 DEV build 3211

This dev release includes new features and bugfixes done during a surprisingly productive weekend.

Full release still requires solving problems that arise from MariaDB 11.8.3 change where innodb_snapshot_isolation has now been turned on as default

Special thanks to Kopo, SaolGhra, TWJohnJohn20116, Shadowhackercz, Vankka, DrexHD & Jsinco for contributions to this update

Changes since DEV build 3189

Added Players online list -tooltip to Players Online graphs
Added support for nickname search in player tables
Added Time.Periodical_tasks.Extension_player_data_refresh_every setting (default 15 MINUTES) which only affects plugins that decide to support it.
Made gathered PlaceholderAPI data update periodically
Added more Query filters (Played on date, Activity group on date, Last seen between)
Added Before and After checkboxes to all between filters to allow more flexible filtering
Added theme editor to navigation item
Fixed theme.yml being recreated
Fixed night mode issues where something had no colors set
Possibly fixed ShutdownDataPreservationTransaction failing on existing join address insert
Fixed playtime queries to include playtime where session started before view window or ended after.
Fixed Query timezone inconsistency between time fields and the graph
Fixed 'View full query' button in the modal that opens when clicking Server calendar
Fixed clicking Server calendar results including players who played on other servers during selected days

Change log

Website

Theme Editor

You can now create your own themes for Plan without needing Html Customization. This is the main new feature of this version and is documented here.

theme.yml has now been deprecated and will be deleted if it only contains default values

MSPT (Milliseconds per Tick)

Milliseconds per Tick (average/95th percentile) have been added to performance metrics on all applicable platforms.

Players online -tooltip

You can now hover over Players online graph to see who was online at specific time (up to 63 players).

Query page improvements

New filters have been added
- Played on date
- Activity group on date
- Last seen between
All 'between' filters now support 'Before' and 'After' by deselecting one of the checkboxes (e.g. played between -> played before)
Multi-select components have been replaced with a mobile friendly, text searchable alternative that no longer requires pressing Shift for multi-selection
Fixed timezone inconsistency between View time input fields and the graph

Other

Kills table can now be searched/sorted/exported and gets up to 25000 entries from the database
Added Uptime data to Performance as Numbers tables
Added support for nickname search in player tables
Performance graph tabs now sync the graph range-finder so that you can view different data for same time easier
Network performance graph colors now vary between servers to be easier to read
Fixed extra Series label appearing in HTTP mode on Performance graph (This is the plugin version history series in HTTPS mode)
Fixed some night mode text invisibility issues
SaolGhra fixed error r.includes is not a function related to Litebans
Fixed 'View full query' button in the modal that opens when clicking Server calendar
Fixed clicking Server calendar results including players who played on other servers during selected days

Config

Jsinco updated 'Data_gathering.Join_addresses_.Filter_out_from_data' to support regex. Note that any existing setting values with . (dot character) will now match any character.
Display_options.Theme (default "default") now refers to theme name in the theme editor rather than "What theme.yml to copy values from"
Display_options.Night_mode (default false) added

Data

MSPT average and 95th percentile added to plan_tps table
Register date 0 (1970-01-01) is now regarded as invalid.
Ban status is now updated by an automatic task that cycles through all known players small amount at a time

Sponge

Sponge API 14 is now used, API 8 is no longer supported.

Fabric

Fabric was updated to 1.12.9 by DrexHD (Supports 1.12.11 as well)

Velocity

Velocity was updated to 3.5.0-SNAPSHOT

Database

Database move system rewrite

/plan db move, /plan db backup, /plan db restore use the new system
Added /plan db merge command (permission: plan.data.merge) which allows merging SQLite data to existing MySQL. This is useful for those merging multiple servers into a network when all servers had Plan installed on separate SQLite databases.

Other

id column added to old plan_tps tables that did not have it yet via Patch.
If MySQL runs into error code 1020 'Stale read' error, the transaction will retry instead of erroring
Fixed dyplicate key violation related to AllowListBounce
Possibly fixed ShutdownDataPreservationTransaction failing on existing join address insert
Fixed playtime queries to include playtime where session started before view window or ended after.

Locale

Dates, time amounts & country names are now translated based on the selected locale. (If specific ones aren't please report it as a bug)
HighCharts & Calendar are now translated based on the selected locale
TWJohnJohn20116 updated zh_TW locale
Shadowhackercz updated CS locale

Extensions

Fixed ArithmeticException related to LibertyBans when bans were infinite
Fixed an issue related to rendering boolean values
Updated Jobs extension to support newer version
Added Time.Periodical_tasks.Extension_player_data_refresh_every setting (default 15 MINUTES) which only affects plugins that decide to support it.
Made gathered PlaceholderAPI data update periodically

Placeholders

Fixed network_players_online always saying 0

Other

Vankka updated DependencyDownload to clean up libraries folder of old versions
Kopo updated the build system to speed up builds & IDE indexing performance

5.7 DEV build 3211

Changes since DEV build 3189

Change log

Website

Theme Editor

MSPT (Milliseconds per Tick)

Players online -tooltip

Query page improvements

Other

Config

Data

Sponge

Fabric

Velocity

Database

Database move system rewrite

Other

Locale

Extensions

Placeholders

Other

Related Projects

mapbox-navigation-android

ToastFish

barcodelib

haze

5.7 DEV build 3211

Changes since DEV build 3189

Change log

Website

Theme Editor

MSPT (Milliseconds per Tick)

Players online -tooltip

Query page improvements

Other

Config

Data

Sponge

Fabric

Velocity

Database

Database move system rewrite

Other

Locale

Extensions

Placeholders

Other

Related Projects

mapbox-navigation-android

ToastFish

barcodelib

haze