DB Editing Tutorials, Tips and Tricks

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

  1. henC

    henC Club Supporter

    Joined:
    May 21, 2018
    Messages:
    7
    Likes Received:
    0
    Hi sorry to interrupt again. Would you mind giving me some step-by-step instructions in create more new players?
    I am now clear about add playerids and artificial keys thanks to your help. However, I still can't figure out how to add more new players. Even after I add new playerids it still won't allow me to create more than 30 players.
    So I try to copy all my created players data in createplayer table, paste it and change the playerid to the new id I created. my original thought was doubling the created players, but assign them in different playerids, then I can edit the faces, names, etc. while entering the game. When I enter the game it did word for a while, I can edit player's face and names. But when I close the game and reopen it, not only I can't edit the faces, but also all the created players' faces, no matter they are the 30 players I created before or the other players I use the data copying to create, are all become default normal face. I think my way doesn't work.
    Sorry to interrupt, but as you say there is a way to add and create new players to the game, so I am hoping to get some help from your way and instructions to add/create new players. Thanks!
     
  2. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
    I never use the createplayer table, I only add new players to the players table. Yes, when you add players this way, you cannot edit faces using the in-game editor, you can only edit their position, kit and stats. To edit their faces, you need rinaldo's CM 16 tool that Fidel fixed to work with FIFA 18:

    http://www.soccergaming.com/index.php?threads/doctor-productions-18-exclusive-worldwide-mods-tools.6459580/page-44#post-648108

    Or you can change their faces, hair, hair color, etc. by manually editing headtypecode, hairstylecode, haircolorcode, etc. in the spreadsheet columns.
     
    Last edited: May 22, 2018
  3. henC

    henC Club Supporter

    Joined:
    May 21, 2018
    Messages:
    7
    Likes Received:
    0
    Thanks for the reply! I give up the CM tool for now since I am just new for editing games, CM seems a little bit too difficult for me.
    Somethings weird happen with my fifa though. After I finished edit my db, I went to the game and changed shoes in game for one of the player. I then load another squad and when I tried to load the edited squad back the game just crushs. I even tried a edited and "clean" squad that was edited by DB from moddingway and the same problem still happened. does it have anything to do with my fifa18 because it is the cracked version?
     
  4. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
    The #1 reason an edited squad save will crash the game has to do with the bogus 0 value issue. Read the first part of my post #2.

    I uploaded squad save tables that are ready edit, with all bogus 0 values removed. Try it, edit one set of shoes only, then go in-game to see if it loads and works:

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

    As for cracked versions, I have no idea if squad save editing works or doesn't work, or why.
     
    Last edited: May 24, 2018
  5. tinpanalley

    tinpanalley Youth Team

    Joined:
    May 15, 2012
    Messages:
    562
    Likes Received:
    91
    I have to be careful here because I don't want to sound like I'm in any way facilitating cracks but just so you understand, when you have a cracked version, you have that game as released with one specific update version. If you then use ANY tool, mod, patch, squad file, etc etc etc that was created on a later version of the game, the chances are extremely high that fundamental files of the game have been altered enough by EA that make your edits crash. Sure, EA needs to do updates for different things but like consoles a major benefit of version updates is locking out people with earlier cracks from doing too much with the game. I have followed @bangus and others' instructions for modifying tables and other things and modified lots of tables for fun that people don't even talk about here. I promise you, if an edit isn't working and you're following the instructions 100% perfectly, your cracked version is the reason and I would suggest you probably don't bring it up again.
     
    marillo likes this.
  6. Fernanditus23

    Fernanditus23 Club Supporter

    Joined:
    May 8, 2013
    Messages:
    165
    Likes Received:
    37
    What are the markers / overlays of Russia 2018? I want to insert them as default scoreboards for friendly matches and custom tournaments. Thank you
     
  7. Dhanush

    Dhanush Club Supporter

    Joined:
    Jun 9, 2018
    Messages:
    17
    Likes Received:
    2
    Can we edit the youth scouting countries in career mode
     
  8. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
  9. msrajjc2

    msrajjc2 Club Supporter

    Joined:
    Nov 4, 2015
    Messages:
    207
    Likes Received:
    81
    @bangus (this may be a stupid question so please forgive if so but) is it possible to use Shawminator's tool to create players, rather than having to convert files with the ModdingWay tool? i could never get it to work (squad files were always corrupted). i managed to find a workaround: downloading an existing edited squad file online (dogfoo's) and making my changes to that. however, if there was a way of using Shawminator's tool that would be ideal i'd think

    thanks
     
  10. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
  11. msrajjc2

    msrajjc2 Club Supporter

    Joined:
    Nov 4, 2015
    Messages:
    207
    Likes Received:
    81
  12. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
    I can help you if you ever want to try this method again. I uploaded a file a few months ago with all tables fixed (post #1), that's what I use. Zero issues with corrupted saves after that, and it literally takes me seconds to create a player using WPS.

    File Explorer has a CM 16 component which makes editing players easier, so that's a definite plus. But Fidel also modded one that works with this method, that's what I have used on occasion.
     
  13. tinpanalley

    tinpanalley Youth Team

    Joined:
    May 15, 2012
    Messages:
    562
    Likes Received:
    91
    I myself have been trying to see if I can use the new File Explorer to do the same edits to the squad files we were doing before. But I just can't figure it out yet.
     
  14. msrajjc2

    msrajjc2 Club Supporter

    Joined:
    Nov 4, 2015
    Messages:
    207
    Likes Received:
    81
    thanks v much. haven't got my PC set up yet (too much work on) but will do soon and may well be asking for your help :)

    @tinpanalley i've not even downloaded shawminator's program yet but will do soon when i get some more time. let me know if you get anywhere
     
  15. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
    I'm actually using File Explorer now, very easy tool to use, and you can access all db tables (dozens more tables).
     
  16. msrajjc2

    msrajjc2 Club Supporter

    Joined:
    Nov 4, 2015
    Messages:
    207
    Likes Received:
    81
    ok great. can you access squads files via shawminator's tool?

    the squad tables are separate to the db tables no? so if you make changes in the latter, they won't show if you use a squad file which is not 'default squads'?
     
  17. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
    You use the tool to edit the db files with CM, or to export the db files for editing in DBM.
    Yes, even though I have made edits to the game db files using File Explorer, I am still able to use my modded squads save from two months ago; just load the squads save, done. And any non-db graphics modding I've done to the game files using File Explorer, show up in my game when using my modded squads save from two months ago.
     
    Last edited: Jun 17, 2018
  18. tinpanalley

    tinpanalley Youth Team

    Joined:
    May 15, 2012
    Messages:
    562
    Likes Received:
    91
    I'd love to know where you open them if you figure it out.
     
  19. msrajjc2

    msrajjc2 Club Supporter

    Joined:
    Nov 4, 2015
    Messages:
    207
    Likes Received:
    81
    thanks for the reply although i'm not sure i understand.

    i've used DBM to add a player (Arshavin) to the latest squads, making him a free agent

    so what i do (as you describe in your OP) is load up fifa and then load that edited squad file, which effectively 'overwrites' the default db squad file

    you cannot use shawminator's tool for this?
     
  20. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,101
    Likes Received:
    479
    You can use FE for that, yes. I was simply explaining that I can still load/use my older modded squad saves, even though I've started editing the default game db files with FE.
     
      

Share This Page