International squad updates on CEP 2.0

[bruce]

Im working on some international roaster updates so for those of you who is using the CEP and are a bit disappointed that there is no updates done on the international teams, im pleased and proud to share some updates with you. The updates are with correct jersey numbers, those players who are retired and not playing in international teams and have added quite a number of new players.
As time is running out for the release of FIFA 2007, I cant do much updates so my aim is only update some great teams like Brazil, England, Portugal, Holland, Germany, France, Spain, Czech Republick, Italy (Hope anyone can find Argentina). Who knows? When i have the time, i will do some more updates. If you have any international updates you have, please feel free to post it here Hope you all appreciate and enjoy it

Step for installation:
Convert your fifa database file into Microsoft Access format using UniDB 4.0 (download at http://fifaecp.com/downloads.html), or you can using DB Master (download at http://www.mysweetpatch.com/boutique/pafiledb.php?action=file&id=5790 to edit your fifa database file. Open table_teamplayerlinks then add and overwrite the datas as follow.

NOTE:
In order for this roaster update to work, you have to delete the D.Squads folder found in your CDocuments and Settings\My Documents\FIFA 06 directory.

Here are some updates i had already done:

Brazil:

teamid playerid jerseynumber position
1370 3712 1 0
1370 4767 5 11
1370 5003 2 3
1370 21570 12 32
1370 28130 10 23
1370 28765 11 19
1370 37576 9 29
1370 40702 30 32
1370 46042 4 6
1370 47390 17 32
1370 48717 22 33
1370 106019 7 32
1370 107715 3 4
1370 135423 13 7
1370 135451 24 33
1370 135455 19 33
1370 135460 31 32
1370 135479 15 33
1370 135520 16 33
1370 136137 25 33
1370 136144 23 31
1370 136161 18 33
1370 136187 6 33
1370 138449 8 15
1370 140008 26 33
1370 148711 14 33
1370 152855 20 33
1370 160774 21 33

France:

teamid playerid jerseynumber position
1335 883 19 3
1335 1419 4 11
1335 1607 16 0
1335 1615 15 32
1335 1625 12 31
1335 1668 6 32
1335 1747 23 32
1335 3813 1 32
1335 3912 14 33
1335 5818 13 33
1335 5984 20 29
1335 6647 5 7
1335 7784 10 33
1335 8376 2 4
1335 11031 11 32
1335 40898 9 26
1335 41635 25 4
1335 45062 17 33
1335 45577 21 33
1335 45601 7 28
1335 53030 18 11
1335 112253 26 33
1335 141645 3 7
1335 150656 8 11
1335 156616 22 33
1335 156726 24 33

Spain:

teamid playerid jerseynumber position
1362 41 13 32
1362 5479 1 0
1362 5623 19 33
1362 8348 2 32
1362 10535 8 16
1362 11576 4 6
1362 13038 5 3
1362 24630 23 32
1362 45186 17 33
1362 45197 14 32
1362 45655 27 7
1362 45661 7 33
1362 49369 9 31
1362 110856 11 19
1362 111008 6 18
1362 111093 10 32
1362 112640 12 33
1362 113422 21 29
1362 134597 20 33
1362 135606 22 33
1362 135745 3 33
1362 135866 16 15
1362 155862 15 4
1362 162895 18 33

 

[OckHAM]

Very good and very useful, but the in-game international rosters selection works fine with the CEP 2.0, so maybe it's a little bit easy if you do it through the game

 

[bruce]

Very good and very useful, but the in-game international rosters selection works fine with the CEP 2.0, so maybe it's a little bit easy if you do it through the game

Yes. But in game, i have to overwrite players to add in new players. But using those fifa databse editor utility, i can add players without overwriting any players and i can have more functions.

 

[OckHAM]

Mmm, not sure to have understood your notation about in-game national rosters selection: anyway as in the original game you can normally add and remove players from national teams, the only difference with CEP is that you have 20.000 more players to select.

 

[bruce]

Well Okham. I don't know how to make patches and i want to share my international updates with people here and is impossible for me to share my entire database file as i have installed lots of fonts so i just want to distribute only a part of my database file. So all i can do is only this. Do you have any other easier way?

England:

teamid playerid jerseynumber position
1318 27 11 19
1318 185 13 33
1318 244 2 3
1318 250 7 15
1318 388 12 32
1318 3363 14 33
1318 5419 10 31
1318 5467 15 33
1318 5471 8 18
1318 7289 6 4
1318 12265 16 32
1318 13349 26 33
1318 13690 25 33
1318 13732 5 6
1318 13743 4 16
1318 13843 28 33
1318 13914 1 0
1318 21146 18 33
1318 34079 3 7
1318 49076 17 33
1318 50542 23 32
1318 50598 27 33
1318 51257 21 32
1318 51850 22 33
1318 54013 20 33
1318 54050 9 29
1318 120312 24 33
1318 152747 19 32

Czech Republic:

teamid playerid jerseynumber position
1330 4305 8 15
1330 6083 6 7
1330 6095 16 19
1330 6135 7 32
1330 6233 12 33
1330 8473 10 23
1330 13380 19 33
1330 13940 9 29
1330 40988 2 3
1330 44902 21 4
1330 45202 13 32
1330 48940 1 0
1330 52632 15 31
1330 53407 4 11
1330 53551 17 33
1330 111198 25 32
1330 112244 20 33
1330 137006 36 33
1330 137020 5 32
1330 137965 14 32
1330 138468 22 6
1330 141267 23 33
1330 142421 3 33
1330 148130 11 33
1330 157311 24 33
1330 167413 18 33

Germany:

teamid playerid jerseynumber position
1337 61 22 32
1337 262 18 33
1337 496 28 33
1337 714 6 33
1337 763 25 32
1337 805 1 0
1337 3647 13 18
1337 3654 26 33
1337 3922 19 15
1337 5430 8 16
1337 5485 5 33
1337 10684 10 33
1337 11110 15 33
1337 11125 14 32
1337 11141 11 29
1337 11769 12 33
1337 12695 3 3
1337 30663 21 6
1337 49012 23 32
1337 51264 16 33
1337 53013 9 33
1337 53612 17 4
1337 105342 27 32
1337 121939 24 7
1337 121944 7 19
1337 137785 4 33
1337 150516 20 31
1337 164493 2 33

Italy:

teamid playerid jerseynumber position
1343 1075 7 32
1343 1088 13 6
1343 1179 1 0
1343 1183 5 4
1343 1238 10 23
1343 1323 20 33
1343 4202 8 19
1343 4731 28 33
1343 4832 32 33
1343 5099 19 3
1343 5879 11 29
1343 7569 29 33
1343 7631 18 32
1343 7763 21 11
1343 23015 9 31
1343 24332 15 33
1343 27578 17 33
1343 45461 16 15
1343 45595 2 33
1343 45733 3 7
1343 49617 27 32
1343 53302 4 32
1343 137160 14 33
1343 137186 6 33
1343 138956 31 33
1343 154634 22 33

 

[OckHAM]

No man, I think it's an excellent idea, just a bit complicated for the majority of the users, but really seems very good that you want to share this update with other users, anyway check the teamwrite settings too, if you remove a player that has an entry there the game can crash.

 

[bruce]

No worry Okham. I've tested the teams which i removed and add lots of players without editing the table_teamwrite and it works fine, even when i use up all my subsitutions. In my opinion, a clean FIFA 2006 game will not have any error message when you exit the game(correct me if I'm wrong).
For the roaster updates, I think that most user dont have any problems with installing it because so far, I've not seen any feedbacks from players having with problems.LOLX. Anyway I've finished another update:

Portugal:

teamid playerid jerseynumber position
1354 2823 15 25
1354 3081 1 0
1354 3622 16 4
1354 4006 13 6
1354 4077 11 32
1354 4083 8 32
1354 4086 29 32
1354 4098 19 33
1354 4205 21 30
1354 20169 6 12
1354 20176 23 32
1354 20205 14 7
1354 20209 4 33
1354 20212 18 10
1354 20731 12 32
1354 20775 27 33
1354 20798 30 33
1354 20801 17 21
1354 47131 5 33
1354 49204 10 33
1354 53769 20 27
1354 120202 2 3
1354 138984 26 33
1354 162347 28 33
1354 163010 22 33
1354 198420 32 33

 

[Lonestarr022]

Yes. But in game, i have to overwrite players to add in new players. But using those fifa databse editor utility, i can add players without overwriting any players and i can have more functions.

well as long as every national team has 23 players its not a big deal

although sifting through the england players for your choice, or brazil, takes a while