sql

Hello, I'm trying to make a mod incorporating more Events into the Vox Populi mod, specifically using the Unhappiness system to make events more realistic. An example is a bank robbery CityEvent that when the CityEventChoices is picked, the city produces -1 Unhappiness from Distress. I see that...

Hello everyone, So I followed the guides on how to make a custom civ and its modifiers, but I'm really confused on that last part. I searched through the root files of the game, and found the IDs. Unfortunately, I couldn't get my traits to work, and I really find it hard to implement them. I...

Hello, I recently discovered the “modding” aspect of CIV VI. I obviously want now to create my own mod or map. However, after looking at some threads and testing the WorldBuilder tool, it seems to be painful to create new maps or modify existing maps from the in game tool. This leads me to...

Making a nomadic forest civ, and i was really hoping to do something for the civ UA like: I've got other parts of the UA to balance it out, but those work fine. It's getting the above to work that i'm having an issue with. So I've narrowed the root cause (probably not the only root cause...

Hello there, I admit I never learned SQL and never used it professionally. Therefore, my skills are low to none. Problem If I split a file in two, it's processed correctly. If it's merged, then some of it (I can't understand precisely where it stops) it's not processed. I know for sure it...

First time creating a mod. Want to make the Liberation War always available. Created my SQL: UPDATE DiplomacyStatements_DeclareWar SET RequiresOccupiedFriendlyCity=0 WHERE KIND_WAR='LIBERATION_WAR'; Essencially changing that Boolean value to 0 so it can always be done. When I build the mod...

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...

Hi, I wanted to create a simple trait granting a permanent +5 strength. But I can't seem to make it work. INSERT OR IGNORE INTO TraitModifiers (TraitType , ModifierId) VALUES ('TRAIT_CIVILIZATION_MAPUCHE_TOQUI' ,'TRAIT_TOQUI_COMBAT_BONUS_UNITS_VS_GOLDEN_AGE_CIV'); INSERT OR...

I want to add a new table for Buildings (and maybe also for Units) that would require multiple resources cost and maintenance, ie: Buildings_Requirements (BuildingType, MainResourceType, MainResourceCosts, SecondResourceType, SecondResourceCosts, MaintenanceRecourceType...

Hi, I have built an Observer mod (Better Spectator Mod), using an unique leader LEADER_SPECTATOR to trigger the change to an observer in game. Everything is lua based and working. My issue another one. Because LEADER_SPECTATOR is currently a member of the Players:Expansion2_Players domain it...

So basically what I wanna do is: that as soon as you research Feudalism, that my unique Unit, (which is a Skutatoi) is spawned upon founding a city with a settler. This should go on until Replacable Parts is researched. After that no units should spawn. Some advice would be nice. Normally I...

hello everyone having trouble getting this to work and have no idea what else to do I added dependencies: nothing added load order, high number: nothing switched from xml to sql: nothing checked the modding.log: no errors concerning this mod it should give the designated leaders a fixed hidden...

New to modding now that I have all this free time due to the pandemic. But I wanted to clear up some of my misconceptions I have. From my reading of Kael's guide, when I make a mod, all my XML files are converted into a SQL database and then used by the game. This data base is called...

I wanna make a teamcolored Stations and later, Bases. When I gonna with units it's works. Next sample for units: MOD/PW_UnitsSubColor.sql UPDATE ArtDefine_UnitMemberInfos SET Model = 'marine04sp_clr.fxsxml' WHERE Type = 'ART_DEF_UNIT_MEMBER_MARINE04SP'; It goes to this...

I'm trying to make it so that every Stock Exchange will give 2 gold per citizen in the city, up to 255 citizens. (In the future +1 when unpowered, another +1 when powered or something similar). Here is what I have so far in an sql file: DECLARE @cnt INT = 1; WHILE @cnt < 256 BEGIN @seyield...

I've been working on a method to validate and merge mods with as much automation as possible. This also has the goal of making mods more friendly to Linux systems and people forgetting to put quotes around filenames. Wondering if anyone has already tackled this and I'm just reinventing the...

For some reason, I'm recieving the following error twice in the database.log: ERROR: UNIQUE constraint failed: Improvement_BonusYieldChanges.Id, Improvement_BonusYieldChanges.ImprovementType, Improvement_BonusYieldChanges.YieldType The only sql I have relating to the...

Hi, I have created a simple game.configuration tickbox in the FrontEnd with XML. I want to execute at simple sql code: UPDATE Units SET PrereqPopulation = '99' WHERE UnitType = 'UNIT_SETTLER'; to prevent players from building settler if this is ticked. How can I affect the gameplay data...

I'm trying to update the text of the shipyard building description but it does not seem to work. UPDATE LocalizedText SET Text='+25% combat experience for all naval units trained in this city. Bonus [ICON_Production] Production equal to the adjacency bonus of the Harbor district. +50%...

I'd like to add a culture adjacency bonus on the theater districts from adjacent harbors. I tried, but the encampment and city center seem to be taken as harbors? Here is the database update code: --harbor district theater adjacency INSERT INTO Adjacency_YieldChanges (ID...