Nutty
Deity
The only reason I brought up Nexus Buddy is if you want to be "lazy" (I see that's not you) and drop in a replacement model by renaming all the files to the names used by an existing model.May I ask for instructions on how to put in a new unit model using Nexus Buddy (like editing the gr2 file to get the dds)? And should I use ModBuddy to "update" the SQL file to include the new change?
You needn't worry about using ModBuddy; you can use a text editor for everything except for posting a mod to the Steam Workshop.
It must be after the END.I added this at the very end of SQL\3-InsertArtDefines.sql... I tried both adding it before and after the END...
In any case, the issue you're having is that unfortunately you can't assume that Firaxis was consistent with the internal unit names. Although it is a "UNIT_CHARIOT_ARCHER" using the UnitArtInfo tag "ART_DEF_UNIT_CHARIOT_ARCHER" (with an underscore between CHARIOT and ARCHER), the member type tag that you want to use is actually "ART_DEF_UNIT_MEMBER_CHARIOTARCHER" (no underscore between CHARIOT and ARCHER).
As for the problem with actually using danrell's chariots for the chariot archer is that they don't actually include any archers, so the animations aren't right and so it doesn't really work.