Page 1 of 1

Blank Database

Posted: Sat Sep 08, 2012 4:41 pm
by archibalduk
This is a blank database for Eastside Hockey Manager 2007. It is based upon the Updated Unfaking Database v5.5 (I have used the UUDB as the basis because it has all of the unfaked team and competition names from the 2006/07 season). The purpose of this database is to help users create an entirely new database from scratch without any modern players and staff present.

Please note that I have left ten players/staff in the database. This is because the Pre Game Editor crashes if the database is completely blank.

Please note that this database is purely experimental. I HIGHLY recommend regular testing in order to ensure that the game is working as expected and that there aren't any crashes. You may risk significant data loss if you fail to test on a regular basis. Keep regular backups too.

I have simmed through a season using the blank database and it works okay.

Download: https://skydrive.live.com/redir?resid=A ... 29C5C5!513

Re: Blank Database

Posted: Sat Sep 08, 2012 4:55 pm
by nino33
Awesome! Thanks so much!

archibalduk wrote:I have simmed through a season using the blank database and it works okay.
Did you happen to notice if (after simming through a season) the game created any more (non grey) players than the 10 you started with?

Re: Blank Database

Posted: Sun Sep 09, 2012 10:55 am
by Vanaja
nino33 wrote:Awesome! Thanks so much!

archibalduk wrote:I have simmed through a season using the blank database and it works okay.
Did you happen to notice if (after simming through a season) the game created any more (non grey) players than the 10 you started with?
bad english warning.. :oops:

I did try to sim this database some seasons. selecting only nhl, ahl and finnish leagues..

Season 1 in begining there is 9926 players or staff. Allmost all of them are game created 14-17y old juniors for minor junior teams. finnish elite league did get some staff but no players, 1nhl player in database, . nhl and ahl have only gm/headcoach. same for canada major junior leagues.

Season 2 i check savegame editor and there is *drums* ........ 9926 players/staff. nhl have that 1 player, ahl none. canada major junior leagues have 0-2 players, one did have 10 and they all are very poor. random check with players, most have 10-40 potential, some have more. best was 97

Season 3 and there is 9926 players or staff... 1nhl, 0ahl and finnish elite league 1-3 per team. Every nhl team have players drafted but they do not sign eny. almost all nhl teams have 1 staff (gm/hc). some have 1-3. they are ex. gm/hc's from chl /uhc or europe
Finnish elite league best player (most goals 27 and points 53 with avR 5.71) have current ability 26 and potential 89. attributes are below 10, influence only is 14. he is 20y old, famous league star... :-D

Season 4 and 9926 staff.. nhl have 31 players total, ahl 2, finnish elite league have 22.
This year we have new Finnish elite league star. 17y old new comer, who have current ability 8 and potential 24. he did have most points in this year, winning Veli-Pekka Ketola Award :-D
Image

Didnt bother sim more season, even this starts looking funny.. maybe later i left game sim for overnight.

Currently It seems that game only create junior players + necessary staff in begining and then it's just regens...

Re: Blank Database

Posted: Sun Sep 09, 2012 11:09 am
by Vanaja
Season 5 and 9926. Now every nhl team have 2 players, some have even 4. Art Ross Trophy goes for Bill Beliveau, 20y old right wing. CurA 26 / PotA 82
Ahl have 8 players. Finnish elite league have only 11 players. best players :roll: have moved to nhl...

Re: Blank Database

Posted: Sun Sep 09, 2012 11:55 am
by Vanaja
Season 8 and no more than 9926 players/staff total...

Re: Blank Database

Posted: Sun Sep 09, 2012 3:16 pm
by nino33
Thanks for posting Vanaja!...your results are really positive to me, as I'm looking at the blank database as "the starting point" for for another retro project

Re: Blank Database

Posted: Sun Sep 09, 2012 3:19 pm
by Vanaja
simmed to year 2030 with no errors or problems. player and staff count is still 9926.

Re: Blank Database

Posted: Thu Sep 20, 2012 3:45 am
by Varlamov
Isn't there a way to clear out the name files? There are still "AAAAA" and "replace" in there, among others. They're not assigned to nations, but they're still there. And that's something I've never understood; if there is one player with a name in the DB, and you change that player, the name drops to zero ... until you reload it, and then it's 1, although no one has it, so it will still come up in the game. For example, the original Swiss researcher put in Aaron Lipp as Lipp Aaron, and Lipp forever remains a Swiss first name in the game.

Also, Darryl Amadio and Kevin Bruder have blank nationalities. The original DB had players like that too.

Re: Blank Database

Posted: Thu Sep 20, 2012 4:35 am
by nino33
Varlamov wrote:Isn't there a way to clear out the name files? There are still "AAAAA" and "replace" in there, among others. They're not assigned to nations, but they're still there. And that's something I've never understood; if there is one player with a name in the DB, and you change that player, the name drops to zero ... until you reload it, and then it's 1, although no one has it, so it will still come up in the game.
I just checked and the 1974 db and the Manimal 4.2 db and neither has names like "AAAAA" or "replace" in the Names Lists (the blank Database is based upon the Updated Unfaking Database v5.5)

There's no way to "clear out the file names" - as far as I can tell it's not possible to delete or remove a name, all you can do is overwrite the name you don't want with another name using the PreGame Editor (I actually spent last weekend going through the 1974 db Names Lists and fixing names)...maybe it’s possible to somehow overwrite the Blank Database Names Lists with the Manimal 4.2 Names Lists (I would not know how to do so!)

Re: Blank Database

Posted: Sat Sep 22, 2012 12:32 pm
by archibalduk
I have added the 'erase DB' function to the EHM Updater. Once I have finished my roster work, I will make some additional changes/fixes to the Updater and will then release it (I'd love it if I could have a new version out in October, but we'll have to see how things go). Anyway, with the next version of the Updater you can blank any DB you like.

With regards to the names, I could probably add a function which removes any unused names. I have noticed the apparently erroneous name counter in the Pre Game Editor too. One way around this is to use the Staff Validation function in the Updater after each time you use the Pre Game Editor. The Staff Validation function, amongst other things, recalculates all of the name counts.

Re: Blank Database

Posted: Tue Oct 02, 2012 4:38 am
by Primis
Hey thanks for this Archi.

It might be crazy, but I think I'm going to take a stab at creating a fictional DB from scratch. I know nino thinks it's impossible to keep players out of the NHL, but I'm going to see if I can find a way. I want to mostly render the NHL minor and useless, and spread out talent more between North America and Europe.

But mostly I just want a fictional DB. I don't want to be constrained by reality. I'm maybe going to bring some lesser hockey countries up, some overrated ones down, and generally make some new, more memorable players with some awesome names and traits.

Re: Blank Database

Posted: Tue Oct 02, 2012 4:52 am
by nino33
Primis wrote:I know nino thinks it's impossible to keep players out of the NHL, but I'm going to see if I can find a way.
IMO Merla had a good idea (http://www.ehmtheblueline.com/forums/vi ... =13&t=9950) trying to set the NHL Age Limit so low pros don't play in the NHL!
Merla was trying to "remove" the NHL to simulate the current NHL Lock Out...with the players set to Free Agents it seemed to work for EU players, but NA Free Agents retired without an NHL to play in!

Re: Blank Database

Posted: Tue Oct 02, 2012 5:15 am
by Primis
nino33 wrote:
Primis wrote:I know nino thinks it's impossible to keep players out of the NHL, but I'm going to see if I can find a way.
IMO Merla had a good idea (http://www.ehmtheblueline.com/forums/vi ... =13&t=9950) trying to set the NHL Age Limit so low pros don't play in the NHL!
Merla was trying to "remove" the NHL to simulate the current NHL Lock Out...with the players set to Free Agents it seemed to work for EU players, but NA Free Agents retired without an NHL to play in!
That's what I'm going to do, set the age limit to 5 or something. I'm also not really going to have UFA's, I'm not going to give them much of a starting choice. I'm going to try and populate leagues myself from the start and we'll see from there.

There's something about starting fresh with full creative control though. I can't believe nobody's done it with a DB yet.

Re: Blank Database

Posted: Fri Apr 19, 2013 5:50 am
by Animal31
I ran a test of this database, to 2060

I noticed a few things

The most notable is that CA does not improve as time goes on
Individual players get better, but they get better to the strength of their oponents. IE, at 26, the 3 players I added (regens) are only at 80 average, with 200PA, and playing in the NHL

another is NHL teams dont get the best players, the 2nd best defencmen by CA is currently in Sweden, is 27, and has a PA of 123, but his CA is only 88

What this means going forward, I have no clue. But I thought Id just say this

Re: Blank Database

Posted: Sat Apr 20, 2013 12:29 am
by nino33
Animal31 wrote:I ran a test of this database, to 2060

I noticed a few things

The most notable is that CA does not improve as time goes on
Individual players get better, but they get better to the strength of their oponents. IE, at 26, the 3 players I added (regens) are only at 80 average, with 200PA, and playing in the NHL

another is NHL teams dont get the best players, the 2nd best defencmen by CA is currently in Sweden, is 27, and has a PA of 123, but his CA is only 88

What this means going forward, I have no clue. But I thought Id just say this
I appreciate you sharing what you found. I thought I'd mention that the blank database wasn't really created to be a "database" but rather to be a starting point for a user created database

archibalduk wrote:The purpose of this database is to help users create an entirely new database from scratch without any modern players and staff present.
I was one of the users asking for this "blank slate starting point" for a user created database (the default database has 43,711 staff/players! My 1974 database [currently] has only 4,232 players/staff...it's great having the almost 40,000 unwanted "modern" staff/players removed from my retro database)


Regards :-)

Re: Blank Database

Posted: Sat Apr 20, 2013 12:37 am
by nino33
nino33 wrote:it's great having the almost 40,000 unwanted "modern" staff/players removed from my retro database)
Oops...I meant to say it's great having the over 40,000 unwanted "modern" staff/players removed

Re: Blank Database

Posted: Sat Apr 20, 2013 12:53 am
by Animal31
I know that, I was just testing it to see how the game would perform under the conditions that the database provided, and my tests showed the possibility to lower the entire leagues skill level, but not allowing it to grow properly

I left my desktop computer on overnight running on vacation mode, so its not like I was desperate to test how the blank database works, I just thought it would be an interesting experiment and observation

Re: Blank Database

Posted: Sat Apr 20, 2013 1:50 am
by nino33
Did you notice how many players/staff you had? Just wondering if it was 9926...Vanaja in his testing found he had 9926 after season 5, and still had 9926 in 2030

Re: Blank Database

Posted: Sat Apr 20, 2013 3:11 am
by Animal31
According to the scout tool;
5442 Players, 981 Non players, and 3140 Clubs

It started with
5439, 3509, 3140, at least with another start up

I added 6 players, 20 non players, and unknown clubs myself

I dont know if 3000 staff retired over 60 years, or if the database started with less. I can run another test if you want

Re: Blank Database

Posted: Sat Apr 20, 2013 3:23 am
by nino33
Animal31 wrote: I can run another test if you want
No need thanks, I was just curious
With my 1974 database at this point it seems about 4000 players/staff are created at start-up...I've never thought to look to see how many there were 25 years later (and I've never simmed 50 years!)

Re: Blank Database

Posted: Sat Apr 20, 2013 3:32 am
by Animal31
I had a really long final that day :B I started the sim at around 8 pm, came home around 1pm the following day
ive been using finals week to test all sorts of databases

one in which every player was rated 20 in every attribute, and every regen inharited the 20's somehow

and one where every player has 100 CA, and all 10 attributes, but for some reason dont seem to be developing aside from like 3 attributes

Re: Blank Database

Posted: Sat Apr 20, 2013 3:40 am
by nino33
Sounds interesting!
EHM certainly can be a challenge to understand :-)

Re: Blank Database

Posted: Sat Apr 20, 2013 3:46 am
by Animal31
I still dont know what numbers to give people in order for them to be both realistic, and how I want them