[LP] How to Change text for Leader Pass Civilizations when the text is not in the databases.

johsnon38

Chieftain
Joined
Aug 24, 2024
Messages
1
I have made a mod with several working gameplay parts and I'm wanting to change the text that appears in the Civ selection Screen.
I have tried to do this in several ways
First I tried using the UPDATE Command Structure
SQL:
UPDATE LocalizedText SET Text='Improvement that unlocks with Masonry and must be built on Desert, Desert Hills or Floodplains. +2 [ICON_Faith] Faith and +4 [ICON_Food] Food. Receives additional yields from adjacent districts. +1 [ICON_Food] Food if adjacent to a city center. For all other districts that award adjacency bonuses: +1 of the appropriate yield if that district is adjacent.' WHERE Tag='LOC_IMPROVEMENT_PYRAMID_DESCRIPTION';
This worked with all the older Civilizations however even trying with different Text Databases it did not work for the New ones(Elizabeth I, Suleiman Mutesem and Harald Varangian).
Seeing as there was no text in the existing text databases (It is added by the DLCs after game start) I tried to insert my code into the database:
SQL:
INSERT INTO EnglishText (Language, Tag, Text, Gender, Plurality) VALUES ('en_US', 'LOC_TRAIT_LEADER_ELIZABETH_DESCRIPTION', 'Englands  [ICON_TradeRoute] Trade Route Capacity is increased by 1 after acquiring a [ICON_GreatAdmiral] Great Admiral. [ICON_TradeRoute] Trade Routes to any city-state provide +3  [ICON_GOLD]  Gold for every specialty district in the origin city. +100% Yields from Plundering  [ICON_TradeRoute] Trade Routes with Naval Units.', null, null);
This also did not work. Additionally I have tried to change the LOC___DESCRIPTION-tags and inserted a new Row into the text databases using this mod as a template https://steamcommunity.com/sharedfiles/filedetails/?id=2896267031
This is in the Frontend UpdateDatabase:
SQL:
--Elizabeth
Update Traits Set Description='LOC_TRAIT_LEADER_ELIZABETH_DESCRIPTION_REWORK' WHERE TraitType='TRAIT_LEADER_ELIZABETH'
--Suleiman
Update Traits Set Description='LOC_TRAIT_LEADER_SULEIMAN_ALT_DESCRIPTION_REWORK' WHERE TraitType='TRAIT_LEADER_SULEIMAN_ALT'
--Harald
Update Traits Set Description='LOC_TRAIT_LEADER_HARALD_ALT_XP_DESCRIPTION_REWORK' WHERE TraitType='TRAIT_LEADER_HARALD_ALT'
This is in the Frontend Update Text:
SQL:
INSERT OR REPLACE INTO BaseGameText (Tag, Text) VALUES ('LOC_TRAIT_CIVILIZATION_ALL_ROADS_TO_ROME_DESCRIPTION', 'All cities you found or conquer start with a Trading Post. If in [ICON_TradeRoute] Trade Route range of your [ICON_Capital] Capital, they also start with a road to it. Your [ICON_TradeRoute] Trade Routes earn +3 [ICON_Gold] Gold for passing through Trading Posts in your own cities.');
INSERT OR REPLACE INTO BaseGameText (Tag, Text) VALUES ('LOC_TRAIT_LEADER_ELIZABETH_DESCRIPTION_REWORK', 'Englands  [ICON_TradeRoute] Trade Route Capacity is increased by 1 after acquiring a [ICON_GreatAdmiral] Great Admiral. [ICON_TradeRoute] Trade Routes to any city-state provide +3  [ICON_GOLD]  Gold for every specialty district in the origin city. +100% Yields from Plundering  [ICON_TradeRoute] Trade Routes with Naval Units.');
INSERT OR REPLACE INTO BaseGameText (Tag, Text) VALUES ('LOC_TRAIT_LEADER_SULEIMAN_ALT_DESCRIPTION_REWORK', '+15% [Icon_Science] Science and [Icon_Culture] Culture when in a [ICON_GLORY_GOLDEN_AGE] Golden Age or Heroic Age. +20% [Icon_Production] Production, +20% [Icon_Gold] Gold when not in a [ICON_GLORY_GOLDEN_AGE] Golden Age or Heroic Age and +4 [ICON_Strength] Combat Strength against Civilizations who are also not in a [ICON_GLORY_GOLDEN_AGE] Golden Age or Heroic Age.');
INSERT OR REPLACE INTO BaseGameText (Tag, Text) VALUES ('LOC_BUILDING_STAVE_CHURCH_DESCRIPTION','A building unique to Norway. Required to purchase Apostles and Inquisitors with [ICON_Faith] Faith. Holy Site districts get an additional standard adjacency bonus from Woods.  +2 [ICON_PRODUCTION] Production to each coastal resource tile in this city.');
INSERT OR REPLACE INTO BaseGameText (Tag, Text) VALUES ('LOC_TRAIT_LEADER_HARALD_ALT_XP_DESCRIPTION_REWORK','All units pay 2 less [ICON_GOLD] Gold maintenance. 75% Discount on Levying units and levied units receive [ICON_CULTURE] Culture, [ICON_FAITH] Faith and [ICON_SCIENCE] Science from kills equal to 50% of the opponents [ICON_STRENGTH] Combat Strength. +2 Influence Points per turn from the Stave Church.');
 
Last edited:
Top Bottom