You can now edit the FIFA 2005 rosters and database by using UniDB 3.0.

Version 3.0 adds FIFA 2005 support, where you can export FIFA 2005 databases (.db files) as well as FIFA 2004 and UEFA EURO 2004 formats.

You can then view the exported MDB database using Microsoft Access 97/2000/XP (2003 not tested, but should be compatible).

Enjoy.


www.fifaecp.com

Great mate. It works perfectly..

It works great for the fifa.db und meta.db, but it doesn't work with fifa.db. When I want to convert the ger.db, there is an error :(

Another question: Where can I find the Team-names ??

Version 3.1 now fixes the problem.

Team names can be found in the language db

http://www.rincontotal.cl/images/problema.JPG

Please Help me!

Thanks Hercules

BetoHuck
RinconTotal.cl

Originally posted by BetoHuck
http://www.rincontotal.cl/images/problema.JPG

Please Help me!

Thanks Hercules

BetoHuck
RinconTotal.cl

The output db and the base db shouldnt be the same file.

Thanks mate. :)

how to read the players name only number!:(

look at the playerwrite table

thx mate!then match it iszit?

how can I change arsenal and acmilan to southampton and portsmouth?

just change the team names, team attributes, player names, player attributes?

Don't work with Access 2003 SP1:(

i've tested it today on ACCESS 2003.. it works well :)
good job!!

Originally posted by Hercules
just change the team names, team attributes, player names, player attributes?

I have found how to change players but not team names

team names are in eng.db

Hi Hercules, I can't figure out the difference between 2 columns in teamkits table: "jerseynumbercolorid" (1) and "numbercolor" (2). I think it's the same difference that intercurs between "shortsnumbercolorid" and "shortnumbercolor".
Well the problem is that I was trying to change AC Milan numbers color from white to gold. It seems that changing column (2) values it's useless. Instead If you change column (1) values you can put different fonts on the kits, but with a specific color only!
For example 221 is for EPL font white, 222 is for EPL font black.
I can't find the code for Adidas (or another generic font) gold!
Can you help me please?
Thanx :(

can anyone tell me where I can find the file for editing the tv pop ups please :D

Herkules: Is there a possibility to get an second unidb which converts from/to csv-files (comma-separated-values)....

I could use such files to manage the data from within my php-scripts at www.vdfb.de (a (the) german bundesliga).... With such a unidb (possibly starable via commandline with parameters to help automatism) i can easy make a new patch for my users each weak an i dont have to write an additional tool to convert my csv´s into the access-db...

Would be nice to get an positiv answer from you. Hold on you good work!!!! And thanx a lot for the exiting tools!!

Best regards,

DonManfred (coder of vdfb.de)

after reading the language file (dan.db for my case), does anybody know how I can link that to the teams and leagues in the fifa.db access file?

Originally posted by cgr
after reading the language file (dan.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.

You´ll find
30018260 Alemannia Aachen
30018261 Aachn
30018262 A. Aachen
12345678

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
30
01826
0

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!?

THANKS!!

just what I needed :-)

I'll suppose there's a similar logic for the league names and position names, but I'll figure that out myself.

the leagueid can be extracted in a similar way where the first 2 digits are "10"

- however, the positions doesn't really seem to be that logical, since they run from 1592-1621....

I'll investigate a bit and get back, if I find a suitable logic to it.

Originally posted by Hercules
You can now edit the FIFA 2005 rosters and database by using UniDB 3.0.

Version 3.0 adds FIFA 2005 support, where you can export FIFA 2005 databases (.db files) as well as FIFA 2004 and UEFA EURO 2004 formats.

You can then view the exported MDB database using Microsoft Access 97/2000/XP (2003 not tested, but should be compatible).

Enjoy.


www.fifaecp.com

Great tool. :rockman:

Whats up with creating own teams ??? Can we now ? :rockman:

Cya !

would this work on saved files as well?

Can someone please tell me why the Sleeve attribute doesn't work? The number is either 0 or 1, I'm assuming 1 is long sleeves. But I have never seen any players apart from my Created one wear long sleeves. Is this a buG??

direct link for download???

What's rtsg?

I don't have Acces, can Fifa ECP make DBEdit for Fifa 2005?

Originally posted by ngyc
direct link for download???

- www.fifaecp.com

go find it yourself :rolleyes:

Team Positions

600 GK
601 SW
602 RWB
603 RB
604 RCB
605 CB
606 LCB
607 LB
608 LWB
609 RDM
610 RCDM
611 CDM
612 LCDM
613 LDM
614 RWM
615 RM
616 RCM
617 CM
618 LCM
619 LM
620 LWM
621 RAM
622 RCAM
623 CAM
624 LCAM
625 LAM
626 RF
627 CF
628 LF
629 RS
630 ST
631 LS
632 Sub
633 Res
634 LCF
635 RCF

Disregard the digit 6 at the beginning of the code.
Extracted from the eng.db file of Fifa 2004. This should help you potential editors out there.

Bless.

Originally posted by MancoBlanco
I don't have Acces, can Fifa ECP make DBEdit for Fifa 2005?

- Hercules already said he would put more work into this, IF he can find the time.

Untill then, get MS Access, and start learning some DB work - I'm sure it'll be useful for you :)

hmmm Keegan, I believe my positions in my dan.db file are numbered differently, or maybe I just missed some positions sitting at 6600-6633

i'll go have a closer look

Can sum1 tell me the playernumber of Romeo Castelen (Feyenoord)??

Originally posted by cgr
hmmm Keegan, I believe my positions in my dan.db file are numbered differently, or maybe I just missed some positions sitting at 6600-6633

i'll go have a closer look


I've actually used the positions I listed above in a patch-in-progress and it works perfectly... but I didn't look at the dan.db (for obvious reasons) but hey... it may actually be different.

Bless.

i cant find it !!!
when i click on downloads section it said not found page !!
can anybody gimme the direct plzzzzzzzzz:(

I used UniDB to convert fifa.db into access database, and found player names in "table_playerwrite" table. But there is some problem with changing.
I successfully changed one player name corresponding to the proper player_id field for my team, but when i changed another name, problem occurs. When I start game on go into squad settings for the team i have only formation, not any of the player names.
During some hours on work on this database i figured that if I use shorter surname for the second player I want change, then the game is ok.
Does someone know what is the problem?
Thanx in advance!

http://www.fifaecp.com/

- at the very bottom of the page

Originally posted by MancoBlanco
Can sum1 tell me the playernumber of Romeo Castelen (Feyenoord)??

28230 Romeo Castelen

Originally posted by cgr
http://www.fifaecp.com/

- at the very bottom of the page

Yes, I use that version of UniDB.

how can i convert eng.db completely? it doesn`t work with unidb...

I have edited some squad numbers, but they aren't in the game. How can i get them in the game?

Originally posted by Hercules
You can now edit the FIFA 2005 rosters and database by using UniDB 3.0.

Version 3.0 adds FIFA 2005 support, where you can export FIFA 2005 databases (.db files) as well as FIFA 2004 and UEFA EURO 2004 formats.

You can then view the exported MDB database using Microsoft Access 97/2000/XP (2003 not tested, but should be compatible).

Enjoy.


www.fifaecp.com

Are you sure the game don't crash when used

Download this wicked Desktop pic!!!


Edit: Inappropriate Image

Originally posted by John 5
Are you sure the game don't crash when used


- if you mess up the data in the access database, and then convert back to fifa.db, the game will probably crash. :rolleyes:

If you only change the data sensibly, the game will work perfectly well. :)

the unidb is a little wonky i find... try editing player first and last names a bit and you will run into big problems...

also i cannot edit team kit fonts!
i tried changing the Greece kit font to the correct one: 10 (adidas like France, Spain, Germany etc..) but it doesn't work for me....
am I crazy or am I right... someone try it and tell me.
:confused:

might be so - I only use it to modify player stats and team formations :-)

when will there be a DBEdit++ release 4 Fifa 2005?

I'm not sure there wil be any dbedit release from fifaecp - last thing Hercules wrote in here, was that he was too busy to do it....but he gave us unidb already, so that's fine :)

I just hope that someone or even hercules will fix this. In the meantime i will continue my work on this problem. I'll try with UniDB version 3.1.
:D

Nope, same with this version.

It will be better if u will post about your problems at this forum:
http://www.breamster.com/forums/index.php?showforum=13

Hm, strange thing but solved. I tried edited fifa.db database on another computer and it worked. So my system has been "little" smashed. :mrpimp:
I reinstalled it, and it works. Maybe it was collision with some software for fifa, and only God knows how many i installed to play with fifa files. I'll be more carefull in the future.

:dragan: :dragan: :dragan:

What is "fifasortorder" in table_teams in fifa.db

I dont think its too much important for tuning the teams. I think it's some kind of internal sorting in tournaments or leagues in menus because i dont see that any of these tables has indexes, so there must be some way for fifa 2005 to organize teams.
Maybe someone has more precise answer.
:D

eldad, there's no action in that forum! unfortunately.

I am not able to edit the "table_playerwrite" player names, "table_teamplayerlinks" player jersey numbers, "table_teamkits" kit fonts + colours,....
I am really only able to edit player skills.
Is this the limitation of UniDB, or is there another problem? What about everyone else?

As for as I know, there is no such limitation of UniDB. Probably You have some software collision.

Sorry, what I mean is that I CAN edit these tables w/in UniDB, but the changes are not shown in the game.

http://www.tucows.com/preview/195815.html

you can also do editing using the trial version of a program you can download here

Originally posted by pklimos
Sorry, what I mean is that I CAN edit these tables w/in UniDB, but the changes are not shown in the game.

That is very strange. Can You explain exactly what You did?

;)

hey folks, can someone explain me what's the logic of the numbers combined at the "jerseynumbercolor" field at "table_teamskits" on fifa.db?

Specifically what numbers?

Oh, I get it, it stands for number graphics in the zdata_xx. I will explain all of that when my tutorial comes out

Originally posted by boshko
That is very strange. Can You explain exactly what You did?

;)

Well let me kind of repeat:
First of all, you should know that I am fairly good with UniDB, I've been using it since last year when I used it to successfully edit Euro 2004. So I am not an expert, but I'm familiar with the program.

This year, I have been able to edit player skills, you know, like pace, shooting, tackling, etc... as well as accessories, facial hair, boot colour, etc...

However my problem is when I try to edit the "table_playerwrite" player names, "table_teamplayerlinks" player jersey numbers, "table_teamkits" kit fonts + colours,.... nothing happens in the game.

For example, I tried changing the Greece kit font to the correct one: 10 (adidas like France, Spain, Germany etc..) but it doesn't work for me.... You can try this yourself. In the kit font column, team ID 1338 (Greece) change it to the adidas font (10).
When I do it, and import the .db file of course, I don't see any changes in the game! Another thing that doesn't work is giving the players long sleeves (1 value)... I don't see the sleeves in the game.

Do you see what I'm saying here?

I have the same problem, I tyry to change Cannavaro's numbre from 29 to 28 and it doesn't appear in the game

I have that problem with changing player jersey numbers as well. Well I feel bad saying this, but I'm glad other people are having the same problem, just so I know I'm not the only one.
Hopefully we can find a solution.
Maybe Hercules can help.

Originally posted by pklimos
Well let me kind of repeat:
First of all, you should know that I am fairly good with UniDB, I've been using it since last year when I used it to successfully edit Euro 2004. So I am not an expert, but I'm familiar with the program.

This year, I have been able to edit player skills, you know, like pace, shooting, tackling, etc... as well as accessories, facial hair, boot colour, etc...

However my problem is when I try to edit the "table_playerwrite" player names, "table_teamplayerlinks" player jersey numbers, "table_teamkits" kit fonts + colours,.... nothing happens in the game.

For example, I tried changing the Greece kit font to the correct one: 10 (adidas like France, Spain, Germany etc..) but it doesn't work for me.... You can try this yourself. In the kit font column, team ID 1338 (Greece) change it to the adidas font (10).
When I do it, and import the .db file of course, I don't see any changes in the game! Another thing that doesn't work is giving the players long sleeves (1 value)... I don't see the sleeves in the game.

Do you see what I'm saying here?

Concerning the player jersey numbers in player_write. I would just erase the whole line. Then retype the info in a new line. See if that works.

I don't think kit font does anything, recheck and make sure that your data is change by opening and closing your program your using.

Another thing to try. When you go to the game. Restore you default rosters and see what happens!

Paul

hi poeple ; iam confused with the specificface id; i wanna add an specific face to a player that doenst have an specific face; i already imported the files to a zadta file; but now comes the assingment in this is were iam get confused; can some someone help me ; cause i want rafael marquez to have his own specific face.

Hey it work, I change a player number, and I also could change the color of my kits number and name of the players... I just follow Appelget advice of restore the default...
Thanks

I have imported a GK kit for Team ID 246 to zdata_10.big
in MS Access i have copied all the values from existing home or
away kit to GK kit and changed the color name and color number to 1 = white
i saved it imported from *.mdb back to fifa.db
in the game i see my imported kit,
but the color of the number hasn't changed it's still black = 2
and the name is white

Please help :(

Originally posted by Stranger
I have imported a GK kit for Team ID 246 to zdata_10.big
in MS Access i have copied all the values from existing home or
away kit to GK kit and changed the color name and color number to 1 = white
i saved it imported from *.mdb back to fifa.db
in the game i see my imported kit,
but the color of the number hasn't changed it's still black = 2
and the name is white

Please help :(

That's because in Fifa 2005, different from 2004 is that the numbers are actual graphics. So you have to change the column with the name "numbercolorid" and "shortsnumbercolorid" to get the color to change. You can still use the number "1" to get white numbers. But that is not the case with all colors.

Does anybody know how to bring the players from the reserves to the starting 11 with UniBD, for example Inzaghi= AC Milan

Thanks I'll really appreaciate some help.

i have a problem with unidb the new one and the old one .
i tried to use unidb to get the eng file but it won't work this is what it says:
Run-time error '-214217887 (80040e21)
The feild is too small to accept the amount of data you attempted to add . try inserting or pasting less data.

Vitu
in teamplayer links you have to change inzaghis position id (33) with someone else who is a 32

POSITIONS
0 Goalkeeper
1 Sweeper
2 Right Wing Back
3 Right Back
4 Right Centre Back
5 Centre Back
6 Left Centre Back
7 Left Back
8 Left Wing Back
9 Right Def. Midfield
10 Right Centre Def. Midfield
11 Centre Def. Midfield
12 Left Centre Def. Midfield
13 Left Def. Midfield
14 Right Wing Midfield
15 Right Midfield
16 Right Centre Midfield
17 Centre Midfield
18 Left Centre Midfield
19 Left Midfield
20 Left Wing Midfield
21 Right Att. Midfield
22 Right Centre Att. Midfield
23 Centre Att. Midfield
24 Left Centre Att. Midfield
25 Left Att. Midfield
26 Right Forward
27 Centre Forward
28 Left Forward
29 Right Striker
30 Striker
31 Left Striker
32 Substitute
>=33 Reserve

Originally posted by pklimos
Vitu
in teamplayer links you have to change inzaghis position id (33) with someone else who is a 32

POSITIONS
0 Goalkeeper
1 Sweeper
2 Right Wing Back
3 Right Back
4 Right Centre Back
5 Centre Back
6 Left Centre Back
7 Left Back
8 Left Wing Back
9 Right Def. Midfield
10 Right Centre Def. Midfield
11 Centre Def. Midfield
12 Left Centre Def. Midfield
13 Left Def. Midfield
14 Right Wing Midfield
15 Right Midfield
16 Right Centre Midfield
17 Centre Midfield
18 Left Centre Midfield
19 Left Midfield
20 Left Wing Midfield
21 Right Att. Midfield
22 Right Centre Att. Midfield
23 Centre Att. Midfield
24 Left Centre Att. Midfield
25 Left Att. Midfield
26 Right Forward
27 Centre Forward
28 Left Forward
29 Right Striker
30 Striker
31 Left Striker
32 Substitute
>=33 Reserve

Thank you so much m8;) I had alread figured this out yesterday but thank you for your support though. It took me a while to figure it out. Thank you once again.

Dang. I have a version of blueshell data guy that expires in 32 days! Anyone no of a place to get a free microsoft access style thingy? I have windows database but it doesn't work with UniDb.

Originally posted by Torontolynx
Dang. I have a version of blueshell data guy that expires in 32 days! Anyone no of a place to get a free microsoft access style thingy? I have windows database but it doesn't work with UniDb.

I don't think so, but full version of Blue Shell Data Guy is only $25

You don't have MS office lying around? If you have Word and Excel then surely you have Access.

Donovan I am little lost here... when you said "RESTORE YOUR ROSTERS" as a solution to the problem of changing number color and player number... How exactly can i do this???

I´m a newbie in fifa 2005 editing so please could you explain this to me.....

Originally posted by davidmende
Donovan I am little lost here... when you said "RESTORE YOUR ROSTERS" as a solution to the problem of changing number color and player number... How exactly can i do this???

I´m a newbie in fifa 2005 editing so please could you explain this to me.....


You do that when you are inside the game. in the My Fifa menu. at the bottom

Got this error trying to convert eng.db I assume this is where eng language files are to edit team names...Right?? Please help.

"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

this is old news.

..and the answer is?

Got this error trying to convert eng.db I assume this is where eng language files are to edit team names...Right?? Please help.

"The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data."

Update to the lastest UniDB. It will fix your problem

the unidb is a little wonky i find... try editing player first and last names a bit and you will run into big problems...

I have to agree with that, whenever I edit a player surname in player_writing table and insert a longer surname than there was before, then game crashes and no squad-list is shown. has anyone overcome this problem? :nape:

I have to agree with that, whenever I edit a player surname in player_writing table and insert a longer surname than there was before, then game crashes and no squad-list is shown. has anyone overcome this problem? :nape:

That's a weird problem. I don't no what to tell you. I've never had that problem. Make sure you have the most updated Unidb. You could just add new players, instead of replacing old ones, that's probably the easiest way to get around your problem.

Hi guys, i am very new to the editing of the game any more than installing kits using kitraptor boots and balls using other apps particulary written for the game. However, i notice that in the kitraptor there are teams like D.Kyiv but they don't have kits. How do i change this and how do i give the teams that don't have third kits third kits?

thanks hope some one can help

Well... Dynamo Kiev is not in the game at all, there are some teams in Kitraptor that are not in the game.

For the 3'd kit question its a bit complicatet but the solution is somewhere in the forum....

As for goalkeeper kits for teams that don't have them you can add it with Creation Centre and then afterwards add it with kitraptor if you want it in 2G format. Don't make too many changes with CC at a time... add a kit or two and then close and say yes to save and yes to run fathbuild... You do the same thing with 3'd kits but you have to activate it in another file for it to show up ingame.

If you can't find it i will try to explain...

Do anyone know where I can download the new version of UniDB for FIFA 2005, I can'ts eem to ind it anywhere, I have found it on Fifaecp, SSweetpatch MRA downloadboutique and at the Download center but all the links are either broken or I'm nothing getting the right version of the patch(in the ase of FIFAECP)?

Can some one help? :nape:

:sun: UniDB v3.2 (http://aru.nd4spdworld.com/ecp/UniDB-3-2-0.zip)

Great, thanks a lot :bouncy: