Page 8 of 82
Re: EHM 1 Database Editor (2016)
Posted: Fri Mar 25, 2016 10:02 am
by archibalduk
Isn't the club's city based upon the location of their arena?
Re: EHM 1 Database Editor (2016)
Posted: Fri Mar 25, 2016 7:24 pm
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.

Re: EHM 1 Database Editor (2016)
Posted: Fri Mar 25, 2016 9:55 pm
by nuka
is it possible to create players using another editor (maybe one for ehm 07) and then import them into ehm ea?
Re: EHM 1 Database Editor (2016)
Posted: Fri Mar 25, 2016 10:09 pm
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.
Re: EHM 1 Database Editor (2016)
Posted: Fri Mar 25, 2016 10:17 pm
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.
Re: EHM 1 Database Editor (2016)
Posted: Sat Mar 26, 2016 2:23 pm
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.
Re: EHM 1 Database Editor (2016)
Posted: Sat Mar 26, 2016 9:45 pm
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.
Re: EHM 1 Database Editor (2016)
Posted: Sun Mar 27, 2016 9:46 am
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...
Re: EHM 1 Database Editor (2016)
Posted: Sun Mar 27, 2016 2:42 pm
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*
Re: EHM 1 Database Editor (2016)
Posted: Mon Mar 28, 2016 6:00 pm
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.

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!
Re: EHM 1 Database Editor (2016)
Posted: Tue Mar 29, 2016 9:37 am
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?
Re: EHM 1 Database Editor (2016)
Posted: Tue Mar 29, 2016 9:54 am
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.
Re: EHM 1 Database Editor (2016)
Posted: Tue Mar 29, 2016 9:17 pm
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?

Re: EHM 1 Database Editor (2016)
Posted: Tue Mar 29, 2016 11:19 pm
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.
Re: EHM 1 Database Editor (2016)
Posted: Wed Mar 30, 2016 10:07 pm
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.

Re: EHM 1 Database Editor (2016)
Posted: Wed Mar 30, 2016 10:20 pm
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!

Re: EHM 1 Database Editor (2016)
Posted: Thu Mar 31, 2016 2:24 am
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!

So true!
Re: EHM 1 Database Editor (2016)
Posted: Thu Mar 31, 2016 3:15 pm
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.
Re: EHM 1 Database Editor (2016)
Posted: Thu Mar 31, 2016 10:28 pm
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
Re: EHM 1 Database Editor (2016)
Posted: Mon Apr 04, 2016 7:47 pm
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?
Re: EHM 1 Database Editor (2016)
Posted: Tue Apr 05, 2016 5:38 pm
by febus
The Redistributable can be downloaded here:
https://www.microsoft.com/en-us/downloa ... x?id=40784
Don't Work.....

Re: EHM 1 Database Editor (2016)
Posted: Tue Apr 05, 2016 9:09 pm
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
Re: EHM 1 Database Editor (2016)
Posted: Thu Apr 07, 2016 5:48 am
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.
Re: EHM 1 Database Editor (2016)
Posted: Sat Apr 09, 2016 12:52 pm
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
Re: EHM 1 Database Editor (2016)
Posted: Sat Apr 09, 2016 8:16 pm
by archibalduk
Thanks for sharing.

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.