more nationalities?

[mrliioadin]

I'm wondering if there is any way to add more nationalities to the game so that when i'm editing national teams who don't have any players represented on any team in the origional game... I can tie them to their true nationality.

For instance I cannot have a player from Fiji in the game. is there any way to get the creation centre to let me tag a player as Fijian? (fijian? Fijan? Fijonia? afijiman?)

 

[Platini10]

Hi,

I've never tried this, but this is what I would do to add nationalities:

1) use UniDB and extract the fifa.db to access

2) create a new nationality1d on the "table_international_id" table

3) Create a Country id on the "table_country" Table

4) create the team (I'm assuming youknow how to do this)

5) Update the nationality on the "table_players" table

you may need to edit the language database to add the team names (short name etc.)

 

[mrliioadin]

I was afraid it might have to be done this way... I don't have MS access =-(. And can't exactly afford it atm. I wish I did... As i understand it it is a much quicker way of editing once you learn the program.

Thank's for letting me know tho man. I appreciate it.

 

[Platini10]

Hi,

There is a free program trial of Blueshell Data Guy. It is similar to MS Access and can easily handle relational databases:

http://www.blueshell.com/

You may be able to work with that. I can help you with data questions if they arise.

Good luck.

 

[mrliioadin]

Thanks man, I may give it a shot and see what I can come up with. I'll do it on my wifes comp so I dont F--- my db up or something hehe.

Thanks again

 

[Biebrich 02]

1. you don't have to do it on a different computer, it's enough do backup the file.

2. why exactly do you need the nationalities? it never really appears anywhere...

 

[mrliioadin]

It's in the player bio's... I'll look through them from time to time throughout a tournament. Also in Creation Centre you can search players by their natinalities i'm hoping to eventually do more with the national teams than just a straight 18-26 man roster for all the national teams... I haven't decided what yet but I'll probably do some youh teams and set up a progression of DBs to move through... But i'm not interested in getting em added anytime soon. And i'm also thinking about in the meantime just adding some like "africa" or "middle east"

 

[StevePitts]

I was afraid it might have to be done this way... I don't have MS access

Grab a copy Rinaldo's freeware DB Master (current version is 2.3 which supports both FIFA 06 and FIFA 07) and use that to dig into the database. If you use it to open ENG.DB (or the language file of your choice) then you will see, right at the end of that file, a group of strings with textids of 35000001 and up where the lower part of the number is the nationality (eg. England is 35000014). The game seems to link these strings automatically (ie. there is no direct link within the database data) to the associated nationality, but you will find that there are far more of them defined than there are entries in the 'country' table in the FIFA.DB file (including Fiji).

 

[Platini10]

Hi Steve,

I believe that there is a link to the country id. Your example of England 35000014 in the eng.db links to the country id 14 on the table_country table within fifa.db.

The eng.db has more nationality assignments than the fifa.db. If you wanted to add players with a nationality of Azerbaijan (on eng.db, not fifa.db), you would need to add the country code of 5 on the table_country (fifa.db) and assign the nationality of 5 on the table_players table (fifa.db) to have Azerbaijan appear on the player bio in the game.

Example:

eng.db

textid string
35000001 Albania
35000002 Andorra
35000003 Armenia
35000004 Austria
35000005 Azerbaijan
35000006 Belarus
35000007 Belgium
35000008 Bosnia Herzegovina
35000009 Bulgaria
35000010 Croatia
35000011 Cyprus
35000012 Czech Republic
35000013 Denmark
35000014 England

fifa.db

table_country

countryid countryname continentid
1 Albania 1
2 Andorra 1
3 ARMENIA 1
4 Austria 1
6 BELARUS 1
7 Belgium 1
8 BOSNIA HERZEGOVINA 1
9 BULGARIA 1
10 CROATIA 1
11 CYPRUS 1
12 CZECH REPUBLIC 1
13 Denmark 1
14 England 1

 

[StevePitts]

I believe that there is a link to the country id

Sorry old son, I think you misinterpreted what I said (or meant, which may not be the same thing). My comment was that there is 'no direct link within the database' (ie. there is no database table that ties countries to their associated names) but rather that the connection is achieved internally by the game code (which is true for country names at text id 35000000+ and for the various team names at text id 30000000+). The content of your post is spot on and hopefully helps to explain a little better what is going on.