INSERT INTO ArtDefine_UnitInfoMemberInfos
(UnitInfoType, UnitMemberInfoType, NumMembers)
VALUES 'ART_DEF_UNIT_LEVY', 'ART_DEF_UNIT_MEMBER_LEVY_EURO', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY', 'ART_DEF_UNIT_MEMBER_LEVY_EURO2', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY', 'ART_DEF_UNIT_MEMBER_LEVY_EURO3', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_ASIA', 'ART_DEF_UNIT_MEMBER_LEVY_ASIA', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_ASIA', 'ART_DEF_UNIT_MEMBER_LEVY_ASIA2', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_ASIA', 'ART_DEF_UNIT_MEMBER_LEVY_ASIA3', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AMER', 'ART_DEF_UNIT_MEMBER_LEVY_AMER', '3' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AMER', 'ART_DEF_UNIT_MEMBER_LEVY_AMER2', '3' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AMER', 'ART_DEF_UNIT_MEMBER_LEVY_AMER3', '3' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AMER', 'ART_DEF_UNIT_MEMBER_LEVY_AMER4', '3' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AFRI', 'ART_DEF_UNIT_MEMBER_LEVY_AFRI', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AFRI', 'ART_DEF_UNIT_MEMBER_LEVY_AFRI2', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AFRI', 'ART_DEF_UNIT_MEMBER_LEVY_AFRI3', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_MIDEAST', 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_MIDEAST', 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST2', '4' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_MIDEAST', 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST3', '4' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRICAMEL', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIFEMALE1', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIFEMALE2', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIFEMALE3', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIFEMALE4', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIMALE1', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIMALE2', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIMALE3', '1' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 'ART_DEF_UNIT_MEMBER_AFRIMALE4', '1';
INSERT INTO ArtDefine_UnitInfos
(Type, DamageStates, Formation)
VALUES 'ART_DEF_UNIT_LEVY', 1, 'Barbarian' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_ASIA', 1, 'Barbarian' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AMER', 1, 'Barbarian' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AFRI', 1, 'Barbarian' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_MIDEAST', 1, 'Barbarian' UNION ALL
VALUES 'ART_DEF_UNIT__SETTLER_MIDEAST', 1, 'LooseCivilian';
INSERT INTO ArtDefine_UnitMemberInfos
(Type, Scale, ZOffset, Domain, Model, MaterialTypeTag, MaterialTypeSoundOverrideTag)
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO', 0.14, null, 'Land', 'levy2_euro.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO2', 0.14, null, 'Land', 'levy2_euro2.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO3', 0.14, null, 'Land', 'levy2_euro3.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA', 0.14, null, 'Land', 'levy2_asia.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA2', 0.14, null, 'Land', 'levy2_asia2.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA3', 0.14, null, 'Land', 'levy2_asia3.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER', 0.14, null, 'Land', 'levy2_amer.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER2', 0.14, null, 'Land', 'levy2_amer2.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER3', 0.14, null, 'Land', 'levy2_amer3.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER4', 0.14, null, 'Land', 'levy2_amer2b.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI', 0.14, null, 'Land', 'levy2_afri.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI2', 0.14, null, 'Land', 'levy2_afri2.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI3', 0.14, null, 'Land', 'levy2_afri3.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST', 0.14, null, 'Land', 'levy2_mideast.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST2', 0.14, null, 'Land', 'levy2_mideast2.fxsxml', 'CLOTH', 'FLESH' UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST3', 0.14, null, 'Land', 'levy2_mideast3.fxsxml', 'CLOTH', 'FLESH';
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)
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO2', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO3', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA2', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA3', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER2', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER3', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER4', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI2', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI3', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST2', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST3', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady Walk AttackCharge', null, null, 12, null, null, null, null, 0.35, null, null, null, null, null, null, null, null, null, null, 8, null, null, null, null, null, 1, 1, null, null, null, null, null, null, null;
INSERT INTO ArtDefine_UnitMemberCombatWeapons
(UnitMemberType, "Index", SubIndex, ID, VisKillStrengthMin, VisKillStrengthMax, ProjectileSpeed, ProjectileTurnRateMin, ProjectileTurnRateMax, HitEffect, HitEffectScale, HitRadius, ProjectileChildEffectScale, AreaDamageDelay, ContinuousFire, WaitForEffectCompletion, TargetGround, IsDropped, WeaponTypeTag, WeaponTypeSoundOverrideTag, MissTargetSlopRadius)
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO2', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO2', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO3', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_EURO3', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA2', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA2', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA3', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_ASIA3', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER2', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER2', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER3', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER3', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER4', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AMER4', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI2', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI2', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI3', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_AFRI3', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST2', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST2', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10 UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST3', 0, 0, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, METAL, SPEAR, null UNION ALL
VALUES 'ART_DEF_UNIT_MEMBER_LEVY_MIDEAST3', 1, 0, null, 10, 20, null, null, null, null, null, null, null, null, null, null, null, null, FLAMING_ARROW, null, 10;
INSERT INTO ArtDefine_StrategicView
(StrategicViewType, TileType, Asset)
VALUES 'ART_DEF_UNIT_LEVY', 'Unit', 'SV_Spearman.dds' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_ASIA', 'Unit', 'SV_Spearman.dds' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AMER', 'Unit', 'SV_Spearman.dds' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_AFRI', 'Unit', 'SV_Spearman.dds' UNION ALL
VALUES 'ART_DEF_UNIT_LEVY_MIDEAST', 'Unit', 'SV_Spearman.dds';
UPDATE Civilizations
SET ArtStyleSuffix = '_MIDEAST' WHERE Type = 'CIVILIZATION_ARABIA' UNION ALL
SET ArtStyleSuffix = '_MIDEAST' WHERE Type = 'CIVILIZATION_EGYPT' UNION ALL
SET ArtStyleSuffix = '_MIDEAST' WHERE Type = 'CIVILIZATION_OTTOMAN' UNION ALL
SET ArtStyleSuffix = '_MIDEAST' WHERE Type = 'CIVILIZATION_PERSIA' UNION ALL
SET ArtStyleSuffix = '_MIDEAST' WHERE Type = 'CIVILIZATION_BABYLON';