FIFA 13 IDs

[Gigee]

Boots id please

 

[Tavano]

Boots id please

quote

 

[Ricky80_9]

please kitnumbers of udinese thanks

 

[a L E x _ 1 O]

training kit ID please

 

[Bubble Gum]

Hi everyone! Here's the full FACE list of FIFA 13. No hidden faces in this list, we still have to find them, but this is better than nothing.

https://docs.google.com/spreadsheet...QmxwOVluUFRGVkE&single=true&gid=1&output=html

 

[UnitedRedDevils]

does anyone have ids of players with generic faces??
any link would do

 

[hayman]

You can get 'em yourself. It ain't that hard.

Use DBM12 and export de players and the playernames tables. Open it in Excel.

Filter in "players" on "headclasscode" 0 = specific and 1=generic.

Then cut the line lastnameID from "players" into "playernames".

Make sure it's: 1: lastnameID, 2: nameID 3:name

Then create/use the following macro:

Sub Change()
    Dim rng As Range, rng2 As Range, cl As Variant
    
    Set rng = Range("A1").CurrentRegion.Columns(1)
    Set rng2 = rng.Offset(, 1).Resize(rng.Rows.Count, 2)
    For Each cl In rng.Cells
        If Application.WorksheetFunction.CountIf(rng.Offset(, 1), cl.Value) > 0 Then
            rng.Replace What:=cl.Value, Replacement:=Application.WorksheetFunction.VLookup(cl.Value, Cells(1, 2).Resize(rng.Rows.Count, 2), 2, 0), LookAt:=xlWhole
        End If
    Next
End Sub

Use the same trick and macro on 1:commonnameID 2: nameID 3:name
And VOILA! Put commonname ID and lastnameID together and you'll have your list!

 

[root4rulez]

i need the players id - names

 

[regularcat]

i need the players id - names

so export the tables & get them bro, its a lot to ask someone to do.

 

[root4rulez]

so export the tables & get them bro, its a lot to ask someone to do.

When export i dont see the name of the player

 

[regularcat]

When export i dont see the name of the player

you wont, you need to get the player names table too & get the names from the ids in the player table, like i said its a lot of work nobody is going to do.

 

[hayman]

It isn't that much work if you use the macro, I've written how to do it!
root4rulez should at least have tried it!!!!!

Anyway, I used the macro, it took me 2 minutes to generate and create your list. I can't attach it to this message. Maybe someone else can upload it somewhere?

It has one sheet with the macro written in it, one sheet on wich I used the macro, one with all the date from "players" loaden from the fifa13 database and one sheet for your generic (without commonnames) and one for the specific faces (with commonnames).

 

[Mulrooney]

does anybody know the id for the Euro qualifiers or the Euro Cup's itself or are they same as the World Cup ID 511 ?

 

[AcidPT]

Does anyone have the tournament id's? I can't find the Euro anywhere, is it the same as the World Cup?

 

[V.K]

Boots IDs? Fonts & numbers IDs anyone?

 

[blueboy73]

You can get 'em yourself. It ain't that hard.

Use DBM12 and export de players and the playernames tables. Open it in Excel.

Filter in "players" on "headclasscode" 0 = specific and 1=generic.

Then cut the line lastnameID from "players" into "playernames".

Make sure it's: 1: lastnameID, 2: nameID 3:name

Then create/use the following macro:

Sub Change()
    Dim rng As Range, rng2 As Range, cl As Variant
    
    Set rng = Range("A1").CurrentRegion.Columns(1)
    Set rng2 = rng.Offset(, 1).Resize(rng.Rows.Count, 2)
    For Each cl In rng.Cells
        If Application.WorksheetFunction.CountIf(rng.Offset(, 1), cl.Value) > 0 Then
            rng.Replace What:=cl.Value, Replacement:=Application.WorksheetFunction.VLookup(cl.Value, Cells(1, 2).Resize(rng.Rows.Count, 2), 2, 0), LookAt:=xlWhole
        End If
    Next
End Sub

Use the same trick and macro on 1:commonnameID 2: nameID 3:name
And VOILA! Put commonname ID and lastnameID together and you'll have your list!

Could you elaborate on this a bit more please , i followed what you said but it doesn't seem to work i'm not entirely sure if i'm doing the macro right,bit of a newbie me. Thanks

 

[hayman]

If you send me a pm with your email address I can send you the complete file.

elaboration:
If you export the database files from DBM12 you'll get a txt file, which you can open in excel. Do so.

In excel you can filter on headclasscode (which is a common or specifiek face, the number 0 equals a specific face, 1 equals a generic face).

%(If you want, you can open a new excel. Copy the player ID table in this new file for your face list with ID's.)

Then you'll have to copy, paste the "lastnameID"-table into a the playername.txt opened as excel file.

Make sure you'll paste in as a new row A.
You'll see
A: lastnameID (is a number) *new in this document
B: nameID (is a numer, corresponding to C) *already existing in playername.txt
C: name (is the name) *already existing in playername.txt

Then create a new macro. Go to the editor and copy/paste the macro code, save it. When you go to macro overview, you can run the macro (it's called "Change"). It changes the LastnameID from number to name.
You can copy the lastnameID table which are now names, next to the playerID table in your player.txt or new file. Now you'll have a list with player ID's and corresponding names of all the specific faces in fifa.

note: Do the same thing on commonnames! Some player are not known by first and lastname, but by a commonname (for example: Nani, Kaka, and many others).

 

[spurspeter]

Does anybody have the ID for Gylfi Sigurdsson please?

Thanks!

 

[DerSchalker]

It is 184484

 

[erick91]

oscar for chelsea please??? ID