
EHM 1 Database & Saved Game Editor v1: BUG REPORTS & FEATURE REQUESTS
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
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
-
- Prospect
- Posts: 53
- Joined: Mon Apr 13, 2015 9:52 pm
- Favourite Team: Vancouver Canucks
- Location: Calgary, AB
Re: EHM 1 Database Editor
looks fantastic. i am patiently waiting to get my hands on this 

-
- Junior League
- Posts: 5
- Joined: Thu Apr 09, 2015 6:09 pm
- Favourite Team: Djurgarden
Re: EHM 1 Database Editor
Nice work! Looking forward to be able to try this one out!
-
- Prospect
- Posts: 58
- Joined: Thu Nov 26, 2009 9:57 am
Re: EHM 1 Database Editor
That looks beautiful...
-
- Junior League
- Posts: 6
- Joined: Thu Feb 16, 2012 12:33 am
Re: EHM 1 Database Editor
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. 

- sjsharkz
- Minor League
- Posts: 294
- Joined: Sat Jan 28, 2006 12:31 pm
Re: EHM 1 Database Editor
As I'm an editing nerd, I can't wait to get an editor for the new EHM! Keep up the good work mate!
- 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
If you're an editing nerd then you should come join us on the TBL Rosterssjsharkz 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!
- 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
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.

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.
-
- Junior League
- Posts: 18
- Joined: Sun Aug 19, 2012 2:29 pm
Re: EHM 1 Database Editor
I wondering if this ediotr make it able to edit leagues?
- 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
Yes, leagues will be editable in the first release.
-
- Second Line
- Posts: 656
- Joined: Sat Jan 07, 2012 11:21 pm
Re: EHM 1 Database Editor
Sounds and looks brilliant...can't wait! 

-
- Prospect
- Posts: 58
- Joined: Thu Nov 26, 2009 9:57 am
Re: EHM 1 Database Editor
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?archibalduk wrote:Yes, leagues will be editable in the first release.
- 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
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.
-
- Prospect
- Posts: 58
- Joined: Thu Nov 26, 2009 9:57 am
Re: EHM 1 Database 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.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.
- 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
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.
- 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
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.
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.
That's exactly how I feel!!Djungelurban wrote:the prospect of being able to fully edit leagues is so very enticing.
- NorthernLights
- Junior League
- Posts: 28
- Joined: Tue Jan 05, 2016 7:32 pm
- Favourite Team: Boston Bruins
- Location: Sweden
Re: EHM 1 Database Editor
Will this allow me to add new players? Would love to add myself and my childhood teammates to our local team 

- 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
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?
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?
- NorthernLights
- Junior League
- Posts: 28
- Joined: Tue Jan 05, 2016 7:32 pm
- Favourite Team: Boston Bruins
- Location: Sweden
Re: EHM 1 Database Editor
I think I read about it but haven't tried it since I have no experience with the 2007 version of the game.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?
- 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
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
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
-
- Junior League
- Posts: 18
- Joined: Sun Aug 19, 2012 2:29 pm
Re: EHM 1 Database Editor
With your editor xan we maybe edit the league struktures? so like an exemple the SHL has 20 teams like in my drream 

- 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
Not to start with. However, if I can figure out the relevant section of the DB then hopefully we will eventually.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
-
- Learning to skate
- Posts: 1
- Joined: Tue Jun 09, 2015 3:23 pm
- Favourite Team: Luleå Hockey & Winnipeg Jets
Re: EHM 1 Database Editor
Will I be able to change places with a team from the Swedish first division with a team from the Swedish Allsvenskan for example?
- 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
That can already be done with the pre-game editor and import_config fileSjö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?
- 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
A couple of screenshots from the beta Editor which I hope to release in the not too distant future:






- 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
As always, thanks much for your efforts Arch!
I wonder what Unknown 01 and Unknown 02 (in League Details) might refer to?

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