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

JFD's Civilizations - Prussia (Frederick) for Vox Populi (v 9)

Compatibility and balance changes for Vox Populi.

  1. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    JFD's Civilizations - Prussia (Frederick) for Vox Populi
    Does not need the original mod

    Recommended to use with Enlightenment Era for Vox Populi
    (steam workshop)
    (link to original mod)
    Click on the overview button on the top left for information.

    Spoiler UA details :
    Original UA: Specialist GPPs and Yields increase Military Production. Military Buildings provide 33% more XP to newly trained Land Units.

    Era scaling on the specialist Great General points is the same as Korea's.

    The Prussian Discipline Promotion is 15% :c5strength: Combat Strength, 15% more when stacked with a Great General.

    The XP bonus was buffed so that your new units are always 1 to 2 levels higher than normal. It also now applies to free XP from policies (ie the 15 XP from Autocracy's Elite Forces).

    Spoiler UB details :
    UB was added to fit with VP's 1 UU, 1 UB/UI format.

    Spoiler UU details :
    Renamed to Gardekorps due to a name conflict with 4UC.

    Gardekorps gets Stalwart as the combat strength from adjacent units aspect was moved to the UB.

    Retained the Landwehr rather than the Deaths Head Hussar as an infantry UU feels more fitting for a Prussian civilisation.

    Spoiler More UC details :
    Teutonic Order (UB) (replaces Heroic Epic)

    Same as Germany.

    Death's Head Hussar (UU) (replaces Cuirassier)

    • +5 :c5strength: Combat Strength and :c5rangedstrength: Ranged Combat Strength.
    • Legacy of the Black Duke (-10% :c5strength: Combat Strength to enemy units within two tiles, ignores enemy zone of control, enemy units will take 5 damage when this unit enters an adjacent tile).

    Spoiler Mod compatibility details :
    With community events, the civ events are the same as Germany.

    For the civ decisions, "Empower the Junker Nobility" bonus to Landwehr production on citizen birth replaced with +15% supply from population.

    Number of units from "Award the Pour le Mérite" now based on the number of Great Generals, as well as Citadels in your territory, and requires at least one of either to enact. Also no longer consumes your Great Generals. These changes mainly help the AI, and also takes into account the fact that making Citadels is important for unit supply in VP.

    If playing with More Unique Components for VP, Prussia gets the Hanse and Deaths Head Hussar. The Hussar is now a Cuirassier replacement. The unique promotion it gets is now retained on upgrade. The 50% change to deal 5 damage AOE on move is changed to 100% and 2 damage.

    Spoiler Credits :

    • JFD: Author.
    • Janboruta: Art (Civ Icon, Leader Icon, Unique Component Icons, Leaderscene, Map).
    • bernie14: Graphics (UUs).
    • Creative Assembly: Music (Peace).
    • Andrea Waldetoft: Music (War).
    • LeeS: Lua Utilities (Unit Spawn Handler).
    • HungryForFood: Kriegsschule icon (edited from this).
     
    Last edited: Oct 26, 2019
    Svcri and IcyAngel like this.
  2. Barak

    Barak Emperor

    Joined:
    May 1, 2003
    Messages:
    1,514
    Location:
    Chicago
    This looks great! How do I download, as the steam workshop link doesn't work.
     
  3. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    Download now button on the top right. I'm working on the Steam link, the formatting is a pain.

    Edit: Steam Workshop link is up!
     
    Last edited: Mar 7, 2018
  4. Asterix Rage

    Asterix Rage Warlord

    Joined:
    Jun 6, 2010
    Messages:
    1,486
  5. Jarula

    Jarula King

    Joined:
    Oct 22, 2016
    Messages:
    680
    Gender:
    Male
    3rd 4th uniques?
     
  6. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    Deaths Head Hussar, the other UU in the original mod, and Hanse.
     
  7. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
    As requested on Steam in relation to the Civilization not appearing in the list of playable civs once installed, some logs. Bare with me if these are posted oddly, haven't done this in ages.

    Database:
    Code:
    [2338.673] columns StrategicViewType, TileType are not unique
    [2338.673] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
    [2342.464] no such table: ContentPackage.LocalizedText
    [2342.464] no such table: ContentPackage.LocalizedText
    [2342.464] no such table: ContentPackage.LocalizedText
    [2343.415] no such table: ContentPackage.LocalizedText
    [2347.908] columns StrategicViewType, TileType are not unique
    [2347.908] While executing - 'INSERT INTO ArtDefine_StrategicView(StrategicViewType, TileType, Asset) VALUES(?,?,?)'
    [2349.187] no such table: ContentPackage.LocalizedText
    [2349.187] no such table: ContentPackage.LocalizedText
    [2349.187] no such table: ContentPackage.LocalizedText
    [2356.332] Validating Foreign Key Constraints...
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2356.332] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2358.625] Failed Validation.
    [2359.031]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        6358472        75920840
    PageCache:    6        12
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    5943504        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        6
    ------------------------------
    [2359.062] Validating Foreign Key Constraints...
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2359.062] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2361.340] Failed Validation.
    [2361.714]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        6359648        75920840
    PageCache:    6        12
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    5944680        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        6
    ------------------------------
    [2458.045] no such table: Language_zh_CN
    [2458.045] In Query - insert into Language_zh_CN('Tag', 'Text') values (?, ?);
    [2458.045] In XMLSerializer while updating table Language_zh_CN from file Localization/IGE_ZH_CN.xml.
    [2522.302] table UnitPromotions has no column named AoEDamageOnMove
    [2526.966] Validating Foreign Key Constraints...
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2526.966] Invalid Reference on Buildings.TrainedFreePromotion - "PROMOTION_PRUSSIAN_DISCIPLINE" does not exist in UnitPromotions
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2528.433] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2531.631] Invalid Reference on Events.RequiredCiv - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_ColonialCityNames.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_ColonialCityNames.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_ColonialCityNames.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_Governments.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2532.504] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2532.504] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2532.504] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2532.504] Invalid Reference on Events_CulturalDevelopments.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2532.504] Failed Validation.
    [2534.392]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        11205424        75920840
    PageCache:    8        15
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    10424064        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        18
    ------------------------------
    [2534.454] Validating Foreign Key Constraints...
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.454] Invalid Reference on ArtDefine_Landmarks.LayoutHandler - "SPECIAL" does not exist in ArtDefine_LandmarkTypes
    [2534.470] Invalid Reference on Buildings.TrainedFreePromotion - "PROMOTION_PRUSSIAN_DISCIPLINE" does not exist in UnitPromotions
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2535.936] Invalid Reference on Leader_Flavors.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2539.119] Invalid Reference on Events.RequiredCiv - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_ColonialCityNames.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_ColonialCityNames.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_ColonialCityNames.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_Governments.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Civilization_JFD_HeadsOfGovernment.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2540.023] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2540.023] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2540.023] Invalid Reference on Leader_JFD_Reforms.LeaderType - "LEADER_JFD_FREDERICK" does not exist in Leaders
    [2540.023] Invalid Reference on Events_CulturalDevelopments.CivilizationType - "CIVILIZATION_JFD_PRUSSIA" does not exist in Civilizations
    [2540.023] Failed Validation.
    [2541.895]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        11206600        75920840
    PageCache:    8        15
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    10425240        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        18
    ------------------------------
    
    Think I might have noticed some errors. Just a few, here and there.

    XML:
    Code:
    [2356.317] **** Validating Game Database *****
    [2358.625] Performing Localization Checks
    [2358.625] Checking Tag Format...
    [2358.625] Note: Tags must only use [A-Z_] characters, start with 'TXT_KEY_', and be under 128 characters long.
    [2358.641] Validating UnitGameplay2DScripts
    [2358.641] Missing Entry for UNIT_BARBARIAN_HORSEMAN
    [2358.641] **** VALIDATION FAILED *****
    [2358.641] Validation Took 2.325611 seconds
    [2359.031] **** Validating Prefetch Process *****
    [2359.031] **** Validation Success *****
    [2359.031] SetGlobalActionInfo
    [2359.031]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        6358472        75920840
    PageCache:    6        12
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    5943504        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        6
    ------------------------------
    [2359.047] **** Validating Game Database *****
    [2361.340] Performing Localization Checks
    [2361.340] Checking Tag Format...
    [2361.340] Note: Tags must only use [A-Z_] characters, start with 'TXT_KEY_', and be under 128 characters long.
    [2361.340] Validating UnitGameplay2DScripts
    [2361.340] Missing Entry for UNIT_BARBARIAN_HORSEMAN
    [2361.340] **** VALIDATION FAILED *****
    [2361.340] Validation Took 2.295668 seconds
    [2361.714] **** Validating Prefetch Process *****
    [2361.714] **** Validation Success *****
    [2361.714] SetGlobalActionInfo
    [2361.714]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        6359648        75920840
    PageCache:    6        12
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    5944680        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        6
    ------------------------------
    [2526.950] **** Validating Game Database *****
    [2532.504] Performing Localization Checks
    [2532.504] Checking Tag Format...
    [2532.504] Note: Tags must only use [A-Z_] characters, start with 'TXT_KEY_', and be under 128 characters long.
    [2532.535] Validating UnitGameplay2DScripts
    [2532.535] **** Validation Success *****
    [2532.535] Validation Took 5.587444 seconds
    [2534.392] **** Validating Prefetch Process *****
    [2534.392] **** Validation Success *****
    [2534.392] SetGlobalActionInfo
    [2534.392]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        11205424        75920840
    PageCache:    8        15
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    10424064        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        18
    ------------------------------
    [2534.439] **** Validating Game Database *****
    [2540.023] Performing Localization Checks
    [2540.023] Checking Tag Format...
    [2540.023] Note: Tags must only use [A-Z_] characters, start with 'TXT_KEY_', and be under 128 characters long.
    [2540.055] Validating UnitGameplay2DScripts
    [2540.055] **** Validation Success *****
    [2540.055] Validation Took 5.614049 seconds
    [2541.895] **** Validating Prefetch Process *****
    [2541.895] **** Validation Success *****
    [2541.895] SetGlobalActionInfo
    [2541.895]
    -- SQLite Memory Statistics --
    Memory Usage:
            [Cur]        [Max]
    Malloc:        11206600        75920840
    PageCache:    8        15
    LookAside:    0        0
    Scratch:    0        1
    
    Static Buffer Overflows:
            [TooLarge]    [NoSpace]
    PageCache:    10425240        63015960
    Scratch:    0        0
    
    Largest Allocations:
    Malloc:        262144
    PageCache:    1172
    Scratch:    6640
    
    Prepared Statements:
    Current:        18
    ------------------------------
    
     
  8. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    From the errors, somehow it seems like one of the sql files failed to execute for some reason. Go to "[Civ 5 mod folder]\JFD's The Kingdom of Prussia for Vox Populi (v 2)\Core" and try to find Prussia_GameDefines.sql. If it's there, open it with a notepad and see if its corrupted or looks off.

    Either way, try re-downloading and re-installing, will probably fix it.
     
  9. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
    Still nothing.
    The sql is there and looks fine, far as I can tell. Here it is, for reference.

    Code:
    --==========================================================================================================================   
    -- BUILDINGS
    --==========================================================================================================================   
    -- Buildings (NEW)
    ------------------------------   
    INSERT INTO Buildings
                (Type,                                 BuildingClass, Cost,        GoldMaintenance,     PrereqTech,            Description,                                 Civilopedia,                                             Help,                                                 Strategy,                                                NeverCapture,    TrainedFreePromotion,                 SpecialistType,            SpecialistCount,    ArtDefineTag,    MinAreaSize, ConquestProb, HurryCostModifier, PortraitIndex,     IconAtlas,                        CitySupplyFlat)
    SELECT        ('BUILDING_PRUSSIAN_KRIEGSSCHULE'),    BuildingClass, Cost-250,    GoldMaintenance,     'TECH_METALLURGY',    ('TXT_KEY_BUILDING_PRUSSIAN_KRIEGSSCHULE'), ('TXT_KEY_CIV5_BUILDINGS_PRUSSIAN_KRIEGSSCHULE_TEXT'), ('TXT_KEY_BUILDING_PRUSSIAN_KRIEGSSCHULE_HELP'),     ('TXT_KEY_BUILDING_PRUSSIAN_KRIEGSSCHULE_STRATEGY'),    NeverCapture,    'PROMOTION_PRUSSIAN_DISCIPLINE',    'SPECIALIST_SCIENTIST', SpecialistCount+1,    ArtDefineTag,    MinAreaSize, ConquestProb, HurryCostModifier, 0,                 ('JFD_PRUSSIA_FOR_VP_ATLAS'),    CitySupplyFlat
    FROM Buildings WHERE (Type = 'BUILDING_MILITARY_ACADEMY');
    ------------------------------   
    -- Building_Flavors (NEW)
    ------------------------------       
    INSERT INTO Building_Flavors     
                (BuildingType,                         FlavorType,                 Flavor)
    VALUES        ('BUILDING_PRUSSIAN_KRIEGSSCHULE',    'FLAVOR_MILITARY_TRAINING', 25),
                ('BUILDING_PRUSSIAN_KRIEGSSCHULE',    'FLAVOR_CULTURE', 15);
    ------------------------------   
    -- Building_ClassesNeededInCity (NEW)
    ------------------------------       
    INSERT INTO Building_ClassesNeededInCity     
                (BuildingType,                     BuildingClassType)
    SELECT        ('BUILDING_PRUSSIAN_KRIEGSSCHULE'),    BuildingClassType
    FROM Building_ClassesNeededInCity WHERE (BuildingType = 'BUILDING_MILITARY_ACADEMY');
    ------------------------------   
    -- Building_YieldChanges (NEW)
    ------------------------------       
    INSERT INTO Building_YieldChanges     
                (BuildingType,                         YieldType,            Yield)
    VALUES        ('BUILDING_PRUSSIAN_KRIEGSSCHULE',    'YIELD_SCIENCE',    5),
                ('BUILDING_PRUSSIAN_KRIEGSSCHULE',    'YIELD_CULTURE',    4);
    ------------------------------   
    -- Building_DomainFreeExperiences (NEW)
    ------------------------------
    INSERT INTO Building_DomainFreeExperiences     
                (BuildingType,                         DomainType, Experience)
    SELECT        ('BUILDING_PRUSSIAN_KRIEGSSCHULE'),    DomainType, Experience
    FROM Building_DomainFreeExperiences WHERE (BuildingType = 'BUILDING_MILITARY_ACADEMY');
    ------------------------------   
    -- Building_DomainProductionModifiers (NEW)
    ------------------------------
    INSERT INTO Building_DomainProductionModifiers     
                (BuildingType,                         DomainType, Modifier)
    SELECT        ('BUILDING_PRUSSIAN_KRIEGSSCHULE'),    DomainType, Modifier
    FROM Building_DomainProductionModifiers WHERE (BuildingType = 'BUILDING_MILITARY_ACADEMY');
    ------------------------------   
    -- Building_SpecialistYieldChangesLocal (NEW)
    ------------------------------       
    /*INSERT INTO Building_SpecialistYieldChangesLocal     
                (BuildingType, SpecialistType, YieldType, Yield)
    VALUES        ('BUILDING_PRUSSIAN_KRIEGSSCHULE', 'SPECIALIST_SCIENTIST', 'YIELD_GREAT_GENERAL_POINTS', 1);*/
    --==========================================================================================================================   
    -- PROMOTIONS
    --==========================================================================================================================   
    -- UnitPromotions
    ------------------------------
    INSERT INTO UnitPromotions
            (Type,                                         Description,                                 Help,                                             Sound,                 CannotBeChosen,     IgnoreZOC,  LostWithUpgrade,    NearbyEnemyCombatMod,    NearbyEnemyCombatRange, MovesChange,    AoEDamageOnMove,    ExperiencePercent,    GoldenAgeValueFromKills,    PortraitIndex,     IconAtlas,             PediaType,             PediaEntry)
    VALUES    ('PROMOTION_JFD_DEATHS_HEAD',                 'TXT_KEY_PROMOTION_JFD_DEATHS_HEAD',         'TXT_KEY_PROMOTION_JFD_DEATHS_HEAD_HELP',         'AS2D_IF_LEVELUP',     1,                     1,             0,                     -10,                    2,                        0,                2,                    0,                    0,                            59,             'ABILITY_ATLAS',    'PEDIA_ATTRIBUTES', 'TXT_KEY_PROMOTION_JFD_DEATHS_HEAD'),
            ('PROMOTION_PRUSSIAN_DISCIPLINE',            'TXT_KEY_PROMOTION_PRUSSIAN_DISCIPLINE',     'TXT_KEY_PROMOTION_PRUSSIAN_DISCIPLINE_HELP',     'AS2D_IF_LEVELUP',     1,                     0,             0,                     0,                        0,                        1,                0,                    0,                    100,                        59,             'ABILITY_ATLAS',    'PEDIA_MELEE',         'TXT_KEY_PROMOTION_PRUSSIAN_DISCIPLINE');
    --------------------------------   
    -- UnitPromotions_UnitCombats
    --------------------------------   
    INSERT INTO UnitPromotions_UnitCombats
            (PromotionType, UnitCombatType)
    VALUES    ('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_MELEE'),
            ('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_GUN');   
    --------------------------------   
    -- UnitPromotions_CombatModPerAdjacentUnitCombat
    --------------------------------   
    INSERT INTO UnitPromotions_CombatModPerAdjacentUnitCombat
            (PromotionType, UnitCombatType, Modifier)
    VALUES    ('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_MELEE', 10),
            ('PROMOTION_PRUSSIAN_DISCIPLINE', 'UNITCOMBAT_GUN', 10);
    
    --==========================================================================================================================   
    -- UNITS
    --==========================================================================================================================
    -- Units
    --------------------------------
    -- Deaths Head Hussar is disabled and only gifted by city states, and is now based on the Cuirassier (ie is ranged)
    INSERT INTO Units     
            (Type,                         Class,                        PrereqTech, Combat,        RangedCombat,    Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, Description,                         Civilopedia,                             Strategy,                                     Help,                                     MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, GoodyHutUpgradeUnitClass, CombatLimit, ObsoleteTech,        XPValueDefense, UnitArtInfo,                         UnitFlagIconOffset, UnitFlagAtlas,                        PortraitIndex,     IconAtlas,                MoveRate,    PurchaseCooldown, MinorCivGift)
    SELECT    'UNIT_JFD_DEATHS_HEAD',        'UNITCLASS_DEATHS_HEAD',    PrereqTech, Combat+5,    RangedCombat+5,    Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, Range, CombatClass, Domain, DefaultUnitAI, 'TXT_KEY_UNIT_JFD_DEATHS_HEAD',     'TXT_KEY_CIV5_JFD_DEATHS_HEAD_TEXT',     'TXT_KEY_UNIT_JFD_DEATHS_HEAD_STRATEGY',     'TXT_KEY_UNIT_HELP_JFD_DEATHS_HEAD',     MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, GoodyHutUpgradeUnitClass, CombatLimit, 'TECH_BALLISTICS',    XPValueDefense, 'ART_DEF_UNIT_JFD_DEATHS_HEAD',        0,                    'JFD_UNIT_FLAG_DEATHS_HEAD_ATLAS',    3,                 'JFD_PRUSSIA_ATLAS',    MoveRate,    PurchaseCooldown, 1
    FROM Units WHERE Type = 'UNIT_CUIRASSIER';
    
    INSERT INTO Units     
            (Type,                         Class, PrereqTech, Combat,        Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, CombatClass, Domain, DefaultUnitAI, Description,                         Civilopedia,                             Strategy,                                     Help,                                     MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, CombatLimit, ObsoleteTech,            XPValueDefense, GoodyHutUpgradeUnitClass, UnitArtInfo,                         UnitFlagIconOffset, UnitFlagAtlas,                        PortraitIndex,     IconAtlas,                PurchaseCooldown)
    SELECT    'UNIT_JFD_LANDWEHR',         Class, PrereqTech, Combat+4,    Cost, FaithCost, RequiresFaithPurchaseEnabled, Moves, CombatClass, Domain, DefaultUnitAI, 'TXT_KEY_UNIT_JFD_LANDWEHR',         'TXT_KEY_CIV5_JFD_LANDWEHR_TEXT',         'TXT_KEY_UNIT_JFD_LANDWEHR_STRATEGY',         'TXT_KEY_UNIT_HELP_JFD_LANDWEHR',        MilitarySupport, MilitaryProduction, Pillage, IgnoreBuildingDefense, AdvancedStartCost, CombatLimit, 'TECH_COMBINED_ARMS',    XPValueDefense, GoodyHutUpgradeUnitClass, 'ART_DEF_UNIT_JFD_LANDWEHR',        0,                    'JFD_UNIT_FLAG_LANDWEHR_ATLAS',        2,                 'JFD_PRUSSIA_ATLAS',    PurchaseCooldown
    FROM Units WHERE Type = 'UNIT_RIFLEMAN';
    
    --------------------------------   
    -- UnitGameplay2DScripts
    --------------------------------   
    INSERT INTO UnitGameplay2DScripts     
            (UnitType,                     SelectionSound, FirstSelectionSound)
    SELECT    'UNIT_JFD_DEATHS_HEAD',     SelectionSound, FirstSelectionSound
    FROM UnitGameplay2DScripts WHERE UnitType = 'UNIT_CUIRASSIER';   
        
    INSERT INTO UnitGameplay2DScripts     
            (UnitType,                     SelectionSound, FirstSelectionSound)
    SELECT    'UNIT_JFD_LANDWEHR',         SelectionSound, FirstSelectionSound
    FROM UnitGameplay2DScripts WHERE UnitType = 'UNIT_RIFLEMAN';
    --------------------------------       
    -- Unit_AITypes
    --------------------------------   
    INSERT INTO Unit_AITypes     
            (UnitType,                     UnitAIType)
    SELECT    'UNIT_JFD_DEATHS_HEAD',     UnitAIType
    FROM Unit_AITypes WHERE UnitType = 'UNIT_CUIRASSIER';
        
    INSERT INTO Unit_AITypes     
            (UnitType,                     UnitAIType)
    SELECT    'UNIT_JFD_LANDWEHR',        UnitAIType
    FROM Unit_AITypes WHERE UnitType = 'UNIT_RIFLEMAN';   
    --------------------------------   
    -- Unit_ClassUpgrades
    --------------------------------       
    INSERT INTO Unit_ClassUpgrades     
            (UnitType,                     UnitClassType)
    SELECT    'UNIT_JFD_DEATHS_HEAD',     UnitClassType
    FROM Unit_ClassUpgrades WHERE UnitType = 'UNIT_CUIRASSIER';
    
    INSERT INTO Unit_ClassUpgrades     
            (UnitType,                     UnitClassType)
    SELECT    'UNIT_JFD_LANDWEHR',        UnitClassType
    FROM Unit_ClassUpgrades WHERE UnitType = 'UNIT_RIFLEMAN';
    --------------------------------   
    -- Unit_ResourceQuantityRequirements
    --------------------------------       
    INSERT INTO Unit_ResourceQuantityRequirements     
            (UnitType,                     ResourceType)
    SELECT    'UNIT_JFD_DEATHS_HEAD',     ResourceType
    FROM Unit_ResourceQuantityRequirements WHERE UnitType = 'UNIT_CUIRASSIER';
    --------------------------------   
    -- Unit_Flavors
    --------------------------------   
    INSERT INTO Unit_Flavors     
            (UnitType,                     FlavorType, Flavor)
    SELECT    'UNIT_JFD_DEATHS_HEAD',        FlavorType, Flavor+2
    FROM Unit_Flavors WHERE UnitType = 'UNIT_CUIRASSIER';
    
    INSERT INTO Unit_Flavors     
            (UnitType,                     FlavorType, Flavor)
    SELECT    'UNIT_JFD_LANDWEHR',         FlavorType, Flavor+2
    FROM Unit_Flavors WHERE UnitType = 'UNIT_RIFLEMAN';   
    --------------------------------
    -- Unit_FreePromotions
    --------------------------------   
    INSERT INTO Unit_FreePromotions     
            (UnitType,                     PromotionType)
    SELECT    'UNIT_JFD_DEATHS_HEAD',        PromotionType
    FROM Unit_FreePromotions WHERE UnitType = 'UNIT_CUIRASSIER';
    
    INSERT INTO Unit_FreePromotions
            (UnitType,                     PromotionType)
    VALUES    ('UNIT_JFD_DEATHS_HEAD',     'PROMOTION_JFD_DEATHS_HEAD');
    
    INSERT INTO Unit_FreePromotions
            (UnitType,                     PromotionType)
    SELECT    'UNIT_JFD_LANDWEHR',        PromotionType
    FROM Unit_FreePromotions WHERE UnitType = 'UNIT_RIFLEMAN';
    
    INSERT INTO Unit_FreePromotions -- Landwehr now gets Stalwart
            (UnitType,                 PromotionType)
    VALUES    ('UNIT_JFD_LANDWEHR',     'PROMOTION_DRILL_4');
    
    --==========================================================================================================================   
    -- UNIT CLASS
    --==========================================================================================================================
    -- UnitClasses
    --------------------------------
    INSERT INTO UnitClasses
            (Type, Description, DefaultUnit)
    VALUES     ('UNITCLASS_DEATHS_HEAD', 'TXT_KEY_UNIT_JFD_DEATHS_HEAD', 'UNIT_JFD_DEATHS_HEAD');
    --==========================================================================================================================   
    -- EVENTS
    --==========================================================================================================================
    -- Events (NEW)
    --------------------------------
    INSERT INTO Events
            (Type, EventClass, Description, Help, EventArt, RandomChance, RandomChanceDelta, IsOneShot, NumChoices, RequiredCiv)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR', 'EVENT_CLASS_CIV_SPECIFIC', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_HELP', 'Event_Prussia_PotatoWar.dds', 15, 1, 0, 2, 'CIVILIZATION_JFD_PRUSSIA'),
            ('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'EVENT_CLASS_CIV_SPECIFIC', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_HELP', 'Event_Prussia_Clausewitz.dds', 5, 2, 1, 1, 'CIVILIZATION_JFD_PRUSSIA');
    
    UPDATE Events SET EraScaling = 1, RequiredEra = 'ERA_RENAISSANCE', ObsoleteEra = 'ERA_MODERN', RequiresWar = 1, EventCooldown = 20 WHERE Type = 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR';
    
    UPDATE Events SET RequiredEra = 'ERA_RENAISSANCE' WHERE Type = 'PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ';   
    --------------------------------
    -- Event_MinimumStartYield (NEW)
    --------------------------------
    INSERT INTO Event_MinimumStartYield
            (EventType, YieldType, Yield)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR', 'YIELD_GOLD', 40);
    --------------------------------
    -- EventChoices (NEW)
    --------------------------------
    INSERT INTO EventChoices
            (Type, Description, Help, IsOneShot, EventDuration)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_1', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_1', 0, 15),
            ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_2', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_2', 0, -1),
            ('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_HELP', 0, -1);
    
    UPDATE EventChoices SET EraScaling = 1, YieldBonusAllCities = 1 WHERE Type = 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2';
    --------------------------------
    -- Event_ParentEvents (NEW)
    --------------------------------
    INSERT INTO Event_ParentEvents
            (EventChoiceType, EventType)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR'),
            ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR'),
            ('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ');
    --------------------------------
    -- EventChoice_InstantYield (NEW)
    --------------------------------
    INSERT INTO EventChoice_InstantYield
            (EventChoiceType, YieldType, Yield)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'YIELD_FOOD', -10);
    --------------------------------
    -- EventChoice_EventCostYield (NEW)
    --------------------------------
    INSERT INTO EventChoice_EventCostYield
            (EventChoiceType, YieldType, Yield)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'YIELD_GOLD', 40);
    --------------------------------
    -- EventChoice_MinimumStartYield (NEW)
    --------------------------------
    INSERT INTO EventChoice_MinimumStartYield
            (EventChoiceType, YieldType, Yield)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'YIELD_GOLD', 40);
    --------------------------------
    -- EventChoice_Notification (NEW)
    --------------------------------
    INSERT INTO EventChoice_Notification
            (EventChoiceType, NotificationType, Description, ShortDescription, IsWorldEvent)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'NOTIFICATION_GENERIC', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_1_NOTIFICATION', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_CHOICE_1_S', 0),
            ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'NOTIFICATION_GENERIC', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_OUTCOME_RESULT_2_NOTIFICATION', 'TXT_KEY_JFD_PRUSSIA_POTATO_WAR_CHOICE_2_S', 0),
            ('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'NOTIFICATION_GENERIC', 'TXT_KEY_WORLD_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 'TXT_KEY_PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ', 1);
    --------------------------------
    -- EventChoiceFlavors (NEW)
    --------------------------------
    INSERT INTO EventChoiceFlavors
            (EventChoiceType, FlavorType, Flavor)
    VALUES    ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'FLAVOR_OFFENSE', -5),
            ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_1', 'FLAVOR_DEFENSE', -5),
            ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'FLAVOR_GROWTH', -5),
            ('PLAYER_EVENT_JFD_PRUSSIA_POTATO_WAR_CHOICE_2', 'FLAVOR_GOLD', -5),
            ('PLAYER_EVENT_JFD_PRUSSIA_CLAUSEWITZ_CHOICE_1', 'FLAVOR_MILITARY_TRAINING', 10);
    --==========================================================================================================================   
    -- LEADERS
    --==========================================================================================================================   
    -- Leaders
    --------------------------------           
    INSERT INTO Leaders
            (Type,                         Description,                             Civilopedia,                             CivilopediaTag,                                 ArtDefineTag,                         VictoryCompetitiveness, WonderCompetitiveness,     MinorCivCompetitiveness,     Boldness,     DiploBalance,     WarmongerHate,     DenounceWillingness,     DoFWillingness, Loyalty,     Neediness,     Forgiveness,     Chattiness, Meanness,     IconAtlas,                 PortraitIndex)
    VALUES    ('LEADER_JFD_FREDERICK',     'TXT_KEY_LEADER_JFD_FREDERICK_DESC',     'TXT_KEY_LEADER_JFD_FREDERICK_PEDIA',     'TXT_KEY_CIVILOPEDIA_LEADERS_JFD_FREDERICK',     'Janboruta_Frederick_Scene.xml',    9,                         8,                         6,                             7,             8,                 6,                 4,                         7,                 8,             5,             5,                 4,             3,             'JFD_PRUSSIA_ATLAS',     1);
    
    -- By-pass VP's leader compatibility trigger
    
    UPDATE Leaders SET VictoryCompetitiveness = 9, WonderCompetitiveness = 8, MinorCivCompetitiveness = 6, Boldness = 7, DiploBalance = 8, WarmongerHate = 6, DenounceWillingness = 4, DoFWillingness = 7, Loyalty = 8, Neediness = 5, Forgiveness = 5, Chattiness = 4, Meanness = 3, Personality = 'PERSONALITY_EXPANSIONIST' WHERE Type = 'LEADER_JFD_FREDERICK';
    --------------------------------       
    -- Leader_MajorCivApproachBiases
    --------------------------------                       
    INSERT INTO Leader_MajorCivApproachBiases
            (LeaderType,                 MajorCivApproachType,                 Bias)
    VALUES    ('LEADER_JFD_FREDERICK',     'MAJOR_CIV_APPROACH_WAR',             4),
            ('LEADER_JFD_FREDERICK',     'MAJOR_CIV_APPROACH_HOSTILE',         4),
            ('LEADER_JFD_FREDERICK',     'MAJOR_CIV_APPROACH_DECEPTIVE',     4),
            ('LEADER_JFD_FREDERICK',     'MAJOR_CIV_APPROACH_GUARDED',         4),
            ('LEADER_JFD_FREDERICK',     'MAJOR_CIV_APPROACH_AFRAID',         3),
            ('LEADER_JFD_FREDERICK',     'MAJOR_CIV_APPROACH_FRIENDLY',         8),
            ('LEADER_JFD_FREDERICK',     'MAJOR_CIV_APPROACH_NEUTRAL',         8);
    --------------------------------   
    -- Leader_MajorCivApproachBiases
    --------------------------------                           
    INSERT INTO Leader_MinorCivApproachBiases
            (LeaderType,                 MinorCivApproachType,                 Bias)
    VALUES    ('LEADER_JFD_FREDERICK',     'MINOR_CIV_APPROACH_IGNORE',         6),
            ('LEADER_JFD_FREDERICK',     'MINOR_CIV_APPROACH_FRIENDLY',         6),
            ('LEADER_JFD_FREDERICK',     'MINOR_CIV_APPROACH_PROTECTIVE',     6),
            ('LEADER_JFD_FREDERICK',     'MINOR_CIV_APPROACH_CONQUEST',         5),
            ('LEADER_JFD_FREDERICK',     'MINOR_CIV_APPROACH_BULLY',         4);
    --------------------------------   
    -- Leader_Flavors
    --------------------------------                           
    INSERT INTO Leader_Flavors
            (LeaderType,                 FlavorType,                         Flavor)
    VALUES    ('LEADER_JFD_FREDERICK',     'FLAVOR_OFFENSE',                     9),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_DEFENSE',                     5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_CITY_DEFENSE',                 5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_MILITARY_TRAINING',         9),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_RECON',                     6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_RANGED',                     4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_MOBILE',                     7),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_NAVAL',                     4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_NAVAL_RECON',                 4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_NAVAL_GROWTH',                 4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_NAVAL_TILE_IMPROVEMENT',     4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_AIR',                         5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_EXPANSION',                 7),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_GROWTH',                     6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_TILE_IMPROVEMENT',             6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_INFRASTRUCTURE',             4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_PRODUCTION',                 6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_GOLD',                         6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_SCIENCE',                     5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_CULTURE',                     5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_HAPPINESS',                 6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_GREAT_PEOPLE',                 6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_WONDER',                     6),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_RELIGION',                     4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_DIPLOMACY',                 8),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_SPACESHIP',                 4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_WATER_CONNECTION',             4),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_NUKE',                         2),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_USE_NUKE',                     2),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_ESPIONAGE',                 5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_AIRLIFT',                     2),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_I_TRADE_DESTINATION',         5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_I_TRADE_ORIGIN',             5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_I_SEA_TRADE_ROUTE',         5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_I_LAND_TRADE_ROUTE',         5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_ARCHAEOLOGY',                 5),
            ('LEADER_JFD_FREDERICK',     'FLAVOR_AIR_CARRIER',                 5);
    --------------------------------   
    -- Leader_Traits
    --------------------------------   
    INSERT INTO Leader_Traits
            (LeaderType,                 TraitType)
    VALUES    ('LEADER_JFD_FREDERICK',     'TRAIT_JFD_PRUSSIA');
    --==========================================================================================================================   
    -- TRAITS
    --==========================================================================================================================   
    -- Traits
    --------------------------------   
    INSERT INTO Traits
            (Type,                         Description,                         ShortDescription)
    VALUES    ('TRAIT_JFD_PRUSSIA',         'TXT_KEY_TRAIT_JFD_PRUSSIA',         'TXT_KEY_TRAIT_JFD_PRUSSIA_SHORT');
    --------------------------------
    -- Trait_GoldenAgeFromGreatPersonBirth (NEW)
    --------------------------------
    INSERT INTO Trait_GoldenAgeFromGreatPersonBirth
            (TraitType,             GreatPersonType,         GoldenAgeTurns)
    VALUES    ('TRAIT_JFD_PRUSSIA',     'GREATPERSON_GENERAL',     5);
    --------------------------------
    -- Trait_DomainFreeExperienceModifier (NEW)
    --------------------------------
    INSERT INTO Trait_DomainFreeExperienceModifier
            (TraitType,             DomainType,     Modifier)
    VALUES    ('TRAIT_JFD_PRUSSIA',     'DOMAIN_LAND',     100),
            ('TRAIT_JFD_PRUSSIA',     'DOMAIN_SEA',     100),
            ('TRAIT_JFD_PRUSSIA',     'DOMAIN_AIR',     100);
    --------------------------------
    -- Trait_BuildingClassYieldChanges (NEW)
    --------------------------------
    /*INSERT INTO Trait_BuildingClassYieldChanges
            (TraitType,             BuildingClassType,                     YieldType,                        YieldChange)
    VALUES    ('TRAIT_JFD_PRUSSIA',     'BUILDINGCLASS_BARRACKS',             'YIELD_GREAT_GENERAL_POINTS',    1),
            ('TRAIT_JFD_PRUSSIA',     'BUILDINGCLASS_ARMORY',             'YIELD_GREAT_GENERAL_POINTS',    1),
            ('TRAIT_JFD_PRUSSIA',     'BUILDINGCLASS_MILITARY_ACADEMY',    'YIELD_GREAT_GENERAL_POINTS',    1);*/
    --------------------------------
    -- Trait_CombatModifierOnWar (NEW) (Requires DLL changes, scrapped and stashed for another civ)
    --------------------------------
    /*INSERT INTO Trait_CombatModifierOnWar
            (TraitType,                Modifier,    Turns)
    VALUES    ('TRAIT_JFD_PRUSSIA',    25,            5);*/
    ------------------------------
    -- Policies (NEW)
    ------------------------------
    INSERT INTO Policies
            (Type,                    Description)
    VALUES    ('POLICY_JFD_PRUSSIA',    'TXT_KEY_TRAIT_JFD_PRUSSIA_SHORT');
    ------------------------------
    -- Policy_BuildingClassProductionModifiers (NEW)
    ------------------------------
    INSERT INTO Policy_BuildingClassProductionModifiers
            (PolicyType, BuildingClassType, ProductionModifier)
    VALUES    ('POLICY_JFD_PRUSSIA', 'BUILDINGCLASS_BARRACKS', 50),
            ('POLICY_JFD_PRUSSIA', 'BUILDINGCLASS_ARMORY', 50),
            ('POLICY_JFD_PRUSSIA', 'BUILDINGCLASS_MILITARY_ACADEMY', 50);
    --==========================================================================================================================   
    -- CIVILIZATIONS
    --==========================================================================================================================   
    -- Civilizations
    --------------------------------       
    INSERT INTO Civilizations     
            (Type,                         DerivativeCiv,            Description,                     ShortDescription,                         Adjective,                                 Civilopedia,                         CivilopediaTag,             DefaultPlayerColor,         ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, IconAtlas,                 PortraitIndex,     AlphaIconAtlas,             SoundtrackTag,     MapImage,                         DawnOfManQuote,                         DawnOfManImage)
    SELECT    'CIVILIZATION_JFD_PRUSSIA',    'CIVILIZATION_GERMANY',    'TXT_KEY_CIV_JFD_PRUSSIA_DESC', 'TXT_KEY_CIV_JFD_PRUSSIA_SHORT_DESC',     'TXT_KEY_CIV_JFD_PRUSSIA_ADJECTIVE',     'TXT_KEY_CIV5_JFD_PRUSSIA_TEXT_1',     'TXT_KEY_CIV5_JFD_PRUSSIA', 'PLAYERCOLOR_JFD_PRUSSIA',     ArtDefineTag, ArtStyleType, ArtStyleSuffix, ArtStylePrefix, 'JFD_PRUSSIA_ATLAS',     0,                 'JFD_PRUSSIA_ALPHA_ATLAS',     'Germany',         'Janboruta_MapPrussia512.dds',     'TXT_KEY_CIV5_DOM_JFD_FREDERICK_TEXT',     'Janboruta_Frederick_DOM.dds'
    FROM Civilizations WHERE Type = 'CIVILIZATION_GERMANY';
    --------------------------------   
    -- Civilization_CityNames
    --------------------------------   
    INSERT INTO Civilization_CityNames
            (CivilizationType,                 CityName)
    VALUES    ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_01'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_02'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_03'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_04'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_05'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_06'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_07'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_08'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_09'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_10'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_11'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_12'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_13'),   
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_14'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_15'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_16'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_17'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_18'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_19'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_20'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_21'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_22'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_23'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_24'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_25'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_26'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_27'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_28'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_29'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_30'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_31'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_32'),
            ('CIVILIZATION_JFD_PRUSSIA',    'TXT_KEY_CITY_NAME_JFD_PRUSSIA_33');
    --------------------------------   
    -- Civilization_FreeBuildingClasses
    --------------------------------           
    INSERT INTO Civilization_FreeBuildingClasses
            (CivilizationType,                 BuildingClassType)
    SELECT    'CIVILIZATION_JFD_PRUSSIA',     BuildingClassType
    FROM Civilization_FreeBuildingClasses WHERE CivilizationType = 'CIVILIZATION_GERMANY';
    --------------------------------       
    -- Civilization_FreeTechs
    --------------------------------           
    INSERT INTO Civilization_FreeTechs
            (CivilizationType,                 TechType)
    SELECT    'CIVILIZATION_JFD_PRUSSIA',     TechType
    FROM Civilization_FreeTechs WHERE CivilizationType = 'CIVILIZATION_GERMANY';
    --------------------------------   
    -- Civilization_FreeUnits
    --------------------------------       
    INSERT INTO Civilization_FreeUnits
            (CivilizationType,                 UnitClassType, Count, UnitAIType)
    SELECT    'CIVILIZATION_JFD_PRUSSIA',     UnitClassType, Count, UnitAIType
    FROM Civilization_FreeUnits WHERE CivilizationType = 'CIVILIZATION_GERMANY';
    --------------------------------   
    -- Civilization_Leaders
    --------------------------------       
    INSERT INTO Civilization_Leaders
            (CivilizationType,                 LeaderheadType)
    VALUES    ('CIVILIZATION_JFD_PRUSSIA',     'LEADER_JFD_FREDERICK');   
    --------------------------------   
    -- Civilization_UnitClassOverrides
    --------------------------------       
    INSERT INTO Civilization_UnitClassOverrides
            (CivilizationType,                 UnitClassType,             UnitType)
    VALUES    ('CIVILIZATION_JFD_PRUSSIA',     'UNITCLASS_RIFLEMAN',     'UNIT_JFD_LANDWEHR');
    --------------------------------   
    -- Civilization_BuildingClassOverrides (NEW)
    --------------------------------   
    INSERT INTO Civilization_BuildingClassOverrides
            (CivilizationType,                 BuildingClassType,                     BuildingType)
    VALUES    ('CIVILIZATION_JFD_PRUSSIA',     'BUILDINGCLASS_MILITARY_ACADEMY',     'BUILDING_PRUSSIAN_KRIEGSSCHULE');
    --------------------------------   
    -- Civilization_Religions
    --------------------------------           
    INSERT INTO Civilization_Religions
            (CivilizationType,                 ReligionType)
    SELECT    'CIVILIZATION_JFD_PRUSSIA',     ReligionType           
    FROM Civilization_Religions WHERE CivilizationType = 'CIVILIZATION_GERMANY';   
    --------------------------------   
    -- Civilization_SpyNames
    --------------------------------   
    INSERT INTO Civilization_SpyNames
            (CivilizationType,                 SpyName)
    VALUES    ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_0'),   
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_1'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_2'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_3'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_4'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_5'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_6'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_7'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_8'),
            ('CIVILIZATION_JFD_PRUSSIA',     'TXT_KEY_SPY_NAME_JFD_PRUSSIA_9');
    --==========================================================================================================================
    --==========================================================================================================================
    Re-downloading and re-installing was the first thing I tried. Didn't work.

    If there was something up with my Vox Pop installation, would you be able to tell from the previously posted logs?
     
  10. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    Launch the game with the mod again, then go to the cache folder (same location as the logs folder). Send me your Civ5ModsDatabase.db and Civ5DebugDatabase.db.

    Right now I'm thinking its a mod load order problem, which can be fixed by deleting the cache folder.
     
  11. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
    Deleting the cache did nothing. However, on the subject of load orders, the Vox components are out of order in the list of enabled mods. I don't put much stock in an in-game list, but is that something?

    Databases are bellow.
    https://mega.nz/#!opRGUYRJ
     
  12. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    Your link is asking for a decryption key.

    Out of order sounds weird though, VP should usually be the first few mods because their names start with the open bracket.
     
  13. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
    Last edited: Mar 16, 2018
  14. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    You need to activate the mods first before you copy the cache files, ie click next after selecting all the relevant mods.
     
  15. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
  16. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    I see the problem, one of the database tables is missing in your game. Upgrading to the latest version of VP should fix it. Are you really sure that you're on the 7th February 2018 version? Because if that's the case, I am wrong in my mod description.

    Ok, I dug a bit further in your cache files, and you're definitely using a version older than 3rd January (your Factory has 2 Engineers). Update VP to the latest version.
     
    Last edited: Mar 18, 2018
  17. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
    How can that be? I just re-downloaded it at the start of this fiasco. Is the version from the auto-installer not the latest version?
     
  18. HungryForFood

    HungryForFood Prince

    Joined:
    Oct 4, 2016
    Messages:
    451
    Location:
    Malaysia
    I have no idea. Maybe if you delete all the VP folders before using the installer, it would help.
     
  19. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
    Well. After a lot of tooling around, I found the problem.
    Every version of the Vox installer I can find, including the one from the 11th and the one posted just yesterday, installs the exact same, out-of-date version of the mod. This is also the same, out-of-date version available in the manual installation folder linked too in the Community Patch thread, and after starting a game and looking through the details, the same, out-of-date version of Vox I've been using for ages.
    This is the most baffling modding issue I've ever encountered, in any game.
     
  20. Zakuzelo

    Zakuzelo Chieftain

    Joined:
    Apr 25, 2014
    Messages:
    36
    And naturally, immediately after pretty much giving up, I find the culprit.
    http://steamcommunity.com/sharedfiles/filedetails/?id=689787148&searchtext=community
    See this little ****? I was subscribed to it. Unsubbed, reinstalled Vox with the latest installer, now it works just fine. I have no idea how a subscription to a third party component caused the entire installation to downgrade, but it did. Fine sure whatever!

    Thanks for the help. After all this hassle you can be sure I'll be back with some feedback on the actual Civ, hopefully it's 3/4UCs included, just...not now.
     

Share This Page