[SQL] Simple edit buffing existing Civ not registering

OurOhnlyHope

Chieftain
Joined
Mar 1, 2021
Messages
3
Hey all,
I've been lurking on these forums since the heyday of Civ 4 and finally tried out modding Civ 6. My sister enjoys the game but doesn't survive long when playing against me and my friends in multiplayer. I was trying to create a mod that buffs the Inca so she stops getting killed by even the AI on Chieftan.

My SQL mod is registered in the "Additional Content" section of the main menu screen. When I load a game none of the buffs apply. I queried the GameplayDebug.sqlite and did not see any of my table updates where they should be. Other updates from other mods (including those I based this off of) do show up correctly.

I should preface by saying that I understand what I am trying to do conceptually, but I have a learning disability so executing that is not easy for me. If anyone has any advice on where I've gone wrong I would appreciate it.

Changes.modfinfo file:
Code:
<?xml version="1.0" encoding="utf-8"?>
<Mod id="9bc14b36-d19c-47c7-89a2-5e1b9b06c61b" version="1">
    <Properties>
        <Name>Inca Buff</Name>
        <Teaser>This mod gives the Inca some advantages. </Teaser>
        <Description>This mod buffs the Inca. I made this for my sister, who is quite bad at this game.</Description>
        <Authors>OurOhnlyHope</Authors>
        <CompatibleVersions>1.2,2.0</CompatibleVersions>
    </Properties>

    <!-- Different parts of the mod -->
    <Components>
        <UpdateDatabase id="INCA_BUFF_PATCH">
            <Items>
                 <File>Code.sql</File>
            </Items>
        </UpdateDatabase>
    </Components>
</Mod>

Code.sql:
Code:
--===================================
-- SQL by OurOhnlyHope
--===================================   
-- Inca Buff Patch
-------------------------------------   

-------------------------------------
-- Civilization Buffs so Ally doesn't get ganked on turn 60 by Canada anymore
-------------------------------------

INSERT INTO CivilziationTraits
        (CivilizationType,        TraitType)
VALUES     ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_LAND_DOWN_UNDER'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_EJERCITO_PATRIOTA'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_IMPERIAL_FREE_CITIES'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_SCOTTISH_ENLIGHTENMENT'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_PLATOS_REPUBLIC'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_ADJACENT_DISTRICTS'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZAITON_ALL_ROADS_TO_ROME'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_MONGOLIAN_ORTOO');

-------------------------------------
-- Leader Buffs in case the above isn't even enough
-------------------------------------

INSERT INTO LeaderTraits
        (LeaderType,            TraitType)
VALUES     ('LEADER_PACHACUTI',    'TRAIT_LEADER_GIFTS_FOR_TLATOANI');

The above is the totality of code I wrote. The game has no problem recognizing the data in the mod.info file.
The idea behind these buffs was to just give the Inca civ the foreign key traits that other civs use. If this methodology is flawed I'm more than willing to trash the code and write some production and food increases from the ground up.

I based my template off of Isau's Modding with SQLite tutorial, for those who are wondering.

Thank you again to anyone who can suggest what I did wrong.
 
You're missing a "File" section in the modinfo. It also wouldn't hurt to change Components to InGameActions (even though they're technically interchangeable) and add a LoadOrder just to make sure it loads after all game files. Try this:
Code:
<?xml version="1.0" encoding="utf-8"?>
<Mod id="9bc14b36-d19c-47c7-89a2-5e1b9b06c61b" version="1">
    <Properties>
        <Name>Inca Buff</Name>
        <Teaser>This mod gives the Inca some advantages. </Teaser>
        <Description>This mod buffs the Inca. I made this for my sister, who is quite bad at this game.</Description>
        <Authors>OurOhnlyHope</Authors>
        <CompatibleVersions>1.2,2.0</CompatibleVersions>
    </Properties>
    <InGameActions>
        <UpdateDatabase id="INCA_BUFF_PATCH">
            <Properties>
                <LoadOrder>300</LoadOrder>
            </Properties>
            <File>Code.sql</File>
        </UpdateDatabase>
    </InGameActions>
    <Files>
        <File>Code.sql</File>
    </Files>
</Mod>
 
Thanks so much for the quick reply Laurana! Unfortunately, it still doesn't seem like the actual SQL code is being injected into the database. When I check the debug database, I still don't see the new civilization traits appended to the inca at all:

Code:
CivilizationType    TraitType
CIVILIZATION_AMERICA    TRAIT_CIVILIZATION_BUILDING_FILM_STUDIO
CIVILIZATION_AMERICA    TRAIT_CIVILIZATION_FOUNDING_FATHERS
CIVILIZATION_AMERICA    TRAIT_CIVILIZATION_UNIT_AMERICAN_P51
CIVILIZATION_ARABIA    TRAIT_CIVILIZATION_BUILDING_MADRASA
CIVILIZATION_ARABIA    TRAIT_CIVILIZATION_LAST_PROPHET
CIVILIZATION_ARABIA    TRAIT_CIVILIZATION_UNIT_ARABIAN_MAMLUK
CIVILIZATION_AUSTRALIA    TRAIT_CIVILIZATION_IMPROVEMENT_OUTBACK_STATION
CIVILIZATION_AUSTRALIA    TRAIT_CIVILIZATION_LAND_DOWN_UNDER
CIVILIZATION_AUSTRALIA    TRAIT_CIVILIZATION_UNIT_DIGGER
CIVILIZATION_AZTEC    TRAIT_CIVILIZATION_BUILDING_TLACHTLI
CIVILIZATION_AZTEC    TRAIT_CIVILIZATION_LEGEND_FIVE_SUNS
CIVILIZATION_AZTEC    TRAIT_CIVILIZATION_UNIT_AZTEC_EAGLE_WARRIOR
CIVILIZATION_BABYLON_STK    TRAIT_CIVILIZATION_BABYLON
CIVILIZATION_BABYLON_STK    TRAIT_CIVILIZATION_BUILDING_PALGUM
CIVILIZATION_BABYLON_STK    TRAIT_CIVILIZATION_UNIT_BABYLONIAN_SABUM_KIBITTUM
CIVILIZATION_BARBARIAN    TRAIT_BARBARIAN
CIVILIZATION_BRAZIL    TRAIT_CIVILIZATION_AMAZON
CIVILIZATION_BRAZIL    TRAIT_CIVILIZATION_STREET_CARNIVAL
CIVILIZATION_BRAZIL    TRAIT_CIVILIZATION_UNIT_BRAZILIAN_MINAS_GERAES
CIVILIZATION_BYZANTIUM    TRAIT_CIVILIZATION_BYZANTIUM
CIVILIZATION_BYZANTIUM    TRAIT_CIVILIZATION_DISTRICT_HIPPODROME
CIVILIZATION_BYZANTIUM    TRAIT_CIVILIZATION_UNIT_BYZANTINE_DROMON
CIVILIZATION_CANADA    TRAIT_CIVILIZATION_FACES_OF_PEACE
CIVILIZATION_CANADA    TRAIT_CIVILIZATION_IMPROVEMENT_ICE_HOCKEY_RINK
CIVILIZATION_CANADA    TRAIT_CIVILIZATION_UNIT_CANADA_MOUNTIE
CIVILIZATION_CHINA    TRAIT_CIVILIZATION_DYNASTIC_CYCLE
CIVILIZATION_CHINA    TRAIT_CIVILIZATION_IMPROVEMENT_GREAT_WALL
CIVILIZATION_CHINA    TRAIT_CIVILIZATION_UNIT_CHINESE_CROUCHING_TIGER
CIVILIZATION_CREE    TRAIT_CIVILIZATION_CREE_TRADE_GAIN_TILES
CIVILIZATION_CREE    TRAIT_CIVILIZATION_IMPROVEMENT_MEKEWAP
CIVILIZATION_CREE    TRAIT_CIVILIZATION_UNIT_CREE_OKIHTCITAW
CIVILIZATION_EGYPT    TRAIT_CIVILIZATION_IMPROVEMENT_SPHINX
CIVILIZATION_EGYPT    TRAIT_CIVILIZATION_ITERU
CIVILIZATION_EGYPT    TRAIT_CIVILIZATION_UNIT_EGYPTIAN_CHARIOT_ARCHER
CIVILIZATION_ENGLAND    TRAIT_CIVILIZATION_INDUSTRIAL_REVOLUTION
CIVILIZATION_ENGLAND    TRAIT_CIVILIZATION_ROYAL_NAVY_DOCKYARD
CIVILIZATION_ENGLAND    TRAIT_CIVILIZATION_UNIT_ENGLISH_SEADOG
CIVILIZATION_ETHIOPIA    TRAIT_CIVILIZATION_ETHIOPIA
CIVILIZATION_ETHIOPIA    TRAIT_CIVILIZATION_IMPROVEMENT_ROCK_HEWN_CHURCH
CIVILIZATION_ETHIOPIA    TRAIT_CIVILIZATION_UNIT_ETHIOPIAN_OROMO_CAVALRY
CIVILIZATION_FRANCE    TRAIT_CIVILIZATION_IMPROVEMENT_CHATEAU
CIVILIZATION_FRANCE    TRAIT_CIVILIZATION_UNIT_FRENCH_GARDE_IMPERIALE
CIVILIZATION_FRANCE    TRAIT_CIVILIZATION_WONDER_TOURISM
CIVILIZATION_GAUL    TRAIT_CIVILIZATION_DISTRICT_OPPIDUM
CIVILIZATION_GAUL    TRAIT_CIVILIZATION_GAUL
CIVILIZATION_GAUL    TRAIT_CIVILIZATION_UNIT_GAUL_GAESATAE
CIVILIZATION_GEORGIA    TRAIT_CIVILIZATION_BUILDING_TSIKHE
CIVILIZATION_GEORGIA    TRAIT_CIVILIZATION_GOLDEN_AGE_QUESTS
CIVILIZATION_GEORGIA    TRAIT_CIVILIZATION_UNIT_GEORGIAN_KHEVSURETI
CIVILIZATION_GERMANY    TRAIT_CIVILIZATION_DISTRICT_HANSA
CIVILIZATION_GERMANY    TRAIT_CIVILIZATION_IMPERIAL_FREE_CITIES
CIVILIZATION_GERMANY    TRAIT_CIVILIZATION_UNIT_GERMAN_UBOAT
CIVILIZATION_GRAN_COLOMBIA    TRAIT_CIVILIZATION_COMANDANTE_GENERAL
CIVILIZATION_GRAN_COLOMBIA    TRAIT_CIVILIZATION_EJERCITO_PATRIOTA
CIVILIZATION_GRAN_COLOMBIA    TRAIT_CIVILIZATION_IMPROVEMENT_HACIENDA
CIVILIZATION_GRAN_COLOMBIA    TRAIT_CIVILIZATION_LLANERO
CIVILIZATION_GREECE    TRAIT_CIVILIZATION_DISTRICT_ACROPOLIS
CIVILIZATION_GREECE    TRAIT_CIVILIZATION_PLATOS_REPUBLIC
CIVILIZATION_GREECE    TRAIT_CIVILIZATION_UNIT_GREEK_HOPLITE
CIVILIZATION_HUNGARY    TRAIT_CIVILIZATION_BUILDING_THERMAL_BATH
CIVILIZATION_HUNGARY    TRAIT_CIVILIZATION_PEARL_DANUBE
CIVILIZATION_HUNGARY    TRAIT_CIVILIZATION_UNIT_HUNGARY_HUSZAR
CIVILIZATION_INCA    TRAIT_CIVILIZATION_GREAT_MOUNTAINS
CIVILIZATION_INCA    TRAIT_CIVILIZATION_IMPROVEMENT_TERRACE_FARM
CIVILIZATION_INCA    TRAIT_CIVILIZATION_UNIT_INCA_WARAKAQ
CIVILIZATION_INDIA    TRAIT_CIVILIZATION_DHARMA
CIVILIZATION_INDIA    TRAIT_CIVILIZATION_IMPROVEMENT_STEPWELL
CIVILIZATION_INDIA    TRAIT_CIVILIZATION_UNIT_INDIAN_VARU
CIVILIZATION_INDONESIA    TRAIT_CIVILIZATION_IMPROVEMENT_KAMPUNG
CIVILIZATION_INDONESIA    TRAIT_CIVILIZATION_INDONESIA_NUSANTARA
CIVILIZATION_INDONESIA    TRAIT_CIVILIZATION_UNIT_INDONESIAN_JONG
CIVILIZATION_JAPAN    TRAIT_CIVILIZATION_ADJACENT_DISTRICTS
CIVILIZATION_JAPAN    TRAIT_CIVILIZATION_BUILDING_ELECTRONICS_FACTORY
CIVILIZATION_JAPAN    TRAIT_CIVILIZATION_UNIT_JAPANESE_SAMURAI
CIVILIZATION_KHMER    TRAIT_CIVILIZATION_BUILDING_PRASAT
CIVILIZATION_KHMER    TRAIT_CIVILIZATION_KHMER_BARAYS
CIVILIZATION_KHMER    TRAIT_CIVILIZATION_UNIT_KHMER_DOMREY
CIVILIZATION_KONGO    TRAIT_CIVILIZATION_MBANZA
CIVILIZATION_KONGO    TRAIT_CIVILIZATION_NKISI
CIVILIZATION_KONGO    TRAIT_CIVILIZATION_UNIT_KONGO_SHIELD_BEARER
CIVILIZATION_KOREA    TRAIT_CIVILIZATION_DISTRICT_SEOWON
CIVILIZATION_KOREA    TRAIT_CIVILIZATION_THREE_KINGDOMS
CIVILIZATION_KOREA    TRAIT_CIVILIZATION_UNIT_KOREAN_HWACHA
CIVILIZATION_MACEDON    TRAIT_CIVILIZATION_BUILDING_BASILIKOI_PAIDES
CIVILIZATION_MACEDON    TRAIT_CIVILIZATION_HELLENISTIC_FUSION
CIVILIZATION_MACEDON    TRAIT_CIVILIZATION_UNIT_HYPASPIST
CIVILIZATION_MALI    TRAIT_CIVILIZATION_DISTRICT_SUGUBA
CIVILIZATION_MALI    TRAIT_CIVILIZATION_MALI_GOLD_DESERT
CIVILIZATION_MALI    TRAIT_CIVILIZATION_UNIT_MALI_MANDEKALU_CAVALRY
CIVILIZATION_MAORI    TRAIT_CIVILIZATION_BUILDING_MARAE
CIVILIZATION_MAORI    TRAIT_CIVILIZATION_IMPROVEMENT_MAORI_PA
CIVILIZATION_MAORI    TRAIT_CIVILIZATION_MAORI_MANA
CIVILIZATION_MAORI    TRAIT_CIVILIZATION_UNIT_MAORI_TOA
CIVILIZATION_MAPUCHE    TRAIT_CIVILIZATION_IMPROVEMENT_CHEMAMULL
CIVILIZATION_MAPUCHE    TRAIT_CIVILIZATION_MAPUCHE_TOQUI
CIVILIZATION_MAPUCHE    TRAIT_CIVILIZATION_UNIT_MAPUCHE_MALON_RAIDER
CIVILIZATION_MAYA    TRAIT_CIVILIZATION_DISTRICT_OBSERVATORY
CIVILIZATION_MAYA    TRAIT_CIVILIZATION_HULCHE
CIVILIZATION_MAYA    TRAIT_CIVILIZATION_MAYAB
CIVILIZATION_MONGOLIA    TRAIT_CIVILIZATION_BUILDING_ORDU
CIVILIZATION_MONGOLIA    TRAIT_CIVILIZATION_MONGOLIAN_ORTOO
CIVILIZATION_MONGOLIA    TRAIT_CIVILIZATION_UNIT_MONGOLIAN_KESHIG
CIVILIZATION_NETHERLANDS    TRAIT_CIVILIZATION_GROTE_RIVIEREN
CIVILIZATION_NETHERLANDS    TRAIT_CIVILIZATION_IMPROVEMENT_POLDER
CIVILIZATION_NETHERLANDS    TRAIT_CIVILIZATION_UNIT_DUTCH_ZEVEN_PROVINCIEN
CIVILIZATION_NORWAY    TRAIT_CIVILIZATION_BUILDING_STAVE_CHURCH
CIVILIZATION_NORWAY    TRAIT_CIVILIZATION_EARLY_OCEAN_NAVIGATION
CIVILIZATION_NORWAY    TRAIT_CIVILIZATION_UNIT_NORWEGIAN_BERSERKER
CIVILIZATION_NUBIA    TRAIT_CIVILIZATION_IMPROVEMENT_PYRAMID
CIVILIZATION_NUBIA    TRAIT_CIVILIZATION_TA_SETI
CIVILIZATION_NUBIA    TRAIT_CIVILIZATION_UNIT_NUBIAN_PITATI
CIVILIZATION_OTTOMAN    TRAIT_CIVILIZATION_BUILDING_GRAND_BAZAAR
CIVILIZATION_OTTOMAN    TRAIT_CIVILIZATION_GREAT_TURKISH_BOMBARD
CIVILIZATION_OTTOMAN    TRAIT_CIVILIZATION_UNIT_OTTOMAN_BARBARY_CORSAIR
CIVILIZATION_PERSIA    TRAIT_CIVILIZATION_IMPROVEMENT_PAIRIDAEZA
CIVILIZATION_PERSIA    TRAIT_CIVILIZATION_SATRAPIES
CIVILIZATION_PERSIA    TRAIT_CIVILIZATION_UNIT_IMMORTAL
CIVILIZATION_PHOENICIA    TRAIT_CIVILIZATION_DISTRICT_COTHON
CIVILIZATION_PHOENICIA    TRAIT_CIVILIZATION_MEDITERRANEAN_COLONIES
CIVILIZATION_PHOENICIA    TRAIT_CIVILIZATION_UNIT_PHOENICIA_BIREME
CIVILIZATION_POLAND    TRAIT_CIVILIZATION_BUILDING_SUKIENNICE
CIVILIZATION_POLAND    TRAIT_CIVILIZATION_GOLDEN_LIBERTY
CIVILIZATION_POLAND    TRAIT_CIVILIZATION_UNIT_POLISH_HUSSAR
CIVILIZATION_ROME    TRAIT_CIVILIZATION_ALL_ROADS_TO_ROME
CIVILIZATION_ROME    TRAIT_CIVILIZATION_DISTRICT_BATH
CIVILIZATION_ROME    TRAIT_CIVILIZATION_UNIT_ROMAN_LEGION
CIVILIZATION_RUSSIA    TRAIT_CIVILIZATION_DISTRICT_LAVRA
CIVILIZATION_RUSSIA    TRAIT_CIVILIZATION_MOTHER_RUSSIA
CIVILIZATION_RUSSIA    TRAIT_CIVILIZATION_UNIT_RUSSIAN_COSSACK
CIVILIZATION_SCOTLAND    TRAIT_CIVILIZATION_IMPROVEMENT_GOLF_COURSE
CIVILIZATION_SCOTLAND    TRAIT_CIVILIZATION_SCOTTISH_ENLIGHTENMENT
CIVILIZATION_SCOTLAND    TRAIT_CIVILIZATION_UNIT_SCOTTISH_HIGHLANDER
CIVILIZATION_SCYTHIA    TRAIT_CIVILIZATION_EXTRA_LIGHT_CAVALRY
CIVILIZATION_SCYTHIA    TRAIT_CIVILIZATION_IMPROVEMENT_KURGAN
CIVILIZATION_SCYTHIA    TRAIT_CIVILIZATION_UNIT_SCYTHIAN_HORSE_ARCHER
CIVILIZATION_SPAIN    TRAIT_CIVILIZATION_IMPROVEMENT_MISSION
CIVILIZATION_SPAIN    TRAIT_CIVILIZATION_TREASURE_FLEET
CIVILIZATION_SPAIN    TRAIT_CIVILIZATION_UNIT_SPANISH_CONQUISTADOR
CIVILIZATION_SUMERIA    TRAIT_CIVILIZATION_FIRST_CIVILIZATION
CIVILIZATION_SUMERIA    TRAIT_CIVILIZATION_IMPROVEMENT_ZIGGURAT
CIVILIZATION_SUMERIA    TRAIT_CIVILIZATION_UNIT_SUMERIAN_WAR_CART
CIVILIZATION_SWEDEN    TRAIT_CIVILIZATION_IMPROVEMENT_OPEN_AIR_MUSEUM
CIVILIZATION_SWEDEN    TRAIT_CIVILIZATION_NOBEL_PRIZE
CIVILIZATION_SWEDEN    TRAIT_CIVILIZATION_UNIT_SWEDEN_CAROLEAN
CIVILIZATION_VIETNAM    TRAIT_CIVILIZATION_DISTRICT_THANH
CIVILIZATION_VIETNAM    TRAIT_CIVILIZATION_UNIT_VIETNAMESE_VOI_CHIEN
CIVILIZATION_VIETNAM    TRAIT_CIVILIZATION_VIETNAM
CIVILIZATION_ZULU    TRAIT_CIVILIZATION_DISTRICT_IKANDA
CIVILIZATION_ZULU    TRAIT_CIVILIZATION_UNIT_ZULU_IMPI
CIVILIZATION_ZULU    TRAIT_CIVILIZATION_ZULU_ISIBONGO

Perhaps the insertion command is wrong and I should be using "Set" Instead?
 
Hey Laurana,

It's still not working after spellchecking. I'm going to call this one a wash. Thanks for all your help--I learned a lot about making mods in Civ 6 through this process, even if it wasn't successful.

So that everyone has a record of the final codebase, in case anyone finds this years down the line:

Code:
<?xml version="1.0" encoding="utf-8"?>
<Mod id="9bc14b36-d19c-47c7-89a2-5e1b9b06c61b" version="1">
    <Properties>
        <Name>Inca Buff</Name>
        <Teaser>This mod gives the Inca some advantages. </Teaser>
        <Description>This mod buffs the Inca. I made this for my sister, who is quite bad at this game.</Description>
        <Authors>OurOhnlyHope</Authors>
        <CompatibleVersions>1.2,2.0</CompatibleVersions>
    </Properties>
    
    <InGameActions>
        <UpdateDatabase id="Gameplay">
            <Properties>
                <LoadOrder>550</LoadOrder>
            </Properties>
        </UpdateDatabase>
    </InGameActions>
    <Files>
        <File>Code.sql</File>
    </Files>
</Mod>

Code:
--===================================
-- SQL by OurOhnlyHope
--===================================   
-- Inca Buff Patch
-------------------------------------   

-------------------------------------
-- Civilization Buffs so Ally doesn't get ganked on turn 60 by Canada anymore
-------------------------------------

INSERT INTO CivilizationTraits
        (CivilizationType,        TraitType)
VALUES     ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_LAND_DOWN_UNDER'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_EJERCITO_PATRIOTA'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_IMPERIAL_FREE_CITIES'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_SCOTTISH_ENLIGHTENMENT'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_PLATOS_REPUBLIC'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_ADJACENT_DISTRICTS'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZAITON_ALL_ROADS_TO_ROME'),
        ('CIVILIZATION_INCA',    'TRAIT_CIVILIZATION_MONGOLIAN_ORTOO');

-------------------------------------
-- Leader Buffs in case the above isn't even enough
-------------------------------------

INSERT INTO LeaderTraits
        (LeaderType,            TraitType)
VALUES     ('LEADER_PACHACUTI',    'TRAIT_LEADER_GIFTS_FOR_TLATOANI');
 
Top Bottom