[XML] [SQL] How to change a model of Landmark? Solved

[Protok St]

I wanna make a teamcolored Stations and later, Bases.

When I gonna with units it's works. Next sample for units: MOD/PW_UnitsSubColor.sql

UPDATE ArtDefine_UnitMemberInfos SET Model = 'marine04sp_clr.fxsxml' WHERE Type = 'ART_DEF_UNIT_MEMBER_MARINE04SP';

It goes to this table:assets\DLC\Expansion1\Units\CivBEArtDefines_UnitMembers_Expansion1.xml

  <UnitMemberArtInfo>
    <Type>ART_DEF_UNIT_MEMBER_MARINE04SP</Type>
    <fScale>0.16</fScale>
    <Granny>Marine04SP.fxsxml</Granny>
    <Combat>
      <Defaults>ART_DEF_TEMPLATE_SOLDIER</Defaults>
      <bReformBeforeCombat>1</bReformBeforeCombat>
      <bHasShortRangedAttack>1</bHasShortRangedAttack>
      <EnableActions>AttackSurfaceToAir</EnableActions>
      <Weapon>
        <fProjectileSpeed>4.0</fProjectileSpeed>
        <WeaponTypeTag>EXPLOSIVE</WeaponTypeTag>
        <WeaponTypeSoundOverrideTag>ACID</WeaponTypeSoundOverrideTag>
        <fHitRadius>15.0</fHitRadius>
        <fTargetHeight>5.0</fTargetHeight>
      </Weapon>
    </Combat>
    <MaterialTypeTag>CLOTH</MaterialTypeTag>
    <MaterialTypeSoundOverrideTag>FLESH</MaterialTypeSoundOverrideTag>
  </UnitMemberArtInfo>

with ths template: assets\SQL\CivBEEngineDatabaseSchema.sql

CREATE TABLE ArtDefine_UnitMemberInfos(    "Type" TEXT NOT NULL PRIMARY KEY, 
                                        "Scale" FLOAT, 
                                        "ZOffset" FLOAT,
                                        "OrbitalOffset" FLOAT,
                                        "Domain" TEXT,                                       
                                        "Model" TEXT NOT NULL,
                                        "MaterialTypeTag" TEXT,
                                        "MaterialTypeSoundOverrideTag" TEXT);

But when I try to do same for landmark - nothing happens.
Example of what I do for Landmark: MOD/PW_StructuresSubColor.sql

UPDATE ArtDefine_Landmarks SET Model = 'stationculturalocean_clr.fxsxml' WHERE ImprovementType = 'ART_DEF_IMPROVEMENT_STATION_CULTURAL';

It goes to this table: assets\DLC\Expansion1\Buildings\CivBEArtDefines_Landmarks.xml

    <LandmarkArtInfo>
        <Era>Any</Era>
        <State>Any</State>
        <fScale>1.0</fScale>
        <Layer>Land</Layer>
        <ImprovementType>ART_DEF_IMPROVEMENT_STATION_CULTURAL</ImprovementType>
        <LayoutHandler>SNAPSHOT</LayoutHandler>
        <ResourceType>ART_DEF_RESOURCE_NONE</ResourceType>
        <FXSXML>Assets/Buildings/Improvements/Stations/Cultural/StationCultural.fxsxml</FXSXML>
        <bTerrainContour>True</bTerrainContour>
    </LandmarkArtInfo>
    <LandmarkArtInfo>
        <Era>Any</Era>
        <State>Any</State>
        <fScale>1.0</fScale>
        <Layer>Shallow</Layer>
        <ImprovementType>ART_DEF_IMPROVEMENT_STATION_CULTURAL</ImprovementType>
        <LayoutHandler>SNAPSHOT</LayoutHandler>
        <ResourceType>ART_DEF_RESOURCE_NONE</ResourceType>
        <FXSXML>assets/DLC/Expansion1/Buildings/Landmarks/Stations/StationCulturalOCEAN/StationCulturalOCEAN.fxsxml</FXSXML>
        <bTerrainContour>False</bTerrainContour>
    </LandmarkArtInfo>
    <LandmarkArtInfo>
        <Era>Any</Era>
        <State>Any</State>
        <fScale>1.0</fScale>
        <Layer>Ocean</Layer>
        <ImprovementType>ART_DEF_IMPROVEMENT_STATION_CULTURAL</ImprovementType>
        <LayoutHandler>SNAPSHOT</LayoutHandler>
        <ResourceType>ART_DEF_RESOURCE_NONE</ResourceType>
        <FXSXML>assets/DLC/Expansion1/Buildings/Landmarks/Stations/StationCulturalOCEAN/StationCulturalOCEAN.fxsxml</FXSXML>
        <bTerrainContour>False</bTerrainContour>
    </LandmarkArtInfo>

with ths template: assets\SQL\CivBEEngineDatabaseSchema.sql

CREATE TABLE ArtDefine_Landmarks(    "Era" TEXT DEFAULT "Any",
                                    "State" TEXT DEFAULT "Any",
                                    "Layer" TEXT DEFAULT "Any",
                                    "Scale" FLOAT DEFAULT 1,
                                    "ImprovementType" TEXT NOT NULL,
                                    "LayoutHandler" TEXT NOT NULL,
                                    "ResourceType" TEXT NOT NULL,
                                    "Model" TEXT,
                                    "TerrainContour" INTEGER DEFAULT 0,
                                    "Tech" TEXT );

Why it's not working like that? How to make it works?

 

[Protok St]

Solved by another way: MOD\Art\Improvements\ArtDefines_Improvements.xml

<GameData>
    <ArtDefine_Landmarks>
        <Update>
            <Where Model="assets/DLC/Expansion1/Buildings/Landmarks/General/AlienHiveOCEAN/AlienHiveSHALLOW.fxsxml"/>
            <Set Model="StationCulturalOCEAN_clr.fxsxml"/>
        </Update>   
    </ArtDefine_Landmarks>
</GameData>

 

[Protok St]

It helps me again.