Hello All,

I'm currently working on a roster update that will include each and every player in the FIFA databases from 2003-2007 (including WC, Champ's League, Euro, etc.). The DB is complete through 2004 with only 2003 to add. The goal in mind is to number each player according to the most recently assigned EA db number so that there is some uniformity to all the patches circulating out there.

There are currently about 24,000 records (excluding youth players and my add-ins). As a result, the DB is fairly large at about 3.3 megs; if there is a call I will attempt an upload somewhere.

Anyone interested in potentially using this database for a patch? If so, please just leave a reply here and we'll see what's up.

I would mind checking it out. Sounds Good.

I would use it becuase the squad that started the season has chnaged a little and we have quite a few young players joined us.

Hey fellas,

There's been a medical emergency in my family, and I'm probably going to need until after this weekend to finish the DB. I apologize for the delay, but in the mean time, this is version in about 90% complete:

http://files.filefront.com/FIFA_DBzip/;6612053;;/fileinfo.html

Thats OK. Just finish when you can. Just Downloaded 90% version.

Don't forget that there maybe players which have two ids, one from Euros/WC's the other from UCL ;)

Hello,

Robbie, the dups have all been taken care of.

The player numbers run like this: the most recently EA-assigned number for a given player is used with actual FIFA releases (ex. 2006, 2007) taking precedence over the Champ's League, Euro and WC games. 2007 was used as the base file for comparison purposes.

Added players not already in a FIFA db start at the number 300001. Whenever possible previously EA-assigned numbers were used for the teamid of any added teams that had already appeared in the FIFA series (ex. CSKA Moscow is team 315 and Dynamo Kyiv 101047). Just as with the players, the most recently EA-assigned number was used for each added team when applicable.

Here is a link for all the team number assignements used in the FIFA series to this point (Excel format):

http://files.filefront.com/FIFA_Teamszip/;6649988;;/fileinfo.html

At this point, the DB is currently updated for all the added teams (with the exception of Nautico, America-RN, and Sport Recife; this due to the traditionally heavy roster activity this time of year in the land of the samba). All transfers for the current window have been completed through Wednesday, the 24th. Currently, I am adding Togo and Trinidad, and plan to update the teams league by league after the official close of the transfer window.

Please feel free to contact me with any suggestions, constructive criticism, etc. (no complaints, please).

hmm, just to let you know that, for example, Laizans and Semberas (both in CSKA in UCL 04/05) had commentary under thier UCL ids, commentary which was carried over into subsequent FIFA's ;)

Oh also, the FIFA series still uses the older ids like 100601 for Luxembourg and 1050xx for teams like Macedonia, Bosnia-Herzegovina, San Marino & the Netherlands by default, so it might be better to have these teams given these id's instead of the WC ones.

Ah here's a list of team id's that may help:
1326 - Bosnia
1340 - Hungary
1347 - Luxembourg
1348 - Macedonia (FYR of)
1351 - N. Ireland
1358 - San Marino

1368 - Yugoslavia (which became: 110082 - Serbia/Montenegro in Euro 2004 and now Serbia in FIFA 07)

1376 - Peru

1409 - Iran

btw all these id's came from FIFA 2002 so if you have that you can look them up in there, as there's a .fsh file for every confederation which has all the teams sorted by the then id, much easier to use than the random assignment in WC 2006.

Nice team list btw ;) (Y) :rockman:

Oh and 1 more thing, won't you be needing art files for all these teams that u plan to add?

Hello,

Most of the art has been collected from various games, patches, etc. However, banners for the added international teams are still needed:

1342 Israel
1360 Slovakia
1411 Japan
1667 Senegal
105035 Netherlands
111108 Peru
111109 Colombia
111111 Morocco
111112 Côte d'Ivoire
111114 Saudi Arabia
111115 Iran
111149 Angola
111459 Chile
111462 Ghana
111481 Jamaica
111483 Togo
111484 Trinidad & Tabago

I don't have WC 2002, so thanks for the info, Robbie. Also, do you know of any other players like Semberas? If so, please let me know.

Hmm, if you need banner you can use the ones from Euro 2004 :bob:

Oh btw it's FIFA 2002, not WC 2002, that had the qualification stages sort of a RTWC bersion, and thus all the ids

The backgrounds for the CAF, AFC, CONCACAF, & COMNEBOL teams aren't available in Euro 2004 for the obvious reason that they're not in Europe. With a template found online, these have been created.

2003 players will be put off until the transfers from the last month have been updated. More or less all of the "missing" players from that game are retired at this point, so their inclusion isn't as vital.

Currently, I am working to add the 2007 J-league to the potential patch.

Here is a list of the 49 teams added to the db:

315 CSKA Moscow
1330 Czech Republic
1342 Israel
1360 Slovakia
1411 Japan
1667 Senegal
100765 Lokomotiv Moscow
100767 Spartak Moscow
101047 Dynamo Kyiv
101059 Shakhtar Donetsk
105035 Netherlands
111108 Peru
111109 Colombia
111111 Morocco
111112 Côte d'Ivoire
111114 Saudi Arabia
111115 Iran
111149 Angola
111459 Chile
111462 Ghana
111481 Jamaica
111483 Togo
111484 Trinidad & Tabago
120001 Toronto FC
120002 Arsenal Reserves
120003 Sport Recife
120004 Nautico
120005 America RJ
120100 Albirex Niigata
120101 Avispa ***ouka
120102 Cerezo Osaka
120103 FC Tokyo
120104 Gamba Osaka
120105 JEF United Chiba
120106 Jubilo Iwata
120107 Kashima Antlers
120108 Kawasaki Frontale
120109 Kyoto Purple Sanga
120110 Nagoya Grampus Eight
120111 Oita Trinita
120112 Omiya Ardija
120113 Sanfrecce Hiroshima
120114 Shimizu S-Pulse
120115 Urawa Red Diamonds
120116 Ventforet Kofu
120117 Yokohama F-Marinos
120118 Yokohama FC
120119 Kashiwa Reysol
120120 Vissel Kobe

I'm hoping to have this released shortly, but these things take time.

You're doin a very good job my friend, keep up the good work!

Thank You, man. Will Do!:ewan:

Hey there,

Egypt has been added to the db. The rosters for EPL, La Liga, and the Brasiliero are done and I may release this for anyone who is interested. Right now, the patch doesn't work with the CreationCentre. Hopefully, that will be rectified shortly.

Please be patient, it'll be worth it.

I'm interested, especially in the getting my epl rosters updated, but other main leagues as well

Hey everyone,

I'm going to try and get a premilnary version of the patch out there by this coming Monday (the 26th). It will include the added teams as well as updates for the EPL, La Liga, Bundesliga, and Serie A.

If I can complete the work sooner, I post a link. In any case, they're will definately be one on Monday.

Make you the Patch as cmp or in what form?
Because cmp were for all the best

Make you the Patch as cmp or in what form?
Because cmp were for all the best

its a db though.

ok

Hello Everyone,

Here is the link for the lastest work I've done:

http://files.filefront.com/Gonzos_Patchzip/;6815978;;/fileinfo.html

The Patch will work with both CreationMaster and CreationCentre, but you will have to install a fresh version of FIFA in order for it to work properly. The EPL and La Liga have been fully updated, while Serie A is about half-done (I didn't have the anticipated free time this past weekend). Also, the J-League teams are "shells" at present as there was some trouble with the data on the players. Those teams will be redone ASAP.

Other than that, everything should work just fine. Please let me know if there are any issues.

One more thing: I'm working on adding the missing commentary to the patch as well (in a separate download).

Finally, the patch is available in English only. Sorry guys!

Great work on the database, and I put on a fresh install to use it. I tried to add the San Marino national team as I have a softish spot for them. However, FIFA 07 crashes just as it loads a match with San Marino selected.

Is there an issue with adding teams to your data?

I did a test yesterday adding Holland to my own data, only with kits from the 'Net and no other things like mini kits or badges. I did that also for San Marino, there's no reason that I can think of why it won't load. I assigned a squad to them in CM and made sure they had the squad filled.

Hey there,

In answer to the preceeding post, I'm not sure why the team wouldn't work, man. With the exception of Access editing, the CM is the program I've used to build the teams, etc. I actually added Egypt after the initial DB was completed without any issues as far as game play.

I had an issue with the J-League teams, but that was sillyness on my part (duplicated players #'s etc.) The only team that I did have trouble adding was CSKA, but I was able to distill that down to a pesky face texture I had imported for one of the squad members.

Since the majority of the players from San Marino don't have custom faces, that's obviously not the issue. We can also rule out .fat regeneration being the problem since you used CM and that's done automatically. I've rechecked the db to rule out duplicate players numbers. The missing badge, minikits, etc. shouldn't cause that kind of a problem either. It's not likely the kits would cause the game to crash either, so I'm really at a loss to explain why the game's crashing on you.

Sorry I wasn't able to provide the solution, man.

An Update:

Serie A rosters are done and the Bundesliga should be done by Tuesday or Wednesday. After that it's Ligue 1, a reconstrution of the J-Leauge, and then a visit over here to the Americas for updates to the Primera, Brasiliero, and MLS.

Ultimately, I would like to update every team, but I don't want to bite off more than I can chew, as it were, so we'll just have to see what unfolds.

Hello,

A quick update. The French and Portuguese Leagues are complete. More than likely Turkey and Holland will come before the Americas.

Hello,

Here's part of the upcoming patch in .cmp:

315 CSKA Moscow
1330 Czech Republic
1342 Israel
1360 Slovakia
1411 Japan
1667 Senegal
100765 Lokomotiv Moscow
100767 Spartak Moscow
101047 Dynamo Kyiv
101059 Shakhtar Donetsk
105035 Netherlands
111108 Peru
111109 Colombia
111111 Morocco
111112 Côte d'Ivoire
111114 Saudi Arabia
111115 Iran
111130 Egypt
111449 Angola
111459 Chile
111462 Ghana
111481 Jamaica
111483 Togo
111484 Trinidad & Tabago

Club Teams (http://files.filefront.com/Gonzos_Club_Add_Onzip/;7009956;/fileinfo.html)
International Teams (http://files.filefront.com/Gonzos_international_Add_nzip/;7009966;/fileinfo.html)

Enjoy.

Here a .cmp updates for La Liga, EPL, Liga BWIN, Serie A, and the Bundesliga.

Download (http://files.filefront.com/Gonzo_Vol_1zip/;7051264;/fileinfo.html)

Here's an updated list of teams, stadiums, and countries as they's appeared in the FIFA games over the years:

Download (http://files.filefront.com/Gonzos_international_Add_nzip/;7009966;/fileinfo.html)

Hello,

Here is a new .CMP international add-on that will add Copa America 2007 and the 2006 World Cup to tournaments.

Download (http://files.filefront.com/Gonzo_International_Add_Onzip/;7070242;/fileinfo.html)

nice job

Yes... good work ;)

Thank You, Thank You very much.:)

Hello,

The Champion's League .db has been integrated into the .db files which started this thread. The completed w/2003 should be up within the next few days for anyone that whants them.

In the mean time,

Here's an update to the club's add-on I've already released:

259 Levski Sofia
284 Beitar Jerusalem
315 CSKA Moscow
399 Maccabi Haifa
100545 Maccabi Tel-Aviv
100761 Steaua Bucharest
100765 Lokomotiv Moscow
100767 Spartak Moscow
101047 Dynamo Kyiv
101059 Shakhtar Donetsk
120011 Red Star Belgrade
120012 Partizan Belgrade
120013 Dinamo Zagreb
120014 Zenit St. Petersburg

Download
(http://dodownload.filefront.com/7168566//38b01c839b44a3f312c1f08bfaea87588974ec2bf1b1e5880c 0e6434c0ad80f03309c4f0774ea934)

Man, thank you very much for all of this!
I'm just loving this because I like to tinker with the database a lot too!

However, as I quickly skimmed through the thread, I was left kind of confused :$ Will you actually release J-League with all the teams and their kits, banners etc? It would be the best patch ever. :)

Will you actually release J-League with all the teams and their kits, banners etc? It would be the best patch ever. :)

Yes, I'll definately release the J-League. I've been a little sidetracked of late, but will finish J-1 within a week, week and a half. I'm building the league rosters more or less from the bottom up, so it's taking a little time to make sure I get the postions, etc., correct. I think/hope that I've got that worked out.

Sooner or later, I'll have an MLS update, hopefully Mexico and Brazil as well - Brazil in late May after the Brasiliero starts. I haven't finished Ligue 1 or the Eredivisie as yet either, but I plan to get to them.

Here's an update for the US national team:
Download (http://dodownload.filefront.com/7169679//38b01c839b44a3f312c1f08bfaea87588974ec2bf1b1e5880c 0e6434c0ad80f03309c4f0774ea934)

Hello,

The Champion's League .db has been integrated into the .db files which started this thread. The completed w/2003 should be up within the next few days for anyone that whants them.

In the mean time,

Here's an update to the club's add-on I've already released:

259 Levski Sofia
284 Beitar Jerusalem
315 CSKA Moscow
399 Maccabi Haifa
100545 Maccabi Tel-Aviv
100761 Steaua Bucharest
100765 Lokomotiv Moscow
100767 Spartak Moscow
101047 Dynamo Kyiv
101059 Shakhtar Donetsk
120011 Red Star Belgrade
120012 Partizan Belgrade
120013 Dinamo Zagreb
120014 Zenit St. Petersburg

Download
(http://dodownload.filefront.com/7168566//38b01c839b44a3f312c1f08bfaea87588974ec2bf1b1e5880c 0e6434c0ad80f03309c4f0774ea934)


Great ,thanks for this,
PARTIZAN Belgrade is my favorite team:mrpimp:

Yes, I'll definately release the J-League. I've been a little sidetracked of late, but will finish J-1 within a week, week and a half. I'm building the league rosters more or less from the bottom up, so it's taking a little time to make sure I get the postions, etc., correct. I think/hope that I've got that worked out.
Very, very glad to hear that! Take your time. :)
Btw, have you been able to retrieve some players' original heads? Such as Shinji Ono and others who EA have made? :O Just curious. :)

And I hope you give Makoto Hasebe a good rating..! :mexican:
just kidding, but anyways, good luck with the project! :)

Btw, have you been able to retrieve some players' original heads? Such as Shinji Ono and others who EA have made?

Hello,

The J-League is half-done. So, I should have something out by mid- to late-next week.

Also, if you renumber a player to their original EA player number the face will already be loaded into the game if the player previously had an EA-designed face. For example, Ono's original player number is 29118. (You have to use access to edit the player number in this case). There is already a face in the game for him. Same with Batistuta, Guardiola, David SEaman, and a bunch of others.:mrpimp:

Hello,

Here is a download for Urawa Reds & Gamba Osaka:

Download (http://dodownload.filefront.com/7241342//38b01c839b44a3f312c1f08bfaea87588974ec2bf1b1e5880c 0e6434c0ad80f03309c4f0774ea934)

The rest of the league is soon to come.

I `m waiting for your J league ,mate ...:)

Guys or gonzo
anyone now FIFA ID for next national teams

Costa Rica
South Korea
USA


I mean in any Fifa version, their standard ID`s ???

Thanks for reply ;)

anyone now FIFA ID for next national teams
Always assuming that I'm not jumping in somewhere where I've misunderstood the requirement, I'd say:

Costa Rica - 1383
South Korea - 974
USA - 1387

thanks StevePitts, I found those ID`s early,
but thanks anyway
(they are correct)

Gonzo, where can i find Guardiola, Batistuta, Djorkaeff and other retired players????

Gonzo, where can i find Guardiola, Batistuta, Djorkaeff and other retired players????

Hola,

To "find" the retired players what you need to do is access an older FIFA db to retrieve the players old FIFA playerid. Then you use the UniDB to open you the FIFA 2007 db and a player record with the ID from the older version of FIFA (i.e. David Seaman is playerid 1) via Microsoft Access (or some comparable program). Save your work and reimport the access file into your FIFA 2007 db using UniDB. That's pretty much the skinny.

If that's too much you can always download my updated which will be up before the end of this weekend.

An additional note: I have about 4 more teams to edit to complete the J-League. The Mexican league has been updated and MLS is more than half-done. By the end of this weekend, end of next week at the latest, the links will be on this thread.

For anyone who's interested here is a copy of the db files I had mentioned in the previous post. Among the retired players inclued are Batistuta and Pep Guardiola. It also contains the info for every previous CMP file or patch I've put out.

Download (http://dodownload.filefront.com/7293865//38b01c839b44a3f312c1f08bfaea87588974ec2bf1b1e5880c 0e6434c0ad80f03309c4f0774ea934)

Hello,

Sorry for the delay on this one, but the long-promised J-League patch will be done at some point on Tuesday. Hopefully before the Champion's League kick-off, but I can't promise that.

Stay tuned.

For anyone who's interested here is a copy of the db files I had mentioned in the previous post. Among the retired players inclued are Batistuta and Pep Guardiola. It also contains the info for every previous CMP file or patch I've put out.

Download (http://dodownload.filefront.com/7293865//38b01c839b44a3f312c1f08bfaea87588974ec2bf1b1e5880c 0e6434c0ad80f03309c4f0774ea934)



hey gonzo99, would there be any problem if i juz install into DB into my fifa without using ur previous patch?will it still work ? cos the Readme file says 'To activate the added teams please download and install the CMP files'

hey gonzo99, would there be any problem if i juz install into DB into my fifa without using ur previous patch?will it still work ? cos the Readme file says 'To activate the added teams please download and install the CMP files'

Hey there,

No, man, there should be no problem if you don't use the db. The .db file has the player/team info contained within it, so by using that file you would just be updating the information already in the game. If you skip the .db file, then just import the league w/CM07 selecting the add function.

Hopefully that will help.

An additional note: I have about 4 more teams to edit to complete the J-League. The Mexican league has been updated and MLS is more than half-done. By the end of this weekend, end of next week at the latest, the links will be on this thread.

I'm looking forward to your MLS update as I'm a big fan. Are you going to add Toronto FC? Keep up the great work.

I'm looking forward to your MLS update as I'm a big fan. Are you going to add Toronto FC? Keep up the great work.

Thanks, and yes, Toronto has been added. The update for MLS should be done before this weekend, at worst on Monday.

Thanks, and yes, Toronto has been added. The update for MLS should be done before this weekend, at worst on Monday.

a little late, but here's the MLS update:

Download (http://dodownload.filefront.com/7411191//d66c467cca9ea37802d3ea8622edc825618dc9438f8323ade6 09ea96cea5dc6d8a595f5269602e73)

A word: the rosters for many of the teams aren't finalized with the league, as such some players are without an updated appearance.

a little late, but here's the MLS update:

Download (http://dodownload.filefront.com/7411191//d66c467cca9ea37802d3ea8622edc825618dc9438f8323ade6 09ea96cea5dc6d8a595f5269602e73)

A word: the rosters for many of the teams aren't finalized with the league, as such some players are without an updated appearance.

cool... Im downloading it right now. 700 megs.:) this should be very good.

Clint Mathis forever!

cool... Im downloading it right now. 700 megs.:) this should be very good.

Clint Mathis forever!

well that was 700 megs of the wrong thing.

I am trying to import this file and it crashes my game on loading. I am using the Career Expansion Pack v4 and I just want toronto FC in the existing MLS league. is this possible?