FIFA Player IDs

Discussion in 'FIFA 16 Forum' started by jimjim, May 26, 2016.

  1. jimjim

    jimjim Club Supporter

    Joined:
    Apr 13, 2016
    Messages:
    22
    Likes Received:
    0
    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)
     
  2. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    2
    Location:
    Wilmington
    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?
     
  3. jimjim

    jimjim Club Supporter

    Joined:
    Apr 13, 2016
    Messages:
    22
    Likes Received:
    0
    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.
     
  4. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    2
    Location:
    Wilmington
    They could have been in update patches or could have been hidden players in past editions of the game.
     
  5. jimjim

    jimjim Club Supporter

    Joined:
    Apr 13, 2016
    Messages:
    22
    Likes Received:
    0
    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?
     
  6. mrliioadin

    mrliioadin Senior Squad

    Joined:
    Apr 3, 2006
    Messages:
    2,347
    Likes Received:
    2
    Location:
    Wilmington
    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.
     
  7. dissectionalone

    dissectionalone Senior Squad

    Joined:
    Oct 20, 2011
    Messages:
    1,337
    Likes Received:
    2
    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
     
  8. jimjim

    jimjim Club Supporter

    Joined:
    Apr 13, 2016
    Messages:
    22
    Likes Received:
    0
    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?
     
  9. Bubble Gum

    Bubble Gum Youth Team

    Joined:
    Jul 28, 2012
    Messages:
    209
    Likes Received:
    0
  10. jimjim

    jimjim Club Supporter

    Joined:
    Apr 13, 2016
    Messages:
    22
    Likes Received:
    0
    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.
     
  11. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  12. jimjim

    jimjim Club Supporter

    Joined:
    Apr 13, 2016
    Messages:
    22
    Likes Received:
    0
    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.
     
  13. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  14. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  15. jimjim

    jimjim Club Supporter

    Joined:
    Apr 13, 2016
    Messages:
    22
    Likes Received:
    0
    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.
     
  16. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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.
     
  17. xtrinox

    xtrinox Club Supporter

    Joined:
    Feb 23, 2016
    Messages:
    12
    Likes Received:
    0
    You should add him to some mod makers
     
  18. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    What do you mean "add him"? And why "mod makers"?
     
  19. bangus

    bangus Starting XI

    Joined:
    Sep 21, 2011
    Messages:
    5,413
    Likes Received:
    480
    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
     
  20. daniel.ok

    daniel.ok Reserve Team

    Joined:
    Apr 24, 2009
    Messages:
    915
    Likes Received:
    105
    in what table from database I can found the Surnames & JerseyNames of the players?
     
      

Share This Page