Updated rosters?

[Spectra]

Hi,

I reviewed the database and found some potential serious problems.

The person that created the patch/database re-used existing Youth player IDs (607 of them), renamed the players and added them to the teams. The main issues that I see are:

(1) 4 -14 year old players on teams

(2) With the youth ids being used, this could cause potential crashes in subsequent seasons as the ids are already in use

(3) Youths have been depleted by 607 players

Hm, interesting. I experienced a crash between the second and third season and this could be why then.

I've edited the hell out of this db but that's just to have something to do until 08 gets released. Guess I won't be starting a new career before that then hehe....

 

[Platini10]

Fixing the roster with unidb

Hi, I'm posting this reply in this thread to avoid hi-Carlos*ing the creation master thread.

Originally Posted by leavemealone
link of update which i am using
http://www.eamods.com/Downloads/details/id=276.html
i got this link from the thread "Updated rosters?"

Hi,

This roster update will cause crashes in subsequent seasons because the auther re-used over 500 Youth Ids to create new players. You will run into errors when the game tries to generate a new youth that has an id in use.

Originally Posted by leavemealone
ya.i know.only for first time it runs ok.but from 2nd time there is crash when i start new season with same team.do you know the solution?shall i change the ID or delete young players?

Hi,

*All of my changes were made in the fifa.db*

I solved this problem by editing all of the re-used Youth player Ids and created new ones. example: for 410110, I added a leading 6 to make the id 6410110 (original youth player = Niels Sondergaard, he was replaced by Alexandre Song in the patch). My change reinstated Sondergaard as a youth with id 410110 and I created Song with the new id of 6410110.

I used a different program to edit that extracts the fifa.db into relational database that I open with MS Access.

I had to change the table_players table to edit the player ID. Once I changed all of the ids, I reloaded all of the original Youths from the original fifa.db. After the table_players table was "fixed", I had to edit the table_teamplayerlinks (this is the table that sets the rosters). I made the same changes on this table, meaning, I modified the playerid to have a leading 6 for the used youth ids.

Your random crash at the start of a new manager could be caused by a couple of things, 1) youth assignment is random and you could have hit a duplicate id at the start of the first season, 2) Duplicate Youth Ids can appear when you "scout for new players 3) some of the players that the patch updated kept the original birthdates of the youths - I found a 4 year old on a team .

thanks.
i have installed all tools available from the thread.i have unidb installed on my PC.now i will try to change ID and try as you said above.

Great. The easiest way to find the re-used ids is to go to the table_teamplayerlinks and sort the column by playerid. The youths on the fifa.db are in the range of 400000 - 410974. There should be no players with an id in that range assigned to a team. Once you change the ids, you will need to replace the used id's with the players from the original fifa disk to ensure that the youths are generated properly throughout a manager career.

 

[leavemealone]

i am changing IDs but i am not recovering the originals.how are they recovered?

 

[leavemealone]

changing 11000 IDs is too much.i am just changing IDs of those players who are assigned to a team.will it work?

 

[Zefilio]

changing 11000 IDs is too much.i am just changing IDs of those players who are assigned to a team.will it work?

I don't think so because the free agents can be contracted in career mode during transfer season, so that will cause the infamous loading bar crash between two seasons in a career...

I have updated my fifa.db with up to date transfers and relegation/promotion but I added over 250 new teams and many new leagues, so posting mine won't help the general user either... (and the language db's other than dutch and italian still need to be updated if I should release it to the general public)

 

[leavemealone]

I don't think so because the free agents can be contracted in career mode during transfer season, so that will cause the infamous loading bar crash between two seasons in a career...

so what do you suggest to do?

 

[Zefilio]

so what do you suggest to do?

Well, there is no easy solution. What I would do is convert the original fifa.db to mdb format and open it in access, then do the same with the edited fifa.db opening it in a second instance of microsoft access.

Delete all youth players in the edited database and replace them with the original youth players. Of course if the editor used youth players id's to replace them with actual players linked to teams you have more work to do.

You'll have to change the id's in the table_players, table_team_player_links and table_playerwrite to id's in the normal range instead of the youth player range (id's 400000 and up, change them to free id's of a lesser value), if this has to be done it's even better to export the whole thing to microsoft excel and replace them "en masse" then importing them back to access... excel is easier to edit a large number of records as you can use the "slider" from cell to cell to increment the values easier than you could do in access.

In any case you're in for a lot of work and above all take backups, several ones. It's up to you if you want to invest that many time in it with Fifa08 lurking around the corner.

Note : If you have the id number changes to do, then of course you'll need to change them first before you "restore" the youth players from the original database.

 

[leavemealone]

how do you restore the youth players from the original databases

 

[leavemealone]

how do you restore the youth players from the original databases?

 

[Zefilio]

As I described above, copy/paste from mdb to mdb in Access.

 

[leavemealone]

i am editing fifa.db first time.please elaborate what to do in MS access.
what i have done is i am changing the IDs by adding 6 as suffix in table_players.
i have changed IDs from 410000 to 410974 to 6410000 to 6410974.
now i dont have any players from ID 410000 to 410974.so,i havent been able to recover youth players from original database.so,how to do it?

i want to learn editing fifa.db

 

[Zefilio]

i am editing fifa.db first time.please elaborate what to do in MS access.
what i have done is i am changing the IDs by adding 6 as suffix in table_players.
i have changed IDs from 410000 to 410974 to 6410000 to 6410974.
now i dont have any players from ID 410000 to 410974.so,i havent been able to recover youth players from original database.so,how to do it?

i want to learn editing fifa.db

With UniDB program (from Fifa ECP) convert original fifa.db to fifa.mdb, open the converted .mdb in MS Access, do the same with the edited fifa.db, now go to the table_players from the original fifa.mdb, copy all records from 410000 to 410974, paste them into the table_players of the edited fifa.mdb, sort the records by id, from small to greater numbers, do the same for the table_playerwrite. Then convert the edited fifa.mdb back to fifa.db and use it in your fifa07/data/cmn folder

Btw, I don't know if adding the 6 in front of the id will work as I am almost sure Fifa always considers every player id greater than 400000 as a youth player...

 

[leavemealone]

thanks.i got it.

 

[Platini10]

i am editing fifa.db first time.please elaborate what to do in MS access.
what i have done is i am changing the IDs by adding 6 as suffix in table_players.
i have changed IDs from 410000 to 410974 to 6410000 to 6410974.
now i dont have any players from ID 410000 to 410974.so,i havent been able to recover youth players from original database.so,how to do it?

i want to learn editing fifa.db

Hi,

You really only needed to update the ids that were in use according to the teamplayerlinks (about 500+ - some were added twice because the players were on a country or allstar team as well).

fifa07 does not use a playerwrite table anymore, so identifying players is a lot easier.

 

[Platini10]

In any case you're in for a lot of work and above all take backups, several ones.

Isn't that why editing is sometimes more fun than playing?

 

[Platini10]

Btw, I don't know if adding the 6 in front of the id will work as I am almost sure Fifa always considers every player id greater than 400000 as a youth player...

I haven't run into this issue before, though I did get an unexpected crash every now and then. I'll convert the used youth players to 1-up from the last non-youth in the original data base (I can do this rather quickly). Thanks for the head's up.

btw, do you still do your chant/sound packs?

Thank you,

P10

 

[leavemealone]

i think there will be no crash after my editing.
what i have edited is i deleted all IDs 400000+ from the table_teamplayerlinks and no editing in table_players.
now i tested this modified fifa.db 3 times.
1 season with porto and 2 seasons with FC basel 1983 by simulating matches.now there is no crash between seasons.

if someone wants to test the modified fifa.db i can mail it.
thanks to Zefilio and Platini10 for helping me in using unidb.

 

[Platini10]

i think there will be no crash after my editing.
what i have edited is i deleted all IDs 400000+ from the table_teamplayerlinks and no editing in table_players.
now i tested this modified fifa.db 3 times.
1 season with porto and 2 seasons with FC basel 1983 by simulating matches.now there is no crash between seasons.

if someone wants to test the modified fifa.db i can mail it.
thanks to Zefilio and Platini10 for helping me in using unidb.

Hi,

You may run into issues where you play a team without the minimum number of players. There are many teams with at least 5+ ids added to the the teamlinks that were re-used youth ids.

you may also encounter a 33 year old youth

If you'd like, I can send you my modifed database. I am changing all of the re-used youth ids to ids that 1-up from the last non-youth on the original fifa.db (I'm starting from 178630). I will also add in all of the real youths from the original and re-link all of the teamplayer links.

If you like to edit, this is a great tool and process to understand the inner linkings of the game. You can also modify any language database (eng.db) and the meta.db with unidb and access. Most changes to the database will ruin a current career, so keep back-ups.

BTW - unidb seems to work fine for fifa08. I was able to play around with the demo db a bit, but did not actually play the demo (I also wanted to extract the new Premiership Numbers to import into fifa07).

Best of luck

P10

 

[leavemealone]

nice.thanks for the info.i think that editing fifa.db will be fun.so,i am trying to learn it.

i will also make another fifa.db with all the youth from original fifa.db

 

[Platini10]

Best of luck with your editing.

Here is the database that I created. This has re-issued playerids for the used youth players. I also added back all of the original youths and re-linked all of the players again. All previously used youth ids have now been re-assigned numbers starting with 178630. Keep in mind that I did not modify any bit of the roster that was created by the patch.


Please send me a PM if you would like the link to the download.

P10