原创MOD-长城基本特性增强MOD-请求设置回复可见，谢谢！

hizhj

这是本人制作的第一个MOD，基于chenhuamin092老大的Ming Great Wall，长城增强MOD并大幅简化，仅仅涉及长城在Improvements.xml文件和Expansion2_Improvements.xml文件中的定义及功能的修改。
再一次致意chenhuamin092老大！
文明6长城加强版MOD by chenhuamin092
https://bbs.3dmgame.com/thread-6097956-1-1.html

本MOD的主要修改：
1、删除前置科技需求，增加掠夺值到200，允许建在国外，可以不连续，不必建在边界，提高防御点数，可以进驻工人，提供4个住房。
2、允许建在山上并通过长城通过山脉。
3、可以建在绝大多数的地形和地貌上。
4、修建在资源之上不铲除资源。
5、6种产出均为5（请自行增减）。
6、相邻6种产出均为2（请自行增减）。
7、工人/建造者修建，不消耗修建次数。

注意：可能需要重新开档；
可能需要删除数据库CACHE（我的文档\My Games\Sid Meier's Civilization VI\Cache）；
LoadOrder=200，与其他MOD冲突的可能性较低；
其他功能及特性保留原版设定。

本MOD的ID是用chenhuamin092老大的ID稍微更改了数字而得，创意工坊查不到。

其他功能目前不会，将来可能学会后更新，也许不更新。

by hizhj
20210518

MOD文件：

游客，如果您要查看本帖隐藏内容请回复

hizhj

MOD效果

---

建造者的能力：

两种长城，一个是系统自带的，一个是长城加强MOD里的明长城。


建在山上的长城

---

如果有问题，请，嗯，怎么能让我知道呢？回帖的话头几页是可以看。那就回帖说吧！

---

版本更新历史：
20210518：新建MOD

myqqmm521

支持大佬666，正好在找长城的mod

hizhj

myqqmm521 发表于 2021-5-18 15:19
支持大佬666，正好在找长城的mod

不是大佬。谢谢回复！

共同进步！

hizhj

MOD制作心路历程


前置PS：对几个MOD的学习分析测试：
关于道路和单位经验增强MOD及文明6长城加强版MOD（二楼）的测试历程及个人体会
https://bbs.3dmgame.com/forum.php?mod=viewthread&tid=6173330&page=1&extra=#pid274270073




1、部分初始设置资料
SELECT *
FROM Improvements
WHERE ImprovementType="IMPROVEMENT_GREAT_WALL"
结果：
ImprovementType,Name,BarbarianCamp,PrereqTech,PrereqCivic,Buildable,Description,RemoveOnEntry,DispersalGold,PlunderType,PlunderAmount,Goody,TilesPerGoody,GoodyRange,Icon,TraitType,Housing,TilesRequired,SameAdjacentValid,RequiresRiver,EnforceTerrain,BuildInLine,CanBuildOutsideTerritory,BuildOnFrontier,AirSlots,DefenseModifier,GrantFortification,MinimumAppeal,Coast,YieldFromAppeal,WeaponSlots,ReligiousUnitHealRate,Appeal,OnePerCity,YieldFromAppealPercent,ValidAdjacentTerrainAmount,Domain,AdjacentSeaResource,RequiresAdjacentBonusOrLuxury,MovementChange,Workable,ImprovementOnRemove,GoodyNotify,NoAdjacentSpecialtyDistrict,RequiresAdjacentLuxury,AdjacentToLand,Removable,OnlyOpenBorders,Capturable
IMPROVEMENT_GREAT_WALL        LOC_IMPROVEMENT_GREAT_WALL_NAME        0                        1        LOC_IMPROVEMENT_GREAT_WALL_EXPANSION2_DESCRIPTION        0        0        PLUNDER_GOLD        50        0                        ICON_IMPROVEMENT_GREAT_WALL        TRAIT_CIVILIZATION_IMPROVEMENT_GREAT_WALL        3        1        1        0        0        0        1        0        0        8        4                0                0        0        0        0        100        0        DOMAIN_LAND        0        0        0        1                1        0        0        0        1        0        1
#
SELECT *
FROM Improvement_ValidBuildUnits
WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
结果：
ImprovementType        UnitType        ConsumesCharge        ValidRepairOnly
IMPROVEMENT_GREAT_WALL        UNIT_BUILDER        1        0
#
SELECT *
FROM Improvements_XP2
WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
结果：
ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant
IMPROVEMENT_GREAT_WALL        0        0        0        1

2、MyGreatWallEnhance.modinfo
<?xml version="1.0" encoding="utf-8"?>
<Mod id="6126d6cd-fedc-451b-aaa7-40f41988c5ee" version="1">

  <Properties>
    <Name>MyGreatWallEnhance</Name>
    <Description>增加可以修建长城的地形、地貌；在资源上建长城不删除资源。</Description>
    <Created>hizhj</Created>
    <Teaser>长城增强</Teaser>
    <Authors>hizhj</Authors>
    <SpecialThanks>chenhuamin092</SpecialThanks>
    <CompatibleVersions>1.2,2.0</CompatibleVersions>
  </Properties>

  <InGameActions>
    <UpdateDatabase id="GreatWallEnhance">
                <Properties>
                        <LoadOrder>200</LoadOrder>
                </Properties>
      <File>MyGreatWallEnhance-Improvements.xml</File>
    </UpdateDatabase>
  </InGameActions>

  <Files>
    <File>MyGreatWallEnhance-Improvements.xml</File>
  </Files>

</Mod>

3、MyGreatWallEnhance-Improvements.xml
<?xml version="1.0" encoding="utf-8"?>
<!-- GameData1 -->
<!-- Author: hizhj -->
<!-- DateCreated: 2021/05/18 9:18:36 -->
<GameData>
        <Improvements>
                <Update>
                        <Where ImprovementType="IMPROVEMENT_GREAT_WALL"/>
                        <Set PrereqTech=NULL PlunderType="PLUNDER_GOLD" PlunderAmount="200" Housing="4" Buildable="1" Housing="4" TilesRequired="1" BuildInLine="0" CanBuildOutsideTerritory="1" BuildOnFrontier="0" DefenseModifier="8" GrantFortification="4" Workable="1" />
                </Update>
        </Improvements>

     <!-- 增加可以修建在山脉上 不会被自然掠夺  -->
        <Improvements_XP2>
        <Row ImprovementType="IMPROVEMENT_GREAT_WALL"  BuildOnAdjacentPlot="true"  DisasterResistant="true"/>
        </Improvements_XP2>
        
        <!-- 有效地形 -->
        <Improvement_ValidTerrains>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_DESERT"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_DESERT_HILLS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_DESERT_MOUNTAIN"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_GRASS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_GRASS_HILLS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_GRASS_MOUNTAIN"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_PLAINS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_PLAINS_HILLS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_PLAINS_MOUNTAIN"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_SNOW"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_SNOW_HILLS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_SNOW_MOUNTAIN"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_TUNDRA"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_TUNDRA_HILLS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_TUNDRA_MOUNTAIN"/>
        </Improvement_ValidTerrains>

<!-- 有效地貌 -->
        <Improvement_ValidFeatures>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_FLOODPLAINS_GRASSLAND"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_FLOODPLAINS_PLAINS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_GEOTHERMAL_FISSURE"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_FLOODPLAINS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_VOLCANIC_SOIL"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_OASIS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_FOREST"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_JUNGLE"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_MARSH"/>
        <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_BURNING_FOREST"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_BURNT_FOREST"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_BURNING_JUNGLE"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_BURNT_JUNGLE"/>
        </Improvement_ValidFeatures>

        <Improvement_ValidBuildUnits>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" UnitType="UNIT_BUILDER"/>
        </Improvement_ValidBuildUnits>

        <!-- 有效资源 修建在资源之上 -->
        <Improvement_ValidResources>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_WINE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_WHEAT" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_WHALES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_URANIUM" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_TURTLES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_TRUFFLES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_TOYS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_TOBACCO" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_SUGAR" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_STONE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_SPICES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_SILVER" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_SILK" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_SHIPWRECK" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_SHEEP" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_SALT" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_RICE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_PERFUME" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_PEARLS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_OLIVES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_OIL" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_NITER" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_MERCURY" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_MARBLE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_MAIZE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_JEANS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_JADE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_IVORY" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_IRON" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_INCENSE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_HORSES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_HONEY" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_GYPSUM" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_FURS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_FISH" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_DYES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_DIAMONDS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_DEER" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_CRABS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_COTTON" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_COSMETICS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_COPPER" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_COFFEE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_COCOA" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_COAL" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_CLOVES" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_CITRUS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_CINNAMON" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_CATTLE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_BANANAS" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_ANTIQUITY_SITE" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_AMBER" MustRemoveFeature="false"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" ResourceType="RESOURCE_ALUMINUM" MustRemoveFeature="false"/>
        </Improvement_ValidResources>
        
<!-- 产出 -->
        <Improvement_YieldChanges>
        <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldType="YIELD_GOLD" YieldChange="5"/>
        <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldType="YIELD_FOOD" YieldChange="5"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldType="YIELD_CULTURE" YieldChange="5"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldType="YIELD_PRODUCTION" YieldChange="5"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldType="YIELD_SCIENCE" YieldChange="5"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldType="YIELD_FAITH" YieldChange="5"/>
        </Improvement_YieldChanges>

        <Improvement_Tourism>
         <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TourismSource="TOURISMSOURCE_CULTURE" PrereqTech="TECH_FLIGHT" ScalingFactor="200"/>
        </Improvement_Tourism>

        <Improvement_Adjacencies>
        <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="Wall_Gold"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="Wall_Culture"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="Wall_Food"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="Wall_Production"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="Wall_Science"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="Wall_Faith"/>
        </Improvement_Adjacencies>
        
        <Adjacency_YieldChanges>
                <Row ID="Wall_Gold" Description="Placeholder" YieldType="YIELD_GOLD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
                <Row ID="Wall_Culture" Description="Placeholder" YieldType="YIELD_CULTURE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_CASTLES"/>
                <Row ID="Wall_Food" Description="Placeholder" YieldType="YIELD_FOOD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
                <Row ID="Wall_Production" Description="Placeholder" YieldType="YIELD_PRODUCTION" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_CASTLES"/>
                <Row ID="Wall_Science" Description="Placeholder" YieldType="YIELD_SCIENCE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_BRONZE_WORKING"/>
                <Row ID="Wall_Faith" Description="Placeholder" YieldType="YIELD_FAITH" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_ASTROLOGY"/>
        </Adjacency_YieldChanges>
        
        <Improvement_ValidBuildUnits>
                <Replace ImprovementType="IMPROVEMENT_GREAT_WALL" UnitType="UNIT_BUILDER"/>
        </Improvement_ValidBuildUnits>

</GameData>

4、测试
Database.log报告：
[2098715.926] [Localization]: StartupErrorMessages.xml
[2098715.926] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2098720.448] [Localization]: Validating Foreign Key Constraints...
[2098720.449] [Localization]: Passed Validation.
[2098720.477] [Configuration]: Validating Foreign Key Constraints...
[2098720.478] [Configuration]: Passed Validation.
[2098721.466] [FullTextSearch]: Initializing FullTextSearch
[2098722.259] [Gameplay]: Validating Foreign Key Constraints...
[2098722.276] [Gameplay]: Passed Validation.
[2098723.625] [Configuration]: Validating Foreign Key Constraints...
[2098723.626] [Configuration]: Passed Validation.
[2098724.765] [HallofFame]: Database found. Checking versions...
[2098724.767] [HallofFame]: Database is up-to-date!
[2098739.375] [FullTextSearch]: FTS - Creating Context
[2098783.890] [Configuration]: Validating Foreign Key Constraints...
[2098783.891] [Configuration]: Passed Validation.
[2098790.268] [Gameplay]: Validating Foreign Key Constraints...
[2098790.297] [Gameplay]: Passed Validation.
[2098799.782] [FullTextSearch]: FTS - Creating Context
[2098799.783] [FullTextSearch]: FTS - Creating Context
[2098800.221] [FullTextSearch]: FTS - Creating Context
[2098800.699] [FullTextSearch]: FTS - Creating Context
[2098802.107] [FullTextSearch]: FTS - Creating Context
没有提示错误
#
SELECT * FROM Improvements WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
结果：
ImprovementType,Name,BarbarianCamp,PrereqTech,PrereqCivic,Buildable,Description,RemoveOnEntry,DispersalGold,PlunderType,PlunderAmount,Goody,TilesPerGoody,GoodyRange,Icon,TraitType,Housing,TilesRequired,SameAdjacentValid,RequiresRiver,EnforceTerrain,BuildInLine,CanBuildOutsideTerritory,BuildOnFrontier,AirSlots,DefenseModifier,GrantFortification,MinimumAppeal,Coast,YieldFromAppeal,WeaponSlots,ReligiousUnitHealRate,Appeal,OnePerCity,YieldFromAppealPercent,ValidAdjacentTerrainAmount,Domain,AdjacentSeaResource,RequiresAdjacentBonusOrLuxury,MovementChange,Workable,ImprovementOnRemove,GoodyNotify,NoAdjacentSpecialtyDistrict,RequiresAdjacentLuxury,AdjacentToLand,Removable,OnlyOpenBorders,Capturable
IMPROVEMENT_GREAT_WALL        LOC_IMPROVEMENT_GREAT_WALL_NAME        0                        1        LOC_IMPROVEMENT_GREAT_WALL_EXPANSION2_DESCRIPTION        0        0        PLUNDER_GOLD        50        0                        ICON_IMPROVEMENT_GREAT_WALL        TRAIT_CIVILIZATION_IMPROVEMENT_GREAT_WALL        3        1        1        0        0        0        1        0        0        8        4                0                0        0        0        0        100        0        DOMAIN_LAND        0        0        0        1                1        0        0        0        1        0        1
#
SELECT * FROM Improvements WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
设置没有生效。
#
SELECT * FROM Improvement_ValidBuildUnits WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
结果：
ImprovementType        UnitType        ConsumesCharge        ValidRepairOnly
IMPROVEMENT_GREAT_WALL        UNIT_BUILDER        1        0
#
SELECT * FROM Improvements_XP2 WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
结果：
ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant
IMPROVEMENT_GREAT_WALL        0        0        0        1
#
SELECT * FROM Improvement_ValidTerrains WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
设置没有生效。
#
SELECT * FROM Improvement_ValidFeatures WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
设置没有生效。
#
SELECT * FROM Improvement_ValidResources WHERE ImprovementType="IMPROVEMENT_GREAT_WALL";
设置没有生效。


5、新开档
[2100902.518] [Localization]: StartupErrorMessages.xml
[2100902.519] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2100905.896] [Localization]: Validating Foreign Key Constraints...
[2100905.897] [Localization]: Passed Validation.
[2100905.933] [Configuration]: Validating Foreign Key Constraints...
[2100905.934] [Configuration]: Passed Validation.
[2100907.076] [FullTextSearch]: Initializing FullTextSearch
[2100907.643] [Gameplay]: Validating Foreign Key Constraints...
[2100907.660] [Gameplay]: Passed Validation.
[2100908.929] [Configuration]: Validating Foreign Key Constraints...
[2100908.930] [Configuration]: Passed Validation.
[2100910.140] [HallofFame]: Database found. Checking versions...
[2100910.141] [HallofFame]: Database is up-to-date!
[2100924.670] [FullTextSearch]: FTS - Creating Context
开档/载入存档
[2101009.359] [Configuration]: Validating Foreign Key Constraints...
[2101009.360] [Configuration]: Passed Validation.
[2101015.637] [Gameplay] ERROR: Database::XMLSerializer (MyGreatWallEnhance-Improvements.xml): <Update> element requires a child <Set> element.
[2101015.637] [Gameplay]: In XMLSerializer while updating table Improvements from file MyGreatWallEnhance-Improvements.xml.
[2101015.735] [Gameplay]: Validating Foreign Key Constraints...
[2101015.764] [Gameplay]: Passed Validation.
[2101024.920] [FullTextSearch]: FTS - Creating Context
[2101024.921] [FullTextSearch]: FTS - Creating Context
[2101025.352] [FullTextSearch]: FTS - Creating Context
[2101025.860] [FullTextSearch]: FTS - Creating Context
[2101027.303] [FullTextSearch]: FTS - Creating Context
<GameData>
        <Improvements>
                <Update>
                        <Where ImprovementType="IMPROVEMENT_GREAT_WALL"/>
                        <Set PrereqTech=NULL PlunderType="PLUNDER_GOLD" PlunderAmount="200" Housing="4" Buildable="1" Housing="4" TilesRequired="1" BuildInLine="0" CanBuildOutsideTerritory="1" BuildOnFrontier="0" DefenseModifier="8" GrantFortification="4" Workable="1"/>
                </Update>
        </Improvements>
是不是这条的问题？

6、
[2102556.969] [Localization]: StartupErrorMessages.xml
[2102556.969] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2102561.981] [Localization]: Validating Foreign Key Constraints...
[2102561.982] [Localization]: Passed Validation.
[2102562.017] [Configuration]: Validating Foreign Key Constraints...
[2102562.019] [Configuration]: Passed Validation.
[2102563.172] [FullTextSearch]: Initializing FullTextSearch
[2102563.751] [Gameplay]: Validating Foreign Key Constraints...
[2102563.767] [Gameplay]: Passed Validation.
[2102565.220] [Configuration]: Validating Foreign Key Constraints...
[2102565.220] [Configuration]: Passed Validation.
[2102566.412] [HallofFame]: Database found. Checking versions...
[2102566.414] [HallofFame]: Database is up-to-date!
[2102580.899] [FullTextSearch]: FTS - Creating Context
载入存档
[2102622.387] [Configuration]: Validating Foreign Key Constraints...
[2102622.388] [Configuration]: Passed Validation.
[2102628.549] [Gameplay] ERROR: table Improvements_XP2 has no column named ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant
[2102628.549] [Gameplay]: In Query - insert into Improvements_XP2('ImprovementType', 'ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant', 'BuildOnAdjacentPlot', 'PreventsDrought', 'DisasterResistant') values (?, ?, ?, ?, ?);
[2102628.549] [Gameplay]: In XMLSerializer while updating table Improvements_XP2 from file MyGreatWallEnhance-Improvements.xml.
[2102628.647] [Gameplay]: Validating Foreign Key Constraints...
[2102628.675] [Gameplay]: Passed Validation.
[2102637.997] [FullTextSearch]: FTS - Creating Context
[2102637.997] [FullTextSearch]: FTS - Creating Context
[2102638.434] [FullTextSearch]: FTS - Creating Context
[2102638.944] [FullTextSearch]: FTS - Creating Context
[2102640.383] [FullTextSearch]: FTS - Creating Context
该语句处写错了，ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant这个拷过来后忘记删除了。

7、
更改上述错误
[2103125.032] [Localization]: StartupErrorMessages.xml
[2103125.032] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2103129.823] [Localization]: Validating Foreign Key Constraints...
[2103129.824] [Localization]: Passed Validation.
[2103129.859] [Configuration]: Validating Foreign Key Constraints...
[2103129.860] [Configuration]: Passed Validation.
[2103131.012] [FullTextSearch]: Initializing FullTextSearch
[2103131.587] [Gameplay]: Validating Foreign Key Constraints...
[2103131.603] [Gameplay]: Passed Validation.
[2103133.070] [Configuration]: Validating Foreign Key Constraints...
[2103133.071] [Configuration]: Passed Validation.
[2103134.213] [HallofFame]: Database found. Checking versions...
[2103134.215] [HallofFame]: Database is up-to-date!
[2103148.795] [FullTextSearch]: FTS - Creating Context
[2103173.881] [Configuration]: Validating Foreign Key Constraints...
[2103173.882] [Configuration]: Passed Validation.
[2103180.794] [Gameplay] ERROR: UNIQUE constraint failed: Improvements_XP2.ImprovementType
[2103180.794] [Gameplay]: While executing - 'insert into Improvements_XP2('ImprovementType', 'AllowImpassableMovement', 'BuildOnAdjacentPlot', 'PreventsDrought', 'DisasterResistant') values (?, ?, ?, ?, ?);'
[2103180.795] [Gameplay]: In XMLSerializer while inserting row into table insert into Improvements_XP2('ImprovementType', 'AllowImpassableMovement', 'BuildOnAdjacentPlot', 'PreventsDrought', 'DisasterResistant') with  values (IMPROVEMENT_GREAT_WALL, 1, 1, 1, 1, ).
[2103180.795] [Gameplay]: In XMLSerializer while updating table Improvements_XP2 from file MyGreatWallEnhance-Improvements.xml.
[2103180.795] [Gameplay] ERROR: UNIQUE constraint failed: Improvements_XP2.ImprovementType
[2103180.917] [Gameplay]: Validating Foreign Key Constraints...
[2103180.956] [Gameplay]: Passed Validation.
[2103195.149] [FullTextSearch]: FTS - Creating Context
[2103195.150] [FullTextSearch]: FTS - Creating Context
[2103195.590] [FullTextSearch]: FTS - Creating Context
[2103196.064] [FullTextSearch]: FTS - Creating Context
[2103197.447] [FullTextSearch]: FTS - Creating Context
又遇到了唯一性校验问题。

8、更改Improvements_XP2表
用Replace替换Row
        <Improvements_XP2>
        <Replace ImprovementType="IMPROVEMENT_GREAT_WALL" AllowImpassableMovement="true" BuildOnAdjacentPlot="true" PreventsDrought="true" DisasterResistant="true"/>
        </Improvements_XP2>
[2103431.005] [Gameplay] ERROR: UNIQUE constraint failed: Improvement_ValidTerrains.ImprovementType, Improvement_ValidTerrains.TerrainType
[2103431.005] [Gameplay]: While executing - 'insert into Improvement_ValidTerrains('ImprovementType', 'TerrainType') values (?, ?);'
[2103431.005] [Gameplay]: In XMLSerializer while inserting row into table insert into Improvement_ValidTerrains('ImprovementType', 'TerrainType') with  values (IMPROVEMENT_GREAT_WALL, TERRAIN_DESERT, ).
[2103431.005] [Gameplay]: In XMLSerializer while updating table Improvement_ValidTerrains from file MyGreatWallEnhance-Improvements.xml.
[2103431.005] [Gameplay] ERROR: UNIQUE constraint failed: Improvement_ValidTerrains.ImprovementType, Improvement_ValidTerrains.TerrainType
Improvements_XP2不提示错误了，但是Improvement_ValidTerrains表又提示错误了。
        <Improvement_ValidTerrains>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_DESERT"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_DESERT_HILLS"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" TerrainType="TERRAIN_DESERT_MOUNTAIN"/>
TERRAIN_DESERT、HILLS在原版中存在。用Replace替换Row。
MOUNTAIN在原版中没有。保留Row。
        <Improvement_ValidFeatures>
                <Replace ImprovementType="IMPROVEMENT_GREAT_WALL" FeatureType="FEATURE_VOLCANIC_SOIL"/>
        </Improvement_ValidFeatures>
FEATURE_VOLCANIC_SOIL原版中好像也存在。用Replace替换Row。

原版的临近产出：
        <Improvement_Adjacencies>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Gold"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Culture"/>
        </Improvement_Adjacencies>
        <Adjacency_YieldChanges>
                <Row ID="GreatWall_Gold" Description="Placeholder" YieldType="YIELD_GOLD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
                <Row ID="GreatWall_Culture" Description="Placeholder" YieldType="YIELD_CULTURE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_CASTLES"/>
        </Adjacency_YieldChanges>

9、
[2104052.751] [Gameplay] ERROR: UNIQUE constraint failed: Improvement_Tourism.ImprovementType
[2104052.751] [Gameplay]: While executing - 'insert into Improvement_Tourism('ImprovementType', 'TourismSource', 'PrereqTech', 'ScalingFactor') values (?, ?, ?, ?);'
[2104052.751] [Gameplay]: In XMLSerializer while inserting row into table insert into Improvement_Tourism('ImprovementType', 'TourismSource', 'PrereqTech', 'ScalingFactor') with  values (IMPROVEMENT_GREAT_WALL, TOURISMSOURCE_CULTURE, TECH_FLIGHT, 200, ).
[2104052.751] [Gameplay]: In XMLSerializer while updating table Improvement_Tourism from file MyGreatWallEnhance-Improvements.xml.
[2104052.751] [Gameplay] ERROR: UNIQUE constraint failed: Improvement_Tourism.ImprovementType
Improvement_Tourism。用Replace替换Row。

10、
        <Improvement_Adjacencies>
        <!--Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Gold"/-->
                <!--Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Culture"/-->
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Food"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Production"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Science"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" YieldChangeId="GreatWall_Faith"/>
        </Improvement_Adjacencies>
        
        <Adjacency_YieldChanges>
                <Delete ID="GreatWall_Gold"/>
                <Row ID="GreatWall_Gold" Description="Placeholder" YieldType="YIELD_GOLD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Delete ID="GreatWall_Culture"/>
                <Row ID="GreatWall_Culture" Description="Placeholder" YieldType="YIELD_CULTURE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL""/>
                <Row ID="GreatWall_Food" Description="Placeholder" YieldType="YIELD_FOOD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL""/>
                <Row ID="GreatWall_Production" Description="Placeholder" YieldType="YIELD_PRODUCTION" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Science" Description="Placeholder" YieldType="YIELD_SCIENCE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Faith" Description="Placeholder" YieldType="YIELD_FAITH" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
        </Adjacency_YieldChanges>
游戏加载存档时崩溃：
Unhandled Exception
Code:  EXCEPTION_ACCESS_VIOLATION
Error reading address 0x1b

Call Stack
-----------------------------------------------------
??? ! ???   ???, line 0
??? ! ???   ???, line 0
??? ! ???   ???, line 0
??? ! ???   ???, line 0

SELECT * FROM Adjacency_YieldChanges
WHERE AdjacentImprovement="IMPROVEMENT_GREAT_WALL";
结果：
ID        Description        YieldType        YieldChange        TilesRequired        OtherDistrictAdjacent        AdjacentSeaResource        AdjacentTerrain        AdjacentFeature        AdjacentRiver        AdjacentWonder        AdjacentNaturalWonder        AdjacentImprovement        AdjacentDistrict        PrereqCivic        PrereqTech        ObsoleteCivic        ObsoleteTech        AdjacentResource        AdjacentResourceClass        Self
GreatWall_Gold        Placeholder        YIELD_GOLD        1        1        0        0                        0        0        0        IMPROVEMENT_GREAT_WALL                        TECH_MASONRY                        0        NO_RESOURCECLASS        0
GreatWall_Culture        Placeholder        YIELD_CULTURE        1        1        0        0                        0        0        0        IMPROVEMENT_GREAT_WALL                        TECH_CASTLES                        0        NO_RESOURCECLASS        0

11、将GreatWall_Gold和GreatWall_Culture两句注释掉
        <Adjacency_YieldChanges>
                <!-- Row ID="GreatWall_Gold" Description="Placeholder" YieldType="YIELD_GOLD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/ -->
                <!-- Row ID="GreatWall_Culture" Description="Placeholder" YieldType="YIELD_CULTURE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL""/ -->
                <Row ID="GreatWall_Food" Description="Placeholder" YieldType="YIELD_FOOD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL""/>
                <Row ID="GreatWall_Production" Description="Placeholder" YieldType="YIELD_PRODUCTION" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Science" Description="Placeholder" YieldType="YIELD_SCIENCE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Faith" Description="Placeholder" YieldType="YIELD_FAITH" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
        </Adjacency_YieldChanges>
[2107963.723] [Gameplay] ERROR: table Adjacency_YieldChanges has no column named "
[2107963.723] [Gameplay]: In Query - insert into Adjacency_YieldChanges('ID', 'Description', 'YieldType', 'YieldChange', 'TilesRequired', 'AdjacentImprovement', '"') values (?, ?, ?, ?, ?, ?, ?);
[2107963.723] [Gameplay]: In XMLSerializer while updating table Adjacency_YieldChanges from file MyGreatWallEnhance-Improvements.xml.
[2107963.790] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2107963.790] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2107963.790] [Gameplay]: Validating Foreign Key Constraints...
[2107963.802] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Food" does not exist in Adjacency_YieldChanges
[2107963.802] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Production" does not exist in Adjacency_YieldChanges
[2107963.802] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Science" does not exist in Adjacency_YieldChanges
[2107963.802] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Faith" does not exist in Adjacency_YieldChanges
[2107963.821] [Gameplay]: Failed Validation.
加载存档后，提示模组失败。
#
[2107968.436] [Configuration]: Validating Foreign Key Constraints...
[2107968.437] [Configuration]: Passed Validation.
[2107969.293] [FullTextSearch]: FTS - Creating Context
[2108104.109] [FullTextSearch]: FTS - Creating Context
[2108127.999] [Configuration]: Validating Foreign Key Constraints...
[2108128.000] [Configuration]: Passed Validation.
[2108134.689] [Gameplay] ERROR: table Adjacency_YieldChanges has no column named "
[2108134.689] [Gameplay]: In Query - insert into Adjacency_YieldChanges('ID', 'Description', 'YieldType', 'YieldChange', 'TilesRequired', 'AdjacentImprovement', '"') values (?, ?, ?, ?, ?, ?, ?);
[2108134.689] [Gameplay]: In XMLSerializer while updating table Adjacency_YieldChanges from file MyGreatWallEnhance-Improvements.xml.
[2108134.745] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2108134.745] [Gameplay] ERROR: FOREIGN KEY constraint failed
[2108134.745] [Gameplay]: Validating Foreign Key Constraints...
[2108134.758] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Food" does not exist in Adjacency_YieldChanges
[2108134.758] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Production" does not exist in Adjacency_YieldChanges
[2108134.758] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Science" does not exist in Adjacency_YieldChanges
[2108134.758] [Gameplay] ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Faith" does not exist in Adjacency_YieldChanges
[2108134.777] [Gameplay]: Failed Validation.
[2108139.111] [Configuration]: Validating Foreign Key Constraints...
[2108139.112] [Configuration]: Passed Validation.
[2108139.945] [FullTextSearch]: FTS - Creating Context
重新开档仍然如此，提示模组失败。
#

12、将<Adjacency_YieldChanges>调到<Improvement_Adjacencies>前面
[2108536.979] [Localization]: StartupErrorMessages.xml
[2108536.979] [Localization]: Input XML does not contain database entry tags. GameData, GameInfo or Database
[2108540.065] [Localization]: Validating Foreign Key Constraints...
[2108540.066] [Localization]: Passed Validation.
[2108540.092] [Configuration]: Validating Foreign Key Constraints...
[2108540.093] [Configuration]: Passed Validation.
[2108541.218] [FullTextSearch]: Initializing FullTextSearch
[2108541.807] [Gameplay]: Validating Foreign Key Constraints...
[2108541.824] [Gameplay]: Passed Validation.
[2108543.148] [Configuration]: Validating Foreign Key Constraints...
[2108543.149] [Configuration]: Passed Validation.
[2108544.373] [HallofFame]: Database found. Checking versions...
[2108544.374] [HallofFame]: Database is up-to-date!
[2108558.973] [FullTextSearch]: FTS - Creating Context
[2108578.747] [Configuration]: Validating Foreign Key Constraints...
[2108578.748] [Configuration]: Passed Validation.
[2108585.138] [Gameplay] ERROR: table Adjacency_YieldChanges has no column named "
[2108585.138] [Gameplay]: In Query - insert into Adjacency_YieldChanges('ID', 'Description', 'YieldType', 'YieldChange', 'TilesRequired', 'AdjacentImprovement', '"') values (?, ?, ?, ?, ?, ?, ?);
[2108585.138] [Gameplay]: In XMLSerializer while updating table Adjacency_YieldChanges from file MyGreatWallEnhance-Improvements.xml.
[2108585.240] [Gameplay]: Validating Foreign Key Constraints...
[2108585.271] [Gameplay]: Passed Validation.
[2108609.087] [FullTextSearch]: FTS - Creating Context
[2108609.088] [FullTextSearch]: FTS - Creating Context
[2108609.428] [FullTextSearch]: FTS - Creating Context
[2108609.917] [FullTextSearch]: FTS - Creating Context
[2108611.256] [FullTextSearch]: FTS - Creating Context
可以载入存档，但看起来还是不对。
看起来好像是语句有问题。

13、拷贝Improvements.xml原版语句并更改
SELECT * FROM Adjacency_YieldChanges
WHERE ID LIKE "%WALL%";
从数据库中删除查询到的结果。
拷贝Improvements.xml原版语句并更改。
        <Adjacency_YieldChanges>
                <Row ID="GreatWall_Food" Description="Placeholder" YieldType="YIELD_FOOD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
                <Row ID="GreatWall_Production" Description="Placeholder" YieldType="YIELD_PRODUCTION" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
                <Row ID="GreatWall_Science" Description="Placeholder" YieldType="YIELD_SCIENCE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
                <Row ID="GreatWall_Faith" Description="Placeholder" YieldType="YIELD_FAITH" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
        </Adjacency_YieldChanges>
通过。
#
问题：
原版中GOLD和CULTURE语句中
                <Row ID="GreatWall_Gold" Description="Placeholder" YieldType="YIELD_GOLD" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_MASONRY"/>
                <Row ID="GreatWall_Culture" Description="Placeholder" YieldType="YIELD_CULTURE" YieldChange="1" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL" PrereqTech="TECH_CASTLES"/>
GOLD和CULTURE都是增加1，YieldChange="1"，但是查询Adjacency_YieldChanges表显示为2。
SELECT ID,Description,YieldType,YieldChange,TilesRequired,AdjacentImprovement,PrereqTech
FROM Adjacency_YieldChanges
WHERE ID LIKE "%WALL%";
结果：
ID        Description        YieldType        YieldChange        TilesRequired        AdjacentImprovement        PrereqTech
GreatWall_Gold        Placeholder        YIELD_GOLD        2        1        IMPROVEMENT_GREAT_WALL        TECH_MASONRY
GreatWall_Culture        Placeholder        YIELD_CULTURE        2        1        IMPROVEMENT_GREAT_WALL        TECH_CASTLES
GreatWall_Food        Placeholder        YIELD_FOOD        1        1        IMPROVEMENT_GREAT_WALL        TECH_MASONRY
GreatWall_Production        Placeholder        YIELD_PRODUCTION        1        1        IMPROVEMENT_GREAT_WALL        TECH_MASONRY
GreatWall_Science        Placeholder        YIELD_SCIENCE        1        1        IMPROVEMENT_GREAT_WALL        TECH_MASONRY
GreatWall_Faith        Placeholder        YIELD_FAITH        1        1        IMPROVEMENT_GREAT_WALL        TECH_MASONRY
Wall_Gold        Placeholder        YIELD_GOLD        1        1        IMPROVEMENT_MING_GREAT_WALL        TECH_MASONRY
Wall_Culture        Placeholder        YIELD_CULTURE        1        1        IMPROVEMENT_MING_GREAT_WALL        TECH_CASTLES
Wall_Food        Placeholder        YIELD_FOOD        1        1        IMPROVEMENT_MING_GREAT_WALL        TECH_MASONRY
Wall_Production        Placeholder        YIELD_PRODUCTION        1        1        IMPROVEMENT_MING_GREAT_WALL        TECH_CASTLES
Wall_Science        Placeholder        YIELD_SCIENCE        1        1        IMPROVEMENT_MING_GREAT_WALL        TECH_BRONZE_WORKING
Wall_Faith        Placeholder        YIELD_FAITH        1        1        IMPROVEMENT_MING_GREAT_WALL        TECH_ASTROLOGY
类似的语句，为何GOLD和CULTURE都是2，其他却都是1呢？

14、将临近产出都改为2，并去掉后添加的4个的科技需求
        <Adjacency_YieldChanges>
                <Row ID="GreatWall_Food" Description="Placeholder" YieldType="YIELD_FOOD" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Production" Description="Placeholder" YieldType="YIELD_PRODUCTION" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Science" Description="Placeholder" YieldType="YIELD_SCIENCE" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Faith" Description="Placeholder" YieldType="YIELD_FAITH" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
        </Adjacency_YieldChanges>
查询：
SELECT ID,Description,YieldType,YieldChange,TilesRequired,AdjacentImprovement,PrereqTech
FROM Adjacency_YieldChanges
WHERE ID LIKE "%WALL%";
结果：
ID        Description        YieldType        YieldChange        TilesRequired        AdjacentImprovement        PrereqTech
GreatWall_Gold        Placeholder        YIELD_GOLD        2        1        IMPROVEMENT_GREAT_WALL        TECH_MASONRY
GreatWall_Culture        Placeholder        YIELD_CULTURE        2        1        IMPROVEMENT_GREAT_WALL        TECH_CASTLES
GreatWall_Food        Placeholder        YIELD_FOOD        2        1        IMPROVEMENT_GREAT_WALL        
GreatWall_Production        Placeholder        YIELD_PRODUCTION        2        1        IMPROVEMENT_GREAT_WALL        
GreatWall_Science        Placeholder        YIELD_SCIENCE        2        1        IMPROVEMENT_GREAT_WALL        
GreatWall_Faith        Placeholder        YIELD_FAITH        2        1        IMPROVEMENT_GREAT_WALL        

15、测试数据库操作
在Navicat中测试。
1）删除记录
DELETE FROM Adjacency_YieldChanges WHERE ID = "GreatWall_Gold";
成功

2）添加记录
INSERT INTO Adjacency_YieldChanges(ID,Description,YieldType) VALUES("aaa","Placeholder","YIELD_GOLD");
成功。
注意，此三字段必须包含，且YieldType必须为6种YIELD类型之一。

INSERT INTO Adjacency_YieldChanges(ID,Description,YieldType,YieldChange,TilesRequired,AdjacentImprovement)
VALUES("GreatWall_Gold","Placeholder","YIELD_GOLD",1,1,"IMPROVEMENT_GREAT_WALL");
成功。

16、删除前置科技条件
        <Improvements>
                <Delete ImprovementType="IMPROVEMENT_GREAT_WALL"/>
                <Row ImprovementType="IMPROVEMENT_GREAT_WALL" Name="LOC_IMPROVEMENT_GREAT_WALL_NAME" Description="LOC_IMPROVEMENT_GREAT_WALL_DESCRIPTION" Icon="ICON_IMPROVEMENT_GREAT_WALL" PlunderType="PLUNDER_GOLD" PlunderAmount="200" Buildable="true" Housing="4"  TilesRequired="1" TraitType="TRAIT_CIVILIZATION_IMPROVEMENT_GREAT_WALL" BuildInLine="0" CanBuildOutsideTerritory="1" BuildOnFrontier="0" DefenseModifier="8" GrantFortification="4" Workable="1"/>
        </Improvements>

        <Adjacency_YieldChanges>
                <Delete ID="GreatWall_Gold"/>
                <Row ID="GreatWall_Gold" Description="Placeholder" YieldType="YIELD_GOLD" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Delete ID="GreatWall_Culture"/>
                <Row ID="GreatWall_Culture" Description="Placeholder" YieldType="YIELD_CULTURE" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>

                <Row ID="GreatWall_Food" Description="Placeholder" YieldType="YIELD_FOOD" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Production" Description="Placeholder" YieldType="YIELD_PRODUCTION" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Science" Description="Placeholder" YieldType="YIELD_SCIENCE" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
                <Row ID="GreatWall_Faith" Description="Placeholder" YieldType="YIELD_FAITH" YieldChange="2" TilesRequired="1" AdjacentImprovement="IMPROVEMENT_GREAT_WALL"/>
        </Adjacency_YieldChanges>
可能需要删掉CACHE里面的数据库文件才能生效。刚改完时，IMPROVEMENT_GREAT_WALL的前置科技还是在的。

输不怕

第三方付付付付付付付付付付付付付付付

A1052099774

这么过分

GHgood

6666666666666666

hxy722

seeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

mh370123

1111111111111111111111111111111111

墨墨幻影

6666666666666

xuflf1111

6666666666666666

yu1997324

666666666666666

回忆曾经...

6666666666666666666666666666666666666666666666666

uami

勇者愤怒，抽刃向更强者；怯者愤怒，却抽刃向更弱者。不可救药的民族中，一定有许多英雄，专向孩子们瞪眼。这些孱头们。

chennevergiveup

感谢楼主

万事寂寥

感谢楼主无私分享

heishanyang

感谢分享

chenshan36

1111111111111

liminggang0115

谢谢大神分享。

眼前的迷雾

谢谢分享

kenwang226

来一个

luoyic0111

感谢分享了

淓愺滺豳哬厾

666666666666666

zhijiang7

大佬666666666

f459009942

看看！！！！！！

songtastez

感谢分享

无灭.什么

6666666666666666666666

Q绝望篇

6666666666

orangebai

太感谢了