Generic EA Roster Editor

[Xanathol]

Resurrecting this thread since I realized I kinda got spread out a bit...



New Version Of the Generic Editor Is Up - Get It Here!



( For those interested, source code is here though 11/7 version, and Madden editor, NCAA 12 Dynasty editor, and old generic editor is here ).




11/15


Seriously hate doing this but I realized how horrible the new image mapping type was without a nice, meaningful description field, so I updated the editor and config accordingly ( add a description field to each imageitem and wrap imageitems all in an 'Images' tag ).


Enjoy!


================================================== ======


11/14


New features added! ( sorry, source not up yet - just the bits for now ).


1. The dependency on the two DLLs is now gone, though two more have been added ( more on that later ). Bottomline is, the executable and assemblies along with it are all compiled Any CPU, so if you can run .Net, you should be able to run the app ( ex. on a Surface RT, after jailbreak on boot to avoid the signing needs, of course ).


2. Real formulas are in! While these are not mapped by a field ( ie. no good for calculating overalls by position ), they are good for that missing data that is computed in game, such as completion percentage ( see new config ). This is where the two new assemblies come into play - thanks NCalc!

For the folks that care & wanna know how to use the new field type, see here:

Spoiler

Ex.

<Field>
    <Abbreviation>Comp %*</Abbreviation>
    <Name>Comp %*</Name>
    <ControlType>Formula</ControlType>
    <Formula>[Pass Completions] / [Pass Attempts] * 100.0</Formula>
    <Description></Description>
    <Type>uint</Type>
</Field>

ControlType => Formula

The formula in the Formula field can use any standard math operations and those defined by NCalc ( see their site / documentation ). You can also use field names within this table only. Field names that contain spaces must be wrapped in square brackets.

3. Images are in! If you have them, of course... A new field has been added where you can choose a value via an image & combobox. Obviously, you have to have the images! I have included a folder with all the different face values I've seen in game and my config utilizes this new feature.

For the folks that care & wanna know how to use the new field type, see here:

Spoiler

Ex.

<Field>
    <Abbreviation>PGHE</Abbreviation>
    <Name>Face</Name>
    <ControlType>ImageComboBox</ControlType>
    <ImageItem>
        <Value>0</Value>
        <ImagePath>.</ImagePath>
    </ImageItem>
    <ImageItem>
        <Value>1</Value>
        <ImagePath>\Images\Faces\1 - Light 1.gif</ImagePath>
    </ImageItem>
    <Description></Description>
    <Type>uint</Type>
</Field>

ControlType => ImageComboBox

You can have as many images as you need. The Value is the value in the database, usually an int, and the ImagePath is the relative path to the image file from the editor's location. Note the need for a slash in front!

Note, you should include those not mapped as well ( ex. in my case, a Face value of 0 ) in case someone loads a file that has that face you don't have an image for. Just set the path to a . or something.

Enjoy!



================================================== ======




11/7


BUG FIX!


Editor and configs have been updated and a pretty big bug fix is in!

1. Seems that my code for fields that were mapped to other tables ( Player ID, for instance ) that would account for missing values was NOT functioning correctly, which doesn't hurt any of your data - just displayed incorrect stuff. Now, when there is a missing field, it will properly show the value with no mapping ( ex. Injury table usually has some Player IDs hanging around that no longer exist and now, instead of a name showing - that was incorrectly shown - the value will show instead.

2. Thanks to PocketScout, we've now have a ton of stat stuff mapped in the config! And with that, I found a nice 'feature' where EA apparently mapped a field value to one meaning in one table and another in another table... so with that, a new field type is added, a MappedComboBox, where you can create a fictional field to add to your view and use a real field to index into it ( see RCDI's usage with NCAA Record Desc., for example ).

3. There is a now a refresh button so you don't have to Recalc maps in each view when you change something mapped. For example, if you changed a player's last name, you use to have to recalc maps in each view to update all the dropdowns - now you just recalc maps in that view and refresh in the others.

4. There should be a performance increase in loading the data, as I added a Dictionary to keep track of mapped fields and their place in their respective comboboxes in stead of brute force searchign everytime.

5. Filtering using the string operations such as contains now works in combobox data of all types. Note - it IS case sensitive.

6. The config has a lot of stuff populated and corrected and now, the Dynasty config has a nested view. If you don't like it, change it!


I think that is everything...
Enjoy!




================================================== =====

10/29



A few bug fixes are in ( hopefully fixed the import issue cujo - thanks for that! ) plus support for new fields.

NOTE! Do NOT use the included configs without this version ( or newer ) of the editor!

In the new configs, time of day ( in minutes ) is a supported mapping and an 'adjusted' combobox ( basically, an offset ie. Height & Weight is now easily mapped ).

Plus, the new config has most equipment mapped to names now.

Also, Save As is now in, though may need testing.




================================================== =====

10/25

As some of you may know from the other threads, I have updated this editor, particularly with NCAA 14 in mind. It is still a generic editor and should work for other EA games, I have packaged my own NCAA 14 roster & dynasty configs along with this download - yes, they are a work in progress, as always!


The features such as I/O, Recalc Maps, Copy Config, and MC02 Recalc On/Off are documented elsewhere, but a quick run down:


1. IO Export - export one or all currently visible records in a view. Must choose a key ( ex. PGID ie Player ID for the PLAY / Players table ) when exporting; this is for the import features to use.

2. IO Import - as a completely new record, overwriting record based on keys, or overwriting the selected without the key. Primary usage scenario is send roster to all roster builders, filter to a team, update players on team, export all visible, send to coordinator who imports -> overwriting existing. Bam - new roster with a team of people without a lot of hassle.

3. Recalc Maps - if you change the value of a field used as a reference ( ie. First Name referenced by Player ID ), hit this to update the maps.

4. Copy Config - copy config entries from one config to another - makes it easy to share what you have found or update known configs from a prior year/edition to a new one.

5. MC02 Recalc - if ON, recalculates the checksums in the MC02 file. You need this on for Madden, NCAA 12, etc - NCAA 14 needs this OFF!




So the new features / updates...




1. MC02 Recalc is now OFF by default - figured that while most games need it on, it is safer off by default to avoid a "dammit I forgot to turn that off now I must redo my roster" moments for NCAA 14 folks.

2. A new field type has been added - Calculated! And it means what you may think it means - it lets you add a field that can perform a summation of other fields, ie. you can add a 'calculated overall' column now, which I have in my two config files in the download.

Here is how it works for those that care, otherwise, skip the below!

Spoiler

The 'formulas' supported are brain dead simple - a summation of listed fields you choose that have a multiplier applied to each of them individually, plus an adjustment value. Here's what it looks like:

<Field>
    <Abbreviation>OVR*</Abbreviation>
    <Name>OVR*</Name>
    <ControlType>Calculated</ControlType>
    <ControlLink>
        <Table></Table>
        <IndexField>Position</IndexField>
        <Formulas>
            <Formula>
                <IndexValue>0</IndexValue>
                <Variables>
                    <Variable>
                        <Field>Speed</Field>
                        <Multiplier>0.0875</Multiplier>
                    </Variable>
                    <Variable>
                        <Field>Awareness</Field>
                        <Multiplier>0.2</Multiplier>
                    </Variable>
                    <Variable>
                        <Field>Throwing Power</Field>
                        <Multiplier>0.35</Multiplier>
                    </Variable>
                    <Variable>
                        <Field>Throwing Accuracy</Field>
                        <Multiplier>0.4</Multiplier>
                    </Variable>
                </Variables>
                <Adjustment>0</Adjustment>
            </Formula>
        </Formulas>
        <Min>40</Min>
        <Max>99</Max>
    </ControlLink>
    <Description></Description>
    <Type>uint</Type>
</Field>

Here is the break down ( note - all fields MUST be set ):

1. Has to have a unique name & abbreviation that doesn't actually exist otherwise.
2. ControlType has to be set to Calculated
3. IndexField is the field from the assumed table / view where this guy will be used that will determine which formula in the list of formulas to use. In other words, Position / PPOS, as each one has a different formula to calculate the overall.
4. Formula section(s) is/are the calculation(s) used base on the IndexField - you can have as many of these as you have different values for the IndexField.
4. IndexValue is the value of the IndexField that will map to this formula. In our example, 0 == QB, so 0 is the QB overall formula.
5. Variable sections are the different fields used in the calculations - you can have as many of these as fields needed.
6. Each Variable has a Field and Multiplier. The field is the field to retrieve the record value of and the multiplier is to be multiplied against the field value.
7. Adjustment is a number to add at the end of the total calculation ( can be negative and oft is ).
8. Min and Max are the minimum and maximum for the total computed.
9. Of course, add the field to your view, else you will never see it!

So in the example above, what it is saying is for a QB, to try and calculate the overall:

OVR = Speed * 0.0875 + Awareness * 0.2 + Throwing Power * 0.35 + Throwing Accuracy * 0.4 + 0.

Then of course, OVR is checked to make sure it is > Min and < Max.

To come up with these formulas, you need to adjust values on a player at this position to the point where you figure out how much a point in a given stat contributes to their overall. You will find that for many positions, once you find these values, a 99 in all stats would total up to WAY above 99 - this is where the Adjustment value comes into play, ie. the amount needed to be added ( as a positive or negative number ) to bring that value down to its correct value.

Good luck! I hope someone comes up with better formulas than I do!

Note - my config has such a column added to try and calculate overalls while you edit. Right now, formulas are only in for QB, HB, and FB ( though QB's look way off ). If you want more and don't want to wait for me to try to figure it out, please read the above and add your own!


Enjoy!





******************** Original Post *********************

Some of you may have seen my editor for Madden 12. Well, now I have created a generic EA roster editor. I only have instructions for editing an Xbox 360 roster, as I have no idea how to decrypt PS3 files.

Again, this is a generic editor, in that it should be able to edit any of EA's MC02 files that contain one of their DB files. Now that comes with a price, in that its nowhere near as feature rich as the Madden editor and its takes a bit longer to load, but such is life!

You can see my first introduction of it here which describes the config stuff and you can also get the instructions there for extracting the MC02 in the first post.

You need .Net 4.0, Horizon, ( links to both in other thread ) and my editor:

** old link gone! **

The short version is copy your roster to a USB stick, put it in the computer, open Horizon ( see other thread for download link ), extract the file from your USB device, open in the Package Manager tool in Horizon, and extract the contents to your computer ( with an MC02 extension to keep things straight ).

Now open the editor, choose File->Load Config and select the ncaa12.xml file included with the download. Now choose File->open and pick the MC02 file from your roster - that's its!

There are functions to filter a table's view and perform mass data functions to the items listed in the filtered view ( ex. say you filter out LSU CBs and mass set Speed to 90 - only the LSU CBs will have a 90 speed set ). Of course you can save it and reverse the process above to put it back on your Xbox ( don't forget to rehash & resign!!!! )

Let me know when you guys think. Oh, and if anyone discovers what some of the unknown fields are, please post & update the XML so we can all benefit!

[SonOfEd]

Looking forward to tweaking with this Xan! I've had a blast with your M12 editor. A tool like this has been loooong awaited for NCAA.

[19]

I was able to get this to work with a '13 roster file. I actually was able to go through and fix a lot of the double numbers on a couple different teams. Looks good to go.

You may have something here, good work.

[yanks126ws]

Great work Xan! I haven't tried the tool on NCAA13 yet so I was wondering if it is possible to change the cyber faces without it affecting the height/ weight?

Example: I want to assign Denard Robinson dreads but there is no option for dreads for dark skin, just medium skin for his height/ weight class.

[kingsofthevalley]

Great. Looks like I'll be hitting up gamestop today to purchase again and I'll also have to get a cheap laptop pc (unless I can make this work on a MAC?). Global editor is ALL I've been waiting for. This is all EA had to do to quell some of the complaints they always receive from this board, very simple, but it takes someone from within the community to do it.

Kudos to ya Xan, you actually saved one of their long time customers because I was definitely done with em (of course not saying my lone purchase meant much lol). I don't see why they don't have you on the dev team in some fashion to do an official global editor for them. Appreciate the work. Is there anything you need on the financial side to make this easier to use/make it more official, etc, etc?

[Gotmadskillzson]

Don't care for this version of the editor, too limiting and it freezes too much to the point it makes a person stop using it. Not talking a few seconds freezes, but full minute freeze every time you go to a different field. Plus I like the Madden version better, more user friendly, much easier to do mass edits.

Speaking of mass edits, it doesn't do the entire NCAA roster. It stops at Hawaii. That is probably due to the fact NCAA has more players then Madden does when I use the Madden editor. But I like I said, the Madden editor is more user friendly and quicker.

But you are on the right track. If you can make a NCAA editor exactly like the Madden editor but ensure it does all 123 teams and not just half of them, you will have some thing golden.

[TarHeelPhenom]

Quote: Originally Posted by Gotmadskillzson

Don't care for this version of the editor, too limiting and it freezes too much to the point it makes a person stop using it. Not talking a few seconds freezes, but full minute freeze every time you go to a different field. Plus I like the Madden version better, more user friendly, much easier to do mass edits. Speaking of mass edits, it doesn't do the entire NCAA roster. It stops at Hawaii. That is probably due to the fact NCAA has more players then Madden does when I use the Madden editor. But I like I said, the Madden editor is more user friendly and quicker. But you are on the right track. If you can make a NCAA editor exactly like the Madden editor but ensure it does all 123 teams and not just half of them, you will have some thing golden.

GMS is exactly right! There are only 2100+ player slots for mass global editing at one time; and NCAA has way more players than that. Also, some of the ratings on NCAA cannot be edited with the Madden Editor. For example, Hit Power, Juke Move, Spin Move, Power and Finesse Move, Man and Zone Cov, Spec Catch and Catch In Traffic...none of those can be at the current moment with the Madden Editor. but, that one is def more user friendly than the generic one at this time. Hopefully, my man Xan will put his skills and expertise to work and make this tool something to change it for us NCAAers.

[kingsofthevalley]

Whoa whoa lol. Guess I won't be buying NCAA again or a laptop after all. Thanks for saving me a couple of dollars gents. Only does half the teams? Bummer.