Soccer Gaming Forums
Registration is free! Calendar Find other members Frequently Asked Questions Rules User CP Tools Home


Go Back   Soccer Gaming Forums | FIFA Forums, FIFA Mods, Futball > FIFA Series > FIFA 13 Forum > FIFA 13 PC Editing Forum

Reply
 
Thread Tools Search this Thread Rating: Thread Rating: 301 votes, 4.95 average. Display Modes
Old 15-10-2012, 12:30:PM   #27
hayman
Club Supporter
 
Join Date: Jan 2006
Location: Hollandia
Posts: 21
hayman is on a distinguished road
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:

Code:
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!
hayman is offline   Reply With Quote
Old 15-10-2012, 05:15:PM   #28
root4rulez
Reserve Team
 
root4rulez's Avatar
 
Join Date: May 2010
Posts: 501
root4rulez is on a distinguished road
Send a message via Skype™ to root4rulez
i need the players id - names
root4rulez is offline   Reply With Quote
Old 15-10-2012, 09:01:PM   #29
regularcat
Manager
 
Join Date: Jun 2008
Posts: 12,669
regularcat is a jewel in the roughregularcat is a jewel in the roughregularcat is a jewel in the rough
Quote:
Originally Posted by root4rulez View Post
i need the players id - names
so export the tables & get them bro, its a lot to ask someone to do.
regularcat is offline   Reply With Quote
Old 15-10-2012, 09:09:PM   #30
root4rulez
Reserve Team
 
root4rulez's Avatar
 
Join Date: May 2010
Posts: 501
root4rulez is on a distinguished road
Send a message via Skype™ to root4rulez
Quote:
Originally Posted by regularcat View Post
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
root4rulez is offline   Reply With Quote
Old 15-10-2012, 09:19:PM   #31
regularcat
Manager
 
Join Date: Jun 2008
Posts: 12,669
regularcat is a jewel in the roughregularcat is a jewel in the roughregularcat is a jewel in the rough
Quote:
Originally Posted by root4rulez View Post
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.
regularcat is offline   Reply With Quote
Old 17-10-2012, 01:02:PM   #32
hayman
Club Supporter
 
Join Date: Jan 2006
Location: Hollandia
Posts: 21
hayman is on a distinguished road
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).

Last edited by hayman; 17-10-2012 at 01:06:PM.
hayman is offline   Reply With Quote
Old 19-10-2012, 10:33:PM   #33
Mulrooney
Youth Team
 
Mulrooney's Avatar
 
Join Date: Dec 2011
Location: Greater Manchester,Trafford
Posts: 130
Mulrooney has a little shameless behaviour in the past
Send a message via MSN to Mulrooney Send a message via Skype™ to 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 ?
__________________

Mulrooney is offline   Reply With Quote
Old 19-10-2012, 11:25:PM   #34
AcidPT
Club Supporter
 
Join Date: Sep 2011
Posts: 35
AcidPT is on a distinguished road
Does anyone have the tournament id's? I can't find the Euro anywhere, is it the same as the World Cup?
AcidPT is offline   Reply With Quote
Old 20-10-2012, 12:01:PM   #35
V.K
Starting XI
 
V.K's Avatar
 
Join Date: Nov 2010
Location: Moscow
Posts: 3,691
V.K will become famous soon enoughV.K will become famous soon enough
Boots IDs? Fonts & numbers IDs anyone?
V.K is offline   Reply With Quote
Old 23-10-2012, 09:36:AM   #36
blueboy73
Club Supporter
 
Join Date: Oct 2012
Posts: 5
blueboy73 is on a distinguished road
Quote:
Originally Posted by hayman View Post
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:

Code:
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
blueboy73 is offline   Reply With Quote
Old 24-10-2012, 06:34:PM   #37
hayman
Club Supporter
 
Join Date: Jan 2006
Location: Hollandia
Posts: 21
hayman is on a distinguished road
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).
hayman is offline   Reply With Quote
Old 25-10-2012, 06:48:PM   #38
spurspeter
Club Supporter
 
Join Date: Jun 2005
Posts: 63
spurspeter is on a distinguished road
Does anybody have the ID for Gylfi Sigurdsson please?

Thanks!
spurspeter is offline   Reply With Quote
Old 25-10-2012, 09:03:PM   #39
DerSchalker
Youth Team
 
Join Date: Aug 2012
Posts: 490
DerSchalker is on a distinguished road
It is 184484
DerSchalker is offline   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT +1. The time now is 05:53:PM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
You Rated this Thread: