FIFA Player IDs

[jimjim]

Hi everyone.If anyone can help me with this I would appreciate it.I have some fifa players IDs but I can't find the player names because those players do not appear in any fifa,euro or world cup series.But I can only hear those names with sound master 06-10 (Clive Tydlesley in commentary).I recognize some of them but I am not sure.Here is a list of IDs and what can I hear from sound master.If anyone can recognize or find in some way them or tell me a way to find them please give me his/her help.

The list:
13123 <miguel> but who?
135605 <raul> maybe Raul Nunez Aural goalkeeper
143410 <bodnar> maybe Laszlo Bodnar (but he is in fifa 05-10 with different ID)
143416 <Golovko>Oleksandr Holovko(Aleksandr Golovko) 99%
143417 <Gusev> Oleg Husyev (Gusev) (but he is in fifa 07-10 with different ID)
143422 Oleksandr Melaschenko 99%
144260 Ilhan Mansiz 99%
144274 Sergen Yalcin 99%
146483 <rivas> maybe Avimiled Rivas
146539 <amarilla> maybe Angel Amarilla
146647 Dani Cancela 99%
146994 <martin> maybe from Barcelona
147460 <leandro> maybe Leandro Lessa Azevedo(but he is in fifa 06-08 with different ID)
148126 Denis Evsikov 99%
148141 Anton Remenchik 99%
148612 <simao> maybe bruno simao
148804 <verluis> maybe (Johan Versluis or Roy Versluis )
149120 <van driel>
149232 <mancini> maybe Alessandro Faiolhe Amantino Mancini (former Roma,Inter player)
149307 <cocu> maybe Phillipe Cocu
149935 Najwan Ghrayib 99%
149947 Gustavo Boccoli 99%
149968 Shai Biruk 99%
149977 Eran Levy 99%
149979 Giovanni Rosso 99%
150260 Marcin Kuzba 99% (but he is in fifa 05-06 with different ID)
150274 <papadopoulos>
150411 <vitka>
150663 <cisse>
155908 <knight>
156002 <reid>
157149 <Serjao> Sergio Ricardo de Jesus Vertello Serjao (vasco da gama)
159030 Vincenzo Iacopino 80%
160768 <Sergent> maybe Stephane Sergent
162117 <senel>
163281 <allsopp>
163610 <carrick>
165242 <litenba> (maybe Khalifa Elhadj Ba)
166756 <bell>
166759 <wanless>
166762 <taylor>
166920 Daryl Fordyce 99%
167427 Jurgen Klinsmann 99%
169160 <javi or havi or pavi>
47172 <johansson>
13965 (I think he is Alvaro with ID 139065 but EA made a mistake,check in sound master 09 or 10)
110325 Victor Manuel Fernandez Gutierrez (but he is in fifa 05-10 again with differen ID)
110339 Fran(Francisco Jose Figueroa Alonso) (but he is in fifa 06 with different ID)
53963 John O'Brien (but he is in fifa 05-08 again with differen ID)
134887 Barry Ferguson (but he is in fifa 05-10 again with differen ID)

 

[mrliioadin]

Hi everyone.If anyone can help me with this I would appreciate it.I have some fifa players IDs but I can't find the player names because those players do not appear in any fifa,euro or world cup series.But I can only hear those names with sound master 06-10 (Clive Tydlesley in commentary).I recognize some of them but I am not sure.Here is a list of IDs and what can I hear from sound master.If anyone can recognize or find in some way them or tell me a way to find them please give me his/her help.

The list:
13123 <miguel> but who?
135605 <raul> maybe Raul Nunez Aural goalkeeper
143410 <bodnar> maybe Laszlo Bodnar (but he is in fifa 05-10 with different ID)
143416 <Golovko>Oleksandr Holovko(Aleksandr Golovko) 99%
143417 <Gusev> Oleg Husyev (Gusev) (but he is in fifa 07-10 with different ID)
143422 Oleksandr Melaschenko 99%
144260 Ilhan Mansiz 99%
144274 Sergen Yalcin 99%
146483 <rivas> maybe Avimiled Rivas
146539 <amarilla> maybe Angel Amarilla
146647 Dani Cancela 99%
146994 <martin> maybe from Barcelona
147460 <leandro> maybe Leandro Lessa Azevedo(but he is in fifa 06-08 with different ID)
148126 Denis Evsikov 99%
148141 Anton Remenchik 99%
148612 <simao> maybe bruno simao
148804 <verluis> maybe (Johan Versluis or Roy Versluis )
149120 <van driel>
149232 <mancini> maybe Alessandro Faiolhe Amantino Mancini (former Roma,Inter player)
149307 <cocu> maybe Phillipe Cocu
149935 Najwan Ghrayib 99%
149947 Gustavo Boccoli 99%
149968 Shai Biruk 99%
149977 Eran Levy 99%
149979 Giovanni Rosso 99%
150260 Marcin Kuzba 99% (but he is in fifa 05-06 with different ID)
150274 <papadopoulos>
150411 <vitka>
150663 <cisse>
155908 <knight>
156002 <reid>
157149 <Serjao> Sergio Ricardo de Jesus Vertello Serjao (vasco da gama)
159030 Vincenzo Iacopino 80%
160768 <Sergent> maybe Stephane Sergent
162117 <senel>
163281 <allsopp>
163610 <carrick>
165242 <litenba> (maybe Khalifa Elhadj Ba)
166756 <bell>
166759 <wanless>
166762 <taylor>
166920 Daryl Fordyce 99%
167427 Jurgen Klinsmann 99%
169160 <javi or havi or pavi>
47172 <johansson>
13965 (I think he is Alvaro with ID 139065 but EA made a mistake,check in sound master 09 or 10)
110325 Victor Manuel Fernandez Gutierrez (but he is in fifa 05-10 again with differen ID)
110339 Fran(Francisco Jose Figueroa Alonso) (but he is in fifa 06 with different ID)
53963 John O'Brien (but he is in fifa 05-08 again with differen ID)
134887 Barry Ferguson (but he is in fifa 05-10 again with differen ID)

If you look up the playerid in the players table, you'll see four columns related to names.

1. firstname
2. lastname (or surname, can't remember)
3. commonname
4. Jerseyname (orsomething like that)

You'll see a set of numbers in those columns. Write those numbers down or store them in excel for you to look up. If one of those numbers is 21232, write it down and we'll look it up in the appropriate table...

Which is, the playernames table. Playernames are another table with just three columns, name, commendaryid, nameid. lookup the number you got in the nameid column and you'll have your player's name.

If you want to see what teams they are on, you can look in the teamplayerlinks table. There the playerid will appear in the table alongside the teamid (which corresponds to the team table).

This is how relational databases work and it is called data normalization. 1 table will store the basic information like a name. Another table will store other more detailed unique information. If I have 2000 players whose first name is Gary, I'm wasting a lot of data by building a table with Gary's name in it over and over and over again. Instead I build a table where Gary = 1. In the other table, my nameid can just say 1. The program can then look up ID 1 and pull Gary's name anytime it sees that number.

Help?

 

[jimjim]

If you look up the playerid in the players table, you'll see four columns related to names.

1. firstname
2. lastname (or surname, can't remember)
3. commonname
4. Jerseyname (orsomething like that)

You'll see a set of numbers in those columns. Write those numbers down or store them in excel for you to look up. If one of those numbers is 21232, write it down and we'll look it up in the appropriate table...

Which is, the playernames table. Playernames are another table with just three columns, name, commendaryid, nameid. lookup the number you got in the nameid column and you'll have your player's name.

If you want to see what teams they are on, you can look in the teamplayerlinks table. There the playerid will appear in the table alongside the teamid (which corresponds to the team table).

This is how relational databases work and it is called data normalization. 1 table will store the basic information like a name. Another table will store other more detailed unique information. If I have 2000 players whose first name is Gary, I'm wasting a lot of data by building a table with Gary's name in it over and over and over again. Instead I build a table where Gary = 1. In the other table, my nameid can just say 1. The program can then look up ID 1 and pull Gary's name anytime it sees that number.

Help?

My dear friend,
I am not sure that I understood what you were writing but I also think you didn't understand me too.Those IDs there are not in any Fifa from 2003-2016,or in world cup,euro or uefa series.But when someone uses the sound master, a tool that you can edit the commentary,in fifa 06-10 sound master you can find some IDs that have commentary,you can hear it but you cannot find the player.Those commentaries were made for these players but they never put these players in the game.So it's difficult to find them.I believe that someone can recognize them by what he hears or by compare them with players with previous or next ID number.I tried it and that's why I wrote some of them in the list.I also hope that EA somewhere has those names posted but I don't know how to find them.I hope I made my self clear.

 

[mrliioadin]

They could have been in update patches or could have been hidden players in past editions of the game.

 

[jimjim]

They could have been in update patches or could have been hidden players in past editions of the game.

I know it but is there any way to find them? But some of them like 149935 Najwan Ghrayib he was a player of Maccabi Haifa. In Fifa 2003 Maccabi Haifa is in game but this player isn't because he played for Maccabi Ahi Nazareth.In Fifa 05 or Uefa Champions League 2004-2005, EA maybe initially wanted to put Maccabi Haifa in game but for some reason they didn't but they made this player
ID and recorded a commentary name for him who had moved to this team that year.But this player had never been used in any Fifa series because he played for teams that didn't include in Fifa.In the other hand,Idan Tal a similar occasion
he is in Fifa 07 and Euro 2008 played for Bolton and Israel.I know those players are hidden but I hope that someone here may had find a way how to discover them. I also think EA has a list of this players but how can we find it?

 

[mrliioadin]

Yeah I mean I think you're probably right about how they got in there. I'm not sure how to find a list of them given that they are hidden. I honestly think you probably know more about this that anyone else right now. Someone might surprise me though.

 

[dissectionalone]

Some players have never been on any Fifa game apart from the now defunct Fifa Manager series, that's why some players have relatively low ID's the first time we see them in the regular Fifa series.

You could clearly notice this in Fifa 14 when the other south american leagues were added, as quite a bit of players had ID's that were "lower" than the newer ID's used for some players that were being added for the first time.

But that was mostly until Fifa Manager 07 I believe. After that they changed a lot of the ID's on the series (both for clubs and players)

I doubt you'll be able to find such a list, unless someone from EA itself provided it

 

[jimjim]

Some players have never been on any Fifa game apart from the now defunct Fifa Manager series, that's why some players have relatively low ID's the first time we see them in the regular Fifa series.

You could clearly notice this in Fifa 14 when the other south american leagues were added, as quite a bit of players had ID's that were "lower" than the newer ID's used for some players that were being added for the first time.

But that was mostly until Fifa Manager 07 I believe. After that they changed a lot of the ID's on the series (both for clubs and players)

I doubt you'll be able to find such a list, unless someone from EA itself provided it

I would like to ask you something.Are there the same player IDs for Fifa and Fifa Manager? And if so,are there maybe some of those players who I am looking for in a Fifa Manager series?

 

[Bubble Gum]

You may compare your list with mine: Full ID List

 

[jimjim]

You may compare your list with mine: Full ID List

Thank you Bubble Gum for uploading your list but unfortunately anyone of those players appear in this list. I am going to try commpare those IDs with the close IDs from your list but it would be difficult to recognise some of them.

 

[bangus]

It is possible and probable those players are no longer in the game. If you cannot find the players, there is a way to use those sound file IDs. You can create the player yourself, and then assign a sound file name to them. That is one way to get those players in the game.

 

[jimjim]

It is possible and probable those players are no longer in the game. If you cannot find the players, there is a way to use those sound file IDs. You can create the player yourself, and then assign a sound file name to them. That is one way to get those players in the game.

I know it but the problem is that I can't identify them.When I finally find them I am going to create these players but I have to know some information about them like position, skills, bio etc.

 

[bangus]

I know it but the problem is that I can't identify them.When I finally find them I am going to create these players but I have to know some information about them like position, skills, bio etc.

I'm not sure what your doubt and hesitation is here. The name-specific sound files like "Denis Evsikov" are obvious. So make Denis Evsikov and assign that name to him. And the generic last name sound file names like "Rivas" can be assigned to anyone with the last name (or first name) Rivas. Create whatever Rivas player you want and then assign him that name.

 

[bangus]

I just figured out you probably think names can only be assigned to one specific player. Not true. Every player has both a player ID and a commentary ID. So you can create:

Avimiled Rivas
player ID 70000
sound ID 146483

Harry Rivas
player ID 70001
sound ID 146483

Juan Rivas
player ID 70002
sound ID 146483

Etc. So if you decide you want "Rivas" to be Avimiled Rivas, then just search online for Avimiled Rivas, get his face, stats, height, weight, etc., then create him and assign him sound ID 146483. The other commentary-specific names like "Denis Evsikov" obviously belong to one player only, not sure why you think that's only 99% certain. You can already search them online, and then go ahead and create them.

 

[jimjim]

I just figured out you probably think names can only be assigned to one specific player. Not true. Every player has both a player ID and a commentary ID. So you can create:

Avimiled Rivas
player ID 70000
sound ID 146483

Harry Rivas
player ID 70001
sound ID 146483

Juan Rivas
player ID 70002
sound ID 146483

Etc. So if you decide you want "Rivas" to be Avimiled Rivas, then just search online for Avimiled Rivas, get his face, stats, height, weight, etc., then create him and assign him sound ID 146483. The other commentary-specific names like "Denis Evsikov" obviously belong to one player only, not sure why you think that's only 99% certain. You can already search them online, and then go ahead and create them.

For Denis Evsikov the commentary is "Evsikov" and I am 99% sure that he is him because he is the only footballer with this surname.For "Rivas" I think he is Avimilde Rivas because this commentary is near to Xabi Prieto's id 146482
who played for Real Sociedad and Amaviled Rivas is the only player with surename Rivas who had played also for this team but I am not sure that this is the right player. And for some players like id 165242 I don't understand what the commentator says so if anyone has sound master 06 to 10 please hear those commentaries for me and write me what you undestand.

 

[bangus]

For Denis Evsikov the commentary is "Evsikov" and I am 99% sure that he is him because he is the only footballer with this surname. For "Rivas" I think he is Avimilde Rivas because this commentary is near to Xabi Prieto's id 146482

Okay so last names only... So create a player that looks like Denis Evsikov, then assign him the Evsikov commentary ID. Now you have Denis Evsikov in your game.

Likewise, create a player that looks like Avimilde Rivas, then assign him the Rivas commentary ID. Now you've got Avimilde Rivas in your game.

I don't know if CM 16 is good for creating new players, a lot of CM features don't work as well as they used to. But that's the easiest way to create a new player. The other way is to find a player that looks like Evsikov, then open up the players table in Excel, find the player (via his ID) that looks like Evsikov, then copy and paste that player's values into the bottom of the players table. Then edit that line of new values to make Evsikov, change his player ID, first/last name value, kit name value, any rating changes, etc.

This way you can get those players in your game now, you don't have to wait around for weeks or months or maybe never to find their real ID... if those players are even in the game anymore, which many of them aren't.

 

[xtrinox]

Okay so last names only... So create a player that looks like Denis Evsikov, then assign him the Evsikov commentary ID. Now you have Denis Evsikov in your game.

Likewise, create a player that looks like Avimilde Rivas, then assign him the Rivas commentary ID. Now you've got Avimilde Rivas in your game.

I don't know if CM 16 is good for creating new players, a lot of CM features don't work as well as they used to. But that's the easiest way to create a new player. The other way is to find a player that looks like Evsikov, then open up the players table in Excel, find the player (via his ID) that looks like Evsikov, then copy and paste that player's values into the bottom of the players table. Then edit that line of new values to make Evsikov, change his player ID, first/last name value, kit name value, any rating changes, etc.

This way you can get those players in your game now, you don't have to wait around for weeks or months or maybe never to find their real ID... if those players are even in the game anymore, which many of them aren't.

You should add him to some mod makers

 

[bangus]

You should add him to some mod makers

What do you mean "add him"? And why "mod makers"?

 

[bangus]

Does anyone of you know who is this player 169838 - Kelly, Craig? There isn't
any player whose name is Craig Kelly.Is this name true? He aslo has a specific face but I cannot recognize him.

-jimjim

 

[daniel.ok]

in what table from database I can found the Surnames & JerseyNames of the players?