安装 Steam
登录
|
语言
繁體中文（繁体中文）
日本語（日语）
한국어（韩语）
ไทย（泰语）
български（保加利亚语）
Čeština（捷克语）
Dansk（丹麦语）
Deutsch（德语）
English（英语）
Español-España（西班牙语 - 西班牙）
Español - Latinoamérica（西班牙语 - 拉丁美洲）
Ελληνικά（希腊语）
Français（法语）
Italiano（意大利语）
Bahasa Indonesia（印度尼西亚语）
Magyar（匈牙利语）
Nederlands（荷兰语）
Norsk（挪威语）
Polski（波兰语）
Português（葡萄牙语 - 葡萄牙）
Português-Brasil（葡萄牙语 - 巴西）
Română（罗马尼亚语）
Русский（俄语）
Suomi（芬兰语）
Svenska（瑞典语）
Türkçe（土耳其语）
Tiếng Việt（越南语）
Українська（乌克兰语）
报告翻译问题
7 
举报此帖
-- Author: Angryr
-- DateCreated: 4/8/2017 11:47:01 PM
--------------------------------------------------------------
-- To restore old version (+1 Gold and +1 Faith in all cities) replace the code below with the commented out code at the bottom of the file.
-- Same with GodKing_Text.sql
--------------------------------------------------------------
------------------------------
-- God King
-- +1 Amentity in the Capital.
------------------------------
-- Create the requirement that the city requires a palace (surprisingly it doesn't exist yet).
INSERT INTO Requirements (RequirementId, RequirementType)
VALUES
('REQUIREMENT_CITY_HAS_PALACE', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (ModifierId, Name, Value)
VALUES
('REQUIREMENT_CITY_HAS_PALACE', 'BuildingType', 'BUILDING_PALACE');
INSERT INTO RequirementSets (RequirementSetId, RequirementSetType)
VALUES
('CITY_HAS_PALACE', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements
VALUES
('CITY_HAS_PALACE', 'REQUIREMENT_CITY_HAS_PALACE');
-- Create & attach the modifier for the "+1 amentity in the capital".
INSERT INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId)
VALUES
('GOD_KING_AMENTITY', 'MODIFIER_PLAYER_CITIES_ADJUST_POLICY_AMENITY', 'CITY_HAS_PALACE');
INSERT INTO ModifierArguments (ModifierId, Name, Value)
VALUES,
('GOD_KING_AMENTITY', 'Amount', 1);
INSERT INTO PolicyModifiers (PolicyType, ModifierId)
VALUES
('POLICY_GOD_KING', 'GOD_KING_AMENTITY');
---------------------------------------
-- God King
-- +1 Gold and +1 Faith in ALL cities.
---------------------------------------
-- Remove the two existing "capital" modifiers.
DELETE FROM PolicyModifiers
WHERE ModifierId IN ('GOD_KING_GOLD', 'GOD_KING_FAITH');
-- Create & attach the modifier for the "+1 Gold in all cities" and the "+1 Faith in all cities".
INSERT INTO Modifiers (ModifierId, ModifierType)
VALUES
('GOD_KING_ALLCITYGOLD', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_CHANGE'),
('GOD_KING_ALLCITYFAITH', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_CHANGE');
INSERT INTO ModifierArguments (ModifierId, Name, Value)
VALUES
('GOD_KING_ALLCITYGOLD', 'YieldType', 'YIELD_GOLD'),
('GOD_KING_ALLCITYGOLD', 'Amount', 1),
('GOD_KING_ALLCITYFAITH', 'YieldType', 'YIELD_FAITH'),
('GOD_KING_ALLCITYFAITH', 'Amount', 1);
INSERT INTO PolicyModifiers (PolicyType, ModifierId)
VALUES
('POLICY_GOD_KING', 'GOD_KING_ALLCITYGOLD'),
('POLICY_GOD_KING', 'GOD_KING_ALLCITYFAITH');
-- GodKing
-- Author: Angryr
-- DateCreated: 4/8/2017 11:47:01 PM
--------------------------------------------------------------
-- To restore old version (+1 Gold and +1 Faith in all cities) replace the code below with the commented out code at the bottom of the file.
-- Same with GodKing_Text.sql
--------------------------------------------------------------
------------------------------
-- God King
-- +1 Amentity in the Capital.
------------------------------
-- Create the requirement that the city requires a palace (surprisingly it doesn't exist yet).
INSERT INTO RequirementSets (RequirementSetId, RequirementSetType) VALUES
('A_CITY_HAS_PALACE', 'REQUIREMENTSET_TEST_ALL');
INSERT INTO RequirementSetRequirements (RequirementSetId, RequirementId) VALUES
('A_CITY_HAS_PALACE', 'A_REQ_CITY_HAS_PALACE');
INSERT INTO Requirements (RequirementId, RequirementType) VALUES
('A_REQ_CITY_HAS_PALACE', 'REQUIREMENT_CITY_HAS_BUILDING');
INSERT INTO RequirementArguments (RequirementId, Name, Value) VALUES
('A_REQ_CITY_HAS_PALACE', 'BuildingType', 'BUILDING_PALACE');
-- Create & attach the modifier for the "+1 amentity in the capital".
INSERT INTO Modifiers (ModifierId, ModifierType, SubjectRequirementSetId) VALUES
('GOD_KING_AMENTITY', 'MODIFIER_PLAYER_CITIES_ADJUST_POLICY_AMENITY', 'A_CITY_HAS_PALACE');
INSERT INTO ModifierArguments (ModifierId, Name, Value) VALUES
('GOD_KING_AMENTITY', 'Amount', 1);
INSERT INTO PolicyModifiers (PolicyType, ModifierId) VALUES
('POLICY_GOD_KING', 'GOD_KING_AMENTITY');
---------------------------------------
-- God King
-- +1 Gold and +1 Faith in ALL cities.
---------------------------------------
-- Remove the two existing "capital" modifiers.
DELETE FROM PolicyModifiers
WHERE ModifierId IN ('GOD_KING_GOLD', 'GOD_KING_FAITH');
-- Create & attach the modifier for the "+1 Gold in all cities" and the "+1 Faith in all cities".
INSERT INTO Modifiers (ModifierId, ModifierType)
VALUES
('GOD_KING_ALLCITYGOLD', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_CHANGE'),
('GOD_KING_ALLCITYFAITH', 'MODIFIER_PLAYER_CITIES_ADJUST_CITY_YIELD_CHANGE');
INSERT INTO ModifierArguments (ModifierId, Name, Value)
VALUES
('GOD_KING_ALLCITYGOLD', 'YieldType', 'YIELD_GOLD'),
('GOD_KING_ALLCITYGOLD', 'Amount', 1),
('GOD_KING_ALLCITYFAITH', 'YieldType', 'YIELD_FAITH'),
('GOD_KING_ALLCITYFAITH', 'Amount', 1);
INSERT INTO PolicyModifiers (PolicyType, ModifierId)
VALUES
('POLICY_GOD_KING', 'GOD_KING_ALLCITYGOLD'),
('POLICY_GOD_KING', 'GOD_KING_ALLCITYFAITH');
-- GodKing_Text
-- Author: Angryr
-- DateCreated: 4/8/2017 11:47:09 PM
--------------------------------------------------------------
-- To restore old version (+1 Gold and +1 Faith in all cities) replace the code below with the commented out code at the bottom of the file.
-- Same with GodKing.sql
--------------------------------------------------------------
UPDATE LocalizedText
SET Text = '+1[ICON_Gold] and +1[ICON_Faith] in all cities. +1[ICON_Amenities] in the [ICON_Capital] Capital.'
WHERE Tag = 'LOC_POLICY_GOD_KING_DESCRIPTION'
AND Language = 'en_US';