1. We have just migrated to Xenforo forum platform. Few things to remember:
    - You will need to reset your password in order to login. Reset your pass here: Click here. Be sure to check SPAM folder!
    - Avatars were not migrated. You will need to upload your new avatar

    Regards,
    Soccer Gaming Admin

DB Editing Tutorials, Tips and Tricks

Discussion in 'FIFA 18 Forum' started by bangus, Oct 19, 2017.

  1. tinpanalley

    tinpanalley Youth Team

    Joined:
    May 15, 2012
    Messages:
    353
    Likes Received:
    41
    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.
     
  2. msrajjc2

    msrajjc2 Club Supporter

    Joined:
    Nov 4, 2015
    Messages:
    192
    Likes Received:
    75
    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?
     
  3. tinpanalley

    tinpanalley Youth Team

    Joined:
    May 15, 2012
    Messages:
    353
    Likes Received:
    41
    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.
     
    Last edited: Mar 4, 2018
  4. ::..Federico Debla..::

    ::..Federico Debla..:: Fan Favourite

    Joined:
    Oct 23, 2001
    Messages:
    5,210
    Likes Received:
    81
    Location:
    Kingston, Jamaica-Buenos Aires, Argentina
    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?.
     
  5. madkoala

    madkoala Club Supporter

    Joined:
    Apr 28, 2018
    Messages:
    1
    Likes Received:
    0
    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?
     
  6. bonitoass

    bonitoass Club Supporter

    Joined:
    Aug 20, 2016
    Messages:
    9
    Likes Received:
    0
    Is there a way to open .big files?
     
  7. kilay

    kilay Club Supporter

    Joined:
    May 2, 2018
    Messages:
    13
    Likes Received:
    5
    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
     
    Last edited: May 3, 2018
  8. JohnnySTRSSN

    JohnnySTRSSN Club Supporter

    Joined:
    Apr 6, 2018
    Messages:
    14
    Likes Received:
    4
    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?
     
  9. regularcat

    regularcat Manager Moderator

    Joined:
    Jun 11, 2008
    Messages:
    13,022
    Likes Received:
    203
    Teams table in the database will tell you.
     
  10. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  11. henC

    henC Club Supporter

    Joined:
    May 21, 2018
    Messages:
    7
    Likes Received:
    0
    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.
     
  12. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  13. henC

    henC Club Supporter

    Joined:
    May 21, 2018
    Messages:
    7
    Likes Received:
    0
    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
     
  14. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  15. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    Last edited: May 21, 2018
  16. henC

    henC Club Supporter

    Joined:
    May 21, 2018
    Messages:
    7
    Likes Received:
    0
    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!
     
  17. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  18. henC

    henC Club Supporter

    Joined:
    May 21, 2018
    Messages:
    7
    Likes Received:
    0
    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
     
    Last edited: May 21, 2018
  19. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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?
     
  20. henC

    henC Club Supporter

    Joined:
    May 21, 2018
    Messages:
    7
    Likes Received:
    0
    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!
     
      

Share This Page