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

[Papinho81]

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

Spoiler: Description

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:

Package_Update_player_table_v20210529

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

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:

Pap R Script Face Installer v20210221

MediaFire is a simple to use free service that lets you put all your photos, documents, music, and video in a single place so you can access them anywhere and share them everywhere.

www.mediafire.com

Face Installer Tutorial Video:

Spoiler

Probably more to come soon...

 

[Papinho81]

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.

 

[Papinho81]

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]

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]

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.

 

[Samka]

Does your script work with FIFA 14 and FIFA 15?

 

[Papinho81]

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.

 

[Samka]

Please record video manual, im bad speak english)

 

[likesenpai]

Please record video manual, im bad speak english)

I agree, A video would be super helpful. If see it done properly I can then copy that and do it myself

 

[likesenpai]

I agree, A video would be super helpful. If see it done properly I can then copy that and do it myself

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

 

[ovide]

i suggest doing the same for fifa 14 too please

 

[Papinho81]

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]

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.

 

[Lebor30]

new idea Amazing, i'm looking forward to your work bro and tnx

 

[nikolapfc89]

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]

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]

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

 

[Papinho81]

How do you check the player overall? Ingame or with CM16?

 

[nikolapfc89]

CM16.

But also transfers, look

Getafe winter transfers

Spoiler

and my squad converted Getafe

Spoiler

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.

 

[Papinho81]

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

Spoiler: Messi CM16 OVR

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

Spoiler: Messi DB Master

Which is its correct ovr according to sofifa last update

Spoiler: Messi sofifa

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).