hizhj 发表于 2021-5-18 14:52

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

这是本人制作的第一个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文件:**** Hidden Message *****


hizhj 发表于 2021-5-18 14:54

本帖最后由 hizhj 于 2021-5-21 16:52 编辑

MOD效果

建造者的能力:
https://att.3dmgame.com/att/forum/202105/18/205225z8iazfesjnrbex0i.png
两种长城,一个是系统自带的,一个是长城加强MOD里的明长城。

https://att.3dmgame.com/att/forum/202105/18/210845fg66r96v51vwzuvh.png
建在山上的长城


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


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

myqqmm521 发表于 2021-5-18 15:19

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


hizhj 发表于 2021-5-18 15:22

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

不是大佬。谢谢回复!

共同进步!

hizhj 发表于 2021-5-18 21:10

本帖最后由 hizhj 于 2021-5-19 07:53 编辑

MOD制作心路历程
https://bbs.3dmgame.com/static/image/hrline/line5.png

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

https://bbs.3dmgame.com/static/image/hrline/line8.png


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报告:
: StartupErrorMessages.xml
: Input XML does not contain database entry tags. GameData, GameInfo or Database
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Initializing FullTextSearch
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Database found. Checking versions...
: Database is up-to-date!
: FTS - Creating Context
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: 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、新开档
: StartupErrorMessages.xml
: Input XML does not contain database entry tags. GameData, GameInfo or Database
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Initializing FullTextSearch
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Database found. Checking versions...
: Database is up-to-date!
: FTS - Creating Context
开档/载入存档
: Validating Foreign Key Constraints...
: Passed Validation.
ERROR: Database::XMLSerializer (MyGreatWallEnhance-Improvements.xml): <Update> element requires a child <Set> element.
: In XMLSerializer while updating table Improvements from file MyGreatWallEnhance-Improvements.xml.
: Validating Foreign Key Constraints...
: Passed Validation.
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: 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、
: StartupErrorMessages.xml
: Input XML does not contain database entry tags. GameData, GameInfo or Database
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Initializing FullTextSearch
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Database found. Checking versions...
: Database is up-to-date!
: FTS - Creating Context
载入存档
: Validating Foreign Key Constraints...
: Passed Validation.
ERROR: table Improvements_XP2 has no column named ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant
: In Query - insert into Improvements_XP2('ImprovementType', 'ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant', 'BuildOnAdjacentPlot', 'PreventsDrought', 'DisasterResistant') values (?, ?, ?, ?, ?);
: In XMLSerializer while updating table Improvements_XP2 from file MyGreatWallEnhance-Improvements.xml.
: Validating Foreign Key Constraints...
: Passed Validation.
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
该语句处写错了,ImprovementType,AllowImpassableMovement,BuildOnAdjacentPlot,PreventsDrought,DisasterResistant这个拷过来后忘记删除了。

7、
更改上述错误
: StartupErrorMessages.xml
: Input XML does not contain database entry tags. GameData, GameInfo or Database
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Initializing FullTextSearch
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Database found. Checking versions...
: Database is up-to-date!
: FTS - Creating Context
: Validating Foreign Key Constraints...
: Passed Validation.
ERROR: UNIQUE constraint failed: Improvements_XP2.ImprovementType
: While executing - 'insert into Improvements_XP2('ImprovementType', 'AllowImpassableMovement', 'BuildOnAdjacentPlot', 'PreventsDrought', 'DisasterResistant') values (?, ?, ?, ?, ?);'
: In XMLSerializer while inserting row into table insert into Improvements_XP2('ImprovementType', 'AllowImpassableMovement', 'BuildOnAdjacentPlot', 'PreventsDrought', 'DisasterResistant') withvalues (IMPROVEMENT_GREAT_WALL, 1, 1, 1, 1, ).
: In XMLSerializer while updating table Improvements_XP2 from file MyGreatWallEnhance-Improvements.xml.
ERROR: UNIQUE constraint failed: Improvements_XP2.ImprovementType
: Validating Foreign Key Constraints...
: Passed Validation.
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: 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>
ERROR: UNIQUE constraint failed: Improvement_ValidTerrains.ImprovementType, Improvement_ValidTerrains.TerrainType
: While executing - 'insert into Improvement_ValidTerrains('ImprovementType', 'TerrainType') values (?, ?);'
: In XMLSerializer while inserting row into table insert into Improvement_ValidTerrains('ImprovementType', 'TerrainType') withvalues (IMPROVEMENT_GREAT_WALL, TERRAIN_DESERT, ).
: In XMLSerializer while updating table Improvement_ValidTerrains from file MyGreatWallEnhance-Improvements.xml.
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、
ERROR: UNIQUE constraint failed: Improvement_Tourism.ImprovementType
: While executing - 'insert into Improvement_Tourism('ImprovementType', 'TourismSource', 'PrereqTech', 'ScalingFactor') values (?, ?, ?, ?);'
: In XMLSerializer while inserting row into table insert into Improvement_Tourism('ImprovementType', 'TourismSource', 'PrereqTech', 'ScalingFactor') withvalues (IMPROVEMENT_GREAT_WALL, TOURISMSOURCE_CULTURE, TECH_FLIGHT, 200, ).
: In XMLSerializer while updating table Improvement_Tourism from file MyGreatWallEnhance-Improvements.xml.
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>
ERROR: table Adjacency_YieldChanges has no column named "
: In Query - insert into Adjacency_YieldChanges('ID', 'Description', 'YieldType', 'YieldChange', 'TilesRequired', 'AdjacentImprovement', '"') values (?, ?, ?, ?, ?, ?, ?);
: In XMLSerializer while updating table Adjacency_YieldChanges from file MyGreatWallEnhance-Improvements.xml.
ERROR: FOREIGN KEY constraint failed
ERROR: FOREIGN KEY constraint failed
: Validating Foreign Key Constraints...
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Food" does not exist in Adjacency_YieldChanges
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Production" does not exist in Adjacency_YieldChanges
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Science" does not exist in Adjacency_YieldChanges
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Faith" does not exist in Adjacency_YieldChanges
: Failed Validation.
加载存档后,提示模组失败。
#
: Validating Foreign Key Constraints...
: Passed Validation.
: FTS - Creating Context
: FTS - Creating Context
: Validating Foreign Key Constraints...
: Passed Validation.
ERROR: table Adjacency_YieldChanges has no column named "
: In Query - insert into Adjacency_YieldChanges('ID', 'Description', 'YieldType', 'YieldChange', 'TilesRequired', 'AdjacentImprovement', '"') values (?, ?, ?, ?, ?, ?, ?);
: In XMLSerializer while updating table Adjacency_YieldChanges from file MyGreatWallEnhance-Improvements.xml.
ERROR: FOREIGN KEY constraint failed
ERROR: FOREIGN KEY constraint failed
: Validating Foreign Key Constraints...
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Food" does not exist in Adjacency_YieldChanges
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Production" does not exist in Adjacency_YieldChanges
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Science" does not exist in Adjacency_YieldChanges
ERROR: Invalid Reference on Improvement_Adjacencies.YieldChangeId - "GreatWall_Faith" does not exist in Adjacency_YieldChanges
: Failed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: FTS - Creating Context
重新开档仍然如此,提示模组失败。
#

12、将<Adjacency_YieldChanges>调到<Improvement_Adjacencies>前面
: StartupErrorMessages.xml
: Input XML does not contain database entry tags. GameData, GameInfo or Database
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Initializing FullTextSearch
: Validating Foreign Key Constraints...
: Passed Validation.
: Validating Foreign Key Constraints...
: Passed Validation.
: Database found. Checking versions...
: Database is up-to-date!
: FTS - Creating Context
: Validating Foreign Key Constraints...
: Passed Validation.
ERROR: table Adjacency_YieldChanges has no column named "
: In Query - insert into Adjacency_YieldChanges('ID', 'Description', 'YieldType', 'YieldChange', 'TilesRequired', 'AdjacentImprovement', '"') values (?, ?, ?, ?, ?, ?, ?);
: In XMLSerializer while updating table Adjacency_YieldChanges from file MyGreatWallEnhance-Improvements.xml.
: Validating Foreign Key Constraints...
: Passed Validation.
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: FTS - Creating Context
: 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的前置科技还是在的。



输不怕 发表于 2021-5-18 22:47

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

A1052099774 发表于 2021-5-19 08:49

这么过分:lol

GHgood 发表于 2021-5-19 08:55

6666666666666666

hxy722 发表于 2021-5-19 09:14

seeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

mh370123 发表于 2021-5-19 09:16

1111111111111111111111111111111111

墨墨幻影 发表于 2021-5-19 09:57

6666666666666

xuflf1111 发表于 2021-5-19 11:44

6666666666666666

yu1997324 发表于 2021-5-19 12:13

666666666666666

回忆曾经... 发表于 2021-5-19 15:34

6666666666666666666666666666666666666666666666666

uami 发表于 2021-5-19 21:12

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

chennevergiveup 发表于 2021-5-19 21:52

感谢楼主

万事寂寥 发表于 2021-5-19 23:21

感谢楼主无私分享

heishanyang 发表于 2021-5-20 00:36

感谢分享

chenshan36 发表于 2021-5-20 09:03

1111111111111

liminggang0115 发表于 2021-5-20 09:34

谢谢大神分享。

眼前的迷雾 发表于 2021-5-20 10:53

谢谢分享

kenwang226 发表于 2021-5-20 12:05

来一个

luoyic0111 发表于 2021-5-20 16:41

感谢分享了

淓愺滺豳哬厾 发表于 2021-5-20 17:49

666666666666666

zhijiang7 发表于 2021-5-20 18:11

大佬666666666

f459009942 发表于 2021-5-20 19:50

看看!!!!!!

songtastez 发表于 2021-5-20 21:03

感谢分享

无灭.什么 发表于 2021-5-20 21:20

6666666666666666666666

Q绝望篇 发表于 2021-5-21 00:30

6666666666

orangebai 发表于 2021-5-21 01:07

太感谢了
页: [1] 2 3 4 5 6 7 8 9 10
查看完整版本: 原创MOD-长城基本特性增强MOD-请求设置回复可见,谢谢!