DB Conversion FIFA 23 to FIFA 07

[EfekanP]

Hi everyone,

I am trying to convert FIFA 23 DB to FIFA 07.

This is a player example (Joe Cole) of FIFA 07.

{
    "acceleration": "87",
    "accessorycolor1": "1",
    "accessorycolor2": "3",
    "accessorycolor3": "1",
    "accessorycolor4": "1",
    "accessorycolor5": "1",
    "accessoryid1": "4",
    "accessoryid2": "8",
    "accessoryid3": "0",
    "accessoryid4": "0",
    "accessoryid5": "0",
    "adaptability": "0",
    "aggression": "76",
    "ambition": "0",
    "assetid": "27",
    "ballcontrol": "89",
    "birthdate": "145757",
    "bodysizecode": "2",
    "celebration": "0",
    "crossing": "82",
    "developmentstylecode": "3",
    "developmenttypecode": "1",
    "dribbling": "91",
    "facetypeid": "4",
    "facialhairstyleid": "1",
    "fansfavourite": "1",
    "finishing": "74",
    "firstname": "Joe",
    "flexibility": "0",
    "freekicks": "82",
    "gkdiving": "8",
    "gkpositioning": "12",
    "haircolorid": "2",
    "hairtypeid": "16",
    "handling": "11",
    "heading": "49",
    "height": "175",
    "highclubidentification": "0",
    "hightrainingworkrate": "0",
    "inflexible": "0",
    "injuryprone": "0",
    "internationalreputation": "4",
    "leadership": "68",
    "learningspeed": "4",
    "legtypeid": "5",
    "longpassing": "68",
    "longshotaccuracy": "81",
    "lowclubidentification": "0",
    "lowmedhairtypeid": "5",
    "lowtrainingworkrate": "0",
    "marking": "56",
    "mediadarling": "0",
    "nationality": "14",
    "originalname": "1",
    "playercomposure": "82",
    "playerid": "27",
    "playingstyle": "12",
    "potential": "93",
    "preferredfoot": "0",
    "preferredposition1": "19",
    "reactions": "87",
    "reflexes": "6",
    "retirementage": "33",
    "scandalprone": "0",
    "shoecolor": "46",
    "shortpassing": "87",
    "shotpower": "74",
    "sleevelength": "0",
    "sprintspeed": "83",
    "stamina": "86",
    "strength": "72",
    "surname": "Cole",
    "tackling": "64",
    "weakfootability": "3",
    "weight": "70",
    "wouldnotsignfor": "0",
    "wouldsignfor": "5"
}

This is a player example (Joe Cole) of FIFA 23:

{
    "acceleration": "89",
    "accessorycode1": "0",
    "accessorycode2": "0",
    "accessorycode3": "0",
    "accessorycode4": "0",
    "accessorycolourcode1": "0",
    "accessorycolourcode2": "0",
    "accessorycolourcode3": "0",
    "accessorycolourcode4": "0",
    "aggression": "64",
    "agility": "90",
    "animfreekickstartposcode": "0",
    "animpenaltiesstartposcode": "0",
    "attackingworkrate": "2",
    "avatarpomid": "0",
    "balance": "87",
    "ballcontrol": "91",
    "birthdate": 139913,
    "bodytypecode": "8",
    "commonnameid": "0",
    "composure": "83",
    "contractvaliduntil": "2027",
    "crossing": "87",
    "curve": "87",
    "defensiveawareness": "55",
    "defensiveworkrate": "0",
    "defspe": "51",
    "dribbling": "92",
    "driref": "90",
    "emotion": "3",
    "eyebrowcode": "0",
    "eyecolorcode": "2",
    "faceposerpreset": "4",
    "facialhaircolorcode": "3",
    "facialhairtypecode": "0",
    "finishing": "85",
    "finishingcode1": "0",
    "finishingcode2": "0",
    "firstname": "Joe",
    "firstnameid": "16441",
    "freekickaccuracy": "86",
    "gender": "0",
    "gkdiving": "9",
    "gkglovetypecode": "0",
    "gkhandling": "6",
    "gkkicking": "13",
    "gkkickstyle": "0",
    "gkpositioning": "16",
    "gkreflexes": "7",
    "gksavetype": "0",
    "haircolorcode": "3",
    "hairstylecode": "0",
    "hairtypecode": "19",
    "hashighqualityhead": "1",
    "hasseasonaljersey": "0",
    "headassetid": "27",
    "headclasscode": "0",
    "headingaccuracy": "59",
    "headtypecode": "3",
    "headvariation": "0",
    "height": "176",
    "interceptions": "52",
    "internationalrep": "3",
    "iscustomized": "0",
    "isretiring": "0",
    "jerseyfit": "0",
    "jerseysleevelengthcode": "0",
    "jerseystylecode": "0",
    "jumping": "79",
    "lastnameid": "6972",
    "longpassing": "76",
    "longshots": "87",
    "modifier": "0",
    "nationality": "14",
    "overallrating": "87",
    "pacdiv": "88",
    "paskic": "86",
    "penalties": "73",
    "personality": "4",
    "phypos": "72",
    "playerid": "27",
    "playerjerseynameid": "15443",
    "playerjointeamdate": "160273",
    "positioning": "80",
    "potential": "87",
    "preferredfoot": "1",
    "preferredposition1": "23",
    "preferredposition2": "27",
    "preferredposition3": "18",
    "preferredposition4": "-1",
    "reactions": "81",
    "runningcode1": "0",
    "runningcode2": "0",
    "runstylecode": "0",
    "shoecolorcode1": "15",
    "shoecolorcode2": "21",
    "shoedesigncode": "0",
    "shoetypecode": "1",
    "shohan": "84",
    "shortpassing": "87",
    "shortstyle": "0",
    "shotpower": "81",
    "sideburnscode": "0",
    "skillmoves": "3",
    "skillmoveslikelihood": "3",
    "skintonecode": "3",
    "skintypecode": "0",
    "slidingtackle": "41",
    "smallsidedshoetypecode": "501",
    "socklengthcode": "0",
    "sprintspeed": "87",
    "stamina": "82",
    "standingtackle": "46",
    "strength": "69",
    "surname": "Cole",
    "tattooback": "0",
    "tattoofront": "0",
    "tattoohead": "0",
    "tattooleftarm": "0",
    "tattooleftleg": "0",
    "tattoorightarm": "0",
    "tattoorightleg": "0",
    "trait1": "67240448",
    "trait2": "0",
    "usercaneditname": "0",
    "vision": "89",
    "volleys": "82",
    "weakfootabilitytypecode": "4",
    "weight": "73"
}

and I am trying to match the fields. Basic fields are the same but there are a lot of fields that do not exist in FIFA 23. Also, the fields that are related to accessories, face, hair and etc. can take different values.

My conversion matrix:

{
   
{
    "acceleration": "same",
    "accessorycolor1": "accessorycolourcode1? can be 0 I guess",
    "accessorycolor2": "accessorycolourcode2? can be 0 I guess",
    "accessorycolor3": "accessorycolourcode3? can be 0 I guess",
    "accessorycolor4": "accessorycolourcode4? can be 0 I guess",
    "accessorycolor5": "not exist, i will use 0",
    "accessoryid1": "accessorycode1? can be 0 I guess",
    "accessoryid2": "accessorycode2? can be 0 I guess",
    "accessoryid3": "accessorycode3? can be 0 I guess",
    "accessoryid4": "accessorycode4? can be 0 I guess",
    "accessoryid5": "not exist, i will use 0",
    "adaptability": "? takes 0 or 1",
    "aggression": "same",
    "ambition": "? takes 0 or 1",
    "assetid": "same with playerid",
    "ballcontrol": "same",
    "birthdate": "calculated",
    "bodysizecode": "bodytypecode?",
    "celebration": "? can be 0 I guess",
    "crossing": "same",
    "developmentstylecode": "?",
    "developmenttypecode": "?",
    "dribbling": "same",
    "facetypeid": "headtypecode?",
    "facialhairstyleid": "facialhairtypecode?",
    "fansfavourite": "? takes 0 or 1",
    "finishing": "same",
    "firstname": "retrieved",
    "flexibility": "? takes 0 or 1",
    "freekicks": "?",
    "gkdiving": "same",
    "gkpositioning": "same",
    "haircolorid": "haircolorcode?",
    "hairtypeid": "hairtypecode?",
    "handling": "gkhandling",
    "heading": "headingaccuracy",
    "height": "same",
    "highclubidentification": "? takes 0 or 1",
    "hightrainingworkrate": "? takes 0 or 1",
    "inflexible": "? takes 0 or 1",
    "injuryprone": "? takes 0 or 1",
    "internationalreputation": "internationalrep",
    "leadership": "? takes int 20-99",
    "learningspeed": "? takes int 1-5",
    "legtypeid": "?",
    "longpassing": "same",
    "longshotaccuracy": "longshots",
    "lowclubidentification": "? takes 0 or 1",
    "lowmedhairtypeid": "?",
    "lowtrainingworkrate": "? takes 0 or 1",
    "marking": "defensiveawareness? can be use",
    "mediadarling": "? takes 0 or 1",
    "nationality": "same",
    "originalname": "1",
    "playercomposure": "? takes int 1-99",
    "playerid": "same",
    "playingstyle": "? takes int 0-13",
    "potential": "same",
    "preferredfoot": "same",
    "preferredposition1": "same",
    "reactions": "same",
    "reflexes": "gkreflexes",
    "retirementage": "?",
    "scandalprone": "? takes 0 or 1",
    "shoecolor": "shoecolorcode1?",
    "shortpassing": "same",
    "shotpower": "same",
    "sleevelength": "? takes 0 or 1",
    "sprintspeed": "same",
    "stamina": "same",
    "strength": "same",
    "surname": "retrieved",
    "tackling": "standingtackle",
    "weakfootability": "weakfootabilitytypecode? FIFA07:0-4, FIFA23:1-5 can be use",
    "weight": "same",
    "wouldnotsignfor": "? can be 0",
    "wouldsignfor": "? can be 0"
}
}

I put a question mark on problematic fields. Do you have any idea what I can do? If I can not find any solution I will just randomise them.

 

[EfekanP]

I managed the convert several tables from FIFA 23 Oct 1, 2022 DB to FIFA 07.
Progress:

• players, teams, teamplayerlinks, jerseynames, teamwrite tables updated.

• If a player has a commonname, I use it as a surname. If not, I use firstname and surname.
• Birth dates are calculated as (birthdate - 16 years) because we can not change the start of FIFA 07.
• Positions are converted. (RW-> RWM, LW-> LWM, rest of the positions are the same.)
• FIFA 07 has a 30-player limit for a team. I could not link more than 30 players. But I kept a log of them.
• Young players were added from FIFA 07 original database.

Issues:

• Trying to ignore women's teams.
• Trying to fix generic players. (There could be a manual solution.)
• Some characters can not be represented in the game. (I don't know what can I do?)
• FIFA 07 has a colors table but FIFA 23 has R, G, and B fields in the team table. (I will work on it.)
• Formations are problematic. I will try to convert them too.
• I am trying to find FIFA 23 generic faces and hair to match with FIFA 07 values.

WIP:

• leagues, teamleaguelinks tables.
• Players, leagues, and teams that are not in FIFA 23 but are shown in older FIFA games.

Sample squads gallery:

http://imgur.com/a/SYVhQpT

 

[EfekanP]

In-Game Screenshots:

Faces by Dmitri
Kits from my other work.

http://imgur.com/a/5GDV3Ty

http://imgur.com/a/P8P7q3k

http://imgur.com/a/ZZ4bQnL

http://imgur.com/a/DRDcnPA

http://imgur.com/a/gEJgvOZ

 

[EfekanP]

http://imgur.com/a/LNhsV2h

http://imgur.com/a/qC0NB3q

http://imgur.com/a/vYewRRb

http://imgur.com/a/GLMsffB

 

[EfekanP]

http://imgur.com/a/VppXuOG

http://imgur.com/a/RWRvCNo

 

[Dmitri]

FIFA 07 has a colors table but FIFA 23 has R, G, and B fields in the team table. (I will work on it.)

There are 2 options:
You can compare FIFA 23 RGB color with those which are stored in your table, and find the most similar one. For comparing colors, something like this can be used:

How to compare two colors for similarity/difference

I want to design a program that can help me assess between 5 pre-defined colors which one is more similar to a variable color, and with what percentage. The thing is that I don't know how to do that

stackoverflow.com

Or you can try to completely redefine the table with colors and put all colors which you need there. However, this may require additional changes in the exe in case if new IDs won't fit the space which is allocated for them in exe.

If a player has a commonname, I use it as a surname. If not, I use firstname and surname.

Yes that's the correct way.

FIFA 07 has a 30-player limit for a team. I could not link more than 30 players. But I kept a log of them.

I think you shouldn't use such high numbers. Better check which is the max squad size in original database and use it. I think it was something between 22 and 25, can't remember the exact value.

Some characters can not be represented in the game. (I don't know what can I do?)

Find them and replace?

 

[EfekanP]

Find them and replace?

I do not know if I can find all the characters that can not be represented in FIFA 07. I realized one of them when I was checking the players randomly.

Alexandru Cicaldau - https://sofifa.com/player/243001

There are 2 options:
You can compare FIFA 23 RGB color with those which are stored in your table, and find the most similar one. For comparing colors, something like this can be used:

How to compare two colors for similarity/difference

I want to design a program that can help me assess between 5 pre-defined colors which one is more similar to a variable color, and with what percentage. The thing is that I don't know how to do that

stackoverflow.com

Or you can try to completely redefine the table with colors and put all colors which you need there. However, this may require additional changes in the exe in case if new IDs won't fit the space which is allocated for them in exe.

One of the ideas in my mind is to classify the colors rather than creating all of them with RGB values, maybe I could create limited colors, and then I will just select the nearest colors that I created.

I think you shouldn't use such high numbers. Better check which is the max squad size in original database and use it. I think it was something between 22 and 25, can't remember the exact value.

I will check it.

 

[EfekanP]

@Dmitri I have some other questions for you.

1. There are some irrelevant areas like tape on the player's left knee when I use your faces. What are those? Did you do them intentionally?

2. Is there any possibility to use sub-folders with FIFA 07 Asset Loader like the GTA 3-VC-SA Modloader? I tried but not working.

GTAGarage.com » Mod Loader » View Screenshot

www.gtagarage.com

3. Is there an easier way to convert FSHs to BIG files? I am also converting the minifaces and minikits but it is hard to import all of them one by one. Maybe you could add this feature to the Asset Loader?

4. Are you making the faces that you publish in Comunidad FIFA 07 - 08 Facebook group with the technique that you published before or is there any easy way to convert those faces?

 

[Dmitri]

There are some irrelevant areas like tape on the player's left knee when I use your faces. What are those? Did you do them intentionally?

These faces are not compatible with HD body model. They use original body texture.

Is there any possibility to use sub-folders with FIFA 07 Asset Loader like the GTA 3-VC-SA Modloader? I tried but not working.

No, it's not possible.

Is there an easier way to convert FSHs to BIG files? I am also converting the minifaces and minikits but it is hard to import all of them one by one. Maybe you could add this feature to the Asset Loader?

You can add gui files to subfolders, they have higher priority than files in .big.

Are you making the faces that you publish in Comunidad FIFA 07 - 08 Facebook group with the technique that you published before or is there any easy way to convert those faces?

I'm using a set of my own tools to make it faster.

 

[EfekanP]

You can add gui files to subfolders, they have higher priority than files in .big.

I put all FSH files in/data/gui/assets/heads folder next to .big file but it did not work.

A fsh file only includes a 1.png file. I created them with OTools-0175. I don't know if is it relevant or not but when I unpack the fsh file with OTools-0175, I am seeing a file named "1" without an extension.

If you wanna check, I am publishing Lionel Messi (158023):

Minifaces - Google Drive

drive.google.com

 

[Dmitri]

You also need to put your fsh into big. 1 image - 1 fsh - 1 big. Then this big must be placed in data/gui/... folder.
The name "1 " is correct.

 

[EfekanP]

You also need to put your fsh into big. 1 image - 1 fsh - 1 big. Then this big must be placed in data/gui/... folder.
The name "1 " is correct.

Then I am asking my previous question again, Is there a way to put fsh files to big files one by one.
Or can I put all fsh files to a single big file?

 

[Dmitri]

I don't know because I'm not that experienced in using available tools. There are many different .big editors and maybe in one of them such thing is possible.
I always write my own tools for such tasks.

 

[Plaza]

Then I am asking my previous question again, Is there a way to put fsh files to big files one by one.
Or can I put all fsh files to a single big file?

I use to import massive faces using File Master 08 and it works. Create a new .big file and search into the tool, (File Master) them import your .fsh´s and regenerate.

 

[EfekanP]

I use to import massive faces using File Master 08 and it works. Create a new .big file and search into the tool, (File Master) them import your .fsh´s and regenerate.

I am currently not dealing with faces. I am talking about minifaces. The problem is putting .fsh files into .big files should be automatic.

You also need to put your fsh into big. 1 image - 1 fsh - 1 big. Then this big must be placed in data/gui/... folder.
The name "1 " is correct.

I found how to put fsh files into big files but I am searching for .o, .const, and .apt files.

Also, there could be an issue with OTools. If I import the .fsh file created by using OTools, the miniface seems weird.

But when I put the image file itself, it seems like this:

There are some differences between the sizes of both .big files and .fsh files. (BIG files are created with the scenarios that I mentioned above.)

 

[Dmitri]

It could be a problem with Creation Master. Does it work well in the game?

 

[EfekanP]

It could be a problem with Creation Master. Does it work well in the game?

Not much but there are some slight quality issues in some areas.

 

[EfekanP]

Not much but there are some slight quality issues in some areas.

To understand the differences you need to zoom in.

 

[Dmitri]

Try to build fsh with -fshFormat rgb -fshLevels 1

 

[EfekanP]

Try to build fsh with -fshFormat rgb -fshLevels 1

Now seems okay. Thanks for your help. I am also working on logos and banners, should I need to use the same command line arguments for them? Also, what is the main problem with this issue to understand clearly?