EHM 1 Database & Saved Game Editor v1: BUG REPORTS & FEATURE REQUESTS

[CJ]

Looking really good!!

[archibalduk]

As always, thanks much for your efforts Arch!

I wonder what Unknown 01 and Unknown 02 (in League Details) might refer to?

Your comment made me realise that the various Unknown fields are not very helpfully labelled in the Editor. As you'll see from the screenshots below, I have now added the data type in brackets. Some of the Unknown fields are clearly a particular data type (e.g. the Unknown 01 field is clearly an integer) and so they're displayed as that type. Others I'm not sure about (e.g. Unknown 02) and so I'm displaying the raw hex code. As you'll see from the Unknown 02 field, the data is 5 bytes long which means it could be (1) an integer and a char/bool, (2) two shorts and a char/bool, (4) one short and three chars/bools, or (5) five chars and/or bools (each of these five combinations equals 5 bytes).

Having looked at the Unknown 01 integer a little closer, I'm certain it's some sort of "Parent League ID" field. It seems only divisions/conferences use this field and it always refers to the League ID of the parent league. For example, the EIHL Conferences (see the first screenshot below) both refer to a Parent League ID of 65 and this is the League ID of the EIHL. Similarly, the CIS Conferences (see e.g. the second screenshot below) each refer to the ID number for the CIS (i.e. the ID for the CIS League is 131).

There are a few other interesting new fields which I haven't yet properly looked at or decoded. For instance, the Drafts data contains additional data which I think perhaps relates to leagues. There's also the Player Awards table which contains additional data for goalie awards (I wonder if it is the criteria for determining the winner?...). Once I have all of the editor screens done, I'll be able to spend more time trying to decode/figure out the remaining fields.

[archibalduk]

Another observation on this Parent Competition field: It seems it is used to create a hierarchy of conferences/divisions. For instance, the Parent of the ECHL West Division and the Mid-West Division is set as the ECHL National Conference. In turn, the Parent of the ECHL National Conference is the ECHL. It's the same with the NHL; the Divisions have the Conferences as their Parent and the Conferences have the NHL as the Parent.

Another thing: Remember the Club Status setting in EHM 2007? This is the one where you can set it as Invalid/Amateur/Semi-Pro/Pro. It seems a fifth setting has been added to the EHM 1 DB. From the looks of it, this is a Junior category because it seems to be set for teams in High School, Midget, etc leagues and teams with "U20", "U18", etc in their team names. I'm guessing the Import function automatically picks up teams with these sorts of keywords in their name or their league name and sets them to Junior accordingly. It doesn't affect colleague teams AFAIK and so I'm thinking this is almost certainly a new Junior category.

[archibalduk]

The first version of the Editor is now available here: http://www.ehmtheblueline.com/forums/vi ... 48&t=16014

There's a fairly detailed list of features and limitations if you visit the above link. If anybody encounters anything that doesn't work as expected or encounters a crash, please do post as much detail here so that I can try to fix it.

[Edgars]

Thank you!

[Tasku]

Awesome work, as usual, Arch.

[A9L3E]

Brilliant!

[archibalduk]

Hmm looks like the EU Membership setting might be wrong in the Editor...

[archibalduk]

I'm thinking the Unknown01 field in the Nations editing screen has something to do with determining IIHF rankings and/or which World Champs divisions teams play in. I've broken the Unknown01 field into its four constituent bytes. It almost looks like the right most byte perhaps relates to World Champs divisions (if you look at the patterns of the 43, 44 and 45 figures below). However, teams like Great Britain have the same figure (45) as the likes of Canada and the US which obviously wouldn't make sense. Does anybody else see a pattern with that column (or any others)?

[archibalduk]

Aha! Unknown01 is the team's current IIHF score.

[CJ]

I just opened the 98db in the editor. I noticed that all players were missing their roles (dunno why as you clearly had roles on the players in your preview)!?. They all had them on [none]. I have imported the player roles for the NHL.. only other explanation is that they somehow aren't in the game.

And also all players "natural fitness" is on 2.

Looking good this editor, easy on the eye!

[sao.phim]

Great work, very nice tool!!

Only issue I have noticed for now, is contract length. For example, Voracek I see in the game with extended contract - until 2024. This season salary 4250000, from next season 8250000. When I load same DB in the editor, it is showing his contract expiry 30.6.2016 and the actual salary 4250000. It seems to me, that editor is ignoring that extended contract and new salary. Same it is with Couturier (also in the game extended with higher salary from next season) for example.

[Manimal]

Great work, very nice tool!!

Only issue I have noticed for now, is contract length. For example, Voracek I see in the game with extended contract - until 2024. This season salary 4250000, from next season 8250000. When I load same DB in the editor, it is showing his contract expiry 30.6.2016 and the actual salary 4250000. It seems to me, that editor is ignoring that extended contract and new salary. Same it is with Couturier (also in the game extended with higher salary from next season) for example.

That is due to the extensions being in the extra_config file and not in the actual database

[archibalduk]

I just opened the 98db in the editor. I noticed that all players were missing their roles (dunno why as you clearly had roles on the players in your preview)!?. They all had them on [none]. I have imported the player roles for the NHL.. only other explanation is that they somehow aren't in the game.

Could you send a PM to me with a link to the EHM 2007 format DB please? I will take a look. I want to first look at an exported_attributes file using the Updater and then I'll try importing the DB into EHM 1. Player Roles seem to be working with the TBL Rosters v8.1 and so I think the cause with the 98 DB is either that the Roles have been lost (perhaps due to the Pre-Game Editor) or the EHM 1 DB you're using was perhaps created using an older version of EHM 1. If you go to the Database Header screen in the Editor, what does the Build Version say? It should be 1013 (although it is a guess on my part that this is the Build Version, but it is the pattern I have noticed with successive versions of the game).

And also all players "natural fitness" is on 2.

Thanks! I have fixed this in the Editor. The Morale and Natural Fitness fields were the wrong way around (i.e. the setting labelled "Morale" in the Editor is actually editing the Natural Fitness setting).

The structure of the Player Attributes table in EHM 1 is a bit different to EHM 2007. It's all the same data, but the fields are in a different order. It's taken quite a lot of trial and error to try and figure it out - so that's how the Morale and Natural Fitness fields ended up the wrong way round in the Editor.

[zbguy]

Great work! Can't wait to be able to add and delete stuff. Thanks for this

[sjsharkz]

Great work Archi, this is amazing.

Quick question, with the latest rosters (8.1). Theres no 'database' file that I can load onto the editor. Am I missing something here?

Also, does this editor enable us to fix the numerous poor attributes for prospects? For example, I could give a prospect a -9 potential, and perhaps a 100 current ability, go and do all his attributes based on what I know, and scouring reports. Then I load the game up and import the database, and the attributes for that player aren't what they say on the editor.

[Alessandro]

That's not DB-related

[nino33]

Quick question, with the latest rosters (8.1). Theres no 'database' file that I can load onto the editor. Am I missing something here?

Databases have been released in EHM07 format, and then imported into the new EHM (the new EHM version is what this new editor edits)

Also, does this editor enable us to fix the numerous poor attributes for prospects? For example, I could give a prospect a -9 potential, and perhaps a 100 current ability, go and do all his attributes based on what I know, and scouring reports. Then I load the game up and import the database, and the attributes for that player aren't what they say on the editor.

While a lot of the EHM07 general knowledge is the same for the new EHM, rating players/editing is not.
Players now have "Player Roles" which affect their Attributes, and development is different than it was inEHM07 (more Attributes develop now, and development is different (EHM07 players were "too often too good" and developed unrealistically fast).

There is no "guide" or "rulebook" for editing the new EHM; I've spent hundreds of hours testing and am still learning/figuring things out; in general, Attribute values have to be within a certain range and need to average out to a certain value (but we don't "know" the ranges/values and have to use experience/testing results to try to determine them).

And a 100 CA when drafted is a player who's going to stay in Junior another year or two and then is still likely to be a number of years away from playing in the NHL (to get an idea of appropriate values of prospects take look at the CA/Attributes given to current NHL prospects/2016 Draft prospects.......and I believe NHLers are pretty "correct" and for NHLers the game changes little to none of the ratings, so they'd be good examples)

[greaterone66]

OKay, question from a newbie. I'm in the editor right now, but I cannot open the database for anything except the historical rosters. When I choose the TBL rosters, there is no database option. Im sure it is something simple but I cant figure it out. Thanks!

EDIT: Figured it out

[CJ]

Could you send a PM to me with a link to the EHM 2007 format DB please? I will take a look. I want to first look at an exported_attributes file using the Updater and then I'll try importing the DB into EHM 1. Player Roles seem to be working with the TBL Rosters v8.1 and so I think the cause with the 98 DB is either that the Roles have been lost (perhaps due to the Pre-Game Editor) or the EHM 1 DB you're using was perhaps created using an older version of EHM 1. If you go to the Database Header screen in the Editor, what does the Build Version say? It should be 1013 (although it is a guess on my part that this is the Build Version, but it is the pattern I have noticed with successive versions of the game).

Now that you mentioned it. I used the old pre-game editor last week when I altered the team colours for the 98db. So I saved the db with the old pre-game editor to see how to colours looked in-game, this is probably the reason the roles got lost! I don't have the DB in 07 format..I think!? Nino probably has. If you still need it?

[greaterone66]

Okay, so I edited a player that I felt was really off as a trial, but when I re-import the database after editing it, he is back to normal and not set the way he was edited. What am I missing?

[archibalduk]

Now that you mentioned it. I used the old pre-game editor last week when I altered the team colours for the 98db. So I saved the db with the old pre-game editor to see how to colours looked in-game, this is probably the reason the roles got lost! I don't have the DB in 07 format..I think!? Nino probably has. If you still need it?

The Role should only be lost if you edit a player with a Role set. I.e. you view the player's profile in the 2007 Pre-Game Editor and click on Confirm. If you don't click on the Confirm button then the Role won't be lost for that player. So if you've only been editing team/comp colours then the Roles shouldn't have been lost...

___________________________________________________________________________________________________________

Just to repeat what Nino said as this question keeps cropping up and I suspect it will whilst everybody gets used to how the databases work in EHM 1:

Quick question, with the latest rosters (8.1). Theres no 'database' file that I can load onto the editor. Am I missing something here?

OKay, question from a newbie. I'm in the editor right now, but I cannot open the database for anything except the historical rosters. When I choose the TBL rosters, there is no database option. Im sure it is something simple but I cant figure it out. Thanks!

EDIT: Figured it out

Okay, so I edited a player that I felt was really off as a trial, but when I re-import the database after editing it, he is back to normal and not set the way he was edited. What am I missing?

As of now, we have two formats of database:

1. EHM 2007 format (consisting of the various .dat files people are used to seeing plus the usual .cfg files and the import_config.cfg file); and
2. EHM 1 format (consisting of a single .db file plus the usual .cfg files)

We currently release the TBL Rosters in EHM 2007 format only. There are two reasons for this:

1. We do not have a fully running editor and updater/importer yet; and
2. When new leagues/rules are added with EHM game patches, only databases reimported via the Import button in EHM 1 will benefit from them (because it is the Import function that makes the leagues playable in the database).

The EHM 1 Editor is for EHM 1 format databases only. In other words, the database.db file. The EHM 2007 Pre-Game Editor is used for editing the EHM 2007 format databases (i.e. the collection of .dat files).

The Import function in EHM 1 is used to convert the EHM 2007 format database (i.e. the .dat files) into EHM 1 format (i.e. the database.db file). The reason greaterone66 is losing his changes after editing the .db file is because he is re-importing the EHM 2007 database afterwards. This will overwrite his edited EHM 1 format database (i.e. the database.db file) with a re-imported version of the original EHM 2007 database file. You only need to import to convert from EHM 2007 format to EHM 1. Once you have done that, you don't have to do it again.

[CJ]

The Role should only be lost if you edit a player with a Role set. I.e. you view the player's profile in the 2007 Pre-Game Editor and click on Confirm. If you don't click on the Confirm button then the Role won't be lost for that player. So if you've only been editing team/comp colours then the Roles shouldn't have been lost...

Oh! I didn't touch any player.
Ask Nino for a 2007 version of the 98db so you can check it out.

EDIT:
I did some digging now. It seems that the roles never end up in the DB! I import the attributes_update to the updater and save it. Then export the attributes and when I open that up all players are at "Mixed" Do I have a old updater or shreadsheets or something when they are just goalie styles.

[archibalduk]

If you're using the version 2.0.6 Updater then it should work. I need to see your copy of the DB and your attribute_update file.

[CJ]

If you're using the version 2.0.6 Updater then it should work. I need to see your copy of the DB and your attribute_update file.

Why on earth did I have 2.0.5? I downloaded it last week.. Gonna download 2.0.6 now.

EDIT:
Thanks! Everything is solved now. It was just that somehow I used an old updater.