Madden Xtreme DB Editor

User avatar
elguapo
Hall of Fame
Posts: 3333
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX

Madden Xtreme DB Editor

Postby elguapo » Sat Jan 26, 2019 9:21 pm

The Madden Xtreme DB Editor was compiled on Windows 11, Visual Studio 2022 C#.
1/8/25

DBTab.jpg
DBTab.jpg (332.54 KiB) Viewed 3903 times


Image

Use at your own risk, no "customer support", backup your files.


FEATURES
  • Optimized to read/write through records.
  • Definitions file. (definitions.csv) inspired by valvegas1 (required)
  • Import/Export multiple tables at once.
  • Configuration file. (MXDBE.ini) (optional)
  • Import/Export comma (*.csv)/tab (*.txt) delimited TABLES.
  • Copy/add/delete/import/export individual records.
  • Import/Export custom column TABLES. Reorder the columns any way you want and export the TABLE in the same order.
  • Edits are not permanent until you save the file.
  • Edit possible emulator console files. (2004 - 2020)
  • Unsupported column types are tdbBinary, tdbVarchar and tdbLongVarchar.
  • Customize the DB editor with your team colors.
  • Import/Export MDC files. (Draft Classes)

Customize with Team colors
Spoiler:
EaglesTeamColors.jpg
EaglesTeamColors.jpg (303.2 KiB) Viewed 3903 times


Preview Video
https://rumble.com/v5c5du2-xtreme-db-editor-feature-preview-8232024.html


StingRay68 wrote:Update for Madden21 :

Madden21 roster only has 3 tables, DCHT, PLAY,TEAM

[edit] after fixing some things, that seems to be the only differences between the db file that was uploaded and the M21 roster file.

M21 Roster also has what I believe to be a checksum in the header (I could be wrong, I'm no expert).
Assuming that is the case, unless that can be figured out, an external editor would not be able to produce a file that would be valid in game.
This works flawlessly with PS3 files, FYI.
-AaronS

Dolphin *.gci files
Yes, it does work, thankfully
-MFV303

Special Thanks,
To StingRay68 for his insights, direction and for most of the heavy lifting in this project.


MXDBE.ini
Spoiler:
This is the configuration file that presets options. It resides in the same folder as the Xtreme DB editor exe.

Code: Select all

DB12,C:\Users\madde\Documents\Madden NFL 08\00012-DB_TEMPLATES.db
SDTA,C:\Users\madde\Documents\Madden NFL 08\StreamedData.db
ALDB,C:\Users\madde\Documents\Madden NFL 08\Rosters\roster2007.ros
TIEP,0
FDPx,0
TGCF,000000
TGCB,FFFFFF
TGCD,F0E68C
CGCF,000000
CGCB,FFFFFF
CGCA,EEF4F9
CGCD,F0E68C
DEFF,definitions.csv

DB12 This sets the path to the DB_TEMPLATES #12 file. (zero based unchecked)
SDTA This sets the path to the StreamedData.db file.
ALDB This Auto Loads a preferred DB.
TIEP This sets the export filename. 0 = [DB Name] - [Table Name], 1 = [Table Name]
FDPx This sets the column order. 0 = Default, 1 = Ascending, 2 = Descending
TGCF This sets the Table Grid Color Foreground in hex format.
TGCB This sets the Table Grid Color Background in hex format.
TGCD This sets the Table Grid Color Definitions in hex format.
CGCF This sets the Column Grid Color Foreground in hex format.
CGCB This sets the Column Grid Color Background in hex format.
CGCA This sets the Column Grid Color Alt in hex format.
CGCD This sets the Column Grid Color Definitions in hex format.
DEFF This sets the path to the definitions.csv file. It must be the last entry.


Team Editor
Spoiler:
This is still a work in progress but most of everything in here is functional except create a team.
Image


Created uniforms are a work in progress.
Image
Set the default uniforms in the Home/Away boxes.


Add a uniform to a team by selecting the ID first. This is the location in the UNIFORMS.dat file. If the ID box is white a uniform setting must be created. Click the add (+) button to create it. Set the settings for the uniform and then click the add (+) button on the uniform list to add it.


Player Editor
Spoiler:
The Player editor is mostly non-functional. The only things that can be done is delete a player, cut down roster size and import/export MDC files. (Draft Classes) I will work on the Player editor in the off season.
draftclass.jpg
draftclass.jpg (402.2 KiB) Viewed 213 times



Previous Version
Madden Xtreme DB Editor (back)
reverting to a previous version because some console files were not being saved corretly.

Madden Xtreme DB Editor

Madden Xtreme DB Editor

Sponsor

Sponsor
 

User avatar
RevanFan
Legend
Posts: 12683
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: Madden NFL DB Editor 2019

Postby RevanFan » Sat Jan 26, 2019 10:07 pm

Ooh. Gonna have to try this out soon. Hopefully it loads the PLAY table faster than the old DB Editor. Even with an overclocked 8700K, freaking table takes forever.
Support me on Cash App - $RevanFan
Historic Cowboys Teams Mod
My Cowboys Journal
I'm a die hard Cowboys fan and a lifelong New Yorker.

User avatar
elguapo
Hall of Fame
Posts: 3333
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX

Re: Madden NFL DB Editor 2019

Postby elguapo » Sat Jan 26, 2019 11:11 pm

RevanFan wrote:Ooh. Gonna have to try this out soon. Hopefully it loads the PLAY table faster than the old DB Editor. Even with an overclocked 8700K, freaking table takes forever.


Let us know your findings.

Edit: If any issues please include the OS it is being run under. Thanks

User avatar
RevanFan
Legend
Posts: 12683
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: Madden NFL DB Editor 2019

Postby RevanFan » Sun Jan 27, 2019 12:39 am

elguapo wrote:
RevanFan wrote:Ooh. Gonna have to try this out soon. Hopefully it loads the PLAY table faster than the old DB Editor. Even with an overclocked 8700K, freaking table takes forever.


Let us know your findings.

Edit: If any issues please include the OS it is being run under. Thanks

Will do. Currently can't remember if I'm running 1803 or 1809 of Windows 10, haha. I'll look it up beforehand if I notice any issues. I think I'm on 1803. I have Windows 10 Education, so I'm allowed to defer feature updates for a full calendar year.
Support me on Cash App - $RevanFan
Historic Cowboys Teams Mod
My Cowboys Journal
I'm a die hard Cowboys fan and a lifelong New Yorker.

joegreenlight10
Rookie
Posts: 22
Joined: Mon Aug 15, 2016 2:29 pm

Re: Madden NFL DB Editor 2019

Postby joegreenlight10 » Mon Jan 28, 2019 10:10 pm

Is this strictly for 2019 rosters? I see there's an 08 roster loaded in the screenshot, but anything 08 I try to load brings up the dreaded Unhandled Exception. Running Windows 10 Home, 1803. Original DB editor runs fine.

User avatar
elguapo
Hall of Fame
Posts: 3333
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX

Re: Madden NFL DB Editor 2019

Postby elguapo » Tue Jan 29, 2019 7:30 am

joegreenlight10 wrote:Is this strictly for 2019 rosters? I see there's an 08 roster loaded in the screenshot, but anything 08 I try to load brings up the dreaded Unhandled Exception. Running Windows 10 Home, 1803. Original DB editor runs fine.


The DB editor works with all Madden 08 db files. It can also load some Madden 19 files like the roster (with the FBChunks stripped out adding the ROS extension. See image in first post).

Make sure the file you're trying to load is not corrupted.

User avatar
elguapo
Hall of Fame
Posts: 3333
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX

Re: Madden NFL DB Editor 2019

Postby elguapo » Tue Jan 29, 2019 11:05 pm

So exporting tables with unsupported field types will print crazy characters which affects the spreadsheet so I made a change to print "usft" (unsupported field type) instead. You will still be able to preview what is on those unsupported field types on the screen.

Also working on a feature to make franchise to roster and an "Addendum" feature that will add partial fields to a table.

Will let you all know when it is ready.

User avatar
RevanFan
Legend
Posts: 12683
Joined: Fri Jul 15, 2011 5:25 pm
Location: New York

Re: Madden NFL DB Editor 2019

Postby RevanFan » Wed Jan 30, 2019 2:05 am

I can't seem to open any files from Madden 08. I tried opening my franchise and got this error.

error1.png
error1.png (173.11 KiB) Viewed 47508 times


Then I tried a roster and got the same error. Tried both normal and as an administrator. Compatibility mode for Windows 7 also didn't help.

I'm on Windows 10 Education version 1803. The old DB Editor works fine and loads all my files.
Support me on Cash App - $RevanFan
Historic Cowboys Teams Mod
My Cowboys Journal
I'm a die hard Cowboys fan and a lifelong New Yorker.

User avatar
elguapo
Hall of Fame
Posts: 3333
Joined: Thu Feb 09, 2012 8:24 am
Location: El Paso, TX

Re: Madden NFL DB Editor 2019

Postby elguapo » Wed Jan 30, 2019 10:24 am

RevanFan wrote:I can't seem to open any files from Madden 08. I tried opening my franchise and got this error.

error1.png

Then I tried a roster and got the same error. Tried both normal and as an administrator. Compatibility mode for Windows 7 also didn't help.

I'm on Windows 10 Education version 1803. The old DB Editor works fine and loads all my files.


Let me look into it.

User avatar
StingRay68
Hall of Fame
Posts: 1078
Joined: Mon Jan 09, 2012 7:23 pm

Re: Madden NFL DB Editor 2019

Postby StingRay68 » Wed Jan 30, 2019 12:42 pm

elguapo wrote:Let me look into it.


System.BadImageFormatException

Check your build properties and make sure you didn't select Platform Target - x64. You want 'Any CPU' and prefer 32bit, or just x86


Return to “Utilities”

Who is online

Users browsing this forum: No registered users and 4 guests