R scripts to update your fifa 16 database and to install faces to your game

Papinho81

Reserves
Hi everyone!

I will use this thread to share my scripts written in the R language (similar to C language) that will allow updating your fifa 16 database using as a source squad files exported from fifa 19.

To be able to execute those scripts you will need the free R statistical software which is very easy to find and to install.

1) Players.txt updater

The first script I am sharing will allows you updating the players.txt table from your database using as a source any fifa 19 squad file.
It does not replace the players.txt file from your database but only update the stats and info of the players of your database that are also in the fifa 19 squad file (updating by matching player ids). Players from your db that are not present in the squadfile will remain untouched.
Also, only columns from the players.txt table that are 100% compatible between fifa 16 and fifa 19 are updated (56 columns in total, the list is provided inside the script).

To go throughout the process of updating the players tables you will need this R script and couple of others tools such as DB Master and notepad (not provided inside the package) but also FIFA17SquadFilesConverter (included insie the package).
The package comes with a readme file that will provide you all the instructions to go through the updating process.

Also if you are not familiar with R or programming, the read me file will guide you to install and open the script. Once the script open, all you will have to do is clicking on some windos popping up.

This is the link toward this first database editing scripts package, the player.txt updater package:



2) Face files Installer:

Description:
http://soccergaming.com/index.php?t...-fifa-16-database.6466212/page-3#post-6537445


Link toward the face installer script:


Face Installer Tutorial Video:



Probably more to come soon...



upload_2019-1-15_18-35-13.png
 
Last edited:

Papinho81

Reserves
Not sure anyone is really interested by these scripts... but I have updated the player.txt updater package, the link in the OP has been updated.

What are the changes? Now if you select the compute overall option, if a player has a higher computed overall than its potential, its potential is set equal to its computed overall. I noticed that players with higher overall than their potential tended to loose attributes quite quickly.

For example the computed overall for Messi using fifa19 attributes is 96 (the computation formula is the same than inside cm16) while its potential in fifa 19 is 94. Without that correction in my script, Messi was loosing attributes a bit too quickly.
 
Last edited:

Papinho81

Reserves
I finished a script that allows updating the playerid of players from your database with no EA ids (ie created player by someone) with the current EA playerids if the player is now part of fifa19 database (or anyother database actually from which you can export the players.txt table).

For exemple, I am using as a base moddingway patch 28.04 (the last version I think) that comes with the chinese super league. But the CSL was made by Ariel and co before it was released by EA in fifa 19. So, moddingway playerid for player from the CSL are different from the actual EA fifa 19 playerid (do you still follow me?). My script allows updating the playerid of all those players (not only CSL players) in all the tables of your database and also gives you the option to automatically rename all the graphic files (faces, mini faces, ect...) and lua files.
The script gives your several options: 1) get report in the form of tables readable with xls, 2) report + automatic update of your db files and game files.

Why does it matter to update your playerid in your DB? Well, if you want to use the players.txt updater I posted in the OP, many more players will be updated to their current stats.

The thing is, making the script user-friendly takes quite some time and before I do this, I need to know if it will be of anyone use?

I know that R software might look scary at first, but what it takes to use these script is simply to install the R software, provide the path to the required files and execute the script et voilà...
 

The Wizard

Reserve Team
I finished a script that allows updating the playerid of players from your database with no EA ids (ie created player by someone) with the current EA playerids if the player is now part of fifa19 database (or anyother database actually from which you can export the players.txt table).

For exemple, I am using as a base moddingway patch 28.04 (the last version I think) that comes with the chinese super league. But the CSL was made by Ariel and co before it was released by EA in fifa 19. So, moddingway playerid for player from the CSL are different from the actual EA fifa 19 playerid (do you still follow me?). My script allows updating the playerid of all those players (not only CSL players) in all the tables of your database and also gives you the option to automatically rename all the graphic files (faces, mini faces, ect...) and lua files.
The script gives your several options: 1) get report in the form of tables readable with xls, 2) report + automatic update of your db files and game files.

Why does it matter to update your playerid in your DB? Well, if you want to use the players.txt updater I posted in the OP, many more players will be updated to their current stats.

The thing is, making the script user-friendly takes quite some time and before I do this, I need to know if it will be of anyone use?

I know that R software might look scary at first, but what it takes to use these script is simply to install the R software, provide the path to the required files and execute the script et voilà...

At first I think it's a great idea. Personally I don't know how R works and to be honest I don't know if I have the time to learn it but I'm pretty sure that many users would love to have an updated MW Mod database. So maybe you can share the script and the DB. I fear that the script won't be downloaded that often but it's a great contribution for the community.
 

Papinho81

Reserves
I am totally fine with low download numbers. What I don't want is to invest time in something literally no one will use. If it is useful at least for one person, then it worth it. I owe so much to fifa 16 modding community (stadium makers like you, face makers, any graphic makers that release fantastic art work almost on a daily base ) that I am happy if it can be useful to at least someone.

Also, I understand that people have no time and/or no interest in learning R language, that's why I am releasing scripts with step by step explanation (which takes time to make) so anyone should be able to run them. Really what it takes to run my scripts is simply to open the R software, click on file, click on open a script, navigate toward the script location to open the script. Once the script is open, you need to provide a few pathes toward the input folders (simple copy paste), then run the command lines by tipping control+R one each line (less than 10 lines).

For the database, I did my own edit like adding new stadiums, so I might share some tables of my database but not all, because they won't be compatible with other people game files.
 

Papinho81

Reserves
It uses as input files tables exported from the game database (with db master) and tables exported from fifa 19 squadfiles (with for exemple RDBM; or fifasquadconverter then db master ) so if tables are identical in terms of columns present inside the tables between fifa 16 and 14 or 15 then yes, it is fully compatible.
 

Papinho81

Reserves
Ok. After a few tries I managed to do it. Your guide is really helpful, just the programme isn't.

I know R is not what we can call a user friendly program, It is why I provided a step by step guide. I am happy you find it useful and you managed to run the script on your own.

On the other hand, R is super flexible, have huge community providing all sort of crazy features and is powerful to deal with huge databases.
 

Papinho81

Reserves
i suggest doing the same for fifa 14 too please

Ovide, like I said in my post above, if the players table of fifa 14 is identical to fifa 16 one in terms of the columns numbers and names, then my script is compatible with it.

Let me know if you need assistance.
 

nikolapfc89

Youth Team
Tool working perfect mate! Especially with great instructions.

I have question, does squad files from 19 includes transfers? I am checking now some teams (not big ones) and i see players are mixed. There are some new but also many of them missing. I downloaded squad from MW forums you posted (25 march).

And if squad have new players what will happen if i dont have it in my DB? Will be created?
 

Papinho81

Reserves
In theory last fifa 19 squad files should have transfers up to date. Can you pinpoint an example where they are wrong?

But, my updater do not update transfers (teamplayerslinks), only players stats (players.txt) for the players from your DB (your players.txt) that are also present and have the same id in the fifa 19 squad file (fifa 19 players.txt). So when it comes to that updater there is no conflict possible other than ID not matching (ie you created a player and assigned an ID that is now used by EA for another player)

I wanted to add that I have updated the package to make it much more user friendly and will post it shortly.
 

nikolapfc89

Youth Team
In theory last fifa 19 squad files should have transfers up to date. Can you pinpoint an example where they are wrong?

But, my updater do not update transfers (teamplayerslinks), only players stats (players.txt) for the players from your DB (your players.txt) that are also present and have the same id in the fifa 19 squad file (fifa 19 players.txt). So when it comes to that updater there is no conflict possible other than ID not matching (ie you created a player and assigned an ID that is now used by EA for another player)

I wanted to add that I have updated the package to make it much more user friendly and will post it shortly.

Just checked St.Johnstone for example, missing winter transfers (squad 25.03).

Also for example Sancho J. should have overall 79 like says in 19 db. But in my db it's still old 78.
Some players seems to be Ok some seems to be old.
Jermain Defoe old mine db 76, and 19 says 75.
Munas Dabbur mine 78, and 19 says 79.
Kai Havertz mine 81, 19 - 82.

I tried both methods - TRUE or FALSE. Maybe database i downloaded is overall like that? Can you check?
FIFA 19 squad 26.03.

https://www34.zippyshare.com/v/2NIm8mS1/file.html
 

nikolapfc89

Youth Team
CM16.

But also transfers, look

Getafe winter transfers


and my squad converted Getafe


i dont have them.



EDIT: Stats ingame look like to be OK.
Some of them are OK, some of them are +- 2 up or down in CM16.

But i dont know how transfers are not OK.


I am using DB converted from FIFA 19 by scouser from forum.
Also some players (example Lucas Paqueta) was missing so i inserted in my game from MW DB with different ID than 19 (233927) and of course he wasnt updated. What is best solution to update only one player? Thanx.
 
Last edited:

Papinho81

Reserves
Ok! Scouser database rely on a database updated with a old squad file (http://www.soccergaming.com/index.p...sions-db-kits-ect.6465940/page-8#post-6523036), so that would explain why you don't have winter transfers.

The best solution to update only one player is to change the id of the player in CM16 and to give him its EA ID. If you have graphic or lua files for that player you would need to change their ids too. To update the stats you can do it manually (no ID change requires) or you can rerun the script after you exported the players.txt table from your edited DB (with the new ID for Paqueta).

About the OVR when using the option to copy it from fifa19 inside the script, there is something weird happening. If you take the example of Messi that I updated using the squad file you shared and using the option compute overall turned off, CM16 says is ovr=96

upload_2019-3-27_13-49-56.png

But its ovr in the player.txt table viewed with DB master says his ovr=94

upload_2019-3-27_13-51-11.png

Which is its correct ovr according to sofifa last update
upload_2019-3-27_13-52-6.png

So the "bug" seems to come from CM16 rather than my updater.
In the end, what really matters is what is displayed in the game.
As far as I am concerned, I can only recommand using the compute option set to TRUE because if you play a tournament or a career the OVR copied from fifa 19 will be unstable because the game recompute the players OVR based on players attributes.
With the compute OVR set to TRUE you can see for some players fluctuating OVR at the beginning of a career but it is much less common than when copying fifa 19 OVR (or fifa18 like moddingway DB did).
 


Top