DB editing

[andy359]

Hi,
I began to edit a roster with UniDB and Excel.
But now I have two questions:

1. Which position has which number?
2. Which nationality has which number?


I hopy you can help me. Thanks!

 

[StevePitts]

1. Which position has which number?

I don't use UniDB, since I have my own code for reading the various files, but you can find the position names start at textid 600 (I'm assuming that UniDB gives you the string data from ENG.D. Position 0 = textid 600 = 'GK', position 30 = textid 630 = 'ST', and so on.

2. Which nationality has which number?

Unfortunately there doesn't seem to be a simple answer to this one, because there are two types of country/nation ids, one related to team details and one to countries. If you are referring to the 'nationality' field in the player data, then you need to look the value up in the 'country' segment (which I would guess UniDB extracts into a separate table).

 

[Rinaldo]

Hi,
I began to edit a roster with UniDB and Excel.
But now I have two questions:

1. Which position has which number?
2. Which nationality has which number?


I hopy you can help me. Thanks!

Load the Intelli-Edit schema for FIFA 06. It will solve this problem for you! Try it.

 

[andy359]

Load the Intelli-Edit schema for FIFA 06. It will solve this problem for you! Try it.

I tried DB-Master with Inteli-Edit now, but I don't understand this Inteli-Edit completely. I opened the Fifa06.xml with DB-Master, but nothing happens. What am I making wrong?

 

[Kieron]

Pal! I dont understand why you use UniDB for editing?! FifaDATA 2.8 its a best editor for this... olny one thing after you finished your updates, you need "rebuild" your DB in UniDB (use original DB for that)

 

[Rinaldo]

I tried DB-Master with Inteli-Edit now, but I don't understand this Inteli-Edit completely. I opened the Fifa06.xml with DB-Master, but nothing happens. What am I making wrong?

After you have loaded FIFA06.xml, a box is activated that describe many numeric fields with its meaning.

 

[Rinaldo]

Pal! I dont understand why you use UniDB for editing?! FifaDATA 2.8 its a best editor for this... olny one thing after you finished your updates, you need "rebuild" your DB in UniDB (use original DB for that)

Yes, FifaData is an excellent editor, but it is not generic. With DB Master (as like with UniD you can open any .db file.

 

[Platini10]

Hi,
I began to edit a roster with UniDB and Excel.
But now I have two questions:

1. Which position has which number?

I got this from the eng.db, which can be expanded by unidb.

textid string
0 GK
1 SW
2 RWB
3 RB
4 RCB
5 CB
6 LCB
7 LB
8 LWB
9 RDM
10 RCDM
11 CDM
12 LCDM
13 LDM
14 RWM
15 RM
16 RCM
17 CM
18 LCM
19 LM
20 LWM
21 RAM
22 RCAM
23 CAM
24 LCAM
25 LAM
26 RF
27 CF
28 LF
29 RS
30 ST
31 LS
32 Sub
33 Res

 

[Platini10]

Hi,

The Nationality numbers can be derived from the table_country table.

Hope that helps

 

[andy359]

After you have loaded FIFA06.xml, a box is activated that describe many numeric fields with its meaning.

Oh, yes, now I can see it. Thanks!