Hey man thanks, i put suarez in barcelona. (took a few hours hahah)
I also added a player to the game. The only problem is that the player's name was not in the game, so the player has no name now. (
https://imgur.com/a/EF3IU2U)
Maybe one of you guys knows how to add names of players who are not in the game?
thank you in advance,
-Mike
You need to go to the
players table and assign the name in
firstnameid, lastnameid, playerjerseynameid and
commonnameid (commonnameid is only required if the player's surname is a long one, but in reality we only use a short version).
For example,
Andrés Iniesta in the database has
Andrés as the
firstname and
Iniesta Luján as the
lastname. But since in reality we do not use the secondary "surname", his
commonnameid is
Iniesta. This goes for most players who have 2 firstnames and/or 2 lastnames.
playerjerseynameid is the name on the shirt, in this case:
A.Iniesta.
--------------------------------------------
But for a player who has only one first name and/or one surname in the
lastname,
commonnameid simply has to be
0.
For example,
Lionel Messi in the database has
Lionel as the
firstname and
Messi as the
lastname. Therefore he does not need a
commonnameid.
----------------------------------------
As to know what the
nameID of your player is, you can find them in the
playernames table. If they do not contain the names you want to have, you simply need to add them there and give them a unique
ID.
For example, if I want to add
Sergi Roberto to the database, I look inside the
playernames table to see if his name is already there.
Roberto is already there (
nameID 5498).
So in the
players table, I will type
5498 in the
lastnameid. So now I already have
Sergi Roberto's surname in the game. However,
Sergi does not exist in the database, so I simply add a new
name and
nameid in the
playernames table. For example I use
7000 as the
nameid and type
Sergi as the
name. Now I go back to the
players table and type
7000 in the
firstnameid. Now the game will display
Sergi Roberto's name correctly.
But we still need to add his
playerjerseynameid, which is
S.Roberto. So I will add it to the
playernames table, with
7001 as the
nameid. Now I will type in
7001 at
playerjerseynameid in the
players table, to also have his name on the shirt ingame.
----------------------
You can also look inside FIFA 20's database to find the
players/
teams/
leagues/
playernames, extract these tables and then use excel to add/convert these tables to FIFA Street's tables.