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

Discuss all aspects of editing the data and databases in EHM here. Have a question about the EHM Editor, EHM Assistant, editing the .cfg files, hex editing the .dat or .db files? Want to tweak the EHM exe file to change league rules/structure, start date etc? This is the place!
Forum rules
This is the forum to discuss all aspects of editing the EHM data and tweaking the game.

Have a bug or feature request for the EHM Editor? Post them in the EHM Editor thread. Please start a new thread or post in another thread if you have a question about how to use the EHM Editor.

Given the large number of questions on similar topics, we ask that you start a new thread for a new question unless you can locate a similar question in an existing thread. This will hopefully ensure that similar questions do not get buried in large threads.

Useful links: EHM 1 Assistant (Download) | EHM 1 Editor (Download) | EHM 1 Editor Tutorials | Editing Rules & Structures Guide | Converting EHM 2004 / 2005 DBs to EHM 1 | Converting an EHM 2007 DB to EHM 1 | Extra_config.cfg | Import_config.cfg | Player Roles
Post Reply
Melun64
Prospect
Posts: 53
Joined: Mon Apr 13, 2015 9:52 pm
Favourite Team: Vancouver Canucks
Location: Calgary, AB

Re: EHM 1 Database Editor

Post by Melun64 »

looks fantastic. i am patiently waiting to get my hands on this :D
Sparvass
Junior League
Posts: 5
Joined: Thu Apr 09, 2015 6:09 pm
Favourite Team: Djurgarden

Re: EHM 1 Database Editor

Post by Sparvass »

Nice work! Looking forward to be able to try this one out!
Djungelurban
Prospect
Posts: 58
Joined: Thu Nov 26, 2009 9:57 am

Re: EHM 1 Database Editor

Post by Djungelurban »

That looks beautiful...
MovesLikeJagr
Junior League
Posts: 6
Joined: Thu Feb 16, 2012 12:33 am

Re: EHM 1 Database Editor

Post by MovesLikeJagr »

Great work! Can't wait for it to be released one day - I really want to head one of the national teams in the present against modern-day Soviet and Czechoslovak national teams. :-D
User avatar
sjsharkz
Minor League
Posts: 294
Joined: Sat Jan 28, 2006 12:31 pm

Re: EHM 1 Database Editor

Post by sjsharkz »

As I'm an editing nerd, I can't wait to get an editor for the new EHM! Keep up the good work mate!
User avatar
Manimal
TBL Admin Team
Posts: 6344
Joined: Thu Apr 24, 2008 4:01 am
Custom Rank: EHM Rosters Man
Favourite Team: Djurgårdens IF
Location: Karlstad, Sweden

Re: EHM 1 Database Editor

Post by Manimal »

sjsharkz wrote:As I'm an editing nerd, I can't wait to get an editor for the new EHM! Keep up the good work mate!
If you're an editing nerd then you should come join us on the TBL Rosters
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database Editor

Post by archibalduk »

Thanks for the words of encouragement. :-)

I am slowly continuing to make progress with it. I'd actually made a lot of progress, but decided to re-write a big chunk of the programme so as to remove the need to use an SQL database. Now it's all good old binary which means it's much faster and will allow me to eventually bring over all of the EHM 2007 Updater functions to it. I'm still re-writing the chunk I mentioned, but I'm getting through it as quickly as I can. I really want to get at least a basic editor with a few tables editable sooner rather than later. I haven't figured out the full database structure yet and so it won't be possible to add new records to begin with.
rickard1122
Junior League
Posts: 18
Joined: Sun Aug 19, 2012 2:29 pm

Re: EHM 1 Database Editor

Post by rickard1122 »

I wondering if this ediotr make it able to edit leagues?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database Editor

Post by archibalduk »

Yes, leagues will be editable in the first release.
BKarchitect
Second Line
Posts: 656
Joined: Sat Jan 07, 2012 11:21 pm

Re: EHM 1 Database Editor

Post by BKarchitect »

Sounds and looks brilliant...can't wait! =P~
Djungelurban
Prospect
Posts: 58
Joined: Thu Nov 26, 2009 9:57 am

Re: EHM 1 Database Editor

Post by Djungelurban »

archibalduk wrote:Yes, leagues will be editable in the first release.
How editable are we talking here? Like basic things like changing squad limits and league reputation, or more complex things like actually changing league structures and number of teams or even enabling new playable leagues?
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database Editor

Post by archibalduk »

I haven't figured out the league structures/rules/etc tables and so it'll be the basic details you see in the EHM 2007 Pre-Game Editor.
Djungelurban
Prospect
Posts: 58
Joined: Thu Nov 26, 2009 9:57 am

Re: EHM 1 Database Editor

Post by Djungelurban »

archibalduk wrote:I haven't figured out the league structures/rules/etc tables and so it'll be the basic details you see in the EHM 2007 Pre-Game Editor.
Well, I guess you gotta start somewhere, so it's good enough for a first step for sure. I just got curious since the prospect of being able to fully edit leagues is so very enticing.
User avatar
A9L3E
All-Star
Posts: 1230
Joined: Tue Sep 09, 2008 6:22 am
Custom Rank: Shiny gilded nameplate
Favourite Team: Helsingin Jokerit
Location: Vantaa, Finland

Re: EHM 1 Database Editor

Post by A9L3E »

I would also guess that making advanced league editing available would be a monumental task. Otherwise Riz would have surely released tools for that already, since that could allow him to focus fully on non-database matters.
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database Editor

Post by archibalduk »

Editing the data isn't really that hard. The difficulty is trying to figure out the structure of the relevant sections of the database file. If I had the structure then it'd be easy. The challenge is that each record within that particular table is variable in size so it's a big task trying to figure out the base structure and the various bool/bitwise settings that cause expanded records (and in turn then figuring out the structure of the expanded segments). And as the remaining new tables are located after this variable-sized table, I have no way of being able to reliably calculate the size of this table so that I can skip it and read in the subsequent tables. It's a bit frustrating, but I've got plenty to keep me occupied right now what with getting the standard data editable (which is progressing really well).

I believe Riz's work on the league editing aspect is to create new rules in the game and then implement them in the database structure. It's not just DB editing work - it's adding the actual functionality to both the game and the DB.
Djungelurban wrote:the prospect of being able to fully edit leagues is so very enticing.
That's exactly how I feel!!
User avatar
NorthernLights
Junior League
Posts: 28
Joined: Tue Jan 05, 2016 7:32 pm
Favourite Team: Boston Bruins
Location: Sweden

Re: EHM 1 Database Editor

Post by NorthernLights »

Will this allow me to add new players? Would love to add myself and my childhood teammates to our local team :grin:
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database Editor

Post by archibalduk »

Not initially. The first step is to make everything editable. Then I need to figure out the new universal unique ID system that has been added to the DB. I don't expect this to be a hard thing to figure out, but I don't see the point at looking at it before I can edit everything (really all I need to do is figure out whether the number in the Database Header refers to the highest current UID or the next UID to be used). Also, I need to figure out the new Team Records table which, until I have decoded it, prevents me from adding players/staff owing to the way the tables are arranged in the DB. Once that's done, I'll start work on the ability to add/delete entries.

Btw, I take it you're aware you could edit the EHM 2007 format of the TBL Rosters using the Pre-Game Editor and then import into EHM 1?
User avatar
NorthernLights
Junior League
Posts: 28
Joined: Tue Jan 05, 2016 7:32 pm
Favourite Team: Boston Bruins
Location: Sweden

Re: EHM 1 Database Editor

Post by NorthernLights »

archibalduk wrote:Not initially. The first step is to make everything editable. Then I need to figure out the new universal unique ID system that has been added to the DB. I don't expect this to be a hard thing to figure out, but I don't see the point at looking at it before I can edit everything (really all I need to do is figure out whether the number in the Database Header refers to the highest current UID or the next UID to be used). Also, I need to figure out the new Team Records table which, until I have decoded it, prevents me from adding players/staff owing to the way the tables are arranged in the DB. Once that's done, I'll start work on the ability to add/delete entries.

Btw, I take it you're aware you could edit the EHM 2007 format of the TBL Rosters using the Pre-Game Editor and then import into EHM 1?
I think I read about it but haven't tried it since I have no experience with the 2007 version of the game.
User avatar
nino33
Mr. Goalie
Posts: 6088
Joined: Sat Aug 07, 2010 3:37 am
Custom Rank: Retro Rosters Specialist
Favourite Team: 1970s hockey

Re: EHM 1 Database Editor

Post by nino33 »

You don't need any experience with the 2007 game to edit.

The editors for the 2007 game are what is used to create the databases/rosters for the new EHM - first you do the editing work (using 2007 tools), and then you import you edits/changes into the new EHM game! By doing so you can add you and your friends to a database that then import that database into the new EHM
rickard1122
Junior League
Posts: 18
Joined: Sun Aug 19, 2012 2:29 pm

Re: EHM 1 Database Editor

Post by rickard1122 »

With your editor xan we maybe edit the league struktures? so like an exemple the SHL has 20 teams like in my drream :)
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database Editor

Post by archibalduk »

rickard1122 wrote:With your editor xan we maybe edit the league struktures? so like an exemple the SHL has 20 teams like in my drream :)
Not to start with. However, if I can figure out the relevant section of the DB then hopefully we will eventually.
Sjöbao
Learning to skate
Posts: 1
Joined: Tue Jun 09, 2015 3:23 pm
Favourite Team: Luleå Hockey & Winnipeg Jets

Re: EHM 1 Database Editor

Post by Sjöbao »

Will I be able to change places with a team from the Swedish first division with a team from the Swedish Allsvenskan for example?
User avatar
Manimal
TBL Admin Team
Posts: 6344
Joined: Thu Apr 24, 2008 4:01 am
Custom Rank: EHM Rosters Man
Favourite Team: Djurgårdens IF
Location: Karlstad, Sweden

Re: EHM 1 Database Editor

Post by Manimal »

Sjöbao wrote:Will I be able to change places with a team from the Swedish first division with a team from the Swedish Allsvenskan for example?
That can already be done with the pre-game editor and import_config file
User avatar
archibalduk
TBL Admin Team
Posts: 20372
Joined: Tue Jul 06, 2004 8:44 pm
Custom Rank: Seaside + Fruit Juice Mode
Favourite Team: Guildford (EPL) / Invicta (NIHL)
Location: United Kingdom
Contact:

Re: EHM 1 Database Editor

Post by archibalduk »

A couple of screenshots from the beta Editor which I hope to release in the not too distant future:

Image

Image

Image
User avatar
nino33
Mr. Goalie
Posts: 6088
Joined: Sat Aug 07, 2010 3:37 am
Custom Rank: Retro Rosters Specialist
Favourite Team: 1970s hockey

Re: EHM 1 Database Editor

Post by nino33 »

As always, thanks much for your efforts Arch! :notworthy:

I wonder what Unknown 01 and Unknown 02 (in League Details) might refer to? :-k
Post Reply