Database Table Fragments

**Blitzkrieg80** · November 27, 2013, 02:20 PM

yes, also i think PFM and multiple save requests are an issue... thanks for being patient, i've been wanting to get this to work...

atm because i cant test every time, im wondering if i should just apply this method to stuff i really need it on, such as campaign variables, main_units, effects_bundles.... but how do you guys do it? do you verify (that its working) every table after you do it or just every so often?

**Kurisu Paifuaa** · December 01, 2013, 05:33 AM

Originally Posted by Blitzkrieg80

yes, also i think PFM and multiple save requests are an issue... thanks for being patient, i've been wanting to get this to work...

atm because i cant test every time, im wondering if i should just apply this method to stuff i really need it on, such as campaign variables, main_units, effects_bundles.... but how do you guys do it? do you verify (that its working) every table after you do it or just every so often?

Unfortunately, manual verification is the only thing we have going. It's probably just as important to compile a list of what does work as it is for exceptions.

Whoever ends up at the modding conference, I hope that they'll ask about getting us some sort of db logging functionality included with the next public SDK release. I think it would lead to better practices all around and less 'voodoo' fixes like movie packs.

**Blitzkrieg80** · November 30, 2013, 05:35 PM

OK... the .pack movie format is the problem from what i can tell... campaign variables fragments work in steam workshop / mod manager but not same exact mod as 'movie'... oh well... good to know! i would not touch / mess with fragments whatsoever if doing movie packs.

I am happy it works in Steam Workshop though! Thanks for the help

**crzyrndm** · January 26, 2014, 01:01 AM

Patch 9 beta may have broken support for this partially again (Details)

If anyone else comes across occurences of fragments not working after updating for patch 9, please add your examples so we can get it noticed.

**Kurisu Paifuaa** · January 26, 2014, 05:04 PM

Testing your example pack when I get a chance...

One thing I've found (prior to patch9) is that the alphabetical priority concerning table fragments will sometimes yield unintended results with multiple mods or a single mod where the base table is included to remove an entry. Do your changes work if you call your table crzy_land_units instead of land_units_crzy? Just a guess, but perhaps the vanilla land_units is taking priority even though it's pack type is 'patch' (which would be a bug). This also happens if you have two 'mod' type packs loading and one contains the base table name... it's treated the same as a fragment. So crzy_land_units > land_units > land_units_crzy.

edit: What happens if you include the base table in your test mod? It should be treated alphabetically like I described... which would provide a possible workaround since you could then control priority (through alphabetical naming) at the mod level.

**crzyrndm** · January 26, 2014, 06:40 PM

Originally Posted by Kurisu Paifuaa

Testing your example pack when I get a chance...

One thing I've found (prior to patch9) is that the alphabetical priority concerning table fragments will sometimes yield unintended results with multiple mods or a single mod where the base table is included to remove an entry. Do your changes work if you call your table crzy_land_units instead of land_units_crzy? Just a guess, but perhaps the vanilla land_units is taking priority even though it's pack type is 'patch' (which would be a bug). This also happens if you have two 'mod' type packs loading and one contains the base table name... it's treated the same as a fragment. So crzy_land_units > land_units > land_units_crzy.

edit: What happens if you include the base table in your test mod? It should be treated alphabetically like I described... which would provide a possible workaround since you could then control priority (through alphabetical naming) at the mod level.

I have no other mods affecting land_units, and including the base table doesn't seem to have any effect (and isn't really an option due to breaking compatibility with any other mod which changes vanilla units for other users)

**Kurisu Paifuaa** · January 26, 2014, 10:01 PM

Originally Posted by crzyrndm

I have no other mods affecting land_units, and including the base table doesn't seem to have any effect (and isn't really an option due to breaking compatibility with any other mod which changes vanilla units for other users)

Ok. Hmm... so even including the base table won't override the patch level land_units? Yeah, that is a problem... that would indicate that you can't mod that table in any way... at least with a mod type pack.

I agree that it isn't good practice to include the whole table, but from the short round of tests I performed prior to patch 9, it didn't matter anyway. A fragment would override it if it came before it alphabetically (e.g. k_land_units > land_units > m_land_units) where the record is the same.

Off to test your pack...

edit: your example packs uploaded to totalwar.com are movie packs... they're sure to frown upon that

. Don't know how that affects the example

edit: As a movie pack, your land_unit change to ammunition indeed does not work. However, changing your pack to a mod had the desired effect (had to use hex editor to change the 5th byte, PFM is still bugged). This might be exclusive to movie packs.

I tested by looking at Iceni ballista (bri_ballista) in custom battle. As a movie ammunition = 15, as a mod ammunition = 30

**crzyrndm** · January 27, 2014, 12:15 AM

Aw, wut. When the hell did that happen...

EDIT

Right you are, movie was the issue (Not a clue how that happened...).

PS
While PFM throws an exception when you change type, it does go through if you hit continue and save.

**Kurisu Paifuaa** · January 27, 2014, 01:51 AM

Yup, I always feel like the wheels are going to fall off whenever PFM spits an error though, so I avoid.

Anyway, good that we don't have another mysterious creeping file system bug on the loose. I'm sure something else is wrong somewhere though

Actually, your test should be a final nail in the coffin for movie packs, except for some vfx edits and such.

**gdwitt** · June 20, 2014, 03:18 PM

How do I name new lua scripts to override others' scripts?
I am trying to create a submod to add forced march back into DEI.
The new mod script works with Radious, but it doesn't affect DEI units/armies.

**crzyrndm** · June 20, 2014, 04:11 PM

Lua scripts, since they're actually proper code, use explicit linkages not a naming system. That both gives you more options, and means that fragments are not applicable