[BNW] Skeleton graphics not working for no reason.

[NO_Body]

I'll go straight to the point.

Spoiler :

This code works:

Spoiler :

--ORC SPEARMAN
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    ("ART_DEF_UNIT_SPEARMAN_ORC"), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE (Type = "ART_DEF_UNIT_SPEARMAN");
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    SELECT    ("ART_DEF_UNIT_SPEARMAN_ORC"), ("ART_DEF_UNIT_MEMBER_SPEARMAN_ORC"), "NumMembers"
    FROM "ArtDefine_UnitInfoMemberInfos" WHERE (UnitInfoType = "ART_DEF_UNIT_SPEARMAN");
INSERT INTO "ArtDefine_UnitMemberCombats" ('UnitMemberType', 'EnableActions', 'DisableActions', 'MoveRadius', 'ShortMoveRadius', 'ChargeRadius', 'AttackRadius', 'RangedAttackRadius', 'MoveRate', 'ShortMoveRate', 'TurnRateMin', 'TurnRateMax', 'TurnFacingRateMin', 'TurnFacingRateMax', 'RollRateMin', 'RollRateMax', 'PitchRateMin', 'PitchRateMax', 'LOSRadiusScale', 'TargetRadius', 'TargetHeight', 'HasShortRangedAttack', 'HasLongRangedAttack', 'HasLeftRightAttack', 'HasStationaryMelee', 'HasStationaryRangedAttack', 'HasRefaceAfterCombat', 'ReformBeforeCombat', 'HasIndependentWeaponFacing', 'HasOpponentTracking', 'HasCollisionAttack', 'AttackAltitude', 'AltitudeDecelerationDistance', 'OnlyTurnInMovementActions', 'RushAttackFormation')
    SELECT    ("ART_DEF_UNIT_MEMBER_SPEARMAN_ORC"), "EnableActions", "DisableActions", "MoveRadius", "ShortMoveRadius", "ChargeRadius", "AttackRadius", "RangedAttackRadius",
            "MoveRate", "ShortMoveRate", "TurnRateMin", "TurnRateMax", "TurnFacingRateMin", "TurnFacingRateMax", "RollRateMin", "RollRateMax", "PitchRateMin", "PitchRateMax", "LOSRadiusScale", "TargetRadius", "TargetHeight", "HasShortRangedAttack", "HasLongRangedAttack", "HasLeftRightAttack", "HasStationaryMelee", "HasStationaryRangedAttack", "HasRefaceAfterCombat", "ReformBeforeCombat", "HasIndependentWeaponFacing", "HasOpponentTracking", "HasCollisionAttack", "AttackAltitude", "AltitudeDecelerationDistance", "OnlyTurnInMovementActions", "RushAttackFormation"
    FROM "ArtDefine_UnitMemberCombats" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_SPEARMAN");
INSERT INTO "ArtDefine_UnitMemberCombatWeapons" ('UnitMemberType', 'Index', 'SubIndex', 'ID', 'VisKillStrengthMin', 'VisKillStrengthMax', 'ProjectileSpeed', 'ProjectileTurnRateMin', 'ProjectileTurnRateMax', 'HitEffect', 'HitEffectScale', 'HitRadius', 'ProjectileChildEffectScale', 'AreaDamageDelay', 'ContinuousFire', 'WaitForEffectCompletion', 'TargetGround', 'IsDropped', 'WeaponTypeTag', 'WeaponTypeSoundOverrideTag')
    SELECT ("ART_DEF_UNIT_MEMBER_SPEARMAN_ORC"), "Index", "SubIndex", "ID", "VisKillStrengthMin", "VisKillStrengthMax", "ProjectileSpeed", "ProjectileTurnRateMin", "ProjectileTurnRateMax", "HitEffect", "HitEffectScale", "HitRadius", "ProjectileChildEffectScale", "AreaDamageDelay", "ContinuousFire", "WaitForEffectCompletion", "TargetGround", "IsDropped", "WeaponTypeTag", "WeaponTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberCombatWeapons" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_SPEARMAN");
INSERT INTO "ArtDefine_UnitMemberInfos" ("Type", "Scale", "ZOffset", "Domain", "Model", "MaterialTypeTag", "MaterialTypeSoundOverrideTag")
    SELECT    ("ART_DEF_UNIT_MEMBER_SPEARMAN_ORC"), "Scale", "ZOffset", "Domain",
            ("orc_spearman.fxsxml"), "MaterialTypeTag", "MaterialTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberInfos" WHERE (Type = "ART_DEF_UNIT_MEMBER_SPEARMAN");

This code does Not work:

Spoiler :

--DEAD SPEARMAN
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    ("ART_DEF_UNIT_SPEARMAN_DEAD"), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE (Type = "ART_DEF_UNIT_SPEARMAN");
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    SELECT    ("ART_DEF_UNIT_SPEARMAN_DEAD"), ("ART_DEF_UNIT_MEMBER_SPEARMAN_DEAD"), "NumMembers"
    FROM "ArtDefine_UnitInfoMemberInfos" WHERE (UnitInfoType = "ART_DEF_UNIT_SPEARMAN");
INSERT INTO "ArtDefine_UnitMemberCombats" ('UnitMemberType', 'EnableActions', 'DisableActions', 'MoveRadius', 'ShortMoveRadius', 'ChargeRadius', 'AttackRadius', 'RangedAttackRadius', 'MoveRate', 'ShortMoveRate', 'TurnRateMin', 'TurnRateMax', 'TurnFacingRateMin', 'TurnFacingRateMax', 'RollRateMin', 'RollRateMax', 'PitchRateMin', 'PitchRateMax', 'LOSRadiusScale', 'TargetRadius', 'TargetHeight', 'HasShortRangedAttack', 'HasLongRangedAttack', 'HasLeftRightAttack', 'HasStationaryMelee', 'HasStationaryRangedAttack', 'HasRefaceAfterCombat', 'ReformBeforeCombat', 'HasIndependentWeaponFacing', 'HasOpponentTracking', 'HasCollisionAttack', 'AttackAltitude', 'AltitudeDecelerationDistance', 'OnlyTurnInMovementActions', 'RushAttackFormation')
    SELECT    ("ART_DEF_UNIT_MEMBER_SPEARMAN_DEAD"), "EnableActions", "DisableActions", "MoveRadius", "ShortMoveRadius", "ChargeRadius", "AttackRadius", "RangedAttackRadius",
            "MoveRate", "ShortMoveRate", "TurnRateMin", "TurnRateMax", "TurnFacingRateMin", "TurnFacingRateMax", "RollRateMin", "RollRateMax", "PitchRateMin", "PitchRateMax", "LOSRadiusScale", "TargetRadius", "TargetHeight", "HasShortRangedAttack", "HasLongRangedAttack", "HasLeftRightAttack", "HasStationaryMelee", "HasStationaryRangedAttack", "HasRefaceAfterCombat", "ReformBeforeCombat", "HasIndependentWeaponFacing", "HasOpponentTracking", "HasCollisionAttack", "AttackAltitude", "AltitudeDecelerationDistance", "OnlyTurnInMovementActions", "RushAttackFormation"
    FROM "ArtDefine_UnitMemberCombats" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_SPEARMAN");
INSERT INTO "ArtDefine_UnitMemberCombatWeapons" ('UnitMemberType', 'Index', 'SubIndex', 'ID', 'VisKillStrengthMin', 'VisKillStrengthMax', 'ProjectileSpeed', 'ProjectileTurnRateMin', 'ProjectileTurnRateMax', 'HitEffect', 'HitEffectScale', 'HitRadius', 'ProjectileChildEffectScale', 'AreaDamageDelay', 'ContinuousFire', 'WaitForEffectCompletion', 'TargetGround', 'IsDropped', 'WeaponTypeTag', 'WeaponTypeSoundOverrideTag')
    SELECT ("ART_DEF_UNIT_MEMBER_SPEARMAN_DEAD"), "Index", "SubIndex", "ID", "VisKillStrengthMin", "VisKillStrengthMax", "ProjectileSpeed", "ProjectileTurnRateMin", "ProjectileTurnRateMax", "HitEffect", "HitEffectScale", "HitRadius", "ProjectileChildEffectScale", "AreaDamageDelay", "ContinuousFire", "WaitForEffectCompletion", "TargetGround", "IsDropped", "WeaponTypeTag", "WeaponTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberCombatWeapons" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_SPEARMAN");
INSERT INTO "ArtDefine_UnitMemberInfos" ("Type", "Scale", "ZOffset", "Domain", "Model", "MaterialTypeTag", "MaterialTypeSoundOverrideTag")
    SELECT    ("ART_DEF_UNIT_MEMBER_SPEARMAN_DEAD"), "Scale", "ZOffset", "Domain",
            ("skeleton_spearman.fxsxml"), "MaterialTypeTag", "MaterialTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberInfos" WHERE (Type = "ART_DEF_UNIT_MEMBER_SPEARMAN");

Only thing not working is the Skeleton models.
i've tested other units with the same code and i don't see the issue....
I have also looked in the Modinfo file and i cannot see any spell errors.
But just in case here's the code for the file importing:

Spoiler :

    <File md5="5706BF34E2C4E028663AE1AD53339227" import="1">Art/Undead units/SkeleArcher/black_4x4.dds</File>
    <File md5="C71481158988FD945210E30972267418" import="1">Art/Undead units/SkeleArcher/skeleton_archer.fxsxml</File>
    <File md5="AA52BEFD1895E610AE0E5CD3E5CB7093" import="1">Art/Undead units/SkeleArcher/skeleton_archer.gr2</File>
    <File md5="B2C8805004FC1446AD621C6CD17F421F" import="1">Art/Undead units/SkeleArcher/skeleton_diff.dds</File>
    <File md5="5706BF34E2C4E028663AE1AD53339227" import="1">Art/Undead units/SkeleSwordsman/black_4x4.dds</File>
    <File md5="B2C8805004FC1446AD621C6CD17F421F" import="1">Art/Undead units/SkeleSwordsman/skeleton_diff.dds</File>
    <File md5="3253CADCB2F8E7AF83B0A3C75A52D4A5" import="1">Art/Undead units/SkeleSwordsman/skeleton_swordsman.fxsxml</File>
    <File md5="C4AE40A95ED0C4667535F989D58DF600" import="1">Art/Undead units/SkeleSwordsman/skeleton_swordsman.gr2</File>
    <File md5="5706BF34E2C4E028663AE1AD53339227" import="1">Art/Undead units/SkeleSpearman/black_4x4.dds</File>
    <File md5="098B7E1A92A74844E3A4F822E62DA66C" import="1">Art/Undead units/SkeleSpearman/skeleton_diff.dds</File>
    <File md5="15E733A11F81DA948081D87AAF00C2C4" import="1">Art/Undead units/SkeleSpearman/skeleton_spearman.fxsxml</File>
    <File md5="EB82A0E41642E64E7C198F04CC252299" import="1">Art/Undead units/SkeleSpearman/skeleton_spearman.gr2</File>
    <File md5="5706BF34E2C4E028663AE1AD53339227" import="1">Art/Undead units/SkeleWarrior/black_4x4.dds</File>
    <File md5="99B2E01FC5BE395AC42D4243C4209CB5" import="1">Art/Undead units/SkeleWarrior/skeleton.fxsxml</File>
    <File md5="043838ABA4143CF1CF8A44629FB4A73B" import="1">Art/Undead units/SkeleWarrior/skeleton.gr2</File>
    <File md5="B2C8805004FC1446AD621C6CD17F421F" import="1">Art/Undead units/SkeleWarrior/skeleton_diff.dds</File>

Only the archer skeleton works.
The Swordman, Warrior & Spearman does not.

I would say there's something wrong with the model codes them selves, but they work in the halloween civ mod, so i don't see the issue.

Edit: So apparently the Unit graphics work in other civ art styles, But not the undead one, and there's still no logical reason for it.
Only difference is one art style is called "_ORC" ect, and the other "_DED"/"_DEAD" (used both terms while testing)

here's the artstyle code:

Spoiler :

-- ORC
UPDATE Civilizations SET ArtStyleSuffix = "_ORC" WHERE Type = 'CIVILIZATION_GENERICd_CIV';
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    REPLACE("Type", '_EURO', '_ORC'), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE Type LIKE '%_EURO';
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    SELECT    REPLACE("UnitInfoType", '_EURO', '_ORC'), "UnitMemberInfoType", "NumMembers"
    FROM "ArtDefine_UnitInfoMemberInfos" WHERE UnitInfoType LIKE '%_EURO';

-- DARF
UPDATE Civilizations SET ArtStyleSuffix = "_DARF" WHERE Type = 'CIVILIZATION_DWARFS';
UPDATE Civilizations SET ArtStyleSuffix = "_DARF" WHERE Type = 'CIVILIZATION_MOUNTAIN_DWARVES';
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    REPLACE("Type", '_EURO', '_DARF'), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE Type LIKE '%_EURO';
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    SELECT    REPLACE("UnitInfoType", '_EURO', '_DARF'), "UnitMemberInfoType", "NumMembers"
    FROM "ArtDefine_UnitInfoMemberInfos" WHERE UnitInfoType LIKE '%_EURO';

-- GOB
UPDATE Civilizations SET ArtStyleSuffix = "_GOB" WHERE Type = 'CIVILIZATION_GENERICK_CIV_NOT';
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    REPLACE("Type", '_EURO', '_GOB'), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE Type LIKE '%_EURO';
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    SELECT    REPLACE("UnitInfoType", '_EURO', '_GOB'), "UnitMemberInfoType", "NumMembers"
    FROM "ArtDefine_UnitInfoMemberInfos" WHERE UnitInfoType LIKE '%_EURO';

-- ELVIS
UPDATE Civilizations SET ArtStyleSuffix = "_ELVIS" WHERE Type = 'CIVILIZATION_HIGH_ELVES';
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    REPLACE("Type", '_EURO', '_ELVIS'), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE Type LIKE '%_EURO';
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    SELECT    REPLACE("UnitInfoType", '_EURO', '_ELVIS'), "UnitMemberInfoType", "NumMembers"
    FROM "ArtDefine_UnitInfoMemberInfos" WHERE UnitInfoType LIKE '%_EURO';

-- DEAD
UPDATE Civilizations SET ArtStyleSuffix = "_DEAD" WHERE Type = 'CIVILIZATION_GENERICK_CIV';
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    REPLACE("Type", '_EURO', '_DEAD'), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE Type LIKE '%_EURO';
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    SELECT    REPLACE("UnitInfoType", '_EURO', '_DEAD'), "UnitMemberInfoType", "NumMembers"
    FROM "ArtDefine_UnitInfoMemberInfos" WHERE UnitInfoType LIKE '%_EURO';

(GENERICK/GENERICd/NOT, are the test civilization i use)

 

[NO_Body]

I found the culprit.
Apparently, any code posted after this one:

Spoiler :

-- ELVIS WARRIOR
INSERT INTO "ArtDefine_UnitInfos" ('Type','DamageStates','Formation')
    SELECT    ("ART_DEF_UNIT__WARRIOR_ELVIS"), "DamageStates", "Formation"
    FROM "ArtDefine_UnitInfos" WHERE (Type = "ART_DEF_UNIT__WARRIOR");
-- V1
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    VALUES    ("ART_DEF_UNIT__WARRIOR_ELVIS", "ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS", 3);
-- V2
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    VALUES    ("ART_DEF_UNIT__WARRIOR_ELVIS", "ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2", 3);
-- V3
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    VALUES    ("ART_DEF_UNIT__WARRIOR_ELVIS", "ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V3", 2);
-- V1
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    VALUES    ("ART_DEF_UNIT__WARRIOR_ELVIS", "ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS", 3);
-- V2
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    VALUES    ("ART_DEF_UNIT__WARRIOR_ELVIS", "ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2", 3);
-- V3
INSERT INTO "ArtDefine_UnitInfoMemberInfos" ('UnitInfoType','UnitMemberInfoType','NumMembers')
    VALUES    ("ART_DEF_UNIT__WARRIOR_ELVIS", "ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V3", 2);
-- V1
INSERT INTO "ArtDefine_UnitMemberCombats" ('UnitMemberType', 'EnableActions', 'DisableActions', 'MoveRadius', 'ShortMoveRadius', 'ChargeRadius', 'AttackRadius', 'RangedAttackRadius', 'MoveRate', 'ShortMoveRate', 'TurnRateMin', 'TurnRateMax', 'TurnFacingRateMin', 'TurnFacingRateMax', 'RollRateMin', 'RollRateMax', 'PitchRateMin', 'PitchRateMax', 'LOSRadiusScale', 'TargetRadius', 'TargetHeight', 'HasShortRangedAttack', 'HasLongRangedAttack', 'HasLeftRightAttack', 'HasStationaryMelee', 'HasStationaryRangedAttack', 'HasRefaceAfterCombat', 'ReformBeforeCombat', 'HasIndependentWeaponFacing', 'HasOpponentTracking', 'HasCollisionAttack', 'AttackAltitude', 'AltitudeDecelerationDistance', 'OnlyTurnInMovementActions', 'RushAttackFormation')
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS"), "EnableActions", "DisableActions", "MoveRadius", "ShortMoveRadius", "ChargeRadius", "AttackRadius", "RangedAttackRadius",
            "MoveRate", "ShortMoveRate", "TurnRateMin", "TurnRateMax", "TurnFacingRateMin", "TurnFacingRateMax", "RollRateMin", "RollRateMax", "PitchRateMin", "PitchRateMax", "LOSRadiusScale", "TargetRadius", "TargetHeight", "HasShortRangedAttack", "HasLongRangedAttack", "HasLeftRightAttack", "HasStationaryMelee", "HasStationaryRangedAttack", "HasRefaceAfterCombat", "ReformBeforeCombat", "HasIndependentWeaponFacing", "HasOpponentTracking", "HasCollisionAttack", "AttackAltitude", "AltitudeDecelerationDistance", "OnlyTurnInMovementActions", "RushAttackFormation"
    FROM "ArtDefine_UnitMemberCombats" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_WARRIOR");
INSERT INTO "ArtDefine_UnitMemberCombatWeapons" ('UnitMemberType', 'Index', 'SubIndex', 'ID', 'VisKillStrengthMin', 'VisKillStrengthMax', 'ProjectileSpeed', 'ProjectileTurnRateMin', 'ProjectileTurnRateMax', 'HitEffect', 'HitEffectScale', 'HitRadius', 'ProjectileChildEffectScale', 'AreaDamageDelay', 'ContinuousFire', 'WaitForEffectCompletion', 'TargetGround', 'IsDropped', 'WeaponTypeTag', 'WeaponTypeSoundOverrideTag')
    SELECT ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS"), "Index", "SubIndex", "ID", "VisKillStrengthMin", "VisKillStrengthMax", "ProjectileSpeed", "ProjectileTurnRateMin", "ProjectileTurnRateMax", "HitEffect", "HitEffectScale", "HitRadius", "ProjectileChildEffectScale", "AreaDamageDelay", "ContinuousFire", "WaitForEffectCompletion", "TargetGround", "IsDropped", "WeaponTypeTag", "WeaponTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberCombatWeapons" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_WARRIOR");
INSERT INTO "ArtDefine_UnitMemberInfos" ("Type", "Scale", "ZOffset", "Domain", "Model", "MaterialTypeTag", "MaterialTypeSoundOverrideTag")
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS"), "Scale", "ZOffset", "Domain",
            ("elf_warrior_v2.fxsxml"), "MaterialTypeTag", "MaterialTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberInfos" WHERE (Type = "ART_DEF_UNIT_MEMBER_WARRIOR");
-- V2
INSERT INTO "ArtDefine_UnitMemberCombats" ('UnitMemberType', 'EnableActions', 'DisableActions', 'MoveRadius', 'ShortMoveRadius', 'ChargeRadius', 'AttackRadius', 'RangedAttackRadius', 'MoveRate', 'ShortMoveRate', 'TurnRateMin', 'TurnRateMax', 'TurnFacingRateMin', 'TurnFacingRateMax', 'RollRateMin', 'RollRateMax', 'PitchRateMin', 'PitchRateMax', 'LOSRadiusScale', 'TargetRadius', 'TargetHeight', 'HasShortRangedAttack', 'HasLongRangedAttack', 'HasLeftRightAttack', 'HasStationaryMelee', 'HasStationaryRangedAttack', 'HasRefaceAfterCombat', 'ReformBeforeCombat', 'HasIndependentWeaponFacing', 'HasOpponentTracking', 'HasCollisionAttack', 'AttackAltitude', 'AltitudeDecelerationDistance', 'OnlyTurnInMovementActions', 'RushAttackFormation')
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2"), "EnableActions", "DisableActions", "MoveRadius", "ShortMoveRadius", "ChargeRadius", "AttackRadius", "RangedAttackRadius",
            "MoveRate", "ShortMoveRate", "TurnRateMin", "TurnRateMax", "TurnFacingRateMin", "TurnFacingRateMax", "RollRateMin", "RollRateMax", "PitchRateMin", "PitchRateMax", "LOSRadiusScale", "TargetRadius", "TargetHeight", "HasShortRangedAttack", "HasLongRangedAttack", "HasLeftRightAttack", "HasStationaryMelee", "HasStationaryRangedAttack", "HasRefaceAfterCombat", "ReformBeforeCombat", "HasIndependentWeaponFacing", "HasOpponentTracking", "HasCollisionAttack", "AttackAltitude", "AltitudeDecelerationDistance", "OnlyTurnInMovementActions", "RushAttackFormation"
    FROM "ArtDefine_UnitMemberCombats" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_WARRIOR");
INSERT INTO "ArtDefine_UnitMemberCombatWeapons" ('UnitMemberType', 'Index', 'SubIndex', 'ID', 'VisKillStrengthMin', 'VisKillStrengthMax', 'ProjectileSpeed', 'ProjectileTurnRateMin', 'ProjectileTurnRateMax', 'HitEffect', 'HitEffectScale', 'HitRadius', 'ProjectileChildEffectScale', 'AreaDamageDelay', 'ContinuousFire', 'WaitForEffectCompletion', 'TargetGround', 'IsDropped', 'WeaponTypeTag', 'WeaponTypeSoundOverrideTag')
    SELECT ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2"), "Index", "SubIndex", "ID", "VisKillStrengthMin", "VisKillStrengthMax", "ProjectileSpeed", "ProjectileTurnRateMin", "ProjectileTurnRateMax", "HitEffect", "HitEffectScale", "HitRadius", "ProjectileChildEffectScale", "AreaDamageDelay", "ContinuousFire", "WaitForEffectCompletion", "TargetGround", "IsDropped", "WeaponTypeTag", "WeaponTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberCombatWeapons" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_WARRIOR");
INSERT INTO "ArtDefine_UnitMemberInfos" ("Type", "Scale", "ZOffset", "Domain", "Model", "MaterialTypeTag", "MaterialTypeSoundOverrideTag")
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2"), "Scale", "ZOffset", "Domain",
            ("elf_warrior_v3.fxsxml"), "MaterialTypeTag", "MaterialTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberInfos" WHERE (Type = "ART_DEF_UNIT_MEMBER_WARRIOR");
-- V3
INSERT INTO "ArtDefine_UnitMemberCombats" ('UnitMemberType', 'EnableActions', 'DisableActions', 'MoveRadius', 'ShortMoveRadius', 'ChargeRadius', 'AttackRadius', 'RangedAttackRadius', 'MoveRate', 'ShortMoveRate', 'TurnRateMin', 'TurnRateMax', 'TurnFacingRateMin', 'TurnFacingRateMax', 'RollRateMin', 'RollRateMax', 'PitchRateMin', 'PitchRateMax', 'LOSRadiusScale', 'TargetRadius', 'TargetHeight', 'HasShortRangedAttack', 'HasLongRangedAttack', 'HasLeftRightAttack', 'HasStationaryMelee', 'HasStationaryRangedAttack', 'HasRefaceAfterCombat', 'ReformBeforeCombat', 'HasIndependentWeaponFacing', 'HasOpponentTracking', 'HasCollisionAttack', 'AttackAltitude', 'AltitudeDecelerationDistance', 'OnlyTurnInMovementActions', 'RushAttackFormation')
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V3"), "EnableActions", "DisableActions", "MoveRadius", "ShortMoveRadius", "ChargeRadius", "AttackRadius", "RangedAttackRadius",
            "MoveRate", "ShortMoveRate", "TurnRateMin", "TurnRateMax", "TurnFacingRateMin", "TurnFacingRateMax", "RollRateMin", "RollRateMax", "PitchRateMin", "PitchRateMax", "LOSRadiusScale", "TargetRadius", "TargetHeight", "HasShortRangedAttack", "HasLongRangedAttack", "HasLeftRightAttack", "HasStationaryMelee", "HasStationaryRangedAttack", "HasRefaceAfterCombat", "ReformBeforeCombat", "HasIndependentWeaponFacing", "HasOpponentTracking", "HasCollisionAttack", "AttackAltitude", "AltitudeDecelerationDistance", "OnlyTurnInMovementActions", "RushAttackFormation"
    FROM "ArtDefine_UnitMemberCombats" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_WARRIOR");
INSERT INTO "ArtDefine_UnitMemberCombatWeapons" ('UnitMemberType', 'Index', 'SubIndex', 'ID', 'VisKillStrengthMin', 'VisKillStrengthMax', 'ProjectileSpeed', 'ProjectileTurnRateMin', 'ProjectileTurnRateMax', 'HitEffect', 'HitEffectScale', 'HitRadius', 'ProjectileChildEffectScale', 'AreaDamageDelay', 'ContinuousFire', 'WaitForEffectCompletion', 'TargetGround', 'IsDropped', 'WeaponTypeTag', 'WeaponTypeSoundOverrideTag')
    SELECT ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V3"), "Index", "SubIndex", "ID", "VisKillStrengthMin", "VisKillStrengthMax", "ProjectileSpeed", "ProjectileTurnRateMin", "ProjectileTurnRateMax", "HitEffect", "HitEffectScale", "HitRadius", "ProjectileChildEffectScale", "AreaDamageDelay", "ContinuousFire", "WaitForEffectCompletion", "TargetGround", "IsDropped", "WeaponTypeTag", "WeaponTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberCombatWeapons" WHERE (UnitMemberType = "ART_DEF_UNIT_MEMBER_WARRIOR");
INSERT INTO "ArtDefine_UnitMemberInfos" ("Type", "Scale", "ZOffset", "Domain", "Model", "MaterialTypeTag", "MaterialTypeSoundOverrideTag")
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2"), "Scale", "ZOffset", "Domain",
            ("elf_warrior.fxsxml"), "MaterialTypeTag", "MaterialTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberInfos" WHERE (Type = "ART_DEF_UNIT_MEMBER_WARRIOR");

Will not work for some reason.
I assume it has to do with the variations on the elf (elvis) units.
I wonder Why though, is there a bug in this code?

 

[LeeS]

INSERT INTO "ArtDefine_UnitMemberInfos" ("Type", "Scale", "ZOffset", "Domain", "Model", "MaterialTypeTag", "MaterialTypeSoundOverrideTag")
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2"), "Scale", "ZOffset", "Domain",
            ("elf_warrior_v3.fxsxml"), "MaterialTypeTag", "MaterialTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberInfos" WHERE (Type = "ART_DEF_UNIT_MEMBER_WARRIOR");

INSERT INTO "ArtDefine_UnitMemberInfos" ("Type", "Scale", "ZOffset", "Domain", "Model", "MaterialTypeTag", "MaterialTypeSoundOverrideTag")
    SELECT    ("ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2"), "Scale", "ZOffset", "Domain",
            ("elf_warrior.fxsxml"), "MaterialTypeTag", "MaterialTypeSoundOverrideTag"
    FROM "ArtDefine_UnitMemberInfos" WHERE (Type = "ART_DEF_UNIT_MEMBER_WARRIOR");

I would think you'd be getting a syntax error for the repeat attempt to define ART_DEF_UNIT_MEMBER_WARRIOR_ELVIS_V2

 

[NO_Body]

Huh, i didn't see that. Thanks!
Same error on all 3, that's what i get for copy pasting.