Page 1 of 2
Database Editing Question - NHL Records
Posted: Tue May 05, 2015 8:40 pm
by TehJesster
Hey TBL! The new EHM:EA has got me back in full gear EHM mode, I love it. The thing is I'm always one for 'restarting' the NHL and playing it out as if it just formed today, its fun to see the history unfold.
My question is, how do I remove gretzky as the 'Most Points in a Season' record, etc. I've erased all trophy history, NHL champions are gone (I did team swapping to blank teams to remove their encoded history). The only thing I can't get rid of is NHL records, for the few they haev in their for the likes of Gretzky and Howe.
I want this to be empty:
Like this:
Re: Database Editing Question - NHL Records
Posted: Tue May 05, 2015 9:46 pm
by archibalduk
Try looking in the records_config.cfg file which is located in the same folder as your DB files. You can open it in Notepad. I haven't checked, but I think this should have the records you're after.
Re: Database Editing Question - NHL Records
Posted: Tue May 05, 2015 9:49 pm
by TehJesster
archibalduk wrote:Try looking in the records_config.cfg file which is located in the same folder as your DB files. You can open it in Notepad. I haven't checked, but I think this should have the records you're after.
Thank you Archi, I will try to pry in and see if I can remove them that way. Would be perfect! I'll let you know my findings.
Re: Database Editing Question - NHL Records
Posted: Tue May 05, 2015 10:21 pm
by TehJesster
archibalduk wrote:Try looking in the records_config.cfg file which is located in the same folder as your DB files. You can open it in Notepad. I haven't checked, but I think this should have the records you're after.
This worked! Easy as pie! Thank you tons! :]
Re: Database Editing Question - NHL Records
Posted: Tue May 05, 2015 10:27 pm
by archibalduk
Glad to hear it! My pleasure.
Re: Database Editing Question - NHL Records
Posted: Wed May 06, 2015 4:30 am
by TehJesster
One more question to Archi or anyone who is knowledgable enough. Now with EHM:EA is it possible to delete the records for individual teams as well? It would be a lot easier to get rid of club records and keep the 2014 rule set format rather than having to swap NHL teams with inactives in the Pre-Game Editor.
Re: Database Editing Question - NHL Records
Posted: Fri May 08, 2015 7:44 pm
by DeVulus
Hey TehJesster, can you tell me how to edit trophy history for the NHL and possibly other leagues. I've got the new TBL rosters, but they're missing the winners from the 13-14 season and it's really bugging me.
Thanks in advance.
Re: Database Editing Question - NHL Records
Posted: Sun May 10, 2015 1:53 am
by TehJesster
DeVulus wrote:Hey TehJesster, can you tell me how to edit trophy history for the NHL and possibly other leagues. I've got the new TBL rosters, but they're missing the winners from the 13-14 season and it's really bugging me.
Thanks in advance.
I'm not quite sure how to edit them, I only know how to delete them entirely. :[ Its possible someone else may know that answer though, i'll leave it open.
Re: Database Editing Question - NHL Records
Posted: Sun May 10, 2015 10:18 am
by jilech
DeVulus wrote:Hey TehJesster, can you tell me how to edit trophy history for the NHL and possibly other leagues. I've got the new TBL rosters, but they're missing the winners from the 13-14 season and it's really bugging me.
Thanks in advance.
You'll need to use the EHM 2007 Updater to do that.
http://www.ehmtheblueline.com/forums/vi ... 10&t=11154
Step 1: File -> Open the database
Step 2: Spreadsheet -> Create Spreadsheet Templates (I recommend Use CSV Spreadsheet, as it's a lot easier to just edit with notepad).
Step 3: Add the history you want in the comp_history_update.csv in notepad
Step 4: In the Home tab, import your new club comp history file. Save the database.
Now re-import the DB into EHM:EA and start new game.
This is how my comp_history_update.csv looks like to add the 2013-14 NHL history:
Code: Select all
Competition Name;Year;Champions;Runners Up;Third Placed;Regular Season Champions;Hosts
National Hockey League;2014;Los Angeles Kings;New York Rangers;;Boston Bruins;Los Angeles Kings
Re: Database Editing Question - NHL Records
Posted: Sun May 10, 2015 9:22 pm
by DeVulus
Much appreciated. Thanks for the help.
Re: Database Editing Question - NHL Records
Posted: Thu May 14, 2015 12:16 am
by jilech
TehJesster wrote:One more question to Archi or anyone who is knowledgable enough. Now with EHM:EA is it possible to delete the records for individual teams as well? It would be a lot easier to get rid of club records and keep the 2014 rule set format rather than having to swap NHL teams with inactives in the Pre-Game Editor.
Delete the club_records.data file. Create a new textfile and rename it to club_records.dat.
Use the EHM 2007 Updater
http://www.ehmtheblueline.com/forums/vi ... 88&t=13532 to load the database and save it again. This will update the index.dat file with the "new empty" records file. Voila you got empty club records.
EDIT: Remember to re-import the database in-game, to make the game read the new empty .dat files.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 3:59 am
by nuggett
What other .dat files can you reset to bring league history back to nothing (ie as if starting from scratch). Can you remove Player History, Team Competition history, etc.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 8:47 am
by jilech
nuggett wrote:What other .dat files can you reset to bring league history back to nothing (ie as if starting from scratch). Can you remove Player History, Team Competition history, etc.
club_comp_history.dat - removes competition histories
club_histories.dat - removes the league histories from the club
staff_history.dat - removes player histories
I just tested those three, though it gave an error when starting new game saying staff histories had been deleted, the game was created succesfully.
So I guess you could do it with all the "history/histories/records".dat files.
Remember to backup the DB
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 12:32 pm
by nuggett
I just tried this, but never removed anything. Must be doing something wrong - I followed the same steps as above.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 12:54 pm
by jilech
nuggett wrote:I just tried this, but never removed anything. Must be doing something wrong - I followed the same steps as above.
Did you re-import the database?
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 12:59 pm
by nuggett
With the 2007 Updater - yes.
Or through the game itself - no.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 1:00 pm
by jilech
nuggett wrote:With the 2007 Updater - yes.
Or through the game itself - no.
In the game itself. You need to do that, before starting new game.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 1:02 pm
by nuggett
Re-imported through game (missed that step)... works perfect.
Thanks.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 1:03 pm
by nuggett
Just need to figure out what files to adjust.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 1:05 pm
by jilech
nuggett wrote:Re-imported through game (missed that step)... works perfect.
Thanks.
You're welcome
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 10:18 pm
by nuggett
I am getting through this - how do you remove the Awards history.
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 10:35 pm
by archibalduk
Load your DB using the EHM Updater (v3.0.0a) -> Click on "Data" -> Mass Edit -> Database. You'll see a number of tick boxes where you can choose what data you want to erase. It is not as thoroughly tested as I'd like yet, but it should be okay:
http://1drv.ms/1bFt3Ds
Re: Database Editing Question - NHL Records
Posted: Mon May 18, 2015 11:06 pm
by nuggett
Thanks. But how do I remove the Awards in the NHL history section. Which block do I click or do I have it do it manually.
Re: Database Editing Question - NHL Records
Posted: Tue May 19, 2015 6:29 am
by jilech
nuggett wrote:I am getting through this - how do you remove the Awards history.
staff_comp_history.dat is the awards history.
Re: Database Editing Question - NHL Records
Posted: Tue May 19, 2015 7:34 am
by archibalduk
nuggett wrote:Thanks. But how do I remove the Awards in the NHL history section. Which block do I click or do I have it do it manually.
Staff Competition History (I used the same terminology as the DB file names).