DPyro's Editor - Identifying The Fields

[Phil Parent]

The release topic of DPyro's Editor has a lot of people trying to get it to work for them. I thought it would be nice to have a topic where those who got it to work try to figure out what the different tables and fields are.

I've been messing around comparing stats from the game and the data in the database and I've figured out a few...

In the DSVY / Player Ratings table....


The field EWUF is Overall (Probably calculated in-game, I wouldn't mess with it, I suspect it would be overwritten.)
The field ADEB is Speed
The field WSIO is Body Checking
The field DJLK is Endurance
The field ZXQY is Puck Control (Often the same rating as Passing BTW... It took a while to find aplayer that had different ratings to figure out what this one was.)
The field DURO is Passing
The field EJVH is Wrist Shot Power
The field EEBO is Wrist Shot Accuracy
The field JVCD is Slap Shot Power
The field BBQK is Slap Shot Accuracy
The field QYYP is Agility
The field RYOP is Strenght
The field FXKC is Acceleration
The field XOQY is Balance
The field VWRK is Faceoffs
The field BUES is Durability
The field NVCI is Deking
The field OKSO is Aggressiveness
The field ZARF is Poise
The field WCJU is Hand Eye
The field SRRZ is Shot Blocking
The field DLIV is Offensive Awareness
The field PVTO is Defensive Awareness
The field XQHS is Discipline
The field YBUG is Fighting Skills
The field YTUT is Stick Checking

Field WGBO has a rating of 0 for everybody except Ovechkin, who has 24. I thought it may have been visor tint, but I'm not sure he's the only one to have a colored visor and if so, I don't get the 24 if it is, it should be 1. Another possibility: His missing tooth?

[DPyro]

Re: DPyro's Editor - Identifying The Fields

I can't take credit for the editor. Big thanks to Xanathol who made the program here.

[Moose24x]

Re: DPyro's Editor - Identifying The Fields

This is really good stuff. Any chance someone can update the .XML with this info as it's discovered (I would try but I'd just end up ruining the .XML file)? Also, if anyone posts new discoveries maybe Phil can edit the OP to include them?

[archibalduk]

Re: DPyro's Editor - Identifying The Fields

Somebody mentioned this in the original Editor Thread, but there's a useful screenshot of Artem's editor which explains quite a few of the tabs. In his screenshot the abbreviations are reversed compared with how they appear in the Generic DB Tool. They're also from NHL 11 but I guess they're the same titles for NHL 14:



A couple I found for NHL 13 which may also apply for NHL 14:

PLAYER INFO TAB:
dXSB = Team Contracted

ARENA TAB:
vfEq = Arena ID

TEAM INFO TAB:
buDa = Arena

Also, I think wcSL is the Retired Numbers tab:
dXSB = Team (presumably dXSB is always Team ID as it matches the abbreviation from the Player Info Tab)
JFiY = Retired Jersey Number

[Dougie_G_93]

Re: DPyro's Editor - Identifying The Fields

Field WGBO has a rating of 0 for everybody except Ovechkin, who has 24. I thought it may have been visor tint, but I'm not sure he's the only one to have a colored visor and if so, I don't get the 24 if it is, it should be 1.

Check David Perron, he has a tinted visor too... Alex Steen used to as well.

[Moose24x]

Re: DPyro's Editor - Identifying The Fields

Check David Perron, he has a tinted visor too... Alex Steen used to as well.

Gaborik (and probably Kopitar) 100% have tints in the game.


So, going by that screen from Artem's website, does anyone have any idea what the fields:

Head ID (DaPp)
Haircap (Fdcp)
Haircards_b (HLGG)
Haircards_a (xOzX)

Actually mean. I'm assuming Head ID is where we can change the generic faces and I'll just have to figure out how the numbers correspond but the others? Do haircards_b and haircards_a even have to do with hair? Haircap? I'd love to change some players hair color, but I'm not gonna mess with any of this stuff until it's been figured out.

Also, if one of you guys who is really good at this stuff wants to look under the header (DzSF) and see if you can decypher what any of those columns mean, I feel that could be a big page for fixing player's that look nothing like themselves. Also the heading (uquv).

[Moose24x]

Re: DPyro's Editor - Identifying The Fields

Ugh, I just noticed that the dSvy tab, for editing players attributes has no way of identifying the player other than "Player ID" which is a number, running from 2-16000 something. I know you can find this information on another page so you know who you're editing, but it would be much easier if there was a way to get the players' names to display, or at least sort this page by team.

[Phil Parent]

Re: DPyro's Editor - Identifying The Fields

There, I got all the main stats for the Skater Stats table!

ANd thank you for that screenshot this will be SO helpful to figure out the tabs. I can say that the exhibitiongoalieai tab IS named mHuy, so I'll figure out those stats now.

[Phil Parent]

Re: DPyro's Editor - Identifying The Fields

Ugh, I just noticed that the dSvy tab, for editing players attributes has no way of identifying the player other than "Player ID" which is a number, running from 2-16000 something. I know you can find this information on another page so you know who you're editing, but it would be much easier if there was a way to get the players' names to display, or at least sort this page by team.

I was thinking of doing a numbered list people could refer too... that's really long to do though.

[Moose24x]

Re: DPyro's Editor - Identifying The Fields

I was thinking of doing a numbered list people could refer too... that's really long to do though.

I've got ubPc sorted by pro team and what I'm doing is just writing down the player ID numbers for the whole team (or taking a screen of the editor) and then doing it one team at a time. It takes a while to sort down the list to find each number, but for now it's the best I can do. Is it possible to CHANGE the names of the columns in the editor when we know what they are, or does that have to be changed in the .XML? I'd really like to just be able to see all of the skater attributes, now that you've figured them out, but I have NO idea how to set that up in the .XML file.

[shogunofharlem3]

Re: DPyro's Editor - Identifying The Fields

The release topic of DPyro's Editor has a lot of people trying to get it to work for them. I thought it would be nice to have a topic where those who got it to work try to figure out what the different tables and fields are.

I've been messing around comparing stats from the game and the data in the database and I've figured out a few...

In the DSVY / Player Ratings table....


The field EWUF is Overall (Probably calculated in-game, I wouldn't mess with it, I suspect it would be overwritten.)
The field ADEB is Speed
The field WSIO is Body Checking
The field DJLK is Endurance
The field ZXQY is Puck Control (Often the same rating as Passing BTW... It took a while to find aplayer that had different ratings to figure out what this one was.)
The field DURO is Passing
The field EJVH is Wrist Shot Power
The field EEBO is Wrist Shot Accuracy
The field JVCD is Slap Shot Power
The field BBQK is Slap Shot Accuracy
The field QYYP is Agility
The field RYOP is Strenght
The field FXKC is Acceleration
The field XOQY is Balance
The field VWRK is Faceoffs
The field BUES is Durability
The field NVCI is Deking
The field OKSO is Aggressiveness
The field ZARF is Poise
The field WCJU is Hand Eye
The field SRRZ is Shot Blocking
The field DLIV is Offensive Awareness
The field PVTO is Defensive Awareness
The field XQHS is Discipline
The field YBUG is Fighting Skills
The field YTUT is Stick Checking

Field WGBO has a rating of 0 for everybody except Ovechkin, who has 24. I thought it may have been visor tint, but I'm not sure he's the only one to have a colored visor and if so, I don't get the 24 if it is, it should be 1. Another possibility: His missing tooth?

Yellow skate laces? Everyone else is probably white.

[DPyro]

Re: DPyro's Editor - Identifying The Fields

I got a sample xml config which you can find here which uses combo boxes to display names instead of numbers (for example handedness left/right), however if you try to sort or filter by column you end up with an error message as it's expecting a number and not a string.

[Phil Parent]

Re: DPyro's Editor - Identifying The Fields

[/B]

Yellow skate laces? Everyone else is probably white.

Wouldn't that be in equipment though? I don't know.

[Phil Parent]

Re: DPyro's Editor - Identifying The Fields

XMJA tab... Skater equipment as is in the screenshot archibalduk posted...

- CNFB field is the Visor, codified as 0 = Straight Visor, 1 = Curved Visor, 2 = No Visor
- SPPG field is Pant Lenght, 0 = Short, 1 = Long
- NISO field is Tape Color, 0 = Black, 1 = White etc. But if anybody in the game has tape color other than that, this is wrong.
- DBYQ field is Visor Tint. 0 = No Tint, 1 = Gray, 4 = Green, 6 = Blue.... it's in the order they are listed in CAP.
- YPGJ field is Jersey Tuck. 0 = None, 1 = Left, 2 = Right, 3 - Full.
- XIVU field is Shoulder Pad Size. 0 = Small, 1 = Big
- DUUX field is Sock Tuck. 0 = None, 1 = Full, 2 = Front, 3 = Back

- WXFX field is the Stick. Codification is weird, and I think there might be more sticks in the game than there are available to pick in cap. Sherwood Nexon N12 = 57?!? Coming soon.

[leafnut24]

Re: DPyro's Editor - Identifying The Fields

So, going by that screen from Artem's website, does anyone have any idea what the fields:

Head ID (DaPp)
Haircap (Fdcp)
Haircards_b (HLGG)
Haircards_a (xOzX)

Actually mean. I'm assuming Head ID is where we can change the generic faces and I'll just have to figure out how the numbers correspond but the others? Do haircards_b and haircards_a even have to do with hair? Haircap? I'd love to change some players hair color, but I'm not gonna mess with any of this stuff until it's been figured out.

Also, if one of you guys who is really good at this stuff wants to look under the header (DzSF) and see if you can decypher what any of those columns mean, I feel that could be a big page for fixing player's that look nothing like themselves. Also the heading (uquv).

Just successfully change will petscenig's head to the one Tyler Biggs has. Not a hitch at all.