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
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 (2016)

Post by archibalduk »

Isn't the club's city based upon the location of their arena?
Sparvass
Junior League
Posts: 5
Joined: Thu Apr 09, 2015 6:09 pm
Favourite Team: Djurgarden

Re: EHM 1 Database Editor (2016)

Post by Sparvass »

Im wondering if its possible to add so one can change the transfer funds? Im experiencing a problem with the board having the requests for them grayed out all the time.
:)
nuka
Learning to skate
Posts: 3
Joined: Fri Mar 11, 2016 1:27 am
Favourite Team: ottawa

Re: EHM 1 Database Editor (2016)

Post by nuka »

is it possible to create players using another editor (maybe one for ehm 07) and then import them into ehm ea?
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 (2016)

Post by A9L3E »

nuka wrote:is it possible to create players using another editor (maybe one for ehm 07) and then import them into ehm ea?
Yes. EHM Updater or Pre-Game Editor.
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 (2016)

Post by archibalduk »

Sparvass wrote:Im wondering if its possible to add so one can change the transfer funds? Im experiencing a problem with the board having the requests for them grayed out all the time.
:)
Yes, on the Clubs editing screen.
Sparvass
Junior League
Posts: 5
Joined: Thu Apr 09, 2015 6:09 pm
Favourite Team: Djurgarden

Re: EHM 1 Database Editor (2016)

Post by Sparvass »

archibalduk wrote:
Sparvass wrote:Im wondering if its possible to add so one can change the transfer funds? Im experiencing a problem with the board having the requests for them grayed out all the time.
:)
Yes, on the Clubs editing screen.

Hmm, either im blind or just confused.. I can only see "Player budget" and "Cash" - which doesnt effect the transfer funds.
Exarz
Junior League
Posts: 27
Joined: Fri Mar 30, 2012 4:23 pm
Favourite Team: VIK Västerås HK & Jokerit
Location: Sweden

Re: EHM 1 Database Editor (2016)

Post by Exarz »

archibalduk wrote:Isn't the club's city based upon the location of their arena?
Nope, it's separate.

I changed Severstal Cherepovets to AIK Hockey and made them play in the current "Ericsson Globe Arena" located in Stockholm. It still says that the city is Cherepovets.
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 (2016)

Post by archibalduk »

That's very interesting. I think there is still some data I haven't yet decoded in the club table. I wonder if it relates to a club's city. I'll take a look...
marksbros6
TBL Rosters Researcher
Posts: 601
Joined: Sun Nov 24, 2013 7:34 pm

Re: EHM 1 Database Editor (2016)

Post by marksbros6 »

Regarding editing a teams transfer funds I seem to recall when I tried it the value entered in the editor didn't affect the amount in-game?

I think the game automatically sets the transfer-funds based on the club reputation, as changing that affected how much the board made available.

*That was with the old editor though, not tried it in the new one yet*
User avatar
ideawithoutamind
TBL Rosters Researcher
Posts: 123
Joined: Sat Apr 11, 2015 5:54 am
Custom Rank: Global United Hockey
Favourite Team: Boston Bruins

Re: EHM 1 Database Editor (2016)

Post by ideawithoutamind »

archibalduk wrote:The latest version of the Eastside Hockey Manager 1 Database Editor can be downloaded here: http://www.ehmtheblueline.com/editor



ORIGINAL POST:

It's going to take a long, long time, but I've started work on an EHM:EA Editor. I'm still working my way through the various data tables (6 done so far) as well as experimenting with a properly written data editor. Unlike the EHM 2007 Updater, the new editor loads the data into an SQL database which I can then edit. This isn't something I've tried before, but I've found it makes writing the various editing functions significantly easier and quicker.

I'm going to be working on the DB research and EHM 2007 Updater in amongst working on the EHM:EA Editor; so it's going to be a slow process. But hopefully one day I'll have a fully functioning editor (and eventually with similar import/export functions as the EHM 2007 Updater). I'll try to update this thread every so often with my progress.

Image
Posted this in another forum toward the Save Game editor; but I am a developer and avid EHM fan.

I'd love to be a part of this project in any capacity; as a database dev, I am fairly strong with SQL; so please let me know if there would be anything I could help contribute with. Thanks!
Exarz
Junior League
Posts: 27
Joined: Fri Mar 30, 2012 4:23 pm
Favourite Team: VIK Västerås HK & Jokerit
Location: Sweden

Re: EHM 1 Database Editor (2016)

Post by Exarz »

archibalduk wrote:That's very interesting. I think there is still some data I haven't yet decoded in the club table. I wonder if it relates to a club's city. I'll take a look...
Thanks!

By the way, is there some way to change the foreign restriction rule for the leagues?
User avatar
Named
TBL Rosters Researcher
Posts: 698
Joined: Tue Apr 07, 2015 8:34 pm
Custom Rank: League structures guru
Favourite Team: Chicago Blackhawks
Location: PL

Re: EHM 1 Database Editor (2016)

Post by Named »

Foreign restriction rule could be changed without editor. You can check with "MAX_FOREIGN_ON_ROSTER" in one *.cfg files in database folder.
manixi
Learning to skate
Posts: 1
Joined: Tue Mar 29, 2016 9:13 pm
Favourite Team: Jokerit

Re: EHM 1 Database Editor (2016)

Post by manixi »

First of all, thank you for the great work with the editor!
archibalduk wrote:It's not possible to correctly move players/non-players to other teams in saved games. There's an additional contracts table within the saved game which I haven't decoded and so, although the player will appear on the roster/line-up, his contract data won't be updated.
Secondly, is this something that will be available at some point? :)
User avatar
visualdarkness
Stanley Cup Winner
Posts: 1434
Joined: Tue Jul 15, 2008 3:14 am
Location: Surahammar, Sweden

Re: EHM 1 Database Editor (2016)

Post by visualdarkness »

Is there a way to quickly filter all the players/staff/rights for one team? Maybe I am blind but I cant see it.
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 (2016)

Post by archibalduk »

ideawithoutamind wrote:Posted this in another forum toward the Save Game editor; but I am a developer and avid EHM fan.

I'd love to be a part of this project in any capacity; as a database dev, I am fairly strong with SQL; so please let me know if there would be anything I could help contribute with. Thanks!
Thanks for the kind offer. :-) I'm not sure there's much I need help with at the moment. I'm using C++ and Qt (mostly using Qt's Model/View approach). I briefly looked at SQL but it's not very useful for work on the EHM database (it adds a lot of work to maintaining the code in the Editor and it seems to lead to casting/truncating double types). The database side of things is all done (save that I'm filling in some blanks with the DB structures). It's really a case of finishing my work on coding the final editing screens and working on various underlying routines/functions.

If you ever consider writing your own tools for EHM then do let me know and I'd be happy to help get you up and running.
manixi wrote:First of all, thank you for the great work with the editor!
archibalduk wrote:It's not possible to correctly move players/non-players to other teams in saved games. There's an additional contracts table within the saved game which I haven't decoded and so, although the player will appear on the roster/line-up, his contract data won't be updated.
Secondly, is this something that will be available at some point? :)
I'm afraid there's no immediate plans on this at the moment. At least not until DB editing is all up and running along with the Updater functions we need for the purposes of our TBL Rosters work.
visualdarkness wrote:Is there a way to quickly filter all the players/staff/rights for one team? Maybe I am blind but I cant see it.
There's no filters at the moment. I'll be adding some once all editing screens are done. :thup:
User avatar
CJ
TBL Rosters Researcher
Posts: 3411
Joined: Tue Nov 08, 2011 6:34 pm
Custom Rank: Formerly jhcjobpb
Favourite Team: Florida Panthers
Location: Finland

Re: EHM 1 Database Editor (2016)

Post by CJ »

I have to say, this editor looks really professional! ;) Also...first time I opened it I knew how to navigate in it, which is fantastic! :thup:
User avatar
visualdarkness
Stanley Cup Winner
Posts: 1434
Joined: Tue Jul 15, 2008 3:14 am
Location: Surahammar, Sweden

Re: EHM 1 Database Editor (2016)

Post by visualdarkness »

jhcjobpb wrote:I have to say, this editor looks really professional! ;) Also...first time I opened it I knew how to navigate in it, which is fantastic! :thup:
So true!
Sparvass
Junior League
Posts: 5
Joined: Thu Apr 09, 2015 6:09 pm
Favourite Team: Djurgarden

Re: EHM 1 Database Editor (2016)

Post by Sparvass »

I've since the discovery of the transfer funds not existing experienced that the cash doesnt work for me either.. Anyone else have any experience with the same problem? The only thing that seems to be affected by change is the player budget.
filipsvk01
Learning to skate
Posts: 4
Joined: Mon Oct 05, 2015 9:33 pm
Favourite Team: Chicago Blackhawks

Re: EHM 1 Database Editor (2016)

Post by filipsvk01 »

Is there a way to edit League Rules? Max 5 foreign players in team/match in Slovakian Tipsport Liga is such a <snip>. There are no rules like that and it really grinds my gears
Exarz
Junior League
Posts: 27
Joined: Fri Mar 30, 2012 4:23 pm
Favourite Team: VIK Västerås HK & Jokerit
Location: Sweden

Re: EHM 1 Database Editor (2016)

Post by Exarz »

Named wrote:Foreign restriction rule could be changed without editor. You can check with "MAX_FOREIGN_ON_ROSTER" in one *.cfg files in database folder.
I didn't find it in any of the *.cfg files. Do I have to add it myself?
User avatar
febus
Junior League
Posts: 5
Joined: Sun Dec 14, 2008 5:15 pm
Location: Italia

Re: EHM 1 Database Editor (2016)

Post by febus »

The Redistributable can be downloaded here: https://www.microsoft.com/en-us/downloa ... x?id=40784

Don't Work..... :-)
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 (2016)

Post by archibalduk »

If you click on the link in the Download thread, it works. Perhaps you're copying and pasting the link rather than clicking on it. Here it is: https://www.microsoft.com/en-us/downloa ... x?id=40784
User avatar
febus
Junior League
Posts: 5
Joined: Sun Dec 14, 2008 5:15 pm
Location: Italia

Re: EHM 1 Database Editor (2016)

Post by febus »

Thanks for the reply ..... no ..... but it was clicked on the link to the following page, that I wore to the file that was not working. After 4 days finally I made me download the file.
Thank you.
sean222
Learning to skate
Posts: 2
Joined: Sun Feb 23, 2014 1:27 pm

Re: EHM 1 Database Editor (2016)

Post by sean222 »

First of all ,thank you for that awesome editor ,it's really user friendly. In ehm 07 ,editing attributes in saved game was really long procedure ,because of that crazy nubmers ,which doesn't make sense(for example ,number 47 in editor for flair was 14 in game,but number 47 in editor for checking was 5 in game ) but in this new EHM the number are same so I made little table if somebody wants to edit save game.
http://imgur.com/AiadfYg
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 (2016)

Post by archibalduk »

Thanks for sharing. :thup: That's really useful. I hadn't appreciated that the 1-100 scale converted to the 1-20 scale like that (I had always thought it was a simple 1:5 scale). Hopefully it'll help others trying to edit attributes.
Post Reply