Introducing "Quo's Spheres of Intrigue"

[isau]

Hi all,

So the big news is the mod that was previously known as Quo's Combined Tweaks is morphing into something new. Going forward it will be called Quo's Spheres of Intrigue, and focus less on being a "balance" mod like it did before, and more like a small expansion pack that adds features.

Key features of this mod, continued from Quo's Combined Tweaks, are:

• The sphere system, with unique powers for each sphere
• The Friendship Gift system, in which making friends with other civs provides a gift
• The bedrock system, that limits where you can build Walls
• The MyOptions system that provides the ability to turn various features on or off
• The MyScratchpad file which provides an easy way to add your own custom SQL code to the mod for tweaks you would like to make
• Various other assorted systems

Huge thanks to @Gedemon and other moderators at Civ Fanatics for assisting in getting the new forum set up.

You can expect the first release of Spheres of Intrigue in the next day or so, with a couple of new features.

 

[Guynemer]

Looking forward to the next stage!

Finally managed to complete a North Africa sphere game (as Cleo); that was a lot of fun.

 

[Grathocke]

I used your guidance in the MyScratchpad and have been able to get custom civs and custom leaders working great with the spheres. Thanks.

 

[Grathocke]

@isau I'm having trouble now adding additional civs beyond 2 to the scratchpad. No matter which one I choose to add, after the 2nd one the additional one will not utilize the sphere. Por ejemplo:

`INSERT OR REPLACE INTO CivilizationTraits
(CivilizationType, TraitType)
SELECT '('CIVILIZATION_SUK_TIBET', 'QUO_TRAIT_BIOME_ASIAN_EXPANSE')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_SUK_TIBET'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);

SELECT '('CIVILIZATION_NETHERLANDS', 'QUO_TRAIT_BIOME_WEST_EUROPE')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_NETHERLANDS'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);

SELECT '('CIVILIZATION_CAF_BYZ', 'QUO_TRAIT_BIOME_ROMANESQUE')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_CAF_BYZ'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);

Can you enlighten me as to what I am doing wrong?

 

[isau]

You need to write the full INSERT statement for each one.


INSERT OR REPLACE INTO CivilizationTraits
(CivilizationType, TraitType)
SELECT '('CIVILIZATION_NETHERLANDS', 'QUO_TRAIT_BIOME_WEST_EUROPE')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_NETHERLANDS'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);

 

[isau]

There's some good news about the next patch. I finally dug far enough into the AI programming to figure out why AI Brazil refused to build its special Brazilian Revolution project. Turns out there's a column Firaxis created in the AI tables that is a total mismatch for what it actually does. Once I corrected this, AI Brazil has suddenly because willing to trigger it.

 

[Laurana Kanan]

There's some good news about the next patch. I finally dug far enough into the AI programming to figure out why AI Brazil refused to build its special Brazilian Revolution project. Turns out there's a column Firaxis created in the AI tables that is a total mismatch for what it actually does. Once I corrected this, AI Brazil has suddenly because willing to trigger it.

I'm curious what the correction is as I have had a similar issue with getting Civs to build a special project.

 

[isau]

I'm curious what the correction is as I have had a similar issue with getting Civs to build a special project.

The issue is the LeaderType field. What needs to go here is not the LeaderType at all, but instead the TraitType. The actual TraitType field should be left alone.

 

[Grathocke]

You need to write the full INSERT statement for each one.

OK, I've tried that. It seems that for some reason I can only get Tibet to work. Probably something to do with the Dalai Lama.
Here's my text:
INSERT OR REPLACE INTO CivilizationTraits
(CivilizationType, TraitType)
SELECT '('CIVILIZATION_SUK_SIAM', 'QUO_TRAIT_BIOME_ASIAN_PACIFIC')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_SUK_SIAM'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);
`INSERT OR REPLACE INTO CivilizationTraits
(CivilizationType, TraitType)
SELECT '('CIVILIZATION_SUK_TIBET', 'QUO_TRAIT_BIOME_ASIAN_EXPANSE')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_SUK_TIBET'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);
I've added color exactly as it shows up in Notepad++.
I have tried multiple civs, always with the same result. Oddly, I tried Sukitract's Iceland and used the Western Europe biome. Instead, he had the Boreal Europe biome, although it said "Nordic Sphere" or something similar. I couldn't find anywhere in the Iceland files where this mod was even mentioned. I also discovered that his Hadrian leader and Gedemo's William pick up the biome on their own. At any rate, I'm a bit confused and it's getting late. I can't figure this one out.

 

[isau]

OK, I've tried that. It seems that for some reason I can only get Tibet to work. Probably something to do with the Dalai Lama.
Here's my text:
INSERT OR REPLACE INTO CivilizationTraits
(CivilizationType, TraitType)
SELECT '('CIVILIZATION_SUK_SIAM', 'QUO_TRAIT_BIOME_ASIAN_PACIFIC')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_SUK_SIAM'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);
`INSERT OR REPLACE INTO CivilizationTraits
(CivilizationType, TraitType)
SELECT '('CIVILIZATION_SUK_TIBET', 'QUO_TRAIT_BIOME_ASIAN_EXPANSE')
FROM Civilizations WHERE Civilizations.CivilizationType='CIVILIZATION_SUK_TIBET'
AND EXISTS (SELECT 1 FROM tblQuoOptions WHERE OptionId='QUO_OPTION_ENABLE_BIOMES' AND Value > 1);
I've added color exactly as it shows up in Notepad++.
I have tried multiple civs, always with the same result. Oddly, I tried Sukitract's Iceland and used the Western Europe biome. Instead, he had the Boreal Europe biome, although it said "Nordic Sphere" or something similar. I couldn't find anywhere in the Iceland files where this mod was even mentioned. I also discovered that his Hadrian leader and Gedemo's William pick up the biome on their own. At any rate, I'm a bit confused and it's getting late. I can't figure this one out.

SUK's Iceland is explicitly supported by this mod, so if you have it installed, Iceland will automatically get the Nordic sphere.

I haven't seen his/her Siam or Tibet mods yet, so I may need to take a look. If they are as good as the Iceland mod I can add explicit support for them.


I would recommend downloading SQLite Studio (see my instructions in the Tutorial library on how to connect to the database) and running this query:

select * from civilizationtraits
left join traits using (traittype)
left join traitmodifiers using (traittype)
left join modifiers using (modifierid)
left join modifierarguments using (modifierid)
where civilizationtype like "%CHINA%"

Replace China with the name of the Civ you want to investigate. You should see a bunch of rows with the Biome Traits listed under the civ. This is how I do my QA and testing.

Example below.

You can also use SQLite Studio to test whether your code is working prior to putting it In MyScratchpad.

 

[Laurana Kanan]

The issue is the LeaderType field. What needs to go here is not the LeaderType at all, but instead the TraitType. The actual TraitType field should be left alone.

View attachment 521052

Hmm, my issue must be somewhere else as I have correctly used TRAIT_LEADER_MAJOR_CIV for that column. I thought maybe there was something else I might have left out. Might just be the valuation is too low. Thank you though.

p.s. Looking at your screenshot, aren't you using AgendaType not TraitType? The TraitType would be TRAIT_AGENDA_GREAT_PERSON_OBSESSED. I mean it probably doesn't matter as the TraitType is attached to the AgendaType.

 

[kevinbad2010]

Hey there was wondering about a release date guessing it will be around next week?
Thanks in advance.

 

[isau]

Hey there was wondering about a release date guessing it will be around next week?
Thanks in advance.

Hmm, my issue must be somewhere else as I have correctly used TRAIT_LEADER_MAJOR_CIV for that column. I thought maybe there was something else I might have left out. Might just be the valuation is too low. Thank you though.

p.s. Looking at your screenshot, aren't you using AgendaType not TraitType? The TraitType would be TRAIT_AGENDA_GREAT_PERSON_OBSESSED. I mean it probably doesn't matter as the TraitType is attached to the AgendaType.

Sorry, you are correct. Try an Agenda Type.

 

[isau]

Hey there was wondering about a release date guessing it will be around next week?
Thanks in advance.

I am traveling next week so I am hoping to do an Alpha release prior to that. Perhaps tomorrow (Saturday).

The new version isn't terribly different from where Quo's Combined Tweaks was to start out, but there are some pretty nice (IMO) changes.

 

[rockinroger]

Congrats on the new project isau. I have been quietly playing your mod for quite awhile. I have been inactive on reporting stuff. I will do what I can to help you test things.

 

[isau]

It's just a small thing but here's a preview of a feature that will be in the first release of Spheres of Intrigue. Now when a city hits certain break points for the number of districts constructed (currently 1, 4, and 7 districts) it will automatically get roads appropriate to the era surrounding the city. I am still doing some testing to be sure this doesn't break railroads before it becomes an official part of the mod.

 

[isau]

The first version of Spheres of Intrigue is now available and has been posted here:

https://forums.civfanatics.com/resources/quos-spheres-of-intrigue.27445/

 

[Guynemer]

Any particular civs you want feedback on in this new version?

 

[isau]

Any particular civs you want feedback on in this new version?

Just any observations you have are helpful.

 

[Guynemer]

Rolled Poundmaker. I don't think you touched the Native America sphere, other than the governor changes, so not a whole lot of new input, other than I absolutely love the North America sphere. The only excluded governor is the one I never use anyway, and automatic 100% loyalty at all times is crazy powerful for grabbing spots near resources and natural wonders and such. The only downside is, like the lack of castellan, kind of moot, as cavalry units aren't usually my preferred fighting style.

I'm not sure if Native America is overpowered, or it just fits me perfectly.

I enjoyed the new road system as well; it did not seem to interfere with railroads at all.