DB Editing Tutorials, Tips and Tricks

bangus · Oct 22, 2017

pedrito799 said:
Thanks Bangus, Maybe the Liveropool has this problem because has this trait : 128 - KEEP UP PRESSURE

I removed all traits; I removed all the vs-weaker, vs-equal, vs-stronger values; I edited 3 different tables and got rid of them all. Liverpool stills plays a noticeably higher pressure game than other teams.

The problem is these cheat boost codes are deeply embedded in the core game coding and we can't do anything about that. It's always been my #1 issue with FIFA, the way EA has hard-coded these cheats in. The degree of pressure even changes depending on whether the CPU team is playing you at home or away. You might set it up so CPU teams play a realistic game in their home games. But then they come into your stadium, and pressure like crazy and run around like lunatics.

pedrito799 · Oct 22, 2017

bangus said:
I removed all traits; I removed all the vs-weaker, vs-equal, vs-stronger values; I edited 3 different tables and got rid of them all. Liverpool stills plays a noticeably higher pressure game than other teams.

The problem is these cheat boost codes are deeply embedded in the core game coding and we can't do anything about that. It's always been my #1 issue with FIFA, the way EA has hard-coded these cheats in. The degree of pressure even changes depending on whether the CPU team is playing you at home or away. You might set it up so CPU teams play a realistic game in their home games. But then they come into your stadium, and pressure like crazy and run around like lunatics.

That sadly read that.

I was sure if already you knew it. My Hope was take off it and so we can control the GP, who know if a day we can decode the game to 100%

pedrito799 · Oct 23, 2017

Hi Bangus,

I have an idea,but I think it is more easy when we have more tools for fifa 18 or 17 ( if you are playing 17's) The moddingway in fifa 16 and preview did create new teams as for example the teams for the champions league. My idea it is : We Delete ,for example,liverpool and we create a new liverpool whit same players ,same colors,same budget etc.So maybe the new liverpool has not codes and script

.... What do you think?

dogfood09 · Oct 23, 2017

Great job bangus.

It's my understanding that when you export a table, it needs to be imported with the columns in the correct order as exported? I want to edit the database with excel but I find the columns annoying and time consuming to edit. What I would like is to have all the player details together , followed by all the attributes and then everything else. And then imported back in the order I've edited. Can this be done? Apologies as I'm new to editing and a novice in excel .

bangus · Oct 23, 2017

dogfood09 said:
Great job bangus.

It's my understanding that when you export a table, it needs to be imported with the columns in the correct order as exported? I want to edit the database with excel but I find the columns annoying and time consuming to edit. What I would like is to have all the player details together , followed by all the attributes and then everything else. And then imported back in the order I've edited. Can this be done? Apologies as I'm new to editing and a novice in excel .

Thanks. Columns have to be in original order when importing. What I do each year is create an Excel template with all values/columns listed in alphabetical order. I have that open side by side with my table and use it for easy reference. Open the players table for example, then open a new blank sheet beside it. Copy/paste the column headers from the players table, into the new sheet along with the row ID. That way you don't have to type it all out by hand, it's much quicker. When done, sort in alphabetical order, then save as a template file and it will open each time with your list A-Z.

bangus · Oct 23, 2017

pedrito799 said:
we create a new liverpool whit same players ,same colors,same budget etc.So maybe the new liverpool has not codes and script .... What do you think?

The boost coding is probably linked to the team ID, yes. Creating teams though is too much work for me. I play tournaments only and avoid using the big teams. I play against lower teams that don't have the cheat boost coding, there are a number of teams that don't have it.

dogfood09 · Oct 23, 2017

bangus said:
Thanks. Columns have to be in original order when importing. What I do each year is create an Excel template with all values/columns listed in alphabetical order. I have that open side by side with my table and use it for easy reference. Open the players table for example, then open a new blank sheet beside it. Copy/paste the column headers from the players table, into the new sheet along with the row ID. That way you don't have to type it all out by hand, it's much quicker. When done, sort in alphabetical order, then save as a template file and it will open each time with your list A-Z.

Thanks, I shall try That, I'm guessing I could also hide all the columns I don't plan on editing too?

bangus · Oct 23, 2017

dogfood09 said:
Thanks, I shall try That, I'm guessing I could also hide all the columns I don't plan on editing too?

Is there a Hide Column function? Nice.

Just tried it out, great tip.

Hey I wonder if you can create a template with columns already hidden, I will try that.

Yes the template opens with previously selected columns already hidden, then saves as a usable table. Excellent tip, I'll add that to the top of the thread, thanks. Perfect for editing player ability values only in the players table as you said.

sonaldo · Oct 23, 2017

Thanks so much bangus this is incredibly helpful!

I wonder if there is a way to assign photos/commentary IDs to youth scouted (generated) players?

bangus · Oct 23, 2017

msrajjc2 said:
I wonder if there is a way to assign photos/commentary IDs to youth scouted (generated) players?

Thanks. Career commentary editing was possible up to FIFA 16 when Rinaldo's Internal Master tool worked with pre-Frostbite FIFA. Don't know now though. One option for commentary, for extreme career geeks, would be to edit the career commentary table (career_lastnames) so it only generates last names that have an active commentary assignment.

bangus · Oct 23, 2017

SAHKnight said:
Thanks for all your tips and tutorial bangus. I have one question : do you know what are the limits of entry that we can put in the 3 tables (players, editplayernames and teamlinksplayer)?

You are welcome. The min-max parameters for all the values in the various tables can be viewed in DBM, top toolbar.

itskn · Oct 24, 2017

how do you edit player names? i can't see player name table when i export db

StevenChen · Oct 24, 2017

I successfully created the FIFA18 squad file.
Chile and Brazilian league teams, two league I created 28 teams of real players (the remaining two new teams).
And I added four Chinese teams. These are the same as FIFA17.
Now there are some players in Chile and Brazil League name is wrong, I have not finished editing yet.

But I encountered another problem. I add a new team in the rest of the world where the game can search for players. But the team did not show it. Can not use this new team to play. For example: Tevez in China Shanghai team, you can search for Tevez.

I do not know how to continue, how to solve this problem

Game screenshots：

http://www.mediafire.com/view/9e4c928bez...190912.png

http://www.mediafire.com/view/985kjfcxbx...190617.png

http://www.mediafire.com/view/m34y9rvzix...190920.png

http://www.mediafire.com/view/4xh13c0x3o...191420.png

my db files：
http://www.mediafire.com/file/mjnsa67txx...4001611.db

Squads files：

http://www.mediafire.com/file/0cs05gesur...Squads1111

bangus · Oct 24, 2017

itskn said:
how do you edit player names? i can't see player name table when i export db

Moddingway's db contains the playernames table. Link is in the first post.

StevenChen · Oct 24, 2017

StevenChen said:
I successfully created the FIFA18 squad file.
Chile and Brazilian league teams, two league I created 28 teams of real players (the remaining two new teams).
And I added four Chinese teams. These are the same as FIFA17.
Now there are some players in Chile and Brazil League name is wrong, I have not finished editing yet.

But I encountered another problem. I add a new team in the rest of the world where the game can search for players. But the team did not show it. Can not use this new team to play. For example: Tevez in China Shanghai team, you can search for Tevez.

I do not know how to continue, how to solve this problem

Game screenshots：

http://www.mediafire.com/view/9e4c928bez...190912.png

http://www.mediafire.com/view/985kjfcxbx...190617.png

http://www.mediafire.com/view/m34y9rvzix...190920.png

http://www.mediafire.com/view/4xh13c0x3o...191420.png

my db files：
http://www.mediafire.com/file/mjnsa67txx...4001611.db

Squads files：

http://www.mediafire.com/file/0cs05gesur...Squads1111

@bangus Is it the default_teamsheets problem? Look at the picture, the bottom four lines are my added team. playerid seems to be incorrect, probably when I copied it, did not check it clearly
http://www.mediafire.com/view/2apgk027j387oyb/QQ图片20171024155701.png

bangus · Oct 24, 2017

StevenChen said:
Now there are some players in Chile and Brazil League name is wrong.

Many player names IDs are different in FIFA 18 than in FIFA 17. Check the playernames table for updated ID codes.

As for the rest, this is a general "How to edit the DB" tutorial thread. It's not a thread to discuss how to add teams, or create new leagues. Please ask your questions in the Editing forum, plus you'd get more answers from people who know how to do that. I don't know, so I can't help you, sorry.

StevenChen · Oct 24, 2017

bangus said:
Many player names IDs are different in FIFA 18 than in FIFA 17. Check the playernames table for updated ID codes.

As for the rest, this is a general "How to edit the DB" tutorial thread. It's not a thread to discuss how to add teams, or create new leagues. Please ask your questions in the Editing forum, plus you'd get more answers from people who know how to do that. I don't know, so I can't help you, sorry.

OK.anyway, thank you.

bangus · Oct 24, 2017

StevenChen said:
@bangus Is it the default_teamsheets problem?

There several tables that all have to be edited correctly. That's why it's impossible to know. Thanks.

bangus · Oct 24, 2017

SAHKnight said:
I wanted to know about the maximum number of entry that we can put in the tables. As i saw for example benbiggis said he had some issue for his mod because his table "reached the limits".

And last, please have you some link for the id of the different columns (shoetypecode, hairtypecode,...)?

I do not know what the limits are. DBM shows you can add new player IDs up to 300000. So there's one. And I don't have those IDs; if they aren't listed on the forum, or can't be viewed in Creation Master 16, you have to find them yourself via trial and error. In the past I have done this: create 11 new players and make them your starting 11. Give them playerids starting at ID 250000 so when you sort the players table, they are all at the top together and it's easy to edit them all. To check hair color IDs: give one player hair color 0, the next hair color 1, the next hair color 2, etc.

bangus · Oct 24, 2017

To anyone posting, please read and take note of the important updates to this thread, top of the first post on page 1. Thanks.

DB Editing Tutorials, Tips and Tricks

Starting XI

Club Supporter

Club Supporter

Club Supporter

Starting XI

Starting XI

Club Supporter

Starting XI

Club Supporter

Starting XI

Starting XI

Club Supporter

Club Supporter

Starting XI

Club Supporter

Starting XI

Club Supporter

Starting XI

Starting XI

Starting XI