Add a new unit in the game (using SQL)

[fuzzy_bunnies]

OK I'm still having trouble. I redid everything based on the galleon sample, I just realized that G&K changed the way the XML files are formatted... but it still doesn't work. Can someone take a look at this and let me know what I'm missing? For now I'm trying to get them to work using existing units and existing icons so I didn't modify the icons xml or the memberinfo/combats/weapons tables. Sample selection below, I can post the whole thing if needed:

Spoiler :

<!-- ********************************************** -->


<ArtDefine_UnitInfos>
<Row>
<Type>ART_DEF_UNIT_ZOMBIE_HORDE</Type>
<DamageStates>1</DamageStates>
<Formation>Barbarian</Formation>
</Row>
</ArtDefine_UnitInfos>

<ArtDefine_UnitInfoMemberInfos>
<Row>
<UnitInfoType>ART_DEF_UNIT_ZOMBIE_HORDE</UnitInfoType>
<UnitMemberInfoType>ART_DEF_UNIT_MEMBER_BARBARIAN_EURO_ALPHA</UnitMemberInfoType>
<NumMembers>15</NumMembers>
</Row>
</ArtDefine_UnitInfoMemberInfos>

<ArtDefine_StrategicView>
<Row>
<StrategicViewType>ART_DEF_UNIT_ZOMBIE_HORDE</StrategicViewType>
<TileType>Unit</TileType>
<Asset>SV_AntiAircraftGun.dds</Asset>
</Row>
</ArtDefine_StrategicView>


<!-- ********************************************** -->


<ArtDefine_UnitInfos>
<Row>
<Type>ART_DEF_UNIT_CIVILIAN_MILITIA</Type>
<DamageStates>1</DamageStates>
<Formation>WARRIOR</Formation>
</Row>
</ArtDefine_UnitInfos>

<ArtDefine_UnitInfoMemberInfos>
<Row>
<UnitInfoType>ART_DEF_UNIT_CIVILIAN_MILITIA</UnitInfoType>
<UnitMemberInfoType>ART_DEF_UNIT_MEMBER_WARRIOR_V2</UnitMemberInfoType>
<NumMembers>3</NumMembers>
</Row>
</ArtDefine_UnitInfoMemberInfos>

<ArtDefine_StrategicView>
<Row>
<StrategicViewType>ART_DEF_UNIT_CIVILIAN_MILITIA</StrategicViewType>
<TileType>Unit</TileType>
<Asset>SV_AntiAircraftGun.dds</Asset>
</Row>
</ArtDefine_StrategicView>

<!-- ********************************************** -->


<ArtDefine_UnitInfos>
<Row>
<Type>ART_DEF_UNIT_SURVIVALIST</Type>
<DamageStates>1</DamageStates>
<Formation>UnFormed</Formation>
</Row>
</ArtDefine_UnitInfos>

<ArtDefine_UnitInfoMemberInfos>
<Row>
<UnitInfoType>ART_DEF_UNIT_SURVIVALIST</UnitInfoType>
<UnitMemberInfoType>ART_DEF_UNIT_MEMBER_INFANTRY</UnitMemberInfoType>
<NumMembers>2</NumMembers>
</Row>
</ArtDefine_UnitInfoMemberInfos>

<ArtDefine_StrategicView>
<Row>
<StrategicViewType>ART_DEF_UNIT_SURVIVALIST</StrategicViewType>
<TileType>Unit</TileType>
<Asset>SV_AntiAircraftGun.dds</Asset>
</Row>
</ArtDefine_StrategicView>

<!-- ********************************************** -->


<ArtDefine_UnitInfos>
<Row>
<Type>ART_DEF_UNIT_RANGER</Type>
<DamageStates>1</DamageStates>
<Formation>UnFormed</Formation>
</Row>
</ArtDefine_UnitInfos>

<ArtDefine_UnitInfoMemberInfos>
<Row>
<UnitInfoType>ART_DEF_UNIT_RANGER</UnitInfoType>
<UnitMemberInfoType>ART_DEF_UNIT_MEMBER_INFANTRY</UnitMemberInfoType>
<NumMembers>1</NumMembers>
</Row>
<Row>
<UnitInfoType>ART_DEF_UNIT_RANGER</UnitInfoType>
<UnitMemberInfoType>ART_DEF_UNIT_MEMBER_WORKER_EURO_LATE</UnitMemberInfoType>
<NumMembers>2</NumMembers>
</Row>
</ArtDefine_UnitInfoMemberInfos>

<ArtDefine_StrategicView>
<Row>
<StrategicViewType>ART_DEF_UNIT_RANGER</StrategicViewType>
<TileType>Unit</TileType>
<Asset>SV_AntiAircraftGun.dds</Asset>
</Row>
</ArtDefine_StrategicView>

<!-- ********************************************** -->

Thanks in advance for any assistance!

 

[whoward69]

I can post the whole thing if needed:

Probably best to start a new thread in the general forum (more people will see it there) and attach the zipped built mod (not the ModBuddy project but the built mod - should be in C:\Users\{username}\Documents\My Games\Sid Meier's Civilization 5\Mods) and any relevant info from the database.log file (you DO have logging enabled and are actually checking the log files)

 

[CoDazle]

So I have been following this thread and trying to figure out how to make a Unit based off of the Greek Hoplite just using a single unit that is a tad larger. But like many others, I am plagued by the spearman unit appearing with every attempt I have tried. I have attempted XML and SQL methods. Working on a mod that adds Champion Units to the game, I have the concept down, but would really like single unit graphics for my champion units

I have attached what I have so far. If anyone has any pointers let me know.

Spoiler :

INSERT INTO ArtDefine_UnitInfos (Type,DamageStates,Formation)
SELECT ('ART_DEF_UNIT_CHAMPION_SPEARMAN'), DamageStates, Formation
FROM ArtDefine_UnitInfos WHERE (Type = 'ART_DEF_UNIT_U_GREEK_HOPLITE');

INSERT INTO ArtDefine_UnitInfoMemberInfos (UnitInfoType,UnitMemberInfoType,NumMembers)
SELECT ('ART_DEF_UNIT_CHAMPION_SPEARMAN'), ('ART_DEF_UNIT_MEMBER_CHAMPION_SPEARMAN'), (1)
FROM ArtDefine_UnitInfoMemberInfos WHERE (UnitInfoType = 'ART_DEF_UNIT_U_GREEK_HOPLITE');

INSERT INTO ArtDefine_UnitMemberCombats (UnitMemberType, EnableActions, ShortMoveRadius, ShortMoveRate, TargetHeight, HasRefaceAfterCombat, ReformBeforeCombat)
SELECT ('ART_DEF_UNIT_MEMBER_CHAMPION_SPEARMAN'), UnitMemberType, EnableActions, ShortMoveRadius, ShortMoveRate, TargetHeight, HasRefaceAfterCombat, ReformBeforeCombat
FROM ArtDefine_UnitMemberCombats WHERE (UnitMemberType = 'ART_DEF_UNIT_MEMBER_U_GREEK_HOPLITE');

INSERT INTO ArtDefine_UnitMemberCombatWeapons (UnitMemberType, "Index", SubIndex, WeaponTypeTag, WeaponTypeSoundOverrideTag)
SELECT ('ART_DEF_UNIT_MEMBER_CHAMPION_SPEARMAN'), UnitMemberType, "Index", SubIndex, WeaponTypeTag, WeaponTypeSoundOverrideTag
FROM ArtDefine_UnitMemberCombatWeapons WHERE (UnitMemberType = 'ART_DEF_UNIT_MEMBER_U_GREEK_HOPLITE');

INSERT INTO ArtDefine_UnitMemberCombatWeapons (UnitMemberType, "Index", SubIndex, VisKillStrengthMin, VisKillStrengthMax, WeaponTypeTag, MissTargetSlopRadius)
SELECT ('ART_DEF_UNIT_MEMBER_CHAMPION_SPEARMAN'), UnitMemberType, "Index", SubIndex, VisKillStrengthMin, VisKillStrengthMax, WeaponTypeTag, MissTargetSlopRadius
FROM ArtDefine_UnitMemberCombatWeapons WHERE (UnitMemberType = 'ART_DEF_UNIT_MEMBER_U_GREEK_HOPLITE');

INSERT INTO ArtDefine_UnitMemberInfos (Type, Scale, Model, MaterialTypeTag, MaterialTypeSoundOverrideTag)
SELECT ('ART_DEF_UNIT_MEMBER_CHAMPION_SPEARMAN'), Type, (.20), Model, MaterialTypeTag, MaterialTypeSoundOverrideTag
FROM ArtDefine_UnitMemberInfos WHERE (Type = 'ART_DEF_UNIT_MEMBER_U_GREEK_HOPLITE');

INSERT INTO ArtDefine_StrategicView (StrategicViewType, TileType, Asset )
SELECT ('ART_DEF_UNIT_CHAMPION_SPEARMAN'), TileType, Asset
FROM ArtDefine_StrategicView WHERE (Type = 'ART_DEF_UNIT_U_GREEK_HOPLITE');

 

[whoward69]

Stmts 3 thru 6 give the error "N+1 values for N columns" and the last stmt complains about no such column Type

So, step 1 would be to enable logging. Step 2, to check and double check your typing

 

[Zaelon]

Hello fellow modders

I've been trying to follow your tutorial, along with some other resources you point at in this thread, but I haven't been too successful so far.
As I'm no 3D artist I used existing models from a working mod (Faerun from G&K) so the gr2, dds and all should be ok.
I followed your examples to make the sql and could get over the spearman bug. The units seem to display just fine when idle, they can move with animations (even though their movement range seems weird), and they can use ranged attack but with no animation - the ranged animation seems to work when triggered through firetuner though.
But the worst of all is that they respawn in the city they were made in every new turn !
I found nothing relevant in the logs and I didn't seem to find much more typing keywords in google.
So I was wondering if you guys had been through something like this and, if so, if you knew how to fix it !

Thanking you in advance for your time,
Cheers,
Chris

 

[Zaelon]

Okay, I figured it out.
It has nothing to do with the new models actually. Turns out I had also a wrong "domain" set for them !

 

[LakeTroll]

Complete newbie questions I know but here goes. How do I copy the art files into my mod? What is VFS and how do I work with it? None of the intro tutorials I've read including Kael's seem to mention this stuff. If anyone could point me to a source of information on these subjects I would be very grateful.

 

[Gedemon]

Yes, Kael' guide was made before the introduction of the vitual file system. See the modiki (link is in the top menu), and specifically here for the VFS.

 

[Immk]

I cant get the models to work, i only see a spearman.

This is the code of my sql.

Spoiler :

INSERT INTO ArtDefine_UnitInfos (Type,DamageStates,Formation)
SELECT ('ART_DEF_UNIT_BIPLAN'), DamageStates, Formation
FROM ArtDefine_UnitInfos WHERE (Type = 'ART_DEF_UNIT_FIGHTER');

INSERT INTO ArtDefine_UnitInfoMemberInfos (UnitInfoType,UnitMemberInfoType,NumMembers)
SELECT ('ART_DEF_UNIT_BIPLAN'), ('ART_DEF_UNIT_MEMBER_BIPLAN'), NumMembers
FROM ArtDefine_UnitInfoMemberInfos WHERE (UnitInfoType = 'ART_DEF_UNIT_FIGHTER');

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_BIPLAN'), 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_FIGHTER');

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_BIPLAN'), "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_FIGHTER');

INSERT INTO ArtDefine_UnitMemberInfos (Type, Scale, ZOffset, Domain, Model, MaterialTypeTag, MaterialTypeSoundOverrideTag)
SELECT ('ART_DEF_UNIT_MEMBER_BIPLAN'), Scale, ZOffset, Domain, ('EarlyFighter_Generic.fxsxml'), MaterialTypeTag, MaterialTypeSoundOverrideTag
FROM ArtDefine_UnitMemberInfos WHERE (Type = 'ART_DEF_UNIT_MEMBER_FIGHTER');

INSERT INTO ArtDefine_StrategicView (StrategicViewType, TileType, Asset )
SELECT ('ART_DEF_UNIT_BIPLAN'), TileType, Asset
FROM ArtDefine_StrategicView WHERE (StrategicViewType = 'ART_DEF_UNIT_FIGHTER');

--La mierda se separa aqui--

INSERT INTO UnitClasses (Type, Description, MaxGlobalInstances, MaxTeamInstances, MaxPlayerInstances, InstanceCostModifier, DefaultUnit )
SELECT ('UNITCLASS_BIPLAN'), Description, MaxGlobalInstances, MaxTeamInstances, MaxPlayerInstances, InstanceCostModifier, ('UNIT_BIPLAN')
FROM UnitClasses WHERE (Type = 'UNITCLASS_FIGHTER');

INSERT INTO Units (Type, Description, Civilopedia, Strategy, Help, Requirements, Combat, RangedCombat, Cost, Moves, Immobile, Range, BaseSightRange, Class, Special, Capture, CombatClass, Domain, CivilianAttackPriority, DefaultUnitAI, Food, NoBadGoodies, RivalTerritory, MilitarySupport, MilitaryProduction, Pillage, Found, FoundAbroad, CultureBombRadius, GoldenAgeTurns, IgnoreBuildingDefense, PrereqResources, Mechanized, Suicide, CaptureWhileEmbarked, PrereqTech, ObsoleteTech, GoodyHutUpgradeUnitClass, HurryCostModifier, AdvancedStartCost, MinAreaSize, AirUnitCap, NukeDamageLevel, WorkRate, NumFreeTechs, RushBuilding, BaseHurry, HurryMultiplier, BaseGold, NumGoldPerEra, SpreadReligion, CombatLimit, RangeAttackOnlyInDomain, RangeAttackIgnoreLOS, RangedCombatLimit, XPValueAttack, XPValueDefense, SpecialCargo, DomainCargo, Conscription, ExtraMaintenanceCost, NoMaintenance, Unhappiness, UnitArtInfo, UnitArtInfoCulturalVariation, UnitArtInfoEraVariation, ProjectPrereq, SpaceshipProject, LeaderPromotion, LeaderExperience, DontShowYields, ShowInPedia, MoveRate, UnitFlagIconOffset, PortraitIndex, IconAtlas, UnitFlagAtlas)
SELECT ('UNIT_BIPLAN'), ('Biplan'), Civilopedia, Strategy, Help, Requirements,
Combat, (25), (250), Moves, Immobile, (5), BaseSightRange, ('UNITCLASS_BIPLAN'), Special, Capture, CombatClass, Domain, CivilianAttackPriority, DefaultUnitAI, Food, NoBadGoodies, RivalTerritory, MilitarySupport, MilitaryProduction, Pillage, Found, FoundAbroad, CultureBombRadius, GoldenAgeTurns, IgnoreBuildingDefense, PrereqResources, Mechanized, Suicide, CaptureWhileEmbarked, PrereqTech, ObsoleteTech, GoodyHutUpgradeUnitClass, HurryCostModifier, AdvancedStartCost, MinAreaSize, AirUnitCap, NukeDamageLevel, WorkRate, NumFreeTechs, RushBuilding, BaseHurry, HurryMultiplier, BaseGold, NumGoldPerEra, SpreadReligion, CombatLimit, RangeAttackOnlyInDomain, RangeAttackIgnoreLOS, RangedCombatLimit, XPValueAttack, XPValueDefense, SpecialCargo, DomainCargo, Conscription, ExtraMaintenanceCost, NoMaintenance, Unhappiness,
('ART_DEF_UNIT_BIPLAN'), UnitArtInfoCulturalVariation, UnitArtInfoEraVariation, ProjectPrereq, SpaceshipProject, LeaderPromotion, LeaderExperience, DontShowYields, ShowInPedia, MoveRate,
UnitFlagIconOffset, PortraitIndex, IconAtlas, UnitFlagAtlas
FROM Units WHERE (Type = 'UNIT_FIGHTER');

INSERT INTO Unit_AITypes (UnitType, UnitAIType)
SELECT ('UNIT_BIPLAN'), UnitAIType
FROM Unit_AITypes WHERE (UnitType = 'UNIT_FIGHTER');

INSERT INTO Unit_ClassUpgrades (UnitType, UnitClassType)
SELECT ('UNIT_BIPLAN'), UnitClassType
FROM Unit_ClassUpgrades WHERE (UnitType = 'UNIT_FIGHTER');

INSERT INTO Unit_Flavors (UnitType, FlavorType, Flavor)
SELECT ('UNIT_BIPLAN'), FlavorType, Flavor
FROM Unit_Flavors WHERE (UnitType = 'UNIT_FIGHTER');

INSERT INTO Unit_FreePromotions (UnitType, PromotionType)
SELECT ('UNIT_BIPLAN'), PromotionType
FROM Unit_FreePromotions WHERE (UnitType = 'UNIT_FIGHTER');

INSERT INTO Unit_ResourceQuantityRequirements (UnitType, ResourceType, Cost)
SELECT ('UNIT_BIPLAN'), ResourceType, Cost
FROM Unit_ResourceQuantityRequirements WHERE (UnitType = 'UNIT_FIGHTER');

This is a screen of how my project looks

Spoiler :

Sorry for my bad english. Also sorry if my too bad at modding im really newbie at it.

 

[Nutty]

Immk,
There don't seem to be any problems with your SQL. Are you sure all 4 of the unit art files are VFS=true and you have Reload Unit System activated?

Can you attach the built mod? While you're at it, you can make sure you have logging enabled, then after you have started a new game with your mod activated, post the contents of your database.log.

 

[Immk]

-- Nervermind --

What happened is that i forgot to check the box of Reload Unit System on the mod properties.

Thank you for the help.

 

[Nutty]

No, that error comes from someone sloppy at Firaxis for the base game. The errors from your mod are:

[964.320] Invalid Reference on Units.Description - "Biplan" does not exist in Language_en_US
[964.413] Invalid Reference on UnitPromotions.PediaEntry - "TXT_KEY_PROMOTION_WITHDRAW_BEFORE_MELEE" does not exist in Language_en_US
[964.444] Invalid Reference on UnitPromotions.Help - "TXT_KEY_PROMOTION_WITHDRAW_BEFORE_MELEE_HELP" does not exist in Language_en_US
[964.491] Invalid Reference on UnitPromotions.Description - "TXT_KEY_PROMOTION_WITHDRAW_BEFORE_MELEE" does not exist in Language_en_US
[964.491] Failed Validation.

But I don't think that would cause spearman to display for your unit. Please post the built mod.

 

[AngelsFallFirst]

Hi, Im totally new to modding< just started a project in which i want to add a A9 Cruiser MKI tank ingame.

This may sound stupid, but what do i need to make the mod apper in the MODS section in the game. The game doesnt see my mod. or did i miss anything.

Here's the code:

Spoiler :

-- Insert SQL Rules Here 

-- A9 Cruiser Mk I
INSERT INTO ArtDefine_UnitInfos(Type, DamageStates, Formation)
	SELECT ('ART_DEF_UNIT_A9_CRUISER_MK_I'), DamageStates, Formation
	FROM ArtDefine_UnitInfos WHERE (Type = 'ART_DEF_UNIT_TANK');
	VALUES ('ART_DEF_UNIT_A9_CRUISER_MK_I', 1, 'Vehicle');

INSERT INTO ArtDefine_UnitInfoMemberInfos(UnitInfoType, UnitMemberInfoType, NumMembers)
	SELECT	('ART_DEF_UNIT_A9_CRUISER_MK_I'), ('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), NumMembers
	FROM ArtDefine_UnitInfoMemberInfos WHERE (UnitInfoType = 'ART_DEF_UNIT_TANK');
	VALUES ('ART_DEF_UNIT_A9_CRUISER_MK_I', 'ART_DEF_UNIT_MEMBER_TANK', 3);

INSERT INTO ArtDefine_UnitMemberInfos(Type, Scale, Model, MaterialTypeTag, MaterialTypeSoundOverrideTag)
	SELECT	('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), Scale, ZOffset, Domain, ('A9_Cruiser_MK_I.fxsxml'), MaterialTypeTag, MaterialTypeSoundOverrideTag
	FROM ArtDefine_UnitMemberInfos WHERE (Type = 'ART_DEF_UNIT_MEMBER_TANK');
	VALUES ('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I', 0.10999999940395355, 'Assets/Units/Tank/Tank.fxsxml', 'METAL', 'METALSM');

INSERT INTO ArtDefine_UnitMemberCombats(UnitMemberType, EnableActions, HasShortRangedAttack, HasStationaryMelee, HasRefaceAfterCombat, ReformBeforeCombat, HasIndependentWeaponFacing)
	SELECT	('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), 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_TANK');
	VALUES ('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I', 'Idle Attack RunCharge AttackCity Bombard Death BombardDefend Run Fortify CombatReady', 1, 1, 0, 1, 1);

INSERT INTO ArtDefine_UnitMemberCombatWeapons(UnitMemberType, "Index", SubIndex, VisKillStrengthMin, VisKillStrengthMax, HitEffect, WeaponTypeTag, WeaponTypeSoundOverrideTag)
	SELECT ('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), "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_TANK');
	VALUES ('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I', 0, 0, 25.0, 50.0, 'ART_DEF_VEFFECT_TANK_IMPACT_$(TERRAIN)', 'EXPLOSIVE', 'EXPLOSION6POUND');

INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset)
	SELECT	('ART_DEF_UNIT_A9_CRUISER_MK_I'), TileType, Asset
	FROM ArtDefine_StrategicView WHERE (StrategicViewType = 'ART_DEF_UNIT_TANK');
	VALUES ('ART_DEF_UNIT_A9_CRUISER_MK_I', 'Unit', 'A9_Cruiser_MK_I.dds');





INSERT INTO UnitClasses (Type, Description, MaxGlobalInstances, MaxTeamInstances, MaxPlayerInstances, InstanceCostModifier, DefaultUnit )
	SELECT ('UNITCLASS_A9_CRUISER_MK_I'), Description, MaxGlobalInstances, MaxTeamInstances, MaxPlayerInstances, InstanceCostModifier, ('UNIT_A9_CRUISER_MK_I')
	FROM UnitClasses WHERE (Type = 'UNITCLASS_TANK');

INSERT INTO Units (Type, Description, Civilopedia, Strategy, Help, Requirements, Combat, RangedCombat, Cost, Moves, Immobile, Range, BaseSightRange, Class, Special, Capture, CombatClass, Domain, CivilianAttackPriority, DefaultUnitAI, Food, NoBadGoodies, RivalTerritory, MilitarySupport, MilitaryProduction, Pillage, Found, FoundAbroad, CultureBombRadius, GoldenAgeTurns, IgnoreBuildingDefense, PrereqResources, Mechanized, Suicide, CaptureWhileEmbarked, PrereqTech, ObsoleteTech, GoodyHutUpgradeUnitClass, HurryCostModifier, AdvancedStartCost, MinAreaSize, AirUnitCap, NukeDamageLevel, WorkRate, NumFreeTechs, RushBuilding, BaseHurry, HurryMultiplier, BaseGold, NumGoldPerEra, SpreadReligion, IsReligious, CombatLimit, RangeAttackOnlyInDomain, RangeAttackIgnoreLOS, RangedCombatLimit, XPValueAttack, XPValueDefense, SpecialCargo, DomainCargo, Conscription, ExtraMaintenanceCost, NoMaintenance, Unhappiness, UnitArtInfo, UnitArtInfoCulturalVariation, UnitArtInfoEraVariation, ProjectPrereq, SpaceshipProject, LeaderPromotion, LeaderExperience, DontShowYields, ShowInPedia, MoveRate, UnitFlagIconOffset, PortraitIndex, IconAtlas, UnitFlagAtlas)
	SELECT	('UNIT_A9_CRUISER_MK_I'), ('A9 Cruiser MKI'), ('TXT_KEY_UNIT_A9_CRUISER_MKI'),  Civilopedia, Strategy, Help, Requirements, Combat, RangedCombat, Cost, Moves, Immobile, Range, BaseSightRange, Class, Special, Capture, CombatClass, Domain, CivilianAttackPriority, DefaultUnitAI, Food, NoBadGoodies, RivalTerritory, MilitarySupport, MilitaryProduction, Pillage, Found, FoundAbroad, CultureBombRadius, GoldenAgeTurns, IgnoreBuildingDefense, PrereqResources, Mechanized, Suicide, CaptureWhileEmbarked, PrereqTech, ObsoleteTech, GoodyHutUpgradeUnitClass, HurryCostModifier, AdvancedStartCost, MinAreaSize, AirUnitCap, NukeDamageLevel, "WorkRate", NumFreeTechs, RushBuilding, BaseHurry, HurryMultiplier, BaseGold, NumGoldPerEra, SpreadReligion, IsReligious, CombatLimit, RangeAttackOnlyInDomain, RangeAttackIgnoreLOS, RangedCombatLimit, XPValueAttack, XPValueDefense, SpecialCargo, DomainCargo, Conscription, ExtraMaintenanceCost, NoMaintenance, Unhappiness,
			('ART_DEF_UNIT_A9_CRUISER_MK_I'), UnitArtInfoCulturalVariation, UnitArtInfoEraVariation, ProjectPrereq, SpaceshipProject, LeaderPromotion, LeaderExperience, DontShowYields, ShowInPedia, MoveRate, ("1"), PortraitIndex, IconAtlas
	FROM Units WHERE (Type = 'UNIT_TANK');

INSERT INTO Language_en_US ( Tag, Text )
	VALUES ( 'TXT_KEY_UNIT_A9_CRUISER_MKI', 'A9 Cruiser MKI' );

INSERT INTO Unit_AITypes (UnitType, UnitAIType)
	SELECT ('UNIT_A9_CRUISER_MK_I'), UnitAIType
	FROM Unit_AITypes WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_ClassUpgrades (UnitType, UnitClassType)
	SELECT ('UNIT_A9_CRUISER_MK_I'), UnitClassType
	FROM Unit_ClassUpgrades WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_Flavors (UnitType, FlavorType, Flavor)
	SELECT ('UNIT_A9_CRUISER_MK_I'), FlavorType, Flavor
	FROM Unit_Flavors WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_FreePromotions (UnitType, PromotionType)
	SELECT ('UNIT_A9_CRUISER_MKI'), PromotionType
	FROM Unit_FreePromotions WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_ResourceQuantityRequirements (UnitType, ResourceType, Cost)
	SELECT ('UNIT_A9_CRUISER_MKI'), ResourceType, Cost
	FROM Unit_ResourceQuantityRequirements WHERE (UnitType = 'UNIT_TANK');

 

[Nutty]

what do i need to make the mod apper in the MODS section in the game. The game doesnt see my mod. or did i miss anything.

Did you Build it in ModBuddy?

Your SQLite syntax isn't right. You either use a SELECT (to make a copy of an existing row with some changes) or a VALUES (insert a brand new line and specify all the values), but you're trying to do both at once.

 

[AngelsFallFirst]

yes I did build it in SQL, hmmm I,ll remove VALUES then and see what happens

 

[AngelsFallFirst]

Ok, the code looks like this now, the game sees the mod, but i cant build the new unit. its still the vanilla TANK and no signs of the new unit... what could be the problem?

I want it to be available only for england, well in this case. Not to replace the vanilla tank, but as alternative tank in the building list.

code:

Spoiler :

-- Insert SQL Rules Here 

INSERT INTO ArtDefine_UnitInfos(Type, DamageStates, Formation)
	SELECT ('ART_DEF_UNIT_A9_CRUISER_MK_I'), DamageStates, Formation
	FROM ArtDefine_UnitInfos WHERE (Type = 'ART_DEF_UNIT_TANK');

INSERT INTO ArtDefine_UnitInfoMemberInfos(UnitInfoType, UnitMemberInfoType, NumMembers)
	SELECT	('ART_DEF_UNIT_A9_CRUISER_MK_I'), ('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), NumMembers
	FROM ArtDefine_UnitInfoMemberInfos WHERE (UnitInfoType = 'ART_DEF_UNIT_TANK');

INSERT INTO ArtDefine_UnitMemberInfos(Type, Scale, Model, MaterialTypeTag, MaterialTypeSoundOverrideTag)
	SELECT	('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), Scale, ZOffset, Domain, ('A9_Cruiser_MK_I.fxsxml'), MaterialTypeTag, MaterialTypeSoundOverrideTag
	FROM ArtDefine_UnitMemberInfos WHERE (Type = 'ART_DEF_UNIT_MEMBER_TANK');

INSERT INTO ArtDefine_UnitMemberCombats(UnitMemberType, EnableActions, HasShortRangedAttack, HasStationaryMelee, HasRefaceAfterCombat, ReformBeforeCombat, HasIndependentWeaponFacing)
	SELECT	('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), 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_TANK');

INSERT INTO ArtDefine_UnitMemberCombatWeapons(UnitMemberType, "Index", SubIndex, VisKillStrengthMin, VisKillStrengthMax, HitEffect, WeaponTypeTag, WeaponTypeSoundOverrideTag)
	SELECT ('ART_DEF_UNIT_MEMBER_A9_CRUISER_MK_I'), "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_TANK');

INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset)
	SELECT	('ART_DEF_UNIT_A9_CRUISER_MK_I'), TileType, Asset
	FROM ArtDefine_StrategicView WHERE (StrategicViewType = 'ART_DEF_UNIT_TANK');


-- A9 Cruiser Mk I

INSERT INTO UnitClasses (Type, Description, MaxGlobalInstances, MaxTeamInstances, MaxPlayerInstances, InstanceCostModifier, DefaultUnit )
	SELECT ('UNITCLASS_A9_CRUISER_MK_I'), Description, MaxGlobalInstances, MaxTeamInstances, MaxPlayerInstances, InstanceCostModifier, ('UNIT_A9_CRUISER_MKI')
	FROM UnitClasses WHERE (Type = 'UNITCLASS_TANK');

INSERT INTO Units (Type, Description, Civilopedia, Strategy, Help, Requirements, Combat, RangedCombat, Cost, Moves, Immobile, Range, BaseSightRange, Class, Special, Capture, CombatClass, Domain, CivilianAttackPriority, DefaultUnitAI, Food, NoBadGoodies, RivalTerritory, MilitarySupport, MilitaryProduction, Pillage, Found, FoundAbroad, CultureBombRadius, GoldenAgeTurns, IgnoreBuildingDefense, PrereqResources, Mechanized, Suicide, CaptureWhileEmbarked, PrereqTech, ObsoleteTech, GoodyHutUpgradeUnitClass, HurryCostModifier, AdvancedStartCost, MinAreaSize, AirUnitCap, NukeDamageLevel, WorkRate, NumFreeTechs, RushBuilding, BaseHurry, HurryMultiplier, BaseGold, NumGoldPerEra, SpreadReligion, IsReligious, CombatLimit, RangeAttackOnlyInDomain, RangeAttackIgnoreLOS, RangedCombatLimit, XPValueAttack, XPValueDefense, SpecialCargo, DomainCargo, Conscription, ExtraMaintenanceCost, NoMaintenance, Unhappiness, UnitArtInfo, UnitArtInfoCulturalVariation, UnitArtInfoEraVariation, ProjectPrereq, SpaceshipProject, LeaderPromotion, LeaderExperience, DontShowYields, ShowInPedia, MoveRate, UnitFlagIconOffset, PortraitIndex, IconAtlas, UnitFlagAtlas)
	SELECT	('UNIT_A9_CRUISER_MK_I'), ('A9 Cruiser MKI'),  Civilopedia, Strategy, Help, Requirements, Combat, RangedCombat, Cost, Moves, Immobile, Range, BaseSightRange, Class, Special, Capture, CombatClass, Domain, CivilianAttackPriority, DefaultUnitAI, Food, NoBadGoodies, RivalTerritory, MilitarySupport, MilitaryProduction, Pillage, Found, FoundAbroad, CultureBombRadius, GoldenAgeTurns, IgnoreBuildingDefense, PrereqResources, Mechanized, Suicide, CaptureWhileEmbarked, PrereqTech, ObsoleteTech, GoodyHutUpgradeUnitClass, HurryCostModifier, AdvancedStartCost, MinAreaSize, AirUnitCap, NukeDamageLevel, "WorkRate", NumFreeTechs, RushBuilding, BaseHurry, HurryMultiplier, BaseGold, NumGoldPerEra, SpreadReligion, IsReligious, CombatLimit, RangeAttackOnlyInDomain, RangeAttackIgnoreLOS, RangedCombatLimit, XPValueAttack, XPValueDefense, SpecialCargo, DomainCargo, Conscription, ExtraMaintenanceCost, NoMaintenance, Unhappiness,
			('ART_DEF_UNIT_A9_CRUISER_MK_I'), UnitArtInfoCulturalVariation, UnitArtInfoEraVariation, ProjectPrereq, SpaceshipProject, LeaderPromotion, LeaderExperience, DontShowYields, ShowInPedia, MoveRate, ("1"), PortraitIndex, IconAtlas
	FROM Units WHERE (Type = 'UNIT_TANK');

INSERT INTO Unit_AITypes (UnitType, UnitAIType)
	SELECT ('UNIT_A9_CRUISER_MK_I'), UnitAIType
	FROM Unit_AITypes WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_ClassUpgrades (UnitType, UnitClassType)
	SELECT ('UNIT_A9_CRUISER_MK_I'), UnitClassType
	FROM Unit_ClassUpgrades WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_Flavors (UnitType, FlavorType, Flavor)
	SELECT ('UNIT_A9_CRUISER_MK_I'), FlavorType, Flavor
	FROM Unit_Flavors WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_FreePromotions (UnitType, PromotionType)
	SELECT ('UNIT_A9_CRUISER_MK_I'), PromotionType
	FROM Unit_FreePromotions WHERE (UnitType = 'UNIT_TANK');

INSERT INTO Unit_ResourceQuantityRequirements (UnitType, ResourceType, Cost)
	SELECT ('UNIT_A9_CRUISER_MK_I'), ResourceType, Cost
	FROM Unit_ResourceQuantityRequirements WHERE (UnitType = 'UNIT_TANK');

 

[Gedemon]

what's in the database.log ?

 

[AngelsFallFirst]

<?xml version="1.0" encoding="utf-8"?>
<Mod id="bdc97a4c-4425-4104-a37a-7f1d7218af69" version="1">
<Properties>
<Name>A9 Cruiser MKI</Name>
<Stability>Alpha</Stability>
<Teaser>A9 Cruiser MKI Tank</Teaser>
<Description>Experimental Mod</Description>
<Authors>Ophidian</Authors>
<HideSetupGame>0</HideSetupGame>
<AffectsSavedGames>1</AffectsSavedGames>
<MinCompatibleSaveVersion>0</MinCompatibleSaveVersion>
<SupportsSinglePlayer>1</SupportsSinglePlayer>
<SupportsMultiplayer>1</SupportsMultiplayer>
<SupportsMac>1</SupportsMac>
<ReloadLandmarkSystem>0</ReloadLandmarkSystem>
<ReloadStrategicViewSystem>0</ReloadStrategicViewSystem>
<ReloadUnitSystem>1</ReloadUnitSystem>
</Properties>
<Dependencies />
<References />
<Blocks />
<Files>
<File md5="B6303B4AA2BEBC0AC32A64660ED8E55F" import="0">SQL/Values.sql</File>
<File md5="539828CF96AAD114F91101A93C873B58" import="0">SQL/NewUnits.sql</File>
<File md5="34C07015AC8580ED079C71C397675229" import="1">UK/Army/A9_Cruiser_MK_I/A9_Cruiser_MK_I.dds</File>
<File md5="3F01AC32C18D45E5B3FAED951E6B678F" import="1">UK/Army/A9_Cruiser_MK_I/A9_Cruiser_MK_I.fxsxml</File>
<File md5="22EAE9AE4509E8A261AD316CBCCB1EA7" import="1">UK/Army/A9_Cruiser_MK_I/A9_Cruiser_MK_I.gr2</File>
<File md5="AC41C06BA721315512F26433220FEDF7" import="1">UK/Army/A9_Cruiser_MK_I/no_gloss.dds</File>
<File md5="39D65B3F27C06B95E2F6FA28F1E19BF6" import="0">XML/UnitText.xml</File>
</Files>
<Actions>
<OnModActivated>
<UpdateDatabase>NewUnits.sql</UpdateDatabase>
<UpdateDatabase>Values.sql</UpdateDatabase>
</OnModActivated>
</Actions>
</Mod>

 

[Gedemon]

nop, the database.log, in the log folder

you need to activate logging first (see whoward's tutorial in this section)

 

[Riker13]

Many thanks for this Gedemon (and others who contributed) it helped me in starting out on SQL.

Regards

Riker13