DB Editing Tutorials, Tips and Tricks

GONÇALO said:

Hi @bangus

I have two doubts.

1- I put specific adboards for the Brazilian league, in the stadiums that have fixed adboards it works well, but we who have dynamic adboards do not work, is there any way they work?

2- Is there any way I can prevent Brazilian teams from hiring players from outside the American continent, for example, less Asian or European?

thankful.

Click to expand...

You have to edit the transfer related files in the dlc removing the European and Asian areas.

regularcat said:

You have to edit the transfer related files in the dlc removing the European and Asian areas.

Click to expand...

Hi, can you explain to me which table is this part and where should I move?

Thanks!

GONÇALO said:

Hi, can you explain to me which table is this part and where should I move?

Thanks!

Click to expand...

It is located in the legacy files, look for transfer related files and search the FIFA 15 Forum.

regularcat said:

It is located in the legacy files, look for transfer related files and search the FIFA 15 Forum.

Click to expand...

Good Morning! I could not find anything on the forum, could you help me?

Is there any easier way to edit player's body types than having to convert the DB using Moddingway's tool, exporting, importing, re-converting, etc?.

Just my contribution.... i have some ideas for patch but without a proper tool i can't do so much.
By the way, my traits (team traits and player traits)
TEAMS TRAIT1

# 1 Impatient Board
# 2 Loyal Board
# 4 Squad Rotation
# 8 Consistent Layout
# 16 Switch wingers
# 32 Centreback Split
---------------------------------------------
# 64 Defend the Lead (*)
# 128 Keep Up Pressure (*)
----------------------------------------------
# 256 More attacking at home
--------------------------------------------------
# 512 Tac. Tiki taka (**)
# 1024 Tac. Short Passing (**)
# 2048 Tac. Counter Attack (**)
# 4096 Tac. Direct Attack (**)
# 8192 Tac. Normal Attack (**)
----------------------------------------------
# 16384 Tac. More Crosses (***)
# 32768 Tac. More Dribble (***)
-----------------------------------------------
# 65536 Tac. Medium Pressing (****)
# 131072 Tac. High Pressing (****)
# 262144 Tac. Very High Pressing (****)
# 524288 Tac. Contain (****)
#1048576 Tac. Normal Defending (****)

For each of team trait (vs weak, equal, strong)
(*) Set only one trait of the two
(**) && (****) Set only one trait of the five
(***) You can set them both
es. 2048 + 65536

There are three field with team traits: vs strong (vs strong team), vs equal and vs weak.
How them work:
My team has 77 overall. Opponentweakthreshold (check teams table) value is 4, opponentstrongthreshold value is 2.
Then if I play against a team of 80 overall my team use trait1vstrong because overall 79(77 + opponentstrongthresold=2) is the limit to use trait1vequal, if I play againt a team with 78 of overall my team use trait1vequal , if I play against 71 my team use trait1vweak set of traits.
PLAYERS TRAIT.
TRAIT 1
# 0 1 Inflexibility
# 1 2 Long Throw In
# 2 4 Powerful Free Kick
# 3 8 Diver
# 4 16 Injury Prone
# 5 32 Injury Free
# 6 64 Avoid to use the Weak foot
# 7 128 Dives Into Tackles
# 8 256 Tries To Beat Defensive Line
# 9 512 Selfish
#10 1024 Leadership
#11 2048 Argues With Referee
#12 4096 Early Crosser
#13 8192 Try Often Finesse Shot
#14 16384 Flair
#15 32768 Long Passer
#16 65536 Long shot taker
#17 131072 Speed Dribbler
#18 262144 Play Maker
#19 524288 Pushes Up for Corners
#20 1048576 GK Puncher
#21 2097152 GK Long Thrower
#22 4194304 Power Header
#23 8388608 GK One on One
#24 16777216 Giant Throwin
#25 33554432 OutSide Foot Shot
#26 67108864 Fans favourite
#27 134217728 Through Ball
#28 268435456 Second Wind
#29 536870912 Acrobatic Clearance
TRAIT2
# 1 2 Fancy Feet
# 2 4 Fancy Passes
# 3 8 Fancy Flicks
# 4 16 Stutter Penalty
# 5 32 Chipped Penalty
# 6 64 Bicycle Kicks
# 7 128 Driven Pass
# 8 256 GK Flat Kick
# 9 512 One Club Player
#10 1024 Team Player
#11 2048 Chip Shot
#12 4096 Technical Dribbler
#13 8192 GK Sweeper Keeper
#14 16384 Backs into player
#15 32768 Corner Specialist
#16 65536 Takes Finesse Free Kicks
#17 131072 Target Forward
#18 262144 Gk Cautions with Crosses
#19 524288 GK Comes for Crosses
#20 1048576 Blames Teammates
#21 2097152 GK Save with foot
#22 4194304 SetPiece Specialist
#23 8388608 Tornado Skillmove

bangus said:

Credits and thanks: to Moddingway for his fabulous FIFA Squads Files Converter tool and for sharing his db files; to Fidel for all the mods, files and editing tips he happily provides and shares; and to regularcat who helped mentor me years ago when I was a novice at all this.

-------

Important Update: Use Fidel's FIFA 18 Squads save file (link below) to create your FIFA 18 squads1 and squadsdefault files for Moddingway's Converter. Moddingway's db contains tables that currently cannot be edited/imported back into the Squads save file.

-------

First, a quick overview of the database (db) editing process. Links to all files mentioned here will be provided below.

Tools, programs and files used in this tutorial:
- Moddingway's FIFA Squads Files Converter tool
- Rinaldo's DB Master 15 tool
- Excel or a similar program
- squads save file
- db file
- db-meta.xml file

1. Start with any squads save file generated via the in-game save feature.
2. Extract the db file from the squads save file using Moddingway's Converter tool.
3. Add the db file to an empty folder containing the db-meta.xml file.
4. Use Rinaldo's DBM tool to open that folder and load the db tables into the DBM tool.

At this point, the db tables are visible in the DBM tool, and can be individually edited in the tool itself. This method though is both inefficient and unreliable. The best way to edit tables is to continue on and:

5. Use the Export function in the DBM tool to export the tables into an empty folder.
6. Open tables in Excel to edit.
7. Use the Import function in the DBM tool to import the edited tables back into the db.
8. Transfer the newly-edited db file back into the Converter tool folder.
9. Use the Converter tool to convert the db file back into the squads save file.
10. Transfer the newly-created squads save file into your game, and play.

Moddingway's Squads Files Converter tool was developed for FIFA 17. It will first need to be tweaked to use with FIFA 18. This is the process:

1. The Converter tool folder contains a squads1 file and a squadsdefault file. Both are 4,159 KB in size. These two FIFA 17 files need to be removed and replaced with two corresponding FIFA 18 files.

2. Place the FIFA 18 squads save file you plan to use on your desktop. Right-click and make a second copy of the same file. Re-name one of the files squads1, and the other squadsdefault.

3. Delete the FIFA 17 squads1 and squadsdefault files from the Moddingway Converter folder.

4. Transfer the newly-created FIFA 18 squads1 and squadsdefault files into the Moddingway Converter folder. Both should be 4,871 KB in size.

Moddingway's Squads Files Converter is now ready to be used with FIFA 18. Be aware you may have to use the Converter's Browse For Squad Save function to search for and load the new squads1 file you just created and placed into the folder.

Links and other info:

Moddingway's FIFA 17 Squads Files Converter, files and tutorial, plus Rinaldo's DB Master 15:

http://www.moddingway.com/news/6640.html

Moddingway's FIFA 18 db file and db-meta.xml file:

http://www.soccergaming.com/index.php?threads/fifa-18-database-exported.6459569/

Fidel's FIFA 18 Squads save file (original, unedited):

http://soccergaming.com/index.php?t...ve-worldwide-mods-tools.6459580/#post-6464478

WPS Office (Excel-similar program, free download):

https://www.wps.com

All squad file tables ready to edit (bogus 0 values removed):

http://www.mediafire.com/file/orifm02ao027x1q/all+tables+edited.7z

Squads save file location: Documents/FIFA 18/settings.

Click to expand...

whatever i do it doesn't wanna work
squad file is always damaged!!

Thiego-BR said:

Por favor Bangus faça uma dB com a liga Brasileira licenciada !? Se você quiser posso ajudar com ids de jogadores BRs

Click to expand...

am i suppose to do it for every table where i see the rows of 0 value???

How to add real face in to your manager in career mode??

Can someone give me a reminder regarding the traits?
De gea traits:
trait1: 3145728
trait2: 0

How it's being calculated\I can transform it into text with multiple of his traits? I remember there was some post about it but i couldn't find it.

bonitoass said:

Can someone give me a reminder regarding the traits?
De gea traits:
trait1: 3145728
trait2: 0

How it's being calculated\I can transform it into text with multiple of his traits? I remember there was some post about it but i couldn't find it.

Click to expand...

Look 4 posts above yours.

Do you guys have the Predator/Glitch boots?

There are a lot of EncryptedAssets in Frosty Editor.

Hello Guys,

I would like to ask for your help:

I would like to convert team from fifa 16 to fifa 18

Is this possible with those tool converter and cm 16 to 18 tool?

Thank you in advance,

Philip

hello, can someone tell me why not change the collar shape of the kits if it is already in the database.

When I try and create a squad file from a db file i get this error:

Can anyone please help?

msrajjc2 said:

When I try and create a squad file from a db file i get this error....

Can anyone please help?

Click to expand...

You need to follow this word for word. It's very clear.

tinpanalley said:

You need to follow this word for word. It's very clear.

Click to expand...

Thank you. I followed the steps, but I got the same error.

I did the following:

• Got my squads file: Squads20180224225720
• Used the tool to convert it into a .db file
• Using Frosty Editor, exported fifa_ng_db-meta.xml
• Opened DB master with the two above files
• Added a player (Andrei Arshavin)
• Saved the .db file into the converter tool's folder
• Opened the tool, loaded the .db file and clicked 'create squad file', and got:

EDIT: followed all instructions, created a 'squads1' and 'squadsdefault' file. Even when trying to 'create squad file' using ANY db file I get this error message:



Somebody please tell me what i'm doing wrong

It's a .db file how can there be no database to convert?!

msrajjc2 said:

Thank you. I followed the steps, but I got the same error.

I did the following:

• Got my squads file: Squads20180224225720
• Used the tool to convert it into a .db file
• Using Frosty Editor, exported fifa_ng_db-meta.xml
• Opened DB master with the two above files
• Added a player (Andrei Arshavin)
• Saved the .db file into the converter tool's folder
• Opened the tool, loaded the .db file and clicked 'create squad file', and got:

EDIT: followed all instructions, created a 'squads1' and 'squadsdefault' file. Even when trying to 'create squad file' using ANY db file I get this error message:

Somebody please tell me what i'm doing wrong

It's a .db file how can there be no database to convert?!

Click to expand...

Hey, so under "Browse for Squad File" you have selected a file that ends in ".db". This is not correct. You need to select the squad file that you extracted the original database from. So it looks like you should browse and select the "squads1" file. After that make sure the database you have edited and want to insert into the new squad file is also named "squads1(.db)". It seems the tool will look for the database file with the same name as the selected squad file.

dimDev said:

Hey, so under "Browse for Squad File" you have selected a file that ends in ".db". This is not correct. You need to select the squad file that you extracted the original database from. So it looks like you should browse and select the "squads1" file. After that make sure the database you have edited and want to insert into the new squad file is also named "squads1(.db)". It seems the tool will look for the database file with the same name as the selected squad file.

Click to expand...

To be fair, I've done this as well and with recent updates, I simply can not get the game to accept my edited squad files. Maybe it's because I'm still on update 2, who knows. So many variables.

msrajjc2 said:

Thank you. I followed the steps, but I got the same error.

Click to expand...

Did you ever manage to make this work?