• This is a reminder of 3 IMPORTANT RULES:

    1- External self-promotion websites or apps are NOT allowed here, like Discord/Twitter/Patreon/etc.

    2- Do NOT post in other languages. English-only.

    3- Crack/Warez/Piracy talk is NOT allowed.

    Breaking any of the above rules will result in your messages being deleted and you will be banned upon repetition.

    Please, stop by this thread SoccerGaming Forum Rules And Guidelines and make sure you read and understand our policies.

    Thank you!

DB Conversion FIFA 23 to FIFA 07

Dmitri

Reserves
Use these settings for GUI textures.
By default otools uses compressed texture format (dxt1 or dxt5). This is suitable for 3D things, but for 2D (GUI) it's better to use uncompressed textures. rgb is uncompressed 32-bit format. There's also rgb16 if you want to use 16-bit colors.
Also, there's no need in mipmap levels in 2D, so only one level must be saved.
 

FIFA07 Editor

Club Supporter
"bodysizecode": "bodytypecode?",
My body type conversion is as follows:
ID FIFA 20 : ID FIFA 07
1 Average and Lean 1 Small
2 Average and Normal 2 Normal
3 Average and Stocky 3 Big
4 Tall and Lean 1 Small
5 Tall and Normal 2 Normal
6 Tall and Stocky 3 Big
7 Short and Lean 1 Small
8 Short and Normal 2 Normal
9 Short and Stocky 3 Big
10 Lionel Messi 2 Normal
11 Very Tall and Lean 1 Small
You can also use: 0 = very small and 4 = very big.
The rest is a specific body type for the player, eg ID 10 is for Messi... The conversion must be manual or random.
"developmentstylecode": "?",
My conversion is based on the difference between overall and potential:
If the difference is 20+: Random between 4 and 5.
If the difference is 10+: Random between 2 and 3.
If the difference is 0+: Random between 1 and 2.

"developmenttypecode": "?",
My conversion is based on the difference between overall and potential:
If the difference is 20+: Random between 1 and 2.
If the difference is 0+: Random between 2 and 3.

"facialhairstyleid": "facialhairtypecode?",
My body type conversion is as follows:
ID FF20 ID FF07
0 None 1 None
1 Chin beard 6 Long Beard
2 Chin strap 4 Short Beard
3 Goatee 2 Goatee
4 Medium Beard 4
5 Moustache 3 Moustache
6 Stubble 4
7 Tuft 5 Pointed Beard
8 ? 1
9 ? 1
10 ? 1
11 ? 1
12 ? 1
13 ? 1
14 ? 1
15 ? 1
16 ? 1
17 ? 1
18 ? 1
20 ? 1
28 ? 1


"freekicks": "?",
Is "freekickaccuracy".

"haircolorid": "haircolorcode?",
ID FF20 ID FF07
0 Blonde 4 Blonde
1 Black 1 Black
2 Dark Blonde 4
3 Dark Brown 2 Dark Brown
4 Light Blonde 7 Light Blonde
5 Light Brown 3 Light Brown
6 Brown 2
7 Red 5 Red
8 White 7
9 Grey 6 Grey
12 Green 1
13 Violet 5

"leadership": "? takes int 20-99",
My conversion is based on "personality":
If = 5, Random between 87 and 95.
If = 4, Random between 76 and 86.
If = 3, Random between 67 and 75.
If = 2, Random between 56 and 66.
If = 1, Random between 20 and 55.

"playercomposure": "? takes int 1-99",
Is "composure".

"playingstyle": "? takes int 0-13",
My conversion is based on "preferredposition1 FF07":
0 GK.
1 Any attacking player.
2 ST, CF, RF or LF.
3 LF, RF, ST, CF or CAM.
4 CAM, RF, LF, ST or CF.
5 CAM, RWM, LWM, RM, LM or CM.
6 CDM or CM.
7 CDM, CM, RWM, RM, LWM or LM.
8 CB, CDM, CM, RB or LB.
9 No Exist.
10 CB, RB or LB.
11 RWB, RB, LB or LWB.
12 RM, RWM, LWM, LM, LF or RF.


I'm sorry for my English.
I'm Argentine... I used google translate.
 

EfekanP

Club Supporter
Thanks for the info bro. But I could not understand the following one. What is "playingstyle" and why did you associate it with positions?

My conversion is based on "preferredposition1 FF07":
0 GK.
1 Any attacking player.
2 ST, CF, RF or LF.
3 LF, RF, ST, CF or CAM.
4 CAM, RF, LF, ST or CF.
5 CAM, RWM, LWM, RM, LM or CM.
6 CDM or CM.
7 CDM, CM, RWM, RM, LWM or LM.
8 CB, CDM, CM, RB or LB.
9 No Exist.
10 CB, RB or LB.
11 RWB, RB, LB or LWB.
12 RM, RWM, LWM, LM, LF or RF.
 

FIFA07 Editor

Club Supporter
Thanks for the info bro. But I could not understand the following one. What is "playingstyle" and why did you associate it with positions?
These are the play styles:
0 = Shot Stopper
1 = Target Man/Key piece?
2 = Clinical Striker
3 = Counter-Attacker
4 = Dribbler
5 = Midfield Master
6 = Defensive Midfielder
7 = Box to box/Versatile
8 = Ball Winner
9 = Sweeper/Libero
10 = Stopper
11 = Wing Backs
12 = Attacking Winger
They are very individual, but doing it manually is very difficult, there are thousands of players.

Based on the playstyles I randomly calculate as follows:

GK = 0
Any attacking player = 1
ST/CF = 2, 3 or 4
LF/RF = 12, 3, 4 or 2
CAM = 5 or 4
LWM/RWM = 12 or 5
LM/RM = 5, 12 or 6
CM = 5, 6, 7 or 8
CDM = 6, 8 or 7
LWB/RWB = 11
LB/RB = 11, 8 or 10
CB = 10, 8 or 11


If anyone else has any suggestions to improve the calculation, it is very helpful, thanks.
 

EfekanP

Club Supporter
These are the play styles:
0 = Shot Stopper
1 = Target Man/Key piece?
2 = Clinical Striker
3 = Counter-Attacker
4 = Dribbler
5 = Midfield Master
6 = Defensive Midfielder
7 = Box to box/Versatile
8 = Ball Winner
9 = Sweeper/Libero
10 = Stopper
11 = Wing Backs
12 = Attacking Winger
They are very individual, but doing it manually is very difficult, there are thousands of players.

Based on the playstyles I randomly calculate as follows:

GK = 0
Any attacking player = 1
ST/CF = 2, 3 or 4
LF/RF = 12, 3, 4 or 2
CAM = 5 or 4
LWM/RWM = 12 or 5
LM/RM = 5, 12 or 6
CM = 5, 6, 7 or 8
CDM = 6, 8 or 7
LWB/RWB = 11
LB/RB = 11, 8 or 10
CB = 10, 8 or 11


If anyone else has any suggestions to improve the calculation, it is very helpful, thanks.
Thanks for the explanation. I will check FIFA 23 DB again. If any other value can be helpful or not.
 

Kwando101

Club Supporter
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:
Share the DB
 

Kwando101

Club Supporter
Please send me the fifa 07 updated db.file if u have
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:
 


Top