• 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 Editing Tutorials, Tips and Tricks

eldon7

Youth Team
You've been here for years, so hardly a noob lol. I see in your other posts you already know about the new tools; Frosty tutorial in the FIFA 18 forum.
i did found it on youtube but i asked here about that to see if somewhere someone has every step on how to use that tool in text format also but anyways,i'll take the risk.
you think it''ll be safe to install fifa 18(skidrow steampunk) without removing skiwrow fifa 16?
 

bangus

Starting XI
how to use that tool in text format
The Frosty db editing process is identical to the one described here in post #1. Export the db files from the game files, export the tables from the db files and edit in Excel, import the edited tables back into the db files, and then import the db files back into the game files.
 

bangus

Starting XI
Does that work during a Manager Career if you want to manually make a transfer between two teams you don't control?
Test it out and post your results. I don't play career mode so could you explain how you were able to accomplish this in past FIFAs.
 
Last edited:

tinpanalley

Youth Team
Test it out and post your results. I don't play career mode so could you explain how you were able to accomplish this in past FIFAs.
It doesn't work. People who know managing career files better than me have told me it doesn't work. I have a vague recollection of being able to do this in FIFA 15 or earlier but I think it was in tournament mode.
 

bangus

Starting XI
I have a vague recollection of being able to do this in FIFA 15 or earlier
Using rinaldo's IM tool, yes. Fidel created and still creates mods that allow for career mode player editing, but I don't know about transfers as I have never used those mods.
 

tinpanalley

Youth Team
I did some Frosty edits of cmsettings and transfers and I was surprised that everything worked well, as I had hoped. Unfortunately, the moment I exit out of the career save and reload it, the game crashes. Every time. I've tried everything. I tried removing the edits one by one, nothing works. I have the latest Frosty Editor and I'm on title update 2. Don't know what else to try.
 

bangus

Starting XI
I did some Frosty edits of cmsettings and transfers and I was surprised that everything worked well, as I had hoped. Unfortunately, the moment I exit out of the career save and reload it, the game crashes. Every time. I've tried everything. I tried removing the edits one by one, nothing works. I have the latest Frosty Editor and I'm on title update 2. Don't know what else to try.
That's the problem with editing things like cm files, it can break the game, check theawesomegem's cm thread, people are finding serious bugs as they play it.

FYI, if you have edited team info using the in-game editor (formations, tactics), and then export tables to further edit the db, it can corrupt your save. Whereas editing players and making transfers using the in-game editor, doesn't corrupt the file. In case that applies.
 
Last edited:

Sami 1999

Reserve Team
While DB editing is great, I think the idea of editing the Squad file is important too.

You know, when you edit your DB directly, you can't play online anymore. But if you edit Squad files, you will be able to play online since Online modes just ignores your Squad files.


Now, we have been able to enter legend players using Squad file. So does that mean if we can import a specific face with an specific ID [Lets for example take a New ID like 50009 which isn't assigned to any players] and then enter that ID to create a player using the Squad file, will the player show up in game? Or he won't be available in game since his ID doesn't exist on the real DB?

Also @bangus do you know how many IDs Ronaldo Nazario have? We all know one of his ID is 37576. But he has 3 faces now. If you use Frosty Editor to view his 37576 ID face, you will see that he has only 1 face inside that ID of 37576.

Where are the other 2 faces? What ID are they using? How can I find them? I extracted the DB from Fidel's Squad file but I don't think I can find out players ID from there.
 

bangus

Starting XI
Also @bangus do you know how many IDs Ronaldo Nazario have? We all know one of his ID is 37576. But he has 3 faces now. If you use Frosty Editor to view his 37576 ID face, you will see that he has only 1 face inside that ID of 37576.
There is no player with that ID in my game so I can't help you. There are 8 different db/meta files that can be exported in Frosty, whoever you are looking for may be in one or more of those DBs.
 

Sami 1999

Reserve Team
There is no player with that ID in my game so I can't help you. There are 8 different db/meta files that can be exported in Frosty, whoever you are looking for may be in one or more of those DBs.
I see, I will take a look at it.
 

bangus

Starting XI
What ID are they using? How can I find them?
I doubt they are in the main ng.db files. But if you want to find possible duplicates of players using different IDs, one way is to locate the player's first/last name ID, then sort the columns and look for players with the identical first/last name IDs.
 

tinpanalley

Youth Team
FYI, if you have edited team info using the in-game editor (formations, tactics), and then export tables to further edit the db, it can corrupt your save. Whereas editing players and making transfers using the in-game editor, doesn't corrupt the file. In case that applies.
I haven't done anything to the squad file. I only tried editing transfers.ini to stop transfers from happening. That's all I want is to completely stop them. I tried editing the squad file using DBMaster to prolong contracts and lower transfer budgets but that didn't work for me either for some reason.
 

bangus

Starting XI
I tried editing the squad file using DBMaster to prolong contracts and lower transfer budgets but that didn't work for me either for some reason.
What do you mean "that didn't work"? Do you mean your edits didn't show up in-game? If so, that would indicate the mod is not launching, and there are a few different reasons why that happens.
 

tinpanalley

Youth Team
What do you mean "that didn't work"? Do you mean your edits didn't show up in-game? If so, that would indicate the mod is not launching, and there are a few different reasons why that happens.
Well, you know, you tried to help me through using DBMaster to edit the xml and db files, and removing all the zero values etc etc. And I never got that to work for editing contract years and transfer budgets. So then I went back to editing just the inis in the dlc folder like I did with 16. Is it possible to do the previous db edits you were helping me with but with Frosty instead of DBMaster and squad file converter?
 

bangus

Starting XI
Is it possible to do the previous db edits you were helping me with but with Frosty instead of DBMaster and squad file converter?
The Frosty editor allows you to edit all tables, including the tables with contract years and transfer budgets, and the career mode tables, so the answer is yes.
 

tinpanalley

Youth Team
The Frosty editor allows you to edit all tables, including the tables with contract years and transfer budgets, and the career mode tables, so the answer is yes.
The Frosty Editor doesn't appear to have the ability to do anything other than import/export.

This is what I did... I tried to test by myself instead of just asking you.
Frosty - Export fifa_ng_db.db and fifa_ng_db-meta.xml
DBMaster - open that exported DB and export players and teams tables
Excel - edit those tables and reimport them to DBMaster and resave
Frosty - reimport the edited DB and XML

It doesn't appear to have made any changes to the team budgets or player contracts though. Looking at that what do you think I did wrong?
 


Top