Originally posted by cgr
after reading the language file (Shifty.db for my case), does anybody know how I can link that to the teams and leagues in the fifa.db access file?
The Teamname are always THREE Databaseentries in [lang].db for EACH Team.
Think that the complete id in the db has 8 digits.
The first 7 ist related to the team. The last one related to the "type of entry".
In example of Aachen.
30018260 Alemannia Aachen
30018262 A. Aachen
1 and 2: Identifier for "Teamentry". Don´t think about tha, just use it
In normal Teams it is 30. There are Teams with 31 also but this are possibly (dunno exactly) team for a special playmode in fifa!?
3, 4, 5, 6 and 7: TeamID
8: Here you find 0, 1 and 2
0 is the "long Teamname"
1 is Teamname short (5 chars)
2 is Teamname medium (i think 10 chars like in 04)
In the fifa.db you should have to use ONLY the teamid without leading 0´s
In this example it means that
30018260 would be translated to
We don´t need the Teamidentifier 30 and we don´t need the long or short name... remove 0/1/2
01826 without leading zero is 1826. And THAT´S the TeamID of Alemannia Aachen.
Hope it helps!?