DB Editing Tutorials, Tips and Tricks

[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?

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!

 

[bangus]

So I try to copy all my created players data in createplayer table... when I close the game and reopen it, not only I can't edit the faces, but also all the created players' faces

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.

 

[henC]

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.

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?

 

[bangus]

I then load another squad and when I tried to load the edited squad back the game just crushs.

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.

 

[tinpanalley]

does it have anything to do with my fifa18 because it is the cracked version?

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.

 

[Fernanditus23]

What are the markers / overlays of Russia 2018? I want to insert them as default scoreboards for friendly matches and custom tournaments. Thank you

 

[Dhanush]

Can we edit the youth scouting countries in career mode

 

[bangus]

Can we edit the youth scouting countries in career mode

Not with this editor. Ask here:

http://www.soccergaming.com/index.php?threads/fifa-18-career-mod.6464164/

 

[sonaldo]

@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

 

[bangus]

is it possible to use Shawminator's tool to create players, rather than having to convert files with the ModdingWay tool?

I don't know, but I assume you can. I tried his tool for five minutes. But there's nothing I need to edit so I didn't explore it more than that.

 

[sonaldo]

I don't know, but I assume you can. I tried his tool for five minutes. But there's nothing I need to edit so I didn't explore it more than that.

i'll do some experimenting when i find some time. thanks!

 

[bangus]

i'll do some experimenting when i find some time. thanks!

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.

 

[tinpanalley]

i'll do some experimenting when i find some time. thanks!

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.

 

[sonaldo]

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.

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

 

[bangus]

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

I'm actually using File Explorer now, very easy tool to use, and you can access all db tables (dozens more tables).

 

[sonaldo]

I'm actually using File Explorer now, very easy tool to use, and you can access all db tables (dozens more tables).

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'?

 

[bangus]

ok great. can you access squads files via shawminator's tool?

You use the tool to edit the db files with CM, or to export the db files for editing in DBM.

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'?

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.

 

[tinpanalley]

ok great. can you access squads files via shawminator's tool?

I'd love to know where you open them if you figure it out.

 

[sonaldo]

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.

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?

 

[bangus]

you cannot use shawminator's tool for this?

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.