Thanks...what I want is to switch this default...
...to this one...
...so I don't have to enter the stadium preview screen and change it every time.
Definition File Update
Re: Definition File Update
glad i could help...that actually leads me to my current project of checking if weather is at all any relation to players stamina and if not how to make it so it is...i've been away from this game for a while and just getting back to it is making it slightly difficult to remember everything but i have learned that there are a few things i have found to not be hard coded like most are assuming and i am currently working on implementing some new things into the game that will add to realism and accuracy...will update everyone on my findings and results on these monumental achievements when i sort them all out and get them working properly
Re: Definition File Update
valvegas1 wrote:NickyJ wrote:"Button actions" sounds quite interesting. In Madden 04, the buttons are badly arranged. (For example, sprinting on offense is button 2, on defense it's button 3.) If those buttons could be changed, that would be great.
I have tried using these to edit the button layouts and it did work for me although i should mention i use an XBOX360 controller for my game so i ussually map them to that and not a keyboard...just my preference...i had a friend tell me something a while back about being able to add the ncaa functions to the controls (pitch & fake pitch) but i dont remember how he did it but i know he used xpadder to map it to his controller as a two button function and i remember he said it was programed into madden but they scratched it before release...if anyone else has attemted this or figured this out it could be very big...like i said i really dont remember how he did it or what he did but i remember seeing him use it in the game
I'm using a Logitech gamepad, so I might try it out. Where is the db file with the buttons located?
Re: Definition File Update
NickyJ wrote:valvegas1 wrote:NickyJ wrote:"Button actions" sounds quite interesting. In Madden 04, the buttons are badly arranged. (For example, sprinting on offense is button 2, on defense it's button 3.) If those buttons could be changed, that would be great.
I have tried using these to edit the button layouts and it did work for me although i should mention i use an XBOX360 controller for my game so i ussually map them to that and not a keyboard...just my preference...i had a friend tell me something a while back about being able to add the ncaa functions to the controls (pitch & fake pitch) but i dont remember how he did it but i know he used xpadder to map it to his controller as a two button function and i remember he said it was programed into madden but they scratched it before release...if anyone else has attemted this or figured this out it could be very big...like i said i really dont remember how he did it or what he did but i remember seeing him use it in the game
I'm using a Logitech gamepad, so I might try it out. Where is the db file with the buttons located?
That would be in the CFGN, CFGP & CFGX tables of the streameddata.db file
Re: Definition File Update
I just checked Madden 04's StreamedData.db file, and it doesn't have those. It must be only 08 that has them. Oh, well. It was worth a shot.
Re: Definition File Update
sorry...didn't realize you was referring to 04...I have 08 only so all my data and info is based on thatNickyJ wrote:I just checked Madden 04's StreamedData.db file, and it doesn't have those. It must be only 08 that has them. Oh, well. It was worth a shot.
- slydways
- Banned
- Posts: 917
- Joined: Wed Jan 09, 2013 7:41 pm
- Location: Alliance,Ohio ........Home of the MOUNT UNION PURPLE RAIDERS 11 Division III National Championships
Re: Definition File Update
To find out which players have a particular "Player Face ID"...it is found in the PFEx column of your roster file.
1. Open your roster ( <default roster> or custom ) in DB Editor
2. Click the PLAY Table ( players)
3.Go to last column on the right ( PFEx)...this is the Player ID number.
4. Go to CVS...export CVS [ it should appear in your "Documents" folder (not Madden) under Folder "DB CVS Output"]
5. Load file into Excel or Open Office Calc (Free)
6.Highlight the PFEx column.
7.go up to "Sort Ascending"( A/Z arrow down - in Calc) click
8.Click "extend selection"
9 You now have all the Player ID's in numerical order and can easily view what players have that particular number.
Pictures of Face ID's are here...( Face ID's control skin color also...not PCPH as listed in the "Definition File")
The "PCPH" of Vinatieri and Marvin Harrison in the <default roster> are BOTH "2" (1,2,3 are all that are used). This can't mean a skin color because one player is "light" and the other is "dark". Not sure what it means...but it is NOT skin color. It seems to me that a few dedicated serious members of FootballFreaks community , and here at FootballIdiots have deciphered many of the important acronyms in the databases...but some others have simply "guessed" and went to the FF site and edited the Definitions File. I would question every entry on the list unless it has been tested and proven.
Also "PSKI" is wrong as "Player Skin Color" but at least that LOOKS like it should be "Skin Color" Just another guess...can't be correct
(1,2,3 are used ) Addai is 2 , Marvin Harrison is 1....but BOTH are dark. ( i.e. 1=light , 2=med , 3=dark) Maybe it means Player Skiing"?
1. Open your roster ( <default roster> or custom ) in DB Editor
2. Click the PLAY Table ( players)
3.Go to last column on the right ( PFEx)...this is the Player ID number.
4. Go to CVS...export CVS [ it should appear in your "Documents" folder (not Madden) under Folder "DB CVS Output"]
5. Load file into Excel or Open Office Calc (Free)
6.Highlight the PFEx column.
7.go up to "Sort Ascending"( A/Z arrow down - in Calc) click
8.Click "extend selection"
9 You now have all the Player ID's in numerical order and can easily view what players have that particular number.
Pictures of Face ID's are here...( Face ID's control skin color also...not PCPH as listed in the "Definition File")
The "PCPH" of Vinatieri and Marvin Harrison in the <default roster> are BOTH "2" (1,2,3 are all that are used). This can't mean a skin color because one player is "light" and the other is "dark". Not sure what it means...but it is NOT skin color. It seems to me that a few dedicated serious members of FootballFreaks community , and here at FootballIdiots have deciphered many of the important acronyms in the databases...but some others have simply "guessed" and went to the FF site and edited the Definitions File. I would question every entry on the list unless it has been tested and proven.
Also "PSKI" is wrong as "Player Skin Color" but at least that LOOKS like it should be "Skin Color" Just another guess...can't be correct
(1,2,3 are used ) Addai is 2 , Marvin Harrison is 1....but BOTH are dark. ( i.e. 1=light , 2=med , 3=dark) Maybe it means Player Skiing"?
- slydways
- Banned
- Posts: 917
- Joined: Wed Jan 09, 2013 7:41 pm
- Location: Alliance,Ohio ........Home of the MOUNT UNION PURPLE RAIDERS 11 Division III National Championships
Re: Definition File Update
Here is the most updated Definitions List from FF site .Last edit was 9/8/13. There are still errors and this list is not alphabetical...just took it as is from the FF site. The acronyms and their definitions are grouped like this ( see green )...
Here is the list in .xls...
Code: Select all
ACTX
OWNER COMMENTS TEXT
AGCX
AGENT COMMENT TEXT
artx
pb editor graphic
arty
pb editor graphic
ASNN
Minimum Number of Players Assigned to Position
ASPO/ENVU
Position Number
BGID
PLAYBOOK ID
BNAM
PLAYBOOK NAME
BOFF
PLAYBOOK TYPE 1=OFFENSE, 0=DEFENSE
BORD
PLAYBOOK ORDER
caat
Pass Att.
cacm
Pass Comp.
CADH
City December High Temp
CADO
City December Low Temp
CAGE
Coach Age
cafd
First downs
cain
INT Thrown
calN
Pass Long
CART
CUSTOM ART
casa
Times Sacked
CASH
City September High Temp
CASO
City September Low Temp
catd
Pass TD
CAVI
City Average Income
CAWD
AWARD ID
caya
Pass Yds
CBLM
Coach Ratings – Worst Loss
CBWM
Coach Ratings – Biggest Win
ccca
Catches
CCCS
CONTROLLER MOVE (DIVE, SPRINT, STRAFE, ETC)
ccdr
Drops
CCHM
Coach Chemistry
CCID
Coach ID
CCLN
Contract Length
CCLO
Coach Ratings – Career Losses
CCPL
Coach Ratings – Playoff Losses
CCPW
Coach Ratings – Playoff Wins
ccrL
Rec. Long
cctd
Rec. TD
CCTI
Coach Ratings – Career Ties
CCWI
Coach Ratings – Career Wins
CCWS
Coach Ratings – Winning Seasons
ccya
Rec. Yds
ccyc
YAC
CDEF
Coach Defense Rating
CDID
Coach Defense Playbook
cdpd
Pass Def.
CDPT
Priority Type
cdta
Tackle
CDTA
Coach Defense Agressiveness
cdtl
Tackle for Loss
CDTR
Coach Defense Strategy Pass
CDTX
DRAFT CLASS WORKOUT TEXT
CDTY
Coach Defense Philosophy – 95=4-3; 5=3-4
cEID
EVENT ID
CETH
Coach Ethics
CFDA
Coach Management Draft Player – 0=user; 1=CPU
CFDP
Coach Management Sign Draft Picks – 0=user; 1=CPU
CFFA
Coach Management Sign Free Agents – 0=user; 1=CPU
CFFR
Coach Management Fill Rosters – 0=user; 1=CPU
CFRP
Coach Management Re-sign Players – 0=user; 1=CPU
CFRR
Coach Management Depth Chart – 0=user; 1=CPU
CFUC
Coach Control – 1=user; 0=CPU
CGID
Conference ID
cgmp
Games Played
cgms
Games Started
CGPT
City Growth Rate
CHAR
Coach Hair?????
CHGT
Coach Height???????
ckaa
FGA 1-29
ckac
FGA 30-39
ckad
FGA 40-49
ckae
FGA 50+
ckea
XPA
ckeb
XP Blocked
ckem
XPM
ckfa
FGA
ckfb
FG Blocked
ckfL
FG Long
ckfm
FGM
ckma
FGM 1-29
ckmc
FGM 30-39
ckmd
FGM 40-49
ckme
FGM 50+
cknk
Kickoffs
CKNW
Coach Knowledge
cktb
Touchbacks
clbl
Blocks
clff
Forced Fumble
clfr
Fumble Recov.
clft
Fumble Rec. TD
clfy
Fumble Yards
CLNA
Coach Name
clsa
Safety
clsk
Sacks
CLTF
Last Team (Franchise)??????????
cMON
MONTH ID
CMOT
Coach Motivation
CMTX
MONTH TEXT
CNAM
CONFERENCE NAME
cNDA
DAYS IN MONTH
COCX
NEW COACH COMMENTS TEXT
COFF
Coach Offense Rating
COID
COLLEGE ID
CONA
COLLEGE NAME
copa
Pancakes
COPS
Coach Position – 0=HC; 1=OC; 2=DC; 3=ST
cosa
Sacks Allowed
COTA
Coach Offense Agressiveness
COTR
Coach Offense Strategy
cpat
Punts
cpbl
Punts Blocked
CPID
Coach Offense Playbook
cplN
Punt Long
cpny
Net Yds
CPOP
City Population
cppt
Inside 20
CPT1
Captain 1
CPT2
Captain 2
CPT3
Captain 3
cptb
Touchbacks
cpya
Yards (punt)
CRAT
Coach Approval Rating
CRBT
Coach Running Strategy
CRca
CREDIT ID
CRcd
CREDIT HEADER
CRDB
Coach Rating DB
CRde
CREDIT NAME
CRDL
Coach Rating DL
CREG
City Region
CRid
CREDIT NAME ID
crka
Kick Return Attempts
crkL
Kick Return Long
CRKS
Coach Rating K
crkt
Kick Return TD
crky
Kick Return Yards
CRLB
Coach Rating LB
CROL
Coach Rating OL
crpa
Punt Return Attempts
crpL
Punt Return Long
CRPS
Coach Rating P
crpt
Punt Return TD
crpy
Punt Return Yards
CRQB
Coach Rating QB
CRRB
Coach Rating RB
CRSA
Coach Rating S
CRWR
Coach Rating WR
CSAL
Coach Salary
CSBL
Coach Ratings – Super Bowl Losses
CSBW
Coach Ratings – Super Bowl Wins
csin
INT
csit
INT for TD
csiy
INT yards
CSKI
Coach Skin Color ID
CSLO
Coach Ratings – Season Losses
cslR
INT Long
CSWI
Coach Ratings – Season Wins
CSWM
Coach Ratings – Season's Biggest Winning Margin???????
CSXP
Coach Portrait ID
CTIZ
City Time Zone ????
cu2y
20+ Yds
cuat
Rush Att
cubt
Broken Tackles
cufu
Fumbles
culN
Rush Long
cutd
Rush TD
cuya
Rush Yds
cuyh
After 1st Hit
CYID
City ID
CYNM
City Name
CYNP
City Newspaper
CYST
State
ddep
Depth Chart Order
DGID
Division ID
DGRA
Draft Grade
DISN
Division Place
DNAM
DIVISION NAME
DRND
Round Number (0 Index)
DRTY
Drill Type
DRYR
Last Names for Draft Class
DTRP
Drill Trophy
ENUN
Position
ETXT
EVENT TEXT
EVIM
EVENT IMPORTANCE
EVTX
KEY
FABD
Favorite Offer on the Table
FCHL
Fan Hair Color
FCTX
GAME PLANNING TEXT
fmtx
{C}formation layout graphic
fmty
{C}formation layout graphic
FPTN
UNIFORM PART (?)
FRID
Franchise ID
FSKN
Fan Skin Color
gaat
Pass Att.
gacc
Pass Comp.
gacm
Pass Comp.
gADV
GAME PLANNING TEXT
gafd
First downs
gain
INT Thrown
galN
Pass Long
gasa
Times Sacked
GASC
Away Team Score. Found in GINF table.
This contains the value of the visiting team's score in an in-progress game.
gatd
Pass TD
GATG
Away Team TGID
GATO
Away Team Time Outs. Found in GINF table.
This contains the value of the visiting team's remaining time-outs in an in-progress game.
gaya
Pass Yds
gcca
Catches
gcdr
Drops
gcrL
Rec. Long
gctd
Rec. TD
gcya
Rec. Yds
gcyc
YAC
GDAT
Day of the Week; 0 Thurs, 1 Fri, 2 Sat, 3 Sun, etc.
gdpd
passes defended
gdta
tackles
gdtl
Tackle for Loss
GFHU
User played game????
GFOT
Game went into OT (for weekly scores/schedule)
GFTG
Thanksgiving Day Game, 1=yes, 0=no
ggmP
Games Played
ggmS
Games Started
GHSC
Home Team Score. Found in GINF table.
This contains the value of the home team's score in an in-progress game.
GHTG
Home Team TGID
GHTO
Home Team Time Outs. Found in GINF table.
This contains the value of the home team's remaining time-outs in an in-progress game.
gkaa
FGA 1-29
gkac
FGA 30-39
gkad
FGA 40-49
gkae
FGA 50+
gkea
XPA
gkeb
XP Blocked
gkem
XPM
gkfa
FGA
gkfb
FG Blocked
gkfL
FG Long
gkfm
FGM
gkma
FGM 1-29
gkmc
FGM 30-39
gkmd
FGM 40-49
gkme
FGM 50+
gknk
Kickoffs
gktb
Touchbacks
glbl
Blocks
glff
Forced Fumble
glfr
Fumble Recov.
glft
Fumble Rec. TD
glfy
Fumble Return Yards
glsa
Safety
glsk
Sacks
gopa
Pancakes
gosa
Sacks Allowed
gpat
Punts
gpbl
Punts Blocked
gplN
Punt Long
gpny
Net Yds
gppt
Inside 20
gptb
Touchbacks (punts)
gpya
Yards (punt)
GQTR
Game Quarter
grka
Kick Return Attempts
grkL
Kick Return Long
grkt
Kick Return TD
grky
Kick Return Yards
grpa
Punt Return Attempts
grpL
Punt Return Long
grpt
Punt Return TD
grpy
Punt Return Yards
gsin
INT
gsit
INT for TD
gsiy
INT yards
gslR
INT Long
GSTA
0 = postseason not including Pro Bowl, 1 = everything else
GTIM
Time Left In Quarter (seconds)
GTOD
Game Time of Day (minutes past midnight)
gu2y
20+ Yds
guat
Rush Att
gubt
Broken Tackles
gufu
Fumbles
gulN
Rush Long
gutd
Rush TD
guya
Rush Yds
guyh
After 1st Hit
INGI
In Game Injury
INIR
Injury Reserve
INJL
Injury Length
INJT
Injury Type
IWAS
Interview Responses
IWQS
Interview Questions
LGID
League ID
LNAM
LEAGUE NAME
MALN
ALBUM NAME
MARN
ARTIST NAME
MCDD
MADDEN CARD NUMBER
MCDS
CARD DESCRIPTION
MCID
MADDEN CARD ID
MCMC
TEXT
MCMI
MADDEN CARD TEXT ID
MCNm
MADDEN CARD – PLAYER NAME
MCUI
HOW TO EARN MADDEN CARD
MDIR
MOVIE DIRECTOR
MPRO
MOVIE PRODUCER
MRDS
RECORD DATE
MRHN
RECORD HOLDER NAME
MRID
MADDEN RECORD ID
MRNA
MADDEN RECORD NAME
MRON
RECORD OCCURRED AGAINST
MRUN
RECORD USER
MRVA
RECORD AMOUNT
MSON
SONG NAME
MSTI
MADDEN SOUNDTRACK ID
MSTN
MADDEN SOUNDTRACK NAME
MTXT
MADDEN TEXT
MVNM
MOVIE NAME
MVPT
MOVIE DESCRIPTION
OAAC
CPU QB Accuracy
OAAW
CPU Awareness
OADB
CPU Break Tackle
OADK
CPU Knockdown
OAFA
CPU FG Accuracy
OAFL
CPU FG Strength
OAIN
CPU INT
OAKL
CPU Kickoff Strength
OAOP
CPU Pass Blocking
OAPA
CPU Punt Accuracy
OAPL
CPU Punt Strength
OARA
CPU RB Ability
OARB
CPU Run Blocking
OARC
CPU WR Catching
OATA
CPU Tackling
OGID
Opponent Team ID
OGRN
Item being sold
OPCL
Penalty Clipping
OPDP
Penalty Def. Pass Interference
OPFM
Penalty Face Mask
OPFS
Penalty False Start
OPHO
Penalty Holding
OPIG
Penalty Intentional Grounding
OPOP
Penalty Off. Pass Interference
OPPI
Penalty KR/PR Catch Interference
OPRK
Penalty Roughing Kicker
OPRP
Penalty Roughing Passer
OQLN
Quarter Length
ORPS
TEAM RELOCATE
OSMB
PROFAINE WORD
OWFA
ATTENDANCE % - 1=0; 101=100; 100%=5.00M
OWFE
Franchise Mode – Fan Expectations
OWFN
City Specific Merchandise for Fan Appreciation Day
OWFS
FAN SUPPORT
OWGA
Prices
OWGP
PRICE
OWGT
Item order
OWGT
ITEM
OWIC
INCOME CONCESSIONS
OWID
Owner ID
OWIM
INCOME MERCHANDISE
OWIP
INCOME PARKING
OWIT
INCOME TICKETS
PAat
Award Description
PACC
Acceleration
PAGE
Player Age
PAGI
Agility
PAGW
Agility
PAWR
Awareness
PAWW
Awareness
PBRE
Nasal Strip
PBTK
Broken Tackle
PBTW
Breaking Tackles
PCAR
Carrying
PCHS
Pad Shelf
PCOL
College ID
PCON
Original Contract Years
PCPH
Skin Color
PCSA
Contract Offer Total Salary
PCTH
Catching
PCYL
Contract Years Left
PDPI
Draft Pick #
PDRO
Round drafted
PDRP
Position at Draft
PEBO
EXPECTED SIGNING BONUS
PECL
EXPECTED CONTRACT LENGTH
PEGO
Player Ego
PESA
EXPECTED SALARY
pEXP
Super Star Mode – Starting Exposure out of college
PEYE
Eye paint
PFAS
Arm Fat
PFCS
Leg Fat
PFEx
Face ID
PFHS
Thigh Fat
PFMK
Face mask
PFNA
Player First Name
PFPB
Pro Bowl
PFTS
Body Fat
PGID
Player ID
PGSL
Sleeves
PHAN
Prefered Hand
PHCL
Hair Color
PHED
Hair Style
PHGT
Height
PHLM
Helmet
PI34
PRIMARY DEFENSE 3-4, 1=YES, 0=NO
PICN
Icon
PIMP
Importance
PINJ
Injury
PINW
Injury
PJEN
Jersey #
PJMP
Jump
PKAC
Kick Accuracy
PKPR
Kick Power
PKRT
Kick Return
PLEL
Left elbow
PLHA
Left Hand
PLNA
Player Last Name
PLSB
this is the position number of the position you want to be able to sub INTO another position
PLSH
Left Shoe
PLSS
Shoes
PLTH
Left Knee
PLWR
Left Wrist
PMAS
Arm muscle
PMCS
Leg Muscle
PMHS
Thigh Muscle
PMOD
Player Attribute to be Modified
PMOR
Morale
PMPC
Mouthpiece
PMTS
Body Weight
PMUS
Body Muscle
PNEK
Neck pad
POID
Player ID
POPS
Original Position ID
POVR
Player Overall
PPBK
Pass Block
PPER
Position Percentage --> This is the probability for each generated player from each draft class that they will be
a certain position.
PPIA
Number of player required at position
PPIM
Position Priority
PPIR
Number of players required at position to start game
pPOP
Super Star Mode – Starting Popularity out of college
PPOS
Player Position
0 – Quarterback
1 – Runningback
2 – Fullback
3 – Wide Receiver
4 – Tight End
5 – Left Tackle
6 – Left Guard
7 – Center
8 – Right Guard
9 – Right Tackle
10 – Left Defensive End
11 – Right Defensive End
12 – Nose Tackle
13 – Left Outside Linebacker
14 – Middle Linebacker
15 – Right Outside Linebacker
16 – Cornerback
17 – Free Safety
18 – Strong Safety
19 – Kicker (Field Goals & Extra Points only)
20 – Punter
21 – Kickoff Returner
22 – Punt Returner
23 – Kickoff (usually the Kicker)
24 – Long Snapper
25 – Third Down Running Back
PPTI
Acquired From
PRBK
Run Block
PRCT
ROOKIE SCOUT COMMENT
PREL
Right elbow
PRHA
Right Hand
PRL2
Player Role 2
PRMA
Player Rating Maximum
PRMI
Player Rating Minimum
PRNM
Role Name
PROL
Player Role ID
PRSH
Right Shoe
PRTH
Right Knee
PRTX
PLAYER RETIREMENT TEXT
PRWR
Right Wrist
PSBO
Player Signing Bonus
PSBS
Body Build Overall
PSEW
Speed
PSKI
Skin Color ID
PSPD
Speed
PSTA
Stamina
PSTR
Strength
PSTY
Throwing Style
PSXP
Portrait ID
PTAK
Tackling
PTAL
Tatoo Left
PTAR
Tatoo Right
PTAW
Throwing Accuracy
PTEN
Player Tendency
PTGH
Toughness
PTHA
Throw Accuracy
PTHP
Throwing Power
PTPW
Throwing Power
PTSA
Total Salary
PTSL
Sleeves 2
PVCO
Contract Years
PVIS
Visor
PVSB
Signing Bonus
PWGT
Weight
pXPC
Super Star Mode – Starting Expectations out of college
PYRP
Player Years Pro
QSA1
ANSWER CHOICE 1
QSA2
ANSWER CHOICE 2
QSA3
ANSWER CHOICE 3
QSS1
POINTS WITH THIS ANSWER
QSS2
POINTS WITH THIS ANSWER
QSS3
POINTS WITH THIS ANSWER
QSTX
IQ TEST QUESTION
RFA1
Restricted Free Agent Tender Amount level 1 (lowest)
RFA2
Restricted Free Agent Tender Amount level 2
RFA3
Restricted Free Agent Tender Amount level 3
RFA4
Restricted Free Agent Tender Amount level 4 (highest)
RINF
WEBMASTER PAINTING DESCRIPTION
RLNM
ROLE NAME
RLTX
ROLE DESCRIPTION TEXT
ROLE
ROLE ID
RTST
RATING CATEGORY
saat
Pass Att.
sacm
Pass Comp.
safd
First downs
sain
INT Thrown
salN
Pass Long
SAMU
Salary Monetary Units (increasing/decreasing amount you can adjust contract offers)
sasa
Times Sacked
satd
Pass TD
saya
Pass Yds
SCAD
Salary Cap Amount
SCAP
Seating Capacity
SCBU
Marks if the Scouting Notes are unlocked for this player or not (1: unlocked, 0: locked)
scca
Catches
SCCS
Club Seats
scdr
Drops
SCID
SCRIPT ID
SCLB
Luxury Box
SCLL
Lower Level
SCML
Mid Level
SCPC
Salary Cap Percent
scrL
Rec. Long
sctd
Rec. TD
SCUE
Upper Endzone
SCUL
Upper Level
scya
Rec. Yds
scyc
YAC
sdpd
Passes defended
sdta
tackles
sdtl
Tackles for loss
SESI
The seasons in (?). The value is 0 for the first set (first year schedule) and changes to 1 for the second year's
schedule
SEST
9 if preseason, 0 elsewise
SETL
formation set
SEWN
Season Week Number
SEWT
Weight of the game, 0 preseason, 25 regular season, 50 wildcard, 75 divisional, 100 conference, 125 SB, 150 Pro
Bowl
175=the offseason
SEYL
Season Year
SEYR
Season Year
SFTY
Stadium field type: 0 grass, 1 turf, 2 deceiver, 3 atlantis (tridents), 4 dummy, 5 glacier, 6 grassy turf
SGF_
base locations & shifts
SGID
Stadium ID
sgmp
Games Played
sgms
Games Started
SGNM
Game Number; The place it appears on the list in franchise mode
SgYY
Team ID for Past Years Stats
sgYY
TEAM ID
SIMI
Sim Injury
skaa
FGA 1-29
skac
FGA 30-39
skad
FGA 40-49
skae
FGA 50+
skea
XPA
skeb
XP Blocked
skem
XPM
skfa
FGA
skfb
FG Blocked
skfL
FG Long
skfm
FGM
skma
FGM 1-29
skmc
FGM 30-39
skmd
FGM 40-49
skme
FGM 50+
sknk
Kickoffs
sktb
Touchbacks
slbl
Blocks
slff
Forced Fumbles
slfr
Fumble Rec.
slft
Fumble Rec for TD
slfy
Fumble Rec Yds
SLID
SCRIPT LINE ID
slsa
Safety
slsk
Sacks
SLTX
SCRIPT TEXT
SMAD
Max. Yearly Contract Value
SMID
MINIMUM CONTRACT
SNAM
Stadium Name
SNTE
SCOUTING NOTES TEXT
sopa
Pancakes
sosa
Sacks Allowed
SP00
N. Endzone 1st Deck
SP01
N. Endzone 2nd Deck
SP02
N. Endzone 3rd Deck
SP03
1st Deck NW Corner
SP04
1st Deck NE Corner
SP05
S. Endzone 1st Deck
SP06
S. Endzone 2nd Deck
SP07
S. Endzone 3rd Deck
SP08
1st Deck SW Corner
SP09
1st Deck SE Corner
SP10
E. Sideline 1st Deck
SP11
E. Sideline 2nd Deck
SP12
E. Sideline 3rd Deck
SP13
W. Sideline 1st Deck
SP14
W. Sideline 2nd Deck
SP15
W. Sideline 3rd Deck
SP16
Roof Lights
SP17
Roof
SP19
Info Endzone Walls
SP20
Info Sideline Pattern
SP21
Grass Type (tested = wrong)
SP24
Endzone Background
SP25
Background
spat
Punts
spbl
Punts Blocked
SPGE
SCRIPT PAGE
splN
Punt Long
SPNM
First Names for Draft Class
spny
Net Yds
sppt
Inside 20
sptb
Touchbacks
spya
Yards (punt)
srka
Kick Return Attempts
srkL
Kick Return Long
srkt
Kick Return TD
srky
Kick Return Yards
srpa
Punt Return Attempts
srpL
Punt Return Long
srpt
Punt Return TD
srpy
Punt Return Yards
ssca
Catches Allowed
SSSC
YARDS ON DRIVE -50 = 100 yds, 50 = 0 yds
SSCT
Times you ran a rookie drill with that player (0 for 1 time, 1 for 2 times etc.)
SSDE
Time of Possession (seconds)
SSDP
Number of Plays
ssin
INT
ssit
INT for TD
ssiy
INT Yds
sslR
INT Long
SSNE
STADIUM NAME
SSPT
EXTRA POINT 10=XP missed; 11=2pt fail; 13=XP good; 14=2pt good; 16=no extra point
SSPY
Yards on Play
SSTE
Super Bowl site: SGID then refers to stadium of upcoming Super Bowls in franchise mode
SSTI
PGID of scorer
SSTY
Score Type 0=TD Pass; 1=TD run; 3=Fumble Rtn TD; 5=INT Rtn TD; 6=KR TD; 7=PR TD; 9=Safety
STID
UPGRADE ID
STUC
UPGRADE COST
STUM
Annual Expense
STUN
UPGRADE NAME
STVL
Record
su2y
20+ Yds
suat
Rush Att
subt
Broken Tackles
SUDE
UPGRADE DESCRIPTION
sufu
Fumbles
sulN
Rush Long
sutd
Rush TD
suya
Rush Yds
suyh
After 1st Hit
SWEN
Season Week
SYRO
Stadium Years Old
TB2B
Team Background 2nd color, Blue value
TB2G
Team Background 2nd color, Green value
TB2R
Team Background 2nd color, Red value
TBCB
Team Background Color (primary), Blue value
TBCG
Team Background Color (primary), Green value
TBCR
Team Background Color (primary), Red value
TCLO
All Time Losses
TCP0
Team Salary Cap Penalty Current Year (1=$10k)
TCP1
Team Salary Cap Penalty Next Year (1=$10k)
TCTI
All Time Ties
TCWI
All Time Wins
TDNA
Team Name
TDPB
Team Defense Playbook
TDRI
Team Default Roster Number
TEDS
TEAM DESCRIPTION
TEVN
COMMENTS FROM PLAYERS ON TEAM EVENTS
TEZ1
Team Endzone 1
TEZ2
Team Endzone 2
TF00
Bears Offer (yes=1, no=0)
TF01
Bengals Offer (yes=1, no=0)
TF02
Bills Offer (yes=1, no=0)
TF03
Broncos Offer (yes=1, no=0)
TF04
Browns Offer (yes=1, no=0)
TF05
Buccaneers Offer (yes=1, no=0)
TF06
Cardinals Offer (yes=1, no=0)
TF07
Chargers Offer (yes=1, no=0)
TF08
Chiefs Offer (yes=1, no=0)
TF09
Colts Offer (yes=1, no=0)
TF10
Cowboys Offer (yes=1, no=0)
TF11
Dolphins Offer (yes=1, no=0)
TF12
Eagles Offer (yes=1, no=0)
TF13
Falcons Offer (yes=1, no=0)
TF14
49ers Offer (yes=1, no=0)
TF15
Giants Offer (yes=1, no=0)
TF16
Jaguars Offer (yes=1, no=0)
TF17
Jets Offer (yes=1, no=0)
TF18
Lions Offer (yes=1, no=0)
TF19
Packers Offer (yes=1, no=0)
TF20
Panthers Offer (yes=1, no=0)
TF21
Patriots Offer (yes=1, no=0)
TF22
Raiders Offer (yes=1, no=0)
TF23
Rams Offer (yes=1, no=0)
TF24
Ravens Offer (yes=1, no=0)
TF25
Redskins Offer (yes=1, no=0)
TF26
Saints Offer (yes=1, no=0)
TF27
Seahawks Offer (yes=1, no=0)
TF28
Steelers Offer (yes=1, no=0)
TF29
Texans Offer (yes=1, no=0)
TF30
Vikings Offer (yes=1, no=0)
TF31
Titans Offer (yes=1, no=0)
TFID
Training Staff ID
TFKN
Training Staff Knowledge
TFNM
Training Staff Name
TFPN
Training Staff Prevention
TFRC
Training Staff Recovery
TFSA
Training Staff Salary
TFYL
Training Staff Contract Years Left
TGID
Team ID
TLEL
Left elbow
TLGL
Team Logo
TLGS
Team Roster Management Helmet
TLHA
Left Hand 2
TLNA
Team Long name
TLSA
?
TLWR
Left Wrist 2
TMNC
Team Nickname
TMSA
Team Salary
TOID
Team Official ID
TOPB
Team Offense Playbook
TORD
Team Roster Management Order
TRDB
Team Rating DB
TRDE
Team Rating DEF
TRDL
Team Rating DL
TREL
Right elbow
TREP
Team Reputation
TRHA
Right Hand 2
TRIV
Rival ID
TRLB
Team Rating LB
TROF
Team Rating OFF
TROL
Team Rating OL
TROV
Team Rating OVR
TRQB
Team Rating QB
TRRB
Team Rating RB
TRST
Team Rating ST
TRV1
Rival 1
TRV2
Rival 2
TRV3
Rival 3
TRWR
Right Wrist 2
TSCS
Team Season Current Streak
TSIX
Record Description
TSLO
Team Season Loss
TSLW
Team Season Wins
TSNA
TEAM SHORT NAME
TSRL
3 if you don't make playoffs, 2 if you make but lose, 1 if you lose the superbowl, 0 if you win the superbowl
TSRO
Team Season Record Loses
TSRW
Team Season Record Wins
TSTI
Team Season Ties
TSWI
Team Season Wins
TTYP
Team Type
TWRR
Team Rating WR
UCHL
Uniform Custom Helmet Logo
"0"=no logo
"1"= logo both sides facing forward
"2"=logo both sides diferent directions
UDCH
Uniform Decal Chest/Hips
"0"=no decal
"1"= decal at upper left chest.
"2"= decal on both hips facing forward
"3"= decal on both hips facing different directions
UDSL
Uniform Decal Sleeve
0 = no decals
1 = decals face opposite directions (for names)
2 = decals face forward (for symbols)
UFID
Uniform ID
UHNB
Uniform Helmet Number Back
0 = no number 1 = left 2 = right 3 = center 4 = center 5 = center
UHNF
Uniform Helmet Number Front
0= no number 1= number centered
ULTF
Uniform Label Team Favorite
UNUM
Uniform number (on shoulder)
"0" is big top shoulder
"1" is outer sleeve
"2" is sm top shoulder
"3" is no numbers
"4" is outer sleeve
"5" is big top shoulder
URID
Pricing ID
TPST
Prior Season Ties
TPSL
Prior Season Losses
TPSW
Prior Season Wins
tsTy
Total Yards – Team Stats
tsoy
Total Offense – Team Stats
tsop
Total Passing Yards – Team Stats
tsor
Total Rushing Yards – Team Stats
tdPt
TD Passing – Team Stats
tdrt
TD Rushing – Team Stats
ts1d
1st Downs – Team Stats
ts3d
3rd Down Attempts – Team Stats
ts3c
3rd Down Conversions – Team Stats
ts4d
4th Down Attempts – Team Stats
ts4c
4th Down Conversions – Team Stats
tssa
Sacks Allowed – Team Stats
tsdp
Passing Yds Allowed – Team Stats
tsdy
Rushing Yds Allowed – Team Stats
tssk
Sacks – Team Stats
tsDi
Defensive INT – Team Stats
tsfr
Fumbles Recovered – Team Stats
tspi
INT Thrown – Team Stats
tsfl
Fumbles Lost – Team Stats
PVTS
Total Salary
PORI
0=offense, 1=defense, 2=special teams
PLA1
Attribute (relates to subs) 0 – Strength; 1 – Agility; 2 – Speed; 3 – Acceleration; 4 – Awareness; 5 – Catching; 6
– Carrying; 7 – Throw Power; 8 – Throw Accuracy; 9 – Kick Power; 10 – Kick Accuracy; 11 – Breaking Tackles; 12 –
Tackling; 13 – Pass Blocking; 14 – Run Blocking; 15 – Jumping; 16 – Kick Return
PLA2
Attribute (relates to subs) 0 – Strength; 1 – Agility; 2 – Speed; 3 – Acceleration; 4 – Awareness; 5 – Catching; 6
– Carrying; 7 – Throw Power; 8 – Throw Accuracy; 9 – Kick Power; 10 – Kick Accuracy; 11 – Breaking Tackles; 12 –
Tackling; 13 – Pass Blocking; 14 – Run Blocking; 15 – Jumping; 16 – Kick Return
PLA3
Attribute (relates to subs) 0 – Strength; 1 – Agility; 2 – Speed; 3 – Acceleration; 4 – Awareness; 5 – Catching; 6
– Carrying; 7 – Throw Power; 8 – Throw Accuracy; 9 – Kick Power; 10 – Kick Accuracy; 11 – Breaking Tackles; 12 –
Tackling; 13 – Pass Blocking; 14 – Run Blocking; 15 – Jumping; 16 – Kick Return
PLP1
% of attribute reduction (relates to subs)
PLP2
% of attribute reduction (relates to subs)
PLP3
% of attribute reduction (relates to subs)
DPTG
Depth Chart Tier (relates to subs)
GACH
Away Team Challenges. Found in GINF table.
This contains the number of challenges remaining for the visiting team in an in-progress game.
GHCH
Home Team Challenges. Found in GINF table.
This contains the number of challenges remaining for the home team in an in-progress game.
PCMT
Comments about player for in-game commentary.
MCSA
5 = training camp; 7 = preseason; 9 = season including playoffs; 12= advance to owner mode off season; 14= owner
mode offseason; 15= roster management; 17= pre free agency; 18= 1st free agency (note, FAIN and FAPL become active
during this time, containing info about the days left in free agency and the list of players); 20= rookie workouts
stage; 21= nfl draft
NDAT
Translates into player involved in a transaction
PJTY
First Name Initial On Jersey (0=none 1=one 2=two 3=three)
Here is the list in .xls...
- StingRay68
- Hall of Fame
- Posts: 1073
- Joined: Mon Jan 09, 2012 7:23 pm
Re: Definition File Update
Madden amp comes with a field definitions file, I think in excel format... would be nice to get all of this info consolidated in it at some point...
btw what are you guys using to edit the DB files? The Madden Db editor I tried either locks up or is so slow loading a file I end up giving up...
btw what are you guys using to edit the DB files? The Madden Db editor I tried either locks up or is so slow loading a file I end up giving up...
- Attachments
-
- Table-Fields.zip
- (252.91 KiB) Downloaded 226 times
Re: Definition File Update
StingRay68 wrote:btw what are you guys using to edit the DB files? The Madden Db editor I tried either locks up or is so slow loading a file I end up giving up...
I had the same problem that's why i switched back to XP. The db editor 2 does not work with windows 7 (framework issues maybe) and the db editor 3 does work in windows 7 but it just takes too long.
Who is online
Users browsing this forum: No registered users and 4 guests