Help Request: Removing NHL History/Player Stats/Awards

[TehJesster]

Hey TBL! Its been awhile since I posted but I've been looking forever to figure out how to do this idea again, I will explain. I want to create a database using as current of rosters as I can, but the catch is I want it to be like a 'fresh NHL' as in NO HISTORY. No past NHL cup winners, no award history, no player stats history, and I would prefer to use current players (updated attributes to the current season). I could settle with completely fictional players as long as there are no past Cup Winners/History. The date can stay the coded 2006/2007 since essentially this will be a completely clean slate NHL as is.

I have done this before, way back when there was only a pregame/saved game editor and I had to change all the NHL teams to copies and keep the old names to avoid errors and what not. It was a long and semi-complicated process that took me quite a while and sadly I lost that database. If I did have it the game would be pretty out of date though since I believe the DB I based it off of was the Lidas 09/10 rosters. Is there an easier way to do this now with all the new tools? I'm looking at them but I don't exactly understand how to clear the databases the way I want without errors.

[TehJesster]

Wow a lot has changed on the site, well done! The new tools look very promising but I'm a bit overwhelmed on where to start here. I think I want to use the latest TBL Rosters v6.3, but should I use the default roster or the Start Editor version of the roster? Which would be easiest to clear of history? I guess I'm just looking for a little direction of which tools I need to use to achieve my goal of erasing all of the league/team history.

[nino33]

I think I want to use the latest TBL Rosters v6.3, but should I use the default roster or the Start Editor version of the roster? Which would be easiest to clear of history?

It depends on what start date you want (2013 or 2006)...in terms of "which would be easiest to clear of history?" I don't think it'd make any difference

I guess I'm just looking for a little direction of which tools I need to use to achieve my goal of erasing all of the league/team history.

I think I'll allow Archi to respond here as I think he'd know best what can/can't be done, and how best to do it (I'm sure Arch will respond when he has time)

[TehJesster]

Thank you nino. I believe I have discovered where to begin, and thats with the EHM Updater but in order to clear all the history I want I need to have the Index Updater that I posted in the technical forums which isnt working, currently saying files corrupted. Unless there is another means in which I can clear past champs, team and player history I may just have to wait until the file is reuploaded.

[archibalduk]

You're exactly right - the EHM Updater is what you need. But you don't need the Index Updater. The EHM Updater does everything for you (including automatically updating the index).

Here's a basic overview of what you need to do:

1. Load the EHM Updater (make sure you use Run as Admin)

2. File -> Open Database

3. Click on the Database tab. You'll see a section on the right hand side entitled "Erase Data".

4. Under the "Erase Database" section, click on the drop-down menu and select what you want to delete. Then click on the "Erase Data" button.

5. If necessary, keep repeating step #4 above according to what you want to delete. You can just keep selecting different options from the drop-down menu and click on "Erase Data". I'm guessing you'll want to remove Club Competition History, Club Disliked & Favourite Staff, Retired Numbers, Staff Awards History and Staff Career History.

6. Once you've done that, click on the "Optimise DB" button (you'll see this to the left of the "Erase Data" section on the Database tab). The Optimise DB function does various things but, most relevantly for you, it'll recalculate the Player Stats. It does this based on the player career history. Seeing as you'll have erased all player career history, it'll reset all of the Player Stats to zero for you.

7. Click on File -> Save.

It's dawned on me that you cannot erase player records from team histories right now. That's something for me to add to my to-do list.

Welcome back to TBL.

[TehJesster]

You're exactly right - the EHM Updater is what you need. But you don't need the Index Updater. The EHM Updater does everything for you (including automatically updating the index).

Here's a basic overview of what you need to do:

1. Load the EHM Updater (make sure you use Run as Admin)

2. File -> Open Database

3. Click on the Database tab. You'll see a section on the right hand side entitled "Erase Data".

4. Under the "Erase Database" section, click on the drop-down menu and select what you want to delete. Then click on the "Erase Data" button.

5. If necessary, keep repeating step #4 above according to what you want to delete. You can just keep selecting different options from the drop-down menu and click on "Erase Data". I'm guessing you'll want to remove Club Competition History, Club Disliked & Favourite Staff, Retired Numbers, Staff Awards History and Staff Career History.

6. Once you've done that, click on the "Optimise DB" button (you'll see this to the left of the "Erase Data" section on the Database tab). The Optimise DB function does various things but, most relevantly for you, it'll recalculate the Player Stats. It does this based on the player career history. Seeing as you'll have erased all player career history, it'll reset all of the Player Stats to zero for you.

7. Click on File -> Save.

It's dawned on me that you cannot erase player records from team histories right now. That's something for me to add to my to-do list.

Welcome back to TBL.

Thank you very much! I will get to trying this right now, and I can live in my fictitious league with the team player histories in the meantime. :] I'll post if I run into any troubles

[TehJesster]

Wow, unfortunately I find myself with Error v3.0.4 database.cpp 4133 and luckily I know exactly where it happened. I went through and followed what you suggested to erase in the Updater one at a time, saving and then testing DB. Everything worked find one at a time until I did erase 'Club Competition History'. I've ran everything 'As administrator' first, EHM 2007 is updated to 3.0.4 and I am running on Windows 8 OS. Database I used in the indexer was TBL Rosters v6.3 (2006 Version).
Here is a list of all I did, in order.
- Erased Staff Career History (Worked)
- Erased Staff Award History (Worked)
- Erased Retired Numbers (Worked)
- Erased Club Dislikes (Worked)
- Erased Club Competition History (Error above)


Side Question: What does Erasing Drafted Players do?

[archibalduk]

- Erased Club Competition History (Error above)

Ah yes, there is a bug with club competition history right now. Best avoid using that one - sorry I completely forgot! I think I may have fixed it for the next version - but I'm not 100% as I need to do some proper testing.

Side Question: What does Erasing Drafted Players do?

It deletes the draft history. So that's both the Draft History screens in game and also on Player Profile screens where it says which team a player was drafted by. It doesn't however affect player rights.

[TehJesster]

Is there an alternative way to remove past Stanley Cup champions?

[archibalduk]

Is there an alternative way to remove past Stanley Cup champions?

I don't think so. I might have an old tool somewhere, but it won't be all that user friendly. I hope to have the next Updater ready this month or next and hopefully it'll have the club comp history removal working properly.

[TehJesster]

Is there an alternative way to remove past Stanley Cup champions?

I don't think so. I might have an old tool somewhere, but it won't be all that user friendly. I hope to have the next Updater ready this month or next and hopefully it'll have the club comp history removal working properly.

Alright, looking forward to that then.

[TehJesster]

One last question - If I used the Custom Start Date patch and set it to 1901, would it erase the Stanley Cup Champions that way? Since it would be 1901 and not 2006?

[archibalduk]

One last question - If I used the Custom Start Date patch and set it to 1901, would it erase the Stanley Cup Champions that way? Since it would be 1901 and not 2006?

Going from memory, I don't think it does. I think you'll just end up with duplicate entries once you reach the years where there are existing entries.

[TehJesster]

One last question - If I used the Custom Start Date patch and set it to 1901, would it erase the Stanley Cup Champions that way? Since it would be 1901 and not 2006?

Going from memory, I don't think it does. I think you'll just end up with duplicate entries once you reach the years where there are existing entries.

Thank you so much archi! I appreciate the time you've spent responding to my questions. I know of one way to "remove" the teams from Stanley Cup history page but it takes at least 2 hours. What I had done with the old database I mentioned in the OP is use the UK Pre-Game editor to manually change all the NHL teams and replaced them with the same name using the unused teams sitting in the database. It took a long time to copy all the info over to each of the 30 teams, and I could do that again but I think I will stay patient and wait for the next version of the EHM Updater. I appreciate the work you guys do and visit this site frequently. For now I will rebuild my Sabres in TBL v6.3 roster and see if I can win that McDavid sweepstakes.