DB Editing Tutorials, Tips and Tricks

[tinpanalley]

I've done it mate!... That may help you?

Hey, I'm glad you got your solution. Doesn't really change anything with my process though. All I'm doing is going in and changing the team worth and transfer budget down to '10' each in the teams table and then making players have contracts until 2030 in the players table. Nothing else. It makes no sense that my file ends up not working.

 

[sonaldo]

Hey, I'm glad you got your solution. Doesn't really change anything with my process though. All I'm doing is going in and changing the team worth and transfer budget down to '10' each in the teams table and then making players have contracts until 2030 in the players table. Nothing else. It makes no sense that my file ends up not working.

Aw that's a shame.

Do try using dogfoo's squad file though because whatever he's done means that it doesn't come out 'damaged' when you try and load it.

See if you can make your edits to his file and it may be ok?

 

[tinpanalley]

Aw that's a shame.
Do try using dogfoo's squad file though because whatever he's done means that it doesn't come out 'damaged' when you try and load it.
See if you can make your edits to his file and it may be ok?

I'm gonna give it a go. What I don't like about that file is that I don't want legends included at the expense of EA squad update players being replaced, if that's what it is. The only reason I do all this is to minimise transfers by killing budgets. But ultimately the game still finds a loop hole (too smart for its own good) and teams just start loaning people all over the place instead. Only good thing about that is that it's always insignificant players.

I had a theory that something in the squad file is (perhaps even in a non-visible way) tied to title updates. And since I'm still only on title update 2, that could be causing problems. But then you were having the same issue. Had my edits in December not worked, I'd have simply thought it wasn't possible. But is did work back then. So, while it's not likely that it's tied to title updates, one thing that IS possible is that EA went in and added some other non-visible element that breaks beyond repair the moment you open and modify a db from a squad file. Maybe we need some new xml for squad files now? I wish we could find out how that xml for squad files was created in the first place, would be interesting to see if a new one were made today if it would be the same as the one we're all using.

 

[Chuny]

After edits, using SquadsConverter to recreate the squad file may sometimes give an error ingame if not done well.One simple methode to avoid that, is to export the database from frosty editor, make the changes using DB Master, reimport the database in frosty then launch the game using frosty. If you didn't make an error in your edits it should work.

To edit the database to add a new player for example "Arshavin",
1- open your db with DB Master,
2- go to "player" table
3- Copy the line of a player who is similar to arshavin.
4- paste it in a new line.
5- Change the "playerid" to the one you want as instance 147777 for arshavin
6- Go to "teamplayerlinks" table
7- Copy the last line
8- paste it in a new line
9- Change the "artificialkey" to the number following the artificialkey of the line you copied (for instance if the artificial key of the previous was 19445 then you put 19446)
10- Change the "playerid" like in point 5-
11- Change the "teamid" to the one you want to transfer your player (for example 111592 for free agents)
12- Go to "editplayersname" table
13- put in a new line the playerid of your player, his firstname, surname, jerseyname,...
14- Save
15- Reimport the database in frosty editor launch the game and enjoy!

Hey!
I came into this thread looking for answers because this is pretty much the same method I'm using.

The only difference is, I'm using Frosty Editor to export the DB, then use DB Master to Export the STADIUMS table, then I use Excel to edit what I want, save the file, re-import the table back with DB Master, save the changes. Use Frosty Editor to re-import the DB files and then finally EXPORT the pack for Frosty Mod Manager. Then load it in FMM, launch the game... but the changes don't appear to have any effect ingame!??

Haven't tried to launch the game directly from Frosty Editor though, because that'd stop me from using all the other mods I have in FMM!

Any ideas why?.

 

[madkoala]

Hi Bangus, thank you for your tutorial.
I have two problems in BANDO80 patch (143 classic players have been added), which is different situation from your previous tutorial.

1. Everthing about Gerrard is correct except he is silhouette player in squad, I want to add photo to him.
2. Steven Gerrard ONLY in the game, not with the other 142 players.

Because he and some other classic players already have their player ID but no photo(anyway I have already processed his 128x128 photo by other tools), I cannot just switch the id with others?
What can I do to solve these two problems above?

 

[bonitoass]

Is there a way to open .big files?

 

[kilay]

Hi to all, i'm new on this forum but i have a little experence on modding (in the past two year i modded pes), now i'm trying to use CM 16 to edit my db but i have some issues , i readed a lot of theads about that but probably i'm missing something.

My purpose is convert my squad file (already edited in the game) in a DB ,open it with CM 16, edit and then reimport it in my game...

Using FIFA 17 Squad Converter i managed how convert my squad in a db, but i'm not able to open it with CM 16,, for me isn't clear what are the steps to convert the DB in the right CM16 format and all this folder with the same name just create confusion.

have i to export all the tables from mine DB (converted with FIFA 17 converter) and then reimport them inside the DB that i found in CM16 files (16_DB.db)?
Or are there some tools that already do that?

Thnks in advance

EDIT: NEVERMIND i did it

 

[JohnnySTRSSN]

Hey guys. Need some help I've searched as well as I possibly could and came up with nothing. I'm trying to replace the balls for epl, carabao cup, fa cup and champions cup.with my own designs but don't know which ball I.D is for which ball. Any help?

 

[regularcat]

Hey guys. Need some help I've searched as well as I possibly could and came up with nothing. I'm trying to replace the balls for epl, carabao cup, fa cup and champions cup.with my own designs but don't know which ball I.D is for which ball. Any help?

Teams table in the database will tell you.

 

[bangus]

All the links in post #1 are still active, just tested them. Downloaded all files, set up the converter, edited the squads file, and it worked perfectly in-game (I have the latest updated version). Took about 7 minutes. Moddingway's converter method IMO is still the best and least headache-inducing method, as I hear Frosty ends up broken every time there's an EA game update.

 

[henC]

Thank you so much for the thread. I am new to the DB editing and it helps a lot. I do have a question here: is it possible to create more than 30 players using DBMaster? I can't find any ways to break the maximum limit.

 

[bangus]

Thank you so much for the thread. I am new to the DB editing and it helps a lot. I do have a question here: is it possible to create more than 30 players using DBMaster? I can't find any ways to break the maximum limit.

Thanks. Yes, you can create and add hundreds or even thousands of players using this method. Example: open the players table using a docs program like Excel. Copy any number of players' particulars and paste/add them to the bottom of the players table. Give them their own unique id and that's it... dozens or hundreds of new players now added to the game. There's more work to it of course because you also have to change their names/stats etc, plus add them to the teamplayerlinks table so they show up in-game. But it's basically that simple and quick.

 

[henC]

Thanks. Yes, you can create and add hundreds or even thousands of players using this method. Example: open the players table using a docs program like Excel. Copy any number of players' particulars and paste/add them to the bottom of the players table. Give them their own unique id and that's it... dozens or hundreds of new players now added to the game. There's more work to it of course because you also have to change their names/stats etc, plus add them to the teamplayerlinks table so they show up in-game. But it's basically that simple and quick.

Thanks for the reply! Do you mean copy other player's data in players table and teamplayerlinks and then change the playerid and artificial key to a new and unique one in order to create new player(wondering if we can create a new playerid for the new player), and after that just change the names, data, and create faces using the method mention in previous page? I kind of tried it just now but it looks like all the players' names, datas are all mess up, make me wondering is it just I am doing it wrong or is it because I don't get your point. Thanks for the help

 

[bangus]

Thanks for the reply! Do you mean copy other player's data in players table and teamplayerlinks and then change the playerid and artificial key to a new and unique one in order to create new player(wondering if we can create a new playerid for the new player)

Yes, and yes you have to give each player his own id, in both tables. I can help you thru the steps if you like, and I'd suggest you start by creating/adding just one player so it's less confusing.

 

[bangus]

Also, Fidel fixed rinaldo's CM16 editor to work with FIFA 18. Very important tool if you want to make it much easier to edit new unique players:

http://www.soccergaming.com/index.p...dwide-mods-tools.6459580/page-44#post-6481084

 

[henC]

Yes, and yes you have to give each player his own id, in both tables. I can help you thru the steps if you like, and I'd suggest you start by creating/adding just one player so it's less confusing.

sorry for the trouble, could you please give me some detailed instructions if you have time? So I try again to add a new player into the squad. I copy Marco Van Basten's data in players table(I am using bando80's squad), paste it to the bottom of players table, and then change the playid to the last playerid in the table+1. Then I go to the teamplayerlinks table, copy the last player's data, change the playerid to the new id I create, change the artificialkey to the last artificialkey in the table+1 and change the teamid to 241Barcelona. After that I go to editplayernames and give the player a new name(say Tom Fenny). So when I test the new squad, the name of the new player does show in Barcelona, but the squad is all messed up. All the players' name, position, country, face, etc. are been reassigned and all changed. Still wondering which of my steps are wrong. Really appreciate your help, thanks!

 

[bangus]

So when I test the new squad, the name of the new player does show in Barcelona, but the squad is all messed up.

All your steps sound correct, good for you for figuring that all out especially if you're new to this.

Guessing here, but the messed up player info could have to do with a simple error when sorting columns. Example: when I sort the teamplayerlinks table using WPS spreadsheet, I click on the player id column. When I do that, an alert box pops up and asks if I want to expand the selection, or continue with current selection. I have to choose the expand the selection option in order to prevent the other players' particulars from getting all mixed up.

 

[henC]

All your steps sound correct, good for you for figuring that all out especially if you're new to this.

Guessing here, but the messed up player info could have to do with a simple error when sorting columns. Example: when I sort the teamplayerlinks table using WPS spreadsheet, I click on the player id column. When I do that, an alert box pops up and asks if I want to expand the selection, or continue with current selection. I have to choose the expand the selection option in order to prevent the other players' particulars from getting all mixed up.

That's indeed the reason for the mess up. Thank you very much! I am really grateful.
And I am guessing in order to create more than 30 new players I should create new playerids, assign one of the created face to the new idea just like the method in previous page, and instead of delete the original created player, I can just re-edit the original created player's face and data to create a new player. In that way I create a new player using my new playid and the face I've already created and reedit the original to a new one, therefore making 31 created players instead of 30. Just wondering if I am right? I am worry it may cause some error to the squad file since in the createplayer table there are also artificialkeys and if I use my way the artificialkeys would be doubled, although the it seems like the artificialkeys doesn't have to be unique in that table.Maybe I should change the artificial key to a unique one as well? Thanks

 

[bangus]

I am worry it may cause some error to the squad file since in the createplayer table there are also artificialkeys and if I use my way the artificialkeys would be doubled, although the it seems like the artificialkeys doesn't have to be unique in that table.Maybe I should change the artificial key to a unique one as well? Thanks

Glad it's working now.

Every player in the game must have their own player id and artificial key. When I assign new player ids, I start with 70000, 70001, 70002, etc. because I know no EA-created players have ids in the 70000s. You can do the same with artificial keys. Check to see the highest artificial key that EA used, then assign your new players all higher numbers. The thing with the artificial keys is there might be a limit to how high they can go, I don't know, so watch for that.

You can create and add hundreds of players to the game using this method, you're not limited to 30 or 31. I don't understand what you are trying to do when you say "deleting original players" etc. so you will have to explain that. Do you want to use their mini-photos for your new players, is that it?

 

[henC]

Glad it's working now.

Every player in the game must have their own player id and artificial key. When I assign new player ids, I start with 70000, 70001, 70002, etc. because I know no EA-created players have ids in the 70000s. You can do the same with artificial keys. Check to see the highest artificial key that EA used, then assign your new players all higher numbers. The thing with the artificial keys is there might be a limit to how high they can go, I don't know, so watch for that.

You can create and add hundreds of players to the game using this method, you're not limited to 30 or 31. I don't understand what you are trying to do when you say "deleting original players" etc. so you will have to explain that. Do you want to use their mini-photos for your new players, is that it?

It's just a method shown in previous page, I was a little confused and not sure if my way was right but I think I get it now. Thanks for your help!