1. We have added the ability to collapse/expand forum categories and widgets on forum home.
    Dismiss Notice
  2. All Civ avatars are brought back and available for selection in the Avatar Gallery! There are 945 avatars total.
    Dismiss Notice
  3. To make the site more secure, we have installed SSL certificates and enabled HTTPS for both the main site and forums.
    Dismiss Notice
  4. Civ6 is released! Order now! (Amazon US | Amazon UK | Amazon CA | Amazon DE | Amazon FR)
    Dismiss Notice
  5. Dismiss Notice
  6. Forum account upgrades are available for ad-free browsing.
    Dismiss Notice

SQL Maker Tool (Excel) 1.0.2

Creates the SQL to Add Tech/Civics, Modifiers and more (WIP)

  1. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Elucidus submitted a new resource:

    Civic/Tech SQL Maker Tool - Creates the SQL to Add Tech/Civics

    Read more about this resource...
     
  2. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Output looks like this:

    output.png

    What it looks like in game:

    final product.png


    Oh you can copy the entire 5 rows and paste them below and you can make multiple techs at a time.

    extras.png


    Output:
    Extras Output.png
     
    Last edited: Dec 8, 2016
    Seven05 likes this.
  3. Seven05

    Seven05 Warmonger

    Joined:
    Dec 5, 2005
    Messages:
    2,016
    Gender:
    Male
    Location:
    USA
    OK, this is very cool. Maybe the tech tree won't be so scary after all. :)
     
  4. cof125

    cof125 Chieftain

    Joined:
    Sep 14, 2014
    Messages:
    153
    Thank you very much... so needed this cuz changing tech tree takes forever by hand ez to make mistakes. This is a blessing.
     
  5. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Glad, it's useful, I am working on a Modifiers one, but it is much more complicated. It can affect something like 10 tables if you include requirements and the different modifier tables (BuildingModifiers for example).
     
  6. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
  7. thecrazyscot

    thecrazyscot Spiffy

    Joined:
    Dec 27, 2012
    Messages:
    1,668
    Glad to see I'm not the only one looking for ways to make things less tedious. I've made an SQL modifer/requirement autogenerator (although I need to update it to add support for up to 5 modifier arguments for a single entry...currently at 3). Takes a somewhat different approach from you, but you may find it interesting.
     
  8. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    :) Wish I saw that earlier. Yeah, I am lazy, and my plans call for a lot of modifiers, so I made this to make it easier. i was trying to break it down to a lower level, but that was too much. I cam eon to upload my latest version.

    I just finished the first version of my Modifier/Requriement maker. :) Took quite a bit of work, but it only goes up to 4 requirement and modifier arguments.

    This new version hasn't been well tested, I tried a couple of things and I don't have time to get a proper tutorial up, but anyone who wants to play with it, go nuts.
     
  9. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Elucidus updated Civic/Tech SQL Maker Tool with a new update entry:

    SQL Maker 0.9a

    Read the rest of this update entry...
     
  10. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Identified a couple of big bugs.

    Need to add additional input for the modifieriIds of additional items and need to have it validate requirements that cannot be duplicated to be ignored when outputting the code, so they are only referenced for the Ids.

    See the notes below.
    2016-12-12.png
     
  11. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Okay so I am fixing it, and I am thinking 5 ModArguments to One modifier and 5 Modifiers to one set of Requirements?

    That would allow something like modifying almost all of the yields, Food, Production, Gold, Faith and Culture, Leaving out Science...should I just make a sixth? Man this is getting crazy...
     
  12. Mynex

    Mynex Chieftain

    Joined:
    Sep 30, 2010
    Messages:
    287
    I would (add the sixth), just for completeness.
     
  13. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    As if it didn't just get even more complicated :)

    But maybe I can work it in there.
     
  14. Mynex

    Mynex Chieftain

    Joined:
    Sep 30, 2010
    Messages:
    287
    Well, just remember, you did this to yourself! :D

    Anyway, I'd rather have a thorough, complete (as possible) setup and work out the kinks as they pop up than do all this fun stuff by hand. So you're efforts to make my modding life are very much appreciated. :)
     
  15. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Thanks. I'll try and have a working copy by Thursday or Friday.

    Wish I could rename the Resource now to just SQL Maker. :)
     
  16. Mynex

    Mynex Chieftain

    Joined:
    Sep 30, 2010
    Messages:
    287
    Dunno if you can get it renamed, but it doesn't hurt to ask an Op.
     
  17. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    I guess I could go to the thread tools at the top (which I didn't see earlier).

    BTW, the deeper I get, the more complicated this gets.

    So I will probably do it in stages, many many stages.
     
  18. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Elucidus updated SQL Maker Tool with a new update entry:

    SQL Maker 1.0.1

    Read the rest of this update entry...
     
  19. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    Elucidus updated SQL Maker Tool with a new update entry:

    SQL Maker 1.0.2

    Read the rest of this update entry...
     
  20. Elucidus

    Elucidus Chieftain

    Joined:
    Mar 3, 2002
    Messages:
    980
    Location:
    USA
    New patch has several new game effects added to gameEffects.xml:

    REQUIREMENT_SPECIFIC_LEADER_ELIMINATED
    REQUIREMENT_PLAYER_ERA_AT_LEAST
    REQUIREMENT_CULTURE_BOMBED
    EFFECT_REPLACE_PLAYER_GOVERNMENT_SLOT_TYPE
    EFFECT_ADJUST_UNIT_FORCE_RETREAT
    EFFECT_ADJUST_PLAYER_YIELD_MODIFIER_PER_EARNED_GREAT_PERSON
    EFFECT_ADJUST_CULTURE_BOMB_CONVERTS_CITY
    EFFECT_ADJUST_CITY_TRADE_ROUTE_YIELD_FOR_DOMESTIC
    EFFECT_ADJUST_CITY_TRADE_ROUTE_YIELD_FOR_INTERNATIONAL
    EFFECT_ADJUST_CITY_AMENITIES_FROM_CITY_STATES
    EFFECT_ADD_CULTURE_BOMB_TRIGGER
     
    Mynex likes this.

Share This Page