1. We have added a Gift Upgrades feature that allows you to gift an account upgrade to another member, just in time for the holiday season. You can see the gift option when going to the Account Upgrades screen, or on any user profile screen.
    Dismiss Notice

Introducing "Quo's Spheres of Intrigue"

Discussion in 'Quo's Spheres of Intrigue' started by isau, Mar 19, 2019.

  1. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048
    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.

    upload_2019-3-19_17-34-4.png


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

    Guynemer Chieftain

    Joined:
    Feb 20, 2002
    Messages:
    396
    Looking forward to the next stage!

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

    Grathocke Marquis

    Joined:
    Dec 19, 2009
    Messages:
    242
    Gender:
    Male
    Location:
    New Orleans, Louisiana, USA
    I used your guidance in the MyScratchpad and have been able to get custom civs and custom leaders working great with the spheres. Thanks.
     
  4. Grathocke

    Grathocke Marquis

    Joined:
    Dec 19, 2009
    Messages:
    242
    Gender:
    Male
    Location:
    New Orleans, Louisiana, USA
    @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?
     
  5. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048
    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);
     
  6. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048
    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.

    upload_2019-3-21_17-27-7.png
     
    TaylorItaly and Guynemer like this.
  7. Laurana Kanan

    Laurana Kanan Don’t underestimate who I am.

    Joined:
    Apr 10, 2014
    Messages:
    1,727
    Gender:
    Female
    Location:
    Near the Greatest Snow on Earth
    I'm curious what the correction is as I have had a similar issue with getting Civs to build a special project.
     
  8. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048
    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.

    upload_2019-3-21_20-45-2.png
     
  9. Grathocke

    Grathocke Marquis

    Joined:
    Dec 19, 2009
    Messages:
    242
    Gender:
    Male
    Location:
    New Orleans, Louisiana, USA
    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. :lol:
    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.
     
  10. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048


    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:

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

    upload_2019-3-21_23-1-54.png


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

    Attached Files:

  11. Laurana Kanan

    Laurana Kanan Don’t underestimate who I am.

    Joined:
    Apr 10, 2014
    Messages:
    1,727
    Gender:
    Female
    Location:
    Near the Greatest Snow on Earth
    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.
     
  12. kevinbad2010

    kevinbad2010 Chieftain

    Joined:
    Mar 20, 2016
    Messages:
    18
    Location:
    Ireland
    Hey there was wondering about a release date guessing it will be around next week?
    Thanks in advance.
     
  13. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048

    Sorry, you are correct. Try an Agenda Type.
     
  14. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048

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

    rockinroger WoC Team Member

    Joined:
    Feb 6, 2006
    Messages:
    1,312
    Location:
    Overland Park, Kansas
    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 likes this.
  16. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048
    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.

    upload_2019-3-23_14-11-51.png

    upload_2019-3-23_14-13-12.png

    upload_2019-3-23_14-16-51.png
     

    Attached Files:

  17. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048
  18. Guynemer

    Guynemer Chieftain

    Joined:
    Feb 20, 2002
    Messages:
    396
    Any particular civs you want feedback on in this new version?
     
  19. isau

    isau Warlord

    Joined:
    Jan 15, 2007
    Messages:
    3,048

    Just any observations you have are helpful.
     
  20. Guynemer

    Guynemer Chieftain

    Joined:
    Feb 20, 2002
    Messages:
    396
    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.
     

Share This Page