sql

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

I have recently implemented a complete rework of the tech tree in a scenario I have been cobbling together for a while now. I partially used a tool, IndieStoneTechEditor, for the code generation, but basically most techs were deleted and a host of new ones added in. I removed the final three...

I put this "insert into Yields values ('YIELD_TEST', 'LOC_YIELD_TEST_NAME', '[ICON_Faith]', -0.5, 1);" in a .sql file and it shows up in the Yields table as a new yield. I also made granary produce 1 "test" per turn which it says it does, but how do I display how much of the new yield I...

Is it possible to give a plot minus to a yield due to adjacency, and make this conditional? Background I've written sql code that allows Fishing Boats to be built on any coastal tile, which works fine. New Goal I want Fishing boats to get -1 to food for every two adjacent Fishing boats. I've...

I made a builder identical to the vanilla Builder, except he only has 1 build charge. I gift him to players (human and AI) with a lua script. Everything is working fine, except the AI refuses to use the custom Builder unless he is both able to be trained in a city and cheaper than the vanilla...

Hello all, I've been working on a small project that I hope will be able to assist the modding community. The goal was to help bridge the gap of the understanding of SQL to a more open broad range of people who may not have coding experience or prefer a visual representation of it due to the UI...

Idk what I'm expecting to come of this but the terms are too ambiguous for the search bar to be useful so I might as well ask anyway. I was trying to populate a table with binary numbers using SQL's recursion because I'm a showoff who wants to use this basic understanding of the mechanic at...

Archive of Troubleshooting articles written for the Civilization Modding Monthly since although publishing them there allows them to be presented to a wider audience, it's less useful for people searching for answers and for directing questioners. Some of these articles can , or may in some...

I'm trying to create a world wonder, and while i have all the effects i want and the art ready i wanted to give it a special effect, which would be to give +1 gold for every gold producing building (e.g market, bank) it would be extremely tedious to do by hand for each building so i remembered...

I'm trying to introduce the next change in my mod: - cities yield per population is decreased greatly, - each district generates a yield of the corresponding type based on city population - you can build any number of districts of the same type for the city, their summed yield should be...

Hello, I am currently trying to make my first own civ in civ 6, I have used Josh Atkins YouTube tutorial and used his template. Now I am stuck at adding the ability to my new civ, that enables all units to ignore hills. I have written this code so far. Here it is as xml: <?xml version="1.0"...

Hello, I'm trying to use SQL to make a change to the Policies database - IF Vox Populi is NOT enabled (i.e. in case of a normal, non-VP game). Here is the syntax: UPDATE Policies SET BuildingGoldMaintenanceMod = -33 WHERE Type='POLICY_TRADE_UNIONS' AND NOT EXISTS (SELECT * FROM...

Code: <Terrains> <Update> <Where TerrainType="TERRAIN_GRASS_MOUNTAIN" CivilizationType="CIVILIZATION_FEB_CARTHAGE"/> <Set MovementCost="5" Impassable="0" DefenseModifier="3" /> </Update> <Update> <Where...

I want to make every base game civ unplayable if the right ruleset is selected (gonna replace them with my own). I've already added a ruleset and a new civilization (it can even be played with the wrong ruleset, though). Please help! Thanks!

[DELETED] Please delete [DELETED]

I would like to merge VPEE compatibility patch into MUCfVP mod and create ENW small compatibility update too. I only wonder how to code that because if I just put the code then it will throw errors for people who do not use fe. VPEE. Is it possible to code smth like: if VPEE is enabled then...

So I wanted to add new diplomacy texts to my custom civ and for some reason, the text themselves won't show up. I have already successfully inserted text using SQL for buildings and things and after a check of Civ5DebugDatabase.db it would seem all the Response types got inserted correctly (for...

So the problem I'm having is that sometimes the cities will vanish with only the city banner remaining. I've read on the forums that it's either "new building with DisplayPosition column inserted that clashes with another building" or "wrongly inserted art defines for building styles in SQL"...

I want to give all units the Amphibious promotion as a trait, is that possible?

Hi! I'm working on a mod that changes how Barbarians work (i.e. It's a "Wandering Monster" mod that adds 50 WMs to the game, who spawn as Barbarians). Part of the mod seeks to adjust Barb DEFINES as well. I have a "configuration.sql" file that is loaded at the beginning of the mod. The...