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

Reform and Rule

Discussion in 'Civ5 - Modpacks' started by Machiavelli24, Oct 21, 2013.

  1. azurial

    azurial Chieftain

    Joined:
    Sep 26, 2010
    Messages:
    59
    Location:
    Greece
    Basically i want to give unhappy:mad: to some buildings (among other things)
    So i was thinking to apply an invisible policy to all Civs from the start of the game. The policy will have the buildings with unhappy "bonus"...
    Another solution, is to make only one policy available from the start and adding to it the buildings (just to make sure all civs will adopt it by the same "time")
     
  2. Machiavelli24

    Machiavelli24 Mod creator

    Joined:
    May 9, 2012
    Messages:
    818
    Making a building give unhappiness is a bit tricky since the game assumes the happiness provided by a building will be 0 or more. To do unhappiness you would need to do something like replace the ~7 or so happiness players start with due to difficulty with a no-limit building in the capital that provided +1 global happiness. Unhappiness would be done by reducing this stock of buildings. However, it would only allow at most ~7 unhappiness.
     
  3. bane_

    bane_ Howardianism High-Priest

    Joined:
    Nov 27, 2013
    Messages:
    1,559
    Came back to Civ and played with Reform and Rule. Just curious, is this MOD still being updated? :)
     
  4. Machiavelli24

    Machiavelli24 Mod creator

    Joined:
    May 9, 2012
    Messages:
    818
    Yes it is. I'm currently working on some back end stuff that will make it so end users don't have to worry about mod load order. Gameplay-wise I'm working on a set of tweaks to the Exploration branch.
     
  5. bane_

    bane_ Howardianism High-Priest

    Joined:
    Nov 27, 2013
    Messages:
    1,559
    Awesome. :)

    I had a mod incompatibility but couldn't properly assess with which Mod (as I play with way too many to test individually), where Tradition and Commerce had wonky paths and only 4 Policies.
    Not asking for a solution, just hoping that someone may have a similar experience and we can trade information.
     
  6. Machiavelli24

    Machiavelli24 Mod creator

    Joined:
    May 9, 2012
    Messages:
    818
    That sounds like clobbering. Two mods trying to edit social policies are overwriting each other's changes. Do you know off hand if one of the other mods you were using changed social policies?

    Also, if you have logging enabled I could take a look at your database.log which may help give an indication of what is happening.
     
  7. bane_

    bane_ Howardianism High-Priest

    Joined:
    Nov 27, 2013
    Messages:
    1,559
    Unfortunately, this is all the log shows related to policies/policy:

    Spoiler :
    [16155.432] table Policy_FreeBuildingClass already exists
    [16155.432] In XMLSerializer while building table Policy_FreeBuildingClass from file Shared/Policies grant buildings/Policy_FreeBuildingClass.xml.
    [16155.541] no such table: Policy_FreeBuildingClassCapital
    [16155.541] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16155.541] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/1 Tradition/1.2 Legalism.xml.
    [16155.650] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16155.650] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16155.650] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/1 Tradition/2.4 Landed_Elite.xml.
    [16155.650] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16155.650] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16155.650] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/1 Tradition/4 Tradition_Finisher.xml.
    [16155.978] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16155.978] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16155.978] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/2 Liberty/4 Liberty_Finisher.xml.
    [16157.179] no such table: Policy_FreeBuildingClassCityStates
    [16157.179] In Query - insert into Policy_FreeBuildingClassCityStates('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.179] In XMLSerializer while updating table Policy_FreeBuildingClassCityStates from file Social Policies/5 Patronage/1.2 Merchant_Confederacy.xml.
    [16157.179] no such table: Policy_FreeBuildingClassCityStates
    [16157.179] In Query - insert into Policy_FreeBuildingClassCityStates('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.179] In XMLSerializer while updating table Policy_FreeBuildingClassCityStates from file Social Policies/5 Patronage/1.5 Hegemony.xml.
    [16157.179] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16157.179] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.179] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/5 Patronage/2.1 Philanthropy.xml.
    [16157.179] no such table: Policy_FreeBuildingClassCityStates
    [16157.179] In Query - insert into Policy_FreeBuildingClassCityStates('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.179] In XMLSerializer while updating table Policy_FreeBuildingClassCityStates from file Social Policies/5 Patronage/2.3 Scholasticism.xml.
    [16157.179] no such table: Policy_FreeBuildingClassCityStates
    [16157.179] In Query - insert into Policy_FreeBuildingClassCityStates('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.179] In XMLSerializer while updating table Policy_FreeBuildingClassCityStates from file Social Policies/5 Patronage/2.5 Sphere_Influence.xml.
    [16157.179] no such table: Policy_FreeBuildingClassCityStates
    [16157.179] In Query - insert into Policy_FreeBuildingClassCityStates('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.179] In XMLSerializer while updating table Policy_FreeBuildingClassCityStates from file Social Policies/5 Patronage/4 Patronage_Finisher.xml.
    [16157.522] no such table: Policy_FreeBuildingClassCapital
    [16157.522] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.522] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/7 Commerce/1.2 Wagon_Trains.xml.
    [16157.522] no such table: Policy_FreeBuildingClassCapital
    [16157.522] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16157.522] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/7 Commerce/1.4 Entrepreneurship.xml.
    [16158.349] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16158.349] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16158.349] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/9 Rationalism/4 Rationalism_Finisher.xml.
    [16158.365] no such table: Policy_FreeBuildingClassCapital
    [16158.365] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16158.365] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/91 Freedom/1 Campaign_Consultants.xml.
    [16158.365] no such table: Policy_FreeBuildingClassCapital
    [16158.365] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16158.365] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/91 Freedom/1 Economic_Statecraft.xml.
    [16158.567] no such table: Policy_FreeBuildingClassCapital
    [16158.567] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16158.567] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/91 Freedom/1 Tenure.xml.
    [16158.801] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16158.801] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16158.801] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/91 Freedom/2 Free_Speech.xml.
    [16158.848] no such table: Policy_FreeBuildingClassCapital
    [16158.848] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16158.848] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/91 Freedom/3 Aerospace_Engineering.xml.
    [16159.363] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16159.363] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16159.363] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/92 Autocracy/2 Martial_Law.xml.
    [16159.472] no such table: Policy_FreeBuildingClassCityStates
    [16159.472] In Query - insert into Policy_FreeBuildingClassCityStates('PolicyType', 'BuildingClassType') values (?, ?);
    [16159.472] In XMLSerializer while updating table Policy_FreeBuildingClassCityStates from file Social Policies/92 Autocracy/3 Protectorate.xml.
    [16159.488] no such table: Policy_FreeBuildingClassCapital
    [16159.488] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16159.488] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/93 Order/1 Great_Leap_Forward.xml.
    [16159.519] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16159.519] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16159.519] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/93 Order/1 State_Monopoly.xml.
    [16159.613] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16159.613] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16159.613] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/93 Order/2 Birthplace_Revolution.xml.
    [16159.613] no such table: Policy_FreeBuildingClassCapital
    [16159.613] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16159.613] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/93 Order/2 Environmental_Research.xml.
    [16160.143] table Policy_FreeBuildingClass has no column named BuildingClassType
    [16160.143] In Query - insert into Policy_FreeBuildingClass('PolicyType', 'BuildingClassType') values (?, ?);
    [16160.143] In XMLSerializer while updating table Policy_FreeBuildingClass from file Social Policies/93 Order/3 National_Space_Agency.xml.
    [16160.143] no such table: Policy_FreeBuildingClassCapital
    [16160.143] In Query - insert into Policy_FreeBuildingClassCapital('PolicyType', 'BuildingClassType') values (?, ?);
    [16160.143] In XMLSerializer while updating table Policy_FreeBuildingClassCapital from file Social Policies/93 Order/3 Nuclear_Program.xml.
    [16168.474] near "SELECT": syntax error


    The rest is text problems with other mods.
    Hey, thanks by the way. :goodjob:


    EDIT: Also, I said 'Liberty and Commerce', but it was 'Tradition and Commerce' in reality. Fixed.
     
  8. Machiavelli24

    Machiavelli24 Mod creator

    Joined:
    May 9, 2012
    Messages:
    818
    Well, that looks like an easy fix. The line that says "table Policy_FreeBuildingClass already exists" is the issue and every error after it is stuff that depends on that table to work correctly.

    Reform and Rule creates a table called "Policy_FreeBuildingClass" but it looks like some other mod also created an identically named table. Depending on what the other mod expects that table to look like it will either be a quick fix or a trickier fix.

    The "Policy_FreeBuildingClass" is created by some code that supports policies granting buildings. If you are using another Social Policy mod that uses that code than the fix is very easy. You'll need to change the table creation code to use "If not exists" (I'll be able to provide the exact code later today).

    However, if another mod is creating the table but using it in a different way the fix will be trickier. You'll need to rename all the instances of the table in one of the mods. That way each mod will still have their own table to use, but they won't clash on the name.

    To figure out which case you're in, (if you don't know off hand what other social policy mod you may have) you can:

    1) Using a program like WindowsGREP search through your mod directory for "Policy_FreeBuildingClass".
    2) UseSQLiteManager to take a peak at the civ 5 debug database after loading all your mods. Take a screenshot of the contents of the policy_FreeBuildingClass table.
     
  9. bane_

    bane_ Howardianism High-Priest

    Joined:
    Nov 27, 2013
    Messages:
    1,559
    Well, dammit.

    I deleted the cache before seeing your post and it's all perfect now. Still, I performed the grepWin step and found only Communitas (along with our mod, of course) in a regex search, but it was inactive while playing - which makes erasing the cache the next step anyway. :lol:

    Not sure if I already mentioned that, but Honor is finally a viable choice, thanks to your Mod. I don't like playing the Domination game, but I couldn't resist trying a Mongolian Invasion of the Pangea World with those sexy tempting policies. :D

    Thank you very much!
     
  10. Skaz881

    Skaz881 History Major

    Joined:
    Dec 15, 2013
    Messages:
    1,349
    Location:
    Crystal Lake, Illinois, USA.
    I've never played domination, but I know I should try it. I haven't used RAR's Honor (namely because one of my mods gives one of the Honor tenets plus 2 production in the capital) but who knows, I might give it a shot.
     
  11. demondance

    demondance Warlord

    Joined:
    Oct 6, 2012
    Messages:
    166
    One of the most important make me still play Civ5 is your mod.

    That so awesome and super awesome when heard that you are still working on this mod.
     
  12. Machiavelli24

    Machiavelli24 Mod creator

    Joined:
    May 9, 2012
    Messages:
    818
    Reform and Rule verision 19 (The Piracy update) is out!

    This update contains tweaks to the Exploration tree and (to a lesser extent) the Commerce tree as well. There are also a few other minor changes to other policies.

    The main change is one that doesn't effect game play but should be a huge quality of life improvement for people playing with large numbers of mods. Reform and Rule now makes extensive use of database trigger to function correctly no matter what order mods are loaded in. No longer will end users have to manually add references or risk suffering odd idiosyncratic issues.
     
  13. Skaz881

    Skaz881 History Major

    Joined:
    Dec 15, 2013
    Messages:
    1,349
    Location:
    Crystal Lake, Illinois, USA.
    Aren't Piracy and Hegemony doing most of the same thing? It seems like with both policies plus Colonialism you're practically guaranteed to become allies with every city state.
     
  14. Machiavelli24

    Machiavelli24 Mod creator

    Joined:
    May 9, 2012
    Messages:
    818
    The repetition of the bonus at making military units more effective at bullying city-states in Patronage and Exploration has never sat well with me. I try to avoid repeating effects. I still have concerns about the Exploration tree but I want to see if people find its current iteration better.

    I've generally liked the idea of the influence from city-states you can bully being in Exploration but I've read many other people's reactions to it being there as odd. A city-state related policy in a naval tree. I'm trying to rearrange Exploration to try to communicate better what I think the +influence is suppose to encourage to see if it starts clicking for others.

    The intimidate better effect was incorporated into Exploration to try to make it seem like the city-state stuff fit in the tree and that the +influence wasn't just a random effect thrown into the tree.

    I hope this wasn't too rambling. If you were writing a strategy guide for the new Exploration (or any tree for that matter), what would it look like? How would you recommend a player figure out if Exploration is a good tree for them to go in their particular game? What behaviors should a player do to make the most use of Exploration. And what kind of strategy do those behaviors advance?
     
  15. Skaz881

    Skaz881 History Major

    Joined:
    Dec 15, 2013
    Messages:
    1,349
    Location:
    Crystal Lake, Illinois, USA.
    I'll give the new tree a try soon (still have some things to do such as reworking More Pantheons to work with Race for Religion) although for me I'll probably swap one of the city state intimidates over to Autocracy in exchange for Hidden Antiquities.
     
  16. demondance

    demondance Warlord

    Joined:
    Oct 6, 2012
    Messages:
    166
    Explore got a huge change in this new version... it look like this will focus even more on colonist time... well done.

    But one thing still bug me alot is Patronage....

    Hegemony is for capture cs, but what if i dont want to do that ?

    Waste 1 point on Hegemony is bad ideal to get Sphere...

    Well, can i continue play my game with v 19 ?
     
  17. Machiavelli24

    Machiavelli24 Mod creator

    Joined:
    May 9, 2012
    Messages:
    818
    You'll need to finish your existing game before updating to version 19.

    As for Hegemony, if you are "playing nice" with city-states it is of reduced value. However, it does trigger when you liberate city-state, so if Genghis Khan captures Vatican City and you take it back, you'll get the Hegemony culture. I suspect that most players who are "playing nice" with city-states fill out the left side of Patronage first (unless they really want Sphere).

    There is a pretty good chance that I'll be tweaking Exploration again in the next version of Reform and Rule (no release date currently planned, it would be at least a month), so I would be interested in hear what people did with its current iteration.
     
  18. bane_

    bane_ Howardianism High-Priest

    Joined:
    Nov 27, 2013
    Messages:
    1,559
    The Piracy tenet is too powerful in my opinion. I got a super fleet in a Continents game and got a considerably easy Domination win (and I'm not even good at dominating!!) because I could heal my boats on the fly. Without Piracy you need to either conquer the city or wait for a (Tier 2, IIRC) Promotion to be able to do that, so I rarely lost a boat thanks to movement shenanigans.
    Most of my enemies were in a precarious position due to my naval conquest as soon as the Caravels were rolling out, at the middle of the Industrial Era. From that moment on, all I needed was to bring in some land dudes, gain as much gold as the game permitted and spammed a lot of siege units to bring the game home, one non-Coastal city at a time. :)

    The bullying is a very nice effect and I can't see it being abused. It was pretty cool pass by City-States in the way victim and demand Gold. I liked this effect both for gameplay and roleplaying reasons, very well done!
     
  19. demondance

    demondance Warlord

    Joined:
    Oct 6, 2012
    Messages:
    166
    You know, sphere is broken. One of the most ideal to get Sphere is counter other civil who apdopted Sphere. So the ideal is "place nice" with cs, but other civil mess it up by Sphere. That how it's annoy. Vience has a lot of problem with it.

    About tradition, 2 last are weak... really weak.

    - 15% food carry ? joke ? Aqueduct give you 40% food carry. So get 1 point for 15%... i dont think so.
    - Decrease 25% unhappiness on capital and give 1 happy per 10 citizen (round down) ? You force people to play 1 city challenge ?

    >>> About finisher , Traditional and Rationalism are weak, hope you consider more about these two
     
  20. White Out

    White Out Prince

    Joined:
    May 29, 2009
    Messages:
    358
    Gender:
    Male
    Location:
    Calgary
    15% carry over is huge. I disagree.

    I'm going to say that I think rationalism is op. The boost to population and happiness is something I always tone down before I use the mod. Thoughts?
     

Share This Page