Page 3 of 82
Re: EHM 1 Database Editor
Posted: Wed Dec 09, 2015 1:15 am
by Melun64
looks fantastic. i am patiently waiting to get my hands on this

Re: EHM 1 Database Editor
Posted: Thu Dec 10, 2015 4:44 pm
by Sparvass
Nice work! Looking forward to be able to try this one out!
Re: EHM 1 Database Editor
Posted: Fri Dec 11, 2015 12:45 pm
by Djungelurban
That looks beautiful...
Re: EHM 1 Database Editor
Posted: Fri Dec 11, 2015 3:26 pm
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.

Re: EHM 1 Database Editor
Posted: Mon Jan 04, 2016 6:17 am
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!
Re: EHM 1 Database Editor
Posted: Mon Jan 04, 2016 8:09 am
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
Re: EHM 1 Database Editor
Posted: Mon Jan 04, 2016 10:15 pm
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.
Re: EHM 1 Database Editor
Posted: Wed Jan 06, 2016 8:12 pm
by rickard1122
I wondering if this ediotr make it able to edit leagues?
Re: EHM 1 Database Editor
Posted: Wed Jan 06, 2016 8:26 pm
by archibalduk
Yes, leagues will be editable in the first release.
Re: EHM 1 Database Editor
Posted: Sat Jan 09, 2016 9:13 pm
by BKarchitect
Sounds and looks brilliant...can't wait!

Re: EHM 1 Database Editor
Posted: Wed Jan 13, 2016 1:09 pm
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?
Re: EHM 1 Database Editor
Posted: Wed Jan 13, 2016 8:34 pm
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.
Re: EHM 1 Database Editor
Posted: Wed Jan 13, 2016 9:51 pm
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.
Re: EHM 1 Database Editor
Posted: Wed Jan 13, 2016 9:56 pm
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.
Re: EHM 1 Database Editor
Posted: Wed Jan 13, 2016 10:08 pm
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!!
Re: EHM 1 Database Editor
Posted: Thu Jan 14, 2016 8:25 pm
by NorthernLights
Will this allow me to add new players? Would love to add myself and my childhood teammates to our local team

Re: EHM 1 Database Editor
Posted: Thu Jan 14, 2016 8:48 pm
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?
Re: EHM 1 Database Editor
Posted: Thu Jan 14, 2016 8:51 pm
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.
Re: EHM 1 Database Editor
Posted: Thu Jan 14, 2016 10:01 pm
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
Re: EHM 1 Database Editor
Posted: Tue Jan 19, 2016 11:15 pm
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

Re: EHM 1 Database Editor
Posted: Wed Jan 20, 2016 8:39 pm
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.
Re: EHM 1 Database Editor
Posted: Thu Jan 21, 2016 10:30 am
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?
Re: EHM 1 Database Editor
Posted: Thu Jan 21, 2016 1:32 pm
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
Re: EHM 1 Database Editor
Posted: Mon Jan 25, 2016 10:25 pm
by archibalduk
Re: EHM 1 Database Editor
Posted: Tue Jan 26, 2016 12:25 am
by nino33
As always, thanks much for your efforts Arch!
I wonder what Unknown 01 and Unknown 02 (in League Details) might refer to?
