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

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

Code:

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

Code:

  <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

Code:

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

Code:

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

Code:

    <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

Code:

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?

 

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

Code:

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

 

It helps me again.