EHM The Blue Line

CHANGELIST: VERSION 0.3.2 (28-Apr-2019)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2017. Consequently you must now install the Microsoft Visual Studio 2017 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/15/release/vc_redist.x64.exe

New Features:

• Added a schedule dates generator to the Rules & Structure screen;
• Added a schedule generator to the Schedule Templates screen;
• Added a mass editor option to delete all player career history entries with zero games played;
• Added copy club option when adding new clubs via the Editor;
• Added draft history editing screen;
• Added draft history validation;
• Added player rights editing screen; and
• Added player rights validation.

Fixes and Improvements:

• Added colour correction to clubs, leagues and nations where no colour has been set;
• Added NHL draft eligibility columns when exporting Players & Non-Players spreadsheets;
• Added table descriptors to error messages displayed when unable to add or remove rows;
• Added the following filters to the Players & Non-Players screen: (1) Has played for club, (2) Player rights held by club, (3) Club drafted by, (4) NHL draft eligibility, (5) League contracted, (6) League playing in and (7) Has played in league;
• Corrected BKArchitect algorithm used with the automatic player and non-player reputation calculation;
• Disabled tabbing focus of the imperial height and weight conversions on the Player Details tab of the Players and Staff editing screen;
• Fixed crash with Players & Non-Players importer spreadsheet when attempting to retire a person who does not exist in the database;
• Fixed issue with pop-up windows causing the main Editor window to hide behind other windows;
• Fixed issue with the Rules & Structure importing where the existing schedule templates were not being displayed in the import dialog;
• Fixed issue with the Rules & Structure importing where the incorrect Rules & Structure ID was being set;
• Fixed issue with the "Set as Inactive" setting on the Clubs Editing screen not correctly clearing the divisional data;
• Improvements to the EHM 2004 to 2007 converter (but it does not yet result in a playable database);
• Minor adjustments to the layout of the Import Spreadsheet screen;
• Minor changes to user interface dimensions in order to increase available space for smaller screen resolutions;
• Minor performance improvement to text filtering (but wildcard/regular expressing searching is now disabled);
• Redesigned player rights editing sub-screen of the Players and Staff editing screen;
• Removed the "Dialog windows always stay on top of other windows" setting as this is no longer used;
• Simplified logging system; and
• Text entry for indexed items in the Editor are now case insensitive (e.g. the Day of Week field in Schedule Dates).

CHANGELIST: VERSION 0.3.3 (04-May-2019)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2017. Consequently you must now install the Microsoft Visual Studio 2017 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/15/release/vc_redist.x64.exe

Fixes and Improvements:

• Fixed issue with certain player/staff filter settings not working;
• Fixed issue with player/staff names not being displayed if the Sort Staff Data setting is disabled; and
• Fixed minor alignment inconsistencies with certain checkboxes on filter windows.

CHANGELIST: VERSION 0.3.4 (12-November-2019)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2017. Consequently you must now install the Microsoft Visual Studio 2017 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/15/release/vc_redist.x64.exe

New Features:

• Added automatic strength calculation via the Staff Mass Editor menu;
• Added schedule template matrix import and export from/to spreadsheets via the Schedule Generator wizard; and
• Added the option to set the favourite clubs of a player via the Tools menu or all players via the Staff Mass Editor menu.

Fixes and Improvements:

• Added automatic validation of national team Professional Status when loading EHM 2004, 2005 and 2007 databases;
• Added Club Status filter to the Players & Non-Players filter which allows for persons contracted to or playing for inactive/defunct clubs to be filtered;
• Added Professional Status column to the club_edit Converter spreadsheet;
• Brackets are now disregarded when matching text from an importer spreadsheet. E.g. "Belfast Giants (SNL)" will now match against "Belfast Giants SNL";
• Fixed bug with invalid Continental Licence values being set in certain circumstances. Simply load and save the database using the Editor to apply the fix;
• Minor tweak to global application font;
• "_none" is now accepted as a Continent setting in the Club Competitions importer spreadsheet;
• Switched from Qtxlsx version 0.3 to QXlsx version 1.3.45 by Jay Two for Excel spreadsheet processing;
• Updated various synonym and ignore_list data; and
• Upgraded to Qt 5.13.

CHANGELIST: VERSION 0.3.5 (08-December-2019)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2017. Consequently you must now install the Microsoft Visual Studio 2017 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/15/release/vc_redist.x64.exe

New Features:

• Added Playable League Dates spreadsheet export via File -> Export Spreadsheet.

Fixes and Improvements:

• Fixed bug on the Staff filter screen which would cause players or non-players to be filtered out when no non-player or player specific filters were enabled.

CHANGELIST: VERSION 0.3.7 (15-March-2020)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added Draft History mass deletion via the Competitions -> Mass Edit menu; and
• Added rolling saves when saving a database.

Fixes and Improvements:

• Added "Is Valid" columns to the Affiliations spreadsheet to indicate whether the Upper and Lower Clubs are valid (i.e. not inactive);
• Added Nation Contracted and Job for Nation filters to the Staff screen;
• Added Upper League and Lower League fields to the Affiliations screen;
• Blank rows of data in a spreadsheet are now ignored when importing data (note: a row is considered blank if all of the first five columns are blank);
• Fixed cramped/hidden checkbox settings on the Import Spreadsheet screen;
• Fixed issue with City importer spreadsheets not matching existing city records when "[None]" or "_none" is present in the State column;
• Increased the maximum log.txt file size from 500 lines to 1,500 lines;
• Invalid affiliations are now highlighted in yellow in the Affiliations screen (i.e. to flag inactive clubs);
• Redesigned the Structure sub-screen of the Rules & Structures screen;
• The Help tab is now visible before a database or saved game is opened; and
• Updated to Qt version 5.14 and Microsoft Visual Studio C++ 2019 - please ensure that you now install the Microsoft Visual Studio 2019 Redistributable from https://aka.ms/vs/16/release/VC_redist.x64.exe

NOTE: Version 0.3.6 was an internal release. The above changelist includes changes incorporated in version 0.3.6.

CHANGELIST: VERSION 0.4.1 (26-July-2020)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added support for database version 1033 (EHM game version 1.5);
• Added UTF-8 support when importing (but not exporting) CSV spreadsheets where a byte order mark (BOM) is present
• Retired number import and export via spreadsheets; and
• Retired number validation (entries with blank player names are now deleted and the table is now ordered by club ID and jersey number).

Fixes and Improvements:

• Active clubs with no Professional Status set are flagged as invalid when filtering in the Editor and are highlighted in yellow;
• Added a 'Delete' button to the Contract Details screen;
• Added a more detailed error message when the Editor is saving the database;
• Added a setting to automatically save databases to the latest EHM database version (via Settings -> General) (NOTE: DO NOT ENABLE THIS SETTING UNTIL EHM v1.5 IS RELEASED);
• Added additional Potential Ability values of -16 to -20 (NOTE: DO NOT USE THESE RANGES UNTIL EHM v1.5 IS RELEASED);
• Added an error message when trying to add Contract Details to a non-player;
• Added Birth City filtering to the Players and Staff screen;
• Added colour validation to prevent invalid/blank colours (note: the database must be re-saved in order to fix existing databases);
• Added extended logging when updating/refreshing the database;
• Added logging of rolling save numbers to assist with debugging;
• Added sorting for historical team name changes;
• Adding an Extra Rule now automatically shows the Extra Rule selection pop-up window;
• Adjusted the Players & Non-players spreadsheet export such that the Nations filter will act as a sub-filter when also filtering by Club Competition;
• Changing database version now changes both of the Current Version and Original Version settings;
• Clauses fields are now true/false settings;
• Corrected the club histories export spreadsheet which was exporting the Loss and Tie columns the wrong way round;
• Corrected the Database Settings title from Header to Settings;
• Corrected the Nation field on the Editor screen which would flag Afghanistan (id #0) as invalid;
• Enabled fractional DPI scaling;
• Extended the log text file limit to 300 lines from 150 lines;
• Fixed bug with the Player filter resetting when trying to filter by Club Drafted and Club Rights;
• Fixed minor issue with the Editor attempting to delete zero rows from the Contract Details table if there are no records which require deletion;
• Fixed the Club field on the Contract Details screen when the Club Contracted changes (NOTE: This was just a cosmetic issue);
• Improved handling of database versions to ensure compatibility with v1.4.1 and v1.5 format databases;
• Improvements to the UID validation function including the generation of a log spreadsheet showing all changes made;
• Merged the Database Header and Game Basic Data screens into a new Data -> Database Settings screen;
• Minor adjustments to the sizes of labels on the editing screens;
• Re-enabled logging to the Log screen;
• Re-enabled the database author field;
• Resized the ID, UID and Rows fields shown at the foot of each editing screen;
• Retired number import and export via spreadsheets;
• Retired number validation (entries with blank player names are now deleted and the table is now ordered by club ID and jersey number);
• The Detailed Division of every club is automatically set from the club's Division where no Detailed Division has been set;
• Tidied up the Club Name Changes screen;
• Tweaked Award Bonus table sorting to fix an invalid comparator error;
• Upgraded to Qt 5.15; and
• Widened tab sizes slightly (delete the stylesheet.css file for changes to take effect).

NOTE: Versions 0.3.8 - 0.4.0 were internal releases. The above changelist includes changes incorporated in versions 0.3.8 - 0.4.0.

CHANGELIST: VERSION 0.4.2 (27-July-2020)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

Fixes and Improvements:

• The "Always save databases using the latest EHM version" setting, which was accidentally defaulting to enabled, has been fixed to disabled pending release of EHM v1.5.

CHANGELIST: VERSION 0.4.6 (06-December-2020)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added club records importing;
• Added json patching;
• Player potential ability auto-calculation for players aged 24 and older via (i) the Player Details tab of the Staff screen (for a single player) and (ii) via the People -> Mass Edit menu (mass editing); and
• Re-written the internal database version tracker in order to fix an issue with the Editor changing database format mid-save.

Fixes and Improvements:

• Added an 'Enable Logging' setting in order to toggle logging for the purposes of testing (I highly recommend that this setting is always enabled);
• Added an 'NHL Draft Eligibility' indicator to the Statistics tab of the Staff screen;
• Added club records exporting;
• Added extra extended logging text;
• Added Position filtering for players;
• Added Player Role filtering for players;
• Adjusted the default settings on the Find and Replace Club Competitions function for mass editing player career histories;
• Club record entries are now added for any club without any assigned;
• Fixed a crash when attempting to access the Find and Replace Club Competitions function for mass editing player career histories;
• Fixed potential crash when re-ordering the Retired Numbers table where there are two identical entries;
• Fixed an issue with the NHL Draft eligibility player filter;
• Fixed an issue with the stylesheet which was resulting in it not being applied to the Editor;
• Inactive clubs with a Continental Licence set are now flagged as a club error in the Editor;
• Improved performance when using the text search on the Staff screen where all filters are disabled;
• Increased the log file size to 2,048 lines;
• Rearranged the home screen in order to give greater prominence to the editor log;
• The Schedule Dates Generator now accounts for leap years (note: dates falling on 29 February will continue to appear as 1 March in the Schedule Dates table due to the way in which the day of the year is stored in the database - but this shouldn't impact the in-game dates which should still account for a leap year in any event); and
• Tidied up the Importer screen slightly.

NOTE: Versions 0.4.3 - 0.4.5 were internal releases. The above changelist includes changes incorporated in versions 0.4.3 - 0.4.5.

CHANGELIST: VERSION 0.4.7 (20-December-2020)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added an option to export a staff research spreadsheet via the "Export Data" button in the bottom right hand corner of the Players and Staff screen and the Clubs screen.

Fixes and Improvements:

• Added warnings on the Affiliations screen where Affiliation Type is set to (i) [None] or (ii) Junior where the lower club is not a junior club;
• Fixed a bug with player/non-player filtering which required a filter to be applied twice before the data would be properly filtered;
• Fixed a bug with saved games not being loaded correctly;
• Fixed a crash when importing player career history into databases with a large volume (approx. 350,000+) of existing player career history data; and
• Fixed a mismatch between Senior and Junior Final Position columns when importing nation data.

CHANGELIST: VERSION 0.4.9 (07-February-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• First name and second name importing via the Import Spreadsheets function.

Fixes and Improvements:

• Added a sanity check when exporting .ehm files where invalid Transfer Rules ids have been set in the Editor;
• Added a filtered row count to the bottom of each editor screen;
• Added date of birth, status and duplicate count columns to the Player Rights editing screen;
• Added "[inactive]" to the end of club names in the editing screens and when importing non-research spreadsheets of players & staff and clubs;
• Added jersey number to the sub-heading on the Players & Staff editing screen;
• Auto-set Potential Ability function no longer modifies players with a zero Current Ability rating;
• Fixed a bug when exporting club research sheets where the date of birth of alternate captains would be listed twice;
• Fixed a bug when importing spreadsheets where the UID value would not be correctly incremented;
• Fixed a bug with senior and junior national teams being mixed up when importing spreadsheets;
• Jersey numbers are now initialised with zero (instead of -1) as the default value;
• Pass Tendency calculation can now be accessed via the Tools menu when viewing a player and via People -> Players & Staff -> Mass Edit; and
• The UID validator now re-numbers all club UIDs and assigns CHL-specific UIDs to clubs with a continental licence.

NOTE: Version 0.4.8 was an internal release. The above changelist includes changes incorporated in version 0.4.8.

CHANGELIST: VERSION 0.5.1 (06-March-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added spreadsheet exporting for use with the EHM Jersey Generator; and
• Added support for database version 1034.

Fixes and Improvements:

• Adjusted the UID validator to allocated CHL-specific UIDs to Finnish, German and Swedish professional clubs where there are no clubs with a continental licence.

NOTE: Version 0.5.0 was an internal release. The above changelist includes changes incorporated in version 0.5.0.

CHANGELIST: VERSION 0.5.2 (03-April-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added a mass editing option on the Clubs menu to make all clubs in active where they are assigned to an inactive league;
• Added a mass editing option on the People menu to delete all player career history entries where no club or competition has been assigned;
• Added a random name option on the Players & Staff and Officials screens;
• Added copy and paste options to the Player Details and Non-Player screens and via the Tools menu on those screens;
• Added options to clear all player or non-player attributes on the Players & Staff screen; and
• Added Rules and Structures validation displayed on the Status sub-screen (see here for a full list of validation rules).

Fixes and Improvements:

• Added basic filtering options to the Rules and Structures screen;
• Added extra details to the Rules and Structures text report (date range of schedule and actual next upper and lower stages);
• Added option to ignore "C" or "A" captaincy text suffixed to club names when importing player career history spreadsheets;
• Adjusted text sorting to case insensitive;
• Fixed a bug when filtering by Player Role where Goalie: Mixed might be shown when [None] is initially selected as the chosen filter value; and
• Minor optimisations to text matching functions and a general code tidy-up for basic data types.

CHANGELIST: VERSION 1.0.0 (23-April-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added a structure chart sub-screen to the Rules and Structure screen (this is a work in progress);
• Added ability to refresh synonym data via File -> Refresh Synonyms;
• Added Contract Details editing via the People -> Players and Staff screen (version 1.5 database format);
• Added Extra Rule settings #163-181 from game version 1.5 (version 1.5 database format);
• Added Game Extra Data to the Data -> Database Settings screen (version 1.5 database format);
• Added Historical Club Names editing screen (via the Clubs tab) for adding historical club names for player career histories (data can also be imported/exported via the Import buttons at the foot of the screen) (version 1.5 database format);
• Added League Sort Rule #12 (regulation wins only) (version 1.5 database format); and
• The 'Always save databases using the latest EHM version' setting is now automatically enabled when upgrading from any version of the Editor prior to v1.0.0 (this can be overridden in the Settings screen.

Fixes and Improvements:

• Added a setting on the Import Spreadsheet screen which allows synonym settings to be saved across Editor sessions;
• Added additional validation rules to the Rules & Structures screen - see HERE for further details;
• Added support for curly quotation marks when removing "A" and "C" suffixes from club names when importing player career history;
• Comments and blank lines can now be added to synonym files. Comment lines are added by placing two forward slashes at the front of the comment line (e.g. "// This is a comment");
• Fixed issue with Financial Power being corrupted when importing a Nations spreadsheet;
• Fixed issue with League Standard not being updated when importing a Nations spreadsheet;
• Increased the width of the Reputation fields on the Nations screen;
• Minor adjustment to the Alternative Schedule Dates data structure in order to fix a potential crash when saving the database;
• Minor improvements to the dates specified in the Rules and Structures text report which now take into account the final potential date for a cup stage schedule date; and
• Minor optimisations to various functions/classes.

CHANGELIST: VERSION 1.0.1 (24-April-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

Fixes and Improvements:

• Fixed issue with the -16 to -20 Potential Abilities which can now be entered into the Editor and spreadsheets (version 1.5 database format).

CHANGELIST: VERSION 1.0.2 (02-May-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

Fixes and Improvements:

• Fixed a crash when creating or importing a new Playable League Structure caused by the 'maximum league games' validation rule where no stages are initially present;
• Goalies are now set to 15 Pass Tendency when applying the Auto-Set Pass Tendency mass editor;
• Historical club names are now reverse sorted by ID; and
• Rolling saves are now saved as "database-[xxx].bak" instead of "database[xxx].bak" in order to avoid conflict where the base database.db filename contains digits.

CHANGELIST: VERSION 1.1.1 (03-July-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added automatic repair of protected Ruling Body records (i.e. International, Asia, Europe and North America);
• Added duplicate player career history reporting via the Export Spreadsheet screen;
• Added synonym support for cities using the following format: "Database Name", "Alternate Name 1", "Alternative Name 2", etc;
• Added synonym field to the Cities screen; and
• Added the ability to delete Finance Info, Ruling Bodies, Transfer Rules and Staff Awards.

Fixes and Improvements:

• Added contract expiry date filtering to the Staff screen;
• Added support for DB versions 1016 and 1018;
• Changed the 'common' data version to 1010 in order to push the corrected flag values detailed in this changelist;
• Corrected "Candidate League for Continental Licence" extra rules from boolean to integer (Extra Rules 177-179);
• Corrected the description of the "Clubs divided North South" Rules & Structures flag to "Clubs divided geographically";
• Fixed bug where text files in the 'common' sub-folder were being erroneously flagged as incomplete and re-written;
• Fixed record navigation when deleting a record (previously the Editor would navigate two records down);
• Re-enabled counting of Professional Seasons when re-calculating player runtime data; and
• Synonym data for Clubs and Club Competitions now use the following format "Database Name", "Alternate Name 1", "Alternative Name 2", etc. Name synoynms continue to use the original synonym format which uses any column as the "Database Name".

CHANGELIST: VERSION 1.1.3 (11-July-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

Fixes and Improvements:

• Fixed synonyms not always linking with a team/competition/etc in the database; and
• World Reputation is now set to zero where a player has a zero Current Ability when auto-setting Reputation using the xECK29x algorithm.

CHANGELIST: VERSION 1.1.4 (10-September-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added a button next to the Annual Salary field on the Players & Staff screen which will automatically populate the Contract Details sub-screen with the Future Nominal Weekly Wages data; and
• Added a Minor League Annual Salary field to the Players & Staff screen and the Contract Details sub-screen which will automatically calculate and set the player's Two Way Percentage field.

Fixes and Improvements:

• Added ages sub-heading text to the Officials screen;
• Added nation filtering to the Finance Info, Ruling Bodies, Schedule Templates and Transfer Rules screens;
• Changed the "use nation short names" setting to "use nation short and long names" on the Import Spreadsheet screen;
• Fixed a bug where the player's Club Contracted on the Contract Details sub-screen was being incorrectly set when navigating between players;
• Fixed the Potential Ability tool setting Potential Abilities above 200 and added an auto-fix when saving existing databases;
• Nation and Practice Facilities of clubs are now automatically set based on City and Arena when editing the City or Arena via the Editor;
• Players with multiple positions set to 20 are now flagged as invalid in the Editor (via the "Has Errors" filter setting, flagged with a yellow background in the navigation list on the Players & Staff screen and with "[!!]" in the name of the Player Details tab on the Players & Staff screen);
• Primary Nationality of staff or officials are now automatically set based on Birth City when editing the Birth City via the Editor;
• Re-coded filters on the First Names, Second Names, Nations and States & Provinces screens; and
• The long name of the club contracted is now shown in the sub-heading text on the Players & Staff screen.

CHANGELIST: VERSION 1.1.5 (21-December-2021)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

New Features:

• Added club name filtering to the Historical Club Names screen;
• Added the ability to auto-set non-player Potential Ability via the Staff screen (note that clicking on either of the 'Set non-player potential' or 'Set player potential' buttons will set both player and non-player Potential Abilities at the same time - i.e. you do not need to click on both buttons). The formulae used can be found here: https://www.ehmtheblueline.com/forums/v ... 65#p244365;
• Added the ability to synchronise/update Player Roles based on the player's primary position (skaters only) via (i) the Staff -> Player Details screen, (ii) the Tools menu on the Staff screen and (iii) the Staff Attributes mass editor; and
• Extra Rules relating to UIDs now display the name of the linked record assigned to that UID.

Fixes and Improvements:

• Added annual salary (min/max) filtering to the Staff screen;
• Added date of birth filtering on the Player Rights screen;
• Added error condition (Cities): Both latitude and longitude set to zero;
• Added error condition (Player Rights): Contracted or playing for another club in the same league to which the rights relate;
• Added error condition (Staff): Inactive club contracted or club playing for;
• Added error condition (Staff): Player does not have precisely one primary position;
• Added error condition (Staff): Player Role mismatches (e.g. a centre having a winger role);
• Added error filter to the City editing screen;
• Adjusted non-player Reputation calculation for the Premier Pivot Rosters algorithm so that non-player World Reputation = (CA - 20);
• Adjusted player Potential Ability calculation for goalies so that it only applies to goalies aged 27 years or older;
• Extra Rules now display thousands separators where appropriate;
• Fixed "Non agreement nation for defected players relating to player rights [UID]" extra rule appearing as true/false instead of a UID number;
• Merged the Pass Tendency, Potential Ability, Reputation and Strength mass editors into a new Staff Attributes mass editor via Mass Edit menu on the Staff screen;
• The text search box now ignores text in brackets;
• Upgraded QXlsx from version 1.3.45 to version 1.4.3 by Jay Two for Excel spreadsheet processing; and
• Value range spin boxes on filter screens now display thousands separators and are slightly wider.

CHANGELIST: VERSION 1.1.6 (03-January-2022)

IMPORTANT! The Editor is now a 64-bit application and is now built using Microsoft Visual Studio C++ 2019. Consequently you must now install the Microsoft Visual Studio 2019 Redistributable before you attempt to run the Editor otherwise it will crash. You must install the 64-bit version (also known as vcredist_x64.exe). The Redistributable can be downloaded here: https://aka.ms/vs/16/release/VC_redist.x64.exe

Fixes and Improvements:

• Added a confirmation dialog when deleting items from any of the following editor screens: Finance Info, Rules & Structures, Ruling Bodies, Schedule Templates and Transfer Rules;
• Added extra "Invalid Job" value specific to national club jobs; and
• Added three extra Arena Rules values (x00C0, x7FC0 and x7FC8) with temporary descriptions pending confirmation as to what these values mean.

CHANGELIST: VERSION 1.1.7 (20-March-2022)

IMPORTANT! The Editor now uses the Microsoft Visual Studio 2022 Redistributable 64-bit version. Prior versions of the Editor used the 2019 Redistributable.

New Features:

• Added 'Players with Player Rights' spreadsheet via the Export Spreadsheets screen which exports a staff research sheet.

Fixes and Improvements:

• Added duplicate filtering to the Draft History screen (click on the Re-validate History button at the bottom of the screen to update the list of duplicates after making edits);
• Added option to make player/non-player a national team free agent via the right-click menu on the Clubs -> Player Rosters and Staff Rosters sub-screens;
• Added support for spaces in between digits when importing spreadsheets (e.g. "1 234" will be imported as "1234");
• Added the ability to clear all staff award history via the People -> Mass Edit menu;
• Added the ability to select/highlight rows in a table and delete that selection (e.g. player career history, player rights, draft history screens);
• Players with no position set will now have a position auto-set according to their Player Role when using (i) the 'Validate Player Positions' option on the Import Spreadsheet screen, (ii) the 'Synchronise Role and Position' button on the Players and Staff -> Player Details sub-screen and (iii)the 'Synchronise Role and Position' button on the 'Auto-Set Attributes' mass editor;
• Refresh Synonyms now allows for a temporary custom folder for alternative synonym files (with the default folder as a fall-back); and
• Restored old "Unrecognised value" options for Jobs when importing spreadsheets just for backwards compatibility with spreadsheets exported using older versions of the Editor.

CHANGELIST: VERSION 1.1.8 (07-August-2022)

IMPORTANT! The Editor now uses the Microsoft Visual Studio 2022 Redistributable 64-bit version. Prior versions of the Editor used the 2019 Redistributable.

Fixes and Improvements:

• Added the ability to mass delete identical player career history where one entry relates to an inactive club and one entry relates to an active club (the inactive club entry will be deleted) via the People -> Mass Edit menu; and
• Added the option to find and replace club names in player career history via the People -> Mass Edit menu.

CHANGELIST: VERSION 1.2.0 (11-April-2023)

IMPORTANT! The Editor now uses the Microsoft Visual Studio 2022 Redistributable 64-bit version.

General

• Added a button to reset the table sorting order on the Clubs -> Player Roster and Staff Roster sub-screens;
• Added a setting to automatically make players/non-players free agents if they are assigned to an inactive team. If the player/non-player is playing for an inactive team but is contracted to an active team, he will be auto-recalled to his contracted team. The setting is enabled by default and can be toggled via Settings -> Database;
• Added the option to display a confirmation pop-up dialog when clicking on the Delete button on any editing screen in order to prevent accidental deletion of an item. This must be enabled via the Settings -> General screen;
• Strengthened the pop-up window displayed when opening the Editor for the first time in order to clarify the risk of editing a saved game;
• Upgraded QXlsx from version 1.4.3 to 1.4.5 and optimised the manner in which the library is incorporated into the Editor;
• OpenSSL details now shown in Help -> About in preparation for fixing the online update notification; and
• Replacement of various deprecated Qt5 code/functions with Qt6-compatible equivalents.

Bug fixes

• Fixed saved games being force saved to DB v1.4.1; and
• Minor League Annual Salary on the Players & Staff screen now resets to zero when navigating to a new item and correctly updates the Two-Way Percentage setting on the Contract Details sub-screen.

Data Validation when loading or saving a database

• Added a setting to automatically make players/non-players free agents if they are assigned to an inactive team. If the player/non-player is playing for an inactive team but is contracted to an active team, he will be auto-recalled to his contracted team. The setting is enabled by default and can be toggled via Settings -> Database;
• Each team's Last Division is now auto-set where it has been set to [none] or where it is the same as its current division. In such instances the Last Division is set to the team's last division based on its team history or, where the team doesn't have any history, it is set the same as its current division; and
• Invalid affiliations are now auto-deleted. An affiliation where the Upper Club and Lower Club are the same is now treated as an invalid affiliation.

Error conditions

• An affiliation where the Upper Club and Lower Club are the same is now treated as an Affiliation error condition;
• A non-player (including a player/coach) loaned to another team is a Staff error condition;
• A player/non-player with a primary or secondary nationality set to an inactive nation is now a Staff error condition;
• An overage player is now a Staff error condition (see change note regarding overage player mass editing for details on what constitutes an overage player).

Importing & exporting data

• UTF-8 BOM support for when exporting csv spreadsheets. This must be enabled via the Settings -> General screen; and
• Substantial re-coding of the Export Spreadsheets function to include:
  -- options to export all entries, valid entries only or invalid entries only (e.g. where a player/non-player is assigned to an invalid team);
  -- options to export just the selected spreadsheet type or all spreadsheet types (i.e. one click will export every spreadsheet listed in the left-hand menu on the Export Spreadsheet screen);
  -- a small number of additional spreadsheets now allow for club competition and/or nation filtering; and
  -- a general tidy-up of the Export Spreadsheet screen.

Mass Editing

• Added an overage player deletion mass editor on the People tab. A preview spreadsheet of overage players is displayed before proceeding. This allows for:
  -- making any overage player a free agent if they are contracted to a team that plays in a league with an age restriction;
  -- making any overage player a free agent if they are playing for a team that plays in a league with an age restriction (the Editor will recall the player to their contracted club if he is not considered an overage player in his contracted club); and
  -- deleting any player rights where the player is too old to play in the league relating to those rights.

CHANGELIST: VERSION 1.2.2 (11-March-2024)

IMPORTANT! The Editor now uses the Microsoft Visual Studio 2022 Redistributable 64-bit version.

General

• Added support for dark mode;
• Added a confirmation dialog when clearing player or non-player attributes via the Staff editing screen;
• Added a Repair all button to the Staff Awards screen which fixes any Club mismatches where a player is contracted to/playing for another Club within that same league (i.e. the Club contracted to/playing for will be updated as the Player Rights holder);
• Added correct focussing to selection dialog windows in order to ensure they are the uppermost and active window when opened; and
• Added a refresh button to the selection dialog windows which may resolve a rare issue where the date shown in a dialog may go out of sync.

Bug fixes

• Fixed Staff Birth Year sometimes being set to 1 instead of 1900 in certain circumstances.

Data Validation when loading or saving a database

• Added automatic resetting of Clubs with an inactive Rival (i.e. the inactive Club is removed as a Rival); and
• Added automatic resetting of Staff with an inactive Liked or Disliked Club (i.e. the inactive Club is removed as a Liked or Disliked Club).

Error conditions

• An inactive Division/League, Detailed Division, Reserve Division or Nation is now a Club error condition;
• An inactive Liked or Disliked Club is now a Staff error condition; and
• An inactive Rival is now a Club error condition.

Importing & exporting data

• Added Game Dates Report via File -> Export Spreadsheet which provides a spreadsheet setting out various in-game playable league dates (e.g. stage dates and draw dates);
• Added Staff Award importing and exporting;
• Fixed missing header data when exporting an individual player or non-player as a spreadsheet; and
• Removed an extraneous condition from Club Competition History export spreadsheet.

Mass Editing

• Added a Staff Auto-Rater via People -> Mass Edit -> Players & Staff -> Auto-rate players & non-players which automatically calculates and sets player and non-player Current Ability ratings;
• Added mass deletion of duplicate Staff Career History entries via People -> Mass Edit -> Player Career History -> Delete duplicate entries;
• Added mass resetting of Staff Award attributes via People -> Mass Edit -> Staff Awards -> Reset award attributes; and
• Redesigned the Auto-Set Attributes mass editor for Players and Non-Players to allow for multiple Clubs or Club Competitions to be included or excluded.

STAFF AUTO-RATER
The Auto-Rater will automatically generate Current Ability ratings for all players or non-players in a chosen league. Click on People -> Mass Edit -> Players & Staff -> Auto-rate players & non-players in order to apply the Auto-Rater to the chosen scope of players or non-players. Details of the various settings are listed below.

The logic of the Auto-Rater is as follows:

1. Generate a list of Current Ability ratings for each group of player positions (or non-player job types) according to the selected Player Grouping (not applicable to non-players), CA Values and CA Distribution settings;
2. Rank the players/non-players within each Grouping according to three Factors (Experience, Performance Rank and Random Rank);
3. Create a combined Overall Ranking by applying a weighting to each of the three Factor rankings of each player; and
4. Within each Group, assign the best CA to the highest Overall Ranked player/non-player, assign the second best CA to the second highest Overall Ranked player/non-player, etc.

So in other words, the Auto-Rater ranks players according to three Factors and assigns a spread of CAs within each Grouping.

The process is as follows:

1. Set the settings within the Auto-Rater screen as desired;
2. Click on Calculate Ratings in order to calculate the Current Ability ratings. The Auto-Rater will generate a spreadsheet previewing the calculated values. If the calculated values are unsatisfactory, you can re-adjust the settings and then click on Calculate Ratings again; and
3. Click on Apply Ratings to apply the ratings to the database. Alternatively, close the window in order to abort.

The available settings are as follows:

1. Scope

• Staff type: Whether to apply the Auto-Rater to players or non-players.
• Roster scope & Club Competition: Applies to players/non-players whose Club Contracted or Club Playing For matches the target Club Competition.
• Look-back period: How many years of player career histories are factored in when calculating the Factor Rankings. See further below regarding Player Factors.

2. Current ability values

• Player Grouping: Determines each group for ranking players and allocating CAs. If the G, D, W, C Grouping is selected then LDs and RDs will be ranked as a single group and LWs and RWs will be ranked as a single group. Conversely, the G, LD, RD, LW, C, RW Grouping will ensure defencemen and wingers are ranked by individual position - this allows for a more even spread of CAs by position whereas the G, D, W, C Grouping allows for a more uneven spread between LD/RDs and LW/RWs.
• Top/Good/Average/Poor: Determines the target CA ratings for each part of the CA range. The Top CA and the Poor CA indicate the very highest and lowest CAs to be allocated. Average CA is the target average whereas Good CA determines the mid-point between Average CA and Top CA.

3. Current ability distribution

• Distribution type: Bell Curve aims to create a distributions resembling a bell curve. This can cause very concentrated spreads on smaller numbers of players/non-players and is generally only useful for larger leagues (e.g. the NHL) and typically more for the G, D, W, C Grouping type. The Tiered setting is generally the better setting to use and creates more helpful spreads than Bell Curve (essentially Tiered groups the CA spreads into four tiers).
• Top/Good/Average/Poor: These values determine the spread of CAs. A higher value indicates a higher number of CAs within that range. It is advisable to use figures that together add up to 1.00; e.g. the default settings are Top = 0.05, Good = 0.20, Average = 0.40 and Poor = 0.25 which means that 25% of players/non-players will given a CA which is within the Poor tier of a Tiered Distribution or the Poor quartile of the Bell Curve Distribution.

4. Factors

• Determines the weighting given to each of the three factors for the players/non-players. See further below for details of how the Factors are calculated.

5. Bonus rates

• Applies a bonus where a player/non-player has any of the following: (i) National team games played and (ii) Stanley Cups won. The more national GP or Stanley Cups won, the greater the bonus. Any Bonus will improve a player/non-player's Overall Ranking;
• Maximum bonus: Sets the maximum Bonus which a player/non-player will be allocated.

The Factors are calculated as follows:

1. Players

• Experience: Based on player career history for the chosen Look-back Period. Games Played and the League Reputation for each season within the Look-back Period are taken into account.
• Performance: Based on player career history for the chosen Look-back Period. Club Reputation and the League Reputation for each season within the Look-back Period are taken into account. For goalies, Games Played and Win Percentage for each relevant season are factored in. For skaters, Games Played and Points Per Game for each relevant season are factored in.
• Randomness: Completely random

2. Non-Players

• Experience: Years since date of first NHL contract & (roughly) existing CA per year of age (e.g. a 20 year old with an existing 100 non-player CA is regarded as better than a 40 year old with the same existing CA). A slight weighting is applied to certain job types (e.g. Head Coaches, GMs, etc are weighted slightly higher than Coaches).
• Performance: Existing non-player CA (if any) & Club Reputation. As with Experience, there's a slight weighting for certain job types.
• Randomness: Completely random

CHANGELIST: VERSION 1.2.3 (18-August-2024)

IMPORTANT! The Editor now uses the Microsoft Visual Studio 2022 Redistributable 64-bit version.

General

• Disabled the ability to create new nations;
• Minor width adjustment of ID/UID/Filtered Rows/Total Rows fields at the foot of each editing screen; and
• Re-designed the item selection dialog window in order to provide further details for each item. Items can still be selected either by (i) single-clicking on the desired row and then click on 'Select' or (ii) double-clicking on the desired row. See the screenshot below.

Bug fixes

• Fixed Add Item -> Copy Current Item which now correctly refreshes the UI upon creation; and
• IIHF Senior and Junior Ranking values are now imported via the Nations importer spreadsheet.

Mass Editing

• Added mass deletion of officials entries via People -> Mass Edit ->Officials -> Delete all; and
• Added mass deletion of retired numbers entries via Clubs-> Mass Edit -> Retired Numbers -> Delete all.