Definition File Update

Technical discussion of development of third-party apps.
User avatar
valvegas1
All-Pro
Posts: 183
Joined: Sat Oct 08, 2011 2:29 am
Location: Hillsdale, MI

Definition File Update

Postby valvegas1 » Tue Sep 17, 2013 9:22 am

Not sure how many people have actually taken time to figure out definitions for the DB editor but i have compiled 830 of them so far and compiled them int a new file for the DB editor...Just thought i would share what i have with the community

Code: Select all

"MC(xx)","Madden Cards"
"PRFW","Foul Words"
"CCDS","Button Actions"
"MREC","Default records"
"PLAB","Playbooks"
"EVBN","controller assignments"
"UNIF","Uniform ID"
"PLPS","Positional info"
"SBHY","Super Bowl History"
"SCHD","Schedule"
"DRPS","Depth Chart Info"
"PCAW","Catching"
"PKAW","Kick Accuracy"
"PPBW","Pass Blocking"
"PRBW","Run Blocking"
"PACW","Acceleration"
"PTCW","Tackling"
"PKPW","Kicking Power"
"PCRW","Carrying"
"PKRW","Kick Returning"
"PSTW","Strength"
"PJUW","Jumping"
"DCHT","Depth Chart"
"PLAY","Players"
"TUNI","Uniforms"
"TEAM","Team Info"
"UCRF","User Created Fan"
"PSOL","Player Stats Offensive Line"
"PSOF","Player Stats Offense"
"PSNG","Player Started In Game"
"PSKP","Player Stats Kick/Punt Return"
"PSKI","Player Stats Kicking"
"PSDE","Player Stats Defense"
"PCOL","Player Career O-Line"
"PCOF","Player Career Offense"
"PCNG","Player Career In Game"
"PCKP","Player Career Kick/Punt Return"
"PCKI","Player Career Kicking"
"PCDE","Player Career Defensive"
"SgYY","Team played for during stat year"
"COCH","Coaches"
"INJY","Injuries"
"Tccc","credits"
"Pld","credits"
"WLQS","IQ Test"
"ASPP","min/max assigned players at a position"
"ASNN","min. players assigned to position on depth chart"
"ENUN","positions"
"ASPO","position number"
"ENVU","position number"
"cMON","months for Madden"
"CTLC","all time teams"
"CTLG","Create-a-team names"
"EXDI","division terminology"
"FNTP","Create-a-fan"
"OWCP","owner mode stuff"
"PCOS","endorsement info"
"PRCT","main scouting table"
"PRMA","player rating max"
"PRCD","record number (just a counter)"
"PRMI","player rating min"
"PRCT","comments"
"PATT","ID for various rating categories"
"SGAC","rookie grades for scouting report"
"SCAR","info for rookies"
"SCPC","Salary Cap Percent"
"DRND","draft round"
"OWAC","advisor comments in owner mode"
"OCRC","what coaches say when retiring in franchise mode in offseason"
"OWNC","text under Coach Options->Ratings"
"SSNE","Companies for naming stadium"
"CART","Custom Art"
"DCSB","Player Substitutions"
"PLSB","position number of player you want to sub into PPOS"
"DPTG","order of depth chart auto-fill -> 0 is 1st; 1 is 2nd; ect."
"ACTX","OWNER COMMENTS TEXT"
"AGCX","AGENT COMMENT TEXT"
"artx","pbor graphic"
"arty","pbor graphic"
"ASNN","Minimum Number of Players Assigned to Position"
"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"
"cain","INT Thrown"
"calN","Pass Long"
"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)"
"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","CRID"
"CRcd","CRHEADER"
"CRDB","Coach Rating DB"
"CRde","CRNAME"
"CRDL","Coach Rating DL"
"CREG","City Region"
"CRid","CRNAME 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"
"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","formation layout graphic"
"fmty","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"
"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"
"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=QB,1=HB,2=FB,3=WR,4=TE,5=LT,6=LG,7=C,8=R,9=RT,10=LE,11=RE,12=DT,13=LOLB,14=MLB,15=ROLB,16=CB,17=FS,18=SS,19=K,20=P,21=KR,22=PR,23=KO,24=LS,25=TDRB)"
"PPTI","Acquired From"
"PRBK","Run Block"
"PREL","Right elbow"
"PRHA","Right Hand"
"PRL2","Player Role 2"
"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"
"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."
"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"
"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"
"SEYL","Season Year"
"SEYR","Season Year"
"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"
"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"
"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"
"SSPT","EXTRA POINT 10=XP missed; 11=2pt fail; 13=XP good; 14=2pt good; 16=no extra point"
"SSPY","Yards on Play"
"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"
"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","Team Short Name"
"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"
"UDCH","Uniform Decal Code Hip"
"UDSL","Uniform Decal Sleeve"
"UFID","Uniform ID"
"UHNB","Uniform Helmet Number Back"
"UNHF","Uniform Helmet Number Front"
"UNUM","Uniform number....not sure if it's a type or where the number appears on the uniform"
"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)"
"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."
"COLL","Colleges"
"SROK","Superstar Rookies"
"MUSO","Soundtrack Track Listing"
"MUST","Soundtrack Title"
"LDPC","Loading Screen Labels"
"AGCM","Contract Negotiation Comments"
"PYRA","Player Regression"
"PWRA","Player Progression"
"PGAC","Acceleration"
"PGAG","Agility"
"PGSM","Stamina"
"PGIN","Injury"
"PGKP","Kick Power"
"PDRP","Position at Draft (0=QB,1=HB,2=FB,3=WR,4=TE,5=T,6=G,7=C,8=DE,9=DT,10=OLB,11=MLB,12=CB,13=FS,14=SS,15=K,16=P)"
"PYRP","Years Played"
"PGSP","Speed"
"PGTP","Throwing Power"
"PRGR","Player Rating Group (based on overall rating 0=90+,1=82-89,2=76-81,3=70-75,4=60-69,5=<59)"
"PGST","Strength"
"PGJU","Jumping"
"ggmP","Games Played"
"ggmS","Games Started"
"ggdp","Points gained ( For calculating progression )"
"PSTP","points gained or lost for stat( for calculating progression )"
"PSTT","Stat Type"
"PGCA","Carry"
"PGKA","Kick Accuracy"
"PGSA","Stamina"
"PGTA","Throw Accuracy"
"PGPB","Pass Blocking"
"PGRB","Run Blocking"
"PPRD","Progression Round"
"PGTK","Tackling"
"PGKR","Kick Returning"
"PGBT","Break Tackle"
"PGCT","Catch"
"PGAW","Awareness"


You should be able to edit the .def file with notepad++ and just copy and paste this in and save it...it's tested and works fine for me...any questions feel free to ask

Also attached is the actual file ready to be dropped into you editors folder
Attachments
definitions.rar
(8.43 KiB) Downloaded 533 times

Definition File Update

Sponsor

Sponsor
 

User avatar
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

Postby slydways » Tue Sep 17, 2013 11:33 am

Nice job ...thanks...

Here are some from some years ago...and this list has been updated..

http://ffmadden.wikia.com/wiki/Database_field_definitions

"UNHF","Uniform Helmet Number Front" ...will not show up unless corrected to UHNF .
"UNUM","Uniform number....not sure if it's a type or where the number appears on the uniform"...has also been explained..see here... ( and the FF site)

http://www.footballidiot.com/forum/viewtopic.php?f=13&t=14495&p=36922#p36922

User avatar
NickyJ
Hall of Fame
Posts: 2713
Joined: Wed Jul 20, 2011 7:09 pm
Location: Virginia
Contact:

Re: Definition File Update

Postby NickyJ » Tue Sep 17, 2013 11:51 am

"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.
Image

User avatar
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

Postby slydways » Tue Sep 17, 2013 2:34 pm

Question: You have the following acronyms on your list...

CASH
CASO
CADH
CADO

I can't find them in a DB file...can you please tell me in what file and table I could find them? Like DB TEMPLATES #12, table UNIF? or #6 ,table CITY?or a roster file or Franchise file?...Thanks

Also ...found this on the FF site ( my copy has been updated by someone )...

DB_TEMPLATES.dat is the file that contains much of the information used when playing Madden.


Using the DAT File Replacer you can see there are 14 files within this .dat file. Each of those 14 contain additional files. Through years of research it was discover that these 14 files servers the following purposes:

1 Playbook Template
2 Saved Exhibition Game Template
3 Custom Team File Template
4 Franchise Template
5 Controller mapping,online language bans,cards,drills.
6 Roster Template (including default roster)
7 Conferences,Divisions,Nicknames
8 Schedule Template (including schedule for 1st year of franchise)
9 Settings.db
10 Spawn Game Template
11 blank tables
12 Uniform Info
13 no data (null file)
14 User Profile Template


Now all we have to do is match up all the acronyms (i.e. CART) with the File and Table they are located in. That shouldn't take more that a year or two. :o

mike9472
MVP
Posts: 690
Joined: Sun Jul 24, 2011 8:46 pm

Re: Definition File Update

Postby mike9472 » Tue Sep 17, 2013 5:50 pm

Some of these are wrong unless they're not for Madden 08. For example PCOL = Player College PPBK = Player Pass Block PRBK = Player Run Block

User avatar
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

Postby slydways » Tue Sep 17, 2013 8:51 pm

Yea ...it almost looks like the old database definitions file from FF without any of the recent updates or corrections. Anyway here is valvegas1's file saved as a .cvs and alphabetical for easier access.
Definitions Alphabetical.zip
(8.76 KiB) Downloaded 686 times


For more on this...go to collegefootballpc

(link removed)

User avatar
valvegas1
All-Pro
Posts: 183
Joined: Sat Oct 08, 2011 2:29 am
Location: Hillsdale, MI

Re: Definition File Update

Postby valvegas1 » Tue Sep 17, 2013 9:58 pm

Hey slydways those you were questioning are in the actual franchise file when opened in db editor...they are for modding the cities you can move to i believe they are under the CITY fields...been a while since i messed with those though...the only madden game i own is 08 so all these are ones that i use and know work for this game and how i've seen them work for me...should be fairly accurate...there are a few i was uncertain of though but i did my best

User avatar
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

Postby slydways » Tue Sep 17, 2013 10:07 pm

Thanks vegas...I wanted to make my teams in exhibition always play in cold weather ( by default ) so I could see the sleeves. But from what you are saying ...those tables only work in Franchise... I'm out of luck...Thanks though... ;)

User avatar
valvegas1
All-Pro
Posts: 183
Joined: Sat Oct 08, 2011 2:29 am
Location: Hillsdale, MI

Re: Definition File Update

Postby valvegas1 » Tue Sep 17, 2013 10:21 pm

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

User avatar
valvegas1
All-Pro
Posts: 183
Joined: Sat Oct 08, 2011 2:29 am
Location: Hillsdale, MI

Re: Definition File Update

Postby valvegas1 » Tue Sep 17, 2013 10:27 pm

slydways wrote:Thanks vegas...I wanted to make my teams in exhibition always play in cold weather ( by default ) so I could see the sleeves. But from what you are saying ...those tables only work in Franchise... I'm out of luck...Thanks though... ;)

yeah in my work with figuring out how to mod the relocation cities i found that half the stuff is in the man DB template and the rest of it is inside the actual franchise files...suck that it is set up that way cause custom relocation cities can only be modded for each specific franchise file instead of just being modded and available for all franchises right away...the i believe the only way to edit the teams weather is in the actual franchise files but i will double check that for you

Edit: i checked on CASH, CASO, CADH, CADO for you and they are in the main dbtemplate file under the OWCI table, you'll need to go into a franchise to figure out your teams id number to know which to edit though


Return to “Development”

Who is online

Users browsing this forum: No registered users and 1 guest